Run Wait For Request Using PLSQL Block in Oracle Apps R12 - Orapoint

Overview: This Script will help you to make process execution to wait for program to be completed and you can implement this script in your PL/SQL package or Procedure in Oracle R12 Application.

IF req_id > 0
          THEN
             LOOP
                --To make process execution to wait for program to complete
                l_req_return_status :=
                   fnd_concurrent.
                    wait_for_request (request_id   =>  req_id,
                                      interval     => 5, --interval Number of seconds to wait between checks
                                      max_wait     => 60, --Maximum number of seconds to wait for the request completion
                                      -- out arguments
                                      phase        => lc_phase,
                                      status       => lc_status,
                                      dev_phase    => lc_dev_phase,
                                      dev_status   => lc_dev_status,
                                      MESSAGE      => lc_message);
EXIT WHEN UPPER (lc_phase) = 'COMPLETED' OR UPPER (lc_status) IN ('CANCELLED', 'ERROR', 'TERMINATED');         
END LOOP;
END IF;