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_TRIP_STOPS_VALIDATIONS dependencies on WSH_DEBUG_SV

Line 62: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

58: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
59: --
60: IF l_debug_on IS NULL
61: THEN
62: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
63: END IF;
64: --
65: IF l_debug_on THEN
66: WSH_DEBUG_SV.push(l_module_name);

Line 66: WSH_DEBUG_SV.push(l_module_name);

62: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
63: END IF;
64: --
65: IF l_debug_on THEN
66: WSH_DEBUG_SV.push(l_module_name);
67: --
68: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
69: WSH_DEBUG_SV.log(l_module_name,'P_STOP_SEQUENCE_NUMBER',P_STOP_SEQUENCE_NUMBER);
70: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);

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

64: --
65: IF l_debug_on THEN
66: WSH_DEBUG_SV.push(l_module_name);
67: --
68: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
69: WSH_DEBUG_SV.log(l_module_name,'P_STOP_SEQUENCE_NUMBER',P_STOP_SEQUENCE_NUMBER);
70: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
71: WSH_DEBUG_SV.log(l_module_name,'P_STATUS_CODE',P_STATUS_CODE);
72: END IF;

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

65: IF l_debug_on THEN
66: WSH_DEBUG_SV.push(l_module_name);
67: --
68: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
69: WSH_DEBUG_SV.log(l_module_name,'P_STOP_SEQUENCE_NUMBER',P_STOP_SEQUENCE_NUMBER);
70: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
71: WSH_DEBUG_SV.log(l_module_name,'P_STATUS_CODE',P_STATUS_CODE);
72: END IF;
73: --

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

66: WSH_DEBUG_SV.push(l_module_name);
67: --
68: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
69: WSH_DEBUG_SV.log(l_module_name,'P_STOP_SEQUENCE_NUMBER',P_STOP_SEQUENCE_NUMBER);
70: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
71: WSH_DEBUG_SV.log(l_module_name,'P_STATUS_CODE',P_STATUS_CODE);
72: END IF;
73: --
74: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

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

67: --
68: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
69: WSH_DEBUG_SV.log(l_module_name,'P_STOP_SEQUENCE_NUMBER',P_STOP_SEQUENCE_NUMBER);
70: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
71: WSH_DEBUG_SV.log(l_module_name,'P_STATUS_CODE',P_STATUS_CODE);
72: END IF;
73: --
74: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
75:

Line 87: WSH_DEBUG_SV.pop(l_module_name);

83: --
84: -- Debug Statements
85: --
86: IF l_debug_on THEN
87: WSH_DEBUG_SV.pop(l_module_name);
88: END IF;
89: --
90: RETURN;
91: END IF;

Line 105: WSH_DEBUG_SV.pop(l_module_name);

101: --
102: -- Debug Statements
103: --
104: IF l_debug_on THEN
105: WSH_DEBUG_SV.pop(l_module_name);
106: END IF;
107: --
108: RETURN;
109: END IF;

Line 124: WSH_DEBUG_SV.pop(l_module_name);

120: --
121: -- Debug Statements
122: --
123: IF l_debug_on THEN
124: WSH_DEBUG_SV.pop(l_module_name);
125: END IF;
126: --
127: RETURN;
128: END IF;

Line 144: WSH_DEBUG_SV.pop(l_module_name);

140: --
141: -- Debug Statements
142: --
143: IF l_debug_on THEN
144: WSH_DEBUG_SV.pop(l_module_name);
145: END IF;
146: --
147: RETURN;
148: END IF;

Line 173: WSH_DEBUG_SV.pop(l_module_name);

169: --
170: -- Debug Statements
171: --
172: IF l_debug_on THEN
173: WSH_DEBUG_SV.pop(l_module_name);
174: END IF;
175: --
176: RETURN;
177: END IF;

Line 185: WSH_DEBUG_SV.pop(l_module_name);

181: --
182: -- Debug Statements
183: --
184: IF l_debug_on THEN
185: WSH_DEBUG_SV.pop(l_module_name);
186: END IF;
187: --
188: EXCEPTION
189: WHEN RECORD_LOCKED THEN

Line 197: WSH_DEBUG_SV.pop(l_module_name);

193: --
194: -- Debug Statements
195: --
196: IF l_debug_on THEN
197: WSH_DEBUG_SV.pop(l_module_name);
198: END IF;
199: --
200: RETURN;
201:

Line 206: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

202: --
203: -- Debug Statements
204: --
205: IF l_debug_on THEN
206: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
207: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');
208: END IF;
209: --
210: WHEN OTHERS THEN

Line 207: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');

203: -- Debug Statements
204: --
205: IF l_debug_on THEN
206: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
207: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');
208: END IF;
209: --
210: WHEN OTHERS THEN
211: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_TRIP_STOP_VALIDATIONS.validate_sequence_number');

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

213: --
214: -- Debug Statements
215: --
216: IF l_debug_on THEN
217: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
218: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
219: END IF;
220: --
221: END validate_sequence_number;

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

214: -- Debug Statements
215: --
216: IF l_debug_on THEN
217: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
218: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
219: END IF;
220: --
221: END validate_sequence_number;
222:

Line 253: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

249: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
250: --
251: IF l_debug_on IS NULL
252: THEN
253: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
254: END IF;
255: --
256: IF l_debug_on THEN
257: WSH_DEBUG_SV.push(l_module_name);

Line 257: WSH_DEBUG_SV.push(l_module_name);

253: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
254: END IF;
255: --
256: IF l_debug_on THEN
257: WSH_DEBUG_SV.push(l_module_name);
258: --
259: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
260: WSH_DEBUG_SV.log(l_module_name,'P_STOP_SEQUENCE_NUMBER',P_STOP_SEQUENCE_NUMBER);
261: END IF;

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

255: --
256: IF l_debug_on THEN
257: WSH_DEBUG_SV.push(l_module_name);
258: --
259: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
260: WSH_DEBUG_SV.log(l_module_name,'P_STOP_SEQUENCE_NUMBER',P_STOP_SEQUENCE_NUMBER);
261: END IF;
262: --
263: OPEN c_check_max;

Line 260: WSH_DEBUG_SV.log(l_module_name,'P_STOP_SEQUENCE_NUMBER',P_STOP_SEQUENCE_NUMBER);

256: IF l_debug_on THEN
257: WSH_DEBUG_SV.push(l_module_name);
258: --
259: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
260: WSH_DEBUG_SV.log(l_module_name,'P_STOP_SEQUENCE_NUMBER',P_STOP_SEQUENCE_NUMBER);
261: END IF;
262: --
263: OPEN c_check_max;
264: FETCH c_check_max

Line 278: WSH_DEBUG_SV.pop(l_module_name);

274: --
275: -- Debug Statements
276: --
277: IF l_debug_on THEN
278: WSH_DEBUG_SV.pop(l_module_name);
279: END IF;
280: --
281: EXCEPTION
282: WHEN OTHERS THEN

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

285: --
286: -- Debug Statements
287: --
288: IF l_debug_on THEN
289: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
290: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
291: END IF;
292: --
293: END;

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

286: -- Debug Statements
287: --
288: IF l_debug_on THEN
289: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
290: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
291: END IF;
292: --
293: END;
294: /* p_stop id will be null for new records

Line 328: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

324: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
325: --
326: IF l_debug_on IS NULL
327: THEN
328: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
329: END IF;
330: --
331: IF l_debug_on THEN
332: WSH_DEBUG_SV.push(l_module_name);

Line 332: WSH_DEBUG_SV.push(l_module_name);

328: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
329: END IF;
330: --
331: IF l_debug_on THEN
332: WSH_DEBUG_SV.push(l_module_name);
333: --
334: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
335: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
336: WSH_DEBUG_SV.log(l_module_name,'P_STOP_SEQUENCE_NUMBER',P_STOP_SEQUENCE_NUMBER);

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

330: --
331: IF l_debug_on THEN
332: WSH_DEBUG_SV.push(l_module_name);
333: --
334: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
335: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
336: WSH_DEBUG_SV.log(l_module_name,'P_STOP_SEQUENCE_NUMBER',P_STOP_SEQUENCE_NUMBER);
337: END IF;
338: --

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

331: IF l_debug_on THEN
332: WSH_DEBUG_SV.push(l_module_name);
333: --
334: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
335: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
336: WSH_DEBUG_SV.log(l_module_name,'P_STOP_SEQUENCE_NUMBER',P_STOP_SEQUENCE_NUMBER);
337: END IF;
338: --
339: OPEN c_check_unique;

Line 336: WSH_DEBUG_SV.log(l_module_name,'P_STOP_SEQUENCE_NUMBER',P_STOP_SEQUENCE_NUMBER);

332: WSH_DEBUG_SV.push(l_module_name);
333: --
334: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
335: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
336: WSH_DEBUG_SV.log(l_module_name,'P_STOP_SEQUENCE_NUMBER',P_STOP_SEQUENCE_NUMBER);
337: END IF;
338: --
339: OPEN c_check_unique;
340: FETCH c_check_unique

Line 372: WSH_DEBUG_SV.pop(l_module_name);

368: --
369: -- Debug Statements
370: --
371: IF l_debug_on THEN
372: WSH_DEBUG_SV.pop(l_module_name);
373: END IF;
374: --
375: EXCEPTION
376: WHEN OTHERS THEN

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

379: --
380: -- Debug Statements
381: --
382: IF l_debug_on THEN
383: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
384: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
385: END IF;
386: --
387: END;

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

380: -- Debug Statements
381: --
382: IF l_debug_on THEN
383: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
384: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
385: END IF;
386: --
387: END;
388:

Line 406: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

402: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
403: --
404: IF l_debug_on IS NULL
405: THEN
406: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
407: END IF;
408: --
409: IF l_debug_on THEN
410: WSH_DEBUG_SV.push(l_module_name);

Line 410: WSH_DEBUG_SV.push(l_module_name);

406: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
407: END IF;
408: --
409: IF l_debug_on THEN
410: WSH_DEBUG_SV.push(l_module_name);
411: --
412: WSH_DEBUG_SV.log(l_module_name,'P_STOP_SEQUENCE_NUMBER',P_STOP_SEQUENCE_NUMBER);
413: END IF;
414: --

Line 412: WSH_DEBUG_SV.log(l_module_name,'P_STOP_SEQUENCE_NUMBER',P_STOP_SEQUENCE_NUMBER);

408: --
409: IF l_debug_on THEN
410: WSH_DEBUG_SV.push(l_module_name);
411: --
412: WSH_DEBUG_SV.log(l_module_name,'P_STOP_SEQUENCE_NUMBER',P_STOP_SEQUENCE_NUMBER);
413: END IF;
414: --
415: IF p_stop_sequence_number > 0 THEN
416: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 425: WSH_DEBUG_SV.pop(l_module_name);

421: --
422: -- Debug Statements
423: --
424: IF l_debug_on THEN
425: WSH_DEBUG_SV.pop(l_module_name);
426: END IF;
427: --
428: EXCEPTION
429: WHEN OTHERS THEN

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

432: --
433: -- Debug Statements
434: --
435: IF l_debug_on THEN
436: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
437: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
438: END IF;
439: --
440: END ;

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

433: -- Debug Statements
434: --
435: IF l_debug_on THEN
436: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
437: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
438: END IF;
439: --
440: END ;
441:

Line 460: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

456: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
457: --
458: IF l_debug_on IS NULL
459: THEN
460: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
461: END IF;
462: --
463: IF l_debug_on THEN
464: WSH_DEBUG_SV.push(l_module_name);

Line 464: WSH_DEBUG_SV.push(l_module_name);

460: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
461: END IF;
462: --
463: IF l_debug_on THEN
464: WSH_DEBUG_SV.push(l_module_name);
465: --
466: WSH_DEBUG_SV.log(l_module_name,'P_STOP_STATUS',P_STOP_STATUS);
467: END IF;
468: --

Line 466: WSH_DEBUG_SV.log(l_module_name,'P_STOP_STATUS',P_STOP_STATUS);

462: --
463: IF l_debug_on THEN
464: WSH_DEBUG_SV.push(l_module_name);
465: --
466: WSH_DEBUG_SV.log(l_module_name,'P_STOP_STATUS',P_STOP_STATUS);
467: END IF;
468: --
469: IF p_stop_status = 'OP' THEN
470: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 479: WSH_DEBUG_SV.pop(l_module_name);

475: --
476: -- Debug Statements
477: --
478: IF l_debug_on THEN
479: WSH_DEBUG_SV.pop(l_module_name);
480: END IF;
481: --
482: EXCEPTION
483: WHEN OTHERS THEN

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

486: --
487: -- Debug Statements
488: --
489: IF l_debug_on THEN
490: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
491: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
492: END IF;
493: --
494: END;

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

487: -- Debug Statements
488: --
489: IF l_debug_on THEN
490: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
491: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
492: END IF;
493: --
494: END;
495: /** Logic used here

Line 568: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

564: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
565: --
566: IF l_debug_on IS NULL
567: THEN
568: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
569: END IF;
570: --
571: IF l_debug_on THEN
572: WSH_DEBUG_SV.push(l_module_name);

Line 572: WSH_DEBUG_SV.push(l_module_name);

568: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
569: END IF;
570: --
571: IF l_debug_on THEN
572: WSH_DEBUG_SV.push(l_module_name);
573: --
574: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
575: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
576: WSH_DEBUG_SV.log(l_module_name,'P_STOP_SEQUENCE_NUMBER',P_STOP_SEQUENCE_NUMBER);

Line 574: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);

570: --
571: IF l_debug_on THEN
572: WSH_DEBUG_SV.push(l_module_name);
573: --
574: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
575: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
576: WSH_DEBUG_SV.log(l_module_name,'P_STOP_SEQUENCE_NUMBER',P_STOP_SEQUENCE_NUMBER);
577: END IF;
578: --

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

571: IF l_debug_on THEN
572: WSH_DEBUG_SV.push(l_module_name);
573: --
574: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
575: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
576: WSH_DEBUG_SV.log(l_module_name,'P_STOP_SEQUENCE_NUMBER',P_STOP_SEQUENCE_NUMBER);
577: END IF;
578: --
579: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 576: WSH_DEBUG_SV.log(l_module_name,'P_STOP_SEQUENCE_NUMBER',P_STOP_SEQUENCE_NUMBER);

572: WSH_DEBUG_SV.push(l_module_name);
573: --
574: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
575: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
576: WSH_DEBUG_SV.log(l_module_name,'P_STOP_SEQUENCE_NUMBER',P_STOP_SEQUENCE_NUMBER);
577: END IF;
578: --
579: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
580:

Line 632: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

628: --
629: -- Debug Statements
630: --
631: IF l_debug_on THEN
632: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
633: END IF;
634: --
635: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',
636: WSH_NEW_DELIVERIES_PVT.get_name(l_rec_wdl1(j).delivery_id));

Line 641: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

637: --
638: -- Debug Statements
639: --
640: IF l_debug_on THEN
641: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
642: END IF;
643: --
644: FND_MESSAGE.SET_TOKEN('TRIP_NAME',
645: WSH_TRIPS_PVT.get_name(p_trip_id));

Line 667: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

663: --
664: -- Debug Statements
665: --
666: IF l_debug_on THEN
667: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
668: END IF;
669: --
670: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',
671: WSH_NEW_DELIVERIES_PVT.get_name(l_rec_wdl1(j).delivery_id));

Line 676: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

672: --
673: -- Debug Statements
674: --
675: IF l_debug_on THEN
676: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
677: END IF;
678: --
679: FND_MESSAGE.SET_TOKEN('TRIP_NAME',
680: WSH_TRIPS_PVT.get_name(p_trip_id));

Line 696: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.UNASSIGN_TRIP',WSH_DEBUG_SV.C_PROC_LEVEL);

692: --
693: -- Debug Statements
694: --
695: IF l_debug_on THEN
696: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.UNASSIGN_TRIP',WSH_DEBUG_SV.C_PROC_LEVEL);
697: END IF;
698: --
699: WSH_TRIPS_ACTIONS.unassign_trip
700: (p_del_rows => l_del_to_unassign,

Line 717: WSH_DEBUG_SV.pop(l_module_name);

713: --
714: -- Debug Statements
715: --
716: IF l_debug_on THEN
717: WSH_DEBUG_SV.pop(l_module_name);
718: END IF;
719: --
720: EXCEPTION
721: WHEN OTHERS THEN

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

724: --
725: -- Debug Statements
726: --
727: IF l_debug_on THEN
728: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
729: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
730: END IF;
731: --
732: END;

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

725: -- Debug Statements
726: --
727: IF l_debug_on THEN
728: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
729: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
730: END IF;
731: --
732: END;
733: /*

Line 788: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

784: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
785: --
786: IF l_debug_on IS NULL
787: THEN
788: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
789: END IF;
790: --
791: IF l_debug_on THEN
792: WSH_DEBUG_SV.push(l_module_name);

Line 792: WSH_DEBUG_SV.push(l_module_name);

788: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
789: END IF;
790: --
791: IF l_debug_on THEN
792: WSH_DEBUG_SV.push(l_module_name);
793: --
794: WSH_DEBUG_SV.log(l_module_name,'X_STOP_SEQUENCE_NUMBER',X_STOP_SEQUENCE_NUMBER);
795: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
796: WSH_DEBUG_SV.log(l_module_name,'P_STATUS_CODE',P_STATUS_CODE);

Line 794: WSH_DEBUG_SV.log(l_module_name,'X_STOP_SEQUENCE_NUMBER',X_STOP_SEQUENCE_NUMBER);

790: --
791: IF l_debug_on THEN
792: WSH_DEBUG_SV.push(l_module_name);
793: --
794: WSH_DEBUG_SV.log(l_module_name,'X_STOP_SEQUENCE_NUMBER',X_STOP_SEQUENCE_NUMBER);
795: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
796: WSH_DEBUG_SV.log(l_module_name,'P_STATUS_CODE',P_STATUS_CODE);
797: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
798: WSH_DEBUG_SV.log(l_module_name,'P_NEW_FLAG',P_NEW_FLAG);

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

791: IF l_debug_on THEN
792: WSH_DEBUG_SV.push(l_module_name);
793: --
794: WSH_DEBUG_SV.log(l_module_name,'X_STOP_SEQUENCE_NUMBER',X_STOP_SEQUENCE_NUMBER);
795: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
796: WSH_DEBUG_SV.log(l_module_name,'P_STATUS_CODE',P_STATUS_CODE);
797: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
798: WSH_DEBUG_SV.log(l_module_name,'P_NEW_FLAG',P_NEW_FLAG);
799: END IF;

Line 796: WSH_DEBUG_SV.log(l_module_name,'P_STATUS_CODE',P_STATUS_CODE);

792: WSH_DEBUG_SV.push(l_module_name);
793: --
794: WSH_DEBUG_SV.log(l_module_name,'X_STOP_SEQUENCE_NUMBER',X_STOP_SEQUENCE_NUMBER);
795: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
796: WSH_DEBUG_SV.log(l_module_name,'P_STATUS_CODE',P_STATUS_CODE);
797: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
798: WSH_DEBUG_SV.log(l_module_name,'P_NEW_FLAG',P_NEW_FLAG);
799: END IF;
800: --

Line 797: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);

793: --
794: WSH_DEBUG_SV.log(l_module_name,'X_STOP_SEQUENCE_NUMBER',X_STOP_SEQUENCE_NUMBER);
795: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
796: WSH_DEBUG_SV.log(l_module_name,'P_STATUS_CODE',P_STATUS_CODE);
797: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
798: WSH_DEBUG_SV.log(l_module_name,'P_NEW_FLAG',P_NEW_FLAG);
799: END IF;
800: --
801: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 798: WSH_DEBUG_SV.log(l_module_name,'P_NEW_FLAG',P_NEW_FLAG);

794: WSH_DEBUG_SV.log(l_module_name,'X_STOP_SEQUENCE_NUMBER',X_STOP_SEQUENCE_NUMBER);
795: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
796: WSH_DEBUG_SV.log(l_module_name,'P_STATUS_CODE',P_STATUS_CODE);
797: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
798: WSH_DEBUG_SV.log(l_module_name,'P_NEW_FLAG',P_NEW_FLAG);
799: END IF;
800: --
801: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
802: l_stop_sequence_number := 0;

Line 819: WSH_DEBUG_SV.pop(l_module_name);

815: --
816: -- Debug Statements
817: --
818: IF l_debug_on THEN
819: WSH_DEBUG_SV.pop(l_module_name);
820: END IF;
821: --
822: RETURN;
823: END IF;

Line 871: WSH_DEBUG_SV.pop(l_module_name);

867: --
868: -- Debug Statements
869: --
870: IF l_debug_on THEN
871: WSH_DEBUG_SV.pop(l_module_name);
872: END IF;
873: --
874: EXCEPTION
875: WHEN OTHERS THEN

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

878: --
879: -- Debug Statements
880: --
881: IF l_debug_on THEN
882: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
883: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
884: END IF;
885: --
886: END;

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

879: -- Debug Statements
880: --
881: IF l_debug_on THEN
882: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
883: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
884: END IF;
885: --
886: END;
887:

Line 973: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

969: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
970: --
971: IF l_debug_on IS NULL
972: THEN
973: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
974: END IF;
975: --
976: IF l_debug_on THEN
977: WSH_DEBUG_SV.push(l_module_name);

Line 977: WSH_DEBUG_SV.push(l_module_name);

973: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
974: END IF;
975: --
976: IF l_debug_on THEN
977: WSH_DEBUG_SV.push(l_module_name);
978: --
979: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
980: WSH_DEBUG_SV.log(l_module_name,'p_action',p_action);
981: END IF;

Line 979: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);

975: --
976: IF l_debug_on THEN
977: WSH_DEBUG_SV.push(l_module_name);
978: --
979: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
980: WSH_DEBUG_SV.log(l_module_name,'p_action',p_action);
981: END IF;
982:
983: Init_Stop_Actions_Tbl(

Line 980: WSH_DEBUG_SV.log(l_module_name,'p_action',p_action);

976: IF l_debug_on THEN
977: WSH_DEBUG_SV.push(l_module_name);
978: --
979: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
980: WSH_DEBUG_SV.log(l_module_name,'p_action',p_action);
981: END IF;
982:
983: Init_Stop_Actions_Tbl(
984: p_action => p_action,

Line 989: WSH_DEBUG_SV.log(l_module_name,'Init_Detail_Actions_Tbl x_return_status',x_return_status);

985: x_stop_actions_tab => l_stop_actions_tab,
986: x_return_status => x_return_status);
987:
988: IF l_debug_on THEN
989: WSH_DEBUG_SV.log(l_module_name,'Init_Detail_Actions_Tbl x_return_status',x_return_status);
990: END IF;
991:
992: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
993: raise error_in_init_actions;

Line 1005: wsh_debug_sv.log(l_module_name, 'l_caller', l_caller);

1001: l_caller := p_caller;
1002: --
1003: --
1004: IF l_debug_on THEN
1005: wsh_debug_sv.log(l_module_name, 'l_caller', l_caller);
1006: END IF;
1007: --
1008: --
1009: -- Actions on inbound trip-stops are allowed only if caller

Line 1038: wsh_debug_sv.log(l_module_name, 'l_caller-modified', l_caller);

1034: END IF;
1035: --
1036: --
1037: IF l_debug_on THEN
1038: wsh_debug_sv.log(l_module_name, 'l_caller-modified', l_caller);
1039: END IF;
1040: -- J-IB-NPARIKH-}
1041: --
1042:

Line 1070: WSH_DEBUG_SV.log(l_module_name,'WSH_DELIVERY_VALIDATIONS.Is_Action_Enabled l_return_status',l_return_status);

1066: x_error_ids => l_error_ids,
1067: x_valid_index_tab => l_valid_index_tab);
1068:
1069: IF l_debug_on THEN
1070: WSH_DEBUG_SV.log(l_module_name,'WSH_DELIVERY_VALIDATIONS.Is_Action_Enabled l_return_status',l_return_status);
1071: END IF;
1072:
1073: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS)
1074: AND l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN

Line 1104: WSH_DEBUG_SV.log(l_module_name,'WSH_DELIVERY_VALIDATIONS.Is_Action_Enabled l_return_status',

1100: x_error_ids => l_error_ids,
1101: x_valid_index_tab => l_valid_index_tab);
1102:
1103: IF l_debug_on THEN
1104: WSH_DEBUG_SV.log(l_module_name,'WSH_DELIVERY_VALIDATIONS.Is_Action_Enabled l_return_status',
1105: l_return_status);
1106: END IF;
1107:
1108: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS)

Line 1185: WSH_DEBUG_SV.pop(l_module_name);

1181: --}
1182: END IF;
1183:
1184: IF l_debug_on THEN
1185: WSH_DEBUG_SV.pop(l_module_name);
1186: END IF;
1187:
1188: EXCEPTION
1189: WHEN error_in_init_actions THEN

Line 1195: WSH_DEBUG_SV.logmsg(l_module_name,'error_in_init_actions exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1191: IF stop_to_det_cur%ISOPEN THEN
1192: CLOSE stop_to_det_cur;
1193: END IF;
1194: IF l_debug_on THEN
1195: WSH_DEBUG_SV.logmsg(l_module_name,'error_in_init_actions exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1196: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:error_in_init_actions');
1197: END IF;
1198:
1199: WHEN OTHERS THEN

Line 1196: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:error_in_init_actions');

1192: CLOSE stop_to_det_cur;
1193: END IF;
1194: IF l_debug_on THEN
1195: WSH_DEBUG_SV.logmsg(l_module_name,'error_in_init_actions exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1196: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:error_in_init_actions');
1197: END IF;
1198:
1199: WHEN OTHERS THEN
1200: -- OTM R12, glog proj, other cursors are not using OPEN/FETCH

Line 1206: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||

1202: CLOSE stop_to_det_cur;
1203: END IF;
1204: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1205: IF l_debug_on THEN
1206: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1207: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1208: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1209: END IF;
1210: END Is_Action_Enabled;

Line 1207: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1203: END IF;
1204: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1205: IF l_debug_on THEN
1206: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1207: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1208: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1209: END IF;
1210: END Is_Action_Enabled;
1211:

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

1204: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1205: IF l_debug_on THEN
1206: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1207: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1208: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1209: END IF;
1210: END Is_Action_Enabled;
1211:
1212:

Line 2106: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2102: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2103: --
2104: IF l_debug_on IS NULL
2105: THEN
2106: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2107: END IF;
2108: --
2109: IF l_debug_on THEN
2110: --

Line 2111: WSH_DEBUG_SV.push(l_module_name);

2107: END IF;
2108: --
2109: IF l_debug_on THEN
2110: --
2111: WSH_DEBUG_SV.push(l_module_name);
2112: WSH_DEBUG_SV.log(l_module_name,'stop_id', p_stop_rec.stop_id);
2113: WSH_DEBUG_SV.log(l_module_name,'p_parent_entity_id', p_parent_entity_id);
2114: WSH_DEBUG_SV.log(l_module_name, 'Action', p_in_rec.action_code);
2115: WSH_DEBUG_SV.log(l_module_name, 'Caller', p_in_rec.caller);

Line 2112: WSH_DEBUG_SV.log(l_module_name,'stop_id', p_stop_rec.stop_id);

2108: --
2109: IF l_debug_on THEN
2110: --
2111: WSH_DEBUG_SV.push(l_module_name);
2112: WSH_DEBUG_SV.log(l_module_name,'stop_id', p_stop_rec.stop_id);
2113: WSH_DEBUG_SV.log(l_module_name,'p_parent_entity_id', p_parent_entity_id);
2114: WSH_DEBUG_SV.log(l_module_name, 'Action', p_in_rec.action_code);
2115: WSH_DEBUG_SV.log(l_module_name, 'Caller', p_in_rec.caller);
2116: --

Line 2113: WSH_DEBUG_SV.log(l_module_name,'p_parent_entity_id', p_parent_entity_id);

2109: IF l_debug_on THEN
2110: --
2111: WSH_DEBUG_SV.push(l_module_name);
2112: WSH_DEBUG_SV.log(l_module_name,'stop_id', p_stop_rec.stop_id);
2113: WSH_DEBUG_SV.log(l_module_name,'p_parent_entity_id', p_parent_entity_id);
2114: WSH_DEBUG_SV.log(l_module_name, 'Action', p_in_rec.action_code);
2115: WSH_DEBUG_SV.log(l_module_name, 'Caller', p_in_rec.caller);
2116: --
2117: END IF;

Line 2114: WSH_DEBUG_SV.log(l_module_name, 'Action', p_in_rec.action_code);

2110: --
2111: WSH_DEBUG_SV.push(l_module_name);
2112: WSH_DEBUG_SV.log(l_module_name,'stop_id', p_stop_rec.stop_id);
2113: WSH_DEBUG_SV.log(l_module_name,'p_parent_entity_id', p_parent_entity_id);
2114: WSH_DEBUG_SV.log(l_module_name, 'Action', p_in_rec.action_code);
2115: WSH_DEBUG_SV.log(l_module_name, 'Caller', p_in_rec.caller);
2116: --
2117: END IF;
2118: --

Line 2115: WSH_DEBUG_SV.log(l_module_name, 'Caller', p_in_rec.caller);

2111: WSH_DEBUG_SV.push(l_module_name);
2112: WSH_DEBUG_SV.log(l_module_name,'stop_id', p_stop_rec.stop_id);
2113: WSH_DEBUG_SV.log(l_module_name,'p_parent_entity_id', p_parent_entity_id);
2114: WSH_DEBUG_SV.log(l_module_name, 'Action', p_in_rec.action_code);
2115: WSH_DEBUG_SV.log(l_module_name, 'Caller', p_in_rec.caller);
2116: --
2117: END IF;
2118: --
2119: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2124: WSH_DEBUG_SV.log(l_module_name,'calling eliminate_displayonly_fields');

2120: --
2121: IF p_in_rec.action_code = 'CREATE' THEN
2122: --
2123: IF l_debug_on THEN
2124: WSH_DEBUG_SV.log(l_module_name,'calling eliminate_displayonly_fields');
2125: END IF;
2126: --
2127: -- nothing else need to be disabled
2128: --

Line 2141: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);

2137: END IF;
2138: --
2139: --3509004: public api changes, commented the following code.
2140: /* IF l_debug_on THEN
2141: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
2142: WSH_DEBUG_SV.pop(l_module_name);
2143: END IF;
2144: --
2145: RETURN;

Line 2142: WSH_DEBUG_SV.pop(l_module_name);

2138: --
2139: --3509004: public api changes, commented the following code.
2140: /* IF l_debug_on THEN
2141: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
2142: WSH_DEBUG_SV.pop(l_module_name);
2143: END IF;
2144: --
2145: RETURN;
2146: -- */

Line 2157: WSH_DEBUG_SV.log(l_module_name,'trip_id',l_parent_entity_id);

2153: OPEN get_trip_id(p_stop_rec.stop_id);
2154: FETCH get_trip_id INTO l_parent_entity_id;
2155: --
2156: IF l_debug_on THEN
2157: WSH_DEBUG_SV.log(l_module_name,'trip_id',l_parent_entity_id);
2158: END IF;
2159: --
2160: IF (get_trip_id%NOTFOUND OR l_parent_entity_id IS NULL) THEN
2161: CLOSE get_trip_id;

Line 2188: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);

2184: x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
2185: THEN
2186: --
2187: IF l_debug_on THEN
2188: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
2189: WSH_DEBUG_SV.pop(l_module_name);
2190: END IF;
2191: --
2192: RETURN;

Line 2189: WSH_DEBUG_SV.pop(l_module_name);

2185: THEN
2186: --
2187: IF l_debug_on THEN
2188: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
2189: WSH_DEBUG_SV.pop(l_module_name);
2190: END IF;
2191: --
2192: RETURN;
2193: --

Line 2215: WSH_DEBUG_SV.log(l_module_name,'list.COUNT',l_disabled_list.COUNT);

2211: CLOSE c_tbl_rec;
2212:
2213: --
2214: IF l_debug_on THEN
2215: WSH_DEBUG_SV.log(l_module_name,'list.COUNT',l_disabled_list.COUNT);
2216: END IF;
2217: --
2218: IF l_disabled_list.COUNT = 0 THEN
2219: IF l_debug_on THEN

Line 2220: WSH_DEBUG_SV.log(l_module_name,'calling eliminate_displayonly_fields');

2216: END IF;
2217: --
2218: IF l_disabled_list.COUNT = 0 THEN
2219: IF l_debug_on THEN
2220: WSH_DEBUG_SV.log(l_module_name,'calling eliminate_displayonly_fields');
2221: END IF;
2222: --
2223: -- nothing else need to be disabled
2224: --

Line 2234: WSH_DEBUG_SV.log(l_module_name,'list values',l_disabled_list(i));

2230: --
2231: IF l_debug_on THEN
2232: FOR i in 1..l_disabled_list.COUNT
2233: LOOP
2234: WSH_DEBUG_SV.log(l_module_name,'list values',l_disabled_list(i));
2235: END LOOP;
2236: WSH_DEBUG_SV.log(l_module_name,'calling enable_from_list');
2237: END IF;
2238: --enable the columns matching the l_disabled_list

Line 2236: WSH_DEBUG_SV.log(l_module_name,'calling enable_from_list');

