Log file for AP Requests in 11i

1.Set the following profile options at your user level

FND: Diagnostics to Yes.
FND: Debug Log Enabled to Yes
FND: Debug Log Level to Statement
FND: Debug Log Mode to Asynchronous with Cross-Tier Sequencing
FND: Debug Log Module to %

2. Run the following to get the log for a specific concurrent request.

undefine v_request_id
set pagesize 9999
set linesize 9999
set trimspool on
set trimout on
spool dbug_log_file.log

Select A.module
, A.session_id
, A. process_id
, A.timestamp
, A.message_text
, A.user_id
, A.transaction_context_id
from fnd_log_messages A
,fnd_log_transaction_context b
Where a.transaction_context_id = b.transaction_context_id
And b.transaction_id in (&v_request_id);


Or Refer Note 198799.1 in metalink