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 WSH_DEBUG_SV

Line 53: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

49: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
50: --
51: IF l_debug_on IS NULL
52: THEN
53: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
54: END IF;
55: --
56: IF l_debug_on THEN
57: WSH_DEBUG_SV.push(l_module_name);

Line 57: WSH_DEBUG_SV.push(l_module_name);

53: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
54: END IF;
55: --
56: IF l_debug_on THEN
57: WSH_DEBUG_SV.push(l_module_name);
58: --
59: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_HEADER_ID',P_SOURCE_HEADER_ID);
60: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
61: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_NUMBER',P_ORDER_NUMBER);

Line 59: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_HEADER_ID',P_SOURCE_HEADER_ID);

55: --
56: IF l_debug_on THEN
57: WSH_DEBUG_SV.push(l_module_name);
58: --
59: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_HEADER_ID',P_SOURCE_HEADER_ID);
60: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
61: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_NUMBER',P_ORDER_NUMBER);
62: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_TYPE',P_CONTACT_TYPE);
63: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_NAME',P_CONTACT_NAME);

Line 60: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);

56: IF l_debug_on THEN
57: WSH_DEBUG_SV.push(l_module_name);
58: --
59: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_HEADER_ID',P_SOURCE_HEADER_ID);
60: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
61: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_NUMBER',P_ORDER_NUMBER);
62: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_TYPE',P_CONTACT_TYPE);
63: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_NAME',P_CONTACT_NAME);
64: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_ID',P_CONTACT_ID);

Line 61: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_NUMBER',P_ORDER_NUMBER);

57: WSH_DEBUG_SV.push(l_module_name);
58: --
59: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_HEADER_ID',P_SOURCE_HEADER_ID);
60: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
61: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_NUMBER',P_ORDER_NUMBER);
62: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_TYPE',P_CONTACT_TYPE);
63: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_NAME',P_CONTACT_NAME);
64: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_ID',P_CONTACT_ID);
65: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_LAST_NAME',P_CONTACT_LAST_NAME);

Line 62: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_TYPE',P_CONTACT_TYPE);

58: --
59: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_HEADER_ID',P_SOURCE_HEADER_ID);
60: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
61: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_NUMBER',P_ORDER_NUMBER);
62: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_TYPE',P_CONTACT_TYPE);
63: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_NAME',P_CONTACT_NAME);
64: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_ID',P_CONTACT_ID);
65: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_LAST_NAME',P_CONTACT_LAST_NAME);
66: WSH_DEBUG_SV.log(l_module_name,'P_SHIPPED_LINES',P_SHIPPED_LINES);

Line 63: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_NAME',P_CONTACT_NAME);

59: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_HEADER_ID',P_SOURCE_HEADER_ID);
60: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
61: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_NUMBER',P_ORDER_NUMBER);
62: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_TYPE',P_CONTACT_TYPE);
63: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_NAME',P_CONTACT_NAME);
64: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_ID',P_CONTACT_ID);
65: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_LAST_NAME',P_CONTACT_LAST_NAME);
66: WSH_DEBUG_SV.log(l_module_name,'P_SHIPPED_LINES',P_SHIPPED_LINES);
67: WSH_DEBUG_SV.log(l_module_name,'P_BACKORDERED_LINES',P_BACKORDERED_LINES);

Line 64: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_ID',P_CONTACT_ID);

60: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
61: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_NUMBER',P_ORDER_NUMBER);
62: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_TYPE',P_CONTACT_TYPE);
63: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_NAME',P_CONTACT_NAME);
64: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_ID',P_CONTACT_ID);
65: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_LAST_NAME',P_CONTACT_LAST_NAME);
66: WSH_DEBUG_SV.log(l_module_name,'P_SHIPPED_LINES',P_SHIPPED_LINES);
67: WSH_DEBUG_SV.log(l_module_name,'P_BACKORDERED_LINES',P_BACKORDERED_LINES);
68: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_NOTIF_DATE',P_SHIP_NOTIF_DATE);

Line 65: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_LAST_NAME',P_CONTACT_LAST_NAME);

61: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_NUMBER',P_ORDER_NUMBER);
62: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_TYPE',P_CONTACT_TYPE);
63: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_NAME',P_CONTACT_NAME);
64: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_ID',P_CONTACT_ID);
65: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_LAST_NAME',P_CONTACT_LAST_NAME);
66: WSH_DEBUG_SV.log(l_module_name,'P_SHIPPED_LINES',P_SHIPPED_LINES);
67: WSH_DEBUG_SV.log(l_module_name,'P_BACKORDERED_LINES',P_BACKORDERED_LINES);
68: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_NOTIF_DATE',P_SHIP_NOTIF_DATE);
69: WSH_DEBUG_SV.log(l_module_name,'P_BO_NOTIF_DATE',P_BO_NOTIF_DATE);

Line 66: WSH_DEBUG_SV.log(l_module_name,'P_SHIPPED_LINES',P_SHIPPED_LINES);

62: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_TYPE',P_CONTACT_TYPE);
63: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_NAME',P_CONTACT_NAME);
64: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_ID',P_CONTACT_ID);
65: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_LAST_NAME',P_CONTACT_LAST_NAME);
66: WSH_DEBUG_SV.log(l_module_name,'P_SHIPPED_LINES',P_SHIPPED_LINES);
67: WSH_DEBUG_SV.log(l_module_name,'P_BACKORDERED_LINES',P_BACKORDERED_LINES);
68: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_NOTIF_DATE',P_SHIP_NOTIF_DATE);
69: WSH_DEBUG_SV.log(l_module_name,'P_BO_NOTIF_DATE',P_BO_NOTIF_DATE);
70: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);

Line 67: WSH_DEBUG_SV.log(l_module_name,'P_BACKORDERED_LINES',P_BACKORDERED_LINES);

63: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_NAME',P_CONTACT_NAME);
64: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_ID',P_CONTACT_ID);
65: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_LAST_NAME',P_CONTACT_LAST_NAME);
66: WSH_DEBUG_SV.log(l_module_name,'P_SHIPPED_LINES',P_SHIPPED_LINES);
67: WSH_DEBUG_SV.log(l_module_name,'P_BACKORDERED_LINES',P_BACKORDERED_LINES);
68: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_NOTIF_DATE',P_SHIP_NOTIF_DATE);
69: WSH_DEBUG_SV.log(l_module_name,'P_BO_NOTIF_DATE',P_BO_NOTIF_DATE);
70: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
71: WSH_DEBUG_SV.log(l_module_name,'P_ITEM_TYPE',P_ITEM_TYPE);

Line 68: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_NOTIF_DATE',P_SHIP_NOTIF_DATE);

64: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_ID',P_CONTACT_ID);
65: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_LAST_NAME',P_CONTACT_LAST_NAME);
66: WSH_DEBUG_SV.log(l_module_name,'P_SHIPPED_LINES',P_SHIPPED_LINES);
67: WSH_DEBUG_SV.log(l_module_name,'P_BACKORDERED_LINES',P_BACKORDERED_LINES);
68: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_NOTIF_DATE',P_SHIP_NOTIF_DATE);
69: WSH_DEBUG_SV.log(l_module_name,'P_BO_NOTIF_DATE',P_BO_NOTIF_DATE);
70: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
71: WSH_DEBUG_SV.log(l_module_name,'P_ITEM_TYPE',P_ITEM_TYPE);
72: END IF;

Line 69: WSH_DEBUG_SV.log(l_module_name,'P_BO_NOTIF_DATE',P_BO_NOTIF_DATE);

65: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_LAST_NAME',P_CONTACT_LAST_NAME);
66: WSH_DEBUG_SV.log(l_module_name,'P_SHIPPED_LINES',P_SHIPPED_LINES);
67: WSH_DEBUG_SV.log(l_module_name,'P_BACKORDERED_LINES',P_BACKORDERED_LINES);
68: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_NOTIF_DATE',P_SHIP_NOTIF_DATE);
69: WSH_DEBUG_SV.log(l_module_name,'P_BO_NOTIF_DATE',P_BO_NOTIF_DATE);
70: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
71: WSH_DEBUG_SV.log(l_module_name,'P_ITEM_TYPE',P_ITEM_TYPE);
72: END IF;
73: --

Line 70: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);

66: WSH_DEBUG_SV.log(l_module_name,'P_SHIPPED_LINES',P_SHIPPED_LINES);
67: WSH_DEBUG_SV.log(l_module_name,'P_BACKORDERED_LINES',P_BACKORDERED_LINES);
68: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_NOTIF_DATE',P_SHIP_NOTIF_DATE);
69: WSH_DEBUG_SV.log(l_module_name,'P_BO_NOTIF_DATE',P_BO_NOTIF_DATE);
70: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
71: WSH_DEBUG_SV.log(l_module_name,'P_ITEM_TYPE',P_ITEM_TYPE);
72: END IF;
73: --
74: --

Line 71: WSH_DEBUG_SV.log(l_module_name,'P_ITEM_TYPE',P_ITEM_TYPE);

67: WSH_DEBUG_SV.log(l_module_name,'P_BACKORDERED_LINES',P_BACKORDERED_LINES);
68: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_NOTIF_DATE',P_SHIP_NOTIF_DATE);
69: WSH_DEBUG_SV.log(l_module_name,'P_BO_NOTIF_DATE',P_BO_NOTIF_DATE);
70: WSH_DEBUG_SV.log(l_module_name,'P_WORKFLOW_PROCESS',P_WORKFLOW_PROCESS);
71: WSH_DEBUG_SV.log(l_module_name,'P_ITEM_TYPE',P_ITEM_TYPE);
72: END IF;
73: --
74: --
75: -- Debug Statements

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 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 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 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 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 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 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 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 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 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 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 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 229: WSH_DEBUG_SV.pop(l_module_name);

225: --
226: -- Debug Statements
227: --
228: IF l_debug_on THEN
229: WSH_DEBUG_SV.pop(l_module_name);
230: END IF;
231: --
232: exception
233: when others then

Line 238: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_CORE.CONTEXT',WSH_DEBUG_SV.C_PROC_LEVEL);