2232: FOR i in 1..l_disabled_list.COUNT
2233: LOOP
2234: WSH_DEBUG_SV.log(l_module_name,'list values',l_disabled_list(i));
2235: END LOOP;
2236: WSH_DEBUG_SV.log(l_module_name,'calling enable_from_list');
2237: END IF;
2238: --enable the columns matching the l_disabled_list
2239: enable_from_list(l_disabled_list,
2240: p_stop_rec,

Line 2258: WSH_DEBUG_SV.log(l_module_name,'list values',l_disabled_list(i));

2254: --
2255: IF l_debug_on THEN
2256: FOR i in 1..l_disabled_list.COUNT
2257: LOOP
2258: WSH_DEBUG_SV.log(l_module_name,'list values',l_disabled_list(i));
2259: END LOOP;
2260: WSH_DEBUG_SV.log(l_module_name,'First element is not FULL');
2261: WSH_DEBUG_SV.log(l_module_name,'calling eliminate_displayonly_fields');
2262: END IF;

Line 2260: WSH_DEBUG_SV.log(l_module_name,'First element is not FULL');

2256: FOR i in 1..l_disabled_list.COUNT
2257: LOOP
2258: WSH_DEBUG_SV.log(l_module_name,'list values',l_disabled_list(i));
2259: END LOOP;
2260: WSH_DEBUG_SV.log(l_module_name,'First element is not FULL');
2261: WSH_DEBUG_SV.log(l_module_name,'calling eliminate_displayonly_fields');
2262: END IF;
2263: --
2264: eliminate_displayonly_fields (p_stop_rec,p_in_rec,x_stop_rec);

Line 2261: WSH_DEBUG_SV.log(l_module_name,'calling eliminate_displayonly_fields');

2257: LOOP
2258: WSH_DEBUG_SV.log(l_module_name,'list values',l_disabled_list(i));
2259: END LOOP;
2260: WSH_DEBUG_SV.log(l_module_name,'First element is not FULL');
2261: WSH_DEBUG_SV.log(l_module_name,'calling eliminate_displayonly_fields');
2262: END IF;
2263: --
2264: eliminate_displayonly_fields (p_stop_rec,p_in_rec,x_stop_rec);
2265: --

Line 2267: WSH_DEBUG_SV.log(l_module_name,'calling disable_from_list');

2263: --
2264: eliminate_displayonly_fields (p_stop_rec,p_in_rec,x_stop_rec);
2265: --
2266: IF l_debug_on THEN
2267: WSH_DEBUG_SV.log(l_module_name,'calling disable_from_list');
2268: END IF;
2269: -- The fileds in the list are getting disabled
2270: disable_from_list(l_disabled_list,
2271: l_db_col_rec,

Line 2303: WSH_DEBUG_SV.pop(l_module_name);

2299: --
2300: END IF;
2301:
2302: IF l_debug_on THEN
2303: WSH_DEBUG_SV.pop(l_module_name);
2304: END IF;
2305:
2306: EXCEPTION
2307: WHEN e_all_disabled THEN

Line 2321: WSH_DEBUG_SV.pop(l_module_name,'e_all_disabled');

2317: FND_MESSAGE.Set_Token('ENTITY_ID',p_stop_rec.stop_id);
2318: wsh_util_core.add_message(x_return_status,l_module_name);
2319: IF l_debug_on THEN
2320: -- Nothing is updateable
2321: WSH_DEBUG_SV.pop(l_module_name,'e_all_disabled');
2322: END IF;
2323: WHEN e_dp_no_entity THEN
2324: -- OTM R12, glog proj, close open cursors
2325: IF get_trip_id%ISOPEN THEN

Line 2334: WSH_DEBUG_SV.pop(l_module_name,'e_dp_no_entity');

2330: END IF;
2331: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2332: -- the message for this is set in original get_disabled_list
2333: IF l_debug_on THEN
2334: WSH_DEBUG_SV.pop(l_module_name,'e_dp_no_entity');
2335: END IF;
2336: WHEN e_bad_field THEN
2337: -- OTM R12, glog proj, close open cursors
2338: IF get_trip_id%ISOPEN THEN

Line 2349: WSH_DEBUG_SV.log(l_module_name,'Bad field name passed to the list:'

2345: FND_MESSAGE.SET_NAME('WSH','WSH_BAD_FIELD_NAME');
2346: FND_MESSAGE.Set_Token('FIELD_NAME',l_field_name);
2347: wsh_util_core.add_message(x_return_status,l_module_name);
2348: IF l_debug_on THEN
2349: WSH_DEBUG_SV.log(l_module_name,'Bad field name passed to the list:'
2350: ,l_field_name);
2351: WSH_DEBUG_SV.pop(l_module_name,'e_bad_field');
2352: END IF;
2353:

Line 2351: WSH_DEBUG_SV.pop(l_module_name,'e_bad_field');

2347: wsh_util_core.add_message(x_return_status,l_module_name);
2348: IF l_debug_on THEN
2349: WSH_DEBUG_SV.log(l_module_name,'Bad field name passed to the list:'
2350: ,l_field_name);
2351: WSH_DEBUG_SV.pop(l_module_name,'e_bad_field');
2352: END IF;
2353:
2354: WHEN OTHERS THEN
2355: -- OTM R12, glog proj, close open cursors

Line 2365: WSH_DEBUG_SV.log(l_module_name,'Error:',SUBSTR(SQLERRM,1,200));

2361: END IF;
2362: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2363: wsh_util_core.default_handler('WSH_TRIP_STOPS_VALIDATIONS.get_disabled_list', l_module_name);
2364: IF l_debug_on THEN
2365: WSH_DEBUG_SV.log(l_module_name,'Error:',SUBSTR(SQLERRM,1,200));
2366: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2367: END IF;
2368: END Get_Disabled_List;
2369:

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

2362: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2363: wsh_util_core.default_handler('WSH_TRIP_STOPS_VALIDATIONS.get_disabled_list', l_module_name);
2364: IF l_debug_on THEN
2365: WSH_DEBUG_SV.log(l_module_name,'Error:',SUBSTR(SQLERRM,1,200));
2366: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2367: END IF;
2368: END Get_Disabled_List;
2369:
2370:

Line 2390: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2386: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2387: --
2388: IF l_debug_on IS NULL
2389: THEN
2390: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2391: END IF;
2392: --
2393: IF l_debug_on THEN
2394: WSH_DEBUG_SV.push(l_module_name);

Line 2394: WSH_DEBUG_SV.push(l_module_name);

2390: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2391: END IF;
2392: --
2393: IF l_debug_on THEN
2394: WSH_DEBUG_SV.push(l_module_name);
2395: --
2396: WSH_DEBUG_SV.log(l_module_name,'p_action', p_action);
2397: END IF;
2398: --

Line 2396: WSH_DEBUG_SV.log(l_module_name,'p_action', p_action);

2392: --
2393: IF l_debug_on THEN
2394: WSH_DEBUG_SV.push(l_module_name);
2395: --
2396: WSH_DEBUG_SV.log(l_module_name,'p_action', p_action);
2397: END IF;
2398: --
2399: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2400:

Line 2466: WSH_DEBUG_SV.pop(l_module_name);

2462: END IF;
2463: -- J-IB-NPARIKH-}
2464:
2465: IF l_debug_on THEN
2466: WSH_DEBUG_SV.pop(l_module_name);
2467: END IF;
2468: EXCEPTION
2469: WHEN OTHERS THEN
2470: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 2473: WSH_DEBUG_SV.log(l_module_name,'Error:',SUBSTR(SQLERRM,1,200));

2469: WHEN OTHERS THEN
2470: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2471: wsh_util_core.default_handler('WSH_TRIP_STOPS_VALIDATIONS.get_disabled_list', l_module_name);
2472: IF l_debug_on THEN
2473: WSH_DEBUG_SV.log(l_module_name,'Error:',SUBSTR(SQLERRM,1,200));
2474: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2475: END IF;
2476:
2477: END Init_Stop_Actions_Tbl;

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

2470: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2471: wsh_util_core.default_handler('WSH_TRIP_STOPS_VALIDATIONS.get_disabled_list', l_module_name);
2472: IF l_debug_on THEN
2473: WSH_DEBUG_SV.log(l_module_name,'Error:',SUBSTR(SQLERRM,1,200));
2474: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2475: END IF;
2476:
2477: END Init_Stop_Actions_Tbl;
2478:

Line 2558: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2554: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2555: --
2556: IF l_debug_on IS NULL
2557: THEN
2558: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2559: END IF;
2560: --
2561: IF l_debug_on THEN
2562: WSH_DEBUG_SV.push(l_module_name);

Line 2562: WSH_DEBUG_SV.push(l_module_name);

2558: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2559: END IF;
2560: --
2561: IF l_debug_on THEN
2562: WSH_DEBUG_SV.push(l_module_name);
2563: WSH_DEBUG_SV.log(l_module_name,'p_trip_id',p_trip_id);
2564: WSH_DEBUG_SV.log(l_module_name,'p_stop_id',p_stop_id);
2565: WSH_DEBUG_SV.log(l_module_name,'p_action',p_action);
2566: WSH_DEBUG_SV.log(l_module_name,'p_shipment_direction',p_shipment_direction);

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

2559: END IF;
2560: --
2561: IF l_debug_on THEN
2562: WSH_DEBUG_SV.push(l_module_name);
2563: WSH_DEBUG_SV.log(l_module_name,'p_trip_id',p_trip_id);
2564: WSH_DEBUG_SV.log(l_module_name,'p_stop_id',p_stop_id);
2565: WSH_DEBUG_SV.log(l_module_name,'p_action',p_action);
2566: WSH_DEBUG_SV.log(l_module_name,'p_shipment_direction',p_shipment_direction);
2567: WSH_DEBUG_SV.log(l_module_name,'x_shipments_type_flag',x_shipments_type_flag);

Line 2564: WSH_DEBUG_SV.log(l_module_name,'p_stop_id',p_stop_id);

2560: --
2561: IF l_debug_on THEN
2562: WSH_DEBUG_SV.push(l_module_name);
2563: WSH_DEBUG_SV.log(l_module_name,'p_trip_id',p_trip_id);
2564: WSH_DEBUG_SV.log(l_module_name,'p_stop_id',p_stop_id);
2565: WSH_DEBUG_SV.log(l_module_name,'p_action',p_action);
2566: WSH_DEBUG_SV.log(l_module_name,'p_shipment_direction',p_shipment_direction);
2567: WSH_DEBUG_SV.log(l_module_name,'x_shipments_type_flag',x_shipments_type_flag);
2568: END IF;

Line 2565: WSH_DEBUG_SV.log(l_module_name,'p_action',p_action);

2561: IF l_debug_on THEN
2562: WSH_DEBUG_SV.push(l_module_name);
2563: WSH_DEBUG_SV.log(l_module_name,'p_trip_id',p_trip_id);
2564: WSH_DEBUG_SV.log(l_module_name,'p_stop_id',p_stop_id);
2565: WSH_DEBUG_SV.log(l_module_name,'p_action',p_action);
2566: WSH_DEBUG_SV.log(l_module_name,'p_shipment_direction',p_shipment_direction);
2567: WSH_DEBUG_SV.log(l_module_name,'x_shipments_type_flag',x_shipments_type_flag);
2568: END IF;
2569: --

Line 2566: WSH_DEBUG_SV.log(l_module_name,'p_shipment_direction',p_shipment_direction);

2562: WSH_DEBUG_SV.push(l_module_name);
2563: WSH_DEBUG_SV.log(l_module_name,'p_trip_id',p_trip_id);
2564: WSH_DEBUG_SV.log(l_module_name,'p_stop_id',p_stop_id);
2565: WSH_DEBUG_SV.log(l_module_name,'p_action',p_action);
2566: WSH_DEBUG_SV.log(l_module_name,'p_shipment_direction',p_shipment_direction);
2567: WSH_DEBUG_SV.log(l_module_name,'x_shipments_type_flag',x_shipments_type_flag);
2568: END IF;
2569: --
2570: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 2567: WSH_DEBUG_SV.log(l_module_name,'x_shipments_type_flag',x_shipments_type_flag);

2563: WSH_DEBUG_SV.log(l_module_name,'p_trip_id',p_trip_id);
2564: WSH_DEBUG_SV.log(l_module_name,'p_stop_id',p_stop_id);
2565: WSH_DEBUG_SV.log(l_module_name,'p_action',p_action);
2566: WSH_DEBUG_SV.log(l_module_name,'p_shipment_direction',p_shipment_direction);
2567: WSH_DEBUG_SV.log(l_module_name,'x_shipments_type_flag',x_shipments_type_flag);
2568: END IF;
2569: --
2570: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2571: --

Line 2609: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_VALIDATIONS.has_inbound_deliveries',WSH_DEBUG_SV.C_PROC_LEVEL);

2605: IF NVL(p_shipment_direction,'O') IN ('O','IO')
2606: THEN
2607: --{
2608: IF l_debug_on THEN
2609: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_VALIDATIONS.has_inbound_deliveries',WSH_DEBUG_SV.C_PROC_LEVEL);
2610: END IF;
2611: --
2612: IF
2613: WSH_TRIP_VALIDATIONS.has_inbound_deliveries

Line 2634: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_VALIDATIONS.has_outbound_deliveries',WSH_DEBUG_SV.C_PROC_LEVEL);

2630: IF NVL(p_shipment_direction,'O') NOT IN ('O','IO')
2631: THEN
2632: --{
2633: IF l_debug_on THEN
2634: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_VALIDATIONS.has_outbound_deliveries',WSH_DEBUG_SV.C_PROC_LEVEL);
2635: END IF;
2636: --
2637: IF
2638: WSH_TRIP_VALIDATIONS.has_outbound_deliveries

Line 2664: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_VALIDATIONS.has_outbound_deliveries',WSH_DEBUG_SV.C_PROC_LEVEL);

2660: IF NVL(p_shipment_direction,'O') IN ('O','IO')
2661: THEN
2662: --{
2663: IF l_debug_on THEN
2664: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_VALIDATIONS.has_outbound_deliveries',WSH_DEBUG_SV.C_PROC_LEVEL);
2665: END IF;
2666: --
2667: IF
2668: WSH_TRIP_VALIDATIONS.has_outbound_deliveries

Line 2683: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_VALIDATIONS.has_inbound_deliveries',WSH_DEBUG_SV.C_PROC_LEVEL);

2679: --}
2680: ELSE
2681: --{
2682: IF l_debug_on THEN
2683: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_VALIDATIONS.has_inbound_deliveries',WSH_DEBUG_SV.C_PROC_LEVEL);
2684: END IF;
2685: --
2686: IF
2687: WSH_TRIP_VALIDATIONS.has_inbound_deliveries

Line 2707: WSH_DEBUG_SV.log(l_module_name,'x_shipments_type_flag',x_shipments_type_flag);

2703: END IF;
2704: --
2705: --
2706: IF l_debug_on THEN
2707: WSH_DEBUG_SV.log(l_module_name,'x_shipments_type_flag',x_shipments_type_flag);
2708: WSH_DEBUG_SV.pop(l_module_name);
2709: END IF;
2710: --}
2711: EXCEPTION

Line 2708: WSH_DEBUG_SV.pop(l_module_name);

2704: --
2705: --
2706: IF l_debug_on THEN
2707: WSH_DEBUG_SV.log(l_module_name,'x_shipments_type_flag',x_shipments_type_flag);
2708: WSH_DEBUG_SV.pop(l_module_name);
2709: END IF;
2710: --}
2711: EXCEPTION
2712: --{

Line 2719: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2715:
2716: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2717: --
2718: IF l_debug_on THEN
2719: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2720: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2721: END IF;
2722: --
2723: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2716: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2717: --
2718: IF l_debug_on THEN
2719: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2720: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2721: END IF;
2722: --
2723: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2724:

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

2724:
2725: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2726: --
2727: IF l_debug_on THEN
2728: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2729: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2730: END IF;
2731: --
2732: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

Line 2729: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

2725: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2726: --
2727: IF l_debug_on THEN
2728: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2729: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2730: END IF;
2731: --
2732: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2733: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 2736: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2732: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2733: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2734: --
2735: IF l_debug_on THEN
2736: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2737: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2738: END IF;
2739: WHEN OTHERS THEN
2740: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 2737: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');

2733: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2734: --
2735: IF l_debug_on THEN
2736: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2737: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2738: END IF;
2739: WHEN OTHERS THEN
2740: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2741: wsh_util_core.default_handler('WSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag', l_module_name);

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

2739: WHEN OTHERS THEN
2740: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2741: wsh_util_core.default_handler('WSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag', l_module_name);
2742: IF l_debug_on THEN
2743: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2744: END IF;
2745: --}
2746: END refreshShipmentsTypeFlag;
2747: --

Line 3221: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

3217: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3218: --
3219: IF l_debug_on IS NULL
3220: THEN
3221: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3222: END IF;
3223: --
3224: IF l_debug_on THEN
3225: WSH_DEBUG_SV.push(l_module_name);

Line 3225: WSH_DEBUG_SV.push(l_module_name);

3221: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3222: END IF;
3223: --
3224: IF l_debug_on THEN
3225: WSH_DEBUG_SV.push(l_module_name);
3226: --
3227: WSH_DEBUG_SV.log(l_module_name,'P_in_rec.STOP_ID',P_in_rec.STOP_ID);
3228: WSH_DEBUG_SV.log(l_module_name,'P_in_rec.put_messages',P_in_rec.put_messages);
3229: WSH_DEBUG_SV.log(l_module_name,'P_in_rec.caller',P_in_rec.caller);

Line 3227: WSH_DEBUG_SV.log(l_module_name,'P_in_rec.STOP_ID',P_in_rec.STOP_ID);

3223: --
3224: IF l_debug_on THEN
3225: WSH_DEBUG_SV.push(l_module_name);
3226: --
3227: WSH_DEBUG_SV.log(l_module_name,'P_in_rec.STOP_ID',P_in_rec.STOP_ID);
3228: WSH_DEBUG_SV.log(l_module_name,'P_in_rec.put_messages',P_in_rec.put_messages);
3229: WSH_DEBUG_SV.log(l_module_name,'P_in_rec.caller',P_in_rec.caller);
3230: WSH_DEBUG_SV.log(l_module_name,'P_in_rec.actual_date',P_in_rec.actual_date);
3231: END IF;

Line 3228: WSH_DEBUG_SV.log(l_module_name,'P_in_rec.put_messages',P_in_rec.put_messages);

3224: IF l_debug_on THEN
3225: WSH_DEBUG_SV.push(l_module_name);
3226: --
3227: WSH_DEBUG_SV.log(l_module_name,'P_in_rec.STOP_ID',P_in_rec.STOP_ID);
3228: WSH_DEBUG_SV.log(l_module_name,'P_in_rec.put_messages',P_in_rec.put_messages);
3229: WSH_DEBUG_SV.log(l_module_name,'P_in_rec.caller',P_in_rec.caller);
3230: WSH_DEBUG_SV.log(l_module_name,'P_in_rec.actual_date',P_in_rec.actual_date);
3231: END IF;
3232: --

Line 3229: WSH_DEBUG_SV.log(l_module_name,'P_in_rec.caller',P_in_rec.caller);

3225: WSH_DEBUG_SV.push(l_module_name);
3226: --
3227: WSH_DEBUG_SV.log(l_module_name,'P_in_rec.STOP_ID',P_in_rec.STOP_ID);
3228: WSH_DEBUG_SV.log(l_module_name,'P_in_rec.put_messages',P_in_rec.put_messages);
3229: WSH_DEBUG_SV.log(l_module_name,'P_in_rec.caller',P_in_rec.caller);
3230: WSH_DEBUG_SV.log(l_module_name,'P_in_rec.actual_date',P_in_rec.actual_date);
3231: END IF;
3232: --
3233: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 3230: WSH_DEBUG_SV.log(l_module_name,'P_in_rec.actual_date',P_in_rec.actual_date);

3226: --
3227: WSH_DEBUG_SV.log(l_module_name,'P_in_rec.STOP_ID',P_in_rec.STOP_ID);
3228: WSH_DEBUG_SV.log(l_module_name,'P_in_rec.put_messages',P_in_rec.put_messages);
3229: WSH_DEBUG_SV.log(l_module_name,'P_in_rec.caller',P_in_rec.caller);
3230: WSH_DEBUG_SV.log(l_module_name,'P_in_rec.actual_date',P_in_rec.actual_date);
3231: END IF;
3232: --
3233: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3234: l_stop_warnings := 0;

Line 3341: WSH_DEBUG_SV.log(l_module_name,'l_linked_stop_info_rec.stop_id',l_linked_stop_info_rec.stop_id);

3337: END IF;
3338: --
3339: --
3340: IF l_debug_on THEN
3341: WSH_DEBUG_SV.log(l_module_name,'l_linked_stop_info_rec.stop_id',l_linked_stop_info_rec.stop_id);
3342: WSH_DEBUG_SV.log(l_module_name,'l_linked_stop_info_rec.stop_location_id',l_linked_stop_info_rec.stop_location_id);
3343: END IF;
3344:
3345: IF (p_in_rec.caller LIKE 'FTE%'

Line 3342: WSH_DEBUG_SV.log(l_module_name,'l_linked_stop_info_rec.stop_location_id',l_linked_stop_info_rec.stop_location_id);

3338: --
3339: --
3340: IF l_debug_on THEN
3341: WSH_DEBUG_SV.log(l_module_name,'l_linked_stop_info_rec.stop_id',l_linked_stop_info_rec.stop_id);
3342: WSH_DEBUG_SV.log(l_module_name,'l_linked_stop_info_rec.stop_location_id',l_linked_stop_info_rec.stop_location_id);
3343: END IF;
3344:
3345: IF (p_in_rec.caller LIKE 'FTE%'
3346: OR p_in_rec.caller LIKE 'WSH_IB%')

Line 3376: WSH_DEBUG_SV.log(l_module_name,'l_stop_info_rec.stop_Sequence_number',l_stop_info_rec.stop_Sequence_number);

3372: x_out_rec.trip_seal_code := l_stop_info_rec.trip_seal_code;
3373: x_out_rec.trip_name := l_stop_info_rec.trip_name;
3374: --
3375: IF l_debug_on THEN
3376: WSH_DEBUG_SV.log(l_module_name,'l_stop_info_rec.stop_Sequence_number',l_stop_info_rec.stop_Sequence_number);
3377: WSH_DEBUG_SV.log(l_module_name,'l_stop_info_rec.trip_id',l_stop_info_rec.trip_id);
3378: WSH_DEBUG_SV.log(l_module_name,'l_stop_info_Rec.trip_Status_Code',l_stop_info_Rec.trip_Status_Code);
3379: WSH_DEBUG_SV.log(l_module_name,'l_stop_info_Rec.shipments_Type_flag',l_stop_info_Rec.shipments_Type_flag);
3380: WSH_DEBUG_SV.log(l_module_name,'l_linked_stop_info_Rec.shipments_Type_flag',l_linked_stop_info_Rec.shipments_Type_flag);

Line 3377: WSH_DEBUG_SV.log(l_module_name,'l_stop_info_rec.trip_id',l_stop_info_rec.trip_id);

3373: x_out_rec.trip_name := l_stop_info_rec.trip_name;
3374: --
3375: IF l_debug_on THEN
3376: WSH_DEBUG_SV.log(l_module_name,'l_stop_info_rec.stop_Sequence_number',l_stop_info_rec.stop_Sequence_number);
3377: WSH_DEBUG_SV.log(l_module_name,'l_stop_info_rec.trip_id',l_stop_info_rec.trip_id);
3378: WSH_DEBUG_SV.log(l_module_name,'l_stop_info_Rec.trip_Status_Code',l_stop_info_Rec.trip_Status_Code);
3379: WSH_DEBUG_SV.log(l_module_name,'l_stop_info_Rec.shipments_Type_flag',l_stop_info_Rec.shipments_Type_flag);
3380: WSH_DEBUG_SV.log(l_module_name,'l_linked_stop_info_Rec.shipments_Type_flag',l_linked_stop_info_Rec.shipments_Type_flag);
3381: WSH_DEBUG_SV.log(l_module_name,'l_virtual_shipments_Type_flag',l_virtual_shipments_Type_flag);

Line 3378: WSH_DEBUG_SV.log(l_module_name,'l_stop_info_Rec.trip_Status_Code',l_stop_info_Rec.trip_Status_Code);

3374: --
3375: IF l_debug_on THEN
3376: WSH_DEBUG_SV.log(l_module_name,'l_stop_info_rec.stop_Sequence_number',l_stop_info_rec.stop_Sequence_number);
3377: WSH_DEBUG_SV.log(l_module_name,'l_stop_info_rec.trip_id',l_stop_info_rec.trip_id);
3378: WSH_DEBUG_SV.log(l_module_name,'l_stop_info_Rec.trip_Status_Code',l_stop_info_Rec.trip_Status_Code);
3379: WSH_DEBUG_SV.log(l_module_name,'l_stop_info_Rec.shipments_Type_flag',l_stop_info_Rec.shipments_Type_flag);
3380: WSH_DEBUG_SV.log(l_module_name,'l_linked_stop_info_Rec.shipments_Type_flag',l_linked_stop_info_Rec.shipments_Type_flag);
3381: WSH_DEBUG_SV.log(l_module_name,'l_virtual_shipments_Type_flag',l_virtual_shipments_Type_flag);
3382: END IF;

Line 3379: WSH_DEBUG_SV.log(l_module_name,'l_stop_info_Rec.shipments_Type_flag',l_stop_info_Rec.shipments_Type_flag);

3375: IF l_debug_on THEN
3376: WSH_DEBUG_SV.log(l_module_name,'l_stop_info_rec.stop_Sequence_number',l_stop_info_rec.stop_Sequence_number);
3377: WSH_DEBUG_SV.log(l_module_name,'l_stop_info_rec.trip_id',l_stop_info_rec.trip_id);
3378: WSH_DEBUG_SV.log(l_module_name,'l_stop_info_Rec.trip_Status_Code',l_stop_info_Rec.trip_Status_Code);
3379: WSH_DEBUG_SV.log(l_module_name,'l_stop_info_Rec.shipments_Type_flag',l_stop_info_Rec.shipments_Type_flag);
3380: WSH_DEBUG_SV.log(l_module_name,'l_linked_stop_info_Rec.shipments_Type_flag',l_linked_stop_info_Rec.shipments_Type_flag);
3381: WSH_DEBUG_SV.log(l_module_name,'l_virtual_shipments_Type_flag',l_virtual_shipments_Type_flag);
3382: END IF;
3383: --

Line 3380: WSH_DEBUG_SV.log(l_module_name,'l_linked_stop_info_Rec.shipments_Type_flag',l_linked_stop_info_Rec.shipments_Type_flag);

3376: WSH_DEBUG_SV.log(l_module_name,'l_stop_info_rec.stop_Sequence_number',l_stop_info_rec.stop_Sequence_number);
3377: WSH_DEBUG_SV.log(l_module_name,'l_stop_info_rec.trip_id',l_stop_info_rec.trip_id);
3378: WSH_DEBUG_SV.log(l_module_name,'l_stop_info_Rec.trip_Status_Code',l_stop_info_Rec.trip_Status_Code);
3379: WSH_DEBUG_SV.log(l_module_name,'l_stop_info_Rec.shipments_Type_flag',l_stop_info_Rec.shipments_Type_flag);
3380: WSH_DEBUG_SV.log(l_module_name,'l_linked_stop_info_Rec.shipments_Type_flag',l_linked_stop_info_Rec.shipments_Type_flag);
3381: WSH_DEBUG_SV.log(l_module_name,'l_virtual_shipments_Type_flag',l_virtual_shipments_Type_flag);
3382: END IF;
3383: --
3384:

Line 3381: WSH_DEBUG_SV.log(l_module_name,'l_virtual_shipments_Type_flag',l_virtual_shipments_Type_flag);

3377: WSH_DEBUG_SV.log(l_module_name,'l_stop_info_rec.trip_id',l_stop_info_rec.trip_id);
3378: WSH_DEBUG_SV.log(l_module_name,'l_stop_info_Rec.trip_Status_Code',l_stop_info_Rec.trip_Status_Code);
3379: WSH_DEBUG_SV.log(l_module_name,'l_stop_info_Rec.shipments_Type_flag',l_stop_info_Rec.shipments_Type_flag);
3380: WSH_DEBUG_SV.log(l_module_name,'l_linked_stop_info_Rec.shipments_Type_flag',l_linked_stop_info_Rec.shipments_Type_flag);
3381: WSH_DEBUG_SV.log(l_module_name,'l_virtual_shipments_Type_flag',l_virtual_shipments_Type_flag);
3382: END IF;
3383: --
3384:
3385: -- Check for Exceptions against Trip Stop and its Contents

Line 3387: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.Check_Exceptions',WSH_DEBUG_SV.C_PROC_LEVEL);

3383: --
3384:
3385: -- Check for Exceptions against Trip Stop and its Contents
3386: IF l_debug_on THEN
3387: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.Check_Exceptions',WSH_DEBUG_SV.C_PROC_LEVEL);
3388: END IF;
3389: l_exceptions_tbl.delete;
3390: l_exp_logged := FALSE;
3391: WSH_XC_UTIL.Check_Exceptions (

Line 3515: WSH_DEBUG_SV.log(l_module_name,'prev_stop_rec.shipments_type_flag',prev_stop_rec.shipments_type_flag);

3511: --}
3512: END IF;
3513: --
3514: IF l_debug_on THEN
3515: WSH_DEBUG_SV.log(l_module_name,'prev_stop_rec.shipments_type_flag',prev_stop_rec.shipments_type_flag);
3516: WSH_DEBUG_SV.log(l_module_name,'prev_stop_rec.stop_location_id',prev_stop_rec.stop_location_id);
3517: END IF;
3518: --
3519: --

Line 3516: WSH_DEBUG_SV.log(l_module_name,'prev_stop_rec.stop_location_id',prev_stop_rec.stop_location_id);

3512: END IF;
3513: --
3514: IF l_debug_on THEN
3515: WSH_DEBUG_SV.log(l_module_name,'prev_stop_rec.shipments_type_flag',prev_stop_rec.shipments_type_flag);
3516: WSH_DEBUG_SV.log(l_module_name,'prev_stop_rec.stop_location_id',prev_stop_rec.stop_location_id);
3517: END IF;
3518: --
3519: --
3520: IF l_virtual_shipments_type_flag IN ( 'M' , 'O' )

Line 3582: WSH_DEBUG_SV.log(l_module_name,'open_pickup_dlvy_rec.shipment_direction',open_pickup_dlvy_rec.shipment_direction);

3578: --}
3579: END IF;
3580: --
3581: IF l_debug_on THEN
3582: WSH_DEBUG_SV.log(l_module_name,'open_pickup_dlvy_rec.shipment_direction',open_pickup_dlvy_rec.shipment_direction);
3583: END IF;
3584: --
3585: --
3586: IF open_pickup_dlvy_rec.shipment_direction IN ( 'O', 'IO' )

Line 3657: WSH_DEBUG_SV.log(l_module_name,'open_dropoff_dlvy_rec.shipment_direction',open_dropoff_dlvy_rec.shipment_direction);

3653: --}
3654: END IF;
3655: --
3656: IF l_debug_on THEN
3657: WSH_DEBUG_SV.log(l_module_name,'open_dropoff_dlvy_rec.shipment_direction',open_dropoff_dlvy_rec.shipment_direction);
3658: WSH_DEBUG_SV.log(l_module_name,'open_dropoff_dlvy_rec.status_Code',open_dropoff_dlvy_rec.status_Code);
3659: WSH_DEBUG_SV.log(l_module_name,'open_dropoff_dlvy_rec.ultimate_Dropoff_location_id',open_dropoff_dlvy_rec.ultimate_Dropoff_location_id);
3660: END IF;
3661: --

Line 3658: WSH_DEBUG_SV.log(l_module_name,'open_dropoff_dlvy_rec.status_Code',open_dropoff_dlvy_rec.status_Code);

3654: END IF;
3655: --
3656: IF l_debug_on THEN
3657: WSH_DEBUG_SV.log(l_module_name,'open_dropoff_dlvy_rec.shipment_direction',open_dropoff_dlvy_rec.shipment_direction);
3658: WSH_DEBUG_SV.log(l_module_name,'open_dropoff_dlvy_rec.status_Code',open_dropoff_dlvy_rec.status_Code);
3659: WSH_DEBUG_SV.log(l_module_name,'open_dropoff_dlvy_rec.ultimate_Dropoff_location_id',open_dropoff_dlvy_rec.ultimate_Dropoff_location_id);
3660: END IF;
3661: --
3662: --

Line 3659: WSH_DEBUG_SV.log(l_module_name,'open_dropoff_dlvy_rec.ultimate_Dropoff_location_id',open_dropoff_dlvy_rec.ultimate_Dropoff_location_id);

3655: --
3656: IF l_debug_on THEN
3657: WSH_DEBUG_SV.log(l_module_name,'open_dropoff_dlvy_rec.shipment_direction',open_dropoff_dlvy_rec.shipment_direction);
3658: WSH_DEBUG_SV.log(l_module_name,'open_dropoff_dlvy_rec.status_Code',open_dropoff_dlvy_rec.status_Code);
3659: WSH_DEBUG_SV.log(l_module_name,'open_dropoff_dlvy_rec.ultimate_Dropoff_location_id',open_dropoff_dlvy_rec.ultimate_Dropoff_location_id);
3660: END IF;
3661: --
3662: --
3663: -- note that open_dropoff_dlvy_csr filters the deliveries by status,

Line 3775: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_shipments_type_flag',prev_leg_rec.do_stop_shipments_type_flag);

3771: )
3772: LOOP
3773: --{
3774: IF l_debug_on THEN
3775: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_shipments_type_flag',prev_leg_rec.do_stop_shipments_type_flag);
3776: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_status_code',prev_leg_rec.do_stop_status_code);
3777: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_locationId',prev_leg_rec.do_stop_locationId);
3778: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_id',prev_leg_rec.do_stop_id);
3779: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_shipments_type_flag',prev_leg_rec.pu_stop_shipments_type_flag);

Line 3776: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_status_code',prev_leg_rec.do_stop_status_code);

3772: LOOP
3773: --{
3774: IF l_debug_on THEN
3775: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_shipments_type_flag',prev_leg_rec.do_stop_shipments_type_flag);
3776: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_status_code',prev_leg_rec.do_stop_status_code);
3777: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_locationId',prev_leg_rec.do_stop_locationId);
3778: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_id',prev_leg_rec.do_stop_id);
3779: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_shipments_type_flag',prev_leg_rec.pu_stop_shipments_type_flag);
3780: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_status_code',prev_leg_rec.pu_stop_status_code);

Line 3777: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_locationId',prev_leg_rec.do_stop_locationId);

3773: --{
3774: IF l_debug_on THEN
3775: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_shipments_type_flag',prev_leg_rec.do_stop_shipments_type_flag);
3776: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_status_code',prev_leg_rec.do_stop_status_code);
3777: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_locationId',prev_leg_rec.do_stop_locationId);
3778: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_id',prev_leg_rec.do_stop_id);
3779: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_shipments_type_flag',prev_leg_rec.pu_stop_shipments_type_flag);
3780: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_status_code',prev_leg_rec.pu_stop_status_code);
3781: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_locationId',prev_leg_rec.pu_stop_locationId);

Line 3778: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_id',prev_leg_rec.do_stop_id);

3774: IF l_debug_on THEN
3775: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_shipments_type_flag',prev_leg_rec.do_stop_shipments_type_flag);
3776: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_status_code',prev_leg_rec.do_stop_status_code);
3777: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_locationId',prev_leg_rec.do_stop_locationId);
3778: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_id',prev_leg_rec.do_stop_id);
3779: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_shipments_type_flag',prev_leg_rec.pu_stop_shipments_type_flag);
3780: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_status_code',prev_leg_rec.pu_stop_status_code);
3781: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_locationId',prev_leg_rec.pu_stop_locationId);
3782: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_id',prev_leg_rec.pu_stop_id);

Line 3779: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_shipments_type_flag',prev_leg_rec.pu_stop_shipments_type_flag);

3775: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_shipments_type_flag',prev_leg_rec.do_stop_shipments_type_flag);
3776: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_status_code',prev_leg_rec.do_stop_status_code);
3777: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_locationId',prev_leg_rec.do_stop_locationId);
3778: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_id',prev_leg_rec.do_stop_id);
3779: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_shipments_type_flag',prev_leg_rec.pu_stop_shipments_type_flag);
3780: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_status_code',prev_leg_rec.pu_stop_status_code);
3781: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_locationId',prev_leg_rec.pu_stop_locationId);
3782: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_id',prev_leg_rec.pu_stop_id);
3783: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.shipment_direction',prev_leg_rec.shipment_direction);

Line 3780: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_status_code',prev_leg_rec.pu_stop_status_code);

3776: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_status_code',prev_leg_rec.do_stop_status_code);
3777: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_locationId',prev_leg_rec.do_stop_locationId);
3778: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_id',prev_leg_rec.do_stop_id);
3779: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_shipments_type_flag',prev_leg_rec.pu_stop_shipments_type_flag);
3780: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_status_code',prev_leg_rec.pu_stop_status_code);
3781: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_locationId',prev_leg_rec.pu_stop_locationId);
3782: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_id',prev_leg_rec.pu_stop_id);
3783: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.shipment_direction',prev_leg_rec.shipment_direction);
3784: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.dlvy_status_code',prev_leg_rec.dlvy_status_code);

Line 3781: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_locationId',prev_leg_rec.pu_stop_locationId);

3777: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_locationId',prev_leg_rec.do_stop_locationId);
3778: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_id',prev_leg_rec.do_stop_id);
3779: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_shipments_type_flag',prev_leg_rec.pu_stop_shipments_type_flag);
3780: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_status_code',prev_leg_rec.pu_stop_status_code);
3781: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_locationId',prev_leg_rec.pu_stop_locationId);
3782: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_id',prev_leg_rec.pu_stop_id);
3783: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.shipment_direction',prev_leg_rec.shipment_direction);
3784: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.dlvy_status_code',prev_leg_rec.dlvy_status_code);
3785: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.delivery_id',prev_leg_rec.delivery_id);

Line 3782: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_id',prev_leg_rec.pu_stop_id);

3778: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_id',prev_leg_rec.do_stop_id);
3779: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_shipments_type_flag',prev_leg_rec.pu_stop_shipments_type_flag);
3780: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_status_code',prev_leg_rec.pu_stop_status_code);
3781: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_locationId',prev_leg_rec.pu_stop_locationId);
3782: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_id',prev_leg_rec.pu_stop_id);
3783: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.shipment_direction',prev_leg_rec.shipment_direction);
3784: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.dlvy_status_code',prev_leg_rec.dlvy_status_code);
3785: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.delivery_id',prev_leg_rec.delivery_id);
3786: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.dlvy_initialPULocationId',prev_leg_rec.dlvy_initialPULocationId);

Line 3783: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.shipment_direction',prev_leg_rec.shipment_direction);

3779: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_shipments_type_flag',prev_leg_rec.pu_stop_shipments_type_flag);
3780: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_status_code',prev_leg_rec.pu_stop_status_code);
3781: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_locationId',prev_leg_rec.pu_stop_locationId);
3782: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_id',prev_leg_rec.pu_stop_id);
3783: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.shipment_direction',prev_leg_rec.shipment_direction);
3784: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.dlvy_status_code',prev_leg_rec.dlvy_status_code);
3785: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.delivery_id',prev_leg_rec.delivery_id);
3786: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.dlvy_initialPULocationId',prev_leg_rec.dlvy_initialPULocationId);
3787: END IF;

Line 3784: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.dlvy_status_code',prev_leg_rec.dlvy_status_code);

3780: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_status_code',prev_leg_rec.pu_stop_status_code);
3781: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_locationId',prev_leg_rec.pu_stop_locationId);
3782: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_id',prev_leg_rec.pu_stop_id);
3783: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.shipment_direction',prev_leg_rec.shipment_direction);
3784: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.dlvy_status_code',prev_leg_rec.dlvy_status_code);
3785: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.delivery_id',prev_leg_rec.delivery_id);
3786: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.dlvy_initialPULocationId',prev_leg_rec.dlvy_initialPULocationId);
3787: END IF;
3788: --

Line 3785: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.delivery_id',prev_leg_rec.delivery_id);

3781: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_locationId',prev_leg_rec.pu_stop_locationId);
3782: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_id',prev_leg_rec.pu_stop_id);
3783: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.shipment_direction',prev_leg_rec.shipment_direction);
3784: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.dlvy_status_code',prev_leg_rec.dlvy_status_code);
3785: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.delivery_id',prev_leg_rec.delivery_id);
3786: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.dlvy_initialPULocationId',prev_leg_rec.dlvy_initialPULocationId);
3787: END IF;
3788: --
3789: IF prev_leg_rec.do_stop_status_code = 'OP'

Line 3786: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.dlvy_initialPULocationId',prev_leg_rec.dlvy_initialPULocationId);

3782: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_id',prev_leg_rec.pu_stop_id);
3783: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.shipment_direction',prev_leg_rec.shipment_direction);
3784: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.dlvy_status_code',prev_leg_rec.dlvy_status_code);
3785: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.delivery_id',prev_leg_rec.delivery_id);
3786: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.dlvy_initialPULocationId',prev_leg_rec.dlvy_initialPULocationId);
3787: END IF;
3788: --
3789: IF prev_leg_rec.do_stop_status_code = 'OP'
3790: THEN

Line 3870: WSH_DEBUG_SV.log(l_module_name,'prev_stop_rec.shipments_type_flag',prev_stop_rec.shipments_type_flag);

3866: --}
3867: END IF;
3868: --
3869: IF l_debug_on THEN
3870: WSH_DEBUG_SV.log(l_module_name,'prev_stop_rec.shipments_type_flag',prev_stop_rec.shipments_type_flag);
3871: WSH_DEBUG_SV.log(l_module_name,'prev_stop_rec.stop_location_id',prev_stop_rec.stop_location_id);
3872: END IF;
3873: --
3874: --

Line 3871: WSH_DEBUG_SV.log(l_module_name,'prev_stop_rec.stop_location_id',prev_stop_rec.stop_location_id);

3867: END IF;
3868: --
3869: IF l_debug_on THEN
3870: WSH_DEBUG_SV.log(l_module_name,'prev_stop_rec.shipments_type_flag',prev_stop_rec.shipments_type_flag);
3871: WSH_DEBUG_SV.log(l_module_name,'prev_stop_rec.stop_location_id',prev_stop_rec.stop_location_id);
3872: END IF;
3873: --
3874: --
3875: IF l_virtual_shipments_Type_flag = 'I'

Line 3920: WSH_DEBUG_SV.logmsg(l_module_name,'Checking all prior legs-1');

3916: l_stop_Id := prev_leg_rec.pu_stop_Id;
3917: l_dlvy_initialPULocationId := prev_leg_rec.dlvy_initialPULocationId;
3918: --
3919: IF l_debug_on THEN
3920: WSH_DEBUG_SV.logmsg(l_module_name,'Checking all prior legs-1');
3921: END IF;
3922: --
3923: WHILE l_stop_locationId <> l_dlvy_initialPULocationId
3924: LOOP

Line 3935: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_shipments_type_flag',prev_leg_rec1.do_stop_shipments_type_flag);

3931: LOOP
3932: --{
3933:
3934: IF l_debug_on THEN
3935: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_shipments_type_flag',prev_leg_rec1.do_stop_shipments_type_flag);
3936: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_status_code',prev_leg_rec1.do_stop_status_code);
3937: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_locationId',prev_leg_rec1.do_stop_locationId);
3938: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_id',prev_leg_rec1.do_stop_id);
3939: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_shipments_type_flag',prev_leg_rec1.pu_stop_shipments_type_flag);

Line 3936: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_status_code',prev_leg_rec1.do_stop_status_code);

3932: --{
3933:
3934: IF l_debug_on THEN
3935: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_shipments_type_flag',prev_leg_rec1.do_stop_shipments_type_flag);
3936: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_status_code',prev_leg_rec1.do_stop_status_code);
3937: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_locationId',prev_leg_rec1.do_stop_locationId);
3938: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_id',prev_leg_rec1.do_stop_id);
3939: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_shipments_type_flag',prev_leg_rec1.pu_stop_shipments_type_flag);
3940: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_status_code',prev_leg_rec1.pu_stop_status_code);

Line 3937: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_locationId',prev_leg_rec1.do_stop_locationId);

3933:
3934: IF l_debug_on THEN
3935: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_shipments_type_flag',prev_leg_rec1.do_stop_shipments_type_flag);
3936: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_status_code',prev_leg_rec1.do_stop_status_code);
3937: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_locationId',prev_leg_rec1.do_stop_locationId);
3938: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_id',prev_leg_rec1.do_stop_id);
3939: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_shipments_type_flag',prev_leg_rec1.pu_stop_shipments_type_flag);
3940: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_status_code',prev_leg_rec1.pu_stop_status_code);
3941: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_locationId',prev_leg_rec1.pu_stop_locationId);

Line 3938: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_id',prev_leg_rec1.do_stop_id);

3934: IF l_debug_on THEN
3935: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_shipments_type_flag',prev_leg_rec1.do_stop_shipments_type_flag);
3936: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_status_code',prev_leg_rec1.do_stop_status_code);
3937: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_locationId',prev_leg_rec1.do_stop_locationId);
3938: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_id',prev_leg_rec1.do_stop_id);
3939: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_shipments_type_flag',prev_leg_rec1.pu_stop_shipments_type_flag);
3940: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_status_code',prev_leg_rec1.pu_stop_status_code);
3941: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_locationId',prev_leg_rec1.pu_stop_locationId);
3942: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_id',prev_leg_rec1.pu_stop_id);

Line 3939: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_shipments_type_flag',prev_leg_rec1.pu_stop_shipments_type_flag);

3935: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_shipments_type_flag',prev_leg_rec1.do_stop_shipments_type_flag);
3936: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_status_code',prev_leg_rec1.do_stop_status_code);
3937: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_locationId',prev_leg_rec1.do_stop_locationId);
3938: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_id',prev_leg_rec1.do_stop_id);
3939: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_shipments_type_flag',prev_leg_rec1.pu_stop_shipments_type_flag);
3940: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_status_code',prev_leg_rec1.pu_stop_status_code);
3941: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_locationId',prev_leg_rec1.pu_stop_locationId);
3942: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_id',prev_leg_rec1.pu_stop_id);
3943: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.shipment_direction',prev_leg_rec1.shipment_direction);

Line 3940: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_status_code',prev_leg_rec1.pu_stop_status_code);

3936: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_status_code',prev_leg_rec1.do_stop_status_code);
3937: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_locationId',prev_leg_rec1.do_stop_locationId);
3938: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_id',prev_leg_rec1.do_stop_id);
3939: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_shipments_type_flag',prev_leg_rec1.pu_stop_shipments_type_flag);
3940: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_status_code',prev_leg_rec1.pu_stop_status_code);
3941: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_locationId',prev_leg_rec1.pu_stop_locationId);
3942: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_id',prev_leg_rec1.pu_stop_id);
3943: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.shipment_direction',prev_leg_rec1.shipment_direction);
3944: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.dlvy_status_code',prev_leg_rec1.dlvy_status_code);

Line 3941: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_locationId',prev_leg_rec1.pu_stop_locationId);

3937: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_locationId',prev_leg_rec1.do_stop_locationId);
3938: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_id',prev_leg_rec1.do_stop_id);
3939: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_shipments_type_flag',prev_leg_rec1.pu_stop_shipments_type_flag);
3940: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_status_code',prev_leg_rec1.pu_stop_status_code);
3941: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_locationId',prev_leg_rec1.pu_stop_locationId);
3942: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_id',prev_leg_rec1.pu_stop_id);
3943: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.shipment_direction',prev_leg_rec1.shipment_direction);
3944: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.dlvy_status_code',prev_leg_rec1.dlvy_status_code);
3945: END IF;

Line 3942: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_id',prev_leg_rec1.pu_stop_id);

3938: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_id',prev_leg_rec1.do_stop_id);
3939: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_shipments_type_flag',prev_leg_rec1.pu_stop_shipments_type_flag);
3940: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_status_code',prev_leg_rec1.pu_stop_status_code);
3941: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_locationId',prev_leg_rec1.pu_stop_locationId);
3942: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_id',prev_leg_rec1.pu_stop_id);
3943: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.shipment_direction',prev_leg_rec1.shipment_direction);
3944: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.dlvy_status_code',prev_leg_rec1.dlvy_status_code);
3945: END IF;
3946: --

Line 3943: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.shipment_direction',prev_leg_rec1.shipment_direction);

3939: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_shipments_type_flag',prev_leg_rec1.pu_stop_shipments_type_flag);
3940: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_status_code',prev_leg_rec1.pu_stop_status_code);
3941: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_locationId',prev_leg_rec1.pu_stop_locationId);
3942: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_id',prev_leg_rec1.pu_stop_id);
3943: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.shipment_direction',prev_leg_rec1.shipment_direction);
3944: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.dlvy_status_code',prev_leg_rec1.dlvy_status_code);
3945: END IF;
3946: --
3947: IF prev_leg_rec1.do_stop_status_code = 'OP'

Line 3944: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.dlvy_status_code',prev_leg_rec1.dlvy_status_code);

3940: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_status_code',prev_leg_rec1.pu_stop_status_code);
3941: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_locationId',prev_leg_rec1.pu_stop_locationId);
3942: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_id',prev_leg_rec1.pu_stop_id);
3943: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.shipment_direction',prev_leg_rec1.shipment_direction);
3944: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.dlvy_status_code',prev_leg_rec1.dlvy_status_code);
3945: END IF;
3946: --
3947: IF prev_leg_rec1.do_stop_status_code = 'OP'
3948: THEN

Line 4025: WSH_DEBUG_SV.log(l_module_name,'prev_stop_rec.shipments_type_flag',prev_stop_rec.shipments_type_flag);

4021: --}
4022: END IF;
4023: --
4024: IF l_debug_on THEN
4025: WSH_DEBUG_SV.log(l_module_name,'prev_stop_rec.shipments_type_flag',prev_stop_rec.shipments_type_flag);
4026: WSH_DEBUG_SV.log(l_module_name,'prev_stop_rec.stop_location_id',prev_stop_rec.stop_location_id);
4027: END IF;
4028: --
4029: --

Line 4026: WSH_DEBUG_SV.log(l_module_name,'prev_stop_rec.stop_location_id',prev_stop_rec.stop_location_id);

4022: END IF;
4023: --
4024: IF l_debug_on THEN
4025: WSH_DEBUG_SV.log(l_module_name,'prev_stop_rec.shipments_type_flag',prev_stop_rec.shipments_type_flag);
4026: WSH_DEBUG_SV.log(l_module_name,'prev_stop_rec.stop_location_id',prev_stop_rec.stop_location_id);
4027: END IF;
4028: --
4029: --
4030: IF l_virtual_shipments_Type_flag = 'I'

Line 4098: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_stop_statusCode',ib_pickup_rec.pu_stop_statusCode);

4094: l_linked_stop_info_rec.stop_id)
4095: LOOP
4096: --{
4097: IF l_debug_on THEN
4098: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_stop_statusCode',ib_pickup_rec.pu_stop_statusCode);
4099: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_shipments_type_flag',ib_pickup_rec.pu_shipments_type_flag);
4100: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.delivery_statusCode',ib_pickup_rec.delivery_statusCode);
4101: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_stop_locationId',ib_pickup_rec.pu_stop_locationId);
4102: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_stop_id',ib_pickup_rec.pu_stop_id);

Line 4099: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_shipments_type_flag',ib_pickup_rec.pu_shipments_type_flag);

4095: LOOP
4096: --{
4097: IF l_debug_on THEN
4098: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_stop_statusCode',ib_pickup_rec.pu_stop_statusCode);
4099: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_shipments_type_flag',ib_pickup_rec.pu_shipments_type_flag);
4100: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.delivery_statusCode',ib_pickup_rec.delivery_statusCode);
4101: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_stop_locationId',ib_pickup_rec.pu_stop_locationId);
4102: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_stop_id',ib_pickup_rec.pu_stop_id);
4103: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.delivery_id',ib_pickup_rec.delivery_id);

Line 4100: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.delivery_statusCode',ib_pickup_rec.delivery_statusCode);

4096: --{
4097: IF l_debug_on THEN
4098: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_stop_statusCode',ib_pickup_rec.pu_stop_statusCode);
4099: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_shipments_type_flag',ib_pickup_rec.pu_shipments_type_flag);
4100: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.delivery_statusCode',ib_pickup_rec.delivery_statusCode);
4101: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_stop_locationId',ib_pickup_rec.pu_stop_locationId);
4102: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_stop_id',ib_pickup_rec.pu_stop_id);
4103: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.delivery_id',ib_pickup_rec.delivery_id);
4104: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.dlvy_initialPULocationId',ib_pickup_rec.dlvy_initialPULocationId);

Line 4101: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_stop_locationId',ib_pickup_rec.pu_stop_locationId);

4097: IF l_debug_on THEN
4098: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_stop_statusCode',ib_pickup_rec.pu_stop_statusCode);
4099: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_shipments_type_flag',ib_pickup_rec.pu_shipments_type_flag);
4100: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.delivery_statusCode',ib_pickup_rec.delivery_statusCode);
4101: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_stop_locationId',ib_pickup_rec.pu_stop_locationId);
4102: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_stop_id',ib_pickup_rec.pu_stop_id);
4103: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.delivery_id',ib_pickup_rec.delivery_id);
4104: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.dlvy_initialPULocationId',ib_pickup_rec.dlvy_initialPULocationId);
4105: END IF;

Line 4102: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_stop_id',ib_pickup_rec.pu_stop_id);

4098: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_stop_statusCode',ib_pickup_rec.pu_stop_statusCode);
4099: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_shipments_type_flag',ib_pickup_rec.pu_shipments_type_flag);
4100: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.delivery_statusCode',ib_pickup_rec.delivery_statusCode);
4101: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_stop_locationId',ib_pickup_rec.pu_stop_locationId);
4102: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_stop_id',ib_pickup_rec.pu_stop_id);
4103: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.delivery_id',ib_pickup_rec.delivery_id);
4104: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.dlvy_initialPULocationId',ib_pickup_rec.dlvy_initialPULocationId);
4105: END IF;
4106: --

Line 4103: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.delivery_id',ib_pickup_rec.delivery_id);

4099: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_shipments_type_flag',ib_pickup_rec.pu_shipments_type_flag);
4100: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.delivery_statusCode',ib_pickup_rec.delivery_statusCode);
4101: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_stop_locationId',ib_pickup_rec.pu_stop_locationId);
4102: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_stop_id',ib_pickup_rec.pu_stop_id);
4103: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.delivery_id',ib_pickup_rec.delivery_id);
4104: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.dlvy_initialPULocationId',ib_pickup_rec.dlvy_initialPULocationId);
4105: END IF;
4106: --
4107: IF ib_pickup_rec.pu_stop_statusCode in ('OP','AR')

Line 4104: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.dlvy_initialPULocationId',ib_pickup_rec.dlvy_initialPULocationId);

4100: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.delivery_statusCode',ib_pickup_rec.delivery_statusCode);
4101: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_stop_locationId',ib_pickup_rec.pu_stop_locationId);
4102: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_stop_id',ib_pickup_rec.pu_stop_id);
4103: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.delivery_id',ib_pickup_rec.delivery_id);
4104: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.dlvy_initialPULocationId',ib_pickup_rec.dlvy_initialPULocationId);
4105: END IF;
4106: --
4107: IF ib_pickup_rec.pu_stop_statusCode in ('OP','AR')
4108: THEN

Line 4122: WSH_DEBUG_SV.logmsg(l_module_name,'Checking all prior legs');

4118: l_stop_locationId := ib_pickup_rec.pu_stop_locationId;
4119: l_stop_Id := ib_pickup_rec.pu_stop_Id;
4120: --
4121: IF l_debug_on THEN
4122: WSH_DEBUG_SV.logmsg(l_module_name,'Checking all prior legs');
4123: END IF;
4124: --
4125: WHILE l_stop_locationId <> ib_pickup_rec.dlvy_initialPULocationId
4126: LOOP

Line 4137: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_shipments_type_flag',prev_leg_rec.do_stop_shipments_type_flag);

4133: LOOP
4134: --{
4135:
4136: IF l_debug_on THEN
4137: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_shipments_type_flag',prev_leg_rec.do_stop_shipments_type_flag);
4138: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_status_code',prev_leg_rec.do_stop_status_code);
4139: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_locationId',prev_leg_rec.do_stop_locationId);
4140: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_id',prev_leg_rec.do_stop_id);
4141: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_shipments_type_flag',prev_leg_rec.pu_stop_shipments_type_flag);

Line 4138: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_status_code',prev_leg_rec.do_stop_status_code);

4134: --{
4135:
4136: IF l_debug_on THEN
4137: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_shipments_type_flag',prev_leg_rec.do_stop_shipments_type_flag);
4138: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_status_code',prev_leg_rec.do_stop_status_code);
4139: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_locationId',prev_leg_rec.do_stop_locationId);
4140: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_id',prev_leg_rec.do_stop_id);
4141: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_shipments_type_flag',prev_leg_rec.pu_stop_shipments_type_flag);
4142: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_status_code',prev_leg_rec.pu_stop_status_code);

Line 4139: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_locationId',prev_leg_rec.do_stop_locationId);

4135:
4136: IF l_debug_on THEN
4137: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_shipments_type_flag',prev_leg_rec.do_stop_shipments_type_flag);
4138: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_status_code',prev_leg_rec.do_stop_status_code);
4139: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_locationId',prev_leg_rec.do_stop_locationId);
4140: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_id',prev_leg_rec.do_stop_id);
4141: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_shipments_type_flag',prev_leg_rec.pu_stop_shipments_type_flag);
4142: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_status_code',prev_leg_rec.pu_stop_status_code);
4143: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_locationId',prev_leg_rec.pu_stop_locationId);

Line 4140: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_id',prev_leg_rec.do_stop_id);

4136: IF l_debug_on THEN
4137: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_shipments_type_flag',prev_leg_rec.do_stop_shipments_type_flag);
4138: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_status_code',prev_leg_rec.do_stop_status_code);
4139: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_locationId',prev_leg_rec.do_stop_locationId);
4140: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_id',prev_leg_rec.do_stop_id);
4141: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_shipments_type_flag',prev_leg_rec.pu_stop_shipments_type_flag);
4142: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_status_code',prev_leg_rec.pu_stop_status_code);
4143: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_locationId',prev_leg_rec.pu_stop_locationId);
4144: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_id',prev_leg_rec.pu_stop_id);

Line 4141: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_shipments_type_flag',prev_leg_rec.pu_stop_shipments_type_flag);

4137: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_shipments_type_flag',prev_leg_rec.do_stop_shipments_type_flag);
4138: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_status_code',prev_leg_rec.do_stop_status_code);
4139: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_locationId',prev_leg_rec.do_stop_locationId);
4140: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_id',prev_leg_rec.do_stop_id);
4141: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_shipments_type_flag',prev_leg_rec.pu_stop_shipments_type_flag);
4142: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_status_code',prev_leg_rec.pu_stop_status_code);
4143: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_locationId',prev_leg_rec.pu_stop_locationId);
4144: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_id',prev_leg_rec.pu_stop_id);
4145: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.shipment_direction',prev_leg_rec.shipment_direction);

Line 4142: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_status_code',prev_leg_rec.pu_stop_status_code);

4138: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_status_code',prev_leg_rec.do_stop_status_code);
4139: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_locationId',prev_leg_rec.do_stop_locationId);
4140: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_id',prev_leg_rec.do_stop_id);
4141: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_shipments_type_flag',prev_leg_rec.pu_stop_shipments_type_flag);
4142: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_status_code',prev_leg_rec.pu_stop_status_code);
4143: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_locationId',prev_leg_rec.pu_stop_locationId);
4144: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_id',prev_leg_rec.pu_stop_id);
4145: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.shipment_direction',prev_leg_rec.shipment_direction);
4146: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.dlvy_status_code',prev_leg_rec.dlvy_status_code);

Line 4143: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_locationId',prev_leg_rec.pu_stop_locationId);

4139: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_locationId',prev_leg_rec.do_stop_locationId);
4140: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_id',prev_leg_rec.do_stop_id);
4141: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_shipments_type_flag',prev_leg_rec.pu_stop_shipments_type_flag);
4142: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_status_code',prev_leg_rec.pu_stop_status_code);
4143: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_locationId',prev_leg_rec.pu_stop_locationId);
4144: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_id',prev_leg_rec.pu_stop_id);
4145: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.shipment_direction',prev_leg_rec.shipment_direction);
4146: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.dlvy_status_code',prev_leg_rec.dlvy_status_code);
4147: END IF;

Line 4144: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_id',prev_leg_rec.pu_stop_id);

4140: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_id',prev_leg_rec.do_stop_id);
4141: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_shipments_type_flag',prev_leg_rec.pu_stop_shipments_type_flag);
4142: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_status_code',prev_leg_rec.pu_stop_status_code);
4143: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_locationId',prev_leg_rec.pu_stop_locationId);
4144: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_id',prev_leg_rec.pu_stop_id);
4145: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.shipment_direction',prev_leg_rec.shipment_direction);
4146: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.dlvy_status_code',prev_leg_rec.dlvy_status_code);
4147: END IF;
4148: --

Line 4145: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.shipment_direction',prev_leg_rec.shipment_direction);

4141: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_shipments_type_flag',prev_leg_rec.pu_stop_shipments_type_flag);
4142: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_status_code',prev_leg_rec.pu_stop_status_code);
4143: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_locationId',prev_leg_rec.pu_stop_locationId);
4144: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_id',prev_leg_rec.pu_stop_id);
4145: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.shipment_direction',prev_leg_rec.shipment_direction);
4146: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.dlvy_status_code',prev_leg_rec.dlvy_status_code);
4147: END IF;
4148: --
4149: --IF prev_leg_rec.do_stop_status_code in ('OP','AR')

Line 4146: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.dlvy_status_code',prev_leg_rec.dlvy_status_code);

4142: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_status_code',prev_leg_rec.pu_stop_status_code);
4143: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_locationId',prev_leg_rec.pu_stop_locationId);
4144: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_id',prev_leg_rec.pu_stop_id);
4145: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.shipment_direction',prev_leg_rec.shipment_direction);
4146: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.dlvy_status_code',prev_leg_rec.dlvy_status_code);
4147: END IF;
4148: --
4149: --IF prev_leg_rec.do_stop_status_code in ('OP','AR')
4150: IF prev_leg_rec.do_stop_status_code in ('OP')

Line 4228: WSH_DEBUG_SV.log(l_module_name,'prev_stop_rec.shipments_type_flag',prev_stop_rec.shipments_type_flag);

4224: --}
4225: END IF;
4226: --
4227: IF l_debug_on THEN
4228: WSH_DEBUG_SV.log(l_module_name,'prev_stop_rec.shipments_type_flag',prev_stop_rec.shipments_type_flag);
4229: WSH_DEBUG_SV.log(l_module_name,'prev_stop_rec.stop_location_id',prev_stop_rec.stop_location_id);
4230: END IF;
4231: --
4232: --

Line 4229: WSH_DEBUG_SV.log(l_module_name,'prev_stop_rec.stop_location_id',prev_stop_rec.stop_location_id);

4225: END IF;
4226: --
4227: IF l_debug_on THEN
4228: WSH_DEBUG_SV.log(l_module_name,'prev_stop_rec.shipments_type_flag',prev_stop_rec.shipments_type_flag);
4229: WSH_DEBUG_SV.log(l_module_name,'prev_stop_rec.stop_location_id',prev_stop_rec.stop_location_id);
4230: END IF;
4231: --
4232: --
4233: IF l_virtual_shipments_Type_flag = 'I'

Line 4298: WSH_DEBUG_SV.log(l_module_name,'l_initial_pu_dlvy_rec.organization_id',l_initial_pu_dlvy_rec.organization_id);

4294: FOR l_initial_pu_dlvy_rec IN initial_pu_dlvy_csr(p_in_rec.stop_id)
4295: LOOP
4296: --{
4297: IF l_debug_on THEN
4298: WSH_DEBUG_SV.log(l_module_name,'l_initial_pu_dlvy_rec.organization_id',l_initial_pu_dlvy_rec.organization_id);
4299: WSH_DEBUG_SV.log(l_module_name,'l_prev_org_id',l_prev_org_id);
4300: END IF;
4301: --
4302: -- Since deliveries are sorted by organization_id,

Line 4299: WSH_DEBUG_SV.log(l_module_name,'l_prev_org_id',l_prev_org_id);

4295: LOOP
4296: --{
4297: IF l_debug_on THEN
4298: WSH_DEBUG_SV.log(l_module_name,'l_initial_pu_dlvy_rec.organization_id',l_initial_pu_dlvy_rec.organization_id);
4299: WSH_DEBUG_SV.log(l_module_name,'l_prev_org_id',l_prev_org_id);
4300: END IF;
4301: --
4302: -- Since deliveries are sorted by organization_id,
4303: -- peform organization specific checks only when organization id changes

Line 4311: WSH_DEBUG_SV.log(l_module_name,'l_prev_org_dlvy_cnt',l_prev_org_dlvy_cnt);

4307: --{
4308: l_prev_org_dlvy_cnt := l_dlvy_cnt;
4309: --
4310: IF l_debug_on THEN
4311: WSH_DEBUG_SV.log(l_module_name,'l_prev_org_dlvy_cnt',l_prev_org_dlvy_cnt);
4312: WSH_DEBUG_SV.log(l_module_name,'l_dlvy_cnt',l_dlvy_cnt);
4313: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.Get',WSH_DEBUG_SV.C_PROC_LEVEL);
4314: END IF;
4315: --

Line 4312: WSH_DEBUG_SV.log(l_module_name,'l_dlvy_cnt',l_dlvy_cnt);

4308: l_prev_org_dlvy_cnt := l_dlvy_cnt;
4309: --
4310: IF l_debug_on THEN
4311: WSH_DEBUG_SV.log(l_module_name,'l_prev_org_dlvy_cnt',l_prev_org_dlvy_cnt);
4312: WSH_DEBUG_SV.log(l_module_name,'l_dlvy_cnt',l_dlvy_cnt);
4313: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.Get',WSH_DEBUG_SV.C_PROC_LEVEL);
4314: END IF;
4315: --
4316: WSH_SHIPPING_PARAMS_PVT.Get

Line 4313: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.Get',WSH_DEBUG_SV.C_PROC_LEVEL);

4309: --
4310: IF l_debug_on THEN
4311: WSH_DEBUG_SV.log(l_module_name,'l_prev_org_dlvy_cnt',l_prev_org_dlvy_cnt);
4312: WSH_DEBUG_SV.log(l_module_name,'l_dlvy_cnt',l_dlvy_cnt);
4313: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.Get',WSH_DEBUG_SV.C_PROC_LEVEL);
4314: END IF;
4315: --
4316: WSH_SHIPPING_PARAMS_PVT.Get
4317: (

Line 4324: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

4320: x_return_status => l_return_status
4321: );
4322: --
4323: IF l_debug_on THEN
4324: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
4325: END IF;
4326: --
4327: WSH_UTIL_CORE.api_post_call
4328: (

Line 4335: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters',WSH_DEBUG_SV.C_PROC_LEVEL);

4331: x_num_errors => l_num_errors
4332: );
4333:
4334: IF l_debug_on THEN
4335: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters',WSH_DEBUG_SV.C_PROC_LEVEL);
4336: END IF;
4337:
4338: --Bug 3346237: Allow future date and enforce ship method should take values from
4339: -- Global parameters table.

Line 4349: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

4345: );
4346: --
4347:
4348: IF l_debug_on THEN
4349: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
4350: END IF;
4351: --
4352:
4353: WSH_UTIL_CORE.api_post_call

Line 4369: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

4365:
4366: IF (l_param_info.percent_fill_basis_flag = 'W' and l_stop_info_rec.departure_gross_weight is NULL) THEN
4367: FND_MESSAGE.SET_NAME('WSH','WSH_NULL_WV');
4368: IF l_debug_on THEN
4369: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4370: END IF;
4371: --
4372: FND_MESSAGE.SET_TOKEN('ENTITY_TYPE','Stop');
4373: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',wsh_trip_stops_pvt.get_name(p_in_rec.stop_id,p_in_rec.caller));

Line 4383: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

4379:
4380: IF (l_param_info.percent_fill_basis_flag = 'V' and l_stop_info_rec.departure_volume is NULL) THEN
4381: FND_MESSAGE.SET_NAME('WSH','WSH_NULL_WV');
4382: IF l_debug_on THEN
4383: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4384: END IF;
4385: --
4386: FND_MESSAGE.SET_TOKEN('ENTITY_TYPE','Stop');
4387: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',wsh_trip_stops_pvt.get_name(p_in_rec.stop_id,p_in_rec.caller));

Line 4441: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INVTTMTX.TDATECHK',WSH_DEBUG_SV.C_PROC_LEVEL);

4437: --
4438: -- Debug Statements
4439: --
4440: IF l_debug_on THEN
4441: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INVTTMTX.TDATECHK',WSH_DEBUG_SV.C_PROC_LEVEL);
4442: END IF;
4443: --
4444: invttmtx.tdatechk(l_initial_pu_dlvy_rec.organization_id, p_in_rec.actual_date, l_period_id, l_open_past_period);
4445:

Line 4482: WSH_DEBUG_SV.logmsg(l_module_name,'Receiving Organization_id : '|| l_rec_organization_id ||

4478: CLOSE get_org_id;
4479:
4480: IF l_rec_organization_id IS NOT NULL THEN --{
4481: IF l_debug_on THEN
4482: WSH_DEBUG_SV.logmsg(l_module_name,'Receiving Organization_id : '|| l_rec_organization_id ||
4483: ' , Destination Source Code : '|| l_dest_type_code);
4484: END IF;
4485: -- Validate Accounting Period Open only if its a Direct Transfer or InTransit Shipment to Expense Destination
4486: l_intransit_type := NULL;

Line 4496: WSH_DEBUG_SV.log(l_module_name,'Intransit Type', l_intransit_type);

4492: OPEN c_mtl_interorg_parameters( l_initial_pu_dlvy_rec.organization_id, l_rec_organization_id);
4493: FETCH c_mtl_interorg_parameters INTO l_intransit_type;
4494: IF c_mtl_interorg_parameters%FOUND THEN
4495: IF l_debug_on THEN
4496: WSH_DEBUG_SV.log(l_module_name,'Intransit Type', l_intransit_type);
4497: END IF;
4498: IF l_intransit_type = 1 THEN
4499: l_validate_rec_org := TRUE;
4500: END IF;

Line 4508: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INVTTMTX.TDATECHK',WSH_DEBUG_SV.C_PROC_LEVEL);

4504:
4505: IF l_validate_rec_org THEN --{
4506: -- Check for open inventory period
4507: IF l_debug_on THEN
4508: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INVTTMTX.TDATECHK',WSH_DEBUG_SV.C_PROC_LEVEL);
4509: END IF;
4510:
4511: invttmtx.tdatechk(l_rec_organization_id, p_in_rec.actual_date, l_period_id, l_open_past_period);
4512:

Line 4536: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit wsh_delivery_validations.check_exception',WSH_DEBUG_SV.C_PROC_LEVEL);

4532: --{
4533: l_itm_mark_dels(1) := l_initial_pu_dlvy_rec.delivery_id;
4534: --
4535: IF l_debug_on THEN
4536: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit wsh_delivery_validations.check_exception',WSH_DEBUG_SV.C_PROC_LEVEL);
4537: END IF;
4538: --
4539: wsh_delivery_validations.check_exception(
4540: p_deliveries_tab => l_itm_mark_dels,

Line 4546: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

4542: x_exceptions_tab => l_exceptions_tab,
4543: x_return_status => l_return_status);
4544: --
4545: IF l_debug_on THEN
4546: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
4547: END IF;
4548: --
4549: WSH_UTIL_CORE.api_post_call
4550: (

Line 4609: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.check_inTransit',WSH_DEBUG_SV.C_PROC_LEVEL);

4605: --
4606: -- Debug Statements
4607: --
4608: IF l_debug_on THEN
4609: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.check_inTransit',WSH_DEBUG_SV.C_PROC_LEVEL);
4610: END IF;
4611: --
4612: --
4613: -- Check if deliveries can be set to in-transit.

Line 4625: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

4621: x_allowed => l_Allowed
4622: );
4623: --
4624: IF l_debug_on THEN
4625: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
4626: WSH_DEBUG_SV.log(l_module_name,'l_Allowed',l_Allowed);
4627: END IF;
4628: --
4629: --

Line 4626: WSH_DEBUG_SV.log(l_module_name,'l_Allowed',l_Allowed);

4622: );
4623: --
4624: IF l_debug_on THEN
4625: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
4626: WSH_DEBUG_SV.log(l_module_name,'l_Allowed',l_Allowed);
4627: END IF;
4628: --
4629: --
4630: WSH_UTIL_CORE.api_post_call

Line 4700: WSH_DEBUG_SV.log(l_module_name,'l_dlvy_cnt',l_dlvy_cnt);

4696: --}
4697: END LOOP;
4698: --
4699: IF l_debug_on THEN
4700: WSH_DEBUG_SV.log(l_module_name,'l_dlvy_cnt',l_dlvy_cnt);
4701: WSH_DEBUG_SV.log(l_module_name,'l_err_dlvy_cnt',l_err_dlvy_cnt);
4702: END IF;
4703: --
4704: -- IF all deliveries errored out, stop close cannot be allowed.

Line 4701: WSH_DEBUG_SV.log(l_module_name,'l_err_dlvy_cnt',l_err_dlvy_cnt);

4697: END LOOP;
4698: --
4699: IF l_debug_on THEN
4700: WSH_DEBUG_SV.log(l_module_name,'l_dlvy_cnt',l_dlvy_cnt);
4701: WSH_DEBUG_SV.log(l_module_name,'l_err_dlvy_cnt',l_err_dlvy_cnt);
4702: END IF;
4703: --
4704: -- IF all deliveries errored out, stop close cannot be allowed.
4705: --

Line 4737: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.check_close',WSH_DEBUG_SV.C_PROC_LEVEL);

4733: --
4734: -- Debug Statements
4735: --
4736: IF l_debug_on THEN
4737: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.check_close',WSH_DEBUG_SV.C_PROC_LEVEL);
4738: END IF;
4739: --
4740: -- Check if delivery can be closed.
4741: -- If so, add it to out parameter x_out_rec.ultimate_do_dlvy_recTbl

Line 4751: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

4747: x_allowed => l_Allowed
4748: );
4749: --
4750: IF l_debug_on THEN
4751: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
4752: WSH_DEBUG_SV.log(l_module_name,'l_Allowed',l_Allowed);
4753: END IF;
4754: --
4755: --

Line 4752: WSH_DEBUG_SV.log(l_module_name,'l_Allowed',l_Allowed);

4748: );
4749: --
4750: IF l_debug_on THEN
4751: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
4752: WSH_DEBUG_SV.log(l_module_name,'l_Allowed',l_Allowed);
4753: END IF;
4754: --
4755: --
4756: WSH_UTIL_CORE.api_post_call

Line 4804: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_VALIDATIONS.check_inTransit',WSH_DEBUG_SV.C_PROC_LEVEL);

4800: --
4801: -- Debug Statements
4802: --
4803: IF l_debug_on THEN
4804: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_VALIDATIONS.check_inTransit',WSH_DEBUG_SV.C_PROC_LEVEL);
4805: END IF;
4806: --
4807: -- Check if trip can be set to In-Transit.
4808: --

Line 4817: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

4813: x_allowed => l_Allowed
4814: );
4815: --
4816: IF l_debug_on THEN
4817: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
4818: WSH_DEBUG_SV.log(l_module_name,'l_Allowed',l_Allowed);
4819: END IF;
4820: --
4821: --

Line 4818: WSH_DEBUG_SV.log(l_module_name,'l_Allowed',l_Allowed);

4814: );
4815: --
4816: IF l_debug_on THEN
4817: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
4818: WSH_DEBUG_SV.log(l_module_name,'l_Allowed',l_Allowed);
4819: END IF;
4820: --
4821: --
4822: WSH_UTIL_CORE.api_post_call

Line 4857: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_VALIDATIONS.check_close',WSH_DEBUG_SV.C_PROC_LEVEL);

4853: --
4854: -- Debug Statements
4855: --
4856: IF l_debug_on THEN
4857: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_VALIDATIONS.check_close',WSH_DEBUG_SV.C_PROC_LEVEL);
4858: END IF;
4859: --
4860: -- Check if trip can be closed.
4861: --

Line 4870: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);

4866: x_allowed => l_Allowed
4867: );
4868: --
4869: IF l_debug_on THEN
4870: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
4871: WSH_DEBUG_SV.log(l_module_name,'l_Allowed',l_Allowed);
4872: END IF;
4873: --
4874: --

Line 4871: WSH_DEBUG_SV.log(l_module_name,'l_Allowed',l_Allowed);

4867: );
4868: --
4869: IF l_debug_on THEN
4870: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
4871: WSH_DEBUG_SV.log(l_module_name,'l_Allowed',l_Allowed);
4872: END IF;
4873: --
4874: --
4875: WSH_UTIL_CORE.api_post_call

Line 4928: WSH_DEBUG_SV.pop(l_module_name);

4924: --
4925: -- Debug Statements
4926: --
4927: IF l_debug_on THEN
4928: WSH_DEBUG_SV.pop(l_module_name);
4929: END IF;
4930: --
4931: --}
4932: EXCEPTION

Line 4946: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_util_core.e_not_allowed exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

4942: x_out_rec.close_allowed := 'N';
4943: --
4944: --
4945: IF l_debug_on THEN
4946: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_util_core.e_not_allowed exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4947: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_util_core.e_not_allowed');
4948: END IF;
4949: --
4950: WHEN wsh_util_core.e_not_allowed_warning THEN

Line 4947: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_util_core.e_not_allowed');

4943: --
4944: --
4945: IF l_debug_on THEN
4946: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_util_core.e_not_allowed exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4947: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_util_core.e_not_allowed');
4948: END IF;
4949: --
4950: WHEN wsh_util_core.e_not_allowed_warning THEN
4951: IF l_num_warnings > 0

Line 4962: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

4958: x_out_Rec.close_allowed := 'NW';
4959: --
4960: --
4961: IF l_debug_on THEN
4962: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4963: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4964: END IF;
4965: --
4966: WHEN FND_API.G_EXC_ERROR THEN

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

4959: --
4960: --
4961: IF l_debug_on THEN
4962: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4963: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4964: END IF;
4965: --
4966: WHEN FND_API.G_EXC_ERROR THEN
4967:

Line 4971: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

4967:
4968: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4969: --
4970: IF l_debug_on THEN
4971: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4972: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4973: END IF;
4974: --
4975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

4968: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4969: --
4970: IF l_debug_on THEN
4971: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4972: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4973: END IF;
4974: --
4975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4976:

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

4976:
4977: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4978: --
4979: IF l_debug_on THEN
4980: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4981: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4982: END IF;
4983: --
4984: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

Line 4981: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

4977: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4978: --
4979: IF l_debug_on THEN
4980: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4981: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4982: END IF;
4983: --
4984: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
4985: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 4988: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

4984: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
4985: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4986: --
4987: IF l_debug_on THEN
4988: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4989: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
4990: END IF;
4991: --
4992: WHEN OTHERS THEN

Line 4989: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');

4985: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4986: --
4987: IF l_debug_on THEN
4988: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4989: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
4990: END IF;
4991: --
4992: WHEN OTHERS THEN
4993: IF linked_stop_info_csr%ISOPEN THEN

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

4999: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
5000: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.CHECK_STOP_CLOSE',l_module_name);
5001: --
5002: IF l_debug_on THEN
5003: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5004: END IF;
5005: --
5006: --}
5007: END Check_Stop_Close;

Line 5117: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

5113: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
5114: --
5115: IF l_debug_on IS NULL
5116: THEN
5117: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
5118: END IF;
5119: --
5120: IF l_debug_on THEN
5121: WSH_DEBUG_SV.push(l_module_name);

Line 5121: WSH_DEBUG_SV.push(l_module_name);

5117: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
5118: END IF;
5119: --
5120: IF l_debug_on THEN
5121: WSH_DEBUG_SV.push(l_module_name);
5122: --
5123: WSH_DEBUG_SV.log(l_module_name,'p_trip_id',p_trip_id);
5124: WSH_DEBUG_SV.log(l_module_name,'p_stop_id',p_stop_id);
5125: WSH_DEBUG_SV.log(l_module_name,'p_stop_sequence_number',p_stop_sequence_number);

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

5119: --
5120: IF l_debug_on THEN
5121: WSH_DEBUG_SV.push(l_module_name);
5122: --
5123: WSH_DEBUG_SV.log(l_module_name,'p_trip_id',p_trip_id);
5124: WSH_DEBUG_SV.log(l_module_name,'p_stop_id',p_stop_id);
5125: WSH_DEBUG_SV.log(l_module_name,'p_stop_sequence_number',p_stop_sequence_number);
5126: END IF;
5127: --

Line 5124: WSH_DEBUG_SV.log(l_module_name,'p_stop_id',p_stop_id);

5120: IF l_debug_on THEN
5121: WSH_DEBUG_SV.push(l_module_name);
5122: --
5123: WSH_DEBUG_SV.log(l_module_name,'p_trip_id',p_trip_id);
5124: WSH_DEBUG_SV.log(l_module_name,'p_stop_id',p_stop_id);
5125: WSH_DEBUG_SV.log(l_module_name,'p_stop_sequence_number',p_stop_sequence_number);
5126: END IF;
5127: --
5128: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 5125: WSH_DEBUG_SV.log(l_module_name,'p_stop_sequence_number',p_stop_sequence_number);

5121: WSH_DEBUG_SV.push(l_module_name);
5122: --
5123: WSH_DEBUG_SV.log(l_module_name,'p_trip_id',p_trip_id);
5124: WSH_DEBUG_SV.log(l_module_name,'p_stop_id',p_stop_id);
5125: WSH_DEBUG_SV.log(l_module_name,'p_stop_sequence_number',p_stop_sequence_number);
5126: END IF;
5127: --
5128: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5129: --

Line 5188: WSH_DEBUG_SV.log(l_module_name,'l_actual_date',l_actual_date);

5184: --
5185: -- Debug Statements
5186: --
5187: IF l_debug_on THEN
5188: WSH_DEBUG_SV.log(l_module_name,'l_actual_date',l_actual_date);
5189: WSH_DEBUG_SV.pop(l_module_name);
5190: END IF;
5191: --}
5192: EXCEPTION

Line 5189: WSH_DEBUG_SV.pop(l_module_name);

5185: -- Debug Statements
5186: --
5187: IF l_debug_on THEN
5188: WSH_DEBUG_SV.log(l_module_name,'l_actual_date',l_actual_date);
5189: WSH_DEBUG_SV.pop(l_module_name);
5190: END IF;
5191: --}
5192: EXCEPTION
5193: --

Line 5199: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

5195:
5196: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5197: --
5198: IF l_debug_on THEN
5199: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5200: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
5201: END IF;
5202: --
5203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

5196: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
5197: --
5198: IF l_debug_on THEN
5199: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5200: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
5201: END IF;
5202: --
5203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5204:

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

5204:
5205: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
5206: --
5207: IF l_debug_on THEN
5208: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5209: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
5210: END IF;
5211: --
5212: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

Line 5209: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

5205: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
5206: --
5207: IF l_debug_on THEN
5208: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5209: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
5210: END IF;
5211: --
5212: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
5213: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 5216: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

5212: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
5213: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
5214: --
5215: IF l_debug_on THEN
5216: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5217: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
5218: END IF;
5219: --
5220: WHEN OTHERS THEN

Line 5217: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');

5213: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
5214: --
5215: IF l_debug_on THEN
5216: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
5217: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
5218: END IF;
5219: --
5220: WHEN OTHERS THEN
5221:

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

5221:
5222: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
5223: wsh_util_core.default_handler('WSH_TRIP_STOPS_VALIDATIONS.get_stop_close_date', l_module_name);
5224: IF l_debug_on THEN
5225: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5226: END IF;
5227: --
5228: END get_stop_close_date;
5229:

Line 5255: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

5251: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
5252: --
5253: IF l_debug_on IS NULL
5254: THEN
5255: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
5256: END IF;
5257: --
5258: IF l_debug_on THEN
5259: --

Line 5260: WSH_DEBUG_SV.push(l_module_name);

5256: END IF;
5257: --
5258: IF l_debug_on THEN
5259: --
5260: WSH_DEBUG_SV.push(l_module_name);
5261: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.caller',p_in_rec.caller);
5262: --
5263: END IF;
5264: --

Line 5261: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.caller',p_in_rec.caller);

5257: --
5258: IF l_debug_on THEN
5259: --
5260: WSH_DEBUG_SV.push(l_module_name);
5261: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.caller',p_in_rec.caller);
5262: --
5263: END IF;
5264: --
5265: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5747: WSH_DEBUG_SV.log(l_module_name,'l_attributes',l_attributes);

5743: l_attributes := l_attributes || 'TP_STOP_ID, ';
5744: END IF;
5745:
5746: IF l_debug_on THEN
5747: WSH_DEBUG_SV.log(l_module_name,'l_attributes',l_attributes);
5748: WSH_DEBUG_SV.log(l_module_name,'length(l_attributes)',length(l_attributes));
5749: END IF;
5750:
5751:

Line 5748: WSH_DEBUG_SV.log(l_module_name,'length(l_attributes)',length(l_attributes));

