DBA Data[Home] [Help]

APPS.PO_WF_PO_ACCRUAL_ACC dependencies on PO_WF_PO_ACCRUAL_ACC

Line 1: PACKAGE BODY PO_WF_PO_ACCRUAL_ACC AS

1: PACKAGE BODY PO_WF_PO_ACCRUAL_ACC AS
2: /* $Header: POXWPAAB.pls 120.10 2010/10/25 11:38:20 inagdeo 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 12: | PL/SQL body for package: PO_WF_PO_ACCRUAL_ACC

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

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

28: x_progress varchar2(100);
29: x_destination_type varchar2(25);
30: begin
31:
32: x_progress := 'PO_WF_PO_ACCRUAL_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_ACCRUAL_ACC','destination_type',x_progress);

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

Line 96: x_progress := 'PO_WF_PO_ACCRUAL_ACC.AA_from_org : 01';

92: dummy VARCHAR2(40);
93: ret BOOLEAN;
94: begin
95:
96: x_progress := 'PO_WF_PO_ACCRUAL_ACC.AA_from_org : 01';
97: IF (g_po_wf_debug = 'Y') THEN
98: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
99: END IF;
100:

Line 187: wf_core.context('PO_WF_PO_ACCRUAL_ACC','AA_from_org',x_progress);

183: return;
184:
185: EXCEPTION
186: WHEN OTHERS THEN
187: wf_core.context('PO_WF_PO_ACCRUAL_ACC','AA_from_org',x_progress);
188: raise;
189: end AA_from_org;
190:
191: -- * ****************************************************************************** *

Line 217: x_progress := 'PO_WF_PO_ACCRUAL_ACC.AA_for_expense_item: 01';

213: ret BOOLEAN;
214:
215: begin
216:
217: x_progress := 'PO_WF_PO_ACCRUAL_ACC.AA_for_expense_item: 01';
218: IF (g_po_wf_debug = 'Y') THEN
219: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
220: END IF;
221:

Line 297: wf_core.context('PO_WF_PO_ACCRUAL_ACC','AA_for_expense_item',x_progress);

293: RETURN;
294:
295: EXCEPTION
296: WHEN OTHERS THEN
297: wf_core.context('PO_WF_PO_ACCRUAL_ACC','AA_for_expense_item',x_progress);
298: raise;
299:
300: end AA_for_expense_item;
301:

Line 375: 'PO_WF_PO_ACCRUAL_ACC.get_SPS_accrual_account ' ||

371: aname => 'PURCHASING_OU_ID');
372:
373: IF (g_po_wf_debug = 'Y') THEN
374: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
375: 'PO_WF_PO_ACCRUAL_ACC.get_SPS_accrual_account ' ||
376: 'l_purchasing_ou_id='||l_purchasing_ou_id);
377: END IF;
378:
379: --SQL WHAT: Get the Accrual Account for associated with an OU

Line 408: 'PO_WF_PO_ACCRUAL_ACC.get_SPS_accrual_account result='||result);

404: l_progress := '040';
405:
406: IF (g_po_wf_debug = 'Y') THEN
407: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
408: 'PO_WF_PO_ACCRUAL_ACC.get_SPS_accrual_account result='||result);
409: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
410: 'PO_WF_PO_ACCRUAL_ACC.get_SPS_accrual_account l_account_id='||
411: l_account_id);
412: END IF;

Line 410: 'PO_WF_PO_ACCRUAL_ACC.get_SPS_accrual_account l_account_id='||

406: IF (g_po_wf_debug = 'Y') THEN
407: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
408: 'PO_WF_PO_ACCRUAL_ACC.get_SPS_accrual_account result='||result);
409: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
410: 'PO_WF_PO_ACCRUAL_ACC.get_SPS_accrual_account l_account_id='||
411: l_account_id);
412: END IF;
413: EXCEPTION
414: WHEN OTHERS THEN

Line 417: 'PO_WF_PO_ACCRUAL_ACC.get_SPS_accrual_account EXCEPTION at '||

413: EXCEPTION
414: WHEN OTHERS THEN
415: IF (g_po_wf_debug = 'Y') THEN
416: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
417: 'PO_WF_PO_ACCRUAL_ACC.get_SPS_accrual_account EXCEPTION at '||
418: l_progress);
419: END IF;
420: WF_CORE.context('PO_WF_PO_ACCRUAL_ACC', 'get_SPS_accrual_account',
421: l_progress);

Line 420: WF_CORE.context('PO_WF_PO_ACCRUAL_ACC', 'get_SPS_accrual_account',

416: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
417: 'PO_WF_PO_ACCRUAL_ACC.get_SPS_accrual_account EXCEPTION at '||
418: l_progress);
419: END IF;
420: WF_CORE.context('PO_WF_PO_ACCRUAL_ACC', 'get_SPS_accrual_account',
421: l_progress);
422: RAISE;
423: END get_SPS_accrual_account;
424:

Line 465: x_progress := 'PO_WF_PO_ACCRUAL_ACC.fsio_aa_for_expense_item: 01';

461: x_msg_count NUMBER;
462: x_fsio_accrual_account NUMBER;
463:
464: BEGIN
465: x_progress := 'PO_WF_PO_ACCRUAL_ACC.fsio_aa_for_expense_item: 01';
466: IF (g_po_wf_debug = 'Y') THEN
467: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
468: END IF;
469:

Line 479: x_progress := 'PO_WF_PO_ACCRUAL_ACC.fsio_aa_for_expense_item: 02';

475: USING IN itemtype, IN itemkey, OUT x_fsio_accrual_account;
476:
477: END IF;
478:
479: x_progress := 'PO_WF_PO_ACCRUAL_ACC.fsio_aa_for_expense_item: 02';
480: IF (g_po_wf_debug = 'Y') THEN
481: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
482: END IF;
483:

Line 496: wf_core.CONTEXT('PO_WF_PO_ACCRUAL_ACC','FSIO_AA_for_expense_item',

492: result := wf_engine.eng_completed || ':' || wf_engine.eng_null;
493: RETURN;
494: EXCEPTION
495: WHEN OTHERS THEN
496: wf_core.CONTEXT('PO_WF_PO_ACCRUAL_ACC','FSIO_AA_for_expense_item',
497: x_progress);
498: END fsio_aa_for_expense_item;
499:
500: end PO_WF_PO_ACCRUAL_ACC;

Line 500: end PO_WF_PO_ACCRUAL_ACC;

496: wf_core.CONTEXT('PO_WF_PO_ACCRUAL_ACC','FSIO_AA_for_expense_item',
497: x_progress);
498: END fsio_aa_for_expense_item;
499:
500: end PO_WF_PO_ACCRUAL_ACC;