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

Line 76: PO_WF_DEBUG_PKG.insert_debug(g_wf_item_type,g_wf_item_key,text);

72:
73: IF (g_wf_item_type is not null and
74: g_wf_item_key is not null and
75: g_po_wf_debug = 'Y') THEN
76: PO_WF_DEBUG_PKG.insert_debug(g_wf_item_type,g_wf_item_key,text);
77: END IF;
78: IF g_wf_item_type is null and
79: g_wf_item_key is null and
80: g_debug_stmt THEN

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

4755: g_wf_item_type := itemtype;
4756: g_wf_item_key := itemkey;
4757:
4758: IF (g_po_wf_debug = 'Y') THEN
4759: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
4760: END IF;
4761:
4762:
4763: -- Do nothing in cancel or timeout mode

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

4853: aname => 'ONLINE_REPORT_TEXT',
4854: avalue => l_errormessage);
4855: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.sync_with_award_wf: 02'||resultout;
4856: IF (g_po_wf_debug = 'Y') THEN
4857: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
4858: END IF;
4859:
4860: EXCEPTION
4861: when others then

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

4965:
4966: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.ACQUIRE_SYNC_SGD_LOCK: 01';
4967:
4968: IF (g_po_wf_debug = 'Y') THEN
4969: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
4970: END IF;
4971:
4972: l_draft_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'DRAFT_ID');
4973:

Line 4983: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

4979: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.ACQUIRE_SYNC_SGD_LOCK: l_draft_id: '||l_draft_id||', l_po_header_id: '||l_po_header_id||', l_doc_sub_type: '||l_doc_sub_type||', l_doc_type: '||l_doc_type;
4980:
4981:
4982: IF (g_po_wf_debug = 'Y') THEN
4983: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
4984: END IF;
4985:
4986: --insert a row in po entity locks table
4987:

Line 5041: po_wf_debug_pkg.Insert_debug(itemtype, itemkey, x_progress);

5037:
5038: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.IS_LOCK_FOR_SGD_GEN_AVAILABLE: Draft_id: ' || l_draft_id;
5039:
5040: IF (g_po_wf_debug = 'Y') THEN
5041: po_wf_debug_pkg.Insert_debug(itemtype, itemkey, x_progress);
5042: END IF;
5043:
5044: BEGIN
5045: SELECT document_id

Line 5061: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);

5057: EXCEPTION
5058: WHEN No_Data_Found THEN
5059: IF (g_po_wf_debug = 'Y') THEN
5060: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.IS_LOCK_FOR_SGD_GEN_AVAILABLE: in no data found exception';
5061: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
5062: END IF;
5063: END;
5064:
5065: IF (g_po_wf_debug = 'Y') THEN

Line 5074: po_wf_debug_pkg.Insert_debug(itemtype, itemkey, x_progress);

5070:
5071: EXCEPTION
5072: WHEN OTHERS THEN
5073: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.IS_LOCK_FOR_SGD_GEN_AVAILABLE: Exception';
5074: po_wf_debug_pkg.Insert_debug(itemtype, itemkey, x_progress);
5075: RAISE;
5076: END;
5077:
5078: -------------------------------------------------------------------------------

Line 5117: po_wf_debug_pkg.Insert_debug(itemtype, itemkey, x_progress);

5113:
5114: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.IS_SGD_GENERATION_REQUIRED: Draft_id: '
5115: || l_draft_id || 'l_draft_rev_num : '|| l_draft_rev_num || 'l_header_base_rev_num '|| l_header_base_rev_num || 'draft_revision_num '|| draft_revision_num;
5116:
5117: po_wf_debug_pkg.Insert_debug(itemtype, itemkey, x_progress);
5118:
5119: -- Check if the base award version is greater than the draft version or the award has been update w/o mod
5120: IF((l_draft_rev_num < l_header_base_rev_num) OR draft_revision_num = -1 )
5121: THEN

Line 5127: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);

5123: END IF;
5124:
5125: resultout := wf_engine.eng_completed || ':' || l_is_sgd_generation_req;
5126: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.IS_SGD_GENERATION_REQUIRED value is '|| l_is_sgd_generation_req ;
5127: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
5128:
5129: EXCEPTION
5130: WHEN No_Data_Found THEN
5131: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.IS_SGD_GENERATION_REQUIRED: in no data found exception';

Line 5132: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);

5128:
5129: EXCEPTION
5130: WHEN No_Data_Found THEN
5131: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.IS_SGD_GENERATION_REQUIRED: in no data found exception';
5132: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
5133: WHEN OTHERS THEN
5134: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.IS_SGD_GENERATION_REQUIRED: Exception';
5135: po_wf_debug_pkg.Insert_debug(itemtype, itemkey, x_progress);
5136: RAISE;

Line 5135: po_wf_debug_pkg.Insert_debug(itemtype, itemkey, x_progress);

