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.POR_CONTRACTOR_NOTIFY dependencies on PO_WF_DEBUG_PKG

Line 40: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,

36: FROM PO_REQUISITION_HEADERS_ALL
37: WHERE REQUISITION_HEADER_ID = L_REQ_HEADER_ID;
38:
39: IF g_po_wf_debug = 'Y' THEN
40: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
41: g_module_prefix || 'SUPPLIER_NEED_NOTIFY' ||
42: 'L_CONTRACTOR_STATUS, L_SUPPLIER_NOTIFIED_FLAG: ' ||
43: L_CONTRACTOR_STATUS|| ',' || L_SUPPLIER_NOTIFIED_FLAG);
44: end if;

Line 57: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, g_module_prefix || 'SUPPLIER_NEED_NOTIFY' || sqlerrm);

53:
54: EXCEPTION
55: WHEN OTHERS THEN
56: IF g_po_wf_debug = 'Y' THEN
57: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, g_module_prefix || 'SUPPLIER_NEED_NOTIFY' || sqlerrm);
58: END IF;
59:
60: END SUPPLIER_NEED_NOTIFY;
61:

Line 133: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,

129: AND PLS.REQUISITION_SUPPLIER_ID = L_REQUISITION_SUPPLIER_ID
130: AND PORL.REQUISITION_HEADER_ID = PORH.REQUISITION_HEADER_ID;
131:
132: IF g_po_wf_debug = 'Y' THEN
133: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
134: g_module_prefix || 'SELECT_SUPPLIER_NOTIFY' ||
135: 'L_START_DATE, L_JOB_DESCRIPTION, L_REQUISITION_SUPPLIER_ID: ' ||
136: L_START_DATE || ',' || L_JOB_DESCRIPTION || ',' ||
137: L_REQUISITION_SUPPLIER_ID);

Line 183: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,

179:
180: PO_REQAPPROVAL_INIT1.LOCATE_NOTIFIER(L_REQUISITION_SUPPLIER_ID, 'RS', L_NOTIFIER);
181:
182: IF g_po_wf_debug = 'Y' THEN
183: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
184: g_module_prefix || 'SELECT_SUPPLIER_NOTIFY' || 'L_NOTIFIER: ' || L_NOTIFIER || ' L_REQUISITION_SUPPLIER_ID :' || L_REQUISITION_SUPPLIER_ID);
185: end if;
186:
187: IF (L_NOTIFIER IS NULL) THEN

Line 201: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,

197:
198: L_SUPPLIER_EXISTS := 'SUPPLIER_EMAIL_EXISTS';
199:
200: IF g_po_wf_debug = 'Y' THEN
201: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
202: g_module_prefix || 'SELECT_SUPPLIER_NOTIFY' || 'L_SUPPLIER_EXISTS: ' || L_SUPPLIER_EXISTS);
203: END IF;
204:
205: else

Line 210: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,

206:
207: L_SUPPLIER_EXISTS := 'SUPPLIER_EMAIL_NOT_AVAILABLE';
208:
209: IF g_po_wf_debug = 'Y' THEN
210: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
211: g_module_prefix || 'SELECT_SUPPLIER_NOTIFY' || 'L_SUPPLIER_EXISTS: ' || L_SUPPLIER_EXISTS);
212: END IF;
213:
214: SELECT PORL.LINE_NUM, POV.VENDOR_NAME

Line 224: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,

220: AND PLS.REQUISITION_SUPPLIER_ID = L_REQUISITION_SUPPLIER_ID
221: AND PLS.VENDOR_ID = POV.VENDOR_ID;
222:
223: IF g_po_wf_debug = 'Y' THEN
224: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
225: g_module_prefix || 'SELECT_SUPPLIER_NOTIFY L_LINE_NUM:L_VENDOR_NAME'
226: || L_LINE_NUM || ':' || L_VENDOR_NAME);
227: END IF;
228:

Line 255: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, g_module_prefix || 'SELECT_SUPPLIER_NOTIFY' || sqlerrm);

251:
252: EXCEPTION
253: WHEN OTHERS THEN
254: IF g_po_wf_debug = 'Y' THEN
255: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, g_module_prefix || 'SELECT_SUPPLIER_NOTIFY' || sqlerrm);
256: END IF;
257:
258: END SELECT_SUPPLIER_NOTIFY;
259:

Line 276: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,

272: (ITEMTYPE => ITEMTYPE,
273: ITEMKEY => ITEMKEY,
274: ANAME => 'REQUISITION_SUPPLIER_ID');
275: IF g_po_wf_debug = 'Y' THEN
276: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
277: g_module_prefix || 'UPDATE_NOTIFY_SUPPLIER' || 'L_REQUISITION_SUPPLIER_ID : ' || L_REQUISITION_SUPPLIER_ID);
278: end if;
279:
280: UPDATE PO_REQUISITION_SUPPLIERS

Line 289: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, g_module_prefix || 'UPDATE_NOTIFY_SUPPLIER' || sqlerrm);

285:
286: EXCEPTION
287: WHEN OTHERS THEN
288: IF g_po_wf_debug = 'Y' THEN
289: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, g_module_prefix || 'UPDATE_NOTIFY_SUPPLIER' || sqlerrm);
290: END IF;
291:
292: END UPDATE_NOTIFY_SUPPLIER;
293:

Line 319: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE,ITEMKEY,'POR_CONTRACTOR_NOTIFY.GET_ADHOC_EMAIL_ROLE: L_REQ_SUPPLIER_ID:' || L_REQ_SUPPLIER_ID);

315:
316: BEGIN
317:
318: IF (G_PO_WF_DEBUG = 'Y') THEN
319: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE,ITEMKEY,'POR_CONTRACTOR_NOTIFY.GET_ADHOC_EMAIL_ROLE: L_REQ_SUPPLIER_ID:' || L_REQ_SUPPLIER_ID);
320: END IF;
321:
322: BEGIN
323: IF (L_REQ_SUPPLIER_ID IS NOT NULL) THEN

Line 344: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE,ITEMKEY,'POR_CONTRACTOR_NOTIFY.GET_ADHOC_EMAIL_ROLE: SUPPLIER SITE DOES NOT EXIST');

340:
341: EXCEPTION
342: WHEN NO_DATA_FOUND THEN
343: IF (G_PO_WF_DEBUG = 'Y') THEN
344: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE,ITEMKEY,'POR_CONTRACTOR_NOTIFY.GET_ADHOC_EMAIL_ROLE: SUPPLIER SITE DOES NOT EXIST');
345: END IF;
346: RETURN NULL;
347: END;
348:

Line 350: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE,ITEMKEY,' L_VENDOR_SITE_ID, L_VENDOR_CONTACT_ID, L_VENDOR_SITE_CODE, L_VENDOR_SITE_LANG:'

346: RETURN NULL;
347: END;
348:
349: IF (G_PO_WF_DEBUG = 'Y') THEN
350: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE,ITEMKEY,' L_VENDOR_SITE_ID, L_VENDOR_CONTACT_ID, L_VENDOR_SITE_CODE, L_VENDOR_SITE_LANG:'
351: || L_VENDOR_SITE_ID || '*' || L_VENDOR_CONTACT_ID || '*' || L_VENDOR_SITE_CODE || '*' || L_VENDOR_SITE_LANG);
352: END IF;
353:
354: --GET EMAIL ADDRESS FROM SUPPLIER SITE

Line 366: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE,ITEMKEY,'POR_CONTRACTOR_NOTIFY.GET_ADHOC_EMAIL_ROLE: L_EMAIL_ADDRESS FROM SUPPLIER SITE:' || L_EMAIL_ADDRESS || '*');

362: L_EMAIL_ADDRESS := NULL;
363: END;
364:
365: IF (G_PO_WF_DEBUG = 'Y') THEN
366: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE,ITEMKEY,'POR_CONTRACTOR_NOTIFY.GET_ADHOC_EMAIL_ROLE: L_EMAIL_ADDRESS FROM SUPPLIER SITE:' || L_EMAIL_ADDRESS || '*');
367: END IF;
368:
369: --GET EMAIL ADDRESS FROM VENDOR CONTACTS
370: IF L_EMAIL_ADDRESS IS NULL AND L_VENDOR_CONTACT_ID IS NOT NULL THEN

Line 379: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE,ITEMKEY,'POR_CONTRACTOR_NOTIFY.GET_ADHOC_EMAIL_ROLE: L_EMAIL_ADDRESS FROM VENDOR CONTACT:' || L_EMAIL_ADDRESS);

375: WHERE VENDOR_CONTACT_ID = L_VENDOR_CONTACT_ID
376: AND VENDOR_SITE_ID = L_VENDOR_SITE_ID;
377:
378: IF (G_PO_WF_DEBUG = 'Y') THEN
379: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE,ITEMKEY,'POR_CONTRACTOR_NOTIFY.GET_ADHOC_EMAIL_ROLE: L_EMAIL_ADDRESS FROM VENDOR CONTACT:' || L_EMAIL_ADDRESS);
380: END IF;
381:
382: EXCEPTION
383: WHEN NO_DATA_FOUND THEN

Line 390: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE,ITEMKEY,'POR_CONTRACTOR_NOTIFY.GET_ADHOC_EMAIL_ROLE: L_EMAIL_ADDRESS IS NULL');

386: END IF;
387:
388: IF L_EMAIL_ADDRESS IS NULL THEN
389: IF (G_PO_WF_DEBUG = 'Y') THEN
390: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE,ITEMKEY,'POR_CONTRACTOR_NOTIFY.GET_ADHOC_EMAIL_ROLE: L_EMAIL_ADDRESS IS NULL');
391: END IF;
392: RETURN NULL;
393: END IF;
394:

Line 438: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE,ITEMKEY,X_PROGRESS);

434: END IF;
435:
436: X_PROGRESS := 'POR_CONTRACTOR_NOTIFY.GET_ADHOC_EMAIL_ROLE: 02';
437: IF (G_PO_WF_DEBUG = 'Y') THEN
438: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE,ITEMKEY,X_PROGRESS);
439: END IF;
440:
441: RETURN L_EMAIL_PERFORMER;
442:

Line 446: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, g_module_prefix || 'GET_ADHOC_EMAIL_ROLE' || sqlerrm);

442:
443: EXCEPTION
444: WHEN OTHERS THEN
445: IF g_po_wf_debug = 'Y' THEN
446: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, g_module_prefix || 'GET_ADHOC_EMAIL_ROLE' || sqlerrm);
447: END IF;
448:
449: END GET_ADHOC_EMAIL_ROLE;
450:

Line 481: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, g_module_prefix || 'SET_REQSINPOOL_FLAG' || sqlerrm);

477:
478: EXCEPTION
479: WHEN OTHERS THEN
480: IF g_po_wf_debug = 'Y' THEN
481: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, g_module_prefix || 'SET_REQSINPOOL_FLAG' || sqlerrm);
482: END IF;
483:
484: END SET_REQSINPOOL_FLAG;
485: