FND_REQUEST.SUBMIT_REQUEST in R12

FND_REQUEST.SUBMIT_REQUEST is an API used to submit a concurrent program in ORACLE Applications.

Parameters:

Application : Short name of the application associated with the concurrent request to be submitted.  

Program - Short name of the concurrent program (not the executable) for which the request should be submitted.  

Description - Description of the request that is displayed in the Concurrent Requests form (Optional.)  

Start_time - Time at which the request should start running, formatted as HH24:MI or HH24:MI:SS (Optional.)  

Sub_request - Set to TRUE if the request is submitted from another request and should be treated as a sub-request.  

Argument1...100 - Arguments for the concurrent request; up to 100 arguments are permitted. If submitted from Oracle Forms, you must specify all 100 arguments.

Example: Submission of Standard Order Import Program

SET SERVEROUTPUT ON ;

DECLARE

     v_request_id                        NUMBER            DEFAULT 0 ;

    

    --Order Import Parameters

    p_operating_unit                     VARCHAR2 ( 20 )     := NULL ;

    p_order_source                       VARCHAR2 ( 20 )     := 'XYZ' ;

    p_orig_sys_document_ref              VARCHAR2 ( 20 )     := NULL ;

    p_operation_code                     VARCHAR2 ( 20 )     := NULL ;

    p_validate_only                      VARCHAR2 ( 20 )     := 'N' ;

    p_debug_level                        VARCHAR2 ( 20 )     := '1' ;

    p_num_instances                      VARCHAR2 ( 20 )     := '4' ;

    p_sold_to_org_id                     VARCHAR2 ( 20 )     := NULL ;

    p_sold_to_org                        VARCHAR2 ( 20 )     := NULL ;

    p_change_sequence                     VARCHAR2 ( 20 )     := NULL ;

    p_perf_param                         VARCHAR2 ( 20 )     := 'Y' ;

    p_rtrim_data                         VARCHAR2 ( 20 )     := 'N' ;

    p_pro_ord_with_null_flag             VARCHAR2 ( 20 )     := 'Y' ;

    p_default_org_id                     VARCHAR2 ( 20 )     := '83' ;

    p_validate_desc_flex                 VARCHAR2 ( 20 )     := 'N' ;

    -- End of Parameters -----

    v_context varchar2 ( 100 );

    FUNCTION set_context ( i_user_name    IN   VARCHAR2

                         , i_resp_name    IN   VARCHAR2

                         , i_org_id       IN   NUMBER )

    RETURNVARCHAR2

    IS

        /* Inorder to reduce the content of the post I moved the implementation part of this function to another post and it is available here */

    END set_context ;

BEGIN

      -- Setting the context ----

      v_context := set_context ( '&V_USER_NAME' , '&V_RESPONSIBILITY' , 82 );

      IF v_context = 'F'

      THEN

        DBMS_OUTPUT . PUT_LINE ( 'Error while setting the context' );        

      ENDIF ;

      DBMS_OUTPUT . PUT_LINE ( 'Submit Order Import Concurrent Program' );

      v_request_id :=   FND_REQUEST . SUBMIT_REQUEST (

               application  =>   'ONT'

              , program      =>   'OEOIMP'

              , description  =>   'Order Import'

              , start_time   =>   SYSDATE

              , sub_request  =>   NULL

              , argument1    =>   p_operating_unit

              , argument2    =>   p_order_source

              , argument3    =>   p_orig_sys_document_ref

              , argument4    =>   p_operation_code

              , argument5    =>   p_validate_only

              , argument6    =>   p_debug_level

              , argument7    =>   p_num_instances

              , argument8    =>   p_sold_to_org_id

              , argument9    =>   p_sold_to_org

              , argument10   =>   p_change_sequence

              , argument11   =>   p_perf_param

              , argument12   =>   p_rtrim_data

              , argument13   =>   p_pro_ord_with_null_flag

              , argument14   =>   p_default_org_id

              , argument15   =>   p_validate_desc_flex

             );

       COMMIT ;

       DBMS_OUTPUT . PUT_LINE ( 'Request_id: ' ||v_request_id );

EXCEPTIONWHENOTHERSTHEN         

       DBMS_OUTPUT . PUT_LINE (SQLCODE || ' Error :' || SQLERRM );

END ;