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

Line 78: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.CREATEPROCESS',WSH_DEBUG_SV.C_PROC_LEVEL);

74: --
75: -- Debug Statements
76: --
77: IF l_debug_on THEN
78: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.CREATEPROCESS',WSH_DEBUG_SV.C_PROC_LEVEL);
79: END IF;
80: --
81: wf_engine.CreateProcess(
82: ItemType => l_item_type,

Line 81: wf_engine.CreateProcess(

77: IF l_debug_on THEN
78: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.CREATEPROCESS',WSH_DEBUG_SV.C_PROC_LEVEL);
79: END IF;
80: --
81: wf_engine.CreateProcess(
82: ItemType => l_item_type,
83: ItemKey => l_item_key,
84: process => l_workflow_process );
85:

Line 90: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.SETITEMATTRNUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);

86: --
87: -- Debug Statements
88: --
89: IF l_debug_on THEN
90: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.SETITEMATTRNUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
91: END IF;
92: --
93: wf_engine.SetItemAttrNumber(
94: ItemType => l_item_type,

Line 93: wf_engine.SetItemAttrNumber(

89: IF l_debug_on THEN
90: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.SETITEMATTRNUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
91: END IF;
92: --
93: wf_engine.SetItemAttrNumber(
94: ItemType => l_item_type,
95: ItemKey => l_item_key,
96: aname => 'SOURCE_HEADER_ID',
97: avalue => p_source_header_id );

Line 103: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.SETITEMATTRTEXT',WSH_DEBUG_SV.C_PROC_LEVEL);

99: --
100: -- Debug Statements
101: --
102: IF l_debug_on THEN
103: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.SETITEMATTRTEXT',WSH_DEBUG_SV.C_PROC_LEVEL);
104: END IF;
105: --
106: wf_engine.SetItemAttrText(
107: ItemType => l_item_type,

Line 106: wf_engine.SetItemAttrText(

102: IF l_debug_on THEN
103: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.SETITEMATTRTEXT',WSH_DEBUG_SV.C_PROC_LEVEL);
104: END IF;
105: --
106: wf_engine.SetItemAttrText(
107: ItemType => l_item_type,
108: ItemKey => l_item_key,
109: aname => 'SOURCE_CODE',
110: avalue => p_source_code);

Line 116: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.SETITEMATTRNUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);

112: --
113: -- Debug Statements
114: --
115: IF l_debug_on THEN
116: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.SETITEMATTRNUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
117: END IF;
118: --
119: wf_engine.SetItemAttrNumber(
120: ItemType => l_item_type,

Line 119: wf_engine.SetItemAttrNumber(

115: IF l_debug_on THEN
116: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.SETITEMATTRNUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
117: END IF;
118: --
119: wf_engine.SetItemAttrNumber(
120: ItemType => l_item_type,
121: ItemKey => l_item_key,
122: aname => 'ORDER_NUMBER',
123: avalue => p_order_number );

Line 129: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.SETITEMATTRTEXT',WSH_DEBUG_SV.C_PROC_LEVEL);

125: --
126: -- Debug Statements
127: --
128: IF l_debug_on THEN
129: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.SETITEMATTRTEXT',WSH_DEBUG_SV.C_PROC_LEVEL);
130: END IF;
131: --
132: wf_engine.SetItemAttrText(
133: ItemType => l_item_type,

Line 132: wf_engine.SetItemAttrText(

128: IF l_debug_on THEN
129: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.SETITEMATTRTEXT',WSH_DEBUG_SV.C_PROC_LEVEL);
130: END IF;
131: --
132: wf_engine.SetItemAttrText(
133: ItemType => l_item_type,
134: ItemKey => l_item_key,
135: aname => 'CONTACT_TYPE',
136: avalue => p_contact_type);

Line 142: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.SETITEMATTRTEXT',WSH_DEBUG_SV.C_PROC_LEVEL);

138: --
139: -- Debug Statements
140: --
141: IF l_debug_on THEN
142: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.SETITEMATTRTEXT',WSH_DEBUG_SV.C_PROC_LEVEL);
143: END IF;
144: --
145: wf_engine.SetItemAttrText(
146: ItemType => l_item_type,

Line 145: wf_engine.SetItemAttrText(

141: IF l_debug_on THEN
142: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.SETITEMATTRTEXT',WSH_DEBUG_SV.C_PROC_LEVEL);
143: END IF;
144: --
145: wf_engine.SetItemAttrText(
146: ItemType => l_item_type,
147: ItemKey => l_item_key,
148: aname => 'CONTACT_NAME',
149: avalue => p_contact_name);

Line 155: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.SETITEMATTRNUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);

151: --
152: -- Debug Statements
153: --
154: IF l_debug_on THEN
155: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.SETITEMATTRNUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
156: END IF;
157: --
158: wf_engine.SetItemAttrNumber(
159: ItemType => l_item_type,

Line 158: wf_engine.SetItemAttrNumber(

154: IF l_debug_on THEN
155: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.SETITEMATTRNUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
156: END IF;
157: --
158: wf_engine.SetItemAttrNumber(
159: ItemType => l_item_type,
160: ItemKey => l_item_key,
161: aname => 'CONTACT_ID',
162: avalue => p_contact_id);

Line 168: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.SETITEMATTRTEXT',WSH_DEBUG_SV.C_PROC_LEVEL);

164: --
165: -- Debug Statements
166: --
167: IF l_debug_on THEN
168: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.SETITEMATTRTEXT',WSH_DEBUG_SV.C_PROC_LEVEL);
169: END IF;
170: --
171: wf_engine.SetItemAttrText(
172: ItemType => l_item_type,

Line 171: wf_engine.SetItemAttrText(

167: IF l_debug_on THEN
168: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.SETITEMATTRTEXT',WSH_DEBUG_SV.C_PROC_LEVEL);
169: END IF;
170: --
171: wf_engine.SetItemAttrText(
172: ItemType => l_item_type,
173: ItemKey => l_item_key,
174: aname => 'CONTACT_LAST_NAME',
175: avalue => p_contact_last_name);

Line 181: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.SETITEMATTRDATE',WSH_DEBUG_SV.C_PROC_LEVEL);

177: --
178: -- Debug Statements
179: --
180: IF l_debug_on THEN
181: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.SETITEMATTRDATE',WSH_DEBUG_SV.C_PROC_LEVEL);
182: END IF;
183: --
184: wf_engine.SetItemAttrDate(
185: ItemType => l_item_type,

Line 184: wf_engine.SetItemAttrDate(

180: IF l_debug_on THEN
181: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.SETITEMATTRDATE',WSH_DEBUG_SV.C_PROC_LEVEL);
182: END IF;
183: --
184: wf_engine.SetItemAttrDate(
185: ItemType => l_item_type,
186: ItemKey => l_item_key,
187: aname => 'LAST_SHIP_NOTIF_DATE',
188: avalue => p_ship_notif_date);

Line 194: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.SETITEMATTRDATE',WSH_DEBUG_SV.C_PROC_LEVEL);

190: --
191: -- Debug Statements
192: --
193: IF l_debug_on THEN
194: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.SETITEMATTRDATE',WSH_DEBUG_SV.C_PROC_LEVEL);
195: END IF;
196: --
197: wf_engine.SetItemAttrDate(
198: ItemType => l_item_type,

Line 197: wf_engine.SetItemAttrDate(

193: IF l_debug_on THEN
194: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.SETITEMATTRDATE',WSH_DEBUG_SV.C_PROC_LEVEL);
195: END IF;
196: --
197: wf_engine.SetItemAttrDate(
198: ItemType => l_item_type,
199: ItemKey => l_item_key,
200: aname => 'LAST_BO_NOTIF_DATE',
201: avalue => p_bo_notif_date);

Line 207: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.SETITEMUSERKEY',WSH_DEBUG_SV.C_PROC_LEVEL);

203: --
204: -- Debug Statements
205: --
206: IF l_debug_on THEN
207: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.SETITEMUSERKEY',WSH_DEBUG_SV.C_PROC_LEVEL);
208: END IF;
209: --
210: wf_engine.SetItemUserKey(
211: ItemType => l_item_type,

Line 210: wf_engine.SetItemUserKey(

206: IF l_debug_on THEN
207: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.SETITEMUSERKEY',WSH_DEBUG_SV.C_PROC_LEVEL);
208: END IF;
209: --
210: wf_engine.SetItemUserKey(
211: ItemType => l_item_type,
212: ItemKey => l_item_key,
213: UserKey => l_item_userkey );
214:

Line 219: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.STARTPROCESS',WSH_DEBUG_SV.C_PROC_LEVEL);

215: --
216: -- Debug Statements
217: --
218: IF l_debug_on THEN
219: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.STARTPROCESS',WSH_DEBUG_SV.C_PROC_LEVEL);
220: END IF;
221: --
222: wf_engine.StartProcess(
223: ItemType => l_item_type,

Line 222: wf_engine.StartProcess(

218: IF l_debug_on THEN
219: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.STARTPROCESS',WSH_DEBUG_SV.C_PROC_LEVEL);
220: END IF;
221: --
222: wf_engine.StartProcess(
223: ItemType => l_item_type,
224: ItemKey => l_item_key);
225: --
226: -- Debug Statements

Line 367: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRNUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);

363: --
364: -- Debug Statements
365: --
366: IF l_debug_on THEN
367: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRNUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
368: END IF;
369: --
370: l_source_header_id := wf_engine.GetItemAttrNumber(
371: ItemType => itemtype,

Line 370: l_source_header_id := wf_engine.GetItemAttrNumber(

366: IF l_debug_on THEN
367: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRNUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
368: END IF;
369: --
370: l_source_header_id := wf_engine.GetItemAttrNumber(
371: ItemType => itemtype,
372: ItemKey => itemkey,
373: aname => 'SOURCE_HEADER_ID');
374:

Line 379: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRTEXT',WSH_DEBUG_SV.C_PROC_LEVEL);

375: --
376: -- Debug Statements
377: --
378: IF l_debug_on THEN
379: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRTEXT',WSH_DEBUG_SV.C_PROC_LEVEL);
380: END IF;
381: --
382: l_source_code := wf_engine.GetItemAttrText(
383: ItemType => itemtype,

Line 382: l_source_code := wf_engine.GetItemAttrText(

378: IF l_debug_on THEN
379: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRTEXT',WSH_DEBUG_SV.C_PROC_LEVEL);
380: END IF;
381: --
382: l_source_code := wf_engine.GetItemAttrText(
383: ItemType => itemtype,
384: ItemKey => itemkey,
385: aname => 'SOURCE_CODE');
386:

Line 391: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRTEXT',WSH_DEBUG_SV.C_PROC_LEVEL);

387: --
388: -- Debug Statements
389: --
390: IF l_debug_on THEN
391: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRTEXT',WSH_DEBUG_SV.C_PROC_LEVEL);
392: END IF;
393: --
394: l_contact_type := wf_engine.GetItemAttrText(
395: ItemType => itemtype,

Line 394: l_contact_type := wf_engine.GetItemAttrText(

390: IF l_debug_on THEN
391: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRTEXT',WSH_DEBUG_SV.C_PROC_LEVEL);
392: END IF;
393: --
394: l_contact_type := wf_engine.GetItemAttrText(
395: ItemType => itemtype,
396: ItemKey => itemkey,
397: aname => 'CONTACT_TYPE');
398:

Line 403: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRNUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);

399: --
400: -- Debug Statements
401: --
402: IF l_debug_on THEN
403: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRNUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
404: END IF;
405: --
406: l_contact_id := wf_engine.GetItemAttrNumber(
407: ItemType => itemtype,

Line 406: l_contact_id := wf_engine.GetItemAttrNumber(

402: IF l_debug_on THEN
403: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRNUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
404: END IF;
405: --
406: l_contact_id := wf_engine.GetItemAttrNumber(
407: ItemType => itemtype,
408: ItemKey => itemkey,
409: aname => 'CONTACT_ID');
410:

Line 415: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRDATE',WSH_DEBUG_SV.C_PROC_LEVEL);

411: --
412: -- Debug Statements
413: --
414: IF l_debug_on THEN
415: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRDATE',WSH_DEBUG_SV.C_PROC_LEVEL);
416: END IF;
417: --
418: l_bo_notif_date := wf_engine.GetItemAttrDate(
419: ItemType => itemtype,

Line 418: l_bo_notif_date := wf_engine.GetItemAttrDate(

414: IF l_debug_on THEN
415: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRDATE',WSH_DEBUG_SV.C_PROC_LEVEL);
416: END IF;
417: --
418: l_bo_notif_date := wf_engine.GetItemAttrDate(
419: ItemType => itemtype,
420: ItemKey => itemkey,
421: aname => 'LAST_BO_NOTIF_DATE');
422:

Line 427: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRDATE',WSH_DEBUG_SV.C_PROC_LEVEL);

423: --
424: -- Debug Statements
425: --
426: IF l_debug_on THEN
427: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRDATE',WSH_DEBUG_SV.C_PROC_LEVEL);
428: END IF;
429: --
430: l_ship_notif_date := wf_engine.GetItemAttrDate(
431: ItemType => itemtype,

Line 430: l_ship_notif_date := wf_engine.GetItemAttrDate(

426: IF l_debug_on THEN
427: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRDATE',WSH_DEBUG_SV.C_PROC_LEVEL);
428: END IF;
429: --
430: l_ship_notif_date := wf_engine.GetItemAttrDate(
431: ItemType => itemtype,
432: ItemKey => itemkey,
433: aname => 'LAST_SHIP_NOTIF_DATE');
434:

Line 551: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRNUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);

547: --
548: -- Debug Statements
549: --
550: IF l_debug_on THEN
551: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRNUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
552: END IF;
553: --
554: l_source_header_id := wf_engine.GetItemAttrNumber(
555: ItemType => itemtype,

Line 554: l_source_header_id := wf_engine.GetItemAttrNumber(

550: IF l_debug_on THEN
551: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRNUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
552: END IF;
553: --
554: l_source_header_id := wf_engine.GetItemAttrNumber(
555: ItemType => itemtype,
556: ItemKey => itemkey,
557: aname => 'SOURCE_HEADER_ID');
558:

Line 563: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRTEXT',WSH_DEBUG_SV.C_PROC_LEVEL);

559: --
560: -- Debug Statements
561: --
562: IF l_debug_on THEN
563: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRTEXT',WSH_DEBUG_SV.C_PROC_LEVEL);
564: END IF;
565: --
566: l_source_code := wf_engine.GetItemAttrText(
567: ItemType => itemtype,

Line 566: l_source_code := wf_engine.GetItemAttrText(

562: IF l_debug_on THEN
563: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRTEXT',WSH_DEBUG_SV.C_PROC_LEVEL);
564: END IF;
565: --
566: l_source_code := wf_engine.GetItemAttrText(
567: ItemType => itemtype,
568: ItemKey => itemkey,
569: aname => 'SOURCE_CODE');
570:

Line 575: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRTEXT',WSH_DEBUG_SV.C_PROC_LEVEL);

571: --
572: -- Debug Statements
573: --
574: IF l_debug_on THEN
575: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRTEXT',WSH_DEBUG_SV.C_PROC_LEVEL);
576: END IF;
577: --
578: l_contact_type := wf_engine.GetItemAttrText(
579: ItemType => itemtype,

Line 578: l_contact_type := wf_engine.GetItemAttrText(

574: IF l_debug_on THEN
575: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRTEXT',WSH_DEBUG_SV.C_PROC_LEVEL);
576: END IF;
577: --
578: l_contact_type := wf_engine.GetItemAttrText(
579: ItemType => itemtype,
580: ItemKey => itemkey,
581: aname => 'CONTACT_TYPE');
582:

Line 587: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRNUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);

583: --
584: -- Debug Statements
585: --
586: IF l_debug_on THEN
587: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRNUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
588: END IF;
589: --
590: l_contact_id := wf_engine.GetItemAttrNumber(
591: ItemType => itemtype,

Line 590: l_contact_id := wf_engine.GetItemAttrNumber(

586: IF l_debug_on THEN
587: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRNUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
588: END IF;
589: --
590: l_contact_id := wf_engine.GetItemAttrNumber(
591: ItemType => itemtype,
592: ItemKey => itemkey,
593: aname => 'CONTACT_ID');
594:

Line 677: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRNUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);

673: --
674: -- Debug Statements
675: --
676: IF l_debug_on THEN
677: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRNUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
678: END IF;
679: --
680: l_source_header_id := wf_engine.GetItemAttrNumber(
681: ItemType => l_item_type,

Line 680: l_source_header_id := wf_engine.GetItemAttrNumber(

676: IF l_debug_on THEN
677: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRNUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
678: END IF;
679: --
680: l_source_header_id := wf_engine.GetItemAttrNumber(
681: ItemType => l_item_type,
682: ItemKey => l_item_key,
683: aname => 'SOURCE_HEADER_ID');
684:

Line 689: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRTEXT',WSH_DEBUG_SV.C_PROC_LEVEL);

685: --
686: -- Debug Statements
687: --
688: IF l_debug_on THEN
689: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRTEXT',WSH_DEBUG_SV.C_PROC_LEVEL);
690: END IF;
691: --
692: l_source_code := wf_engine.GetItemAttrText(
693: ItemType => l_item_type,

Line 692: l_source_code := wf_engine.GetItemAttrText(

688: IF l_debug_on THEN
689: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRTEXT',WSH_DEBUG_SV.C_PROC_LEVEL);
690: END IF;
691: --
692: l_source_code := wf_engine.GetItemAttrText(
693: ItemType => l_item_type,
694: ItemKey => l_item_key,
695: aname => 'SOURCE_CODE');
696:

Line 701: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRTEXT',WSH_DEBUG_SV.C_PROC_LEVEL);

697: --
698: -- Debug Statements
699: --
700: IF l_debug_on THEN
701: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRTEXT',WSH_DEBUG_SV.C_PROC_LEVEL);
702: END IF;
703: --
704: l_contact_type := wf_engine.GetItemAttrText(
705: ItemType => l_item_type,

Line 704: l_contact_type := wf_engine.GetItemAttrText(

700: IF l_debug_on THEN
701: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRTEXT',WSH_DEBUG_SV.C_PROC_LEVEL);
702: END IF;
703: --
704: l_contact_type := wf_engine.GetItemAttrText(
705: ItemType => l_item_type,
706: ItemKey => l_item_key,
707: aname => 'CONTACT_TYPE');
708:

Line 713: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRNUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);

709: --
710: -- Debug Statements
711: --
712: IF l_debug_on THEN
713: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRNUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
714: END IF;
715: --
716: l_contact_id := wf_engine.GetItemAttrNumber(
717: ItemType => l_item_type,

Line 716: l_contact_id := wf_engine.GetItemAttrNumber(

712: IF l_debug_on THEN
713: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRNUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
714: END IF;
715: --
716: l_contact_id := wf_engine.GetItemAttrNumber(
717: ItemType => l_item_type,
718: ItemKey => l_item_key,
719: aname => 'CONTACT_ID');
720:

Line 725: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRDATE',WSH_DEBUG_SV.C_PROC_LEVEL);

721: --
722: -- Debug Statements
723: --
724: IF l_debug_on THEN
725: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRDATE',WSH_DEBUG_SV.C_PROC_LEVEL);
726: END IF;
727: --
728: l_last_notif_date := wf_engine.GetItemAttrDate(
729: ItemType => l_item_type,

Line 728: l_last_notif_date := wf_engine.GetItemAttrDate(

724: IF l_debug_on THEN
725: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRDATE',WSH_DEBUG_SV.C_PROC_LEVEL);
726: END IF;
727: --
728: l_last_notif_date := wf_engine.GetItemAttrDate(
729: ItemType => l_item_type,
730: ItemKey => l_item_key,
731: aname => 'LAST_SHIP_NOTIF_DATE');
732:

Line 756: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.SETITEMATTRDATE',WSH_DEBUG_SV.C_PROC_LEVEL);

752: --
753: -- Debug Statements
754: --
755: IF l_debug_on THEN
756: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.SETITEMATTRDATE',WSH_DEBUG_SV.C_PROC_LEVEL);
757: END IF;
758: --
759: wf_engine.SetItemAttrDate(
760: ItemType => l_item_type,

Line 759: wf_engine.SetItemAttrDate(

755: IF l_debug_on THEN
756: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.SETITEMATTRDATE',WSH_DEBUG_SV.C_PROC_LEVEL);
757: END IF;
758: --
759: wf_engine.SetItemAttrDate(
760: ItemType => l_item_type,
761: ItemKey => l_item_key,
762: aname => 'LAST_SHIP_NOTIF_DATE',
763: avalue => sysdate);

Line 833: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRNUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);

829: --
830: -- Debug Statements
831: --
832: IF l_debug_on THEN
833: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRNUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
834: END IF;
835: --
836: l_source_header_id := wf_engine.GetItemAttrNumber(
837: ItemType => l_item_type,

Line 836: l_source_header_id := wf_engine.GetItemAttrNumber(

832: IF l_debug_on THEN
833: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRNUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
834: END IF;
835: --
836: l_source_header_id := wf_engine.GetItemAttrNumber(
837: ItemType => l_item_type,
838: ItemKey => l_item_key,
839: aname => 'SOURCE_HEADER_ID');
840:

Line 845: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRTEXT',WSH_DEBUG_SV.C_PROC_LEVEL);

841: --
842: -- Debug Statements
843: --
844: IF l_debug_on THEN
845: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRTEXT',WSH_DEBUG_SV.C_PROC_LEVEL);
846: END IF;
847: --
848: l_source_code := wf_engine.GetItemAttrText(
849: ItemType => l_item_type,

Line 848: l_source_code := wf_engine.GetItemAttrText(

844: IF l_debug_on THEN
845: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRTEXT',WSH_DEBUG_SV.C_PROC_LEVEL);
846: END IF;
847: --
848: l_source_code := wf_engine.GetItemAttrText(
849: ItemType => l_item_type,
850: ItemKey => l_item_key,
851: aname => 'SOURCE_CODE');
852:

Line 857: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRTEXT',WSH_DEBUG_SV.C_PROC_LEVEL);

853: --
854: -- Debug Statements
855: --
856: IF l_debug_on THEN
857: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRTEXT',WSH_DEBUG_SV.C_PROC_LEVEL);
858: END IF;
859: --
860: l_contact_type := wf_engine.GetItemAttrText(
861: ItemType => l_item_type,

Line 860: l_contact_type := wf_engine.GetItemAttrText(

856: IF l_debug_on THEN
857: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRTEXT',WSH_DEBUG_SV.C_PROC_LEVEL);
858: END IF;
859: --
860: l_contact_type := wf_engine.GetItemAttrText(
861: ItemType => l_item_type,
862: ItemKey => l_item_key,
863: aname => 'CONTACT_TYPE');
864:

Line 869: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRNUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);

865: --
866: -- Debug Statements
867: --
868: IF l_debug_on THEN
869: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRNUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
870: END IF;
871: --
872: l_contact_id := wf_engine.GetItemAttrNumber(
873: ItemType => l_item_type,

Line 872: l_contact_id := wf_engine.GetItemAttrNumber(

868: IF l_debug_on THEN
869: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRNUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
870: END IF;
871: --
872: l_contact_id := wf_engine.GetItemAttrNumber(
873: ItemType => l_item_type,
874: ItemKey => l_item_key,
875: aname => 'CONTACT_ID');
876:

Line 881: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRDATE',WSH_DEBUG_SV.C_PROC_LEVEL);

877: --
878: -- Debug Statements
879: --
880: IF l_debug_on THEN
881: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRDATE',WSH_DEBUG_SV.C_PROC_LEVEL);
882: END IF;
883: --
884: l_last_notif_date := wf_engine.GetItemAttrDate(
885: ItemType => l_item_type,

Line 884: l_last_notif_date := wf_engine.GetItemAttrDate(

880: IF l_debug_on THEN
881: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.GETITEMATTRDATE',WSH_DEBUG_SV.C_PROC_LEVEL);
882: END IF;
883: --
884: l_last_notif_date := wf_engine.GetItemAttrDate(
885: ItemType => l_item_type,
886: ItemKey => l_item_key,
887: aname => 'LAST_BO_NOTIF_DATE');
888:

Line 913: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.SETITEMATTRDATE',WSH_DEBUG_SV.C_PROC_LEVEL);

909: --
910: -- Debug Statements
911: --
912: IF l_debug_on THEN
913: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.SETITEMATTRDATE',WSH_DEBUG_SV.C_PROC_LEVEL);
914: END IF;
915: --
916: wf_engine.SetItemAttrDate(
917: ItemType => l_item_type,

Line 916: wf_engine.SetItemAttrDate(

912: IF l_debug_on THEN
913: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.SETITEMATTRDATE',WSH_DEBUG_SV.C_PROC_LEVEL);
914: END IF;
915: --
916: wf_engine.SetItemAttrDate(
917: ItemType => l_item_type,
918: ItemKey => l_item_key,
919: aname => 'LAST_BO_NOTIF_DATE',
920: avalue => sysdate);

Line 1040: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.COMPLETEACTIVITY',WSH_DEBUG_SV.C_PROC_LEVEL);

1036: --
1037: -- Debug Statements
1038: --
1039: IF l_debug_on THEN
1040: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.COMPLETEACTIVITY',WSH_DEBUG_SV.C_PROC_LEVEL);
1041: END IF;
1042: --
1043: wf_engine.completeactivity(
1044: 'WSHNOTIF',

Line 1043: wf_engine.completeactivity(

1039: IF l_debug_on THEN
1040: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.COMPLETEACTIVITY',WSH_DEBUG_SV.C_PROC_LEVEL);
1041: END IF;
1042: --
1043: wf_engine.completeactivity(
1044: 'WSHNOTIF',
1045: to_char(crec.source_header_id)||'-'|| crec.source_code||'-'||l_wf_contact_name,
1046: 'WAIT_FOR_SHIP_CONFIRM_EVENT',
1047: null);

Line 1139: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.ITEMSTATUS',WSH_DEBUG_SV.C_PROC_LEVEL);

1135: --
1136: -- Debug Statements
1137: --
1138: IF l_debug_on THEN
1139: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.ITEMSTATUS',WSH_DEBUG_SV.C_PROC_LEVEL);
1140: END IF;
1141: --
1142: Wf_Engine.ItemStatus(
1143: 'WSHNOTIF',

Line 1142: Wf_Engine.ItemStatus(

1138: IF l_debug_on THEN
1139: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_ENGINE.ITEMSTATUS',WSH_DEBUG_SV.C_PROC_LEVEL);
1140: END IF;
1141: --
1142: Wf_Engine.ItemStatus(
1143: 'WSHNOTIF',
1144: to_char(p_source_header_id)||'-'||p_source_code||'-'||p_contact_name,
1145: l_status,
1146: l_result);