DBA Data[Home] [Help]

APPS.PO_WF_PO_CHARGE_ACC dependencies on PO_WF_DEBUG_PKG

Line 41: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

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:
44:
45: -- Do nothing in cancel or timeout mode

Line 131: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_debug_stmt);

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:
134:
135: -- Do nothing in cancel or timeout mode

Line 167: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_debug_stmt);

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:
170: /* Start DEBUG
171: If (debug_acc_generator_wf) then

Line 178: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_debug_stmt);

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:
181: x_inv_item_type := check_inv_item_type (itemtype, itemkey, x_dest_org_id, x_item_id);
182:

Line 417: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,

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

Line 488: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

484: begin
485:
486: x_progress := 'PO_WF_PO_CHARGE_ACC.expense: 01';
487: IF (g_po_wf_debug = 'Y') THEN
488: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
489: END IF;
490:
491:
492: -- Do nothing in cancel or timeout mode

Line 572: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,

568: if (success = 'N') then
569: result := 'COMPLETE:FAILURE';
570:
571: IF (g_po_wf_debug = 'Y') THEN
572: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
573: 'PO_WF_PO_CHARGE_ACC.expense result='||result);
574: END IF;
575:
576: return;

Line 591: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,

587: fnd_message.clear;
588: RETURN;
589:
590: IF (g_po_wf_debug = 'Y') THEN
591: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
592: 'PO_WF_PO_CHARGE_ACC.expense x_expense_acc='||x_expense_acc);
593: END IF;
594:
595: EXCEPTION

Line 626: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

622: begin
623:
624: x_progress := 'PO_WF_PO_CHARGE_ACC.check_type_of_wip: 01';
625: IF (g_po_wf_debug = 'Y') THEN
626: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
627: END IF;
628:
629:
630: -- Do nothing in cancel or timeout mode

Line 695: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

691: begin
692:
693: x_progress := 'PO_WF_PO_CHARGE_ACC.job_wip: 01';
694: IF (g_po_wf_debug = 'Y') THEN
695: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
696: END IF;
697:
698: -- Do nothing in cancel or timeout mode
699: --

Line 747: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

743: 'l_category_id' || to_char(l_category_id);
744: --
745:
746: IF (g_po_wf_debug = 'Y') THEN
747: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
748: END IF;
749:
750: --Bug# 1902716 togeorge 07/25/2001
751: --EAM: if entity type in(6,7) get the eam account. This call is

Line 906: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

902: END IF;
903:
904: x_progress := 'WIP_JOB_ACCOUNT is :' || to_char(x_wip_job_account);
905: IF (g_po_wf_debug = 'Y') THEN
906: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
907: END IF;
908:
909: if (x_wip_job_account IS NOT NULL) then
910:

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

922: EXCEPTION
923: WHEN OTHERS THEN
924: wf_core.context('PO_WF_PO_CHARGE_ACC','job_wip',x_progress);
925: IF (g_po_wf_debug = 'Y') THEN
926: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, 'EXCEPTION IN PO_WF_PO_CHARGE_ACC.JOB_WIP');
927: END IF;
928: raise;
929:
930: end job_wip;

Line 954: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

950: begin
951:
952: x_progress := 'PO_WF_PO_CHARGE_ACC.schedule: 01';
953: IF (g_po_wf_debug = 'Y') THEN
954: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
955: END IF;
956:
957:
958: -- Do nothing in cancel or timeout mode

Line 1004: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

1000: 'wip_entity_type' || x_wip_entity_type || 'wip_repetitive_schedule_id' ||
1001: to_char(x_wip_repetitive_schedule_id);
1002:
1003: IF (g_po_wf_debug = 'Y') THEN
1004: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1005: END IF;
1006:
1007:
1008: IF (x_wip_schedule_account IS NULL) THEN

Line 1105: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

1101: END IF;
1102:
1103: x_progress := 'WIP_JOB_ACCOUNT is :' || to_char(x_wip_schedule_account);
1104: IF (g_po_wf_debug = 'Y') THEN
1105: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1106: END IF;
1107:
1108: if (x_wip_schedule_account IS NOT NULL) then
1109:

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

1121: EXCEPTION
1122: WHEN OTHERS THEN
1123: wf_core.context('PO_WF_PO_CHARGE_ACC','schedule',x_progress);
1124: IF (g_po_wf_debug = 'Y') THEN
1125: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, 'EXCEPTION IN PO_WF_PO_CHARGE_ACC.SCHEDULE');
1126: END IF;
1127: raise;
1128:
1129: end schedule;

Line 1155: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

1151: begin
1152:
1153: x_progress := 'PO_WF_PO_CHARGE_ACC.is_encumbrance_on: 01';
1154: IF (g_po_wf_debug = 'Y') THEN
1155: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1156: END IF;
1157:
1158:
1159: -- Do nothing in cancel or timeout mode

Line 1193: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'po_encumbrance_flag='||po_encumbrance_flag||', x_destination_type='||x_destination_type||', l_is_financing_flag='||l_is_financing_flag||', l_is_advance_flag='||l_is_advance_flag);

1189: -- get NULL for these attribute values for requisition case. Set them to 'N'.
1190: -- We do not want to compare the item_type to 'POWFRQAG' (i.e. seeded Req AG WF)
1191: -- because the item_types are not hard-coded and customers may change them.
1192: IF (g_po_wf_debug = 'Y') THEN
1193: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'po_encumbrance_flag='||po_encumbrance_flag||', x_destination_type='||x_destination_type||', l_is_financing_flag='||l_is_financing_flag||', l_is_advance_flag='||l_is_advance_flag);
1194:
1195: -- DEBUG QUERIES: Start
1196: -- As part of bug 5058123, there was another issue related to MOAC setup
1197: -- of MO: Security Profile. The value of PO_ENCUMBRANCE_FLAG was NULL.

Line 1206: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'org_id from PO_MOAC='||PO_MOAC_UTILS_PVT.get_current_org_id||', org_id from PO_GA_PVT='||PO_GA_PVT.get_current_org );

1202: -- I suspect that the values loaded in PO_STARTUP_VALUES are NULL in
1203: -- PO_CORE_S.get_po_parameters() [POXCOC1B.pls]. The following queries should
1204: -- get us moe information.
1205: -- Remove this DEBUG QUERIES block, once the MOAC issue is completely fixed.
1206: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'org_id from PO_MOAC='||PO_MOAC_UTILS_PVT.get_current_org_id||', org_id from PO_GA_PVT='||PO_GA_PVT.get_current_org );
1207: -- Query from: PO_CORE_S.get_po_parameters() [POXCOC1B.pls].
1208: SELECT nvl(fsp.purch_encumbrance_flag,'N'),
1209: nvl(fsp.req_encumbrance_flag,'N')
1210: INTO l_purch_encumbrance_flag,

Line 1219: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'PO_CORE_S: l_purch_encumbrance_flag='||l_purch_encumbrance_flag||', l_req_encumbrance_flag='||l_req_encumbrance_flag);

1215: rcv_parameters rcv
1216: WHERE fsp.set_of_books_id = sob.set_of_books_id
1217: AND rcv.organization_id (+) = fsp.inventory_organization_id;
1218:
1219: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'PO_CORE_S: l_purch_encumbrance_flag='||l_purch_encumbrance_flag||', l_req_encumbrance_flag='||l_req_encumbrance_flag);
1220:
1221: SELECT purch_encumbrance_flag,
1222: req_encumbrance_flag
1223: INTO l_purch_encumbrance_flag,

Line 1227: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'View: l_purch_encumbrance_flag='||l_purch_encumbrance_flag||', l_req_encumbrance_flag='||l_req_encumbrance_flag);

1223: INTO l_purch_encumbrance_flag,
1224: l_req_encumbrance_flag
1225: FROM FINANCIALS_SYSTEM_PARAMETERS; -- view
1226:
1227: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'View: l_purch_encumbrance_flag='||l_purch_encumbrance_flag||', l_req_encumbrance_flag='||l_req_encumbrance_flag);
1228:
1229: SELECT purch_encumbrance_flag,
1230: req_encumbrance_flag
1231: INTO l_purch_encumbrance_flag,

Line 1236: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'Table: MOAC: l_purch_encumbrance_flag='||l_purch_encumbrance_flag||', l_req_encumbrance_flag='||l_req_encumbrance_flag);

1232: l_req_encumbrance_flag
1233: FROM FINANCIALS_SYSTEM_PARAMS_ALL -- table
1234: WHERE org_id = PO_MOAC_UTILS_PVT.get_current_org_id;
1235:
1236: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'Table: MOAC: l_purch_encumbrance_flag='||l_purch_encumbrance_flag||', l_req_encumbrance_flag='||l_req_encumbrance_flag);
1237:
1238: SELECT purch_encumbrance_flag,
1239: req_encumbrance_flag
1240: INTO l_purch_encumbrance_flag,

Line 1245: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'Table: PO_GA_PVT: l_purch_encumbrance_flag='||l_purch_encumbrance_flag||', l_req_encumbrance_flag='||l_req_encumbrance_flag);

1241: l_req_encumbrance_flag
1242: FROM FINANCIALS_SYSTEM_PARAMS_ALL -- table
1243: WHERE org_id = PO_GA_PVT.get_current_org;
1244:
1245: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'Table: PO_GA_PVT: l_purch_encumbrance_flag='||l_purch_encumbrance_flag||', l_req_encumbrance_flag='||l_req_encumbrance_flag);
1246: -- DEBUG QUERIES: End
1247: END IF;
1248:
1249: IF (l_is_financing_flag IS NULL) THEN

Line 1258: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'After: l_is_financing_flag='||l_is_financing_flag||', l_is_advance_flag='||l_is_advance_flag);

1254: l_is_advance_flag := 'N';
1255: END IF;
1256:
1257: IF (g_po_wf_debug = 'Y') THEN
1258: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,'After: l_is_financing_flag='||l_is_financing_flag||', l_is_advance_flag='||l_is_advance_flag);
1259: END IF;
1260: -- Bug 5058123: End
1261:
1262: if (po_encumbrance_flag = 'Y' and x_destination_type <> 'SHOP FLOOR'

Line 1271: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

1267: end if;
1268:
1269: x_progress := 'PO_WF_PO_CHARGE_ACC.is_encumbrance_on: result = ' || result;
1270: IF (g_po_wf_debug = 'Y') THEN
1271: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1272: END IF;
1273:
1274: return;
1275:

Line 1407: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,

1403: result := WF_ENGINE.eng_completed || ':Y';
1404: END IF;
1405:
1406: IF (g_po_wf_debug = 'Y') THEN
1407: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1408: 'PO_WF_PO_CHARGE_ACC.is_dest_accounts_flow_type result='||result);
1409: END IF;
1410: EXCEPTION
1411: WHEN OTHERS THEN

Line 1468: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,

1464: result := WF_ENGINE.eng_completed || ':' || l_is_SPS_distribution;
1465: END IF;
1466:
1467: IF (g_po_wf_debug = 'Y') THEN
1468: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1469: 'PO_WF_PO_CHARGE_ACC.is_SPS_distribution result='||result);
1470: END IF;
1471: EXCEPTION
1472: WHEN OTHERS THEN

Line 1762: PO_WF_DEBUG_PKG.insert_debug(p_itemtype, p_itemkey,

1758: itemkey => p_itemkey,
1759: aname => 'PURCHASING_OU_ID');
1760:
1761: IF (l_temp_ou_id <> l_purchasing_ou_id) THEN
1762: PO_WF_DEBUG_PKG.insert_debug(p_itemtype, p_itemkey,
1763: 'LINV does not belong to POU');
1764: END IF;
1765: EXCEPTION
1766: WHEN OTHERS THEN

Line 1768: PO_WF_DEBUG_PKG.insert_debug(p_itemtype, p_itemkey,

1764: END IF;
1765: EXCEPTION
1766: WHEN OTHERS THEN
1767: -- record and ignore the exception, this is just debug code.
1768: PO_WF_DEBUG_PKG.insert_debug(p_itemtype, p_itemkey,
1769: 'Exception while sanity checking LINV');
1770: END;
1771: END IF; -- IF (g_po_wf_debug = 'Y'), sanity check for LINV
1772: END sanity_check_logical_inv_org;

Line 1912: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,

1908:
1909: l_progress := '160';
1910:
1911: IF (g_po_wf_debug = 'Y') THEN
1912: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1913: 'PO_WF_PO_CHARGE_ACC.get_SPS_charge_account result='||result);
1914: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1915: 'PO_WF_PO_CHARGE_ACC.get_SPS_charge_account l_SPS_charge_account_id='||
1916: l_SPS_charge_account_id);

Line 1914: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,

1910:
1911: IF (g_po_wf_debug = 'Y') THEN
1912: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1913: 'PO_WF_PO_CHARGE_ACC.get_SPS_charge_account result='||result);
1914: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1915: 'PO_WF_PO_CHARGE_ACC.get_SPS_charge_account l_SPS_charge_account_id='||
1916: l_SPS_charge_account_id);
1917: END IF;
1918: EXCEPTION

Line 1921: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,

1917: END IF;
1918: EXCEPTION
1919: WHEN OTHERS THEN
1920: IF (g_po_wf_debug = 'Y') THEN
1921: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1922: 'PO_WF_PO_CHARGE_ACC.get_SPS_charge_account EXCEPTION at '|| l_progress);
1923: END IF;
1924: WF_CORE.context('PO_WF_PO_CHARGE_ACC', 'get_SPS_charge_account', l_progress);
1925: RAISE;

Line 1989: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,

1985: itemtype => itemtype,
1986: itemkey => itemkey,
1987: aname => 'TEMP_ACCOUNT_ID');
1988:
1989: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
1990: 'PO_WF_PO_CHARGE_ACC.is_dest_charge_acc_null '||
1991: 'Copying DestChargeAccId to TEMP_ACCOUNT_ID '||
1992: '(current val = ' || l_temp_acc_id || ') ' ||
1993: 'dest_charge_account_id='||l_dest_charge_account_id);

Line 2008: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,

2004: result := WF_ENGINE.eng_completed || ':N';
2005: END IF;
2006:
2007: IF (g_po_wf_debug = 'Y') THEN
2008: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2009: 'PO_WF_PO_CHARGE_ACC.is_dest_charge_acc_null result='||result||
2010: ' l_dest_charge_account_id='||l_dest_charge_account_id);
2011: END IF;
2012:

Line 2100: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,

2096: result := WF_ENGINE.eng_completed || ':Y';
2097: END IF;
2098:
2099: IF (g_po_wf_debug = 'Y') THEN
2100: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2101: 'PO_WF_PO_CHARGE_ACC.are_COAs_same result='||result);
2102: END IF;
2103: EXCEPTION
2104: WHEN OTHERS THEN

Line 2147: PO_WF_DEBUG_PKG.insert_debug(itemtype,

2143: aname =>'RESPONSIBILITY_ID',
2144: avalue => fnd_global.resp_id);
2145: l_progress := '020';
2146: IF (g_po_wf_debug = 'Y') THEN
2147: PO_WF_DEBUG_PKG.insert_debug(itemtype,
2148: itemkey,
2149: 'PO_WF_PO_CHARGE_ACC.set_null_resp_id: Setting the Responsibility to NULL ');
2150: END IF;
2151: FND_GLOBAL.apps_initialize( user_id => fnd_global.user_id,

Line 2192: PO_WF_DEBUG_PKG.insert_debug(itemtype,

2188: itemkey => itemkey,
2189: aname => 'RESPONSIBILITY_ID');
2190: l_progress := '020';
2191: IF (g_po_wf_debug = 'Y') THEN
2192: PO_WF_DEBUG_PKG.insert_debug(itemtype,
2193: itemkey,
2194: 'PO_WF_PO_CHARGE_ACC.reset_resp_id: Setting the Responsibility back to:' || l_resp_id);
2195: END IF;
2196: FND_GLOBAL.apps_initialize( user_id => fnd_global.user_id,

Line 2270: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,

2266: itemkey => itemkey,
2267: aname => 'FND_FLEX_STATUS');
2268:
2269: IF (g_po_wf_debug = 'Y') THEN
2270: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2271: 'PO_WF_PO_CHARGE_ACC.validate_combination: l_flex_status='
2272: ||l_flex_status);
2273: END IF;
2274:

Line 2312: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,

2308: 'GL_GLOBAL\nDETAIL_POSTING_ALLOWED\nI\nNAME=PO_ALL_POSTING_NA\nY');
2309:
2310: IF (NOT l_is_combination_valid) THEN
2311: IF (g_po_wf_debug = 'Y') THEN
2312: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2313: 'PO_WF_PO_CHARGE_ACC.validate_combination: l_is_combination_valid is false');
2314: END IF;
2315:
2316: wf_engine.setitemattrtext(itemtype,itemkey,'FND_FLEX_STATUS','INVALID');