You absolutely need both. They serve different purposes because transactions provide ACID and advisory locks can be used to provide higher level ordering of application code.