Wednesday 8 November 2017

Returning 'Warning' Status From Host Program

By default, 0 is for success, 1 for warning 2 for error. Where as in Unix both 1 and 2 are returns Error.

By adding below peace of code, we can return Warning status.


##---------------START---------------------------
     # set request status to warning:
           RESULT =`sqlplus -s ${FCP_LOGIN} <<!
      DECLARE
         b_success    BOOLEAN;
         n_session_id NUMBER;
      BEGIN
         fnd_global.initialize( session_id            => n_session_id
                               ,user_id               => NULL
                               ,resp_id               => NULL
                               ,resp_appl_id          => NULL
                               ,security_group_id     => NULL
                               ,site_id               => -1
                               ,login_id              => NULL
                               ,conc_login_id         => NULL
                               ,prog_appl_id          => NULL
                               ,conc_program_id       => NULL
                               ,conc_request_id       => ${4} – Request ID
                               ,conc_priority_request => NULL
                               ,form_id               => NULL
                               ,form_appl_id          => NULL
                               ,conc_process_id       => NULL
                               ,conc_queue_id         => NULL
                               ,queue_appl_id         => NULL
                               ,server_id             => -1
                              );
          b_success := fnd_concurrent.set_completion_status
                        (status  => 'WARNING'
                        ,message => 'See log file for warning details.'
                        );
          COMMIT;
          END;
          /
          exit;
          !`
                  ;;

     ##---------------END-------------------------