5744: END IF;
5745:
5746: IF l_debug_on THEN
5747: WSH_DEBUG_SV.log(l_module_name,'l_attributes',l_attributes);
5748: WSH_DEBUG_SV.log(l_module_name,'length(l_attributes)',length(l_attributes));
5749: END IF;
5750:
5751:
5752: IF l_attributes IS NULL THEN

Line 5755: WSH_DEBUG_SV.pop(l_module_name);

5751:
5752: IF l_attributes IS NULL THEN
5753: --no message to be shown to the user
5754: IF l_debug_on THEN
5755: WSH_DEBUG_SV.pop(l_module_name);
5756: END IF;
5757: RETURN;
5758: ELSE
5759: Wsh_Utilities.process_message(

Line 5770: wsh_debug_sv.logmsg(l_module_name,'Error returned by wsh_utilities.process_message',WSH_DEBUG_SV.C_PROC_LEVEL);

5766: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
5767: THEN
5768: x_return_status := l_return_status;
5769: IF l_debug_on THEN
5770: wsh_debug_sv.logmsg(l_module_name,'Error returned by wsh_utilities.process_message',WSH_DEBUG_SV.C_PROC_LEVEL);
5771: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5772: wsh_debug_sv.pop(l_module_name);
5773: END IF;
5774: return;

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

5767: THEN
5768: x_return_status := l_return_status;
5769: IF l_debug_on THEN
5770: wsh_debug_sv.logmsg(l_module_name,'Error returned by wsh_utilities.process_message',WSH_DEBUG_SV.C_PROC_LEVEL);
5771: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5772: wsh_debug_sv.pop(l_module_name);
5773: END IF;
5774: return;
5775: ELSE

Line 5772: wsh_debug_sv.pop(l_module_name);

5768: x_return_status := l_return_status;
5769: IF l_debug_on THEN
5770: wsh_debug_sv.logmsg(l_module_name,'Error returned by wsh_utilities.process_message',WSH_DEBUG_SV.C_PROC_LEVEL);
5771: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5772: wsh_debug_sv.pop(l_module_name);
5773: END IF;
5774: return;
5775: ELSE
5776: x_return_status := wsh_util_core.G_RET_STS_WARNING;

Line 5781: WSH_DEBUG_SV.pop(l_module_name);

5777: END IF;
5778: END IF;
5779:
5780: IF l_debug_on THEN
5781: WSH_DEBUG_SV.pop(l_module_name);
5782: END IF;
5783: --
5784:
5785:

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

5787: WHEN OTHERS THEN
5788: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
5789: --
5790: IF l_debug_on THEN
5791: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5792: END IF;
5793: --
5794: END user_non_updatable_columns;
5795: