eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_WF_PO_CHARGE_ACC dependencies on PO_WF_PO_CHARGE_ACC

Line 1: PACKAGE BODY PO_WF_PO_CHARGE_ACC AS

1: PACKAGE BODY PO_WF_PO_CHARGE_ACC AS
2: /* $Header: POXWPCAB.pls 120.15 2010/11/25 03:39:24 srkotika 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_CHARGE_ACC

Line 39: x_progress := 'PO_WF_PO_CHARGE_ACC.check_destination_type: 01';

35: x_progress varchar2(100);
36: x_destination_type varchar2(25);
37: begin
38:
39: x_progress := 'PO_WF_PO_CHARGE_ACC.check_destination_type: 01';
40: IF (g_po_wf_debug = 'Y') THEN
41: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
42: END IF;
43:

Line 60: dbms_output.put_line ('Procedure PO_WF_PO_CHARGE_ACC.check_destination_type');

56: aname => 'DESTINATION_TYPE_CODE');
57:
58: /* Start DEBUG
59: If (debug_acc_generator_wf) then
60: dbms_output.put_line ('Procedure PO_WF_PO_CHARGE_ACC.check_destination_type');
61: dbms_output.put_line ('DESTINATION_TYPE_CODE: ' || x_destination_type);
62: end if;
63: End DEBUG */
64:

Line 77: wf_core.context('PO_WF_PO_CHARGE_ACC','check_destination_type',x_progress);

73: return;
74:
75: EXCEPTION
76: WHEN OTHERS THEN
77: wf_core.context('PO_WF_PO_CHARGE_ACC','check_destination_type',x_progress);
78:
79: /* Start DEBUG
80: If (debug_acc_generator_wf) then
81: dbms_output.put_line (' --> EXCEPTION <-- in PO_WF_PO_CHARGE_ACC.check_destination_type');

Line 81: dbms_output.put_line (' --> EXCEPTION <-- in PO_WF_PO_CHARGE_ACC.check_destination_type');

77: wf_core.context('PO_WF_PO_CHARGE_ACC','check_destination_type',x_progress);
78:
79: /* Start DEBUG
80: If (debug_acc_generator_wf) then
81: dbms_output.put_line (' --> EXCEPTION <-- in PO_WF_PO_CHARGE_ACC.check_destination_type');
82: end if;
83: End DEBUG */
84:
85: raise;

Line 129: x_debug_stmt := 'PO_WF_PO_CHARGE_ACC.inventory: 01' || x_progress;

125: dummy VARCHAR2(40);
126: ret BOOLEAN;
127: begin
128:
129: x_debug_stmt := 'PO_WF_PO_CHARGE_ACC.inventory: 01' || x_progress;
130: IF (g_po_wf_debug = 'Y') THEN
131: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_debug_stmt);
132: END IF;
133:

Line 158: dbms_output.put_line ('Procedure PO_WF_PO_CHARGE_ACC.inventory');

154: aname => 'DESTINATION_SUBINVENTORY');
155:
156: /* Start DEBUG
157: If (debug_acc_generator_wf) then
158: dbms_output.put_line ('Procedure PO_WF_PO_CHARGE_ACC.inventory');
159: dbms_output.put_line ('DESTINATION_ORGANIZATION_ID: ' || to_char(x_dest_org_id));
160: dbms_output.put_line ('ITEM_ID: ' || to_char(x_item_id));
161: dbms_output.put_line ('DESTINATION_SUBINVENTORY: ' || x_dest_sub_inv);
162: end if;

Line 165: x_debug_stmt := 'PO_WF_PO_CHARGE_ACC.inventory: dest sub inv :' || x_dest_sub_inv;

161: dbms_output.put_line ('DESTINATION_SUBINVENTORY: ' || x_dest_sub_inv);
162: end if;
163: End DEBUG */
164:
165: x_debug_stmt := 'PO_WF_PO_CHARGE_ACC.inventory: dest sub inv :' || x_dest_sub_inv;
166: IF (g_po_wf_debug = 'Y') THEN
167: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_debug_stmt);
168: END IF;
169:

Line 176: x_debug_stmt := 'PO_WF_PO_CHARGE_ACC.inventory: inv item type :' || x_inv_item_type;

172: dbms_output.put_line ('X_INV_ITEM_TYPE:' || x_inv_item_type);
173: end if;
174: End DEBUG */
175:
176: x_debug_stmt := 'PO_WF_PO_CHARGE_ACC.inventory: inv item type :' || x_inv_item_type;
177: IF (g_po_wf_debug = 'Y') THEN
178: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_debug_stmt);
179: END IF;
180:

Line 369: wf_core.context('PO_WF_PO_CHARGE_ACC','inventory',x_progress);

365: RETURN;
366:
367: EXCEPTION
368: WHEN OTHERS THEN
369: wf_core.context('PO_WF_PO_CHARGE_ACC','inventory',x_progress);
370:
371: /* Start DEBUG
372: If (debug_acc_generator_wf) then
373: dbms_output.put_line (' --> EXCEPTION <-- in PO_WF_PO_CHARGE_ACC.inventory');

Line 373: dbms_output.put_line (' --> EXCEPTION <-- in PO_WF_PO_CHARGE_ACC.inventory');

369: wf_core.context('PO_WF_PO_CHARGE_ACC','inventory',x_progress);
370:
371: /* Start DEBUG
372: If (debug_acc_generator_wf) then
373: dbms_output.put_line (' --> EXCEPTION <-- in PO_WF_PO_CHARGE_ACC.inventory');
374: end if;
375: End DEBUG */
376:
377: raise;

Line 395: x_progress := 'PO_WF_PO_CHARGE_ACC.check_inv_item_type: 01';

391: is
392: x_asset_item_flag varchar2(4);
393: x_progress varchar2(200);
394: begin
395: x_progress := 'PO_WF_PO_CHARGE_ACC.check_inv_item_type: 01';
396:
397: select inventory_asset_flag into x_asset_item_flag
398: from mtl_system_items
399: where organization_id = x_dest_org_id

Line 404: dbms_output.put_line ('Procedure PO_WF_PO_CHARGE_ACC.check_inv_item_type');

400: and inventory_item_id = x_item_id;
401:
402: /* Start DEBUG
403: If (debug_acc_generator_wf) then
404: dbms_output.put_line ('Procedure PO_WF_PO_CHARGE_ACC.check_inv_item_type');
405: dbms_output.put_line ('X_ASSET_ITEM_FLAG: ' || x_asset_item_flag);
406: end if;
407: End DEBUG */
408:

Line 420: 'PO_WF_PO_CHARGE_ACC.check_inv_item_type EXCEPTION at '||x_progress

416: WHEN OTHERS THEN
417: -- Bug 3433867: Enhanced exception handling for this function
418: IF (g_po_wf_debug = 'Y') THEN
419: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
420: 'PO_WF_PO_CHARGE_ACC.check_inv_item_type EXCEPTION at '||x_progress
421: ||': '||SQLERRM);
422: END IF;
423: wf_core.context('PO_WF_PO_CHARGE_ACC','check_inv_item_type',x_progress);
424: raise;

Line 423: wf_core.context('PO_WF_PO_CHARGE_ACC','check_inv_item_type',x_progress);

419: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
420: 'PO_WF_PO_CHARGE_ACC.check_inv_item_type EXCEPTION at '||x_progress
421: ||': '||SQLERRM);
422: END IF;
423: wf_core.context('PO_WF_PO_CHARGE_ACC','check_inv_item_type',x_progress);
424: raise;
425: end;
426:
427: --

Line 439: x_progress := 'PO_WF_PO_CHARGE_ACC.check_sub_inv_type: 01';

435: x_asset_inventory number;
436: x_progress varchar2(100);
437: begin
438:
439: x_progress := 'PO_WF_PO_CHARGE_ACC.check_sub_inv_type: 01';
440:
441: select asset_inventory into x_asset_inventory
442: from mtl_secondary_inventories
443: where secondary_inventory_name = x_dest_sub_inv

Line 456: wf_core.context('PO_WF_PO_CHARGE_ACC','check_sub_inv_type',x_progress);

452: end if;
453:
454: EXCEPTION
455: WHEN OTHERS THEN
456: wf_core.context('PO_WF_PO_CHARGE_ACC','check_sub_inv_type',x_progress);
457: raise;
458: end;
459:
460: -- * ****************************************************************************** *

Line 488: x_progress := 'PO_WF_PO_CHARGE_ACC.expense: 01';

484: dummy VARCHAR2(40);
485: ret BOOLEAN;
486: begin
487:
488: x_progress := 'PO_WF_PO_CHARGE_ACC.expense: 01';
489: IF (g_po_wf_debug = 'Y') THEN
490: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
491: END IF;
492:

Line 513: dbms_output.put_line ('Procedure PO_WF_PO_CHARGE_ACC.expense');

509: aname => 'ITEM_ID');
510:
511: /* Start DEBUG
512: If (debug_acc_generator_wf) then
513: dbms_output.put_line ('Procedure PO_WF_PO_CHARGE_ACC.expense');
514: dbms_output.put_line ('DESTINATION_ORGANIZATION_ID: ' || to_char(x_dest_org_id));
515: dbms_output.put_line ('ITEM_ID: ' || to_char(x_item_id));
516: end if;
517: End DEBUG */

Line 579: 'PO_WF_PO_CHARGE_ACC.expense result='||result);

575: result := 'COMPLETE:FAILURE';
576:
577: IF (g_po_wf_debug = 'Y') THEN
578: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
579: 'PO_WF_PO_CHARGE_ACC.expense result='||result);
580: END IF;
581:
582: return;
583: end if;

Line 598: 'PO_WF_PO_CHARGE_ACC.expense x_expense_acc='||x_expense_acc);

594: RETURN;
595:
596: IF (g_po_wf_debug = 'Y') THEN
597: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
598: 'PO_WF_PO_CHARGE_ACC.expense x_expense_acc='||x_expense_acc);
599: END IF;
600:
601: EXCEPTION
602: WHEN OTHERS THEN

Line 603: wf_core.context('PO_WF_PO_CHARGE_ACC','expense',x_progress);

599: END IF;
600:
601: EXCEPTION
602: WHEN OTHERS THEN
603: wf_core.context('PO_WF_PO_CHARGE_ACC','expense',x_progress);
604:
605: /* Start DEBUG
606: If (debug_acc_generator_wf) then
607: dbms_output.put_line (' --> EXCEPTION <-- in PO_WF_PO_CHARGE_ACC.expense');

Line 607: dbms_output.put_line (' --> EXCEPTION <-- in PO_WF_PO_CHARGE_ACC.expense');

603: wf_core.context('PO_WF_PO_CHARGE_ACC','expense',x_progress);
604:
605: /* Start DEBUG
606: If (debug_acc_generator_wf) then
607: dbms_output.put_line (' --> EXCEPTION <-- in PO_WF_PO_CHARGE_ACC.expense');
608: end if;
609: End DEBUG */
610:
611: raise;

Line 630: x_progress := 'PO_WF_PO_CHARGE_ACC.check_type_of_wip: 01';

626: wip_entity_type varchar2(80);
627: x_progress varchar2(100);
628: begin
629:
630: x_progress := 'PO_WF_PO_CHARGE_ACC.check_type_of_wip: 01';
631: IF (g_po_wf_debug = 'Y') THEN
632: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
633: END IF;
634:

Line 650: dbms_output.put_line ('Procedure PO_WF_PO_CHARGE_ACC.check_type_of_wip');

646: itemkey => itemkey,
647: aname => 'WIP_ENTITY_TYPE');
648: /* Start DEBUG
649: If (debug_acc_generator_wf) then
650: dbms_output.put_line ('Procedure PO_WF_PO_CHARGE_ACC.check_type_of_wip');
651: dbms_output.put_line ('WIP_ENTITY_TYPE: ' || wip_entity_type);
652: end if;
653: End DEBUG */
654:

Line 665: wf_core.context('PO_WF_PO_CHARGE_ACC','check_type_of_wip',x_progress);

