537: return 'SUCCESS';
538:
539: exception
540: when others then
541: wf_core.context('ALR_MLR_PKG', 'RESPONSE', l_eventName, l_eventKey,
542: 'Problem encountered when performing ['||step||']');
543: wf_event.SetErrorInfo(p_event, 'ERROR');
544: return 'ERROR';
545: end Response;
555: return (count_var);
556:
557: exception
558: when others then
559: wf_core.context('ALR_MLR_PKG', 'RESPONSE',
560: 'Exception during OpenResponses');
561: raise;
562: end OpenResponses;
563:
582: wf_log_pkg.string(WF_LOG_PKG.level_statement,
583: 'alr.plsql.ALR_MLR_PACKAGE.GetMessageDetails',
584: 'Error, message handle does not exist in db.');
585: end if;
586: wf_core.context('ALR_MLR_PKG', 'RESPONSE',
587: 'Exception during GetMessageDetails');
588: raise;
589:
590: when others then
587: 'Exception during GetMessageDetails');
588: raise;
589:
590: when others then
591: wf_core.context('ALR_MLR_PKG', 'RESPONSE',
592: 'Exception during GetMessageDetails');
593: raise;
594: end GetMessageDetails;
595:
629: CLOSE c_responses_csr;
630:
631: exception
632: when others then
633: wf_core.context('ALR_MLR_PKG', 'RESPONSE',
634: 'Exception during InitResponseVar');
635: raise;
636: end InitResponseVar;
637:
666: CLOSE c_validresp;
667:
668: exception
669: when others then
670: wf_core.context('ALR_MLR_PKG', 'RESPONSE',
671: 'Exception during InitValidResponses');
672: raise;
673: end InitValidResponses;
674:
753: END LOOP;
754:
755: exception
756: when others then
757: wf_core.context('ALR_MLR_PKG', 'RESPONSE',
758: 'Exception during GetRespActions');
759: raise;
760: end GetRespActions;
761:
787: CLOSE c_resp_var_csr;
788:
789: exception
790: when others then
791: wf_core.context('ALR_MLR_PKG', 'RESPONSE',
792: 'Exception during GetOutputValues');
793: raise;
794: end GetOutputValues;
795:
860: end if;
861:
862: exception
863: when others then
864: wf_core.context('ALR_MLR_PKG', 'RESPONSE',
865: 'Exception during SaveRespHistory');
866: if (wf_log_pkg.level_procedure >=
867: fnd_log.g_current_runtime_level) then
868: wf_log_pkg.string(WF_LOG_PKG.level_procedure,
904: end if;
905:
906: exception
907: when others then
908: wf_core.context('ALR_MLR_PKG', 'RESPONSE',
909: 'Exception during SaveResp');
910: raise;
911:
912: end SaveRespVar;
949: END LOOP;
950:
951: exception
952: when others then
953: wf_core.context('ALR_MLR_PKG', 'RESPONSE',
954: 'Exception during SaveOneRespVar');
955: raise;
956: end SaveOneRespVar;
957:
978: success_flag);
979:
980: exception
981: when others then
982: wf_core.context('ALR_MLR_PKG', 'RESPONSE',
983: 'Exception during SaveRespActHistory');
984: raise;
985: end SaveRespActHistory;
986:
998: where message_handle = msg_handle and node_handle=node_handle;
999:
1000: exception
1001: when others then
1002: wf_core.context('ALR_MLR_PKG', 'RESPONSE',
1003: 'Exception during CloseResp');
1004: raise;
1005: end CloseResp;
1006: