declare
lv_ret Number;
RESULT Boolean;
lv_msg VARCHAR2(1000);
begin
lv_ret := FND_REQUEST.SUBMIT_REQUEST(application => 'PER', --Relevant application short name
program => 'XX_TICKET_BALANCE', --Your program short Name
description => 'XX TICKET BALANCE', --Any Description
start_time => sysdate, --standard
sub_request => false, --standard
argument1 => '3890', --Relevant Paramter in sequence
argument2 => '01-Jan-2015',
argument3 => NULL,
argument4 => '31-Dec-2015');
dbms_output.put_line('1st Message: '||lv_ret);
FND_MESSAGE.RETRIEVE(MSGOUT => lv_msg);
dbms_output.put_line('2nd Message: ' || lv_msg);
commit;
end;
lv_ret Number;
RESULT Boolean;
lv_msg VARCHAR2(1000);
begin
FND_GLOBAL.APPS_INITIALIZE(FND_GLOBAL.USER_ID, FND_GLOBAL.RESP_ID, FND_GLOBAL.RESP_APPL_ID);
--FND_GLOBAL.Apps_Initialize(1741, 20420, 1);
RESULT := APPS.fnd_request.set_mode (TRUE);lv_ret := FND_REQUEST.SUBMIT_REQUEST(application => 'PER', --Relevant application short name
program => 'XX_TICKET_BALANCE', --Your program short Name
description => 'XX TICKET BALANCE', --Any Description
start_time => sysdate, --standard
sub_request => false, --standard
argument1 => '3890', --Relevant Paramter in sequence
argument2 => '01-Jan-2015',
argument3 => NULL,
argument4 => '31-Dec-2015');
dbms_output.put_line('1st Message: '||lv_ret);
FND_MESSAGE.RETRIEVE(MSGOUT => lv_msg);
dbms_output.put_line('2nd Message: ' || lv_msg);
commit;
end;