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-------------------------