Call PLSQL package.function() from shell

OUTPUT_RESPONSE=`sqlplus -s $FCP_LOGIN << EOSQL
!
set term off
set head off
set pages 0
set feedback off
set serveroutput on

declare
retcode NUMBER:=0;
begin
retcode := XXYH_XML_PARSER.PARSE('$SOURCE_CODE', '$l_get_response', $FCP_REQID, $PARENT_REQUEST_ID, '$PROD', '$FEED', '$ACTION','','','','','','','');
dbms_output.put_line(retcode);
end;
/
exit;
!

EOSQL
`

Get Responsibility Name and Resp Application Short Name in Shell

# -----------------------------------------------------
# Get Resp Name
# -----------------------------------------------------

RESP_NAME=`sqlplus -s $FCP_LOGIN << !
set term off
set head off
set pages 0
set feedback off
SELECT RESP.responsibility_name
  FROM fnd_responsibility_vl RESP
      ,fnd_concurrent_requests REQ
 WHERE RESP.responsibility_id = REQ.responsibility_id
   AND REQ.request_id         = $FCP_REQID
   AND rownum = 1
/
!
`

RESP_APPL_SHORT_NAME=`sqlplus -s $FCP_LOGIN << !
set term off
set head off
set pages 0
set feedback off
SELECT FAPP.application_short_name
  FROM fnd_application FAPP
      ,fnd_concurrent_requests REQ
 WHERE FAPP.application_id = REQ.responsibility_application_id
   AND REQ.request_id      = $FCP_REQID
   AND rownum = 1
/
!
`

Trace file details for Concurrent Request

SELECT request_id  request_id, 
      oracle_Process_id Trace_id, 
      req.enable_trace trace_flag, 
      decode(oracle_process_id, null, 'No trace file generated',
      dest.value||'/'||lower(dbnm.value)||'_ora_'||oracle_process_id||'.trc') trace_file_name, 
      prog.user_concurrent_program_name concurrent_program_name, 
      execname.execution_file_name|| execname.subroutine_name executable_name, 
      decode(phase_code,'R','Running') 
      ||'-'||decode(status_code,'R','Normal') concurrent_program_status, 
      ses.sid||','|| ses.serial# SID_serial, 
      ses.module module
from fnd_concurrent_requests req, 

     v$session ses, 

     v$process proc, 
     v$parameter dest, 

     v$parameter dbnm, 

     fnd_concurrent_programs_vl prog, 
     fnd_executables execname 
where req.request_id = 26784178 
and req.oracle_process_id=proc.spid(+) 
and proc.addr = ses.paddr(+) 
and dest.name='user_dump_dest' 
and dbnm.name='db_name' 
and req.concurrent_program_id = prog.concurrent_program_id 
and req.program_application_id = prog.application_id 
and prog.executable_application_id = execname.application_id
and prog.executable_id=execname.executable_id; 

Steps to Enable Audit Trail in Oracle Applications

Steps to Enable Audit Trail in Oracle Applications by Sachin Dixit