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_REQCHANGEREQUESTWF_PVT dependencies on PO_WF_DEBUG_PKG

Line 436: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

432: FROM po_system_parameters;
433:
434: l_progress := 'getReqAmountInfo:' || l_rate_type;
435: IF (g_po_wf_debug = 'Y') THEN
436: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
437: END IF;
438:
439: l_approver_user_name := PO_WF_UTIL_PKG.GetItemAttrText(itemtype=>itemtype,
440: itemkey=>itemkey,

Line 450: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

446: WHERE user_name = l_approver_user_name;
447:
448: l_progress := 'getReqAmountInfo:' || l_user_id;
449: IF (g_po_wf_debug = 'Y') THEN
450: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
451: END IF;
452:
453: l_approval_currency := FND_PROFILE.VALUE_SPECIFIC('ICX_PREFERRED_CURRENCY', l_user_id);
454: end if;

Line 466: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

462: end if;
463:
464: l_progress := 'getReqAmountInfo:' || l_approval_currency;
465: IF (g_po_wf_debug = 'Y') THEN
466: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
467: END IF;
468:
469: gl_currency_api.get_closest_triangulation_rate(
470: x_from_currency => p_function_currency,

Line 483: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

479:
480: l_progress := 'getReqAmountInfo:' || substrb(to_char(l_rate), 1, 30);
481:
482: IF (g_po_wf_debug = 'Y') THEN
483: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
484: END IF;
485:
486: /* setting amount for notification subject */
487: l_amount_approval_currency := (p_total_amount/l_denominator_rate) * l_numerator_rate;

Line 501: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

497: FND_CURRENCY.GET_FORMAT_MASK(l_approval_currency,g_currency_format_mask));
498:
499: l_progress := 'getReqAmountInfo:' || l_amount_disp;
500: IF (g_po_wf_debug = 'Y') THEN
501: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
502: END IF;
503:
504: x_amount_for_header := p_req_amount_disp || ' ' || p_function_currency;
505: x_amount_for_header := x_amount_for_header || ' (' || l_amount_disp || ' ' || l_approval_currency || ')';

Line 520: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

516: when gl_currency_api.no_rate then
517: l_progress := 'getReqAmountInfo: no rate';
518:
519: IF (g_po_wf_debug = 'Y') THEN
520: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
521: END IF;
522: x_amount_for_subject := p_total_amount_disp || ' ' || p_function_currency;
523:
524: l_no_rate_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_NO_RATE');

Line 538: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);

534:
535: l_progress := 'getReqAmountInfo:' || substrb(SQLERRM, 1,200);
536:
537: IF (g_po_wf_debug = 'Y') THEN
538: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
539: END IF;
540: x_amount_for_subject := p_total_amount_disp || ' ' || p_function_currency;
541: x_amount_for_header := p_req_amount_disp || ' ' || p_function_currency;
542: x_amount_for_tax := p_tax_amount_disp || ' ' || p_function_currency;

Line 5940: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, 'Entering Update_Action_History_App_Rej...' );

5936: BEGIN
5937: l_progress := 'Update_Action_History_App_Rej: 001';
5938:
5939: IF (g_po_wf_debug = 'Y') THEN
5940: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, 'Entering Update_Action_History_App_Rej...' );
5941: END IF;
5942:
5943: IF (funcmode='RUN') THEN
5944:

Line 5984: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, ' l_action_code = ' || l_action_code );

5980: and object_type_code='REQUISITION'
5981: and sequence_num=l_sequence_num;
5982:
5983: IF (g_po_wf_debug = 'Y') THEN
5984: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, ' l_action_code = ' || l_action_code );
5985: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, ' l_sequence_num = ' || l_sequence_num );
5986: END IF;
5987:
5988: if (l_action_code is null OR l_action_code = 'SUBMIT CHANGE') then

Line 5985: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, ' l_sequence_num = ' || l_sequence_num );

5981: and sequence_num=l_sequence_num;
5982:
5983: IF (g_po_wf_debug = 'Y') THEN
5984: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, ' l_action_code = ' || l_action_code );
5985: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, ' l_sequence_num = ' || l_sequence_num );
5986: END IF;
5987:
5988: if (l_action_code is null OR l_action_code = 'SUBMIT CHANGE') then
5989: open l_approved_change_request_csr(l_change_request_group_id);

Line 6017: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, ' l_new_action_code = ' || l_new_action_code );

6013:
6014: close l_approved_change_request_csr;
6015:
6016: IF (g_po_wf_debug = 'Y') THEN
6017: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, ' l_new_action_code = ' || l_new_action_code );
6018: END IF;
6019:
6020: if (l_action_code = 'SUBMIT CHANGE') then
6021: Insert_Action_History(l_document_id,

Line 6042: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, 'Leaving Update_Action_History_App_Rej...');

6038:
6039: l_progress := 'Update_Action_History_App_Rej: 006';
6040:
6041: IF (g_po_wf_debug = 'Y') THEN
6042: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, 'Leaving Update_Action_History_App_Rej...');
6043: END IF;
6044:
6045: resultout:='COMPLETE' || ':' || 'ACTIVITY_PERFORMED';
6046: return;

Line 8070: PO_WF_DEBUG_PKG.insert_debug(l_req_item_type, l_req_item_key, x_progress );

8066:
8067: x_progress := 'PO_ReqChangeRequestWF_PVT.Get_Total_Amount_Currency: 04.1';
8068:
8069: IF (g_po_wf_debug = 'Y') THEN
8070: PO_WF_DEBUG_PKG.insert_debug(l_req_item_type, l_req_item_key, x_progress );
8071: END IF;
8072:
8073:
8074: IF (lv_tax_region ='JAI')

Line 10305: PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,'PO_CO_Tolerances_Grp.get_tolerances API failed:' || l_return_status || ' ' || l_msg_data);

10301: x_msg_data => l_msg_data);
10302:
10303: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
10304: IF (g_po_wf_debug = 'Y') THEN
10305: PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,'PO_CO_Tolerances_Grp.get_tolerances API failed:' || l_return_status || ' ' || l_msg_data);
10306: END IF;
10307: END IF;
10308:
10309: RETURN l_tolerances_tbl;

Line 10824: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_api_name || ' Return Value:' || l_return_val);

10820: p_tolerances_tab(TOL_SHIPQTY_IND).max_increment,
10821: p_tolerances_tab(TOL_SHIPQTY_IND).max_decrement) = 'N')));
10822:
10823: IF (g_po_wf_debug = 'Y') THEN
10824: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_api_name || ' Return Value:' || l_return_val);
10825: END IF;
10826:
10827: RETURN l_return_val;
10828:

Line 10833: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_api_name || ' Return Value(No data Found):Y');

10829: EXCEPTION
10830: WHEN NO_DATA_FOUND THEN
10831:
10832: IF (g_po_wf_debug = 'Y') THEN
10833: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_api_name || ' Return Value(No data Found):Y');
10834: END IF;
10835:
10836: RETURN 'Y';
10837:

Line 10906: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_api_name || ' Return Value(need by date check):' || l_return_val);

10902: l_return_val := 'Y';
10903: END;
10904:
10905: IF (g_po_wf_debug = 'Y') THEN
10906: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_api_name || ' Return Value(need by date check):' || l_return_val);
10907: END IF;
10908:
10909: l_progress:= '002';
10910:

Line 10951: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_api_name || ' Return Value(start/end date check):' || l_return_val);

10947: END;
10948: END IF;
10949:
10950: IF (g_po_wf_debug = 'Y') THEN
10951: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_api_name || ' Return Value(start/end date check):' || l_return_val);
10952: END IF;
10953:
10954: l_progress:= '003';
10955:

Line 11007: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_api_name || ' Return Value(line amount check):' || l_return_val);

11003:
11004: END IF;
11005:
11006: IF (g_po_wf_debug = 'Y') THEN
11007: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_api_name || ' Return Value(line amount check):' || l_return_val);
11008: END IF;
11009:
11010: RETURN l_return_val;
11011:

Line 11017: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_api_name || ' Return Value(line level check):' || l_return_val);

11013: WHEN OTHERS THEN
11014: l_return_val := 'N';
11015:
11016: IF (g_po_wf_debug = 'Y') THEN
11017: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_api_name || ' Return Value(line level check):' || l_return_val);
11018:
11019: raise;
11020: END IF;
11021:

Line 11135: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_api_name || ' Return Value:' || l_return_val);

11131:
11132: end if;
11133:
11134: IF (g_po_wf_debug = 'Y') THEN
11135: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_api_name || ' Return Value:' || l_return_val);
11136: END IF;
11137:
11138: RETURN l_return_val;
11139:

Line 11144: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_api_name || ' Return Value(No Data Found):Y');

11140: EXCEPTION
11141: WHEN NO_DATA_FOUND THEN
11142:
11143: IF (g_po_wf_debug = 'Y') THEN
11144: PO_WF_DEBUG_PKG.insert_debug(p_item_type, p_item_key, l_api_name || ' Return Value(No Data Found):Y');
11145: END IF;
11146: RETURN 'Y';
11147: END Doc_Level_Changes_Wthn_Tol;
11148:

Line 11190: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, l_api_name || '.Begin');

11186: itemkey => itemkey,
11187: aname => 'CURRENT_PO_HEADER_ID');
11188:
11189: IF (g_po_wf_debug = 'Y') THEN
11190: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, l_api_name || '.Begin');
11191: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, 'l_pochggrp_id:' || l_pochggrp_id || ' l_poheader_id:' || l_poheader_id);
11192: END IF;
11193:
11194: l_progress := '001';

Line 11191: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, 'l_pochggrp_id:' || l_pochggrp_id || ' l_poheader_id:' || l_poheader_id);

11187: aname => 'CURRENT_PO_HEADER_ID');
11188:
11189: IF (g_po_wf_debug = 'Y') THEN
11190: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, l_api_name || '.Begin');
11191: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, 'l_pochggrp_id:' || l_pochggrp_id || ' l_poheader_id:' || l_poheader_id);
11192: END IF;
11193:
11194: l_progress := '001';
11195:

Line 11231: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, 'doc type: '||l_po_doc_type|| ' func currency code: '||l_functional_currency_code||' po curr code: '||l_po_currency_code );

11227: if (l_functional_currency_code <> l_po_currency_code) then
11228: l_return_val := 'N';
11229: end if;
11230:
11231: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, 'doc type: '||l_po_doc_type|| ' func currency code: '||l_functional_currency_code||' po curr code: '||l_po_currency_code );
11232: END IF;
11233:
11234:
11235: IF (l_pochggrp_id IS NOT NULL) THEN

Line 11244: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, 'Return Value(shipmnt_level_changes_wthn_tol):' || l_return_val);

11240: IF (l_return_val <> 'N') THEN
11241: l_return_val := Shipmnt_Level_Changes_Wthn_Tol(itemtype, itemkey, g_tolerances_tbl, l_pochggrp_id);
11242:
11243: IF (g_po_wf_debug = 'Y') THEN
11244: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, 'Return Value(shipmnt_level_changes_wthn_tol):' || l_return_val);
11245: END IF;
11246: END IF;
11247:
11248:

Line 11253: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, 'Return Value(line_level_changes_wthn_tol):' || l_return_val);

11249: IF (l_return_val <> 'N') THEN
11250: -- check for line level changes
11251: l_return_val := Line_Level_Changes_Wthn_Tol(itemtype, itemkey, g_tolerances_tbl, l_pochggrp_id);
11252: IF (g_po_wf_debug = 'Y') THEN
11253: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, 'Return Value(line_level_changes_wthn_tol):' || l_return_val);
11254: END IF;
11255: END IF;
11256:
11257: IF (l_return_val <> 'N') THEN

Line 11261: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, 'Return Value(doc_level_changes_wthn_tol):' || l_return_val);

11257: IF (l_return_val <> 'N') THEN
11258: -- check for document level changes
11259: l_return_val := Doc_Level_Changes_Wthn_Tol(itemtype, itemkey, g_tolerances_tbl, l_pochggrp_id, l_poheader_id);
11260: IF (g_po_wf_debug = 'Y') THEN
11261: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, 'Return Value(doc_level_changes_wthn_tol):' || l_return_val);
11262: END IF;
11263: END IF;
11264:
11265: IF (g_po_wf_debug = 'Y') THEN

Line 11266: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, l_api_name || ' Return Value:' || l_return_val);

11262: END IF;
11263: END IF;
11264:
11265: IF (g_po_wf_debug = 'Y') THEN
11266: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, l_api_name || ' Return Value:' || l_return_val);
11267: END IF;
11268:
11269: -- set result value
11270: resultout := wf_engine.eng_completed || ':' || l_return_val;

Line 11277: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, l_progress || 'SQL ERROR:' || sqlerrm);

11273:
11274: EXCEPTION WHEN OTHERS THEN
11275: -- if something is wrong, just assume it needs approval
11276: IF (g_po_wf_debug = 'Y') THEN
11277: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, l_progress || 'SQL ERROR:' || sqlerrm);
11278: END IF;
11279: resultout := wf_engine.eng_completed || ':N';
11280: END Changes_Wthn_Buyer_Tol_values;
11281: