1: PACKAGE BODY POR_AME_APPROVAL_LIST_WF1S AS
2: /* $Header: POXAME1B.pls 120.2 2006/03/10 09:38:38 yqian noship $ */
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');
170: EXCEPTION
171: WHEN OTHERS THEN
172: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
173: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
174: wf_core.context('POR_AME_APPROVAL_LIST_WF1S','setAmeAttributes',l_progress,sqlerrm);
175:
176: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_APPROVAL_LIST_WF1S.setAmeAttributes');
177: RAISE;
178:
172: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
173: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
174: wf_core.context('POR_AME_APPROVAL_LIST_WF1S','setAmeAttributes',l_progress,sqlerrm);
175:
176: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_APPROVAL_LIST_WF1S.setAmeAttributes');
177: RAISE;
178:
179: end;
180:
270: EXCEPTION
271: WHEN OTHERS THEN
272: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
273: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
274: wf_core.context('POR_AME_APPROVAL_LIST_WF1S','Is_Ame_For_Approval',l_progress,sqlerrm);
275:
276: 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');
277: RAISE;
278:
272: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
273: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
274: wf_core.context('POR_AME_APPROVAL_LIST_WF1S','Is_Ame_For_Approval',l_progress,sqlerrm);
275:
276: 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');
277: RAISE;
278:
279: END Is_Ame_For_Approval;
280:
371: EXCEPTION
372: WHEN OTHERS THEN
373: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
374: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
375: wf_core.context('POR_AME_APPROVAL_LIST_WF1S','Is_Ame_For_Rco_Approval',l_progress,sqlerrm);
376:
377: 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');
378: RAISE;
379:
373: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
374: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
375: wf_core.context('POR_AME_APPROVAL_LIST_WF1S','Is_Ame_For_Rco_Approval',l_progress,sqlerrm);
376:
377: 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');
378: RAISE;
379:
380: END Is_Ame_For_Rco_Approval;
381:
553: EXCEPTION
554: WHEN OTHERS THEN
555: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
556: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
557: wf_core.context('POR_AME_APPROVAL_LIST_WF1S','Get_Next_Approver',l_progress,sqlerrm);
558:
559: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_APPROVAL_LIST_WF1S.GET_NEXT_APPROVER');
560:
561: RAISE;
555: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
556: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
557: wf_core.context('POR_AME_APPROVAL_LIST_WF1S','Get_Next_Approver',l_progress,sqlerrm);
558:
559: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_APPROVAL_LIST_WF1S.GET_NEXT_APPROVER');
560:
561: RAISE;
562:
563: END Get_Next_Approver;
688: WHEN OTHERS THEN
689:
690: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
691: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
692: wf_core.context('POR_AME_APPROVAL_LIST_WF1S',
693: 'Update_Approval_List_Response',l_progress,sqlerrm);
694:
695: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQAPPRV_PVT.UPDATE_APPROVAL_LIST_RESPONSE');
696:
783: WHEN OTHERS THEN
784:
785: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
786: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
787: wf_core.context('POR_AME_APPROVAL_LIST_WF1S',
788: 'Update_Approval_List_Response',l_progress,sqlerrm);
789:
790: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQAPPRV_PVT.UPDATE_APPROVAL_LIST_RESPONSE');
791:
886:
887: RAISE;
888: END updateApprovalListResponse;
889:
890: END POR_AME_APPROVAL_LIST_WF1S;