Home » Applications » Oracle Fusion Apps & E-Business Suite » requset sending api (Oracle Application)
requset sending api [message #462665] Fri, 25 June 2010 08:47 Go to next message
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 #462723 is a reply to message #462665] Sat, 26 June 2010 02:46 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
Why did you remove the code?
Anyway, in the code you have used wait for request, which waits till the first program completes.
That's why your code is taking time.

By
Vamsi
Re: requset sending api [message #462731 is a reply to message #462723] Sat, 26 June 2010 04:32 Go to previous message
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;
Previous Topic: Fnd_request.submit_request
Next Topic: Funds
Goto Forum:
  


Current Time: Wed Apr 24 05:43:32 CDT 2024