DBA Data[Home] [Help]

APPS.PO_WF_PO_VARIANCE_ACC dependencies on PO_WF_PO_VARIANCE_ACC

Line 1: PACKAGE BODY PO_WF_PO_VARIANCE_ACC AS

1: PACKAGE BODY PO_WF_PO_VARIANCE_ACC AS
2: /* $Header: POXWPVAB.pls 120.0 2005/06/01 19:17:58 appldev 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 12: | PL/SQL body for package: PO_WF_PO_VARIANCE_ACC

8: | FILENAME
9: | POXWPVAB.pls
10: |
11: | DESCRIPTION
12: | PL/SQL body for package: PO_WF_PO_VARIANCE_ACC
13: |
14: | NOTES
15: | MODIFIED IMRAN ALI (09/08/97) - Created
16: *=====================================================================*/

Line 32: x_progress := 'PO_WF_PO_VARIANCE_ACC.destination_type: 01';

28: x_progress varchar2(100);
29: x_destination_type varchar2(25);
30: begin
31:
32: x_progress := 'PO_WF_PO_VARIANCE_ACC.destination_type: 01';
33: IF (g_po_wf_debug = 'Y') THEN
34: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
35: END IF;
36:

Line 62: wf_core.context('PO_WF_PO_VARIANCE_ACC','destination_type',x_progress);

58: return;
59:
60: EXCEPTION
61: WHEN OTHERS THEN
62: wf_core.context('PO_WF_PO_VARIANCE_ACC','destination_type',x_progress);
63: raise;
64: end destination_type;
65:
66: -- * ****************************************************************************** *

Line 89: x_progress := 'PO_WF_PO_VARIANCE_ACC.VA_from_org : 01';

85: -- (one time items can be delivered to shopfloor with eam)
86: x_item_id number;
87: begin
88:
89: x_progress := 'PO_WF_PO_VARIANCE_ACC.VA_from_org : 01';
90: IF (g_po_wf_debug = 'Y') THEN
91: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
92: END IF;
93:

Line 160: wf_core.context('PO_WF_PO_VARIANCE_ACC','VA_from_org',x_progress);

156: return;
157:
158: EXCEPTION
159: WHEN OTHERS THEN
160: wf_core.context('PO_WF_PO_VARIANCE_ACC','VA_from_org',x_progress);
161: raise;
162: end VA_from_org;
163:
164: --

Line 222: wf_core.context('PO_WF_PO_VARIANCE_ACC','get_charge_account',x_progress);

218: return;
219:
220: EXCEPTION
221: WHEN OTHERS THEN
222: wf_core.context('PO_WF_PO_VARIANCE_ACC','get_charge_account',x_progress);
223: raise;
224: end get_charge_account;
225:
226:

Line 279: 'PO_WF_PO_VARIANCE_ACC.is_dest_variance_acc_null '||

275: aname => 'DEST_VARIANCE_ACCOUNT_ID');
276:
277: IF (g_po_wf_debug = 'Y') THEN
278: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
279: 'PO_WF_PO_VARIANCE_ACC.is_dest_variance_acc_null '||
280: 'l_dest_variance_account_id='||l_dest_variance_account_id);
281: END IF;
282:
283:

Line 303: 'PO_WF_PO_VARIANCE_ACC.is_dest_variance_acc_null result= '||

299: END IF;
300:
301: IF (g_po_wf_debug = 'Y') THEN
302: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
303: 'PO_WF_PO_VARIANCE_ACC.is_dest_variance_acc_null result= '||
304: result);
305: END IF;
306: EXCEPTION
307: WHEN OTHERS THEN

Line 310: 'PO_WF_PO_VARIANCE_ACC.is_dest_variance_acc_null EXCEPTION at '||

306: EXCEPTION
307: WHEN OTHERS THEN
308: IF (g_po_wf_debug = 'Y') THEN
309: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
310: 'PO_WF_PO_VARIANCE_ACC.is_dest_variance_acc_null EXCEPTION at '||
311: l_progress);
312: END IF;
313: WF_CORE.context('PO_WF_PO_VARIANCE_ACC', 'is_dest_variance_acc_null',
314: l_progress);

Line 313: WF_CORE.context('PO_WF_PO_VARIANCE_ACC', 'is_dest_variance_acc_null',

309: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
310: 'PO_WF_PO_VARIANCE_ACC.is_dest_variance_acc_null EXCEPTION at '||
311: l_progress);
312: END IF;
313: WF_CORE.context('PO_WF_PO_VARIANCE_ACC', 'is_dest_variance_acc_null',
314: l_progress);
315: RAISE;
316: END is_dest_variance_acc_null;
317:

Line 367: 'PO_WF_PO_VARIANCE_ACC.get_destination_charge_account '||

363: aname => 'DEST_CHARGE_ACCOUNT_ID');
364:
365: IF (g_po_wf_debug = 'Y') THEN
366: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
367: 'PO_WF_PO_VARIANCE_ACC.get_destination_charge_account '||
368: 'l_dest_charge_account_id='||l_dest_charge_account_id);
369: END IF;
370:
371: l_progress := '030';

Line 388: 'PO_WF_PO_VARIANCE_ACC.get_destination_charge_account '||

384: END IF;
385:
386: IF (g_po_wf_debug = 'Y') THEN
387: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
388: 'PO_WF_PO_VARIANCE_ACC.get_destination_charge_account '||
389: 'result='||result);
390: END IF;
391: EXCEPTION
392: WHEN OTHERS THEN

Line 395: 'PO_WF_PO_VARIANCE_ACC.get_destination_charge_account EXCEPTION at '||

391: EXCEPTION
392: WHEN OTHERS THEN
393: IF (g_po_wf_debug = 'Y') THEN
394: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
395: 'PO_WF_PO_VARIANCE_ACC.get_destination_charge_account EXCEPTION at '||
396: l_progress);
397: END IF;
398: WF_CORE.context('PO_WF_PO_VARIANCE_ACC', 'get_destination_charge_account',
399: l_progress);

Line 398: WF_CORE.context('PO_WF_PO_VARIANCE_ACC', 'get_destination_charge_account',

394: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
395: 'PO_WF_PO_VARIANCE_ACC.get_destination_charge_account EXCEPTION at '||
396: l_progress);
397: END IF;
398: WF_CORE.context('PO_WF_PO_VARIANCE_ACC', 'get_destination_charge_account',
399: l_progress);
400: RAISE;
401: END get_destination_charge_account;
402:

Line 437: x_progress := 'PO_WF_PO_VARIANCE_ACC.dest_VA_from_org : 01';

433: x_item_id NUMBER;
434:
435: BEGIN
436:
437: x_progress := 'PO_WF_PO_VARIANCE_ACC.dest_VA_from_org : 01';
438:
439: IF (g_po_wf_debug = 'Y') THEN
440: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
441: END IF;

Line 474: x_progress := 'PO_WF_PO_VARIANCE_ACC.dest_VA_from_org : 02';

470: x_account := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,
471: itemkey => itemkey,
472: aname => 'DEST_CHARGE_ACCOUNT_ID');
473:
474: x_progress := 'PO_WF_PO_VARIANCE_ACC.dest_VA_from_org : 02';
475:
476: IF (g_po_wf_debug = 'Y') THEN
477: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
478: END IF;

Line 496: wf_core.context('PO_WF_PO_VARIANCE_ACC','dest_VA_from_org',x_progress);

492: RETURN;
493:
494: EXCEPTION
495: WHEN OTHERS THEN
496: wf_core.context('PO_WF_PO_VARIANCE_ACC','dest_VA_from_org',x_progress);
497: raise;
498: END dest_VA_from_org;
499:
500: --< Shared Proc FPJ End >

Line 502: end PO_WF_PO_VARIANCE_ACC;

498: END dest_VA_from_org;
499:
500: --< Shared Proc FPJ End >
501:
502: end PO_WF_PO_VARIANCE_ACC;