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.FTE_WORKFLOW_UTIL dependencies on WSH_DEBUG_SV

Line 89: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

85: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
86:
87: IF l_debug_on IS NULL
88: THEN
89: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
90: END IF;
91:
92: IF l_debug_on
93: THEN

Line 94: WSH_DEBUG_SV.push(l_module_name);

90: END IF;
91:
92: IF l_debug_on
93: THEN
94: WSH_DEBUG_SV.push(l_module_name);
95: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',p_trip_id);
96: WSH_DEBUG_SV.logmsg(l_module_name,'Raising event oracle.apps.fte.trip.svc.serviceselectioninitiated for trip '||p_trip_id);
97: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.RAISE_EVENT',WSH_DEBUG_SV.C_PROC_LEVEL);
98: END IF;

Line 95: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',p_trip_id);

91:
92: IF l_debug_on
93: THEN
94: WSH_DEBUG_SV.push(l_module_name);
95: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',p_trip_id);
96: WSH_DEBUG_SV.logmsg(l_module_name,'Raising event oracle.apps.fte.trip.svc.serviceselectioninitiated for trip '||p_trip_id);
97: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.RAISE_EVENT',WSH_DEBUG_SV.C_PROC_LEVEL);
98: END IF;
99:

Line 96: WSH_DEBUG_SV.logmsg(l_module_name,'Raising event oracle.apps.fte.trip.svc.serviceselectioninitiated for trip '||p_trip_id);

92: IF l_debug_on
93: THEN
94: WSH_DEBUG_SV.push(l_module_name);
95: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',p_trip_id);
96: WSH_DEBUG_SV.logmsg(l_module_name,'Raising event oracle.apps.fte.trip.svc.serviceselectioninitiated for trip '||p_trip_id);
97: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.RAISE_EVENT',WSH_DEBUG_SV.C_PROC_LEVEL);
98: END IF;
99:
100: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 97: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.RAISE_EVENT',WSH_DEBUG_SV.C_PROC_LEVEL);

93: THEN
94: WSH_DEBUG_SV.push(l_module_name);
95: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',p_trip_id);
96: WSH_DEBUG_SV.logmsg(l_module_name,'Raising event oracle.apps.fte.trip.svc.serviceselectioninitiated for trip '||p_trip_id);
97: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.RAISE_EVENT',WSH_DEBUG_SV.C_PROC_LEVEL);
98: END IF;
99:
100: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
101: WSH_WF_STD.Raise_Event(

Line 113: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in WSH_WF_STD.RAISE_EVENT');

109: THEN
110: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
111: IF l_debug_on
112: THEN
113: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in WSH_WF_STD.RAISE_EVENT');
114: WSH_DEBUG_SV.logmsg(l_module_name, 'Unable to raise Select Service Init for trip '||p_trip_id);
115: END IF;
116: END IF;
117:

Line 114: WSH_DEBUG_SV.logmsg(l_module_name, 'Unable to raise Select Service Init for trip '||p_trip_id);

110: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
111: IF l_debug_on
112: THEN
113: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in WSH_WF_STD.RAISE_EVENT');
114: WSH_DEBUG_SV.logmsg(l_module_name, 'Unable to raise Select Service Init for trip '||p_trip_id);
115: END IF;
116: END IF;
117:
118: IF l_debug_on

Line 120: WSH_DEBUG_SV.pop(l_module_name);

116: END IF;
117:
118: IF l_debug_on
119: THEN
120: WSH_DEBUG_SV.pop(l_module_name);
121: END IF;
122:
123: EXCEPTION
124: WHEN FND_API.G_EXC_ERROR

Line 129: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

125: THEN
126:
127: IF l_debug_on
128: THEN
129: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
130: END IF;
131: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
132: WHEN OTHERS
133: THEN

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

132: WHEN OTHERS
133: THEN
134: IF l_debug_on
135: THEN
136: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
137: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
138: END IF;
139: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
140: END Single_Trip_Sel_Ser_Init;

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

133: THEN
134: IF l_debug_on
135: THEN
136: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
137: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
138: END IF;
139: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
140: END Single_Trip_Sel_Ser_Init;
141:

Line 166: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

162: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
163:
164: IF l_debug_on IS NULL
165: THEN
166: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
167: END IF;
168:
169: IF l_debug_on
170: THEN

Line 171: WSH_DEBUG_SV.push(l_module_name);

167: END IF;
168:
169: IF l_debug_on
170: THEN
171: WSH_DEBUG_SV.push(l_module_name);
172: WSH_DEBUG_SV.log(l_module_name,'P_DEL_ID',p_del_id);
173: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',p_org_id);
174: WSH_DEBUG_SV.logmsg(l_module_name,'Raising event oracle.apps.wsh.delivery.svc.serviceselected for delivery '||p_del_id||', org '||p_org_id);
175: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.RAISE_EVENT',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 172: WSH_DEBUG_SV.log(l_module_name,'P_DEL_ID',p_del_id);

168:
169: IF l_debug_on
170: THEN
171: WSH_DEBUG_SV.push(l_module_name);
172: WSH_DEBUG_SV.log(l_module_name,'P_DEL_ID',p_del_id);
173: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',p_org_id);
174: WSH_DEBUG_SV.logmsg(l_module_name,'Raising event oracle.apps.wsh.delivery.svc.serviceselected for delivery '||p_del_id||', org '||p_org_id);
175: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.RAISE_EVENT',WSH_DEBUG_SV.C_PROC_LEVEL);
176: END IF;

Line 173: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',p_org_id);

169: IF l_debug_on
170: THEN
171: WSH_DEBUG_SV.push(l_module_name);
172: WSH_DEBUG_SV.log(l_module_name,'P_DEL_ID',p_del_id);
173: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',p_org_id);
174: WSH_DEBUG_SV.logmsg(l_module_name,'Raising event oracle.apps.wsh.delivery.svc.serviceselected for delivery '||p_del_id||', org '||p_org_id);
175: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.RAISE_EVENT',WSH_DEBUG_SV.C_PROC_LEVEL);
176: END IF;
177:

Line 174: WSH_DEBUG_SV.logmsg(l_module_name,'Raising event oracle.apps.wsh.delivery.svc.serviceselected for delivery '||p_del_id||', org '||p_org_id);

170: THEN
171: WSH_DEBUG_SV.push(l_module_name);
172: WSH_DEBUG_SV.log(l_module_name,'P_DEL_ID',p_del_id);
173: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',p_org_id);
174: WSH_DEBUG_SV.logmsg(l_module_name,'Raising event oracle.apps.wsh.delivery.svc.serviceselected for delivery '||p_del_id||', org '||p_org_id);
175: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.RAISE_EVENT',WSH_DEBUG_SV.C_PROC_LEVEL);
176: END IF;
177:
178: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 175: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.RAISE_EVENT',WSH_DEBUG_SV.C_PROC_LEVEL);

171: WSH_DEBUG_SV.push(l_module_name);
172: WSH_DEBUG_SV.log(l_module_name,'P_DEL_ID',p_del_id);
173: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',p_org_id);
174: WSH_DEBUG_SV.logmsg(l_module_name,'Raising event oracle.apps.wsh.delivery.svc.serviceselected for delivery '||p_del_id||', org '||p_org_id);
175: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.RAISE_EVENT',WSH_DEBUG_SV.C_PROC_LEVEL);
176: END IF;
177:
178: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
179: WSH_WF_STD.Raise_Event(

Line 192: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in WSH_WF_STD.RAISE_EVENT');

188: THEN
189: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
190: IF l_debug_on
191: THEN
192: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in WSH_WF_STD.RAISE_EVENT');
193: WSH_DEBUG_SV.logmsg(l_module_name, 'Unable to raise Select Service for delivery '||p_del_id||', org '||p_org_id);
194: END IF;
195: END IF;
196:

Line 193: WSH_DEBUG_SV.logmsg(l_module_name, 'Unable to raise Select Service for delivery '||p_del_id||', org '||p_org_id);

189: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
190: IF l_debug_on
191: THEN
192: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in WSH_WF_STD.RAISE_EVENT');
193: WSH_DEBUG_SV.logmsg(l_module_name, 'Unable to raise Select Service for delivery '||p_del_id||', org '||p_org_id);
194: END IF;
195: END IF;
196:
197: IF l_debug_on

Line 199: WSH_DEBUG_SV.pop(l_module_name);

195: END IF;
196:
197: IF l_debug_on
198: THEN
199: WSH_DEBUG_SV.pop(l_module_name);
200: END IF;
201:
202: EXCEPTION
203: WHEN FND_API.G_EXC_ERROR

Line 208: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

204: THEN
205:
206: IF l_debug_on
207: THEN
208: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
209: END IF;
210: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
211: WHEN OTHERS
212: THEN

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

211: WHEN OTHERS
212: THEN
213: IF l_debug_on
214: THEN
215: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
216: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
217: END IF;
218: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
219:

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

212: THEN
213: IF l_debug_on
214: THEN
215: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
216: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
217: END IF;
218: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
219:
220: END Single_Del_Sel_Ser;

Line 247: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

243: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
244:
245: IF l_debug_on IS NULL
246: THEN
247: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
248: END IF;
249:
250: IF l_debug_on
251: THEN

Line 252: WSH_DEBUG_SV.push(l_module_name);

248: END IF;
249:
250: IF l_debug_on
251: THEN
252: WSH_DEBUG_SV.push(l_module_name);
253: WSH_DEBUG_SV.log(l_module_name,'P_DEL_ID',p_del_id);
254: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',p_org_id);
255: WSH_DEBUG_SV.logmsg(l_module_name,'Raising event oracle.apps.wsh.delivery.svc.servicecancelled for delivery '||p_del_id||', org '||p_org_id);
256: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.RAISE_EVENT',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 253: WSH_DEBUG_SV.log(l_module_name,'P_DEL_ID',p_del_id);

249:
250: IF l_debug_on
251: THEN
252: WSH_DEBUG_SV.push(l_module_name);
253: WSH_DEBUG_SV.log(l_module_name,'P_DEL_ID',p_del_id);
254: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',p_org_id);
255: WSH_DEBUG_SV.logmsg(l_module_name,'Raising event oracle.apps.wsh.delivery.svc.servicecancelled for delivery '||p_del_id||', org '||p_org_id);
256: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.RAISE_EVENT',WSH_DEBUG_SV.C_PROC_LEVEL);
257: END IF;

Line 254: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',p_org_id);

250: IF l_debug_on
251: THEN
252: WSH_DEBUG_SV.push(l_module_name);
253: WSH_DEBUG_SV.log(l_module_name,'P_DEL_ID',p_del_id);
254: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',p_org_id);
255: WSH_DEBUG_SV.logmsg(l_module_name,'Raising event oracle.apps.wsh.delivery.svc.servicecancelled for delivery '||p_del_id||', org '||p_org_id);
256: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.RAISE_EVENT',WSH_DEBUG_SV.C_PROC_LEVEL);
257: END IF;
258:

Line 255: WSH_DEBUG_SV.logmsg(l_module_name,'Raising event oracle.apps.wsh.delivery.svc.servicecancelled for delivery '||p_del_id||', org '||p_org_id);

251: THEN
252: WSH_DEBUG_SV.push(l_module_name);
253: WSH_DEBUG_SV.log(l_module_name,'P_DEL_ID',p_del_id);
254: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',p_org_id);
255: WSH_DEBUG_SV.logmsg(l_module_name,'Raising event oracle.apps.wsh.delivery.svc.servicecancelled for delivery '||p_del_id||', org '||p_org_id);
256: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.RAISE_EVENT',WSH_DEBUG_SV.C_PROC_LEVEL);
257: END IF;
258:
259: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 256: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.RAISE_EVENT',WSH_DEBUG_SV.C_PROC_LEVEL);

252: WSH_DEBUG_SV.push(l_module_name);
253: WSH_DEBUG_SV.log(l_module_name,'P_DEL_ID',p_del_id);
254: WSH_DEBUG_SV.log(l_module_name,'P_ORG_ID',p_org_id);
255: WSH_DEBUG_SV.logmsg(l_module_name,'Raising event oracle.apps.wsh.delivery.svc.servicecancelled for delivery '||p_del_id||', org '||p_org_id);
256: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WF_STD.RAISE_EVENT',WSH_DEBUG_SV.C_PROC_LEVEL);
257: END IF;
258:
259: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
260: WSH_WF_STD.Raise_Event(

Line 273: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in WSH_WF_STD.RAISE_EVENT');

269: THEN
270: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
271: IF l_debug_on
272: THEN
273: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in WSH_WF_STD.RAISE_EVENT');
274: WSH_DEBUG_SV.logmsg(l_module_name, 'Unable to raise Cancel Service for delivery '||p_del_id||', org '||p_org_id);
275: END IF;
276: END IF;
277:

Line 274: WSH_DEBUG_SV.logmsg(l_module_name, 'Unable to raise Cancel Service for delivery '||p_del_id||', org '||p_org_id);

270: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
271: IF l_debug_on
272: THEN
273: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in WSH_WF_STD.RAISE_EVENT');
274: WSH_DEBUG_SV.logmsg(l_module_name, 'Unable to raise Cancel Service for delivery '||p_del_id||', org '||p_org_id);
275: END IF;
276: END IF;
277:
278: IF l_debug_on

Line 280: WSH_DEBUG_SV.pop(l_module_name);

276: END IF;
277:
278: IF l_debug_on
279: THEN
280: WSH_DEBUG_SV.pop(l_module_name);
281: END IF;
282:
283: EXCEPTION
284: WHEN FND_API.G_EXC_ERROR

Line 289: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

285: THEN
286:
287: IF l_debug_on
288: THEN
289: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
290: END IF;
291: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
292: WHEN OTHERS
293: THEN

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

292: WHEN OTHERS
293: THEN
294: IF l_debug_on
295: THEN
296: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
297: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
298: END IF;
299: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
300:

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

293: THEN
294: IF l_debug_on
295: THEN
296: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
297: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
298: END IF;
299: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
300:
301: END Single_Del_Can_Ser;

Line 329: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

325: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
326:
327: IF l_debug_on IS NULL
328: THEN
329: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
330: END IF;
331:
332: IF l_debug_on
333: THEN

Line 334: WSH_DEBUG_SV.push(l_module_name);

330: END IF;
331:
332: IF l_debug_on
333: THEN
334: WSH_DEBUG_SV.push(l_module_name);
335: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',p_trip_id);
336: END IF;
337:
338: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 335: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',p_trip_id);

331:
332: IF l_debug_on
333: THEN
334: WSH_DEBUG_SV.push(l_module_name);
335: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',p_trip_id);
336: END IF;
337:
338: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
339: IF l_debug_on THEN

Line 340: WSH_DEBUG_SV.logmsg(l_module_name,'Raising Service Selection Initiated for the trip '||p_trip_id);

336: END IF;
337:
338: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
339: IF l_debug_on THEN
340: WSH_DEBUG_SV.logmsg(l_module_name,'Raising Service Selection Initiated for the trip '||p_trip_id);
341: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_WORKFLOW_UTIL.SINGLE_TRIP_SEL_SER_INIT',WSH_DEBUG_SV.C_PROC_LEVEL);
342: END IF;
343:
344: Single_Trip_Sel_Ser_Init(

Line 341: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_WORKFLOW_UTIL.SINGLE_TRIP_SEL_SER_INIT',WSH_DEBUG_SV.C_PROC_LEVEL);

337:
338: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
339: IF l_debug_on THEN
340: WSH_DEBUG_SV.logmsg(l_module_name,'Raising Service Selection Initiated for the trip '||p_trip_id);
341: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_WORKFLOW_UTIL.SINGLE_TRIP_SEL_SER_INIT',WSH_DEBUG_SV.C_PROC_LEVEL);
342: END IF;
343:
344: Single_Trip_Sel_Ser_Init(
345: p_trip_id => p_trip_id,

Line 354: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in FTE_WORKFLOW_UTIL.SINGLE_TRIP_SEL_SER_INIT');

350: THEN
351: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
352: IF l_debug_on
353: THEN
354: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in FTE_WORKFLOW_UTIL.SINGLE_TRIP_SEL_SER_INIT');
355: WSH_DEBUG_SV.logmsg(l_module_name, 'Raising Select Service Initiated for the trip '||p_trip_id||' failed');
356: END IF;
357: RAISE FND_API.G_EXC_ERROR;
358: END IF;

Line 355: WSH_DEBUG_SV.logmsg(l_module_name, 'Raising Select Service Initiated for the trip '||p_trip_id||' failed');

351: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
352: IF l_debug_on
353: THEN
354: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in FTE_WORKFLOW_UTIL.SINGLE_TRIP_SEL_SER_INIT');
355: WSH_DEBUG_SV.logmsg(l_module_name, 'Raising Select Service Initiated for the trip '||p_trip_id||' failed');
356: END IF;
357: RAISE FND_API.G_EXC_ERROR;
358: END IF;
359:

Line 362: WSH_DEBUG_SV.logmsg(l_module_name,'Fetching the deliveries assigned to the trip');

358: END IF;
359:
360: IF l_debug_on
361: THEN
362: WSH_DEBUG_SV.logmsg(l_module_name,'Fetching the deliveries assigned to the trip');
363: END IF;
364:
365: OPEN Get_Trip_Deliveries(p_trip_id);
366: LOOP

Line 375: WSH_DEBUG_SV.logmsg(l_module_name,'Got delivery '||l_del_id);

371: FETCH Get_Delivery_Org INTO l_org_id;
372: CLOSE Get_Delivery_Org;
373:
374: IF l_debug_on THEN
375: WSH_DEBUG_SV.logmsg(l_module_name,'Got delivery '||l_del_id);
376: WSH_DEBUG_SV.logmsg(l_module_name,'Raising Service Selection for the delivery '||l_del_id);
377: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_WORKFLOW_UTIL.SINGLE_DEL_SEL_SER',WSH_DEBUG_SV.C_PROC_LEVEL);
378: END IF;
379:

Line 376: WSH_DEBUG_SV.logmsg(l_module_name,'Raising Service Selection for the delivery '||l_del_id);

372: CLOSE Get_Delivery_Org;
373:
374: IF l_debug_on THEN
375: WSH_DEBUG_SV.logmsg(l_module_name,'Got delivery '||l_del_id);
376: WSH_DEBUG_SV.logmsg(l_module_name,'Raising Service Selection for the delivery '||l_del_id);
377: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_WORKFLOW_UTIL.SINGLE_DEL_SEL_SER',WSH_DEBUG_SV.C_PROC_LEVEL);
378: END IF;
379:
380: Single_Del_Sel_Ser(

Line 377: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_WORKFLOW_UTIL.SINGLE_DEL_SEL_SER',WSH_DEBUG_SV.C_PROC_LEVEL);

373:
374: IF l_debug_on THEN
375: WSH_DEBUG_SV.logmsg(l_module_name,'Got delivery '||l_del_id);
376: WSH_DEBUG_SV.logmsg(l_module_name,'Raising Service Selection for the delivery '||l_del_id);
377: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_WORKFLOW_UTIL.SINGLE_DEL_SEL_SER',WSH_DEBUG_SV.C_PROC_LEVEL);
378: END IF;
379:
380: Single_Del_Sel_Ser(
381: p_del_id => l_del_id,

Line 391: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in FTE_WORKFLOW_UTIL.SINGLE_DEL_SEL_SER');

387: THEN
388: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
389: IF l_debug_on
390: THEN
391: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in FTE_WORKFLOW_UTIL.SINGLE_DEL_SEL_SER');
392: WSH_DEBUG_SV.logmsg(l_module_name, 'Raising Select Service for the delivery '||l_del_id||' failed');
393: END IF;
394: END IF;
395:

Line 392: WSH_DEBUG_SV.logmsg(l_module_name, 'Raising Select Service for the delivery '||l_del_id||' failed');

388: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
389: IF l_debug_on
390: THEN
391: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in FTE_WORKFLOW_UTIL.SINGLE_DEL_SEL_SER');
392: WSH_DEBUG_SV.logmsg(l_module_name, 'Raising Select Service for the delivery '||l_del_id||' failed');
393: END IF;
394: END IF;
395:
396: END LOOP;

Line 401: WSH_DEBUG_SV.pop(l_module_name);

397: CLOSE Get_Trip_Deliveries;
398:
399: IF l_debug_on
400: THEN
401: WSH_DEBUG_SV.pop(l_module_name);
402: END IF;
403:
404: EXCEPTION
405: WHEN FND_API.G_EXC_ERROR

Line 410: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

406: THEN
407:
408: IF l_debug_on
409: THEN
410: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
411: END IF;
412: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
413: WHEN OTHERS
414: THEN

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

413: WHEN OTHERS
414: THEN
415: IF l_debug_on
416: THEN
417: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
418: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
419: END IF;
420: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
421:

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

414: THEN
415: IF l_debug_on
416: THEN
417: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
418: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
419: END IF;
420: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
421:
422: END Trip_Select_Service_Init;

Line 451: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

447: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
448:
449: IF l_debug_on IS NULL
450: THEN
451: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
452: END IF;
453:
454: IF l_debug_on
455: THEN

Line 456: WSH_DEBUG_SV.push(l_module_name);

452: END IF;
453:
454: IF l_debug_on
455: THEN
456: WSH_DEBUG_SV.push(l_module_name);
457: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',p_trip_id);
458: END IF;
459:
460: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 457: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',p_trip_id);

453:
454: IF l_debug_on
455: THEN
456: WSH_DEBUG_SV.push(l_module_name);
457: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',p_trip_id);
458: END IF;
459:
460: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
461:

Line 464: WSH_DEBUG_SV.logmsg(l_module_name,'Fetching the deliveries assigned to the trip');

460: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
461:
462: IF l_debug_on
463: THEN
464: WSH_DEBUG_SV.logmsg(l_module_name,'Fetching the deliveries assigned to the trip');
465: END IF;
466:
467: OPEN Get_Trip_Deliveries(p_trip_id);
468: LOOP

Line 477: WSH_DEBUG_SV.logmsg(l_module_name,'Got delivery '||l_del_id);

473: FETCH Get_Delivery_Org INTO l_org_id;
474: CLOSE Get_Delivery_Org;
475:
476: IF l_debug_on THEN
477: WSH_DEBUG_SV.logmsg(l_module_name,'Got delivery '||l_del_id);
478: WSH_DEBUG_SV.logmsg(l_module_name,'Raising Service Cancellation for the delivery '||l_del_id);
479: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_WORKFLOW_UTIL.SINGLE_DEL_CAN_SER',WSH_DEBUG_SV.C_PROC_LEVEL);
480: END IF;
481:

Line 478: WSH_DEBUG_SV.logmsg(l_module_name,'Raising Service Cancellation for the delivery '||l_del_id);

474: CLOSE Get_Delivery_Org;
475:
476: IF l_debug_on THEN
477: WSH_DEBUG_SV.logmsg(l_module_name,'Got delivery '||l_del_id);
478: WSH_DEBUG_SV.logmsg(l_module_name,'Raising Service Cancellation for the delivery '||l_del_id);
479: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_WORKFLOW_UTIL.SINGLE_DEL_CAN_SER',WSH_DEBUG_SV.C_PROC_LEVEL);
480: END IF;
481:
482: Single_Del_Can_Ser(

Line 479: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_WORKFLOW_UTIL.SINGLE_DEL_CAN_SER',WSH_DEBUG_SV.C_PROC_LEVEL);

475:
476: IF l_debug_on THEN
477: WSH_DEBUG_SV.logmsg(l_module_name,'Got delivery '||l_del_id);
478: WSH_DEBUG_SV.logmsg(l_module_name,'Raising Service Cancellation for the delivery '||l_del_id);
479: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_WORKFLOW_UTIL.SINGLE_DEL_CAN_SER',WSH_DEBUG_SV.C_PROC_LEVEL);
480: END IF;
481:
482: Single_Del_Can_Ser(
483: p_del_id => l_del_id,

Line 493: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in FTE_WORKFLOW_UTIL.SINGLE_DEL_CAN_SER');

489: THEN
490: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
491: IF l_debug_on
492: THEN
493: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in FTE_WORKFLOW_UTIL.SINGLE_DEL_CAN_SER');
494: WSH_DEBUG_SV.logmsg(l_module_name, 'Raising Cancel Service for the delivery '||l_del_id||' failed');
495: END IF;
496: END IF;
497:

Line 494: WSH_DEBUG_SV.logmsg(l_module_name, 'Raising Cancel Service for the delivery '||l_del_id||' failed');

490: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
491: IF l_debug_on
492: THEN
493: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in FTE_WORKFLOW_UTIL.SINGLE_DEL_CAN_SER');
494: WSH_DEBUG_SV.logmsg(l_module_name, 'Raising Cancel Service for the delivery '||l_del_id||' failed');
495: END IF;
496: END IF;
497:
498: END LOOP;

Line 503: WSH_DEBUG_SV.pop(l_module_name);

499: CLOSE Get_Trip_Deliveries;
500:
501: IF l_debug_on
502: THEN
503: WSH_DEBUG_SV.pop(l_module_name);
504: END IF;
505:
506: EXCEPTION
507: WHEN FND_API.G_EXC_ERROR

Line 512: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

508: THEN
509:
510: IF l_debug_on
511: THEN
512: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
513: END IF;
514: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
515: WHEN OTHERS
516: THEN

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

515: WHEN OTHERS
516: THEN
517: IF l_debug_on
518: THEN
519: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
520: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
521: END IF;
522: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
523:

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

516: THEN
517: IF l_debug_on
518: THEN
519: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
520: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
521: END IF;
522: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
523:
524: END Trip_Cancel_Service;

Line 552: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

548: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
549:
550: IF l_debug_on IS NULL
551: THEN
552: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
553: END IF;
554:
555: IF l_debug_on
556: THEN

Line 557: WSH_DEBUG_SV.push(l_module_name);

553: END IF;
554:
555: IF l_debug_on
556: THEN
557: WSH_DEBUG_SV.push(l_module_name);
558: WSH_DEBUG_SV.log(l_module_name,'P_DLEG_ID',p_dleg_id);
559: END IF;
560:
561: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 558: WSH_DEBUG_SV.log(l_module_name,'P_DLEG_ID',p_dleg_id);

554:
555: IF l_debug_on
556: THEN
557: WSH_DEBUG_SV.push(l_module_name);
558: WSH_DEBUG_SV.log(l_module_name,'P_DLEG_ID',p_dleg_id);
559: END IF;
560:
561: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
562:

Line 571: WSH_DEBUG_SV.logmsg(l_module_name,'Failed to fetch the delivery associated with the delivery leg');

567: IF l_del_id IS NULL
568: THEN
569: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
570: IF l_debug_on THEN
571: WSH_DEBUG_SV.logmsg(l_module_name,'Failed to fetch the delivery associated with the delivery leg');
572: END IF;
573: RAISE FND_API.G_EXC_ERROR;
574: END IF;
575:

Line 581: WSH_DEBUG_SV.logmsg(l_module_name,'Raising Service Selection for the delivery '||l_del_id);

577: FETCH Get_Delivery_Org INTO l_org_id;
578: CLOSE Get_Delivery_Org;
579:
580: IF l_debug_on THEN
581: WSH_DEBUG_SV.logmsg(l_module_name,'Raising Service Selection for the delivery '||l_del_id);
582: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_WORKFLOW_UTIL.SINGLE_DEL_SEL_SER',WSH_DEBUG_SV.C_PROC_LEVEL);
583: END IF;
584:
585: Single_Del_Sel_Ser(

Line 582: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_WORKFLOW_UTIL.SINGLE_DEL_SEL_SER',WSH_DEBUG_SV.C_PROC_LEVEL);

578: CLOSE Get_Delivery_Org;
579:
580: IF l_debug_on THEN
581: WSH_DEBUG_SV.logmsg(l_module_name,'Raising Service Selection for the delivery '||l_del_id);
582: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_WORKFLOW_UTIL.SINGLE_DEL_SEL_SER',WSH_DEBUG_SV.C_PROC_LEVEL);
583: END IF;
584:
585: Single_Del_Sel_Ser(
586: p_del_id => l_del_id,

Line 596: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in FTE_WORKFLOW_UTIL.SINGLE_DEL_SEL_SER');

592: THEN
593: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
594: IF l_debug_on
595: THEN
596: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in FTE_WORKFLOW_UTIL.SINGLE_DEL_SEL_SER');
597: WSH_DEBUG_SV.logmsg(l_module_name, 'Raising Select Service for the delivery '||l_del_id||' failed');
598: END IF;
599: RAISE FND_API.G_EXC_ERROR;
600: END IF;

Line 597: WSH_DEBUG_SV.logmsg(l_module_name, 'Raising Select Service for the delivery '||l_del_id||' failed');

593: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
594: IF l_debug_on
595: THEN
596: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in FTE_WORKFLOW_UTIL.SINGLE_DEL_SEL_SER');
597: WSH_DEBUG_SV.logmsg(l_module_name, 'Raising Select Service for the delivery '||l_del_id||' failed');
598: END IF;
599: RAISE FND_API.G_EXC_ERROR;
600: END IF;
601:

Line 603: WSH_DEBUG_SV.logmsg(l_module_name,'Fetching trip to which the delivery '||l_del_id||' is assigned');

599: RAISE FND_API.G_EXC_ERROR;
600: END IF;
601:
602: IF l_debug_on THEN
603: WSH_DEBUG_SV.logmsg(l_module_name,'Fetching trip to which the delivery '||l_del_id||' is assigned');
604: END IF;
605:
606: OPEN Get_Dleg_Trip(p_dleg_id);
607: FETCH Get_Dleg_Trip INTO l_trip_id;

Line 614: WSH_DEBUG_SV.logmsg(l_module_name,'Found trip '||l_trip_id);

610: IF l_trip_id IS NOT NULL
611: THEN
612:
613: IF l_debug_on THEN
614: WSH_DEBUG_SV.logmsg(l_module_name,'Found trip '||l_trip_id);
615: WSH_DEBUG_SV.logmsg(l_module_name,'Raising Service Selection Initiated for the trip '||l_trip_id);
616: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_WORKFLOW_UTIL.SINGLE_TRIP_SEL_SER_INIT',WSH_DEBUG_SV.C_PROC_LEVEL);
617: END IF;
618:

Line 615: WSH_DEBUG_SV.logmsg(l_module_name,'Raising Service Selection Initiated for the trip '||l_trip_id);

611: THEN
612:
613: IF l_debug_on THEN
614: WSH_DEBUG_SV.logmsg(l_module_name,'Found trip '||l_trip_id);
615: WSH_DEBUG_SV.logmsg(l_module_name,'Raising Service Selection Initiated for the trip '||l_trip_id);
616: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_WORKFLOW_UTIL.SINGLE_TRIP_SEL_SER_INIT',WSH_DEBUG_SV.C_PROC_LEVEL);
617: END IF;
618:
619: Single_Trip_Sel_Ser_Init(

Line 616: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_WORKFLOW_UTIL.SINGLE_TRIP_SEL_SER_INIT',WSH_DEBUG_SV.C_PROC_LEVEL);

612:
613: IF l_debug_on THEN
614: WSH_DEBUG_SV.logmsg(l_module_name,'Found trip '||l_trip_id);
615: WSH_DEBUG_SV.logmsg(l_module_name,'Raising Service Selection Initiated for the trip '||l_trip_id);
616: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_WORKFLOW_UTIL.SINGLE_TRIP_SEL_SER_INIT',WSH_DEBUG_SV.C_PROC_LEVEL);
617: END IF;
618:
619: Single_Trip_Sel_Ser_Init(
620: p_trip_id => l_trip_id,

Line 629: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in FTE_WORKFLOW_UTIL.SINGLE_TRIP_SEL_SER_INIT');

625: THEN
626: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
627: IF l_debug_on
628: THEN
629: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in FTE_WORKFLOW_UTIL.SINGLE_TRIP_SEL_SER_INIT');
630: WSH_DEBUG_SV.logmsg(l_module_name, 'Raising Select Service for the trip '||l_trip_id||' failed');
631: END IF;
632: END IF;
633: ELSE

Line 630: WSH_DEBUG_SV.logmsg(l_module_name, 'Raising Select Service for the trip '||l_trip_id||' failed');

626: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
627: IF l_debug_on
628: THEN
629: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in FTE_WORKFLOW_UTIL.SINGLE_TRIP_SEL_SER_INIT');
630: WSH_DEBUG_SV.logmsg(l_module_name, 'Raising Select Service for the trip '||l_trip_id||' failed');
631: END IF;
632: END IF;
633: ELSE
634: IF l_debug_on THEN

Line 635: WSH_DEBUG_SV.logmsg(l_module_name,'No trip found trip');

631: END IF;
632: END IF;
633: ELSE
634: IF l_debug_on THEN
635: WSH_DEBUG_SV.logmsg(l_module_name,'No trip found trip');
636: END IF;
637: END IF;
638:
639: IF l_debug_on

Line 641: WSH_DEBUG_SV.pop(l_module_name);

637: END IF;
638:
639: IF l_debug_on
640: THEN
641: WSH_DEBUG_SV.pop(l_module_name);
642: END IF;
643:
644: EXCEPTION
645: WHEN FND_API.G_EXC_ERROR

Line 650: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

646: THEN
647:
648: IF l_debug_on
649: THEN
650: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
651: END IF;
652: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
653: WHEN OTHERS
654: THEN

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

653: WHEN OTHERS
654: THEN
655: IF l_debug_on
656: THEN
657: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
658: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
659: END IF;
660: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
661:

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

654: THEN
655: IF l_debug_on
656: THEN
657: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
658: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
659: END IF;
660: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
661:
662: END Dleg_Select_Service;

Line 688: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

684: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
685:
686: IF l_debug_on IS NULL
687: THEN
688: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
689: END IF;
690:
691: IF l_debug_on
692: THEN

Line 693: WSH_DEBUG_SV.push(l_module_name);

689: END IF;
690:
691: IF l_debug_on
692: THEN
693: WSH_DEBUG_SV.push(l_module_name);
694: WSH_DEBUG_SV.log(l_module_name,'P_DLEG_ID',p_dleg_id);
695: END IF;
696:
697: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 694: WSH_DEBUG_SV.log(l_module_name,'P_DLEG_ID',p_dleg_id);

690:
691: IF l_debug_on
692: THEN
693: WSH_DEBUG_SV.push(l_module_name);
694: WSH_DEBUG_SV.log(l_module_name,'P_DLEG_ID',p_dleg_id);
695: END IF;
696:
697: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
698:

Line 707: WSH_DEBUG_SV.logmsg(l_module_name,'Failed to fetch the delivery associated with the delivery leg');

703: IF l_del_id IS NULL
704: THEN
705: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
706: IF l_debug_on THEN
707: WSH_DEBUG_SV.logmsg(l_module_name,'Failed to fetch the delivery associated with the delivery leg');
708: END IF;
709: RAISE FND_API.G_EXC_ERROR;
710: END IF;
711:

Line 717: WSH_DEBUG_SV.logmsg(l_module_name,'Raising Cancel Service for the delivery '||l_del_id);

713: FETCH Get_Delivery_Org INTO l_org_id;
714: CLOSE Get_Delivery_Org;
715:
716: IF l_debug_on THEN
717: WSH_DEBUG_SV.logmsg(l_module_name,'Raising Cancel Service for the delivery '||l_del_id);
718: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_WORKFLOW_UTIL.SINGLE_DEL_CAN_SER',WSH_DEBUG_SV.C_PROC_LEVEL);
719: END IF;
720:
721: Single_Del_Can_Ser(

Line 718: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_WORKFLOW_UTIL.SINGLE_DEL_CAN_SER',WSH_DEBUG_SV.C_PROC_LEVEL);

714: CLOSE Get_Delivery_Org;
715:
716: IF l_debug_on THEN
717: WSH_DEBUG_SV.logmsg(l_module_name,'Raising Cancel Service for the delivery '||l_del_id);
718: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_WORKFLOW_UTIL.SINGLE_DEL_CAN_SER',WSH_DEBUG_SV.C_PROC_LEVEL);
719: END IF;
720:
721: Single_Del_Can_Ser(
722: p_del_id => l_del_id,

Line 732: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in FTE_WORKFLOW_UTIL.SINGLE_DEL_CAN_SER');

728: THEN
729: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
730: IF l_debug_on
731: THEN
732: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in FTE_WORKFLOW_UTIL.SINGLE_DEL_CAN_SER');
733: WSH_DEBUG_SV.logmsg(l_module_name, 'Raising Cancel Service for the delivery '||l_del_id||' failed');
734: END IF;
735: RAISE FND_API.G_EXC_ERROR;
736: END IF;

Line 733: WSH_DEBUG_SV.logmsg(l_module_name, 'Raising Cancel Service for the delivery '||l_del_id||' failed');

729: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
730: IF l_debug_on
731: THEN
732: WSH_DEBUG_SV.logmsg(l_module_name, 'Error occurred in FTE_WORKFLOW_UTIL.SINGLE_DEL_CAN_SER');
733: WSH_DEBUG_SV.logmsg(l_module_name, 'Raising Cancel Service for the delivery '||l_del_id||' failed');
734: END IF;
735: RAISE FND_API.G_EXC_ERROR;
736: END IF;
737:

Line 740: WSH_DEBUG_SV.pop(l_module_name);

736: END IF;
737:
738: IF l_debug_on
739: THEN
740: WSH_DEBUG_SV.pop(l_module_name);
741: END IF;
742:
743: EXCEPTION
744: WHEN FND_API.G_EXC_ERROR

Line 749: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

745: THEN
746:
747: IF l_debug_on
748: THEN
749: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
750: END IF;
751: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
752: WHEN OTHERS
753: THEN

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

752: WHEN OTHERS
753: THEN
754: IF l_debug_on
755: THEN
756: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
757: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
758: END IF;
759: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
760:

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

753: THEN
754: IF l_debug_on
755: THEN
756: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
757: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
758: END IF;
759: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
760:
761: END Dleg_Cancel_Service;