661: return;
662:
663: EXCEPTION
664: WHEN OTHERS THEN
665: wf_core.context('PO_WF_PO_CHARGE_ACC','check_type_of_wip',x_progress);
666: raise;
667:
668: end check_type_of_wip;
669:

Line 699: x_progress := 'PO_WF_PO_CHARGE_ACC.job_wip: 01';

695: --
696:
697: begin
698:
699: x_progress := 'PO_WF_PO_CHARGE_ACC.job_wip: 01';
700: IF (g_po_wf_debug = 'Y') THEN
701: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
702: END IF;
703:

Line 737: dbms_output.put_line ('Procedure PO_WF_PO_CHARGE_ACC.job_wip');

733: --
734:
735: /* Start DEBUG
736: If (debug_acc_generator_wf) then
737: dbms_output.put_line ('Procedure PO_WF_PO_CHARGE_ACC.job_wip');
738: dbms_output.put_line ('DESTINATION_ORGANIZATION_ID: ' || to_char(x_destination_organization_id));
739: dbms_output.put_line ('BOM_COST_ELEMENT_ID: ' || to_char(x_bom_cost_element_id));
740: dbms_output.put_line ('WIP_ENTITY_ID: ' || to_char(x_wip_entity_id));
741: dbms_output.put_line ('WIP_ENTITY_TYPE: ' || x_wip_entity_type);

Line 930: wf_core.context('PO_WF_PO_CHARGE_ACC','job_wip',x_progress);

926: RETURN;
927:
928: EXCEPTION
929: WHEN OTHERS THEN
930: wf_core.context('PO_WF_PO_CHARGE_ACC','job_wip',x_progress);
931: IF (g_po_wf_debug = 'Y') THEN
932: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, 'EXCEPTION IN PO_WF_PO_CHARGE_ACC.JOB_WIP');
933: END IF;
934: raise;

Line 932: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, 'EXCEPTION IN PO_WF_PO_CHARGE_ACC.JOB_WIP');

928: EXCEPTION
929: WHEN OTHERS THEN
930: wf_core.context('PO_WF_PO_CHARGE_ACC','job_wip',x_progress);
931: IF (g_po_wf_debug = 'Y') THEN
932: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, 'EXCEPTION IN PO_WF_PO_CHARGE_ACC.JOB_WIP');
933: END IF;
934: raise;
935:
936: end job_wip;

Line 958: x_progress := 'PO_WF_PO_CHARGE_ACC.schedule: 01';

954: x_wip_repetitive_schedule_id NUMBER;
955: x_progress varchar2(200);
956: begin
957:
958: x_progress := 'PO_WF_PO_CHARGE_ACC.schedule: 01';
959: IF (g_po_wf_debug = 'Y') THEN
960: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
961: END IF;
962:

Line 995: dbms_output.put_line ('Procedure PO_WF_PO_CHARGE_ACC.Schedule');

991: aname => 'WIP_REPETITIVE_SCHEDULE_ID');
992:
993: /* Start DEBUG
994: If (debug_acc_generator_wf) then
995: dbms_output.put_line ('Procedure PO_WF_PO_CHARGE_ACC.Schedule');
996: dbms_output.put_line ('DESTINATION_ORGANIZATION_ID: ' || to_char(x_destination_organization_id));
997: dbms_output.put_line ('BOM_COST_ELEMENT_ID: ' || to_char(x_bom_cost_element_id));
998: dbms_output.put_line ('WIP_ENTITY_ID: ' || to_char(x_wip_entity_id));
999: dbms_output.put_line ('WIP_ENTITY_TYPE: ' || x_wip_entity_type);

Line 1129: wf_core.context('PO_WF_PO_CHARGE_ACC','schedule',x_progress);

1125: RETURN;
1126:
1127: EXCEPTION
1128: WHEN OTHERS THEN
1129: wf_core.context('PO_WF_PO_CHARGE_ACC','schedule',x_progress);
1130: IF (g_po_wf_debug = 'Y') THEN
1131: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, 'EXCEPTION IN PO_WF_PO_CHARGE_ACC.SCHEDULE');
1132: END IF;
1133: raise;

Line 1131: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, 'EXCEPTION IN PO_WF_PO_CHARGE_ACC.SCHEDULE');

1127: EXCEPTION
1128: WHEN OTHERS THEN
1129: wf_core.context('PO_WF_PO_CHARGE_ACC','schedule',x_progress);
1130: IF (g_po_wf_debug = 'Y') THEN
1131: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, 'EXCEPTION IN PO_WF_PO_CHARGE_ACC.SCHEDULE');
1132: END IF;
1133: raise;
1134:
1135: end schedule;

Line 1160: x_progress := 'PO_WF_PO_CHARGE_ACC.is_encumbrance_on: 01';

1156: l_req_encumbrance_flag VARCHAR2(10);
1157: x_wip_entity_type NUMBER;
1158: begin
1159:
1160: x_progress := 'PO_WF_PO_CHARGE_ACC.is_encumbrance_on: 01';
1161: IF (g_po_wf_debug = 'Y') THEN
1162: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1163: END IF;
1164:

Line 1284: x_progress := 'PO_WF_PO_CHARGE_ACC.is_encumbrance_on: result = ' || result;

1280: else
1281: result := 'COMPLETE:FALSE';
1282: end if;
1283:
1284: x_progress := 'PO_WF_PO_CHARGE_ACC.is_encumbrance_on: result = ' || result;
1285: IF (g_po_wf_debug = 'Y') THEN
1286: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1287: END IF;
1288:

Line 1293: wf_core.context('PO_WF_PO_CHARGE_ACC','is_encumbrace_on',x_progress);

1289: return;
1290:
1291: EXCEPTION
1292: WHEN OTHERS THEN
1293: wf_core.context('PO_WF_PO_CHARGE_ACC','is_encumbrace_on',x_progress);
1294: raise;
1295:
1296: end is_encumbrance_on;
1297:

Line 1423: 'PO_WF_PO_CHARGE_ACC.is_dest_accounts_flow_type result='||result);

1419: END IF;
1420:
1421: IF (g_po_wf_debug = 'Y') THEN
1422: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1423: 'PO_WF_PO_CHARGE_ACC.is_dest_accounts_flow_type result='||result);
1424: END IF;
1425: EXCEPTION
1426: WHEN OTHERS THEN
1427: WF_CORE.context('PO_WF_PO_CHARGE_ACC', 'is_dest_accounts_flow_type',

Line 1427: WF_CORE.context('PO_WF_PO_CHARGE_ACC', 'is_dest_accounts_flow_type',

1423: 'PO_WF_PO_CHARGE_ACC.is_dest_accounts_flow_type result='||result);
1424: END IF;
1425: EXCEPTION
1426: WHEN OTHERS THEN
1427: WF_CORE.context('PO_WF_PO_CHARGE_ACC', 'is_dest_accounts_flow_type',
1428: l_progress);
1429: RAISE;
1430: END is_dest_accounts_flow_type;
1431:

Line 1484: 'PO_WF_PO_CHARGE_ACC.is_SPS_distribution result='||result);

1480: END IF;
1481:
1482: IF (g_po_wf_debug = 'Y') THEN
1483: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1484: 'PO_WF_PO_CHARGE_ACC.is_SPS_distribution result='||result);
1485: END IF;
1486: EXCEPTION
1487: WHEN OTHERS THEN
1488: WF_CORE.context('PO_WF_PO_CHARGE_ACC', 'is_SPS_distribution', l_progress);

Line 1488: WF_CORE.context('PO_WF_PO_CHARGE_ACC', 'is_SPS_distribution', l_progress);

1484: 'PO_WF_PO_CHARGE_ACC.is_SPS_distribution result='||result);
1485: END IF;
1486: EXCEPTION
1487: WHEN OTHERS THEN
1488: WF_CORE.context('PO_WF_PO_CHARGE_ACC', 'is_SPS_distribution', l_progress);
1489: RAISE;
1490: END is_SPS_distribution;
1491:
1492: ---------------------------------------------------------------------------

Line 1928: 'PO_WF_PO_CHARGE_ACC.get_SPS_charge_account result='||result);

1924: l_progress := '160';
1925:
1926: IF (g_po_wf_debug = 'Y') THEN
1927: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1928: 'PO_WF_PO_CHARGE_ACC.get_SPS_charge_account result='||result);
1929: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1930: 'PO_WF_PO_CHARGE_ACC.get_SPS_charge_account l_SPS_charge_account_id='||
1931: l_SPS_charge_account_id);
1932: END IF;

Line 1930: 'PO_WF_PO_CHARGE_ACC.get_SPS_charge_account l_SPS_charge_account_id='||

1926: IF (g_po_wf_debug = 'Y') THEN
1927: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1928: 'PO_WF_PO_CHARGE_ACC.get_SPS_charge_account result='||result);
1929: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1930: 'PO_WF_PO_CHARGE_ACC.get_SPS_charge_account l_SPS_charge_account_id='||
1931: l_SPS_charge_account_id);
1932: END IF;
1933: EXCEPTION
1934: WHEN OTHERS THEN

Line 1937: 'PO_WF_PO_CHARGE_ACC.get_SPS_charge_account EXCEPTION at '|| l_progress);

1933: EXCEPTION
1934: WHEN OTHERS THEN
1935: IF (g_po_wf_debug = 'Y') THEN
1936: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1937: 'PO_WF_PO_CHARGE_ACC.get_SPS_charge_account EXCEPTION at '|| l_progress);
1938: END IF;
1939: WF_CORE.context('PO_WF_PO_CHARGE_ACC', 'get_SPS_charge_account', l_progress);
1940: RAISE;
1941: END get_SPS_charge_account;

Line 1939: WF_CORE.context('PO_WF_PO_CHARGE_ACC', 'get_SPS_charge_account', l_progress);

1935: IF (g_po_wf_debug = 'Y') THEN
1936: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1937: 'PO_WF_PO_CHARGE_ACC.get_SPS_charge_account EXCEPTION at '|| l_progress);
1938: END IF;
1939: WF_CORE.context('PO_WF_PO_CHARGE_ACC', 'get_SPS_charge_account', l_progress);
1940: RAISE;
1941: END get_SPS_charge_account;
1942:
1943: ---------------------------------------------------------------------------

Line 2005: 'PO_WF_PO_CHARGE_ACC.is_dest_charge_acc_null '||

2001: itemkey => itemkey,
2002: aname => 'TEMP_ACCOUNT_ID');
2003:
2004: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2005: 'PO_WF_PO_CHARGE_ACC.is_dest_charge_acc_null '||
2006: 'Copying DestChargeAccId to TEMP_ACCOUNT_ID '||
2007: '(current val = ' || l_temp_acc_id || ') ' ||
2008: 'dest_charge_account_id='||l_dest_charge_account_id);
2009: END IF;

Line 2024: 'PO_WF_PO_CHARGE_ACC.is_dest_charge_acc_null result='||result||

2020: END IF;
2021:
2022: IF (g_po_wf_debug = 'Y') THEN
2023: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2024: 'PO_WF_PO_CHARGE_ACC.is_dest_charge_acc_null result='||result||
2025: ' l_dest_charge_account_id='||l_dest_charge_account_id);
2026: END IF;
2027:
2028: EXCEPTION

Line 2030: WF_CORE.context('PO_WF_PO_CHARGE_ACC', 'is_dest_charge_acc_null',

2026: END IF;
2027:
2028: EXCEPTION
2029: WHEN OTHERS THEN
2030: WF_CORE.context('PO_WF_PO_CHARGE_ACC', 'is_dest_charge_acc_null',
2031: l_progress);
2032: RAISE;
2033: END is_dest_charge_acc_null;
2034:

Line 2116: 'PO_WF_PO_CHARGE_ACC.are_COAs_same result='||result);

2112: END IF;
2113:
2114: IF (g_po_wf_debug = 'Y') THEN
2115: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2116: 'PO_WF_PO_CHARGE_ACC.are_COAs_same result='||result);
2117: END IF;
2118: EXCEPTION
2119: WHEN OTHERS THEN
2120: WF_CORE.context('PO_WF_PO_CHARGE_ACC', 'are_COAs_same',

Line 2120: WF_CORE.context('PO_WF_PO_CHARGE_ACC', 'are_COAs_same',

2116: 'PO_WF_PO_CHARGE_ACC.are_COAs_same result='||result);
2117: END IF;
2118: EXCEPTION
2119: WHEN OTHERS THEN
2120: WF_CORE.context('PO_WF_PO_CHARGE_ACC', 'are_COAs_same',
2121: l_progress);
2122: RAISE;
2123: END are_COAs_same;
2124:

Line 2168: 'PO_WF_PO_CHARGE_ACC.set_null_resp_id: Setting the Responsibility to NULL ');

2164: l_progress := '020';
2165: IF (g_po_wf_debug = 'Y') THEN
2166: PO_WF_DEBUG_PKG.insert_debug(itemtype,
2167: itemkey,
2168: 'PO_WF_PO_CHARGE_ACC.set_null_resp_id: Setting the Responsibility to NULL ');
2169: END IF;
2170: FND_GLOBAL.apps_initialize( user_id => fnd_global.user_id,
2171: resp_id => NULL,
2172: resp_appl_id => fnd_global.resp_appl_id);

Line 2178: WF_CORE.context('PO_WF_PO_CHARGE_ACC','SET_NULL_RESP_ID',l_progress);

2174: */
2175: result := WF_ENGINE.eng_completed || ':Y';
2176: EXCEPTION
2177: WHEN OTHERS THEN
2178: WF_CORE.context('PO_WF_PO_CHARGE_ACC','SET_NULL_RESP_ID',l_progress);
2179: raise;
2180:
2181: END set_null_resp_id;
2182:

Line 2218: 'PO_WF_PO_CHARGE_ACC.reset_resp_id: Setting the Responsibility back to:' || l_resp_id);

2214: l_progress := '020';
2215: IF (g_po_wf_debug = 'Y') THEN
2216: PO_WF_DEBUG_PKG.insert_debug(itemtype,
2217: itemkey,
2218: 'PO_WF_PO_CHARGE_ACC.reset_resp_id: Setting the Responsibility back to:' || l_resp_id);
2219: END IF;
2220: FND_GLOBAL.apps_initialize( user_id => fnd_global.user_id,
2221: resp_id => l_resp_id,
2222: resp_appl_id => fnd_global.resp_appl_id);

Line 2228: WF_CORE.context('PO_WF_PO_CHARGE_ACC','RESET_RESP_ID',l_progress);

2224: */
2225: result := WF_ENGINE.eng_completed || ':Y';
2226: EXCEPTION
2227: WHEN OTHERS THEN
2228: WF_CORE.context('PO_WF_PO_CHARGE_ACC','RESET_RESP_ID',l_progress);
2229: RAISE;
2230: END reset_resp_id;
2231: --Bug4033391 End
2232:

Line 2300: 'PO_WF_PO_CHARGE_ACC.validate_combination: l_flex_status='

2296: aname => 'FND_FLEX_STATUS');
2297:
2298: IF (g_po_wf_debug = 'Y') THEN
2299: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2300: 'PO_WF_PO_CHARGE_ACC.validate_combination: l_flex_status='
2301: ||l_flex_status);
2302: END IF;
2303:
2304: -- Do nothing if FND_FLEX_STATUS is INVALID

Line 2359: 'PO_WF_PO_CHARGE_ACC.validate_combination: l_is_combination_valid is false');

2355:
2356: IF (NOT l_is_combination_valid) THEN
2357: IF (g_po_wf_debug = 'Y') THEN
2358: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2359: 'PO_WF_PO_CHARGE_ACC.validate_combination: l_is_combination_valid is false');
2360: END IF;
2361:
2362: wf_engine.setitemattrtext(itemtype,itemkey,'FND_FLEX_STATUS','INVALID');
2363: wf_engine.setitemattrtext(itemtype,itemkey,'FND_FLEX_MESSAGE',

Line 2374: END PO_WF_PO_CHARGE_ACC;

2370:
2371: result := wf_engine.eng_completed || ':' || wf_engine.eng_null;
2372: END validate_combination;
2373:
2374: END PO_WF_PO_CHARGE_ACC;