requset sending api [message #462665] |
Fri, 25 June 2010 08:47 |
lokeshsurana
Messages: 212 Registered: April 2010 Location: India
|
Senior Member |
|
|
I hve one custom form on that form I have one command button as
command button press i want interface programm and Import standard program should get execute
For that i written code as....
The Problem is The code is taking to much time to execute.....
what solution need to do....
The Interface program and Standard Import Program is running correctly and data is also fetch in base table.....
But up to to time form get in hang position still PO get not created...
what should i do...so that form get free for next use....and request id get populated...
[Updated on: Sat, 26 June 2010 01:39] Report message to a moderator
|
|
|
|
Re: requset sending api [message #462731 is a reply to message #462723] |
Sat, 26 June 2010 04:32 |
lokeshsurana
Messages: 212 Registered: April 2010 Location: India
|
Senior Member |
|
|
i removed that wait for request code....then also it will taking time ....and some time first standard interface program is running and then interface program what should need to prevent this....
and one more problem generated the similar code of fnd_request i want run on older version...which parameters need to modify for that.....
code is as follows....
/* Formatted on 2010/06/19 13:58 (Formatter Plus v4.8.8) */
DECLARE
l_success NUMBER;
l_phase VARCHAR2 (1000);
l_status VARCHAR2 (1000);
l_dev_phase VARCHAR2 (1000);
l_dev_status VARCHAR2 (1000);
l_message VARCHAR2 (1000);
INTERVAL NUMBER DEFAULT 60;
max_wait NUMBER DEFAULT 0;
m1 BOOLEAN;
BEGIN
fnd_global.apps_initialize (user_id => 1110,
resp_id => 50606,
resp_appl_id => 1
);
l_success :=
fnd_request.submit_request
('FND',
-- Application Short name of the Concurrent Program.
'XX_IMPORT_PO', -- Program Short Name.
'XX_IMPORT_PO', -- Description of the Program.
SYSDATE, -- Submitted date. Always give the SYSDATE.
FALSE -- Always give the FLASE.
--'ALL', -- Passing the Value to the First Parameter of the report.
--1000,
--'N',
--'N',
---'N'
);
COMMIT;
BEGIN
fnd_global.apps_initialize (user_id => 1110,
resp_id => 50599,
resp_appl_id => 7000
);
l_success :=
fnd_request.submit_request
('PO', -- Application Short name of the Concurrent Program.
'POXPOPDOI', -- Program Short Name.
'Import Standard Purchase Orders',
-- Description of the Program.
SYSDATE, -- Submitted date. Always give the SYSDATE.
FALSE, -- Always give the FLASE.
NULL, -- Passing the Value to the First Parameter of the report.
'STANDARD',
NULL,
'N',
NULL,
'INCOMPLETE',
NULL,
NULL,
82,
NULL,
NULL,
NULL,
NULL,
NULL
---'N'
);
COMMIT;
END;
END;
|
|
|