234: --
235: -- Debug Statements
236: --
237: IF l_debug_on THEN
238: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_CORE.CONTEXT',WSH_DEBUG_SV.C_PROC_LEVEL);
239: END IF;
240: --
241: wf_core.context('WSHNOTIF','StartProcess',
242: to_char(p_source_header_id),

Line 251: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

247: --
248: -- Debug Statements
249: --
250: IF l_debug_on THEN
251: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
252: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
253: END IF;
254: --
255: raise;

Line 252: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

248: -- Debug Statements
249: --
250: IF l_debug_on THEN
251: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
252: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
253: END IF;
254: --
255: raise;
256: END Start_Process;

Line 349: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

345: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
346: --
347: IF l_debug_on IS NULL
348: THEN
349: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
350: END IF;
351: --
352: IF l_debug_on THEN
353: WSH_DEBUG_SV.push(l_module_name);

Line 353: WSH_DEBUG_SV.push(l_module_name);

349: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
350: END IF;
351: --
352: IF l_debug_on THEN
353: WSH_DEBUG_SV.push(l_module_name);
354: --
355: WSH_DEBUG_SV.log(l_module_name,'ITEMTYPE',ITEMTYPE);
356: WSH_DEBUG_SV.log(l_module_name,'ITEMKEY',ITEMKEY);
357: WSH_DEBUG_SV.log(l_module_name,'ACTID',ACTID);

Line 355: WSH_DEBUG_SV.log(l_module_name,'ITEMTYPE',ITEMTYPE);

351: --
352: IF l_debug_on THEN
353: WSH_DEBUG_SV.push(l_module_name);
354: --
355: WSH_DEBUG_SV.log(l_module_name,'ITEMTYPE',ITEMTYPE);
356: WSH_DEBUG_SV.log(l_module_name,'ITEMKEY',ITEMKEY);
357: WSH_DEBUG_SV.log(l_module_name,'ACTID',ACTID);
358: WSH_DEBUG_SV.log(l_module_name,'FUNCMODE',FUNCMODE);
359: WSH_DEBUG_SV.log(l_module_name,'RESULTOUT',RESULTOUT);

Line 356: WSH_DEBUG_SV.log(l_module_name,'ITEMKEY',ITEMKEY);

352: IF l_debug_on THEN
353: WSH_DEBUG_SV.push(l_module_name);
354: --
355: WSH_DEBUG_SV.log(l_module_name,'ITEMTYPE',ITEMTYPE);
356: WSH_DEBUG_SV.log(l_module_name,'ITEMKEY',ITEMKEY);
357: WSH_DEBUG_SV.log(l_module_name,'ACTID',ACTID);
358: WSH_DEBUG_SV.log(l_module_name,'FUNCMODE',FUNCMODE);
359: WSH_DEBUG_SV.log(l_module_name,'RESULTOUT',RESULTOUT);
360: END IF;

Line 357: WSH_DEBUG_SV.log(l_module_name,'ACTID',ACTID);

353: WSH_DEBUG_SV.push(l_module_name);
354: --
355: WSH_DEBUG_SV.log(l_module_name,'ITEMTYPE',ITEMTYPE);
356: WSH_DEBUG_SV.log(l_module_name,'ITEMKEY',ITEMKEY);
357: WSH_DEBUG_SV.log(l_module_name,'ACTID',ACTID);
358: WSH_DEBUG_SV.log(l_module_name,'FUNCMODE',FUNCMODE);
359: WSH_DEBUG_SV.log(l_module_name,'RESULTOUT',RESULTOUT);
360: END IF;
361: --

Line 358: WSH_DEBUG_SV.log(l_module_name,'FUNCMODE',FUNCMODE);

354: --
355: WSH_DEBUG_SV.log(l_module_name,'ITEMTYPE',ITEMTYPE);
356: WSH_DEBUG_SV.log(l_module_name,'ITEMKEY',ITEMKEY);
357: WSH_DEBUG_SV.log(l_module_name,'ACTID',ACTID);
358: WSH_DEBUG_SV.log(l_module_name,'FUNCMODE',FUNCMODE);
359: WSH_DEBUG_SV.log(l_module_name,'RESULTOUT',RESULTOUT);
360: END IF;
361: --
362: if (funcmode = 'RUN') then

Line 359: WSH_DEBUG_SV.log(l_module_name,'RESULTOUT',RESULTOUT);

355: WSH_DEBUG_SV.log(l_module_name,'ITEMTYPE',ITEMTYPE);
356: WSH_DEBUG_SV.log(l_module_name,'ITEMKEY',ITEMKEY);
357: WSH_DEBUG_SV.log(l_module_name,'ACTID',ACTID);
358: WSH_DEBUG_SV.log(l_module_name,'FUNCMODE',FUNCMODE);
359: WSH_DEBUG_SV.log(l_module_name,'RESULTOUT',RESULTOUT);
360: END IF;
361: --
362: if (funcmode = 'RUN') then
363: --

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 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 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 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 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 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 477: WSH_DEBUG_SV.log(l_module_name,'resultout',resultout);

473: --
474: -- Debug Statements
475: --
476: IF l_debug_on THEN
477: WSH_DEBUG_SV.log(l_module_name,'resultout',resultout);
478: WSH_DEBUG_SV.pop(l_module_name);
479: END IF;
480: --
481: return;

Line 478: WSH_DEBUG_SV.pop(l_module_name);

474: -- Debug Statements
475: --
476: IF l_debug_on THEN
477: WSH_DEBUG_SV.log(l_module_name,'resultout',resultout);
478: WSH_DEBUG_SV.pop(l_module_name);
479: END IF;
480: --
481: return;
482: END Order_Status;

Line 533: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

529: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
530: --
531: IF l_debug_on IS NULL
532: THEN
533: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
534: END IF;
535: --
536: IF l_debug_on THEN
537: WSH_DEBUG_SV.push(l_module_name);

Line 537: WSH_DEBUG_SV.push(l_module_name);

533: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
534: END IF;
535: --
536: IF l_debug_on THEN
537: WSH_DEBUG_SV.push(l_module_name);
538: --
539: WSH_DEBUG_SV.log(l_module_name,'ITEMTYPE',ITEMTYPE);
540: WSH_DEBUG_SV.log(l_module_name,'ITEMKEY',ITEMKEY);
541: WSH_DEBUG_SV.log(l_module_name,'ACTID',ACTID);

Line 539: WSH_DEBUG_SV.log(l_module_name,'ITEMTYPE',ITEMTYPE);

535: --
536: IF l_debug_on THEN
537: WSH_DEBUG_SV.push(l_module_name);
538: --
539: WSH_DEBUG_SV.log(l_module_name,'ITEMTYPE',ITEMTYPE);
540: WSH_DEBUG_SV.log(l_module_name,'ITEMKEY',ITEMKEY);
541: WSH_DEBUG_SV.log(l_module_name,'ACTID',ACTID);
542: WSH_DEBUG_SV.log(l_module_name,'FUNCMODE',FUNCMODE);
543: WSH_DEBUG_SV.log(l_module_name,'RESULTOUT',RESULTOUT);

Line 540: WSH_DEBUG_SV.log(l_module_name,'ITEMKEY',ITEMKEY);

536: IF l_debug_on THEN
537: WSH_DEBUG_SV.push(l_module_name);
538: --
539: WSH_DEBUG_SV.log(l_module_name,'ITEMTYPE',ITEMTYPE);
540: WSH_DEBUG_SV.log(l_module_name,'ITEMKEY',ITEMKEY);
541: WSH_DEBUG_SV.log(l_module_name,'ACTID',ACTID);
542: WSH_DEBUG_SV.log(l_module_name,'FUNCMODE',FUNCMODE);
543: WSH_DEBUG_SV.log(l_module_name,'RESULTOUT',RESULTOUT);
544: END IF;

Line 541: WSH_DEBUG_SV.log(l_module_name,'ACTID',ACTID);

537: WSH_DEBUG_SV.push(l_module_name);
538: --
539: WSH_DEBUG_SV.log(l_module_name,'ITEMTYPE',ITEMTYPE);
540: WSH_DEBUG_SV.log(l_module_name,'ITEMKEY',ITEMKEY);
541: WSH_DEBUG_SV.log(l_module_name,'ACTID',ACTID);
542: WSH_DEBUG_SV.log(l_module_name,'FUNCMODE',FUNCMODE);
543: WSH_DEBUG_SV.log(l_module_name,'RESULTOUT',RESULTOUT);
544: END IF;
545: --

Line 542: WSH_DEBUG_SV.log(l_module_name,'FUNCMODE',FUNCMODE);

538: --
539: WSH_DEBUG_SV.log(l_module_name,'ITEMTYPE',ITEMTYPE);
540: WSH_DEBUG_SV.log(l_module_name,'ITEMKEY',ITEMKEY);
541: WSH_DEBUG_SV.log(l_module_name,'ACTID',ACTID);
542: WSH_DEBUG_SV.log(l_module_name,'FUNCMODE',FUNCMODE);
543: WSH_DEBUG_SV.log(l_module_name,'RESULTOUT',RESULTOUT);
544: END IF;
545: --
546: if (funcmode = 'RUN') then

Line 543: WSH_DEBUG_SV.log(l_module_name,'RESULTOUT',RESULTOUT);

539: WSH_DEBUG_SV.log(l_module_name,'ITEMTYPE',ITEMTYPE);
540: WSH_DEBUG_SV.log(l_module_name,'ITEMKEY',ITEMKEY);
541: WSH_DEBUG_SV.log(l_module_name,'ACTID',ACTID);
542: WSH_DEBUG_SV.log(l_module_name,'FUNCMODE',FUNCMODE);
543: WSH_DEBUG_SV.log(l_module_name,'RESULTOUT',RESULTOUT);
544: END IF;
545: --
546: if (funcmode = 'RUN') then
547: --

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 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 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 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 614: WSH_DEBUG_SV.log(l_module_name,'resultout',resultout);

610: --
611: -- Debug Statements
612: --
613: IF l_debug_on THEN
614: WSH_DEBUG_SV.log(l_module_name,'resultout',resultout);
615: WSH_DEBUG_SV.pop(l_module_name);
616: END IF;
617: --
618: return;

Line 615: WSH_DEBUG_SV.pop(l_module_name);

611: -- Debug Statements
612: --
613: IF l_debug_on THEN
614: WSH_DEBUG_SV.log(l_module_name,'resultout',resultout);
615: WSH_DEBUG_SV.pop(l_module_name);
616: END IF;
617: --
618: return;
619: END Order_Fulfilled;

Line 656: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

652: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
653: --
654: IF l_debug_on IS NULL
655: THEN
656: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
657: END IF;
658: --
659: IF l_debug_on THEN
660: WSH_DEBUG_SV.push(l_module_name);

Line 660: WSH_DEBUG_SV.push(l_module_name);

656: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
657: END IF;
658: --
659: IF l_debug_on THEN
660: WSH_DEBUG_SV.push(l_module_name);
661: --
662: WSH_DEBUG_SV.log(l_module_name,'DOCUMENT_ID',DOCUMENT_ID);
663: WSH_DEBUG_SV.log(l_module_name,'DISPLAY_TYPE',DISPLAY_TYPE);
664: WSH_DEBUG_SV.log(l_module_name,'DOCUMENT',DOCUMENT);

Line 662: WSH_DEBUG_SV.log(l_module_name,'DOCUMENT_ID',DOCUMENT_ID);

658: --
659: IF l_debug_on THEN
660: WSH_DEBUG_SV.push(l_module_name);
661: --
662: WSH_DEBUG_SV.log(l_module_name,'DOCUMENT_ID',DOCUMENT_ID);
663: WSH_DEBUG_SV.log(l_module_name,'DISPLAY_TYPE',DISPLAY_TYPE);
664: WSH_DEBUG_SV.log(l_module_name,'DOCUMENT',DOCUMENT);
665: WSH_DEBUG_SV.log(l_module_name,'DOCUMENT_TYPE',DOCUMENT_TYPE);
666: END IF;

Line 663: WSH_DEBUG_SV.log(l_module_name,'DISPLAY_TYPE',DISPLAY_TYPE);

659: IF l_debug_on THEN
660: WSH_DEBUG_SV.push(l_module_name);
661: --
662: WSH_DEBUG_SV.log(l_module_name,'DOCUMENT_ID',DOCUMENT_ID);
663: WSH_DEBUG_SV.log(l_module_name,'DISPLAY_TYPE',DISPLAY_TYPE);
664: WSH_DEBUG_SV.log(l_module_name,'DOCUMENT',DOCUMENT);
665: WSH_DEBUG_SV.log(l_module_name,'DOCUMENT_TYPE',DOCUMENT_TYPE);
666: END IF;
667: --

Line 664: WSH_DEBUG_SV.log(l_module_name,'DOCUMENT',DOCUMENT);

660: WSH_DEBUG_SV.push(l_module_name);
661: --
662: WSH_DEBUG_SV.log(l_module_name,'DOCUMENT_ID',DOCUMENT_ID);
663: WSH_DEBUG_SV.log(l_module_name,'DISPLAY_TYPE',DISPLAY_TYPE);
664: WSH_DEBUG_SV.log(l_module_name,'DOCUMENT',DOCUMENT);
665: WSH_DEBUG_SV.log(l_module_name,'DOCUMENT_TYPE',DOCUMENT_TYPE);
666: END IF;
667: --
668: open c_get_itemkey(document_id);

Line 665: WSH_DEBUG_SV.log(l_module_name,'DOCUMENT_TYPE',DOCUMENT_TYPE);

661: --
662: WSH_DEBUG_SV.log(l_module_name,'DOCUMENT_ID',DOCUMENT_ID);
663: WSH_DEBUG_SV.log(l_module_name,'DISPLAY_TYPE',DISPLAY_TYPE);
664: WSH_DEBUG_SV.log(l_module_name,'DOCUMENT',DOCUMENT);
665: WSH_DEBUG_SV.log(l_module_name,'DOCUMENT_TYPE',DOCUMENT_TYPE);
666: END IF;
667: --
668: open c_get_itemkey(document_id);
669: fetch c_get_itemkey

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 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 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 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 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 744: WSH_DEBUG_SV.log(l_module_name,'l_shipped',l_shipped);

740: l_shipped,
741: l_shipped_lines);
742:
743: IF l_debug_on THEN
744: WSH_DEBUG_SV.log(l_module_name,'l_shipped',l_shipped);
745: WSH_DEBUG_SV.log(l_module_name,'l_shipped_lines',l_shipped_lines);
746: END IF;
747:
748: document_type := 'text/plain';

Line 745: WSH_DEBUG_SV.log(l_module_name,'l_shipped_lines',l_shipped_lines);

741: l_shipped_lines);
742:
743: IF l_debug_on THEN
744: WSH_DEBUG_SV.log(l_module_name,'l_shipped',l_shipped);
745: WSH_DEBUG_SV.log(l_module_name,'l_shipped_lines',l_shipped_lines);
746: END IF;
747:
748: document_type := 'text/plain';
749: document := l_shipped_lines;

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 770: WSH_DEBUG_SV.pop(l_module_name);

766: --
767: -- Debug Statements
768: --
769: IF l_debug_on THEN
770: WSH_DEBUG_SV.pop(l_module_name);
771: END IF;
772: --
773: return;
774: END Shipped_Lines;

Line 812: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

808: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
809: --
810: IF l_debug_on IS NULL
811: THEN
812: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
813: END IF;
814: --
815: IF l_debug_on THEN
816: WSH_DEBUG_SV.push(l_module_name);

Line 816: WSH_DEBUG_SV.push(l_module_name);

812: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
813: END IF;
814: --
815: IF l_debug_on THEN
816: WSH_DEBUG_SV.push(l_module_name);
817: --
818: WSH_DEBUG_SV.log(l_module_name,'DOCUMENT_ID',DOCUMENT_ID);
819: WSH_DEBUG_SV.log(l_module_name,'DISPLAY_TYPE',DISPLAY_TYPE);
820: WSH_DEBUG_SV.log(l_module_name,'DOCUMENT',DOCUMENT);

Line 818: WSH_DEBUG_SV.log(l_module_name,'DOCUMENT_ID',DOCUMENT_ID);

814: --
815: IF l_debug_on THEN
816: WSH_DEBUG_SV.push(l_module_name);
817: --
818: WSH_DEBUG_SV.log(l_module_name,'DOCUMENT_ID',DOCUMENT_ID);
819: WSH_DEBUG_SV.log(l_module_name,'DISPLAY_TYPE',DISPLAY_TYPE);
820: WSH_DEBUG_SV.log(l_module_name,'DOCUMENT',DOCUMENT);
821: WSH_DEBUG_SV.log(l_module_name,'DOCUMENT_TYPE',DOCUMENT_TYPE);
822: END IF;

Line 819: WSH_DEBUG_SV.log(l_module_name,'DISPLAY_TYPE',DISPLAY_TYPE);

815: IF l_debug_on THEN
816: WSH_DEBUG_SV.push(l_module_name);
817: --
818: WSH_DEBUG_SV.log(l_module_name,'DOCUMENT_ID',DOCUMENT_ID);
819: WSH_DEBUG_SV.log(l_module_name,'DISPLAY_TYPE',DISPLAY_TYPE);
820: WSH_DEBUG_SV.log(l_module_name,'DOCUMENT',DOCUMENT);
821: WSH_DEBUG_SV.log(l_module_name,'DOCUMENT_TYPE',DOCUMENT_TYPE);
822: END IF;
823: --

Line 820: WSH_DEBUG_SV.log(l_module_name,'DOCUMENT',DOCUMENT);

816: WSH_DEBUG_SV.push(l_module_name);
817: --
818: WSH_DEBUG_SV.log(l_module_name,'DOCUMENT_ID',DOCUMENT_ID);
819: WSH_DEBUG_SV.log(l_module_name,'DISPLAY_TYPE',DISPLAY_TYPE);
820: WSH_DEBUG_SV.log(l_module_name,'DOCUMENT',DOCUMENT);
821: WSH_DEBUG_SV.log(l_module_name,'DOCUMENT_TYPE',DOCUMENT_TYPE);
822: END IF;
823: --
824: open c_get_itemkey(document_id);

Line 821: WSH_DEBUG_SV.log(l_module_name,'DOCUMENT_TYPE',DOCUMENT_TYPE);

817: --
818: WSH_DEBUG_SV.log(l_module_name,'DOCUMENT_ID',DOCUMENT_ID);
819: WSH_DEBUG_SV.log(l_module_name,'DISPLAY_TYPE',DISPLAY_TYPE);
820: WSH_DEBUG_SV.log(l_module_name,'DOCUMENT',DOCUMENT);
821: WSH_DEBUG_SV.log(l_module_name,'DOCUMENT_TYPE',DOCUMENT_TYPE);
822: END IF;
823: --
824: open c_get_itemkey(document_id);
825: fetch c_get_itemkey

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 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 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 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 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 901: WSH_DEBUG_SV.log(l_module_name,'l_backordered',l_backordered);

897: l_backordered,
898: l_backordered_lines);
899:
900: IF l_debug_on THEN
901: WSH_DEBUG_SV.log(l_module_name,'l_backordered',l_backordered);
902: WSH_DEBUG_SV.log(l_module_name,'l_backordered_lines',l_backordered_lines);
903: END IF;
904:
905: document_type := 'text/plain';

Line 902: WSH_DEBUG_SV.log(l_module_name,'l_backordered_lines',l_backordered_lines);

898: l_backordered_lines);
899:
900: IF l_debug_on THEN
901: WSH_DEBUG_SV.log(l_module_name,'l_backordered',l_backordered);
902: WSH_DEBUG_SV.log(l_module_name,'l_backordered_lines',l_backordered_lines);
903: END IF;
904:
905: document_type := 'text/plain';
906: document := l_backordered_lines;

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 927: WSH_DEBUG_SV.pop(l_module_name);

923: --
924: -- Debug Statements
925: --
926: IF l_debug_on THEN
927: WSH_DEBUG_SV.pop(l_module_name);
928: END IF;
929: --
930: return;
931: --

Line 935: WSH_DEBUG_SV.pop(l_module_name);

931: --
932: -- Debug Statements
933: --
934: IF l_debug_on THEN
935: WSH_DEBUG_SV.pop(l_module_name);
936: END IF;
937: --
938: END Backordered_Lines;
939:

Line 978: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

974: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
975: --
976: IF l_debug_on IS NULL
977: THEN
978: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
979: END IF;
980: --
981: IF l_debug_on THEN
982: WSH_DEBUG_SV.push(l_module_name);

Line 982: WSH_DEBUG_SV.push(l_module_name);

978: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
979: END IF;
980: --
981: IF l_debug_on THEN
982: WSH_DEBUG_SV.push(l_module_name);
983: --
984: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
985: END IF;
986: --

Line 984: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);

980: --
981: IF l_debug_on THEN
982: WSH_DEBUG_SV.push(l_module_name);
983: --
984: WSH_DEBUG_SV.log(l_module_name,'P_DELIVERY_ID',P_DELIVERY_ID);
985: END IF;
986: --
987: --
988: -- Debug Statements

Line 991: WSH_DEBUG_SV.logmsg(l_module_name, 'IN PROCEDURE WSH_WF.UPDATE_WORKFLOW FOR DELIVERY '||P_DELIVERY_ID );

987: --
988: -- Debug Statements
989: --
990: IF l_debug_on THEN
991: WSH_DEBUG_SV.logmsg(l_module_name, 'IN PROCEDURE WSH_WF.UPDATE_WORKFLOW FOR DELIVERY '||P_DELIVERY_ID );
992: END IF;
993: --
994: for crec in c_get_item_key(p_delivery_id)
995: loop

Line 1001: WSH_DEBUG_SV.logmsg(l_module_name, 'CALLING WORKFLOW WAIT_FOR_SHIP_CONFIRM_EVENT WITH '|| TO_CHAR ( CREC.SOURCE_HEADER_ID ) ||'-'|| CREC.SOURCE_CODE||'-'||CREC.CONTACT_TYPE||'-'||TO_CHAR ( CREC.CONTACT_ID ) );

997: --
998: -- Debug Statements
999: --
1000: IF l_debug_on THEN
1001: WSH_DEBUG_SV.logmsg(l_module_name, 'CALLING WORKFLOW WAIT_FOR_SHIP_CONFIRM_EVENT WITH '|| TO_CHAR ( CREC.SOURCE_HEADER_ID ) ||'-'|| CREC.SOURCE_CODE||'-'||CREC.CONTACT_TYPE||'-'||TO_CHAR ( CREC.CONTACT_ID ) );
1002: END IF;
1003: --
1004:
1005: l_wf_contact_name := NULL;

Line 1017: WSH_DEBUG_SV.logmsg(l_module_name, 'UNABLE TO FIND THE CONTACT IN WF_USERS' );

1013: --
1014: -- Debug Statements
1015: --
1016: IF l_debug_on THEN
1017: WSH_DEBUG_SV.logmsg(l_module_name, 'UNABLE TO FIND THE CONTACT IN WF_USERS' );
1018: END IF;
1019: --
1020: ELSE
1021: -- See if the workflow instance is exisiting

Line 1033: WSH_DEBUG_SV.logmsg(l_module_name, 'WORKFLOW INSTANCE EXISTS' );

