416: result := 'COMPLETE';
417:
418: EXCEPTION
419: WHEN L_API_ERROR then
420: WF_CORE.Raise(l_errmsg_name);
421: WHEN OTHERS THEN
422: WF_CORE.Context('IEX_WF_BAN_STATUS_PUB', 'update_approval_status',
423: itemtype, itemkey, actid, funcmode);
424: RAISE;
418: EXCEPTION
419: WHEN L_API_ERROR then
420: WF_CORE.Raise(l_errmsg_name);
421: WHEN OTHERS THEN
422: WF_CORE.Context('IEX_WF_BAN_STATUS_PUB', 'update_approval_status',
423: itemtype, itemkey, actid, funcmode);
424: RAISE;
425: END update_approval_status;
426:
484: result := 'COMPLETE';
485:
486: EXCEPTION
487: WHEN l_API_ERROR then
488: WF_CORE.Raise(l_errmsg_name);
489: WHEN OTHERS THEN
490: WF_CORE.Context('IEX_WF_BAN_STATUS_PUB', 'update_rejection_status',
491: itemtype, itemkey, actid, funcmode);
492: RAISE;
486: EXCEPTION
487: WHEN l_API_ERROR then
488: WF_CORE.Raise(l_errmsg_name);
489: WHEN OTHERS THEN
490: WF_CORE.Context('IEX_WF_BAN_STATUS_PUB', 'update_rejection_status',
491: itemtype, itemkey, actid, funcmode);
492: RAISE;
493:
494: END update_rejection_status;
724: result := 'COMPLETE';
725:
726: EXCEPTION
727: WHEN l_API_ERROR then
728: WF_CORE.Raise(l_errmsg_name);
729: WHEN OTHERS THEN
730: WF_CORE.Context('IEX_WF_BAN_STATUS_PUB', 'set_no_contact_in_TCA',
731: itemtype, itemkey, actid, funcmode);
732: RAISE;
726: EXCEPTION
727: WHEN l_API_ERROR then
728: WF_CORE.Raise(l_errmsg_name);
729: WHEN OTHERS THEN
730: WF_CORE.Context('IEX_WF_BAN_STATUS_PUB', 'set_no_contact_in_TCA',
731: itemtype, itemkey, actid, funcmode);
732: RAISE;
733:
734: END set_no_contact_in_tca;
775: END IF;
776:
777: EXCEPTION
778: WHEN l_API_ERROR then
779: WF_CORE.Raise(l_errmsg_name);
780: WHEN OTHERS THEN
781: WF_CORE.Context('IEX_WF_BAN_STATUS_PUB', 'Create_Strategy',
782: itemtype, itemkey, actid, funcmode);
783: RAISE;
777: EXCEPTION
778: WHEN l_API_ERROR then
779: WF_CORE.Raise(l_errmsg_name);
780: WHEN OTHERS THEN
781: WF_CORE.Context('IEX_WF_BAN_STATUS_PUB', 'Create_Strategy',
782: itemtype, itemkey, actid, funcmode);
783: RAISE;
784:
785: END turnoff_collection_profile;
964: result := 'COMPLETE';
965:
966: EXCEPTION
967: WHEN L_API_ERROR then
968: WF_CORE.Raise(l_errmsg_name);
969: WHEN OTHERS THEN
970: WF_CORE.Context('IEX_WF_BAN_STATUS_PUB', 'turnoff Bankrupt Collections',
971: itemtype, itemkey, actid, funcmode);
972: RAISE;
966: EXCEPTION
967: WHEN L_API_ERROR then
968: WF_CORE.Raise(l_errmsg_name);
969: WHEN OTHERS THEN
970: WF_CORE.Context('IEX_WF_BAN_STATUS_PUB', 'turnoff Bankrupt Collections',
971: itemtype, itemkey, actid, funcmode);
972: RAISE;
973:
974: END turnoff_collections;
1156: result := 'COMPLETE';
1157:
1158: EXCEPTION
1159: WHEN L_API_ERROR then
1160: WF_CORE.Raise(l_errmsg_name);
1161: WHEN OTHERS THEN
1162: WF_CORE.Context('IEX_WF_BAN_STATUS_PUB', 'turnoff Bankrupt Collections',
1163: itemtype, itemkey, actid, funcmode);
1164: RAISE;
1158: EXCEPTION
1159: WHEN L_API_ERROR then
1160: WF_CORE.Raise(l_errmsg_name);
1161: WHEN OTHERS THEN
1162: WF_CORE.Context('IEX_WF_BAN_STATUS_PUB', 'turnoff Bankrupt Collections',
1163: itemtype, itemkey, actid, funcmode);
1164: RAISE;
1165:
1166: END no_turnoff_collections;