1: PACKAGE BODY POR_AME_APPROVAL_LIST_WF1S AS
2: /* $Header: POXAME1B.pls 120.4 2011/05/24 13:16:41 rojain ship $ */
3:
4: -- Read the profile option that enables/disables the debug log
5: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');
193: EXCEPTION
194: WHEN OTHERS THEN
195: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
196: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
197: wf_core.context('POR_AME_APPROVAL_LIST_WF1S','setAmeAttributes',l_progress,sqlerrm);
198:
199: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_APPROVAL_LIST_WF1S.setAmeAttributes');
200: RAISE;
201:
195: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
196: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
197: wf_core.context('POR_AME_APPROVAL_LIST_WF1S','setAmeAttributes',l_progress,sqlerrm);
198:
199: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_APPROVAL_LIST_WF1S.setAmeAttributes');
200: RAISE;
201:
202: end;
203:
293: EXCEPTION
294: WHEN OTHERS THEN
295: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
296: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
297: wf_core.context('POR_AME_APPROVAL_LIST_WF1S','Is_Ame_For_Approval',l_progress,sqlerrm);
298:
299: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_APPROVAL_LIST_WF1S.Is_Ame_For_Approval');
300: RAISE;
301:
295: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
296: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
297: wf_core.context('POR_AME_APPROVAL_LIST_WF1S','Is_Ame_For_Approval',l_progress,sqlerrm);
298:
299: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_APPROVAL_LIST_WF1S.Is_Ame_For_Approval');
300: RAISE;
301:
302: END Is_Ame_For_Approval;
303:
394: EXCEPTION
395: WHEN OTHERS THEN
396: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
397: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
398: wf_core.context('POR_AME_APPROVAL_LIST_WF1S','Is_Ame_For_Rco_Approval',l_progress,sqlerrm);
399:
400: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_APPROVAL_LIST_WF1S.Is_Ame_For_Rco_Approval');
401: RAISE;
402:
396: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
397: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
398: wf_core.context('POR_AME_APPROVAL_LIST_WF1S','Is_Ame_For_Rco_Approval',l_progress,sqlerrm);
399:
400: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_APPROVAL_LIST_WF1S.Is_Ame_For_Rco_Approval');
401: RAISE;
402:
403: END Is_Ame_For_Rco_Approval;
404:
576: EXCEPTION
577: WHEN OTHERS THEN
578: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
579: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
580: wf_core.context('POR_AME_APPROVAL_LIST_WF1S','Get_Next_Approver',l_progress,sqlerrm);
581:
582: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_APPROVAL_LIST_WF1S.GET_NEXT_APPROVER');
583:
584: RAISE;
578: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
579: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
580: wf_core.context('POR_AME_APPROVAL_LIST_WF1S','Get_Next_Approver',l_progress,sqlerrm);
581:
582: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_APPROVAL_LIST_WF1S.GET_NEXT_APPROVER');
583:
584: RAISE;
585:
586: END Get_Next_Approver;
711: WHEN OTHERS THEN
712:
713: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
714: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
715: wf_core.context('POR_AME_APPROVAL_LIST_WF1S',
716: 'Update_Approval_List_Response',l_progress,sqlerrm);
717:
718: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQAPPRV_PVT.UPDATE_APPROVAL_LIST_RESPONSE');
719:
806: WHEN OTHERS THEN
807:
808: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
809: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
810: wf_core.context('POR_AME_APPROVAL_LIST_WF1S',
811: 'Update_Approval_List_Response',l_progress,sqlerrm);
812:
813: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQAPPRV_PVT.UPDATE_APPROVAL_LIST_RESPONSE');
814:
991: WHEN OTHERS THEN
992:
993: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
994: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
995: wf_core.context('POR_AME_APPROVAL_LIST_WF1S',
996: 'SET_FORWARD_RESERVE_APPROVER',l_progress,sqlerrm);
997:
998: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQAPPRV_PVT.SET_FORWARD_RESERVE_APPROVER');
999:
1002: END SET_FORWARD_RESERVE_APPROVER;
1003:
1004:
1005:
1006: END POR_AME_APPROVAL_LIST_WF1S;