1029: --
1030: -- Debug Statements
1031: --
1032: IF l_debug_on THEN
1033: WSH_DEBUG_SV.logmsg(l_module_name, 'WORKFLOW INSTANCE EXISTS' );
1034: END IF;
1035: --
1036: --
1037: -- Debug Statements

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 1054: WSH_DEBUG_SV.logmsg(l_module_name, 'WORKFLOW BLOCK REMOVED SUCCESSFULLY' );

1050: --
1051: -- Debug Statements
1052: --
1053: IF l_debug_on THEN
1054: WSH_DEBUG_SV.logmsg(l_module_name, 'WORKFLOW BLOCK REMOVED SUCCESSFULLY' );
1055: END IF;
1056: --
1057: END IF;
1058: exception

Line 1064: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR WHILE UNBLOCKING THE WORKFLOW BLOCK WAIT_FOR_SHIP_CONFIRM_EVENT' );

1060: --
1061: -- Debug Statements
1062: --
1063: IF l_debug_on THEN
1064: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR WHILE UNBLOCKING THE WORKFLOW BLOCK WAIT_FOR_SHIP_CONFIRM_EVENT' );
1065: END IF;
1066: --
1067: end;
1068: end loop;

Line 1073: WSH_DEBUG_SV.pop(l_module_name);

1069: --
1070: -- Debug Statements
1071: --
1072: IF l_debug_on THEN
1073: WSH_DEBUG_SV.pop(l_module_name);
1074: END IF;
1075: --
1076: EXCEPTION
1077: WHEN OTHERS THEN

Line 1082: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_WF.UPDATE_WORKFLOW' );

1078: --
1079: -- Debug Statements
1080: --
1081: IF l_debug_on THEN
1082: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_WF.UPDATE_WORKFLOW' );
1083: END IF;
1084: --
1085: --
1086: -- Debug Statements

Line 1089: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1085: --
1086: -- Debug Statements
1087: --
1088: IF l_debug_on THEN
1089: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1090: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1091: END IF;
1092: --
1093: END Update_Workflow;

Line 1090: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

1086: -- Debug Statements
1087: --
1088: IF l_debug_on THEN
1089: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1090: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1091: END IF;
1092: --
1093: END Update_Workflow;
1094:

Line 1116: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1112: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1113: --
1114: IF l_debug_on IS NULL
1115: THEN
1116: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1117: END IF;
1118: --
1119: IF l_debug_on THEN
1120: WSH_DEBUG_SV.push(l_module_name);

Line 1120: WSH_DEBUG_SV.push(l_module_name);

1116: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1117: END IF;
1118: --
1119: IF l_debug_on THEN
1120: WSH_DEBUG_SV.push(l_module_name);
1121: --
1122: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_HEADER_ID',P_SOURCE_HEADER_ID);
1123: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
1124: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_NAME',P_CONTACT_NAME);

Line 1122: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_HEADER_ID',P_SOURCE_HEADER_ID);

1118: --
1119: IF l_debug_on THEN
1120: WSH_DEBUG_SV.push(l_module_name);
1121: --
1122: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_HEADER_ID',P_SOURCE_HEADER_ID);
1123: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
1124: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_NAME',P_CONTACT_NAME);
1125: END IF;
1126: --

Line 1123: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);

1119: IF l_debug_on THEN
1120: WSH_DEBUG_SV.push(l_module_name);
1121: --
1122: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_HEADER_ID',P_SOURCE_HEADER_ID);
1123: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
1124: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_NAME',P_CONTACT_NAME);
1125: END IF;
1126: --
1127: --

Line 1124: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_NAME',P_CONTACT_NAME);

1120: WSH_DEBUG_SV.push(l_module_name);
1121: --
1122: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_HEADER_ID',P_SOURCE_HEADER_ID);
1123: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
1124: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_NAME',P_CONTACT_NAME);
1125: END IF;
1126: --
1127: --
1128: -- Debug Statements

Line 1131: WSH_DEBUG_SV.logmsg(l_module_name, 'WSH_WF.CHECK_ITEM_INSTANCE : CALLING WITH ITEM KEY '|| TO_CHAR ( P_SOURCE_HEADER_ID ) ||'-'||P_SOURCE_CODE||'-'||P_CONTACT_NAME );

1127: --
1128: -- Debug Statements
1129: --
1130: IF l_debug_on THEN
1131: WSH_DEBUG_SV.logmsg(l_module_name, 'WSH_WF.CHECK_ITEM_INSTANCE : CALLING WITH ITEM KEY '|| TO_CHAR ( P_SOURCE_HEADER_ID ) ||'-'||P_SOURCE_CODE||'-'||P_CONTACT_NAME );
1132: END IF;
1133: --
1134:
1135: --

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 1154: WSH_DEBUG_SV.logmsg(l_module_name, 'WORKFLOW ITEM INSTANCE IS '||L_STATUS );

1150: --
1151: -- Debug Statements
1152: --
1153: IF l_debug_on THEN
1154: WSH_DEBUG_SV.logmsg(l_module_name, 'WORKFLOW ITEM INSTANCE IS '||L_STATUS );
1155: END IF;
1156: --
1157: ELSE
1158: p_result := FALSE;

Line 1163: WSH_DEBUG_SV.logmsg(l_module_name, 'WORKFLOW ITEM INSTANCE IS '||L_STATUS );

1159: --
1160: -- Debug Statements
1161: --
1162: IF l_debug_on THEN
1163: WSH_DEBUG_SV.logmsg(l_module_name, 'WORKFLOW ITEM INSTANCE IS '||L_STATUS );
1164: END IF;
1165: --
1166: END IF;
1167:

Line 1172: WSH_DEBUG_SV.pop(l_module_name);

1168: --
1169: -- Debug Statements
1170: --
1171: IF l_debug_on THEN
1172: WSH_DEBUG_SV.pop(l_module_name);
1173: END IF;
1174: --
1175: return;
1176: --

Line 1180: WSH_DEBUG_SV.pop(l_module_name);

1176: --
1177: -- Debug Statements
1178: --
1179: IF l_debug_on THEN
1180: WSH_DEBUG_SV.pop(l_module_name);
1181: END IF;
1182: --
1183: EXCEPTION
1184: WHEN OTHERS THEN

Line 1190: WSH_DEBUG_SV.logmsg(l_module_name, 'WORKFLOW ITEM INSTANCE DOESN''T EXIST' );

1186: --
1187: -- Debug Statements
1188: --
1189: IF l_debug_on THEN
1190: WSH_DEBUG_SV.logmsg(l_module_name, 'WORKFLOW ITEM INSTANCE DOESN''T EXIST' );
1191: END IF;
1192: --
1193: --
1194: -- Debug Statements

Line 1197: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1193: --
1194: -- Debug Statements
1195: --
1196: IF l_debug_on THEN
1197: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1198: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1199: END IF;
1200: --
1201: END Check_Item_Instance;

Line 1198: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

1194: -- Debug Statements
1195: --
1196: IF l_debug_on THEN
1197: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1198: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1199: END IF;
1200: --
1201: END Check_Item_Instance;
1202:

Line 1232: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1228: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1229: --
1230: IF l_debug_on IS NULL
1231: THEN
1232: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1233: END IF;
1234: --
1235: IF l_debug_on THEN
1236: WSH_DEBUG_SV.push(l_module_name);

Line 1236: WSH_DEBUG_SV.push(l_module_name);

1232: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1233: END IF;
1234: --
1235: IF l_debug_on THEN
1236: WSH_DEBUG_SV.push(l_module_name);
1237: --
1238: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_HEADER_ID',P_SOURCE_HEADER_ID);
1239: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
1240: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_NUMBER',P_ORDER_NUMBER);

Line 1238: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_HEADER_ID',P_SOURCE_HEADER_ID);

1234: --
1235: IF l_debug_on THEN
1236: WSH_DEBUG_SV.push(l_module_name);
1237: --
1238: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_HEADER_ID',P_SOURCE_HEADER_ID);
1239: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
1240: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_NUMBER',P_ORDER_NUMBER);
1241: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_TYPE',P_CONTACT_TYPE);
1242: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_ID',P_CONTACT_ID);

Line 1239: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);

1235: IF l_debug_on THEN
1236: WSH_DEBUG_SV.push(l_module_name);
1237: --
1238: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_HEADER_ID',P_SOURCE_HEADER_ID);
1239: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
1240: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_NUMBER',P_ORDER_NUMBER);
1241: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_TYPE',P_CONTACT_TYPE);
1242: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_ID',P_CONTACT_ID);
1243: END IF;

Line 1240: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_NUMBER',P_ORDER_NUMBER);

1236: WSH_DEBUG_SV.push(l_module_name);
1237: --
1238: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_HEADER_ID',P_SOURCE_HEADER_ID);
1239: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
1240: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_NUMBER',P_ORDER_NUMBER);
1241: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_TYPE',P_CONTACT_TYPE);
1242: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_ID',P_CONTACT_ID);
1243: END IF;
1244: --

Line 1241: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_TYPE',P_CONTACT_TYPE);

1237: --
1238: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_HEADER_ID',P_SOURCE_HEADER_ID);
1239: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
1240: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_NUMBER',P_ORDER_NUMBER);
1241: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_TYPE',P_CONTACT_TYPE);
1242: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_ID',P_CONTACT_ID);
1243: END IF;
1244: --
1245: l_result := FALSE;

Line 1242: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_ID',P_CONTACT_ID);

1238: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_HEADER_ID',P_SOURCE_HEADER_ID);
1239: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
1240: WSH_DEBUG_SV.log(l_module_name,'P_ORDER_NUMBER',P_ORDER_NUMBER);
1241: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_TYPE',P_CONTACT_TYPE);
1242: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_ID',P_CONTACT_ID);
1243: END IF;
1244: --
1245: l_result := FALSE;
1246: --

Line 1250: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CUSTOM_PUB.START_WORKFLOW',WSH_DEBUG_SV.C_PROC_LEVEL);

1246: --
1247: -- Debug Statements
1248: --
1249: IF l_debug_on THEN
1250: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CUSTOM_PUB.START_WORKFLOW',WSH_DEBUG_SV.C_PROC_LEVEL);
1251: END IF;
1252: --
1253: WSH_CUSTOM_PUB.Start_Workflow(
1254: p_source_header_id,

Line 1272: WSH_DEBUG_SV.logmsg(l_module_name, 'WORKFLOW INSTANCE ALREADY EXISTING FOR THE COMBINATION' );

1268: --
1269: -- Debug Statements
1270: --
1271: IF l_debug_on THEN
1272: WSH_DEBUG_SV.logmsg(l_module_name, 'WORKFLOW INSTANCE ALREADY EXISTING FOR THE COMBINATION' );
1273: END IF;
1274: --
1275: ELSE
1276: --

Line 1280: WSH_DEBUG_SV.logmsg(l_module_name, 'WORKFLOW INSTANCE NOT STARTED DUE TO A PREVIOUS ERROR FOR THE COMBINATION' );

1276: --
1277: -- Debug Statements
1278: --
1279: IF l_debug_on THEN
1280: WSH_DEBUG_SV.logmsg(l_module_name, 'WORKFLOW INSTANCE NOT STARTED DUE TO A PREVIOUS ERROR FOR THE COMBINATION' );
1281: END IF;
1282: --
1283: END IF;
1284: l_cached_result := TRUE;

Line 1293: WSH_DEBUG_SV.logmsg(l_module_name, 'WORKFLOW INSTANCE NOT FOUND IN THE CACHED TABLE' );

1289: --
1290: -- Debug Statements
1291: --
1292: IF l_debug_on THEN
1293: WSH_DEBUG_SV.logmsg(l_module_name, 'WORKFLOW INSTANCE NOT FOUND IN THE CACHED TABLE' );
1294: END IF;
1295: --
1296: l_count := g_wf_table.COUNT + 1;
1297:

Line 1343: WSH_DEBUG_SV.logmsg(l_module_name, 'STARTED WORKFLOW FOR '||P_SOURCE_HEADER_ID||'-'||P_SOURCE_CODE||'-'||L_WF_CONTACT_NAME );

1339: --
1340: -- Debug Statements
1341: --
1342: IF l_debug_on THEN
1343: WSH_DEBUG_SV.logmsg(l_module_name, 'STARTED WORKFLOW FOR '||P_SOURCE_HEADER_ID||'-'||P_SOURCE_CODE||'-'||L_WF_CONTACT_NAME );
1344: END IF;
1345: --
1346: g_wf_table(l_count).wf_started := TRUE;
1347: END IF; -- l_wf_active

Line 1359: WSH_DEBUG_SV.logmsg(l_module_name, 'WSH_CUSTOM_PUB.START_WORKFLOW RETURNED FALSE' );

1355: --
1356: -- Debug Statements
1357: --
1358: IF l_debug_on THEN
1359: WSH_DEBUG_SV.logmsg(l_module_name, 'WSH_CUSTOM_PUB.START_WORKFLOW RETURNED FALSE' );
1360: END IF;
1361: --
1362: END IF; -- l_result = TRUE;
1363: --

Line 1367: WSH_DEBUG_SV.pop(l_module_name);

1363: --
1364: -- Debug Statements
1365: --
1366: IF l_debug_on THEN
1367: WSH_DEBUG_SV.pop(l_module_name);
1368: END IF;
1369: --
1370: return;
1371: --

Line 1379: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_WF.START_WORKFLOW' );

1375: --
1376: -- Debug Statements
1377: --
1378: IF l_debug_on THEN
1379: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_WF.START_WORKFLOW' );
1380: END IF;
1381: --
1382: --
1383: -- Debug Statements

Line 1386: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1382: --
1383: -- Debug Statements
1384: --
1385: IF l_debug_on THEN
1386: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1387: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1388: END IF;
1389: --
1390: END Start_Workflow;

Line 1387: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

1383: -- Debug Statements
1384: --
1385: IF l_debug_on THEN
1386: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1387: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1388: END IF;
1389: --
1390: END Start_Workflow;
1391:

Line 1450: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1446: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1447: --
1448: IF l_debug_on IS NULL
1449: THEN
1450: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1451: END IF;
1452: --
1453: IF l_debug_on THEN
1454: WSH_DEBUG_SV.push(l_module_name);

Line 1454: WSH_DEBUG_SV.push(l_module_name);

1450: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1451: END IF;
1452: --
1453: IF l_debug_on THEN
1454: WSH_DEBUG_SV.push(l_module_name);
1455: --
1456: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_TYPE',P_CONTACT_TYPE);
1457: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_ID',P_CONTACT_ID);
1458: END IF;

Line 1456: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_TYPE',P_CONTACT_TYPE);

1452: --
1453: IF l_debug_on THEN
1454: WSH_DEBUG_SV.push(l_module_name);
1455: --
1456: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_TYPE',P_CONTACT_TYPE);
1457: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_ID',P_CONTACT_ID);
1458: END IF;
1459: --
1460: OPEN get_party(p_contact_type,p_contact_id);

Line 1457: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_ID',P_CONTACT_ID);

1453: IF l_debug_on THEN
1454: WSH_DEBUG_SV.push(l_module_name);
1455: --
1456: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_TYPE',P_CONTACT_TYPE);
1457: WSH_DEBUG_SV.log(l_module_name,'P_CONTACT_ID',P_CONTACT_ID);
1458: END IF;
1459: --
1460: OPEN get_party(p_contact_type,p_contact_id);
1461: FETCH get_party

Line 1477: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_DIRECTORY.GETROLEINFO',WSH_DEBUG_SV.C_PROC_LEVEL);

1473: --
1474: -- Debug Statements
1475: --
1476: IF l_debug_on THEN
1477: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WF_DIRECTORY.GETROLEINFO',WSH_DEBUG_SV.C_PROC_LEVEL);
1478: END IF;
1479: --
1480: wf_directory.getroleinfo(
1481: p_wf_contact_name,

Line 1489: WSH_DEBUG_SV.log(l_module_name,'l_wf_contact_last_name',l_wf_contact_last_name);

1485: l_language,
1486: l_territory);
1487:
1488: IF l_debug_on THEN
1489: WSH_DEBUG_SV.log(l_module_name,'l_wf_contact_last_name',l_wf_contact_last_name);
1490: WSH_DEBUG_SV.log(l_module_name,'l_email_address',l_email_address);
1491: WSH_DEBUG_SV.log(l_module_name,'l_notification_preference',l_notification_preference);
1492: WSH_DEBUG_SV.log(l_module_name,'l_language',l_language);
1493: WSH_DEBUG_SV.log(l_module_name,'l_territory',l_territory);

Line 1490: WSH_DEBUG_SV.log(l_module_name,'l_email_address',l_email_address);

1486: l_territory);
1487:
1488: IF l_debug_on THEN
1489: WSH_DEBUG_SV.log(l_module_name,'l_wf_contact_last_name',l_wf_contact_last_name);
1490: WSH_DEBUG_SV.log(l_module_name,'l_email_address',l_email_address);
1491: WSH_DEBUG_SV.log(l_module_name,'l_notification_preference',l_notification_preference);
1492: WSH_DEBUG_SV.log(l_module_name,'l_language',l_language);
1493: WSH_DEBUG_SV.log(l_module_name,'l_territory',l_territory);
1494: END IF;

Line 1491: WSH_DEBUG_SV.log(l_module_name,'l_notification_preference',l_notification_preference);

1487:
1488: IF l_debug_on THEN
1489: WSH_DEBUG_SV.log(l_module_name,'l_wf_contact_last_name',l_wf_contact_last_name);
1490: WSH_DEBUG_SV.log(l_module_name,'l_email_address',l_email_address);
1491: WSH_DEBUG_SV.log(l_module_name,'l_notification_preference',l_notification_preference);
1492: WSH_DEBUG_SV.log(l_module_name,'l_language',l_language);
1493: WSH_DEBUG_SV.log(l_module_name,'l_territory',l_territory);
1494: END IF;
1495:

Line 1492: WSH_DEBUG_SV.log(l_module_name,'l_language',l_language);

1488: IF l_debug_on THEN
1489: WSH_DEBUG_SV.log(l_module_name,'l_wf_contact_last_name',l_wf_contact_last_name);
1490: WSH_DEBUG_SV.log(l_module_name,'l_email_address',l_email_address);
1491: WSH_DEBUG_SV.log(l_module_name,'l_notification_preference',l_notification_preference);
1492: WSH_DEBUG_SV.log(l_module_name,'l_language',l_language);
1493: WSH_DEBUG_SV.log(l_module_name,'l_territory',l_territory);
1494: END IF;
1495:
1496: IF (l_wf_contact_last_name IS NULL) THEN

Line 1493: WSH_DEBUG_SV.log(l_module_name,'l_territory',l_territory);

1489: WSH_DEBUG_SV.log(l_module_name,'l_wf_contact_last_name',l_wf_contact_last_name);
1490: WSH_DEBUG_SV.log(l_module_name,'l_email_address',l_email_address);
1491: WSH_DEBUG_SV.log(l_module_name,'l_notification_preference',l_notification_preference);
1492: WSH_DEBUG_SV.log(l_module_name,'l_language',l_language);
1493: WSH_DEBUG_SV.log(l_module_name,'l_territory',l_territory);
1494: END IF;
1495:
1496: IF (l_wf_contact_last_name IS NULL) THEN
1497: -- If party is not in wf_users views the we cannot send notification

Line 1511: WSH_DEBUG_SV.pop(l_module_name);

1507: --
1508: -- Debug Statements
1509: --
1510: IF l_debug_on THEN
1511: WSH_DEBUG_SV.pop(l_module_name);
1512: END IF;
1513: --
1514: return;
1515: EXCEPTION

Line 1522: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_WF.GET_WF_USER' );

1518: --
1519: -- Debug Statements
1520: --
1521: IF l_debug_on THEN
1522: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_WF.GET_WF_USER' );
1523: END IF;
1524: --
1525: --
1526: -- Debug Statements

Line 1529: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1525: --
1526: -- Debug Statements
1527: --
1528: IF l_debug_on THEN
1529: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1530: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1531: END IF;
1532: --
1533: END Get_Wf_User;

Line 1530: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

1526: -- Debug Statements
1527: --
1528: IF l_debug_on THEN
1529: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1530: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1531: END IF;
1532: --
1533: END Get_Wf_User;
1534: