APPS.PO_REQAPPROVAL_LAUNCH dependencies on PO_REQAPPROVAL_LAUNCH

Line 1: PACKAGE BODY PO_REQAPPROVAL_LAUNCH AS

1: PACKAGE BODY PO_REQAPPROVAL_LAUNCH AS
2: /* $Header: POXWPA5B.pls 120.5 2007/12/11 07:06:47 rakchakr 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 13: | PL/SQL body for package: PO_REQAPPROVAL_LAUNCH

9: | FILENAME
10: | xxx.sql
11: |
12: | DESCRIPTION
13: | PL/SQL body for package: PO_REQAPPROVAL_LAUNCH
14: |
15: | NOTES Ben Chihaoui Created 6/15/97
16: | MODIFIED (MM/DD/YY)
17: *=======================================================================*/

Line 45: -- x_progress := 'PO_REQAPPROVAL_LAUNCH.Launch_CreatePO_WF: 01';

41: l_preparer_user_name varchar2(100);
42:
43: BEGIN
44:
45: -- x_progress := 'PO_REQAPPROVAL_LAUNCH.Launch_CreatePO_WF: 01';
46: -- /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
47:
48:
49: -- Do nothing in cancel or timeout mode

Line 70: WF_CORE.context('PO_REQAPPROVAL_LAUNCH' , 'Launch_CreatePO_WF', itemtype, itemkey,x_progress);

66: EXCEPTION
67: WHEN OTHERS THEN
68: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
69: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
70: WF_CORE.context('PO_REQAPPROVAL_LAUNCH' , 'Launch_CreatePO_WF', itemtype, itemkey,x_progress);
71: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_LAUNCH.LAUNCH_CREATEPO_WF');
72: raise;
73:
74: END Launch_CreatePO_WF;

Line 71: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_LAUNCH.LAUNCH_CREATEPO_WF');

67: WHEN OTHERS THEN
68: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
69: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
70: WF_CORE.context('PO_REQAPPROVAL_LAUNCH' , 'Launch_CreatePO_WF', itemtype, itemkey,x_progress);
71: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_LAUNCH.LAUNCH_CREATEPO_WF');
72: raise;
73:
74: END Launch_CreatePO_WF;
75:

Line 90: x_progress := 'PO_REQAPPROVAL_LAUNCH.LaunchCreatePOWF:01';

86: x_progress varchar2(100);
87:
88: BEGIN
89:
90: x_progress := 'PO_REQAPPROVAL_LAUNCH.LaunchCreatePOWF:01';
91: IF (g_po_wf_debug = 'Y') THEN
92: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
93: END IF;
94:

Line 123: wf_core.context('PO_REQAPPROVAL_LAUNCH','LaunchCreatePOWF',

119:
120: EXCEPTION
121:
122: WHEN OTHERS THEN
123: wf_core.context('PO_REQAPPROVAL_LAUNCH','LaunchCreatePOWF',
124: x_progress);
125: raise;
126:
127:

Line 198: x_progress := 'PO_REQAPPROVAL_LAUNCH.CreateWFInstance:01';

194: PO_MOAC_UTILS_PVT.set_org_context(l_orgid) ; --
195: end if;
196:
197:
198: x_progress := 'PO_REQAPPROVAL_LAUNCH.CreateWFInstance:01';
199: IF (g_po_wf_debug = 'Y') THEN
200: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
201: END IF;
202:

Line 223: x_progress := 'PO_REQAPPROVAL_LAUNCH.CreateWFInstance:02 ItemType=' ||

219: l_ItemKey := to_char(p_requisition_header_id) || '-' || l_dummy;
220:
221:
222:
223: x_progress := 'PO_REQAPPROVAL_LAUNCH.CreateWFInstance:02 ItemType=' ||
224: l_ItemType || ' ItemKey=' || l_ItemKey;
225: IF (g_po_wf_debug = 'Y') THEN
226: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
227: END IF;

Line 253: wf_core.context('PO_REQAPPROVAL_LAUNCH','CreateWFInstance',

249:
250: EXCEPTION
251:
252: WHEN OTHERS THEN
253: wf_core.context('PO_REQAPPROVAL_LAUNCH','CreateWFInstance',
254: x_progress);
255: raise;
256:
257:

Line 528: WF_CORE.context('PO_REQAPPROVAL_LAUNCH',

524: itemkey => p_itemkey,
525: x_progress => 'Exception in Selector');
526: END IF;
527:
528: WF_CORE.context('PO_REQAPPROVAL_LAUNCH',
529: 'POREQ_SELECTOR',
530: p_itemtype,
531: p_itemkey,
532: p_actid,

Line 538: end PO_REQAPPROVAL_LAUNCH;

534: RAISE;
535:
536: END POREQ_SELECTOR;
537:
538: end PO_REQAPPROVAL_LAUNCH;