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.CLN_NP_UTILS_PKG dependencies on WF_ENGINE

Line 349: l_int_ctl_num := to_number(wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER1', TRUE));

345: cln_debug_pub.Add('Parameters:', 1);
346: END IF;
347:
348: -- Internal Control Number
349: l_int_ctl_num := to_number(wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER1', TRUE));
350: IF (l_Debug_Level <= 1) THEN
351: cln_debug_pub.Add('l_int_ctl_num:' || l_int_ctl_num, 1);
352: END IF;
353:

Line 355: l_app_ref_id := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', TRUE);

351: cln_debug_pub.Add('l_int_ctl_num:' || l_int_ctl_num, 1);
352: END IF;
353:
354: -- Application Reference ID
355: l_app_ref_id := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER4', TRUE);
356: IF (l_Debug_Level <= 1) THEN
357: cln_debug_pub.Add('l_app_ref_id:' || l_app_ref_id, 1);
358: END IF;
359:

Line 361: l_doc_status := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER5', TRUE);

357: cln_debug_pub.Add('l_app_ref_id:' || l_app_ref_id, 1);
358: END IF;
359:
360: -- Document Status
361: l_doc_status := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER5', TRUE);
362: IF (l_Debug_Level <= 1) THEN
363: cln_debug_pub.Add('l_doc_status:' || l_doc_status, 1);
364: END IF;
365:

Line 367: l_trp_id := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER10', TRUE);

363: cln_debug_pub.Add('l_doc_status:' || l_doc_status, 1);
364: END IF;
365:
366: -- TP Header ID
367: l_trp_id := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER10', TRUE);
368: IF (l_Debug_Level <= 1) THEN
369: cln_debug_pub.Add('l_tp_id:' || l_trp_id, 1);
370: END IF;
371:

Line 373: l_cbod_statuslvl := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER2', TRUE);

369: cln_debug_pub.Add('l_tp_id:' || l_trp_id, 1);
370: END IF;
371:
372: -- Confirm BOD Status lvl
373: l_cbod_statuslvl := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER2', TRUE);
374: IF (l_Debug_Level <= 1) THEN
375: cln_debug_pub.Add('l_cbod_statuslvl:' || l_cbod_statuslvl, 1);
376: END IF;
377:

Line 383: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER2', '00');

379: -- If either statuslvl or document status is available, set the other one
380: IF l_doc_status IS NOT NULL THEN -- Set the value of statuslvl based on document status
381: IF l_cbod_statuslvl IS NULL THEN
382: IF (l_doc_status = 'SUCCESS') THEN
383: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER2', '00');
384: ELSE -- Assertion l_doc_status = 'ERROR'
385: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER2', '99');
386: END IF;
387: END IF;

Line 385: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER2', '99');

381: IF l_cbod_statuslvl IS NULL THEN
382: IF (l_doc_status = 'SUCCESS') THEN
383: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER2', '00');
384: ELSE -- Assertion l_doc_status = 'ERROR'
385: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER2', '99');
386: END IF;
387: END IF;
388: ELSE -- Set the value of document status based on statuslvl
389: IF l_cbod_statuslvl IS NOT NULL THEN

Line 391: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER5', 'SUCCESS');

387: END IF;
388: ELSE -- Set the value of document status based on statuslvl
389: IF l_cbod_statuslvl IS NOT NULL THEN
390: IF (l_cbod_statuslvl = '00') THEN
391: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER5', 'SUCCESS');
392: ELSE -- Assertion l_cbod_statuslvl = '99'
393: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER5', 'ERROR');
394: END IF;
395: END IF;

Line 393: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER5', 'ERROR');

389: IF l_cbod_statuslvl IS NOT NULL THEN
390: IF (l_cbod_statuslvl = '00') THEN
391: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER5', 'SUCCESS');
392: ELSE -- Assertion l_cbod_statuslvl = '99'
393: wf_engine.SetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER5', 'ERROR');
394: END IF;
395: END IF;
396: END IF;
397:

Line 399: l_not_code1 := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER6', TRUE);

395: END IF;
396: END IF;
397:
398: -- Notification Code1
399: l_not_code1 := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER6', TRUE);
400: IF (l_Debug_Level <= 1) THEN
401: cln_debug_pub.Add('l_not_code1:' || l_not_code1, 1);
402: END IF;
403:

Line 405: l_not_code_desc1 := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER7', TRUE);

401: cln_debug_pub.Add('l_not_code1:' || l_not_code1, 1);
402: END IF;
403:
404: -- Notification Code Description1
405: l_not_code_desc1 := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER7', TRUE);
406: IF (l_Debug_Level <= 1) THEN
407: cln_debug_pub.Add('l_not_code_desc1:' || l_not_code_desc1, 1);
408: END IF;
409:

Line 412: l_tp_type := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER8', TRUE);

408: END IF;
409:
410:
411: -- Trading Partner Type
412: l_tp_type := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER8', TRUE);
413: IF (l_Debug_Level <= 1) THEN
414: cln_debug_pub.Add('l_tp_type:' || l_tp_type, 1);
415: END IF;
416:

Line 418: -- l_unused := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER9', TRUE);

414: cln_debug_pub.Add('l_tp_type:' || l_tp_type, 1);
415: END IF;
416:
417: -- For futurte use
418: -- l_unused := wf_engine.GetItemAttrText(p_itemtype, p_itemkey, 'PARAMETER9', TRUE);
419:
420:
421: CLN_UTILS.GET_TRADING_PARTNER(l_trp_id, l_tp_id);
422: IF (l_Debug_Level <= 1) THEN