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 977: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

Line 981: WSH_DEBUG_SV.push(l_module_name);

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

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

979: --
980: IF l_debug_on THEN
981: WSH_DEBUG_SV.push(l_module_name);
982: --
983: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
984: WSH_DEBUG_SV.log(l_module_name,'p_action',p_action);
985: END IF;
986:
987: Init_Stop_Actions_Tbl(

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

980: IF l_debug_on THEN
981: WSH_DEBUG_SV.push(l_module_name);
982: --
983: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
984: WSH_DEBUG_SV.log(l_module_name,'p_action',p_action);
985: END IF;
986:
987: Init_Stop_Actions_Tbl(
988: p_action => p_action,

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

989: x_stop_actions_tab => l_stop_actions_tab,
990: x_return_status => x_return_status);
991:
992: IF l_debug_on THEN
993: WSH_DEBUG_SV.log(l_module_name,'Init_Detail_Actions_Tbl x_return_status',x_return_status);
994: END IF;
995:
996: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
997: raise error_in_init_actions;

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

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

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

1038: END IF;
1039: --
1040: --
1041: IF l_debug_on THEN
1042: wsh_debug_sv.log(l_module_name, 'l_caller-modified', l_caller);
1043: END IF;
1044: -- J-IB-NPARIKH-}
1045: --
1046:

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

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

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

1104: x_error_ids => l_error_ids,
1105: x_valid_index_tab => l_valid_index_tab);
1106:
1107: IF l_debug_on THEN
1108: WSH_DEBUG_SV.log(l_module_name,'WSH_DELIVERY_VALIDATIONS.Is_Action_Enabled l_return_status',
1109: l_return_status);
1110: END IF;
1111:
1112: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS)

Line 1189: WSH_DEBUG_SV.pop(l_module_name);

1185: --}
1186: END IF;
1187:
1188: IF l_debug_on THEN
1189: WSH_DEBUG_SV.pop(l_module_name);
1190: END IF;
1191:
1192: EXCEPTION
1193: WHEN error_in_init_actions THEN

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

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

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

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

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

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

Line 1211: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

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

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

Line 2110: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2106: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2107: --
2108: IF l_debug_on IS NULL
2109: THEN
2110: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2111: END IF;
2112: --
2113: IF l_debug_on THEN
2114: --

Line 2115: WSH_DEBUG_SV.push(l_module_name);

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

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

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

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

2113: IF l_debug_on THEN
2114: --
2115: WSH_DEBUG_SV.push(l_module_name);
2116: WSH_DEBUG_SV.log(l_module_name,'stop_id', p_stop_rec.stop_id);
2117: WSH_DEBUG_SV.log(l_module_name,'p_parent_entity_id', p_parent_entity_id);
2118: WSH_DEBUG_SV.log(l_module_name, 'Action', p_in_rec.action_code);
2119: WSH_DEBUG_SV.log(l_module_name, 'Caller', p_in_rec.caller);
2120: --
2121: END IF;

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

2114: --
2115: WSH_DEBUG_SV.push(l_module_name);
2116: WSH_DEBUG_SV.log(l_module_name,'stop_id', p_stop_rec.stop_id);
2117: WSH_DEBUG_SV.log(l_module_name,'p_parent_entity_id', p_parent_entity_id);
2118: WSH_DEBUG_SV.log(l_module_name, 'Action', p_in_rec.action_code);
2119: WSH_DEBUG_SV.log(l_module_name, 'Caller', p_in_rec.caller);
2120: --
2121: END IF;
2122: --

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

2115: WSH_DEBUG_SV.push(l_module_name);
2116: WSH_DEBUG_SV.log(l_module_name,'stop_id', p_stop_rec.stop_id);
2117: WSH_DEBUG_SV.log(l_module_name,'p_parent_entity_id', p_parent_entity_id);
2118: WSH_DEBUG_SV.log(l_module_name, 'Action', p_in_rec.action_code);
2119: WSH_DEBUG_SV.log(l_module_name, 'Caller', p_in_rec.caller);
2120: --
2121: END IF;
2122: --
2123: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

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

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

Line 2146: WSH_DEBUG_SV.pop(l_module_name);

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

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

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

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

2188: x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
2189: THEN
2190: --
2191: IF l_debug_on THEN
2192: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
2193: WSH_DEBUG_SV.pop(l_module_name);
2194: END IF;
2195: --
2196: RETURN;

Line 2193: WSH_DEBUG_SV.pop(l_module_name);

2189: THEN
2190: --
2191: IF l_debug_on THEN
2192: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
2193: WSH_DEBUG_SV.pop(l_module_name);
2194: END IF;
2195: --
2196: RETURN;
2197: --

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

2215: CLOSE c_tbl_rec;
2216:
2217: --
2218: IF l_debug_on THEN
2219: WSH_DEBUG_SV.log(l_module_name,'list.COUNT',l_disabled_list.COUNT);
2220: END IF;
2221: --
2222: IF l_disabled_list.COUNT = 0 THEN
2223: IF l_debug_on THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2307: WSH_DEBUG_SV.pop(l_module_name);

2303: --
2304: END IF;
2305:
2306: IF l_debug_on THEN
2307: WSH_DEBUG_SV.pop(l_module_name);
2308: END IF;
2309:
2310: EXCEPTION
2311: WHEN e_all_disabled THEN

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

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

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

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

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

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

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

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

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

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

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

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

Line 2394: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2390: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2391: --
2392: IF l_debug_on IS NULL
2393: THEN
2394: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2395: END IF;
2396: --
2397: IF l_debug_on THEN
2398: WSH_DEBUG_SV.push(l_module_name);

Line 2398: WSH_DEBUG_SV.push(l_module_name);

2394: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2395: END IF;
2396: --
2397: IF l_debug_on THEN
2398: WSH_DEBUG_SV.push(l_module_name);
2399: --
2400: WSH_DEBUG_SV.log(l_module_name,'p_action', p_action);
2401: END IF;
2402: --

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

2396: --
2397: IF l_debug_on THEN
2398: WSH_DEBUG_SV.push(l_module_name);
2399: --
2400: WSH_DEBUG_SV.log(l_module_name,'p_action', p_action);
2401: END IF;
2402: --
2403: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2404:

Line 2470: WSH_DEBUG_SV.pop(l_module_name);

2466: END IF;
2467: -- J-IB-NPARIKH-}
2468:
2469: IF l_debug_on THEN
2470: WSH_DEBUG_SV.pop(l_module_name);
2471: END IF;
2472: EXCEPTION
2473: WHEN OTHERS THEN
2474: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

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

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

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

Line 2562: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2558: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2559: --
2560: IF l_debug_on IS NULL
2561: THEN
2562: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2563: END IF;
2564: --
2565: IF l_debug_on THEN
2566: WSH_DEBUG_SV.push(l_module_name);

Line 2566: WSH_DEBUG_SV.push(l_module_name);

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

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

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

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

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

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

2565: IF l_debug_on THEN
2566: WSH_DEBUG_SV.push(l_module_name);
2567: WSH_DEBUG_SV.log(l_module_name,'p_trip_id',p_trip_id);
2568: WSH_DEBUG_SV.log(l_module_name,'p_stop_id',p_stop_id);
2569: WSH_DEBUG_SV.log(l_module_name,'p_action',p_action);
2570: WSH_DEBUG_SV.log(l_module_name,'p_shipment_direction',p_shipment_direction);
2571: WSH_DEBUG_SV.log(l_module_name,'x_shipments_type_flag',x_shipments_type_flag);
2572: END IF;
2573: --

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

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

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

2567: WSH_DEBUG_SV.log(l_module_name,'p_trip_id',p_trip_id);
2568: WSH_DEBUG_SV.log(l_module_name,'p_stop_id',p_stop_id);
2569: WSH_DEBUG_SV.log(l_module_name,'p_action',p_action);
2570: WSH_DEBUG_SV.log(l_module_name,'p_shipment_direction',p_shipment_direction);
2571: WSH_DEBUG_SV.log(l_module_name,'x_shipments_type_flag',x_shipments_type_flag);
2572: END IF;
2573: --
2574: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2575: --

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

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

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

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

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

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

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

2683: --}
2684: ELSE
2685: --{
2686: IF l_debug_on THEN
2687: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_VALIDATIONS.has_inbound_deliveries',WSH_DEBUG_SV.C_PROC_LEVEL);
2688: END IF;
2689: --
2690: IF
2691: WSH_TRIP_VALIDATIONS.has_inbound_deliveries

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

2707: END IF;
2708: --
2709: --
2710: IF l_debug_on THEN
2711: WSH_DEBUG_SV.log(l_module_name,'x_shipments_type_flag',x_shipments_type_flag);
2712: WSH_DEBUG_SV.pop(l_module_name);
2713: END IF;
2714: --}
2715: EXCEPTION

Line 2712: WSH_DEBUG_SV.pop(l_module_name);

2708: --
2709: --
2710: IF l_debug_on THEN
2711: WSH_DEBUG_SV.log(l_module_name,'x_shipments_type_flag',x_shipments_type_flag);
2712: WSH_DEBUG_SV.pop(l_module_name);
2713: END IF;
2714: --}
2715: EXCEPTION
2716: --{

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 3225: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

3221: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3222: --
3223: IF l_debug_on IS NULL
3224: THEN
3225: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3226: END IF;
3227: --
3228: IF l_debug_on THEN
3229: WSH_DEBUG_SV.push(l_module_name);

Line 3229: WSH_DEBUG_SV.push(l_module_name);

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

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

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

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

3228: IF l_debug_on THEN
3229: WSH_DEBUG_SV.push(l_module_name);
3230: --
3231: WSH_DEBUG_SV.log(l_module_name,'P_in_rec.STOP_ID',P_in_rec.STOP_ID);
3232: WSH_DEBUG_SV.log(l_module_name,'P_in_rec.put_messages',P_in_rec.put_messages);
3233: WSH_DEBUG_SV.log(l_module_name,'P_in_rec.caller',P_in_rec.caller);
3234: WSH_DEBUG_SV.log(l_module_name,'P_in_rec.actual_date',P_in_rec.actual_date);
3235: END IF;
3236: --

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

3229: WSH_DEBUG_SV.push(l_module_name);
3230: --
3231: WSH_DEBUG_SV.log(l_module_name,'P_in_rec.STOP_ID',P_in_rec.STOP_ID);
3232: WSH_DEBUG_SV.log(l_module_name,'P_in_rec.put_messages',P_in_rec.put_messages);
3233: WSH_DEBUG_SV.log(l_module_name,'P_in_rec.caller',P_in_rec.caller);
3234: WSH_DEBUG_SV.log(l_module_name,'P_in_rec.actual_date',P_in_rec.actual_date);
3235: END IF;
3236: --
3237: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

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

3230: --
3231: WSH_DEBUG_SV.log(l_module_name,'P_in_rec.STOP_ID',P_in_rec.STOP_ID);
3232: WSH_DEBUG_SV.log(l_module_name,'P_in_rec.put_messages',P_in_rec.put_messages);
3233: WSH_DEBUG_SV.log(l_module_name,'P_in_rec.caller',P_in_rec.caller);
3234: WSH_DEBUG_SV.log(l_module_name,'P_in_rec.actual_date',P_in_rec.actual_date);
3235: END IF;
3236: --
3237: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3238: l_stop_warnings := 0;

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

3341: END IF;
3342: --
3343: --
3344: IF l_debug_on THEN
3345: WSH_DEBUG_SV.log(l_module_name,'l_linked_stop_info_rec.stop_id',l_linked_stop_info_rec.stop_id);
3346: WSH_DEBUG_SV.log(l_module_name,'l_linked_stop_info_rec.stop_location_id',l_linked_stop_info_rec.stop_location_id);
3347: END IF;
3348:
3349: IF (p_in_rec.caller LIKE 'FTE%'

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

3342: --
3343: --
3344: IF l_debug_on THEN
3345: WSH_DEBUG_SV.log(l_module_name,'l_linked_stop_info_rec.stop_id',l_linked_stop_info_rec.stop_id);
3346: WSH_DEBUG_SV.log(l_module_name,'l_linked_stop_info_rec.stop_location_id',l_linked_stop_info_rec.stop_location_id);
3347: END IF;
3348:
3349: IF (p_in_rec.caller LIKE 'FTE%'
3350: OR p_in_rec.caller LIKE 'WSH_IB%')

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

3376: x_out_rec.trip_seal_code := l_stop_info_rec.trip_seal_code;
3377: x_out_rec.trip_name := l_stop_info_rec.trip_name;
3378: --
3379: IF l_debug_on THEN
3380: WSH_DEBUG_SV.log(l_module_name,'l_stop_info_rec.stop_Sequence_number',l_stop_info_rec.stop_Sequence_number);
3381: WSH_DEBUG_SV.log(l_module_name,'l_stop_info_rec.trip_id',l_stop_info_rec.trip_id);
3382: WSH_DEBUG_SV.log(l_module_name,'l_stop_info_Rec.trip_Status_Code',l_stop_info_Rec.trip_Status_Code);
3383: WSH_DEBUG_SV.log(l_module_name,'l_stop_info_Rec.shipments_Type_flag',l_stop_info_Rec.shipments_Type_flag);
3384: WSH_DEBUG_SV.log(l_module_name,'l_linked_stop_info_Rec.shipments_Type_flag',l_linked_stop_info_Rec.shipments_Type_flag);

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

3377: x_out_rec.trip_name := l_stop_info_rec.trip_name;
3378: --
3379: IF l_debug_on THEN
3380: WSH_DEBUG_SV.log(l_module_name,'l_stop_info_rec.stop_Sequence_number',l_stop_info_rec.stop_Sequence_number);
3381: WSH_DEBUG_SV.log(l_module_name,'l_stop_info_rec.trip_id',l_stop_info_rec.trip_id);
3382: WSH_DEBUG_SV.log(l_module_name,'l_stop_info_Rec.trip_Status_Code',l_stop_info_Rec.trip_Status_Code);
3383: WSH_DEBUG_SV.log(l_module_name,'l_stop_info_Rec.shipments_Type_flag',l_stop_info_Rec.shipments_Type_flag);
3384: WSH_DEBUG_SV.log(l_module_name,'l_linked_stop_info_Rec.shipments_Type_flag',l_linked_stop_info_Rec.shipments_Type_flag);
3385: WSH_DEBUG_SV.log(l_module_name,'l_virtual_shipments_Type_flag',l_virtual_shipments_Type_flag);

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

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

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

3379: IF l_debug_on THEN
3380: WSH_DEBUG_SV.log(l_module_name,'l_stop_info_rec.stop_Sequence_number',l_stop_info_rec.stop_Sequence_number);
3381: WSH_DEBUG_SV.log(l_module_name,'l_stop_info_rec.trip_id',l_stop_info_rec.trip_id);
3382: WSH_DEBUG_SV.log(l_module_name,'l_stop_info_Rec.trip_Status_Code',l_stop_info_Rec.trip_Status_Code);
3383: WSH_DEBUG_SV.log(l_module_name,'l_stop_info_Rec.shipments_Type_flag',l_stop_info_Rec.shipments_Type_flag);
3384: WSH_DEBUG_SV.log(l_module_name,'l_linked_stop_info_Rec.shipments_Type_flag',l_linked_stop_info_Rec.shipments_Type_flag);
3385: WSH_DEBUG_SV.log(l_module_name,'l_virtual_shipments_Type_flag',l_virtual_shipments_Type_flag);
3386: END IF;
3387: --

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

3380: WSH_DEBUG_SV.log(l_module_name,'l_stop_info_rec.stop_Sequence_number',l_stop_info_rec.stop_Sequence_number);
3381: WSH_DEBUG_SV.log(l_module_name,'l_stop_info_rec.trip_id',l_stop_info_rec.trip_id);
3382: WSH_DEBUG_SV.log(l_module_name,'l_stop_info_Rec.trip_Status_Code',l_stop_info_Rec.trip_Status_Code);
3383: WSH_DEBUG_SV.log(l_module_name,'l_stop_info_Rec.shipments_Type_flag',l_stop_info_Rec.shipments_Type_flag);
3384: WSH_DEBUG_SV.log(l_module_name,'l_linked_stop_info_Rec.shipments_Type_flag',l_linked_stop_info_Rec.shipments_Type_flag);
3385: WSH_DEBUG_SV.log(l_module_name,'l_virtual_shipments_Type_flag',l_virtual_shipments_Type_flag);
3386: END IF;
3387: --
3388:

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

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

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

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

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

3515: --}
3516: END IF;
3517: --
3518: IF l_debug_on THEN
3519: WSH_DEBUG_SV.log(l_module_name,'prev_stop_rec.shipments_type_flag',prev_stop_rec.shipments_type_flag);
3520: WSH_DEBUG_SV.log(l_module_name,'prev_stop_rec.stop_location_id',prev_stop_rec.stop_location_id);
3521: END IF;
3522: --
3523: --

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

3516: END IF;
3517: --
3518: IF l_debug_on THEN
3519: WSH_DEBUG_SV.log(l_module_name,'prev_stop_rec.shipments_type_flag',prev_stop_rec.shipments_type_flag);
3520: WSH_DEBUG_SV.log(l_module_name,'prev_stop_rec.stop_location_id',prev_stop_rec.stop_location_id);
3521: END IF;
3522: --
3523: --
3524: IF l_virtual_shipments_type_flag IN ( 'M' , 'O' )

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

3582: --}
3583: END IF;
3584: --
3585: IF l_debug_on THEN
3586: WSH_DEBUG_SV.log(l_module_name,'open_pickup_dlvy_rec.shipment_direction',open_pickup_dlvy_rec.shipment_direction);
3587: END IF;
3588: --
3589: --
3590: IF open_pickup_dlvy_rec.shipment_direction IN ( 'O', 'IO' )

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

3657: --}
3658: END IF;
3659: --
3660: IF l_debug_on THEN
3661: WSH_DEBUG_SV.log(l_module_name,'open_dropoff_dlvy_rec.shipment_direction',open_dropoff_dlvy_rec.shipment_direction);
3662: WSH_DEBUG_SV.log(l_module_name,'open_dropoff_dlvy_rec.status_Code',open_dropoff_dlvy_rec.status_Code);
3663: WSH_DEBUG_SV.log(l_module_name,'open_dropoff_dlvy_rec.ultimate_Dropoff_location_id',open_dropoff_dlvy_rec.ultimate_Dropoff_location_id);
3664: END IF;
3665: --

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

3658: END IF;
3659: --
3660: IF l_debug_on THEN
3661: WSH_DEBUG_SV.log(l_module_name,'open_dropoff_dlvy_rec.shipment_direction',open_dropoff_dlvy_rec.shipment_direction);
3662: WSH_DEBUG_SV.log(l_module_name,'open_dropoff_dlvy_rec.status_Code',open_dropoff_dlvy_rec.status_Code);
3663: WSH_DEBUG_SV.log(l_module_name,'open_dropoff_dlvy_rec.ultimate_Dropoff_location_id',open_dropoff_dlvy_rec.ultimate_Dropoff_location_id);
3664: END IF;
3665: --
3666: --

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

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

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

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

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

3776: LOOP
3777: --{
3778: IF l_debug_on THEN
3779: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_shipments_type_flag',prev_leg_rec.do_stop_shipments_type_flag);
3780: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_status_code',prev_leg_rec.do_stop_status_code);
3781: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_locationId',prev_leg_rec.do_stop_locationId);
3782: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_id',prev_leg_rec.do_stop_id);
3783: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_shipments_type_flag',prev_leg_rec.pu_stop_shipments_type_flag);
3784: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_status_code',prev_leg_rec.pu_stop_status_code);

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

3777: --{
3778: IF l_debug_on THEN
3779: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_shipments_type_flag',prev_leg_rec.do_stop_shipments_type_flag);
3780: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_status_code',prev_leg_rec.do_stop_status_code);
3781: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_locationId',prev_leg_rec.do_stop_locationId);
3782: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_id',prev_leg_rec.do_stop_id);
3783: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_shipments_type_flag',prev_leg_rec.pu_stop_shipments_type_flag);
3784: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_status_code',prev_leg_rec.pu_stop_status_code);
3785: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_locationId',prev_leg_rec.pu_stop_locationId);

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

3778: IF l_debug_on THEN
3779: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_shipments_type_flag',prev_leg_rec.do_stop_shipments_type_flag);
3780: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_status_code',prev_leg_rec.do_stop_status_code);
3781: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_locationId',prev_leg_rec.do_stop_locationId);
3782: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_id',prev_leg_rec.do_stop_id);
3783: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_shipments_type_flag',prev_leg_rec.pu_stop_shipments_type_flag);
3784: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_status_code',prev_leg_rec.pu_stop_status_code);
3785: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_locationId',prev_leg_rec.pu_stop_locationId);
3786: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_id',prev_leg_rec.pu_stop_id);

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

3779: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_shipments_type_flag',prev_leg_rec.do_stop_shipments_type_flag);
3780: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_status_code',prev_leg_rec.do_stop_status_code);
3781: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_locationId',prev_leg_rec.do_stop_locationId);
3782: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_id',prev_leg_rec.do_stop_id);
3783: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_shipments_type_flag',prev_leg_rec.pu_stop_shipments_type_flag);
3784: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_status_code',prev_leg_rec.pu_stop_status_code);
3785: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_locationId',prev_leg_rec.pu_stop_locationId);
3786: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_id',prev_leg_rec.pu_stop_id);
3787: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.shipment_direction',prev_leg_rec.shipment_direction);

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

3780: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_status_code',prev_leg_rec.do_stop_status_code);
3781: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_locationId',prev_leg_rec.do_stop_locationId);
3782: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_id',prev_leg_rec.do_stop_id);
3783: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_shipments_type_flag',prev_leg_rec.pu_stop_shipments_type_flag);
3784: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_status_code',prev_leg_rec.pu_stop_status_code);
3785: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_locationId',prev_leg_rec.pu_stop_locationId);
3786: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_id',prev_leg_rec.pu_stop_id);
3787: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.shipment_direction',prev_leg_rec.shipment_direction);
3788: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.dlvy_status_code',prev_leg_rec.dlvy_status_code);

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

3781: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_locationId',prev_leg_rec.do_stop_locationId);
3782: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_id',prev_leg_rec.do_stop_id);
3783: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_shipments_type_flag',prev_leg_rec.pu_stop_shipments_type_flag);
3784: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_status_code',prev_leg_rec.pu_stop_status_code);
3785: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_locationId',prev_leg_rec.pu_stop_locationId);
3786: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_id',prev_leg_rec.pu_stop_id);
3787: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.shipment_direction',prev_leg_rec.shipment_direction);
3788: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.dlvy_status_code',prev_leg_rec.dlvy_status_code);
3789: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.delivery_id',prev_leg_rec.delivery_id);

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

3782: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_id',prev_leg_rec.do_stop_id);
3783: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_shipments_type_flag',prev_leg_rec.pu_stop_shipments_type_flag);
3784: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_status_code',prev_leg_rec.pu_stop_status_code);
3785: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_locationId',prev_leg_rec.pu_stop_locationId);
3786: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_id',prev_leg_rec.pu_stop_id);
3787: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.shipment_direction',prev_leg_rec.shipment_direction);
3788: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.dlvy_status_code',prev_leg_rec.dlvy_status_code);
3789: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.delivery_id',prev_leg_rec.delivery_id);
3790: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.dlvy_initialPULocationId',prev_leg_rec.dlvy_initialPULocationId);

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

3783: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_shipments_type_flag',prev_leg_rec.pu_stop_shipments_type_flag);
3784: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_status_code',prev_leg_rec.pu_stop_status_code);
3785: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_locationId',prev_leg_rec.pu_stop_locationId);
3786: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_id',prev_leg_rec.pu_stop_id);
3787: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.shipment_direction',prev_leg_rec.shipment_direction);
3788: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.dlvy_status_code',prev_leg_rec.dlvy_status_code);
3789: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.delivery_id',prev_leg_rec.delivery_id);
3790: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.dlvy_initialPULocationId',prev_leg_rec.dlvy_initialPULocationId);
3791: END IF;

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

3784: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_status_code',prev_leg_rec.pu_stop_status_code);
3785: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_locationId',prev_leg_rec.pu_stop_locationId);
3786: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_id',prev_leg_rec.pu_stop_id);
3787: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.shipment_direction',prev_leg_rec.shipment_direction);
3788: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.dlvy_status_code',prev_leg_rec.dlvy_status_code);
3789: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.delivery_id',prev_leg_rec.delivery_id);
3790: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.dlvy_initialPULocationId',prev_leg_rec.dlvy_initialPULocationId);
3791: END IF;
3792: --

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

3785: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_locationId',prev_leg_rec.pu_stop_locationId);
3786: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_id',prev_leg_rec.pu_stop_id);
3787: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.shipment_direction',prev_leg_rec.shipment_direction);
3788: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.dlvy_status_code',prev_leg_rec.dlvy_status_code);
3789: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.delivery_id',prev_leg_rec.delivery_id);
3790: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.dlvy_initialPULocationId',prev_leg_rec.dlvy_initialPULocationId);
3791: END IF;
3792: --
3793: IF prev_leg_rec.do_stop_status_code = 'OP'

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

3786: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_id',prev_leg_rec.pu_stop_id);
3787: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.shipment_direction',prev_leg_rec.shipment_direction);
3788: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.dlvy_status_code',prev_leg_rec.dlvy_status_code);
3789: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.delivery_id',prev_leg_rec.delivery_id);
3790: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.dlvy_initialPULocationId',prev_leg_rec.dlvy_initialPULocationId);
3791: END IF;
3792: --
3793: IF prev_leg_rec.do_stop_status_code = 'OP'
3794: THEN

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

3870: --}
3871: END IF;
3872: --
3873: IF l_debug_on THEN
3874: WSH_DEBUG_SV.log(l_module_name,'prev_stop_rec.shipments_type_flag',prev_stop_rec.shipments_type_flag);
3875: WSH_DEBUG_SV.log(l_module_name,'prev_stop_rec.stop_location_id',prev_stop_rec.stop_location_id);
3876: END IF;
3877: --
3878: --

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

3871: END IF;
3872: --
3873: IF l_debug_on THEN
3874: WSH_DEBUG_SV.log(l_module_name,'prev_stop_rec.shipments_type_flag',prev_stop_rec.shipments_type_flag);
3875: WSH_DEBUG_SV.log(l_module_name,'prev_stop_rec.stop_location_id',prev_stop_rec.stop_location_id);
3876: END IF;
3877: --
3878: --
3879: IF l_virtual_shipments_Type_flag = 'I'

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

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

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

3935: LOOP
3936: --{
3937:
3938: IF l_debug_on THEN
3939: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_shipments_type_flag',prev_leg_rec1.do_stop_shipments_type_flag);
3940: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_status_code',prev_leg_rec1.do_stop_status_code);
3941: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_locationId',prev_leg_rec1.do_stop_locationId);
3942: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_id',prev_leg_rec1.do_stop_id);
3943: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_shipments_type_flag',prev_leg_rec1.pu_stop_shipments_type_flag);

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

3936: --{
3937:
3938: IF l_debug_on THEN
3939: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_shipments_type_flag',prev_leg_rec1.do_stop_shipments_type_flag);
3940: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_status_code',prev_leg_rec1.do_stop_status_code);
3941: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_locationId',prev_leg_rec1.do_stop_locationId);
3942: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_id',prev_leg_rec1.do_stop_id);
3943: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_shipments_type_flag',prev_leg_rec1.pu_stop_shipments_type_flag);
3944: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_status_code',prev_leg_rec1.pu_stop_status_code);

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

3937:
3938: IF l_debug_on THEN
3939: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_shipments_type_flag',prev_leg_rec1.do_stop_shipments_type_flag);
3940: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_status_code',prev_leg_rec1.do_stop_status_code);
3941: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_locationId',prev_leg_rec1.do_stop_locationId);
3942: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_id',prev_leg_rec1.do_stop_id);
3943: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_shipments_type_flag',prev_leg_rec1.pu_stop_shipments_type_flag);
3944: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_status_code',prev_leg_rec1.pu_stop_status_code);
3945: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_locationId',prev_leg_rec1.pu_stop_locationId);

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

3938: IF l_debug_on THEN
3939: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_shipments_type_flag',prev_leg_rec1.do_stop_shipments_type_flag);
3940: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_status_code',prev_leg_rec1.do_stop_status_code);
3941: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_locationId',prev_leg_rec1.do_stop_locationId);
3942: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_id',prev_leg_rec1.do_stop_id);
3943: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_shipments_type_flag',prev_leg_rec1.pu_stop_shipments_type_flag);
3944: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_status_code',prev_leg_rec1.pu_stop_status_code);
3945: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_locationId',prev_leg_rec1.pu_stop_locationId);
3946: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_id',prev_leg_rec1.pu_stop_id);

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

3939: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_shipments_type_flag',prev_leg_rec1.do_stop_shipments_type_flag);
3940: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_status_code',prev_leg_rec1.do_stop_status_code);
3941: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_locationId',prev_leg_rec1.do_stop_locationId);
3942: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_id',prev_leg_rec1.do_stop_id);
3943: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_shipments_type_flag',prev_leg_rec1.pu_stop_shipments_type_flag);
3944: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_status_code',prev_leg_rec1.pu_stop_status_code);
3945: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_locationId',prev_leg_rec1.pu_stop_locationId);
3946: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_id',prev_leg_rec1.pu_stop_id);
3947: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.shipment_direction',prev_leg_rec1.shipment_direction);

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

3940: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_status_code',prev_leg_rec1.do_stop_status_code);
3941: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_locationId',prev_leg_rec1.do_stop_locationId);
3942: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_id',prev_leg_rec1.do_stop_id);
3943: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_shipments_type_flag',prev_leg_rec1.pu_stop_shipments_type_flag);
3944: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_status_code',prev_leg_rec1.pu_stop_status_code);
3945: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_locationId',prev_leg_rec1.pu_stop_locationId);
3946: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_id',prev_leg_rec1.pu_stop_id);
3947: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.shipment_direction',prev_leg_rec1.shipment_direction);
3948: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.dlvy_status_code',prev_leg_rec1.dlvy_status_code);

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

3941: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_locationId',prev_leg_rec1.do_stop_locationId);
3942: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_id',prev_leg_rec1.do_stop_id);
3943: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_shipments_type_flag',prev_leg_rec1.pu_stop_shipments_type_flag);
3944: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_status_code',prev_leg_rec1.pu_stop_status_code);
3945: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_locationId',prev_leg_rec1.pu_stop_locationId);
3946: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_id',prev_leg_rec1.pu_stop_id);
3947: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.shipment_direction',prev_leg_rec1.shipment_direction);
3948: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.dlvy_status_code',prev_leg_rec1.dlvy_status_code);
3949: END IF;

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

3942: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.do_stop_id',prev_leg_rec1.do_stop_id);
3943: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_shipments_type_flag',prev_leg_rec1.pu_stop_shipments_type_flag);
3944: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_status_code',prev_leg_rec1.pu_stop_status_code);
3945: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_locationId',prev_leg_rec1.pu_stop_locationId);
3946: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_id',prev_leg_rec1.pu_stop_id);
3947: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.shipment_direction',prev_leg_rec1.shipment_direction);
3948: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.dlvy_status_code',prev_leg_rec1.dlvy_status_code);
3949: END IF;
3950: --

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

3943: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_shipments_type_flag',prev_leg_rec1.pu_stop_shipments_type_flag);
3944: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_status_code',prev_leg_rec1.pu_stop_status_code);
3945: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_locationId',prev_leg_rec1.pu_stop_locationId);
3946: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_id',prev_leg_rec1.pu_stop_id);
3947: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.shipment_direction',prev_leg_rec1.shipment_direction);
3948: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.dlvy_status_code',prev_leg_rec1.dlvy_status_code);
3949: END IF;
3950: --
3951: IF prev_leg_rec1.do_stop_status_code = 'OP'

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

3944: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_status_code',prev_leg_rec1.pu_stop_status_code);
3945: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_locationId',prev_leg_rec1.pu_stop_locationId);
3946: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.pu_stop_id',prev_leg_rec1.pu_stop_id);
3947: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.shipment_direction',prev_leg_rec1.shipment_direction);
3948: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec1.dlvy_status_code',prev_leg_rec1.dlvy_status_code);
3949: END IF;
3950: --
3951: IF prev_leg_rec1.do_stop_status_code = 'OP'
3952: THEN

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

4025: --}
4026: END IF;
4027: --
4028: IF l_debug_on THEN
4029: WSH_DEBUG_SV.log(l_module_name,'prev_stop_rec.shipments_type_flag',prev_stop_rec.shipments_type_flag);
4030: WSH_DEBUG_SV.log(l_module_name,'prev_stop_rec.stop_location_id',prev_stop_rec.stop_location_id);
4031: END IF;
4032: --
4033: --

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

4026: END IF;
4027: --
4028: IF l_debug_on THEN
4029: WSH_DEBUG_SV.log(l_module_name,'prev_stop_rec.shipments_type_flag',prev_stop_rec.shipments_type_flag);
4030: WSH_DEBUG_SV.log(l_module_name,'prev_stop_rec.stop_location_id',prev_stop_rec.stop_location_id);
4031: END IF;
4032: --
4033: --
4034: IF l_virtual_shipments_Type_flag = 'I'

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

4098: l_linked_stop_info_rec.stop_id)
4099: LOOP
4100: --{
4101: IF l_debug_on THEN
4102: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_stop_statusCode',ib_pickup_rec.pu_stop_statusCode);
4103: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_shipments_type_flag',ib_pickup_rec.pu_shipments_type_flag);
4104: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.delivery_statusCode',ib_pickup_rec.delivery_statusCode);
4105: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_stop_locationId',ib_pickup_rec.pu_stop_locationId);
4106: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_stop_id',ib_pickup_rec.pu_stop_id);

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

4099: LOOP
4100: --{
4101: IF l_debug_on THEN
4102: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_stop_statusCode',ib_pickup_rec.pu_stop_statusCode);
4103: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_shipments_type_flag',ib_pickup_rec.pu_shipments_type_flag);
4104: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.delivery_statusCode',ib_pickup_rec.delivery_statusCode);
4105: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_stop_locationId',ib_pickup_rec.pu_stop_locationId);
4106: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_stop_id',ib_pickup_rec.pu_stop_id);
4107: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.delivery_id',ib_pickup_rec.delivery_id);

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

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

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

4101: IF l_debug_on THEN
4102: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_stop_statusCode',ib_pickup_rec.pu_stop_statusCode);
4103: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_shipments_type_flag',ib_pickup_rec.pu_shipments_type_flag);
4104: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.delivery_statusCode',ib_pickup_rec.delivery_statusCode);
4105: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_stop_locationId',ib_pickup_rec.pu_stop_locationId);
4106: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_stop_id',ib_pickup_rec.pu_stop_id);
4107: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.delivery_id',ib_pickup_rec.delivery_id);
4108: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.dlvy_initialPULocationId',ib_pickup_rec.dlvy_initialPULocationId);
4109: END IF;

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

4102: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_stop_statusCode',ib_pickup_rec.pu_stop_statusCode);
4103: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_shipments_type_flag',ib_pickup_rec.pu_shipments_type_flag);
4104: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.delivery_statusCode',ib_pickup_rec.delivery_statusCode);
4105: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_stop_locationId',ib_pickup_rec.pu_stop_locationId);
4106: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_stop_id',ib_pickup_rec.pu_stop_id);
4107: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.delivery_id',ib_pickup_rec.delivery_id);
4108: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.dlvy_initialPULocationId',ib_pickup_rec.dlvy_initialPULocationId);
4109: END IF;
4110: --

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

4103: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_shipments_type_flag',ib_pickup_rec.pu_shipments_type_flag);
4104: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.delivery_statusCode',ib_pickup_rec.delivery_statusCode);
4105: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_stop_locationId',ib_pickup_rec.pu_stop_locationId);
4106: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_stop_id',ib_pickup_rec.pu_stop_id);
4107: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.delivery_id',ib_pickup_rec.delivery_id);
4108: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.dlvy_initialPULocationId',ib_pickup_rec.dlvy_initialPULocationId);
4109: END IF;
4110: --
4111: IF ib_pickup_rec.pu_stop_statusCode in ('OP','AR')

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

4104: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.delivery_statusCode',ib_pickup_rec.delivery_statusCode);
4105: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_stop_locationId',ib_pickup_rec.pu_stop_locationId);
4106: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.pu_stop_id',ib_pickup_rec.pu_stop_id);
4107: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.delivery_id',ib_pickup_rec.delivery_id);
4108: WSH_DEBUG_SV.log(l_module_name,'ib_pickup_rec.dlvy_initialPULocationId',ib_pickup_rec.dlvy_initialPULocationId);
4109: END IF;
4110: --
4111: IF ib_pickup_rec.pu_stop_statusCode in ('OP','AR')
4112: THEN

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

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

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

4137: LOOP
4138: --{
4139:
4140: IF l_debug_on THEN
4141: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_shipments_type_flag',prev_leg_rec.do_stop_shipments_type_flag);
4142: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_status_code',prev_leg_rec.do_stop_status_code);
4143: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_locationId',prev_leg_rec.do_stop_locationId);
4144: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_id',prev_leg_rec.do_stop_id);
4145: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_shipments_type_flag',prev_leg_rec.pu_stop_shipments_type_flag);

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

4138: --{
4139:
4140: IF l_debug_on THEN
4141: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_shipments_type_flag',prev_leg_rec.do_stop_shipments_type_flag);
4142: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_status_code',prev_leg_rec.do_stop_status_code);
4143: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_locationId',prev_leg_rec.do_stop_locationId);
4144: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_id',prev_leg_rec.do_stop_id);
4145: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_shipments_type_flag',prev_leg_rec.pu_stop_shipments_type_flag);
4146: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_status_code',prev_leg_rec.pu_stop_status_code);

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

4139:
4140: IF l_debug_on THEN
4141: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_shipments_type_flag',prev_leg_rec.do_stop_shipments_type_flag);
4142: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_status_code',prev_leg_rec.do_stop_status_code);
4143: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_locationId',prev_leg_rec.do_stop_locationId);
4144: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_id',prev_leg_rec.do_stop_id);
4145: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_shipments_type_flag',prev_leg_rec.pu_stop_shipments_type_flag);
4146: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_status_code',prev_leg_rec.pu_stop_status_code);
4147: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_locationId',prev_leg_rec.pu_stop_locationId);

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

4140: IF l_debug_on THEN
4141: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_shipments_type_flag',prev_leg_rec.do_stop_shipments_type_flag);
4142: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_status_code',prev_leg_rec.do_stop_status_code);
4143: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_locationId',prev_leg_rec.do_stop_locationId);
4144: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_id',prev_leg_rec.do_stop_id);
4145: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_shipments_type_flag',prev_leg_rec.pu_stop_shipments_type_flag);
4146: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_status_code',prev_leg_rec.pu_stop_status_code);
4147: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_locationId',prev_leg_rec.pu_stop_locationId);
4148: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_id',prev_leg_rec.pu_stop_id);

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

4141: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_shipments_type_flag',prev_leg_rec.do_stop_shipments_type_flag);
4142: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_status_code',prev_leg_rec.do_stop_status_code);
4143: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_locationId',prev_leg_rec.do_stop_locationId);
4144: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_id',prev_leg_rec.do_stop_id);
4145: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_shipments_type_flag',prev_leg_rec.pu_stop_shipments_type_flag);
4146: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_status_code',prev_leg_rec.pu_stop_status_code);
4147: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_locationId',prev_leg_rec.pu_stop_locationId);
4148: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_id',prev_leg_rec.pu_stop_id);
4149: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.shipment_direction',prev_leg_rec.shipment_direction);

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

4142: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_status_code',prev_leg_rec.do_stop_status_code);
4143: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_locationId',prev_leg_rec.do_stop_locationId);
4144: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_id',prev_leg_rec.do_stop_id);
4145: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_shipments_type_flag',prev_leg_rec.pu_stop_shipments_type_flag);
4146: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_status_code',prev_leg_rec.pu_stop_status_code);
4147: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_locationId',prev_leg_rec.pu_stop_locationId);
4148: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_id',prev_leg_rec.pu_stop_id);
4149: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.shipment_direction',prev_leg_rec.shipment_direction);
4150: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.dlvy_status_code',prev_leg_rec.dlvy_status_code);

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

4143: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_locationId',prev_leg_rec.do_stop_locationId);
4144: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_id',prev_leg_rec.do_stop_id);
4145: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_shipments_type_flag',prev_leg_rec.pu_stop_shipments_type_flag);
4146: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_status_code',prev_leg_rec.pu_stop_status_code);
4147: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_locationId',prev_leg_rec.pu_stop_locationId);
4148: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_id',prev_leg_rec.pu_stop_id);
4149: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.shipment_direction',prev_leg_rec.shipment_direction);
4150: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.dlvy_status_code',prev_leg_rec.dlvy_status_code);
4151: END IF;

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

4144: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.do_stop_id',prev_leg_rec.do_stop_id);
4145: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_shipments_type_flag',prev_leg_rec.pu_stop_shipments_type_flag);
4146: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_status_code',prev_leg_rec.pu_stop_status_code);
4147: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_locationId',prev_leg_rec.pu_stop_locationId);
4148: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_id',prev_leg_rec.pu_stop_id);
4149: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.shipment_direction',prev_leg_rec.shipment_direction);
4150: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.dlvy_status_code',prev_leg_rec.dlvy_status_code);
4151: END IF;
4152: --

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

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

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

4146: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_status_code',prev_leg_rec.pu_stop_status_code);
4147: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_locationId',prev_leg_rec.pu_stop_locationId);
4148: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.pu_stop_id',prev_leg_rec.pu_stop_id);
4149: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.shipment_direction',prev_leg_rec.shipment_direction);
4150: WSH_DEBUG_SV.log(l_module_name,'prev_leg_rec.dlvy_status_code',prev_leg_rec.dlvy_status_code);
4151: END IF;
4152: --
4153: --IF prev_leg_rec.do_stop_status_code in ('OP','AR')
4154: IF prev_leg_rec.do_stop_status_code in ('OP')

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

4228: --}
4229: END IF;
4230: --
4231: IF l_debug_on THEN
4232: WSH_DEBUG_SV.log(l_module_name,'prev_stop_rec.shipments_type_flag',prev_stop_rec.shipments_type_flag);
4233: WSH_DEBUG_SV.log(l_module_name,'prev_stop_rec.stop_location_id',prev_stop_rec.stop_location_id);
4234: END IF;
4235: --
4236: --

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

4229: END IF;
4230: --
4231: IF l_debug_on THEN
4232: WSH_DEBUG_SV.log(l_module_name,'prev_stop_rec.shipments_type_flag',prev_stop_rec.shipments_type_flag);
4233: WSH_DEBUG_SV.log(l_module_name,'prev_stop_rec.stop_location_id',prev_stop_rec.stop_location_id);
4234: END IF;
4235: --
4236: --
4237: IF l_virtual_shipments_Type_flag = 'I'

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

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

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

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

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

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

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

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

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

4313: --
4314: IF l_debug_on THEN
4315: WSH_DEBUG_SV.log(l_module_name,'l_prev_org_dlvy_cnt',l_prev_org_dlvy_cnt);
4316: WSH_DEBUG_SV.log(l_module_name,'l_dlvy_cnt',l_dlvy_cnt);
4317: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.Get',WSH_DEBUG_SV.C_PROC_LEVEL);
4318: END IF;
4319: --
4320: WSH_SHIPPING_PARAMS_PVT.Get
4321: (

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

4324: x_return_status => l_return_status
4325: );
4326: --
4327: IF l_debug_on THEN
4328: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
4329: END IF;
4330: --
4331: WSH_UTIL_CORE.api_post_call
4332: (

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

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

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

4349: );
4350: --
4351:
4352: IF l_debug_on THEN
4353: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
4354: END IF;
4355: --
4356:
4357: WSH_UTIL_CORE.api_post_call

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

4546: x_exceptions_tab => l_exceptions_tab,
4547: x_return_status => l_return_status);
4548: --
4549: IF l_debug_on THEN
4550: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
4551: END IF;
4552: --
4553: WSH_UTIL_CORE.api_post_call
4554: (

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

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

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

4625: x_allowed => l_Allowed
4626: );
4627: --
4628: IF l_debug_on THEN
4629: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
4630: WSH_DEBUG_SV.log(l_module_name,'l_Allowed',l_Allowed);
4631: END IF;
4632: --
4633: --

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

4626: );
4627: --
4628: IF l_debug_on THEN
4629: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
4630: WSH_DEBUG_SV.log(l_module_name,'l_Allowed',l_Allowed);
4631: END IF;
4632: --
4633: --
4634: WSH_UTIL_CORE.api_post_call

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

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

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

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

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

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

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

4751: x_allowed => l_Allowed
4752: );
4753: --
4754: IF l_debug_on THEN
4755: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
4756: WSH_DEBUG_SV.log(l_module_name,'l_Allowed',l_Allowed);
4757: END IF;
4758: --
4759: --

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

4752: );
4753: --
4754: IF l_debug_on THEN
4755: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
4756: WSH_DEBUG_SV.log(l_module_name,'l_Allowed',l_Allowed);
4757: END IF;
4758: --
4759: --
4760: WSH_UTIL_CORE.api_post_call

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

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

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

4817: x_allowed => l_Allowed
4818: );
4819: --
4820: IF l_debug_on THEN
4821: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
4822: WSH_DEBUG_SV.log(l_module_name,'l_Allowed',l_Allowed);
4823: END IF;
4824: --
4825: --

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

4818: );
4819: --
4820: IF l_debug_on THEN
4821: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
4822: WSH_DEBUG_SV.log(l_module_name,'l_Allowed',l_Allowed);
4823: END IF;
4824: --
4825: --
4826: WSH_UTIL_CORE.api_post_call

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

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

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

4870: x_allowed => l_Allowed
4871: );
4872: --
4873: IF l_debug_on THEN
4874: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
4875: WSH_DEBUG_SV.log(l_module_name,'l_Allowed',l_Allowed);
4876: END IF;
4877: --
4878: --

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

4871: );
4872: --
4873: IF l_debug_on THEN
4874: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
4875: WSH_DEBUG_SV.log(l_module_name,'l_Allowed',l_Allowed);
4876: END IF;
4877: --
4878: --
4879: WSH_UTIL_CORE.api_post_call

Line 4932: WSH_DEBUG_SV.pop(l_module_name);

4928: --
4929: -- Debug Statements
4930: --
4931: IF l_debug_on THEN
4932: WSH_DEBUG_SV.pop(l_module_name);
4933: END IF;
4934: --
4935: --}
4936: EXCEPTION

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

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

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

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

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

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

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

4963: --
4964: --
4965: IF l_debug_on THEN
4966: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4967: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4968: END IF;
4969: --
4970: WHEN FND_API.G_EXC_ERROR THEN
4971:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 5121: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

5117: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
5118: --
5119: IF l_debug_on IS NULL
5120: THEN
5121: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
5122: END IF;
5123: --
5124: IF l_debug_on THEN
5125: WSH_DEBUG_SV.push(l_module_name);

Line 5125: WSH_DEBUG_SV.push(l_module_name);

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

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

5123: --
5124: IF l_debug_on THEN
5125: WSH_DEBUG_SV.push(l_module_name);
5126: --
5127: WSH_DEBUG_SV.log(l_module_name,'p_trip_id',p_trip_id);
5128: WSH_DEBUG_SV.log(l_module_name,'p_stop_id',p_stop_id);
5129: WSH_DEBUG_SV.log(l_module_name,'p_stop_sequence_number',p_stop_sequence_number);
5130: END IF;
5131: --

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

5124: IF l_debug_on THEN
5125: WSH_DEBUG_SV.push(l_module_name);
5126: --
5127: WSH_DEBUG_SV.log(l_module_name,'p_trip_id',p_trip_id);
5128: WSH_DEBUG_SV.log(l_module_name,'p_stop_id',p_stop_id);
5129: WSH_DEBUG_SV.log(l_module_name,'p_stop_sequence_number',p_stop_sequence_number);
5130: END IF;
5131: --
5132: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

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

5125: WSH_DEBUG_SV.push(l_module_name);
5126: --
5127: WSH_DEBUG_SV.log(l_module_name,'p_trip_id',p_trip_id);
5128: WSH_DEBUG_SV.log(l_module_name,'p_stop_id',p_stop_id);
5129: WSH_DEBUG_SV.log(l_module_name,'p_stop_sequence_number',p_stop_sequence_number);
5130: END IF;
5131: --
5132: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5133: --

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

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

Line 5193: WSH_DEBUG_SV.pop(l_module_name);

5189: -- Debug Statements
5190: --
5191: IF l_debug_on THEN
5192: WSH_DEBUG_SV.log(l_module_name,'l_actual_date',l_actual_date);
5193: WSH_DEBUG_SV.pop(l_module_name);
5194: END IF;
5195: --}
5196: EXCEPTION
5197: --

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

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

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

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

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

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

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

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

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

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

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

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

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

5225:
5226: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
5227: wsh_util_core.default_handler('WSH_TRIP_STOPS_VALIDATIONS.get_stop_close_date', l_module_name);
5228: IF l_debug_on THEN
5229: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5230: END IF;
5231: --
5232: END get_stop_close_date;
5233:

Line 5259: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

5255: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
5256: --
5257: IF l_debug_on IS NULL
5258: THEN
5259: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
5260: END IF;
5261: --
5262: IF l_debug_on THEN
5263: --

Line 5264: WSH_DEBUG_SV.push(l_module_name);

5260: END IF;
5261: --
5262: IF l_debug_on THEN
5263: --
5264: WSH_DEBUG_SV.push(l_module_name);
5265: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.caller',p_in_rec.caller);
5266: --
5267: END IF;
5268: --

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

5261: --
5262: IF l_debug_on THEN
5263: --
5264: WSH_DEBUG_SV.push(l_module_name);
5265: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.caller',p_in_rec.caller);
5266: --
5267: END IF;
5268: --
5269: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

5747: l_attributes := l_attributes || 'TP_STOP_ID, ';
5748: END IF;
5749:
5750: IF l_debug_on THEN
5751: WSH_DEBUG_SV.log(l_module_name,'l_attributes',l_attributes);
5752: WSH_DEBUG_SV.log(l_module_name,'length(l_attributes)',length(l_attributes));
5753: END IF;
5754:
5755:

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

5748: END IF;
5749:
5750: IF l_debug_on THEN
5751: WSH_DEBUG_SV.log(l_module_name,'l_attributes',l_attributes);
5752: WSH_DEBUG_SV.log(l_module_name,'length(l_attributes)',length(l_attributes));
5753: END IF;
5754:
5755:
5756: IF l_attributes IS NULL THEN

Line 5759: WSH_DEBUG_SV.pop(l_module_name);

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

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

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

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

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

Line 5776: wsh_debug_sv.pop(l_module_name);

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

Line 5785: WSH_DEBUG_SV.pop(l_module_name);

5781: END IF;
5782: END IF;
5783:
5784: IF l_debug_on THEN
5785: WSH_DEBUG_SV.pop(l_module_name);
5786: END IF;
5787: --
5788:
5789:

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

5791: WHEN OTHERS THEN
5792: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
5793: --
5794: IF l_debug_on THEN
5795: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5796: END IF;
5797: --
5798: END user_non_updatable_columns;
5799: