DBA Data[Home] [Help]

APPS.POR_AME_APPROVAL_LIST dependencies on POR_AME_APPROVAL_LIST

Line 1: PACKAGE BODY por_ame_approval_list AS

1: PACKAGE BODY por_ame_approval_list AS
2: /* $Header: POXAPL2B.pls 120.75.12020000.5 2013/03/19 07:20:45 aacai ship $ */
3:
4:
5: -- Read the profile option that enables/disables the debug log

Line 1592: x_progress := 'POR_AME_APPROVAL_LIST.is_req_pre_approved: 01';

1588: FND_LOG.string(FND_LOG.level_statement, g_module_prefix || l_api_name, 'Entering is_req_pre_approved...');
1589: END IF;
1590: end if;
1591:
1592: x_progress := 'POR_AME_APPROVAL_LIST.is_req_pre_approved: 01';
1593: IF (g_po_wf_debug = 'Y') THEN
1594: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1595: END IF;
1596:

Line 1616: x_progress := 'POR_AME_APPROVAL_LIST.is_req_pre_approved: 02' || ameTransactionType;

1612:
1613: getAmeTransactionType(pReqHeaderId => to_number(l_document_id),
1614: pAmeTransactionType => ameTransactionType);
1615:
1616: x_progress := 'POR_AME_APPROVAL_LIST.is_req_pre_approved: 02' || ameTransactionType;
1617: IF (g_po_wf_debug = 'Y') THEN
1618: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1619: END IF;
1620:

Line 1656: x_progress := 'POR_AME_APPROVAL_LIST.is_req_pre_approved: 02. RESULT= ' || x_resultout;

1652:
1653: resultout := wf_engine.eng_completed || ':' || l_return_val;
1654: x_resultout := l_return_val;
1655:
1656: x_progress := 'POR_AME_APPROVAL_LIST.is_req_pre_approved: 02. RESULT= ' || x_resultout;
1657: IF (g_po_wf_debug = 'Y') THEN
1658: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1659: END IF;
1660:

Line 1675: WF_CORE.context('POR_AME_APPROVAL_LIST' , 'is_req_pre_approved', itemtype, itemkey, x_progress);

1671:
1672: WHEN OTHERS THEN
1673: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1674: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1675: WF_CORE.context('POR_AME_APPROVAL_LIST' , 'is_req_pre_approved', itemtype, itemkey, x_progress);
1676: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_APPROVAL_LIST.is_req_pre_approved');
1677: RAISE;
1678:
1679: END is_req_pre_approved;

Line 1676: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_APPROVAL_LIST.is_req_pre_approved');

1672: WHEN OTHERS THEN
1673: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1674: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1675: WF_CORE.context('POR_AME_APPROVAL_LIST' , 'is_req_pre_approved', itemtype, itemkey, x_progress);
1676: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_APPROVAL_LIST.is_req_pre_approved');
1677: RAISE;
1678:
1679: END is_req_pre_approved;
1680:

Line 3691: WF_CORE.context('POR_AME_APPROVAL_LIST' , 'Clear_ame_apprv_list_reject', itemtype, itemkey,l_progress);

3687: EXCEPTION
3688: WHEN OTHERS THEN
3689: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
3690: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
3691: WF_CORE.context('POR_AME_APPROVAL_LIST' , 'Clear_ame_apprv_list_reject', itemtype, itemkey,l_progress);
3692: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm,
3693: 'POR_AME_APPROVAL_LIST.CLEAR_AME_APPRV_LIST_REJECT');
3694: raise;
3695:

Line 3693: 'POR_AME_APPROVAL_LIST.CLEAR_AME_APPRV_LIST_REJECT');

3689: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
3690: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
3691: WF_CORE.context('POR_AME_APPROVAL_LIST' , 'Clear_ame_apprv_list_reject', itemtype, itemkey,l_progress);
3692: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm,
3693: 'POR_AME_APPROVAL_LIST.CLEAR_AME_APPRV_LIST_REJECT');
3694: raise;
3695:
3696: END Clear_ame_apprv_list_reject;
3697:

Line 3698: END por_ame_approval_list;

3694: raise;
3695:
3696: END Clear_ame_apprv_list_reject;
3697:
3698: END por_ame_approval_list;