Przed wywołaniem concurrenta trzeba uruchomic:
FND_SUBMIT.ADD_LAYOUT
Modify your PL/SQL procedure to add a line similar to xml_layout:
1. First you must declare the variable
xml_layout boolean;
2. Then you must call the ADD_LAYOUT API prior to submitting your Concurrent Program.
xml_layout := FND_REQUEST.ADD_LAYOUT(’FND’,’FNDSCURS’,’en’,’US’,’PDF’);
req_id := FND_REQUEST.SUBMIT_REQUEST(’FND’,’FNDSCURS’,’FNDSUBMIT – Active Users
XML’);
Note: The easiest way to find out the parameters for the ADD_LAYOUT API is to run the concurrent program from standard submission then check the OPP Manager log for the parameters after a successful submission.
i.e. From $APPLCSF/$APPLLOG/FNDOPP10367.txt
[5/10/05 12:08:13 PM] [10367:RT239207] Starting XML Publisher post-processing action.
[5/10/05 12:08:13 PM] [10367:RT239207]
Template code: FNDSCURS
Template app: FND
Language: en
Territory: US
Output type: PDF
[5/10/05 12:08:14 PM] [10367:RT239207] XML Publisher post-processing action complete.
[5/10/05 12:08:14 PM] [10367:RT239207] Completed post-processing actions for request 239207.
The syntax of the ADD_LAYOUT is as follows:
— Name
— add_layout
— Purpose
— Called before submission to add layout options for request output.
—
— Arguments
— Template_APPL_Name – Template Application Short name.
— Template_code – Template code
— Template_Language – Template File language (iso value)
— Template_Territory – Template File Territory (iso value)
— Output Format – Output Format
—
function add_layout (template_appl_name in varchar2,
template_code in varchar2,
template_language in varchar2,
template_territory in varchar2,
output_format in varchar2) return boolean;
How To Submit A Concurrent Request Set Using FND_SUBMIT.SUBMIT_PROGRAM ( Doc ID 382791.1 )
How to Use FND_REQUEST.ADD_LAYOUT When Submitting a Concurrent Request Via a PL/SQL Procedure? ( Doc ID 308658.1 )