Date: 29 Jul 99 14:57:48 EDT
From: SUNIL SHARMA sunil-k-sharma@usa.net
To: oraapps-l@cpa.qc.ca
Subject: FND_REQUEST.SUBMIT_REQUEST
Message-ID: 19990729185748.17661.qmail@aw162.netaddress.usa.net

Hi all,


my pl*sql is this

******************

SET FEEDBACK OFF
SET SERVEROUTPUT ON
VARIABLE  message VARCHAR2(240);
DECLARE
     l_request_id   NUMBER;
     l_dev_phase    VARCHAR2(100);
     l_phase        VARCHAR2(100);
     l_status       VARCHAR2(100);
     l_dev_status   VARCHAR2(100);
     l_message      VARCHAR2(240);
     l_wait         BOOLEAN;
     l_print        BOOLEAN;
     l_date         date;
BEGIN
     dbms_output.enable(999999);
     select sysdate  =

     into l_date from dual;
     l_print  :=3D APPS.FND_REQUEST.SET_PRINT_OPTIONS ( 'is_hp','LANDSCAP=
E - 180
columns',
                                                       0,TRUE,'N');
     l_request_id :=3D APPS.FND_REQUEST.SUBMIT_REQUEST(
                          'USADWIP' ,
                          'WIPDJDTL' ,
                          null ,
                          null ,
                          FALSE ,
                          null,    -- 1st argument
                          101 ,
                          null ,
                          null ,
                          null ,
                          null ,
                          null ,
                          null ,
                          null ,
                          null ,
                          l_date,
                          l_date ) ;
/*                          null ,
                          null ,
                          null ,
                          null ,
                          null ,
                          null ,
                          null ,
                          null ,    --   20th argument        =

                          null ,
                          null ,
                          null ,
                          null ,
                          null ,
                          null ,
                          null ,
                          null ,
                          null ,
                          null ,    --   30th argument        =

                          null ,
                          null ,
                          null ,
                          null ,
                          null ,
                          null ,
                          null ,
                          null ,
                          null ,
                          null ,    --   40th argument        =

                          null ,
                          null ,
                          null ,
                          null ,
                          null ,
                          null ,
                          null ,
                          null ,
                          null ,
                          null ,    --   50th argument        =

                          null ,
                          null ,
                          null ,
                          null ,
                          null ,
                          null ,
                          null ,
                          null ,
                          null ,
                          null ,    --   60th argument        =

                          null ,
                          null ,
                          null ,
                          null ,
                          null ,
                          null ,
                          null ,
                          null ,
                          null ,
                          null ,    --   70th argument        =

                          null ,
                          null ,
                          null ,
                          null ,
                          null ,
                          null ,
                          null ,
                          null ,
                          null ,
                          null ,    --   80th argument        =

                          null ,
                          null ,
                          null ,
                          null ,
                          null ,
                          null ,
                          null ,
                          null ,
                          null ,
                          null ,    --   90th argument        =

                          null ,
                          null ,
                          null ,
                          null ,
                          null ,
                          null ,
                          null ,
                          null ,
                          null ,
                          null  );   --   100th argument        */
      COMMIT ;
      dbms_output.put_line('The request id returned is ' ||
TO_CHAR(l_request_id ));
      IF  l_request_id  !=3D 0 THEN   =

          l_dev_phase  :=3D 'INITIAL' ;
          WHILE l_dev_phase  !=3D 'COMPLETE'  LOOP
                l_wait  :=3D
APPS.FND_CONCURRENT.WAIT_FOR_REQUEST(l_request_id,10, 500,
                            l_phase , l_status , l_dev_phase, l_dev_statu=
s
,l_message );
                EXIT WHEN l_dev_phase  =3D 'COMPLETE' ;
          END LOOP ;
--        IF l_dev_phase =3D 'COMPLETE' and l_dev_status =3D 'NORMAL' THE=
N
--           SUBMIT next request ;
--        END IF;  =

      ELSE
          FND_MESSAGE.RETRIEVE(:message );
      END IF ;
END ;
/
select :message from dual ;

*******************

pls help me to short out this problem.

TIA

sunil