DBA Data[Home] [Help]

APPS.POR_AME_APPROVAL_LIST_WF1S dependencies on POR_AME_APPROVAL_LIST

Line 1: PACKAGE BODY POR_AME_APPROVAL_LIST_WF1S AS

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

Line 130: ame_api2.clearAllApprovals( applicationIdIn => por_ame_approval_list.applicationId ,

126: END IF;
127:
128: BEGIN
129:
130: ame_api2.clearAllApprovals( applicationIdIn => por_ame_approval_list.applicationId ,
131: transactionIdIn => l_document_id,
132: transactionTypeIn => l_transaction_type
133: );
134:

Line 156: por_ame_approval_list.change_first_approver ( pReqHeaderId => l_document_id,

152: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
153: END IF;
154:
155: If ( l_forward_to is not null ) then
156: por_ame_approval_list.change_first_approver ( pReqHeaderId => l_document_id,
157: pPersonId => l_forward_to,
158: pApprovalListStr => l_ApprovalListStr,
159: pApprovalListCount => l_ApprovalListCount,
160: pQuoteChar => l_QuoteChar,

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

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:

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

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:

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

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:

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

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:

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

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:

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

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:

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

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;

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

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;

Line 715: wf_core.context('POR_AME_APPROVAL_LIST_WF1S',

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:

Line 810: wf_core.context('POR_AME_APPROVAL_LIST_WF1S',

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:

Line 995: wf_core.context('POR_AME_APPROVAL_LIST_WF1S',

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:

Line 1006: END POR_AME_APPROVAL_LIST_WF1S;

1002: END SET_FORWARD_RESERVE_APPROVER;
1003:
1004:
1005:
1006: END POR_AME_APPROVAL_LIST_WF1S;