To analyze PeopleSoft PeopleCode and SQL traces there is a very nice program available. It is called TraceMagic and can give you an amazing insight in what is happening in PeopleSoft.
SQL
Escalation mail message variables (AWE)
When configuring an Approval Workflow Engine (AWE) transaction there is a possibility to configure mail messages on certain events. For example if you like to send the requester of the transaction an email when the approver doesn’t approve within a certain time frame you can setup an escalation for this.