5131: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.IS_SGD_GENERATION_REQUIRED: in no data found exception';
5132: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
5133: WHEN OTHERS THEN
5134: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.IS_SGD_GENERATION_REQUIRED: Exception';
5135: po_wf_debug_pkg.Insert_debug(itemtype, itemkey, x_progress);
5136: RAISE;
5137: END;
5138:
5139:

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

5165: BEGIN
5166:
5167: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.LAUNCH_SGD_CONCURRENT_PROGRAM: 01';
5168: IF (g_po_wf_debug = 'Y') THEN
5169: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
5170: END IF;
5171:
5172: l_draft_id := wf_engine.GetItemAttrNumber (itemtype, itemkey, 'DRAFT_ID');
5173:

Line 5196: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

5192: l_po_header_id||', l_doc_sub_type: '||l_doc_sub_type||', l_doc_type: '||l_doc_type ||'l_org_id :'|| l_org_id ||
5193: 'l_revision_number '|| l_revision_number;
5194:
5195: IF (g_po_wf_debug = 'Y') THEN
5196: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
5197: END IF;
5198:
5199:
5200: select pf.DOC_FORMAT_TMPL_CODE, f.iso_territory, f.language_code

Line 5230: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

5226:
5227: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.LAUNCH_SGD_CONCURRENT_PROGRAM: : Request id is - '|| l_request_id;
5228:
5229: IF (g_po_wf_debug = 'Y') THEN
5230: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
5231: END IF;
5232:
5233:
5234: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemtype,

Line 5245: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

5241: EXCEPTION
5242: WHEN OTHERS THEN
5243: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.LAUNCH_SGD_CONCURRENT_PROGRAM: Error: '||sqlerrm;
5244: IF (g_po_wf_debug = 'Y') THEN
5245: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
5246: END IF;
5247: resultout := wf_engine.eng_completed || ':' || '';
5248:
5249: END LAUNCH_SGD_CONCURRENT_PROGRAM;

Line 5292: po_wf_debug_pkg.Insert_debug(itemtype, itemkey, x_progress);

5288:
5289: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.RELEASE_SYNC_SGD_LOCK: Draft_id: '
5290: || l_draft_id;
5291:
5292: po_wf_debug_pkg.Insert_debug(itemtype, itemkey, x_progress);
5293:
5294: BEGIN
5295: SELECT document_id
5296: INTO l_po_header_id

Line 5307: po_wf_debug_pkg.Insert_debug(itemtype, itemkey, x_progress);

5303: AND entity_pk1 = l_po_header_id
5304: AND entity_name = G_MOD_SYNC_LOCK;
5305:
5306: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.RELEASE_SYNC_SGD_LOCK: No Of rows deleted from po_entity_locks table : ' || SQL%ROWCOUNT;
5307: po_wf_debug_pkg.Insert_debug(itemtype, itemkey, x_progress);
5308:
5309: FOR item_key IN waiting_process_wf_keys(l_draft_id) LOOP
5310: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.RELEASE_SYNC_SGD_LOCK: Item keys of waiting process : ' || item_key.item_key;
5311: po_wf_debug_pkg.Insert_debug(itemtype, itemkey, x_progress);

Line 5311: po_wf_debug_pkg.Insert_debug(itemtype, itemkey, x_progress);

5307: po_wf_debug_pkg.Insert_debug(itemtype, itemkey, x_progress);
5308:
5309: FOR item_key IN waiting_process_wf_keys(l_draft_id) LOOP
5310: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.RELEASE_SYNC_SGD_LOCK: Item keys of waiting process : ' || item_key.item_key;
5311: po_wf_debug_pkg.Insert_debug(itemtype, itemkey, x_progress);
5312: --Execute complete activity on these process to resume
5313: wf_engine.CompleteActivity(x_itemtype,item_key.item_key,'WAIT_FOR_LOCK_TO_BE_RELEASED','ACTIVITY_PERFORMED');
5314: END LOOP;
5315:

Line 5321: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);

5317:
5318: EXCEPTION
5319: WHEN No_Data_Found THEN
5320: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.RELEASE_SYNC_SGD_LOCK: in no data found exception';
5321: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,x_progress);
5322: END;
5323:
5324: EXCEPTION
5325: WHEN OTHERS THEN

Line 5327: po_wf_debug_pkg.Insert_debug(itemtype, itemkey, x_progress);

5323:
5324: EXCEPTION
5325: WHEN OTHERS THEN
5326: x_progress := 'PO_MOD_SYNC_PROCESS_PVT.RELEASE_SYNC_SGD_LOCK: Exception';
5327: po_wf_debug_pkg.Insert_debug(itemtype, itemkey, x_progress);
5328: RAISE;
5329: END RELEASE_SYNC_SGD_LOCK;
5330:
5331: END;