DBA Data[Home] [Help]

APPS.POR_AME_APPROVAL_LIST_WF1S dependencies on POR_AME_APPROVAL_LIST_WF1S

Line 1: PACKAGE BODY POR_AME_APPROVAL_LIST_WF1S AS

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');

Line 174: wf_core.context('POR_AME_APPROVAL_LIST_WF1S','setAmeAttributes',l_progress,sqlerrm);

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:

Line 176: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_APPROVAL_LIST_WF1S.setAmeAttributes');

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:

Line 274: wf_core.context('POR_AME_APPROVAL_LIST_WF1S','Is_Ame_For_Approval',l_progress,sqlerrm);

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:

Line 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');

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:

Line 375: wf_core.context('POR_AME_APPROVAL_LIST_WF1S','Is_Ame_For_Rco_Approval',l_progress,sqlerrm);

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:

Line 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');

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:

Line 557: wf_core.context('POR_AME_APPROVAL_LIST_WF1S','Get_Next_Approver',l_progress,sqlerrm);

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;

Line 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');

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;

Line 692: wf_core.context('POR_AME_APPROVAL_LIST_WF1S',

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:

Line 787: wf_core.context('POR_AME_APPROVAL_LIST_WF1S',

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:

Line 890: END POR_AME_APPROVAL_LIST_WF1S;

886:
887: RAISE;
888: END updateApprovalListResponse;
889:
890: END POR_AME_APPROVAL_LIST_WF1S;