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_CANCEL_NOTIF_PVT dependencies on WF_ENGINE

Line 54: wf_engine.CreateProcess( ItemType => l_itemtype,

50: l_progress := 'POR_CANCEL_NOTIFICATION_PKG.Start_WF_Process: 02';
51: IF (g_po_wf_debug = 'Y') THEN
52: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,g_module_prefix || l_api_name || l_progress);
53: END IF;
54: wf_engine.CreateProcess( ItemType => l_itemtype,
55: ItemKey => l_itemkey,
56: process => l_wf_process );
57:
58: wf_engine.SetItemAttrNumber ( itemtype => l_itemtype,

Line 58: wf_engine.SetItemAttrNumber ( itemtype => l_itemtype,

54: wf_engine.CreateProcess( ItemType => l_itemtype,
55: ItemKey => l_itemkey,
56: process => l_wf_process );
57:
58: wf_engine.SetItemAttrNumber ( itemtype => l_itemtype,
59: itemkey => l_itemkey,
60: aname => 'REQ_LINE_ID',
61: avalue => reqLineId);
62:

Line 63: wf_engine.SetItemAttrText (itemtype => l_itemtype,

59: itemkey => l_itemkey,
60: aname => 'REQ_LINE_ID',
61: avalue => reqLineId);
62:
63: wf_engine.SetItemAttrText (itemtype => l_itemtype,
64: itemkey => l_itemkey,
65: aname => 'CONTRACTOR_STATUS',
66: avalue => contractorStatus);
67:

Line 68: wf_engine.StartProcess(ItemType => l_itemtype,

64: itemkey => l_itemkey,
65: aname => 'CONTRACTOR_STATUS',
66: avalue => contractorStatus);
67:
68: wf_engine.StartProcess(ItemType => l_itemtype,
69: ItemKey => l_itemkey);
70:
71: RETURN 'Y';
72:

Line 109: if (funcmode <> wf_engine.eng_run) then

105: END IF;
106:
107: -- Do nothing in cancel or timeout mode
108: --
109: if (funcmode <> wf_engine.eng_run) then
110: resultout := wf_engine.eng_null;
111: return;
112: end if;
113:

Line 110: resultout := wf_engine.eng_null;

106:
107: -- Do nothing in cancel or timeout mode
108: --
109: if (funcmode <> wf_engine.eng_run) then
110: resultout := wf_engine.eng_null;
111: return;
112: end if;
113:
114: l_req_line_id := wf_engine.GetItemAttrNumber

Line 114: l_req_line_id := wf_engine.GetItemAttrNumber

110: resultout := wf_engine.eng_null;
111: return;
112: end if;
113:
114: l_req_line_id := wf_engine.GetItemAttrNumber
115: (itemtype => itemtype,
116: itemkey => itemkey,
117: aname => 'REQ_LINE_ID');
118:

Line 135: resultout := wf_engine.eng_completed || ':' || 'Y' ;

131:
132: -- if (l_supplier_notified_flag = 'Y' and
133: -- (l_contractor_status = 'ASSIGNED' or l_contractor_status = 'PENDING')) then
134: if (l_supplier_notified_flag = 'Y') then
135: resultout := wf_engine.eng_completed || ':' || 'Y' ;
136: else
137: resultout := wf_engine.eng_completed || ':' || 'N' ;
138: end if;
139:

Line 137: resultout := wf_engine.eng_completed || ':' || 'N' ;

133: -- (l_contractor_status = 'ASSIGNED' or l_contractor_status = 'PENDING')) then
134: if (l_supplier_notified_flag = 'Y') then
135: resultout := wf_engine.eng_completed || ':' || 'Y' ;
136: else
137: resultout := wf_engine.eng_completed || ':' || 'N' ;
138: end if;
139:
140: EXCEPTION
141: WHEN OTHERS THEN

Line 224: if (funcmode <> wf_engine.eng_run) then

220:
221:
222: -- Do nothing in cancel or timeout mode
223: --
224: if (funcmode <> wf_engine.eng_run) then
225: resultout := wf_engine.eng_null;
226: return;
227: end if;
228:

Line 225: resultout := wf_engine.eng_null;

221:
222: -- Do nothing in cancel or timeout mode
223: --
224: if (funcmode <> wf_engine.eng_run) then
225: resultout := wf_engine.eng_null;
226: return;
227: end if;
228:
229: l_req_line_id := wf_engine.GetItemAttrNumber

Line 229: l_req_line_id := wf_engine.GetItemAttrNumber

225: resultout := wf_engine.eng_null;
226: return;
227: end if;
228:
229: l_req_line_id := wf_engine.GetItemAttrNumber
230: (itemtype => itemtype,
231: itemkey => itemkey,
232: aname => 'REQ_LINE_ID');
233:

Line 234: l_cont_status := wf_engine.GetItemAttrText

230: (itemtype => itemtype,
231: itemkey => itemkey,
232: aname => 'REQ_LINE_ID');
233:
234: l_cont_status := wf_engine.GetItemAttrText
235: (itemtype => itemtype,
236: itemkey => itemkey,
237: aname => 'CONTRACTOR_STATUS');
238:

Line 261: wf_engine.SetItemAttrText (itemtype => itemtype,

257:
258: l_progress := 'POR_CANCEL_NOTIFICATION_PVT.set_notification_attributes: 05';
259:
260: -- Set Subject attributes
261: wf_engine.SetItemAttrText (itemtype => itemtype,
262: itemkey => itemkey,
263: aname => 'JOB_NAME',
264: avalue => l_job_name);
265:

Line 266: wf_engine.SetItemAttrDate (itemtype => itemtype,

262: itemkey => itemkey,
263: aname => 'JOB_NAME',
264: avalue => l_job_name);
265:
266: wf_engine.SetItemAttrDate (itemtype => itemtype,
267: itemkey => itemkey,
268: aname => 'START_DATE',
269: avalue => l_start_date);
270:

Line 272: wf_engine.SetItemAttrText(itemtype => itemtype,

268: aname => 'START_DATE',
269: avalue => l_start_date);
270:
271: -- Set Notification Header attributes
272: wf_engine.SetItemAttrText(itemtype => itemtype,
273: itemkey => itemkey,
274: aname => 'FORWARD_FROM_USER_NAME',
275: avalue => get_user_name());
276:

Line 277: wf_engine.SetItemAttrText(itemtype => itemtype,

273: itemkey => itemkey,
274: aname => 'FORWARD_FROM_USER_NAME',
275: avalue => get_user_name());
276:
277: wf_engine.SetItemAttrText(itemtype => itemtype,
278: itemkey => itemkey,
279: aname => 'REQ_LINE_INFO',
280: avalue => l_req_info);
281:

Line 282: wf_engine.SetItemAttrText(itemtype => itemtype,

278: itemkey => itemkey,
279: aname => 'REQ_LINE_INFO',
280: avalue => l_req_info);
281:
282: wf_engine.SetItemAttrText(itemtype => itemtype,
283: itemkey => itemkey,
284: aname => 'COMPANY_NAME',
285: avalue => get_company_name());
286:

Line 288: wf_engine.SetItemAttrText(itemtype => itemtype,

284: aname => 'COMPANY_NAME',
285: avalue => get_company_name());
286:
287: -- set attributes for message body
288: wf_engine.SetItemAttrText(itemtype => itemtype,
289: itemkey => itemkey,
290: aname => 'CONTACT_INFO',
291: avalue => l_contact_info);
292:

Line 338: if (funcmode <> wf_engine.eng_run) then

334: END IF;
335:
336: -- Do nothing in cancel or timeout mode
337: --
338: if (funcmode <> wf_engine.eng_run) then
339: resultout := wf_engine.eng_null;
340: return;
341: end if;
342:

Line 339: resultout := wf_engine.eng_null;

335:
336: -- Do nothing in cancel or timeout mode
337: --
338: if (funcmode <> wf_engine.eng_run) then
339: resultout := wf_engine.eng_null;
340: return;
341: end if;
342:
343: l_req_line_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 343: l_req_line_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

339: resultout := wf_engine.eng_null;
340: return;
341: end if;
342:
343: l_req_line_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
344: itemkey => itemkey,
345: aname => 'REQ_LINE_ID');
346:
347: l_progress := 'POR_CANCEL_NOTIFICATION_PVT.set_supplier: 02';

Line 350: l_cont_status := wf_engine.GetItemAttrText (itemtype => itemtype,

346:
347: l_progress := 'POR_CANCEL_NOTIFICATION_PVT.set_supplier: 02';
348:
349:
350: l_cont_status := wf_engine.GetItemAttrText (itemtype => itemtype,
351: itemkey => itemkey,
352: aname => 'CONTRACTOR_STATUS');
353:
354: l_progress := 'POR_CANCEL_NOTIFICATION_PVT.set_supplier: 03';

Line 392: wf_engine.SetItemAttrText (itemtype => itemtype,

388: END IF;
389: END IF;
390:
391: IF (l_performer is not null) THEN
392: wf_engine.SetItemAttrText (itemtype => itemtype,
393: itemkey => itemkey,
394: aname => 'SUPPLIER_ROLE',
395: avalue => l_performer);
396: END IF;

Line 398: wf_engine.SetItemAttrNumber (itemtype => itemtype,

394: aname => 'SUPPLIER_ROLE',
395: avalue => l_performer);
396: END IF;
397:
398: wf_engine.SetItemAttrNumber (itemtype => itemtype,
399: itemkey => itemkey,
400: aname => 'SUPPLIER_ID',
401: avalue => l_requisition_supplier_id);
402: l_supplier_exists := 'SUPPLIER_EXIST';

Line 439: wf_engine.SetItemAttrText (itemtype => itemtype,

435: END IF;
436: END IF;
437:
438: IF (l_performer is not null) THEN
439: wf_engine.SetItemAttrText (itemtype => itemtype,
440: itemkey => itemkey,
441: aname => 'SUPPLIER_ROLE',
442: avalue => l_performer);
443: END IF;

Line 445: wf_engine.SetItemAttrNumber (itemtype => itemtype,

441: aname => 'SUPPLIER_ROLE',
442: avalue => l_performer);
443: END IF;
444:
445: wf_engine.SetItemAttrNumber (itemtype => itemtype,
446: itemkey => itemkey,
447: aname => 'SUPPLIER_ID',
448: avalue => l_requisition_supplier_id);
449: l_supplier_exists := 'SUPPLIER_EXIST';

Line 454: resultout := WF_ENGINE.ENG_COMPLETED || ':' || l_supplier_exists;

450: END IF;
451:
452: END IF;
453:
454: resultout := WF_ENGINE.ENG_COMPLETED || ':' || l_supplier_exists;
455:
456: EXCEPTION
457: WHEN OTHERS THEN
458: wf_core.context('POR_CANCEL_NOTIF_PVT','set_supplier',l_progress);

Line 490: if (funcmode <> wf_engine.eng_run) then

486:
487:
488: -- Do nothing in cancel or timeout mode
489: --
490: if (funcmode <> wf_engine.eng_run) then
491: resultout := wf_engine.eng_null;
492: return;
493: end if;
494:

Line 491: resultout := wf_engine.eng_null;

487:
488: -- Do nothing in cancel or timeout mode
489: --
490: if (funcmode <> wf_engine.eng_run) then
491: resultout := wf_engine.eng_null;
492: return;
493: end if;
494:
495: l_req_line_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

Line 495: l_req_line_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,

491: resultout := wf_engine.eng_null;
492: return;
493: end if;
494:
495: l_req_line_id := wf_engine.GetItemAttrNumber (itemtype => itemtype,
496: itemkey => itemkey,
497: aname => 'REQ_LINE_ID');
498:
499: l_progress := 'POR_CANCEL_NOTIFICATION_PVT.post_notification_process: 02';

Line 505: l_cont_status := wf_engine.GetItemAttrText (itemtype => itemtype,

501: UPDATE po_requisition_lines_all
502: SET supplier_notified_for_cancel ='Y'
503: WHERE requisition_line_id = l_req_line_id;
504:
505: l_cont_status := wf_engine.GetItemAttrText (itemtype => itemtype,
506: itemkey => itemkey,
507: aname => 'CONTRACTOR_STATUS');
508:
509: IF (l_cont_status = 'PENDING') THEN

Line 511: l_supplier_id := wf_engine.GetItemAttrNumber

507: aname => 'CONTRACTOR_STATUS');
508:
509: IF (l_cont_status = 'PENDING') THEN
510:
511: l_supplier_id := wf_engine.GetItemAttrNumber
512: (itemtype => itemtype,
513: itemkey => itemkey,
514: aname => 'SUPPLIER_ID');
515: