96: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
97: --
98: IF l_debug_on IS NULL
99: THEN
100: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
101: END IF;
102: --
103: IF l_debug_on THEN
104: WSH_DEBUG_SV.push(l_module_name);
100: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
101: END IF;
102: --
103: IF l_debug_on THEN
104: WSH_DEBUG_SV.push(l_module_name);
105: --
106: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
107: END IF;
108: --
102: --
103: IF l_debug_on THEN
104: WSH_DEBUG_SV.push(l_module_name);
105: --
106: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
107: END IF;
108: --
109: OPEN stops_exist;
110: FETCH stops_exist INTO l_numstops;
115: --
116: -- Debug Statements
117: --
118: IF l_debug_on THEN
119: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
120: END IF;
121: --
122: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
123: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
125: --
126: -- Debug Statements
127: --
128: IF l_debug_on THEN
129: WSH_DEBUG_SV.pop(l_module_name);
130: END IF;
131: --
132: RETURN;
133: END IF;
143: --
144: -- Debug Statements
145: --
146: IF l_debug_on THEN
147: WSH_DEBUG_SV.pop(l_module_name);
148: END IF;
149: --
150: RETURN;
151: END IF;
162: --
163: -- Debug Statements
164: --
165: IF l_debug_on THEN
166: WSH_DEBUG_SV.pop(l_module_name);
167: END IF;
168: --
169: RETURN;
170: END IF;
171:
172: IF l_mode='TRUCK' and l_vehicle is NULL AND WSH_UTIL_CORE.TP_IS_INSTALLED='Y' THEN
173: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_MODE_TR_REQ_VEH');
174: IF l_debug_on THEN
175: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
176: END IF;
177: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
178: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
179: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
180: --
181: -- Debug Statements
182: --
183: IF l_debug_on THEN
184: WSH_DEBUG_SV.pop(l_module_name);
185: END IF;
186: --
187: RETURN;
188: END IF;
198: --
199: -- Debug Statements
200: --
201: IF l_debug_on THEN
202: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
203: END IF;
204: --
205: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
206: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
218: --
219: -- Debug Statements
220: --
221: IF l_debug_on THEN
222: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
223: END IF;
224: --
225: -- Bug 3697947
226: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(st.stop_id,p_caller));
231: --
232: -- Debug Statements
233: --
234: IF l_debug_on THEN
235: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
236: END IF;
237: --
238: -- Bug 3697947
239: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(st.stop_id,p_caller));
246: --
247: -- Debug Statements
248: --
249: IF l_debug_on THEN
250: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
251: END IF;
252: --
253: -- Bug 3697947
254: FND_MESSAGE.SET_TOKEN('STOP_NAME', wsh_trip_stops_pvt.get_name(st.stop_id, p_caller));
263: --
264: -- Debug Statements
265: --
266: IF l_debug_on THEN
267: WSH_DEBUG_SV.pop(l_module_name);
268: END IF;
269: --
270: EXCEPTION
271: WHEN others THEN
271: WHEN others THEN
272: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.CHECK_PLAN');
273: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
274: IF l_debug_on THEN
275: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
276: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
277: END IF;
278:
279: END Check_Plan;
272: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.CHECK_PLAN');
273: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
274: IF l_debug_on THEN
275: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
276: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
277: END IF;
278:
279: END Check_Plan;
280:
319: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
320: --
321: IF l_debug_on IS NULL
322: THEN
323: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
324: END IF;
325: --
326: IF l_debug_on THEN
327: WSH_DEBUG_SV.push(l_module_name);
323: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
324: END IF;
325: --
326: IF l_debug_on THEN
327: WSH_DEBUG_SV.push(l_module_name);
328: --
329: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
330: END IF;
331: --
325: --
326: IF l_debug_on THEN
327: WSH_DEBUG_SV.push(l_module_name);
328: --
329: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
330: END IF;
331: --
332: OPEN trip_info;
333: FETCH trip_info INTO l_status_code, l_planned_flag,l_shipments_type_flag;
340: --
341: -- Debug Statements
342: --
343: IF l_debug_on THEN
344: WSH_DEBUG_SV.pop(l_module_name);
345: END IF;
346: --
347: RETURN;
348: END IF;
354: --
355: -- Debug Statements
356: --
357: IF l_debug_on THEN
358: WSH_DEBUG_SV.pop(l_module_name);
359: END IF;
360: --
361: EXCEPTION
362: WHEN others THEN
366: --
367: -- Debug Statements
368: --
369: IF l_debug_on THEN
370: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
371: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
372: END IF;
373: --
374: END Check_Unplan;
367: -- Debug Statements
368: --
369: IF l_debug_on THEN
370: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
371: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
372: END IF;
373: --
374: END Check_Unplan;
375:
406: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
407: --
408: IF l_debug_on IS NULL
409: THEN
410: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
411: END IF;
412: --
413: IF l_debug_on THEN
414: WSH_DEBUG_SV.push(l_module_name);
410: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
411: END IF;
412: --
413: IF l_debug_on THEN
414: WSH_DEBUG_SV.push(l_module_name);
415: --
416: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
417: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
418: END IF;
412: --
413: IF l_debug_on THEN
414: WSH_DEBUG_SV.push(l_module_name);
415: --
416: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
417: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
418: END IF;
419: --
420: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
413: IF l_debug_on THEN
414: WSH_DEBUG_SV.push(l_module_name);
415: --
416: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
417: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
418: END IF;
419: --
420: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
421:
426: --
427: -- Debug Statements
428: --
429: IF l_debug_on THEN
430: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
431: END IF;
432: --
433: FND_MESSAGE.SET_TOKEN('STOP_NAME', wsh_trip_stops_pvt.get_name(p_stop_id, p_caller));
434: close prev_stop_info;
437: --
438: -- Debug Statements
439: --
440: IF l_debug_on THEN
441: WSH_DEBUG_SV.pop(l_module_name);
442: END IF;
443: --
444: RETURN;
445: END IF;
448: --
449: -- Debug Statements
450: --
451: IF l_debug_on THEN
452: WSH_DEBUG_SV.pop(l_module_name);
453: END IF;
454: --
455: EXCEPTION
456: WHEN others THEN
463: --
464: -- Debug Statements
465: --
466: IF l_debug_on THEN
467: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
468: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
469: END IF;
470: --
471: END Dropoff_Del_Intransit;
464: -- Debug Statements
465: --
466: IF l_debug_on THEN
467: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
468: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
469: END IF;
470: --
471: END Dropoff_Del_Intransit;
472:
542: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
543: --
544: IF l_debug_on IS NULL
545: THEN
546: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
547: END IF;
548: --
549: IF l_debug_on THEN
550: WSH_DEBUG_SV.push(l_module_name);
546: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
547: END IF;
548: --
549: IF l_debug_on THEN
550: WSH_DEBUG_SV.push(l_module_name);
551: --
552: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
553: -- Pack J IB: KVENKATE
554: WSH_DEBUG_SV.log(l_module_name, 'p_curr_stop_seq', p_curr_stop_seq);
548: --
549: IF l_debug_on THEN
550: WSH_DEBUG_SV.push(l_module_name);
551: --
552: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
553: -- Pack J IB: KVENKATE
554: WSH_DEBUG_SV.log(l_module_name, 'p_curr_stop_seq', p_curr_stop_seq);
555: WSH_DEBUG_SV.log(l_module_name, 'p_curr_stop_type', p_curr_stop_type);
556: END IF;
550: WSH_DEBUG_SV.push(l_module_name);
551: --
552: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
553: -- Pack J IB: KVENKATE
554: WSH_DEBUG_SV.log(l_module_name, 'p_curr_stop_seq', p_curr_stop_seq);
555: WSH_DEBUG_SV.log(l_module_name, 'p_curr_stop_type', p_curr_stop_type);
556: END IF;
557: --
558: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
551: --
552: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
553: -- Pack J IB: KVENKATE
554: WSH_DEBUG_SV.log(l_module_name, 'p_curr_stop_seq', p_curr_stop_seq);
555: WSH_DEBUG_SV.log(l_module_name, 'p_curr_stop_type', p_curr_stop_type);
556: END IF;
557: --
558: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
559:
575: END IF;
576: CLOSE c_linked_stop;
577:
578: IF l_debug_on THEN
579: WSH_DEBUG_SV.log(l_module_name,'l_linked_stop_rec.link_type',l_linked_stop_rec.link_type);
580: WSH_DEBUG_SV.log(l_module_name,'l_linked_stop_rec.linked_stop_id',l_linked_stop_rec.linked_stop_id);
581: WSH_DEBUG_SV.log(l_module_name,'l_primary_stop_id',l_primary_stop_id);
582: WSH_DEBUG_SV.log(l_module_name,'l_primary_stop_id',l_secondary_stop_id);
583: WSH_DEBUG_SV.log(l_module_name,'x_linked_stop_id',x_linked_stop_id);
576: CLOSE c_linked_stop;
577:
578: IF l_debug_on THEN
579: WSH_DEBUG_SV.log(l_module_name,'l_linked_stop_rec.link_type',l_linked_stop_rec.link_type);
580: WSH_DEBUG_SV.log(l_module_name,'l_linked_stop_rec.linked_stop_id',l_linked_stop_rec.linked_stop_id);
581: WSH_DEBUG_SV.log(l_module_name,'l_primary_stop_id',l_primary_stop_id);
582: WSH_DEBUG_SV.log(l_module_name,'l_primary_stop_id',l_secondary_stop_id);
583: WSH_DEBUG_SV.log(l_module_name,'x_linked_stop_id',x_linked_stop_id);
584: END IF;
577:
578: IF l_debug_on THEN
579: WSH_DEBUG_SV.log(l_module_name,'l_linked_stop_rec.link_type',l_linked_stop_rec.link_type);
580: WSH_DEBUG_SV.log(l_module_name,'l_linked_stop_rec.linked_stop_id',l_linked_stop_rec.linked_stop_id);
581: WSH_DEBUG_SV.log(l_module_name,'l_primary_stop_id',l_primary_stop_id);
582: WSH_DEBUG_SV.log(l_module_name,'l_primary_stop_id',l_secondary_stop_id);
583: WSH_DEBUG_SV.log(l_module_name,'x_linked_stop_id',x_linked_stop_id);
584: END IF;
585:
578: IF l_debug_on THEN
579: WSH_DEBUG_SV.log(l_module_name,'l_linked_stop_rec.link_type',l_linked_stop_rec.link_type);
580: WSH_DEBUG_SV.log(l_module_name,'l_linked_stop_rec.linked_stop_id',l_linked_stop_rec.linked_stop_id);
581: WSH_DEBUG_SV.log(l_module_name,'l_primary_stop_id',l_primary_stop_id);
582: WSH_DEBUG_SV.log(l_module_name,'l_primary_stop_id',l_secondary_stop_id);
583: WSH_DEBUG_SV.log(l_module_name,'x_linked_stop_id',x_linked_stop_id);
584: END IF;
585:
586:
579: WSH_DEBUG_SV.log(l_module_name,'l_linked_stop_rec.link_type',l_linked_stop_rec.link_type);
580: WSH_DEBUG_SV.log(l_module_name,'l_linked_stop_rec.linked_stop_id',l_linked_stop_rec.linked_stop_id);
581: WSH_DEBUG_SV.log(l_module_name,'l_primary_stop_id',l_primary_stop_id);
582: WSH_DEBUG_SV.log(l_module_name,'l_primary_stop_id',l_secondary_stop_id);
583: WSH_DEBUG_SV.log(l_module_name,'x_linked_stop_id',x_linked_stop_id);
584: END IF;
585:
586:
587: -- Pack J IB: KVENKATE
589: FOR prev_stop_rec IN prev_stop_info(l_primary_stop_id) LOOP
590: --{
591:
592: IF l_debug_on THEN
593: wsh_debug_sv.log(l_module_name, 'stop_seq_num', prev_stop_rec.stop_sequence_number);
594: wsh_debug_sv.log(l_module_name, 'shipments_type_flag', prev_stop_rec.shipments_type_flag);
595: END IF;
596:
597:
590: --{
591:
592: IF l_debug_on THEN
593: wsh_debug_sv.log(l_module_name, 'stop_seq_num', prev_stop_rec.stop_sequence_number);
594: wsh_debug_sv.log(l_module_name, 'shipments_type_flag', prev_stop_rec.shipments_type_flag);
595: END IF;
596:
597:
598: IF (prev_stop_rec.status_code <> 'CL') THEN
601: --
602: -- Debug Statements
603: --
604: IF l_debug_on THEN
605: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
606: END IF;
607: --
608: FND_MESSAGE.SET_TOKEN('STOP_NAME', wsh_trip_stops_pvt.get_name(prev_stop_rec.stop_id));
609: -- Pack J IB: KVENKATE
631: --
632: -- Debug Statements
633: --
634: IF l_debug_on THEN
635: WSH_DEBUG_SV.pop(l_module_name);
636: END IF;
637: --
638: EXCEPTION
639: -- Pack J IB: KVENKATE
639: -- Pack J IB: KVENKATE
640: WHEN FND_API.G_EXC_ERROR THEN
641: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
642: IF l_debug_on THEN
643: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
644: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
645: END IF;
646: --
647:
640: WHEN FND_API.G_EXC_ERROR THEN
641: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
642: IF l_debug_on THEN
643: wsh_debug_sv.logmsg(l_module_name, 'FND_API.G_EXC_ERROR exception has occured.', wsh_debug_sv.c_excep_level);
644: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:FND_API.G_EXC_ERROR');
645: END IF;
646: --
647:
648: WHEN others THEN
658: --
659: -- Debug Statements
660: --
661: IF l_debug_on THEN
662: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
663: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
664: END IF;
665: --
666: END Check_Prev_Stop_Close;
659: -- Debug Statements
660: --
661: IF l_debug_on THEN
662: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
663: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
664: END IF;
665: --
666: END Check_Prev_Stop_Close;
667:
705: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
706: --
707: IF l_debug_on IS NULL
708: THEN
709: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
710: END IF;
711: --
712: IF l_debug_on THEN
713: WSH_DEBUG_SV.push(l_module_name);
709: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
710: END IF;
711: --
712: IF l_debug_on THEN
713: WSH_DEBUG_SV.push(l_module_name);
714: --
715: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
716: END IF;
717: --
711: --
712: IF l_debug_on THEN
713: WSH_DEBUG_SV.push(l_module_name);
714: --
715: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
716: END IF;
717: --
718: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
719:
730: --
731: -- Debug Statements
732: --
733: IF l_debug_on THEN
734: WSH_DEBUG_SV.pop(l_module_name);
735: END IF;
736: --
737: EXCEPTION
738: WHEN others THEN
745: --
746: -- Debug Statements
747: --
748: IF l_debug_on THEN
749: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
750: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
751: END IF;
752: --
753: END Check_Trip_Close;
746: -- Debug Statements
747: --
748: IF l_debug_on THEN
749: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
750: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
751: END IF;
752: --
753: END Check_Trip_Close;
754:
807: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
808: --
809: IF l_debug_on IS NULL
810: THEN
811: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
812: END IF;
813: --
814: IF l_debug_on THEN
815: WSH_DEBUG_SV.push(l_module_name);
811: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
812: END IF;
813: --
814: IF l_debug_on THEN
815: WSH_DEBUG_SV.push(l_module_name);
816: --
817: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
818: END IF;
819: --
813: --
814: IF l_debug_on THEN
815: WSH_DEBUG_SV.push(l_module_name);
816: --
817: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
818: END IF;
819: --
820: OPEN trip_info;
821: FETCH trip_info INTO l_status_code, l_planned_flag;
828: --
829: -- Debug Statements
830: --
831: IF l_debug_on THEN
832: WSH_DEBUG_SV.pop(l_module_name);
833: END IF;
834: --
835: RETURN;
836: END IF;
845: --
846: -- Debug Statements
847: --
848: IF l_debug_on THEN
849: WSH_DEBUG_SV.pop(l_module_name);
850: END IF;
851: --
852: RETURN;
853: END IF;
859: --
860: -- Debug Statements
861: --
862: IF l_debug_on THEN
863: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
864: END IF;
865: --
866: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(p_trip_id));
867: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
871: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
872: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
873: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
874: IF l_debug_on THEN
875: WSH_DEBUG_SV.pop(l_module_name);
876: END IF;
877: RETURN;
878: END IF;
879:
890: --
891: -- Debug Statements
892: --
893: IF l_debug_on THEN
894: WSH_DEBUG_SV.pop(l_module_name);
895: END IF;
896: --
897: RETURN;
898: ELSE
914: --
915: -- Debug Statements
916: --
917: IF l_debug_on THEN
918: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
919: END IF;
920: --
921: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(p_trip_id));
922: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
926: --
927: -- Debug Statements
928: --
929: IF l_debug_on THEN
930: WSH_DEBUG_SV.pop(l_module_name);
931: END IF;
932: --
933: EXCEPTION
934: WHEN others THEN
938: --
939: -- Debug Statements
940: --
941: IF l_debug_on THEN
942: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
943: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
944: END IF;
945: --
946: END Check_Trip_Delete;
939: -- Debug Statements
940: --
941: IF l_debug_on THEN
942: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
943: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
944: END IF;
945: --
946: END Check_Trip_Delete;
947:
998: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
999: --
1000: IF l_debug_on IS NULL
1001: THEN
1002: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1003: END IF;
1004: --
1005: IF l_debug_on THEN
1006: WSH_DEBUG_SV.push(l_module_name);
1002: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1003: END IF;
1004: --
1005: IF l_debug_on THEN
1006: WSH_DEBUG_SV.push(l_module_name);
1007: --
1008: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
1009: END IF;
1010: --
1004: --
1005: IF l_debug_on THEN
1006: WSH_DEBUG_SV.push(l_module_name);
1007: --
1008: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
1009: END IF;
1010: --
1011: OPEN trip_info;
1012: FETCH trip_info INTO l_status_code, l_planned_flag;
1019: --
1020: -- Debug Statements
1021: --
1022: IF l_debug_on THEN
1023: WSH_DEBUG_SV.pop(l_module_name);
1024: END IF;
1025: --
1026: RETURN;
1027: END IF;
1043: --
1044: -- Debug Statements
1045: --
1046: IF l_debug_on THEN
1047: WSH_DEBUG_SV.pop(l_module_name);
1048: END IF;
1049: --
1050: EXCEPTION
1051: WHEN others THEN
1055: --
1056: -- Debug Statements
1057: --
1058: IF l_debug_on THEN
1059: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1060: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1061: END IF;
1062: --
1063: END Check_Change_Carrier;
1056: -- Debug Statements
1057: --
1058: IF l_debug_on THEN
1059: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1060: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1061: END IF;
1062: --
1063: END Check_Change_Carrier;
1064:
1120: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1121: --
1122: IF l_debug_on IS NULL
1123: THEN
1124: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1125: END IF;
1126: --
1127: IF l_debug_on THEN
1128: WSH_DEBUG_SV.push(l_module_name);
1124: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1125: END IF;
1126: --
1127: IF l_debug_on THEN
1128: WSH_DEBUG_SV.push(l_module_name);
1129: --
1130: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
1131: END IF;
1132: --
1126: --
1127: IF l_debug_on THEN
1128: WSH_DEBUG_SV.push(l_module_name);
1129: --
1130: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
1131: END IF;
1132: --
1133: OPEN stop_info;
1134: -- PACK J: KVENKATE
1142: --
1143: -- Debug Statements
1144: --
1145: IF l_debug_on THEN
1146: WSH_DEBUG_SV.pop(l_module_name);
1147: END IF;
1148: --
1149: RETURN;
1150: END IF;
1158: --
1159: -- Debug Statements
1160: --
1161: IF l_debug_on THEN
1162: WSH_DEBUG_SV.pop(l_module_name);
1163: END IF;
1164: --
1165: RETURN;
1166: END IF;
1177: --
1178: -- Debug Statements
1179: --
1180: IF l_debug_on THEN
1181: WSH_DEBUG_SV.pop(l_module_name);
1182: END IF;
1183: --
1184: EXCEPTION
1185: WHEN others THEN
1189: --
1190: -- Debug Statements
1191: --
1192: IF l_debug_on THEN
1193: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1194: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1195: END IF;
1196: --
1197: END Check_Stop_Arrive;
1190: -- Debug Statements
1191: --
1192: IF l_debug_on THEN
1193: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1194: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1195: END IF;
1196: --
1197: END Check_Stop_Arrive;
1198:
1253: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1254: --
1255: IF l_debug_on IS NULL
1256: THEN
1257: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1258: END IF;
1259: --
1260: IF l_debug_on THEN
1261: WSH_DEBUG_SV.push(l_module_name);
1257: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1258: END IF;
1259: --
1260: IF l_debug_on THEN
1261: WSH_DEBUG_SV.push(l_module_name);
1262: --
1263: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
1264: END IF;
1265: --
1259: --
1260: IF l_debug_on THEN
1261: WSH_DEBUG_SV.push(l_module_name);
1262: --
1263: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
1264: END IF;
1265: --
1266: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1267:
1276: --
1277: -- Debug Statements
1278: --
1279: IF l_debug_on THEN
1280: WSH_DEBUG_SV.pop(l_module_name);
1281: END IF;
1282: --
1283: RETURN;
1284: END IF;
1298: --
1299: -- Debug Statements
1300: --
1301: IF l_debug_on THEN
1302: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1303: END IF;
1304: --
1305: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(p_stop_id, p_caller));
1306: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1308: --
1309: -- Debug Statements
1310: --
1311: IF l_debug_on THEN
1312: WSH_DEBUG_SV.pop(l_module_name);
1313: END IF;
1314: --
1315: RETURN;
1316: END IF;
1320: --
1321: -- Debug Statements
1322: --
1323: IF l_debug_on THEN
1324: WSH_DEBUG_SV.pop(l_module_name);
1325: END IF;
1326: --
1327: EXCEPTION
1328: WHEN others THEN
1332: --
1333: -- Debug Statements
1334: --
1335: IF l_debug_on THEN
1336: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1337: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1338: END IF;
1339: --
1340: END Check_Stop_Close;
1333: -- Debug Statements
1334: --
1335: IF l_debug_on THEN
1336: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1337: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1338: END IF;
1339: --
1340: END Check_Stop_Close;
1341:
1370: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1371: --
1372: IF l_debug_on IS NULL
1373: THEN
1374: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1375: END IF;
1376: --
1377: IF l_debug_on THEN
1378: WSH_DEBUG_SV.push(l_module_name);
1374: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1375: END IF;
1376: --
1377: IF l_debug_on THEN
1378: WSH_DEBUG_SV.push(l_module_name);
1379: --
1380: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
1381: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
1382: END IF;
1376: --
1377: IF l_debug_on THEN
1378: WSH_DEBUG_SV.push(l_module_name);
1379: --
1380: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
1381: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
1382: END IF;
1383: --
1384: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1377: IF l_debug_on THEN
1378: WSH_DEBUG_SV.push(l_module_name);
1379: --
1380: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
1381: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
1382: END IF;
1383: --
1384: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1385: --
1385: --
1386: -- Debug Statements
1387: --
1388: IF l_debug_on THEN
1389: WSH_DEBUG_SV.pop(l_module_name);
1390: END IF;
1391: --
1392: END Check_Assign_Trip;
1393:
1465: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1466: --
1467: IF l_debug_on IS NULL
1468: THEN
1469: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1470: END IF;
1471: --
1472: IF l_debug_on THEN
1473: WSH_DEBUG_SV.push(l_module_name);
1469: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1470: END IF;
1471: --
1472: IF l_debug_on THEN
1473: WSH_DEBUG_SV.push(l_module_name);
1474: --
1475: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
1476: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_FLAG',P_TRIP_FLAG);
1477: END IF;
1471: --
1472: IF l_debug_on THEN
1473: WSH_DEBUG_SV.push(l_module_name);
1474: --
1475: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
1476: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_FLAG',P_TRIP_FLAG);
1477: END IF;
1478: --
1479: OPEN stop_info;
1472: IF l_debug_on THEN
1473: WSH_DEBUG_SV.push(l_module_name);
1474: --
1475: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
1476: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_FLAG',P_TRIP_FLAG);
1477: END IF;
1478: --
1479: OPEN stop_info;
1480: FETCH stop_info INTO l_trip_status_code, l_planned_flag, l_stop_status_code, l_trip_id;
1487: --
1488: -- Debug Statements
1489: --
1490: IF l_debug_on THEN
1491: WSH_DEBUG_SV.pop(l_module_name);
1492: END IF;
1493: --
1494: RETURN;
1495: END IF;
1503: --
1504: -- Debug Statements
1505: --
1506: IF l_debug_on THEN
1507: WSH_DEBUG_SV.pop(l_module_name);
1508: END IF;
1509: --
1510: RETURN;
1511: END IF;
1518: --
1519: -- Debug Statements
1520: --
1521: IF l_debug_on THEN
1522: WSH_DEBUG_SV.pop(l_module_name);
1523: END IF;
1524: --
1525: RETURN;
1526: END IF;
1530: --
1531: -- Debug Statements
1532: --
1533: IF l_debug_on THEN
1534: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1535: END IF;
1536: --
1537: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(l_trip_id));
1538: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1540: --
1541: -- Debug Statements
1542: --
1543: IF l_debug_on THEN
1544: WSH_DEBUG_SV.pop(l_module_name);
1545: END IF;
1546: --
1547: RETURN;
1548: ELSIF (l_planned_flag ='F') THEN
1550: --
1551: -- Debug Statements
1552: --
1553: IF l_debug_on THEN
1554: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1555: END IF;
1556: --
1557: FND_MESSAGE.SET_TOKEN('TRIP_NAME', wsh_trips_pvt.get_name(l_trip_id));
1558: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1560: --
1561: -- Debug Statements
1562: --
1563: IF l_debug_on THEN
1564: WSH_DEBUG_SV.pop(l_module_name);
1565: END IF;
1566: --
1567: RETURN;
1568: END IF;
1586: --
1587: -- Debug Statements
1588: --
1589: IF l_debug_on THEN
1590: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1591: END IF;
1592: --
1593: FND_MESSAGE.SET_TOKEN('STOP_NAME', wsh_trip_stops_pvt.get_name(p_stop_id, p_caller));
1594: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1606: --
1607: -- Debug Statements
1608: --
1609: IF l_debug_on THEN
1610: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1611: END IF;
1612: --
1613: FND_MESSAGE.SET_TOKEN('STOP_NAME', wsh_trip_stops_pvt.get_name(p_stop_id,p_caller));
1614: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1618: --
1619: -- Debug Statements
1620: --
1621: IF l_debug_on THEN
1622: WSH_DEBUG_SV.pop(l_module_name);
1623: END IF;
1624: --
1625: EXCEPTION
1626: WHEN others THEN
1630: --
1631: -- Debug Statements
1632: --
1633: IF l_debug_on THEN
1634: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1635: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1636: END IF;
1637: --
1638: END Check_Stop_Delete;
1631: -- Debug Statements
1632: --
1633: IF l_debug_on THEN
1634: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1635: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1636: END IF;
1637: --
1638: END Check_Stop_Delete;
1639:
1691: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1692: --
1693: IF l_debug_on IS NULL
1694: THEN
1695: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1696: END IF;
1697: --
1698: IF l_debug_on THEN
1699: WSH_DEBUG_SV.push(l_module_name);
1695: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1696: END IF;
1697: --
1698: IF l_debug_on THEN
1699: WSH_DEBUG_SV.push(l_module_name);
1700: --
1701: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
1702: WSH_DEBUG_SV.log(l_module_name,'P_LIST_TYPE',P_LIST_TYPE);
1703: END IF;
1697: --
1698: IF l_debug_on THEN
1699: WSH_DEBUG_SV.push(l_module_name);
1700: --
1701: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
1702: WSH_DEBUG_SV.log(l_module_name,'P_LIST_TYPE',P_LIST_TYPE);
1703: END IF;
1704: --
1705: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1698: IF l_debug_on THEN
1699: WSH_DEBUG_SV.push(l_module_name);
1700: --
1701: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
1702: WSH_DEBUG_SV.log(l_module_name,'P_LIST_TYPE',P_LIST_TYPE);
1703: END IF;
1704: --
1705: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1706: --OTM R12, glog proj, use Global Variable
1781: END IF; --}-- end of l_planned_flag IN (Y/F)
1782:
1783: --OTM R12, glog proj
1784: IF l_debug_on THEN
1785: WSH_DEBUG_SV.logmsg(l_module_name,'l_tp_plan_name :'||l_tp_plan_name);
1786: WSH_DEBUG_SV.logmsg(l_module_name,'l_gc3_is_installed :'||l_gc3_is_installed);
1787: WSH_DEBUG_SV.logmsg(l_module_name,'l_planned_flag :'||l_planned_flag);
1788: END IF;
1789: IF l_gc3_is_installed= 'Y' AND
1782:
1783: --OTM R12, glog proj
1784: IF l_debug_on THEN
1785: WSH_DEBUG_SV.logmsg(l_module_name,'l_tp_plan_name :'||l_tp_plan_name);
1786: WSH_DEBUG_SV.logmsg(l_module_name,'l_gc3_is_installed :'||l_gc3_is_installed);
1787: WSH_DEBUG_SV.logmsg(l_module_name,'l_planned_flag :'||l_planned_flag);
1788: END IF;
1789: IF l_gc3_is_installed= 'Y' AND
1790: l_tp_plan_name IS NOT NULL THEN--{
1783: --OTM R12, glog proj
1784: IF l_debug_on THEN
1785: WSH_DEBUG_SV.logmsg(l_module_name,'l_tp_plan_name :'||l_tp_plan_name);
1786: WSH_DEBUG_SV.logmsg(l_module_name,'l_gc3_is_installed :'||l_gc3_is_installed);
1787: WSH_DEBUG_SV.logmsg(l_module_name,'l_planned_flag :'||l_planned_flag);
1788: END IF;
1789: IF l_gc3_is_installed= 'Y' AND
1790: l_tp_plan_name IS NOT NULL THEN--{
1791: IF l_planned_flag = 'N' THEN
1795: i:=i+1; x_disabled_list(i) := 'OPERATOR';
1796: i:=i+1; x_disabled_list(i) := 'VEHICLE_NUMBER';
1797: END IF;
1798: IF l_debug_on THEN
1799: WSH_DEBUG_SV.logmsg(l_module_name, 'Caller :'||p_caller);
1800: WSH_DEBUG_SV.logmsg(l_module_name, 'Disabled List element 1:'||x_disabled_list(1));
1801: WSH_DEBUG_SV.logmsg(l_module_name, 'Before enabling others:');
1802: END IF;
1803: -- As planned_flag is not null field, x_disabled_list would
1796: i:=i+1; x_disabled_list(i) := 'VEHICLE_NUMBER';
1797: END IF;
1798: IF l_debug_on THEN
1799: WSH_DEBUG_SV.logmsg(l_module_name, 'Caller :'||p_caller);
1800: WSH_DEBUG_SV.logmsg(l_module_name, 'Disabled List element 1:'||x_disabled_list(1));
1801: WSH_DEBUG_SV.logmsg(l_module_name, 'Before enabling others:');
1802: END IF;
1803: -- As planned_flag is not null field, x_disabled_list would
1804: -- have 1st element as FULL, so no need to check for <> FULL
1797: END IF;
1798: IF l_debug_on THEN
1799: WSH_DEBUG_SV.logmsg(l_module_name, 'Caller :'||p_caller);
1800: WSH_DEBUG_SV.logmsg(l_module_name, 'Disabled List element 1:'||x_disabled_list(1));
1801: WSH_DEBUG_SV.logmsg(l_module_name, 'Before enabling others:');
1802: END IF;
1803: -- As planned_flag is not null field, x_disabled_list would
1804: -- have 1st element as FULL, so no need to check for <> FULL
1805: i:=i+1; x_disabled_list(i) := 'VEHICLE_NUM_PREFIX';
1895: --
1896: -- Debug Statements
1897: --
1898: IF l_debug_on THEN
1899: WSH_DEBUG_SV.pop(l_module_name);
1900: END IF;
1901: --
1902: EXCEPTION
1903: WHEN e_all_disabled THEN --3509004:public api changes
1910: FND_MESSAGE.Set_Token('ENTITY_ID',p_trip_id);
1911: wsh_util_core.add_message(x_return_status,l_module_name);
1912: IF l_debug_on THEN
1913: -- Nothing is updateable
1914: WSH_DEBUG_SV.pop(l_module_name,'e_all_disabled');
1915: END IF;
1916:
1917:
1918: WHEN WSH_DP_NO_ENTITY THEN
1934: --
1935: -- Debug Statements
1936: --
1937: IF l_debug_on THEN
1938: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_DP_NO_ENTITY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1939: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_DP_NO_ENTITY');
1940: END IF;
1941: --
1942: WHEN WSH_INV_LIST_TYPE THEN
1935: -- Debug Statements
1936: --
1937: IF l_debug_on THEN
1938: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_DP_NO_ENTITY exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1939: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_DP_NO_ENTITY');
1940: END IF;
1941: --
1942: WHEN WSH_INV_LIST_TYPE THEN
1943: -- OTM R12, glog proj
1957: --
1958: -- Debug Statements
1959: --
1960: IF l_debug_on THEN
1961: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INV_LIST_TYPE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1962: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INV_LIST_TYPE');
1963: END IF;
1964: --
1965: WHEN OTHERS THEN
1958: -- Debug Statements
1959: --
1960: IF l_debug_on THEN
1961: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INV_LIST_TYPE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1962: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INV_LIST_TYPE');
1963: END IF;
1964: --
1965: WHEN OTHERS THEN
1966: IF get_trip_status%ISOPEN THEN
1974: --
1975: -- Debug Statements
1976: --
1977: IF l_debug_on THEN
1978: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1979: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1980: END IF;
1981: --
1982: END Get_Disabled_List ;
1975: -- Debug Statements
1976: --
1977: IF l_debug_on THEN
1978: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1979: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1980: END IF;
1981: --
1982: END Get_Disabled_List ;
1983:
2019: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2020: --
2021: IF l_debug_on IS NULL
2022: THEN
2023: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2024: END IF;
2025: --
2026: IF l_debug_on THEN
2027: WSH_DEBUG_SV.push(l_module_name);
2023: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2024: END IF;
2025: --
2026: IF l_debug_on THEN
2027: WSH_DEBUG_SV.push(l_module_name);
2028: --
2029: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
2030: WSH_DEBUG_SV.log(l_module_name,'P_STOP_SEQUENCE_NUMBER',P_STOP_SEQUENCE_NUMBER);
2031: END IF;
2025: --
2026: IF l_debug_on THEN
2027: WSH_DEBUG_SV.push(l_module_name);
2028: --
2029: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
2030: WSH_DEBUG_SV.log(l_module_name,'P_STOP_SEQUENCE_NUMBER',P_STOP_SEQUENCE_NUMBER);
2031: END IF;
2032: --
2033: IF (p_stop_id IS NOT NULL) THEN
2026: IF l_debug_on THEN
2027: WSH_DEBUG_SV.push(l_module_name);
2028: --
2029: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
2030: WSH_DEBUG_SV.log(l_module_name,'P_STOP_SEQUENCE_NUMBER',P_STOP_SEQUENCE_NUMBER);
2031: END IF;
2032: --
2033: IF (p_stop_id IS NOT NULL) THEN
2034:
2060: --
2061: -- Debug Statements
2062: --
2063: IF l_debug_on THEN
2064: WSH_DEBUG_SV.pop(l_module_name);
2065: END IF;
2066: --
2067: RETURN;
2068: ELSIF l_trip_planned = 'F' THEN
2072: --
2073: -- Debug Statements
2074: --
2075: IF l_debug_on THEN
2076: WSH_DEBUG_SV.pop(l_module_name);
2077: END IF;
2078: --
2079: RETURN;
2080: END IF;
2092: --
2093: -- Debug Statements
2094: --
2095: IF l_debug_on THEN
2096: WSH_DEBUG_SV.pop(l_module_name);
2097: END IF;
2098: --
2099: RETURN;
2100:
2105: --
2106: -- Debug Statements
2107: --
2108: IF l_debug_on THEN
2109: WSH_DEBUG_SV.pop(l_module_name);
2110: END IF;
2111: --
2112: END validate_planned_trip;
2113:
2174: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2175: --
2176: IF l_debug_on IS NULL
2177: THEN
2178: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2179: END IF;
2180: --
2181: IF l_debug_on THEN
2182: WSH_DEBUG_SV.push(l_module_name);
2178: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2179: END IF;
2180: --
2181: IF l_debug_on THEN
2182: WSH_DEBUG_SV.push(l_module_name);
2183: --
2184: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
2185: WSH_DEBUG_SV.log(l_module_name,'p_action',p_action);
2186: END IF;
2180: --
2181: IF l_debug_on THEN
2182: WSH_DEBUG_SV.push(l_module_name);
2183: --
2184: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
2185: WSH_DEBUG_SV.log(l_module_name,'p_action',p_action);
2186: END IF;
2187:
2188: -- call initialize API and get the pl/sql table
2181: IF l_debug_on THEN
2182: WSH_DEBUG_SV.push(l_module_name);
2183: --
2184: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
2185: WSH_DEBUG_SV.log(l_module_name,'p_action',p_action);
2186: END IF;
2187:
2188: -- call initialize API and get the pl/sql table
2189: Init_Trip_Actions_Tbl(
2191: x_trip_actions_tab => l_trip_actions_tab,
2192: x_return_status => x_return_status);
2193:
2194: IF l_debug_on THEN
2195: WSH_DEBUG_SV.log(l_module_name,'Init_Detail_Actions_Tbl x_return_status',x_return_status);
2196: END IF;
2197:
2198: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
2199: raise error_in_init_actions;
2208: l_caller := p_caller;
2209: --
2210: --
2211: IF l_debug_on THEN
2212: wsh_debug_sv.log(l_module_name, 'l_caller', l_caller);
2213: END IF;
2214: --
2215: --
2216: -- Actions on inbound trips are allowed only if caller
2241: END IF;
2242: --
2243: --
2244: IF l_debug_on THEN
2245: wsh_debug_sv.log(l_module_name, 'l_caller-modified', l_caller);
2246: END IF;
2247: -- J-IB-NPARIKH-}
2248: --
2249: -- section a
2264: ) THEN
2265:
2266: IF l_trip_actions_tab(l_loop_counter).message_name IS NOT NULL THEN
2267: IF l_debug_on THEN
2268: wsh_debug_sv.log(l_module_name, 'Message Name is', l_trip_actions_tab(l_loop_counter).message_name);
2269: END IF;
2270: FND_MESSAGE.SET_NAME('WSH',l_trip_actions_tab(l_loop_counter).message_name);
2271: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error);
2272: END IF;
2295: x_error_ids => l_error_ids,
2296: x_valid_index_tab => l_valid_index_tab);
2297:
2298: IF l_debug_on THEN
2299: WSH_DEBUG_SV.log(l_module_name,'WSH_DELIVERY_VALIDATIONS.Is_Action_Enabled l_return_status',l_return_status);
2300: END IF;
2301:
2302: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS)
2303: AND (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)
2327: ELSIF p_action = 'SELECT-CARRIER' THEN
2328:
2329: IF p_trip_rec_tab(j).lane_id IS NOT NULL THEN
2330: IF l_debug_on THEN
2331: wsh_debug_sv.log(l_module_name, 'Trip has lane id : ', p_trip_rec_tab(j).lane_id);
2332: END IF;
2333: FND_MESSAGE.SET_NAME('WSH','WSH_FTE_SEL_TRIP_LANE');
2334: FND_MESSAGE.SET_TOKEN('TRIPID',p_trip_rec_tab(j).trip_id);
2335: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error);
2341:
2342: --IF l_move_id IS NOT NULL THEN
2343: IF l_move_id <> -1 THEN
2344: IF l_debug_on THEN
2345: wsh_debug_sv.log(l_module_name, 'Trip has continuous move id id : ', l_move_id);
2346: END IF;
2347: FND_MESSAGE.SET_NAME('WSH','WSH_FTE_SEL_TRIP_MOVE');
2348: FND_MESSAGE.SET_TOKEN('TRIPID',p_trip_rec_tab(j).trip_id);
2349: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error);
2399: --
2400: END IF;
2401:
2402: IF l_debug_on THEN
2403: WSH_DEBUG_SV.pop(l_module_name);
2404: END IF;
2405:
2406: EXCEPTION
2407: WHEN error_in_init_actions THEN
2405:
2406: EXCEPTION
2407: WHEN error_in_init_actions THEN
2408: IF l_debug_on THEN
2409: WSH_DEBUG_SV.logmsg(l_module_name,'error_in_init_actions exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2410: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:error_in_init_actions');
2411: END IF;
2412:
2413: WHEN OTHERS THEN
2406: EXCEPTION
2407: WHEN error_in_init_actions THEN
2408: IF l_debug_on THEN
2409: WSH_DEBUG_SV.logmsg(l_module_name,'error_in_init_actions exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2410: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:error_in_init_actions');
2411: END IF;
2412:
2413: WHEN OTHERS THEN
2414: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.IS_ACTION_ENABLED');
2413: WHEN OTHERS THEN
2414: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.IS_ACTION_ENABLED');
2415: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2416: IF l_debug_on THEN
2417: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2418: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2419: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2420: END IF;
2421: END Is_Action_Enabled;
2414: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.IS_ACTION_ENABLED');
2415: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2416: IF l_debug_on THEN
2417: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2418: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2419: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2420: END IF;
2421: END Is_Action_Enabled;
2422:
2415: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2416: IF l_debug_on THEN
2417: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2418: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2419: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2420: END IF;
2421: END Is_Action_Enabled;
2422:
2423:
2447: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2448: --
2449: IF l_debug_on IS NULL
2450: THEN
2451: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2452: END IF;
2453: --
2454: IF l_debug_on THEN
2455: WSH_DEBUG_SV.push(l_module_name);
2451: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2452: END IF;
2453: --
2454: IF l_debug_on THEN
2455: WSH_DEBUG_SV.push(l_module_name);
2456: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
2457: WSH_DEBUG_SV.log(l_module_name,'p_arr_after_trip_id',p_arr_after_trip_id);
2458: WSH_DEBUG_SV.log(l_module_name,'p_arr_after_trip_name',p_arr_after_trip_name);
2459: END IF;
2452: END IF;
2453: --
2454: IF l_debug_on THEN
2455: WSH_DEBUG_SV.push(l_module_name);
2456: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
2457: WSH_DEBUG_SV.log(l_module_name,'p_arr_after_trip_id',p_arr_after_trip_id);
2458: WSH_DEBUG_SV.log(l_module_name,'p_arr_after_trip_name',p_arr_after_trip_name);
2459: END IF;
2460:
2453: --
2454: IF l_debug_on THEN
2455: WSH_DEBUG_SV.push(l_module_name);
2456: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
2457: WSH_DEBUG_SV.log(l_module_name,'p_arr_after_trip_id',p_arr_after_trip_id);
2458: WSH_DEBUG_SV.log(l_module_name,'p_arr_after_trip_name',p_arr_after_trip_name);
2459: END IF;
2460:
2461: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2454: IF l_debug_on THEN
2455: WSH_DEBUG_SV.push(l_module_name);
2456: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
2457: WSH_DEBUG_SV.log(l_module_name,'p_arr_after_trip_id',p_arr_after_trip_id);
2458: WSH_DEBUG_SV.log(l_module_name,'p_arr_after_trip_name',p_arr_after_trip_name);
2459: END IF;
2460:
2461: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2462:
2466: )
2467: ) THEN
2468: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2469: IF l_debug_on THEN
2470: WSH_DEBUG_SV.pop(l_module_name);
2471: END IF;
2472: RETURN;
2473: END IF;
2474:
2498: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
2499: END IF;
2500:
2501: IF l_debug_on THEN
2502: WSH_DEBUG_SV.pop(l_module_name);
2503: END IF;
2504:
2505: EXCEPTION
2506: WHEN OTHERS THEN
2506: WHEN OTHERS THEN
2507: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.VALIDATE_ARRIVE_AFTER_TRIP');
2508: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2509: IF l_debug_on THEN
2510: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2511: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2512: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2513: END IF;
2514: END Validate_Arrive_after_trip;
2507: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.VALIDATE_ARRIVE_AFTER_TRIP');
2508: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2509: IF l_debug_on THEN
2510: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2511: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2512: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2513: END IF;
2514: END Validate_Arrive_after_trip;
2515:
2508: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2509: IF l_debug_on THEN
2510: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2511: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2512: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2513: END IF;
2514: END Validate_Arrive_after_trip;
2515:
2516:
2537: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2538: --
2539: IF l_debug_on IS NULL
2540: THEN
2541: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2542: END IF;
2543: --
2544:
2545:
2558: l_mode_of_transport :=p_db_trip_info.mode_of_transport;
2559: l_lane_id :=p_db_trip_info.lane_id;
2560:
2561: IF l_debug_on THEN
2562: WSH_DEBUG_SV.push(l_module_name);
2563: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',p_trip_info.trip_id);
2564: WSH_DEBUG_SV.log(l_module_name,'p_consolidation_allowed',p_trip_info.consolidation_allowed);
2565: WSH_DEBUG_SV.log(l_module_name,'p_veh_item_id',p_trip_info.vehicle_item_id);
2566: WSH_DEBUG_SV.log(l_module_name,'p_veh_org_id',p_trip_info.vehicle_organization_id);
2559: l_lane_id :=p_db_trip_info.lane_id;
2560:
2561: IF l_debug_on THEN
2562: WSH_DEBUG_SV.push(l_module_name);
2563: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',p_trip_info.trip_id);
2564: WSH_DEBUG_SV.log(l_module_name,'p_consolidation_allowed',p_trip_info.consolidation_allowed);
2565: WSH_DEBUG_SV.log(l_module_name,'p_veh_item_id',p_trip_info.vehicle_item_id);
2566: WSH_DEBUG_SV.log(l_module_name,'p_veh_org_id',p_trip_info.vehicle_organization_id);
2567: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_code',p_trip_info.ship_method_code);
2560:
2561: IF l_debug_on THEN
2562: WSH_DEBUG_SV.push(l_module_name);
2563: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',p_trip_info.trip_id);
2564: WSH_DEBUG_SV.log(l_module_name,'p_consolidation_allowed',p_trip_info.consolidation_allowed);
2565: WSH_DEBUG_SV.log(l_module_name,'p_veh_item_id',p_trip_info.vehicle_item_id);
2566: WSH_DEBUG_SV.log(l_module_name,'p_veh_org_id',p_trip_info.vehicle_organization_id);
2567: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_code',p_trip_info.ship_method_code);
2568: WSH_DEBUG_SV.log(l_module_name,'p_carrier_id',p_trip_info.carrier_id);
2561: IF l_debug_on THEN
2562: WSH_DEBUG_SV.push(l_module_name);
2563: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',p_trip_info.trip_id);
2564: WSH_DEBUG_SV.log(l_module_name,'p_consolidation_allowed',p_trip_info.consolidation_allowed);
2565: WSH_DEBUG_SV.log(l_module_name,'p_veh_item_id',p_trip_info.vehicle_item_id);
2566: WSH_DEBUG_SV.log(l_module_name,'p_veh_org_id',p_trip_info.vehicle_organization_id);
2567: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_code',p_trip_info.ship_method_code);
2568: WSH_DEBUG_SV.log(l_module_name,'p_carrier_id',p_trip_info.carrier_id);
2569: WSH_DEBUG_SV.log(l_module_name,'p_service_level',p_trip_info.service_level);
2562: WSH_DEBUG_SV.push(l_module_name);
2563: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',p_trip_info.trip_id);
2564: WSH_DEBUG_SV.log(l_module_name,'p_consolidation_allowed',p_trip_info.consolidation_allowed);
2565: WSH_DEBUG_SV.log(l_module_name,'p_veh_item_id',p_trip_info.vehicle_item_id);
2566: WSH_DEBUG_SV.log(l_module_name,'p_veh_org_id',p_trip_info.vehicle_organization_id);
2567: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_code',p_trip_info.ship_method_code);
2568: WSH_DEBUG_SV.log(l_module_name,'p_carrier_id',p_trip_info.carrier_id);
2569: WSH_DEBUG_SV.log(l_module_name,'p_service_level',p_trip_info.service_level);
2570: WSH_DEBUG_SV.log(l_module_name,'p_mode_of_transport',p_trip_info.mode_of_transport);
2563: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',p_trip_info.trip_id);
2564: WSH_DEBUG_SV.log(l_module_name,'p_consolidation_allowed',p_trip_info.consolidation_allowed);
2565: WSH_DEBUG_SV.log(l_module_name,'p_veh_item_id',p_trip_info.vehicle_item_id);
2566: WSH_DEBUG_SV.log(l_module_name,'p_veh_org_id',p_trip_info.vehicle_organization_id);
2567: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_code',p_trip_info.ship_method_code);
2568: WSH_DEBUG_SV.log(l_module_name,'p_carrier_id',p_trip_info.carrier_id);
2569: WSH_DEBUG_SV.log(l_module_name,'p_service_level',p_trip_info.service_level);
2570: WSH_DEBUG_SV.log(l_module_name,'p_mode_of_transport',p_trip_info.mode_of_transport);
2571: WSH_DEBUG_SV.log(l_module_name,'p_lane_id',p_trip_info.lane_id);
2564: WSH_DEBUG_SV.log(l_module_name,'p_consolidation_allowed',p_trip_info.consolidation_allowed);
2565: WSH_DEBUG_SV.log(l_module_name,'p_veh_item_id',p_trip_info.vehicle_item_id);
2566: WSH_DEBUG_SV.log(l_module_name,'p_veh_org_id',p_trip_info.vehicle_organization_id);
2567: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_code',p_trip_info.ship_method_code);
2568: WSH_DEBUG_SV.log(l_module_name,'p_carrier_id',p_trip_info.carrier_id);
2569: WSH_DEBUG_SV.log(l_module_name,'p_service_level',p_trip_info.service_level);
2570: WSH_DEBUG_SV.log(l_module_name,'p_mode_of_transport',p_trip_info.mode_of_transport);
2571: WSH_DEBUG_SV.log(l_module_name,'p_lane_id',p_trip_info.lane_id);
2572:
2565: WSH_DEBUG_SV.log(l_module_name,'p_veh_item_id',p_trip_info.vehicle_item_id);
2566: WSH_DEBUG_SV.log(l_module_name,'p_veh_org_id',p_trip_info.vehicle_organization_id);
2567: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_code',p_trip_info.ship_method_code);
2568: WSH_DEBUG_SV.log(l_module_name,'p_carrier_id',p_trip_info.carrier_id);
2569: WSH_DEBUG_SV.log(l_module_name,'p_service_level',p_trip_info.service_level);
2570: WSH_DEBUG_SV.log(l_module_name,'p_mode_of_transport',p_trip_info.mode_of_transport);
2571: WSH_DEBUG_SV.log(l_module_name,'p_lane_id',p_trip_info.lane_id);
2572:
2573: WSH_DEBUG_SV.log(l_module_name,'l_consolidation_allowed',l_consolidation_allowed);
2566: WSH_DEBUG_SV.log(l_module_name,'p_veh_org_id',p_trip_info.vehicle_organization_id);
2567: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_code',p_trip_info.ship_method_code);
2568: WSH_DEBUG_SV.log(l_module_name,'p_carrier_id',p_trip_info.carrier_id);
2569: WSH_DEBUG_SV.log(l_module_name,'p_service_level',p_trip_info.service_level);
2570: WSH_DEBUG_SV.log(l_module_name,'p_mode_of_transport',p_trip_info.mode_of_transport);
2571: WSH_DEBUG_SV.log(l_module_name,'p_lane_id',p_trip_info.lane_id);
2572:
2573: WSH_DEBUG_SV.log(l_module_name,'l_consolidation_allowed',l_consolidation_allowed);
2574: WSH_DEBUG_SV.log(l_module_name,'l_veh_item_id',l_vehicle_item_id);
2567: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_code',p_trip_info.ship_method_code);
2568: WSH_DEBUG_SV.log(l_module_name,'p_carrier_id',p_trip_info.carrier_id);
2569: WSH_DEBUG_SV.log(l_module_name,'p_service_level',p_trip_info.service_level);
2570: WSH_DEBUG_SV.log(l_module_name,'p_mode_of_transport',p_trip_info.mode_of_transport);
2571: WSH_DEBUG_SV.log(l_module_name,'p_lane_id',p_trip_info.lane_id);
2572:
2573: WSH_DEBUG_SV.log(l_module_name,'l_consolidation_allowed',l_consolidation_allowed);
2574: WSH_DEBUG_SV.log(l_module_name,'l_veh_item_id',l_vehicle_item_id);
2575: WSH_DEBUG_SV.log(l_module_name,'l_veh_org_id',l_vehicle_organization_id);
2569: WSH_DEBUG_SV.log(l_module_name,'p_service_level',p_trip_info.service_level);
2570: WSH_DEBUG_SV.log(l_module_name,'p_mode_of_transport',p_trip_info.mode_of_transport);
2571: WSH_DEBUG_SV.log(l_module_name,'p_lane_id',p_trip_info.lane_id);
2572:
2573: WSH_DEBUG_SV.log(l_module_name,'l_consolidation_allowed',l_consolidation_allowed);
2574: WSH_DEBUG_SV.log(l_module_name,'l_veh_item_id',l_vehicle_item_id);
2575: WSH_DEBUG_SV.log(l_module_name,'l_veh_org_id',l_vehicle_organization_id);
2576: WSH_DEBUG_SV.log(l_module_name,'l_ship_method_code',l_ship_method_code);
2577: WSH_DEBUG_SV.log(l_module_name,'l_carrier_id',l_carrier_id);
2570: WSH_DEBUG_SV.log(l_module_name,'p_mode_of_transport',p_trip_info.mode_of_transport);
2571: WSH_DEBUG_SV.log(l_module_name,'p_lane_id',p_trip_info.lane_id);
2572:
2573: WSH_DEBUG_SV.log(l_module_name,'l_consolidation_allowed',l_consolidation_allowed);
2574: WSH_DEBUG_SV.log(l_module_name,'l_veh_item_id',l_vehicle_item_id);
2575: WSH_DEBUG_SV.log(l_module_name,'l_veh_org_id',l_vehicle_organization_id);
2576: WSH_DEBUG_SV.log(l_module_name,'l_ship_method_code',l_ship_method_code);
2577: WSH_DEBUG_SV.log(l_module_name,'l_carrier_id',l_carrier_id);
2578: WSH_DEBUG_SV.log(l_module_name,'l_service_level',l_service_level);
2571: WSH_DEBUG_SV.log(l_module_name,'p_lane_id',p_trip_info.lane_id);
2572:
2573: WSH_DEBUG_SV.log(l_module_name,'l_consolidation_allowed',l_consolidation_allowed);
2574: WSH_DEBUG_SV.log(l_module_name,'l_veh_item_id',l_vehicle_item_id);
2575: WSH_DEBUG_SV.log(l_module_name,'l_veh_org_id',l_vehicle_organization_id);
2576: WSH_DEBUG_SV.log(l_module_name,'l_ship_method_code',l_ship_method_code);
2577: WSH_DEBUG_SV.log(l_module_name,'l_carrier_id',l_carrier_id);
2578: WSH_DEBUG_SV.log(l_module_name,'l_service_level',l_service_level);
2579: WSH_DEBUG_SV.log(l_module_name,'l_mode_of_transport',l_mode_of_transport);
2572:
2573: WSH_DEBUG_SV.log(l_module_name,'l_consolidation_allowed',l_consolidation_allowed);
2574: WSH_DEBUG_SV.log(l_module_name,'l_veh_item_id',l_vehicle_item_id);
2575: WSH_DEBUG_SV.log(l_module_name,'l_veh_org_id',l_vehicle_organization_id);
2576: WSH_DEBUG_SV.log(l_module_name,'l_ship_method_code',l_ship_method_code);
2577: WSH_DEBUG_SV.log(l_module_name,'l_carrier_id',l_carrier_id);
2578: WSH_DEBUG_SV.log(l_module_name,'l_service_level',l_service_level);
2579: WSH_DEBUG_SV.log(l_module_name,'l_mode_of_transport',l_mode_of_transport);
2580: WSH_DEBUG_SV.log(l_module_name,'l_lane_id',l_lane_id);
2573: WSH_DEBUG_SV.log(l_module_name,'l_consolidation_allowed',l_consolidation_allowed);
2574: WSH_DEBUG_SV.log(l_module_name,'l_veh_item_id',l_vehicle_item_id);
2575: WSH_DEBUG_SV.log(l_module_name,'l_veh_org_id',l_vehicle_organization_id);
2576: WSH_DEBUG_SV.log(l_module_name,'l_ship_method_code',l_ship_method_code);
2577: WSH_DEBUG_SV.log(l_module_name,'l_carrier_id',l_carrier_id);
2578: WSH_DEBUG_SV.log(l_module_name,'l_service_level',l_service_level);
2579: WSH_DEBUG_SV.log(l_module_name,'l_mode_of_transport',l_mode_of_transport);
2580: WSH_DEBUG_SV.log(l_module_name,'l_lane_id',l_lane_id);
2581: END IF;
2574: WSH_DEBUG_SV.log(l_module_name,'l_veh_item_id',l_vehicle_item_id);
2575: WSH_DEBUG_SV.log(l_module_name,'l_veh_org_id',l_vehicle_organization_id);
2576: WSH_DEBUG_SV.log(l_module_name,'l_ship_method_code',l_ship_method_code);
2577: WSH_DEBUG_SV.log(l_module_name,'l_carrier_id',l_carrier_id);
2578: WSH_DEBUG_SV.log(l_module_name,'l_service_level',l_service_level);
2579: WSH_DEBUG_SV.log(l_module_name,'l_mode_of_transport',l_mode_of_transport);
2580: WSH_DEBUG_SV.log(l_module_name,'l_lane_id',l_lane_id);
2581: END IF;
2582:
2575: WSH_DEBUG_SV.log(l_module_name,'l_veh_org_id',l_vehicle_organization_id);
2576: WSH_DEBUG_SV.log(l_module_name,'l_ship_method_code',l_ship_method_code);
2577: WSH_DEBUG_SV.log(l_module_name,'l_carrier_id',l_carrier_id);
2578: WSH_DEBUG_SV.log(l_module_name,'l_service_level',l_service_level);
2579: WSH_DEBUG_SV.log(l_module_name,'l_mode_of_transport',l_mode_of_transport);
2580: WSH_DEBUG_SV.log(l_module_name,'l_lane_id',l_lane_id);
2581: END IF;
2582:
2583:
2576: WSH_DEBUG_SV.log(l_module_name,'l_ship_method_code',l_ship_method_code);
2577: WSH_DEBUG_SV.log(l_module_name,'l_carrier_id',l_carrier_id);
2578: WSH_DEBUG_SV.log(l_module_name,'l_service_level',l_service_level);
2579: WSH_DEBUG_SV.log(l_module_name,'l_mode_of_transport',l_mode_of_transport);
2580: WSH_DEBUG_SV.log(l_module_name,'l_lane_id',l_lane_id);
2581: END IF;
2582:
2583:
2584: --if lane_id, carrier_id, ship_method_code, service_level, mode_of_transport are changed
2607:
2608: END IF;
2609:
2610: IF l_debug_on THEN
2611: WSH_DEBUG_SV.pop(l_module_name);
2612: END IF;
2613:
2614: EXCEPTION
2615: WHEN OTHERS THEN
2615: WHEN OTHERS THEN
2616: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.VALIDATE_CONSOL_ALLOWED');
2617: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2618: IF l_debug_on THEN
2619: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2620: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2621: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2622: END IF;
2623: END Validate_Consol_Allowed;
2616: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.VALIDATE_CONSOL_ALLOWED');
2617: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2618: IF l_debug_on THEN
2619: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2620: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2621: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2622: END IF;
2623: END Validate_Consol_Allowed;
2624:
2617: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2618: IF l_debug_on THEN
2619: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2620: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2621: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2622: END IF;
2623: END Validate_Consol_Allowed;
2624:
2625:
3486: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3487: --
3488: IF l_debug_on IS NULL
3489: THEN
3490: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3491: END IF;
3492: --
3493: IF l_debug_on THEN
3494: --
3491: END IF;
3492: --
3493: IF l_debug_on THEN
3494: --
3495: WSH_DEBUG_SV.push(l_module_name);
3496: WSH_DEBUG_SV.log(l_module_name,'trip_id',p_trip_rec.trip_id);
3497: WSH_DEBUG_SV.log(l_module_name,'Action', p_in_rec.action_code);
3498: WSH_DEBUG_SV.log(l_module_name,'Caller', p_in_rec.caller);
3499: --
3492: --
3493: IF l_debug_on THEN
3494: --
3495: WSH_DEBUG_SV.push(l_module_name);
3496: WSH_DEBUG_SV.log(l_module_name,'trip_id',p_trip_rec.trip_id);
3497: WSH_DEBUG_SV.log(l_module_name,'Action', p_in_rec.action_code);
3498: WSH_DEBUG_SV.log(l_module_name,'Caller', p_in_rec.caller);
3499: --
3500: END IF;
3493: IF l_debug_on THEN
3494: --
3495: WSH_DEBUG_SV.push(l_module_name);
3496: WSH_DEBUG_SV.log(l_module_name,'trip_id',p_trip_rec.trip_id);
3497: WSH_DEBUG_SV.log(l_module_name,'Action', p_in_rec.action_code);
3498: WSH_DEBUG_SV.log(l_module_name,'Caller', p_in_rec.caller);
3499: --
3500: END IF;
3501: --
3494: --
3495: WSH_DEBUG_SV.push(l_module_name);
3496: WSH_DEBUG_SV.log(l_module_name,'trip_id',p_trip_rec.trip_id);
3497: WSH_DEBUG_SV.log(l_module_name,'Action', p_in_rec.action_code);
3498: WSH_DEBUG_SV.log(l_module_name,'Caller', p_in_rec.caller);
3499: --
3500: END IF;
3501: --
3502: x_return_status := FND_API.G_RET_STS_SUCCESS;
3503: --
3504: IF p_in_rec.action_code = 'CREATE' THEN
3505: --
3506: IF l_debug_on THEN
3507: WSH_DEBUG_SV.log(l_module_name,'calling eliminate_displayonly_fields');
3508: END IF;
3509: --
3510: -- nothing else need to be disabled
3511: --
3513: --
3514: --3509004:public api changes
3515: /*
3516: IF l_debug_on THEN
3517: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
3518: WSH_DEBUG_SV.pop(l_module_name);
3519: END IF;
3520: -- RETURN;
3521: --
3514: --3509004:public api changes
3515: /*
3516: IF l_debug_on THEN
3517: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
3518: WSH_DEBUG_SV.pop(l_module_name);
3519: END IF;
3520: -- RETURN;
3521: --
3522: */
3539: x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
3540: THEN
3541: --
3542: IF l_debug_on THEN
3543: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
3544: WSH_DEBUG_SV.pop(l_module_name);
3545: END IF;
3546: RETURN;
3547: --
3540: THEN
3541: --
3542: IF l_debug_on THEN
3543: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
3544: WSH_DEBUG_SV.pop(l_module_name);
3545: END IF;
3546: RETURN;
3547: --
3548: END IF;
3619:
3620: --
3621: --
3622: IF l_debug_on THEN
3623: WSH_DEBUG_SV.log(l_module_name,'list.COUNT',l_disabled_list.COUNT);
3624: END IF;
3625: --
3626: IF l_disabled_list.COUNT = 0 THEN
3627: --
3625: --
3626: IF l_disabled_list.COUNT = 0 THEN
3627: --
3628: IF l_debug_on THEN
3629: WSH_DEBUG_SV.log(l_module_name,'calling eliminate_displayonly_fields');
3630: END IF;
3631: --
3632: -- nothing else need to be disabled
3633: --
3639: --
3640: IF l_debug_on THEN
3641: FOR i in 1..l_disabled_list.COUNT
3642: LOOP
3643: WSH_DEBUG_SV.log(l_module_name,'list values',l_disabled_list(i));
3644: END LOOP;
3645: WSH_DEBUG_SV.log(l_module_name,'calling enable_from_list');
3646: END IF;
3647: --enable the columns matching the l_disabled_list
3641: FOR i in 1..l_disabled_list.COUNT
3642: LOOP
3643: WSH_DEBUG_SV.log(l_module_name,'list values',l_disabled_list(i));
3644: END LOOP;
3645: WSH_DEBUG_SV.log(l_module_name,'calling enable_from_list');
3646: END IF;
3647: --enable the columns matching the l_disabled_list
3648: enable_from_list(l_disabled_list,
3649: p_trip_rec,
3662: --
3663: IF l_debug_on THEN
3664: FOR i in 1..l_disabled_list.COUNT
3665: LOOP
3666: WSH_DEBUG_SV.log(l_module_name,'list values',l_disabled_list(i));
3667: END LOOP;
3668: WSH_DEBUG_SV.log(l_module_name,'First element is not FULL');
3669: WSH_DEBUG_SV.log(l_module_name,'calling eliminate_displayonly_fields');
3670: END IF;
3664: FOR i in 1..l_disabled_list.COUNT
3665: LOOP
3666: WSH_DEBUG_SV.log(l_module_name,'list values',l_disabled_list(i));
3667: END LOOP;
3668: WSH_DEBUG_SV.log(l_module_name,'First element is not FULL');
3669: WSH_DEBUG_SV.log(l_module_name,'calling eliminate_displayonly_fields');
3670: END IF;
3671: --
3672: eliminate_displayonly_fields (p_trip_rec,p_in_rec,x_trip_rec);
3665: LOOP
3666: WSH_DEBUG_SV.log(l_module_name,'list values',l_disabled_list(i));
3667: END LOOP;
3668: WSH_DEBUG_SV.log(l_module_name,'First element is not FULL');
3669: WSH_DEBUG_SV.log(l_module_name,'calling eliminate_displayonly_fields');
3670: END IF;
3671: --
3672: eliminate_displayonly_fields (p_trip_rec,p_in_rec,x_trip_rec);
3673: --
3671: --
3672: eliminate_displayonly_fields (p_trip_rec,p_in_rec,x_trip_rec);
3673: --
3674: IF l_debug_on THEN
3675: WSH_DEBUG_SV.log(l_module_name,'calling disable_from_list');
3676: END IF;
3677: -- The fileds in the list are getting disabled
3678: disable_from_list(l_disabled_list,
3679: l_db_col_rec,
3704: --
3705: END IF;
3706: --
3707: IF l_debug_on THEN
3708: WSH_DEBUG_SV.pop(l_module_name);
3709: END IF;
3710: --
3711: EXCEPTION
3712: WHEN e_all_disabled THEN
3715: FND_MESSAGE.Set_Token('ENTITY_ID',p_trip_rec.trip_id);
3716: wsh_util_core.add_message(x_return_status,l_module_name);
3717: IF l_debug_on THEN
3718: -- Nothing is updateable
3719: WSH_DEBUG_SV.pop(l_module_name,'e_all_disabled');
3720: END IF;
3721: WHEN e_dp_no_entity THEN
3722: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3723: -- the message for this is set in original get_disabled_list
3721: WHEN e_dp_no_entity THEN
3722: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3723: -- the message for this is set in original get_disabled_list
3724: IF l_debug_on THEN
3725: WSH_DEBUG_SV.pop(l_module_name,'e_dp_no_entity');
3726: END IF;
3727: WHEN e_bad_field THEN
3728: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3729: FND_MESSAGE.SET_NAME('WSH','WSH_BAD_FIELD_NAME');
3729: FND_MESSAGE.SET_NAME('WSH','WSH_BAD_FIELD_NAME');
3730: FND_MESSAGE.Set_Token('FIELD_NAME',l_field_name);
3731: wsh_util_core.add_message(x_return_status,l_module_name);
3732: IF l_debug_on THEN
3733: WSH_DEBUG_SV.log(l_module_name,'Bad field name passed to the list:'
3734: ,l_field_name);
3735: WSH_DEBUG_SV.pop(l_module_name,'e_bad_field');
3736: END IF;
3737:
3731: wsh_util_core.add_message(x_return_status,l_module_name);
3732: IF l_debug_on THEN
3733: WSH_DEBUG_SV.log(l_module_name,'Bad field name passed to the list:'
3734: ,l_field_name);
3735: WSH_DEBUG_SV.pop(l_module_name,'e_bad_field');
3736: END IF;
3737:
3738: WHEN OTHERS THEN
3739: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.get_disabled_list'
3739: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.get_disabled_list'
3740: ,l_module_name);
3741: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3742: IF l_debug_on THEN
3743: WSH_DEBUG_SV.log(l_module_name,'Error:',SUBSTR(SQLERRM,1,200));
3744: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3745: END IF;
3746: END Get_Disabled_List;
3747:
3740: ,l_module_name);
3741: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3742: IF l_debug_on THEN
3743: WSH_DEBUG_SV.log(l_module_name,'Error:',SUBSTR(SQLERRM,1,200));
3744: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3745: END IF;
3746: END Get_Disabled_List;
3747:
3748:
3766: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3767: --
3768: IF l_debug_on IS NULL
3769: THEN
3770: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3771: END IF;
3772:
3773: --OTM R12, glog proj, use Global Variable
3774: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
3924: -- bug 5837425
3925:
3926: --
3927: IF l_debug_on THEN
3928: WSH_DEBUG_SV.push(l_module_name);
3929: --
3930: WSH_DEBUG_SV.log(l_module_name,'p_action', p_action);
3931: END IF;
3932: --
3926: --
3927: IF l_debug_on THEN
3928: WSH_DEBUG_SV.push(l_module_name);
3929: --
3930: WSH_DEBUG_SV.log(l_module_name,'p_action', p_action);
3931: END IF;
3932: --
3933: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3934:
3932: --
3933: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3934:
3935: IF l_debug_on THEN
3936: WSH_DEBUG_SV.pop(l_module_name);
3937: END IF;
3938:
3939: EXCEPTION
3940: -- OTM R12, glog proj
3942: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_TRIP_VALIDATIONS.init_trip_actions_tbl'
3943: ,l_module_name);
3944: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3945: IF l_debug_on THEN
3946: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3947: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3948: END IF;
3949:
3950:
3943: ,l_module_name);
3944: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3945: IF l_debug_on THEN
3946: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3947: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3948: END IF;
3949:
3950:
3951: END Init_Trip_Actions_Tbl;
4054: --
4055: l_debug_on := wsh_debug_interface.g_debug;
4056: --
4057: IF l_debug_on IS NULL THEN
4058: l_debug_on := wsh_debug_sv.is_debug_enabled;
4059: END IF;
4060: --
4061: IF l_debug_on THEN
4062: wsh_debug_sv.push(l_module_name);
4058: l_debug_on := wsh_debug_sv.is_debug_enabled;
4059: END IF;
4060: --
4061: IF l_debug_on THEN
4062: wsh_debug_sv.push(l_module_name);
4063: --
4064: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.trip_id ', p_in_rec.trip_id );
4065: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.name ', p_in_rec.name );
4066: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.put_messages', p_in_rec.put_messages);
4060: --
4061: IF l_debug_on THEN
4062: wsh_debug_sv.push(l_module_name);
4063: --
4064: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.trip_id ', p_in_rec.trip_id );
4065: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.name ', p_in_rec.name );
4066: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.put_messages', p_in_rec.put_messages);
4067: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.manual_flag ', p_in_rec.manual_flag );
4068: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.caller ', p_in_rec.caller );
4061: IF l_debug_on THEN
4062: wsh_debug_sv.push(l_module_name);
4063: --
4064: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.trip_id ', p_in_rec.trip_id );
4065: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.name ', p_in_rec.name );
4066: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.put_messages', p_in_rec.put_messages);
4067: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.manual_flag ', p_in_rec.manual_flag );
4068: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.caller ', p_in_rec.caller );
4069: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.actual_date ', p_in_rec.actual_date );
4062: wsh_debug_sv.push(l_module_name);
4063: --
4064: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.trip_id ', p_in_rec.trip_id );
4065: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.name ', p_in_rec.name );
4066: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.put_messages', p_in_rec.put_messages);
4067: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.manual_flag ', p_in_rec.manual_flag );
4068: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.caller ', p_in_rec.caller );
4069: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.actual_date ', p_in_rec.actual_date );
4070: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.stop_id ', p_in_rec.stop_id );
4063: --
4064: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.trip_id ', p_in_rec.trip_id );
4065: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.name ', p_in_rec.name );
4066: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.put_messages', p_in_rec.put_messages);
4067: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.manual_flag ', p_in_rec.manual_flag );
4068: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.caller ', p_in_rec.caller );
4069: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.actual_date ', p_in_rec.actual_date );
4070: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.stop_id ', p_in_rec.stop_id );
4071: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.linked_stop_id ', p_in_rec.linked_stop_id );
4064: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.trip_id ', p_in_rec.trip_id );
4065: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.name ', p_in_rec.name );
4066: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.put_messages', p_in_rec.put_messages);
4067: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.manual_flag ', p_in_rec.manual_flag );
4068: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.caller ', p_in_rec.caller );
4069: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.actual_date ', p_in_rec.actual_date );
4070: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.stop_id ', p_in_rec.stop_id );
4071: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.linked_stop_id ', p_in_rec.linked_stop_id );
4072: END IF;
4065: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.name ', p_in_rec.name );
4066: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.put_messages', p_in_rec.put_messages);
4067: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.manual_flag ', p_in_rec.manual_flag );
4068: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.caller ', p_in_rec.caller );
4069: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.actual_date ', p_in_rec.actual_date );
4070: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.stop_id ', p_in_rec.stop_id );
4071: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.linked_stop_id ', p_in_rec.linked_stop_id );
4072: END IF;
4073: --
4066: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.put_messages', p_in_rec.put_messages);
4067: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.manual_flag ', p_in_rec.manual_flag );
4068: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.caller ', p_in_rec.caller );
4069: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.actual_date ', p_in_rec.actual_date );
4070: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.stop_id ', p_in_rec.stop_id );
4071: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.linked_stop_id ', p_in_rec.linked_stop_id );
4072: END IF;
4073: --
4074: --
4067: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.manual_flag ', p_in_rec.manual_flag );
4068: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.caller ', p_in_rec.caller );
4069: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.actual_date ', p_in_rec.actual_date );
4070: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.stop_id ', p_in_rec.stop_id );
4071: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.linked_stop_id ', p_in_rec.linked_stop_id );
4072: END IF;
4073: --
4074: --
4075: l_num_warnings := 0;
4094: --
4095:
4096: -- Check for Exceptions against the Trip
4097: IF l_debug_on THEN
4098: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.Check_Exceptions',WSH_DEBUG_SV.C_PROC_LEVEL);
4099: END IF;
4100: l_exceptions_tab.delete;
4101: l_exp_logged := FALSE;
4102: l_exp_warning := FALSE;
4210: --
4211: -- Debug Statements
4212: --
4213: IF l_debug_on THEN
4214: WSH_DEBUG_SV.pop(l_module_name);
4215: END IF;
4216: --
4217: --}
4218: EXCEPTION
4227: --
4228: --
4229: --
4230: IF l_debug_on THEN
4231: WSH_DEBUG_SV.logmsg(l_module_name,'e_not_allowed exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4232: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:e_not_allowed');
4233: END IF;
4234: --
4235: WHEN wsh_util_core.e_not_allowed_warning THEN
4228: --
4229: --
4230: IF l_debug_on THEN
4231: WSH_DEBUG_SV.logmsg(l_module_name,'e_not_allowed exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4232: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:e_not_allowed');
4233: END IF;
4234: --
4235: WHEN wsh_util_core.e_not_allowed_warning THEN
4236: IF l_num_warnings > 0
4243: x_allowed := 'NW';
4244: --
4245: --
4246: IF l_debug_on THEN
4247: WSH_DEBUG_SV.logmsg(l_module_name,'e_not_allowed_warning exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4248: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:e_not_allowed_warning');
4249: END IF;
4250: --
4251: WHEN FND_API.G_EXC_ERROR THEN
4244: --
4245: --
4246: IF l_debug_on THEN
4247: WSH_DEBUG_SV.logmsg(l_module_name,'e_not_allowed_warning exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4248: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:e_not_allowed_warning');
4249: END IF;
4250: --
4251: WHEN FND_API.G_EXC_ERROR THEN
4252:
4252:
4253: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4254: --
4255: IF l_debug_on THEN
4256: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4257: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4258: END IF;
4259: --
4260: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4253: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4254: --
4255: IF l_debug_on THEN
4256: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4257: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4258: END IF;
4259: --
4260: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4261:
4261:
4262: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4263: --
4264: IF l_debug_on THEN
4265: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4266: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4267: END IF;
4268: --
4269: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
4262: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4263: --
4264: IF l_debug_on THEN
4265: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4266: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4267: END IF;
4268: --
4269: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
4270: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4269: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
4270: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4271: --
4272: IF l_debug_on THEN
4273: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4274: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
4275: END IF;
4276: --
4277: WHEN OTHERS THEN
4270: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4271: --
4272: IF l_debug_on THEN
4273: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4274: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
4275: END IF;
4276: --
4277: WHEN OTHERS THEN
4278:
4279: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4280: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.check_Close',l_module_name);
4281: --
4282: IF l_debug_on THEN
4283: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4284: END IF;
4285: --
4286: --}
4287: END check_Close;
4350: --
4351: l_debug_on := wsh_debug_interface.g_debug;
4352: --
4353: IF l_debug_on IS NULL THEN
4354: l_debug_on := wsh_debug_sv.is_debug_enabled;
4355: END IF;
4356: --
4357: IF l_debug_on THEN
4358: wsh_debug_sv.push(l_module_name);
4354: l_debug_on := wsh_debug_sv.is_debug_enabled;
4355: END IF;
4356: --
4357: IF l_debug_on THEN
4358: wsh_debug_sv.push(l_module_name);
4359: --
4360: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.trip_id ', p_in_rec.trip_id );
4361: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.name ', p_in_rec.name );
4362: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.put_messages', p_in_rec.put_messages);
4356: --
4357: IF l_debug_on THEN
4358: wsh_debug_sv.push(l_module_name);
4359: --
4360: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.trip_id ', p_in_rec.trip_id );
4361: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.name ', p_in_rec.name );
4362: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.put_messages', p_in_rec.put_messages);
4363: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.manual_flag ', p_in_rec.manual_flag );
4364: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.caller ', p_in_rec.caller );
4357: IF l_debug_on THEN
4358: wsh_debug_sv.push(l_module_name);
4359: --
4360: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.trip_id ', p_in_rec.trip_id );
4361: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.name ', p_in_rec.name );
4362: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.put_messages', p_in_rec.put_messages);
4363: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.manual_flag ', p_in_rec.manual_flag );
4364: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.caller ', p_in_rec.caller );
4365: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.actual_date ', p_in_rec.actual_date );
4358: wsh_debug_sv.push(l_module_name);
4359: --
4360: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.trip_id ', p_in_rec.trip_id );
4361: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.name ', p_in_rec.name );
4362: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.put_messages', p_in_rec.put_messages);
4363: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.manual_flag ', p_in_rec.manual_flag );
4364: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.caller ', p_in_rec.caller );
4365: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.actual_date ', p_in_rec.actual_date );
4366: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.stop_id ', p_in_rec.stop_id );
4359: --
4360: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.trip_id ', p_in_rec.trip_id );
4361: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.name ', p_in_rec.name );
4362: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.put_messages', p_in_rec.put_messages);
4363: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.manual_flag ', p_in_rec.manual_flag );
4364: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.caller ', p_in_rec.caller );
4365: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.actual_date ', p_in_rec.actual_date );
4366: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.stop_id ', p_in_rec.stop_id );
4367: END IF;
4360: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.trip_id ', p_in_rec.trip_id );
4361: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.name ', p_in_rec.name );
4362: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.put_messages', p_in_rec.put_messages);
4363: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.manual_flag ', p_in_rec.manual_flag );
4364: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.caller ', p_in_rec.caller );
4365: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.actual_date ', p_in_rec.actual_date );
4366: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.stop_id ', p_in_rec.stop_id );
4367: END IF;
4368: --
4361: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.name ', p_in_rec.name );
4362: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.put_messages', p_in_rec.put_messages);
4363: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.manual_flag ', p_in_rec.manual_flag );
4364: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.caller ', p_in_rec.caller );
4365: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.actual_date ', p_in_rec.actual_date );
4366: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.stop_id ', p_in_rec.stop_id );
4367: END IF;
4368: --
4369: --
4362: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.put_messages', p_in_rec.put_messages);
4363: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.manual_flag ', p_in_rec.manual_flag );
4364: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.caller ', p_in_rec.caller );
4365: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.actual_date ', p_in_rec.actual_date );
4366: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.stop_id ', p_in_rec.stop_id );
4367: END IF;
4368: --
4369: --
4370: l_num_warnings := 0;
4393: --
4394:
4395: -- Check for Exceptions against the Trip
4396: IF l_debug_on THEN
4397: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.Check_Exceptions',WSH_DEBUG_SV.C_PROC_LEVEL);
4398: END IF;
4399: l_exceptions_tab.delete;
4400: l_exp_logged := FALSE;
4401: l_exp_warning := FALSE;
4503: --
4504: -- Debug Statements
4505: --
4506: IF l_debug_on THEN
4507: WSH_DEBUG_SV.pop(l_module_name);
4508: END IF;
4509: --
4510: --}
4511: EXCEPTION
4521: x_allowed := 'N';
4522: --
4523: --
4524: IF l_debug_on THEN
4525: WSH_DEBUG_SV.logmsg(l_module_name,'e_not_allowed exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4526: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:e_not_allowed');
4527: END IF;
4528: --
4529: WHEN wsh_util_core.e_not_allowed_warning THEN
4522: --
4523: --
4524: IF l_debug_on THEN
4525: WSH_DEBUG_SV.logmsg(l_module_name,'e_not_allowed exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4526: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:e_not_allowed');
4527: END IF;
4528: --
4529: WHEN wsh_util_core.e_not_allowed_warning THEN
4530: IF l_num_warnings > 0
4537: x_allowed := 'NW';
4538: --
4539: --
4540: IF l_debug_on THEN
4541: WSH_DEBUG_SV.logmsg(l_module_name,'e_not_allowed_warning exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4542: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:e_not_allowed_warning');
4543: END IF;
4544: --
4545: WHEN FND_API.G_EXC_ERROR THEN
4538: --
4539: --
4540: IF l_debug_on THEN
4541: WSH_DEBUG_SV.logmsg(l_module_name,'e_not_allowed_warning exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4542: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:e_not_allowed_warning');
4543: END IF;
4544: --
4545: WHEN FND_API.G_EXC_ERROR THEN
4546:
4546:
4547: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4548: --
4549: IF l_debug_on THEN
4550: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4551: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4552: END IF;
4553: --
4554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4547: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4548: --
4549: IF l_debug_on THEN
4550: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4551: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4552: END IF;
4553: --
4554: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4555:
4555:
4556: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4557: --
4558: IF l_debug_on THEN
4559: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4560: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4561: END IF;
4562: --
4563: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
4556: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4557: --
4558: IF l_debug_on THEN
4559: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4560: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4561: END IF;
4562: --
4563: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
4564: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4563: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
4564: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4565: --
4566: IF l_debug_on THEN
4567: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4568: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
4569: END IF;
4570: --
4571: WHEN OTHERS THEN
4564: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4565: --
4566: IF l_debug_on THEN
4567: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4568: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
4569: END IF;
4570: --
4571: WHEN OTHERS THEN
4572:
4573: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4574: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.check_inTransit',l_module_name);
4575: --
4576: IF l_debug_on THEN
4577: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4578: END IF;
4579: --
4580: --}
4581: END check_inTransit;
4624: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
4625: --
4626: IF l_debug_on IS NULL
4627: THEN
4628: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4629: END IF;
4630: --
4631: IF l_debug_on THEN
4632: WSH_DEBUG_SV.push(l_module_name);
4628: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4629: END IF;
4630: --
4631: IF l_debug_on THEN
4632: WSH_DEBUG_SV.push(l_module_name);
4633: WSH_DEBUG_SV.log(l_module_name,'p_trip_id',p_trip_id);
4634: WSH_DEBUG_SV.log(l_module_name,'p_action',p_action);
4635: END IF;
4636: --
4629: END IF;
4630: --
4631: IF l_debug_on THEN
4632: WSH_DEBUG_SV.push(l_module_name);
4633: WSH_DEBUG_SV.log(l_module_name,'p_trip_id',p_trip_id);
4634: WSH_DEBUG_SV.log(l_module_name,'p_action',p_action);
4635: END IF;
4636: --
4637: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4630: --
4631: IF l_debug_on THEN
4632: WSH_DEBUG_SV.push(l_module_name);
4633: WSH_DEBUG_SV.log(l_module_name,'p_trip_id',p_trip_id);
4634: WSH_DEBUG_SV.log(l_module_name,'p_action',p_action);
4635: END IF;
4636: --
4637: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4638: --
4657: --}
4658: END IF;
4659: --
4660: IF l_debug_on THEN
4661: WSH_DEBUG_SV.pop(l_module_name);
4662: END IF;
4663: --}
4664: EXCEPTION
4665: --{
4669: FND_MESSAGE.SET_TOKEN('TRIP_NAME', l_trip_rec.name);
4670: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
4671: --
4672: IF l_debug_on THEN
4673: WSH_DEBUG_SV.logmsg(l_module_name,'e_not_allowed exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4674: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:e_not_allowed');
4675: END IF;
4676: --
4677: WHEN OTHERS THEN
4670: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
4671: --
4672: IF l_debug_on THEN
4673: WSH_DEBUG_SV.logmsg(l_module_name,'e_not_allowed exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4674: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:e_not_allowed');
4675: END IF;
4676: --
4677: WHEN OTHERS THEN
4678: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4677: WHEN OTHERS THEN
4678: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4679: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.validate_trip_status', l_module_name);
4680: IF l_debug_on THEN
4681: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4682: END IF;
4683: --}
4684: END validate_trip_status;
4685: --
4745: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
4746: --
4747: IF l_debug_on IS NULL
4748: THEN
4749: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4750: END IF;
4751: --
4752: IF l_debug_on THEN
4753: WSH_DEBUG_SV.push(l_module_name);
4749: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4750: END IF;
4751: --
4752: IF l_debug_on THEN
4753: WSH_DEBUG_SV.push(l_module_name);
4754: WSH_DEBUG_SV.log(l_module_name,'p_trip_id',p_trip_id);
4755: WSH_DEBUG_SV.log(l_module_name,'p_stop_id',p_stop_id);
4756: END IF;
4757: --
4750: END IF;
4751: --
4752: IF l_debug_on THEN
4753: WSH_DEBUG_SV.push(l_module_name);
4754: WSH_DEBUG_SV.log(l_module_name,'p_trip_id',p_trip_id);
4755: WSH_DEBUG_SV.log(l_module_name,'p_stop_id',p_stop_id);
4756: END IF;
4757: --
4758: --
4751: --
4752: IF l_debug_on THEN
4753: WSH_DEBUG_SV.push(l_module_name);
4754: WSH_DEBUG_SV.log(l_module_name,'p_trip_id',p_trip_id);
4755: WSH_DEBUG_SV.log(l_module_name,'p_stop_id',p_stop_id);
4756: END IF;
4757: --
4758: --
4759: l_cnt := 0;
4768: END IF;
4769: --
4770: --
4771: IF l_debug_on THEN
4772: WSH_DEBUG_SV.log(l_module_name,'l_cnt',l_cnt);
4773: WSH_DEBUG_SV.pop(l_module_name);
4774: END IF;
4775: --
4776: IF l_cnt = 1
4769: --
4770: --
4771: IF l_debug_on THEN
4772: WSH_DEBUG_SV.log(l_module_name,'l_cnt',l_cnt);
4773: WSH_DEBUG_SV.pop(l_module_name);
4774: END IF;
4775: --
4776: IF l_cnt = 1
4777: THEN
4785: WHEN OTHERS THEN
4786: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.has_outbound_deliveries', l_module_name);
4787: --
4788: IF l_debug_on THEN
4789: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4790: END IF;
4791: --
4792: RAISE;
4793: --}
4855: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
4856: --
4857: IF l_debug_on IS NULL
4858: THEN
4859: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4860: END IF;
4861: --
4862: IF l_debug_on THEN
4863: WSH_DEBUG_SV.push(l_module_name);
4859: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4860: END IF;
4861: --
4862: IF l_debug_on THEN
4863: WSH_DEBUG_SV.push(l_module_name);
4864: WSH_DEBUG_SV.log(l_module_name,'p_trip_id',p_trip_id);
4865: WSH_DEBUG_SV.log(l_module_name,'p_stop_id',p_stop_id);
4866: END IF;
4867: --
4860: END IF;
4861: --
4862: IF l_debug_on THEN
4863: WSH_DEBUG_SV.push(l_module_name);
4864: WSH_DEBUG_SV.log(l_module_name,'p_trip_id',p_trip_id);
4865: WSH_DEBUG_SV.log(l_module_name,'p_stop_id',p_stop_id);
4866: END IF;
4867: --
4868: --
4861: --
4862: IF l_debug_on THEN
4863: WSH_DEBUG_SV.push(l_module_name);
4864: WSH_DEBUG_SV.log(l_module_name,'p_trip_id',p_trip_id);
4865: WSH_DEBUG_SV.log(l_module_name,'p_stop_id',p_stop_id);
4866: END IF;
4867: --
4868: --
4869: l_cnt := 0;
4877: --}
4878: END IF;
4879: --
4880: IF l_debug_on THEN
4881: WSH_DEBUG_SV.log(l_module_name,'l_cnt',l_cnt);
4882: WSH_DEBUG_SV.pop(l_module_name);
4883: END IF;
4884: --
4885: IF l_cnt = 1
4878: END IF;
4879: --
4880: IF l_debug_on THEN
4881: WSH_DEBUG_SV.log(l_module_name,'l_cnt',l_cnt);
4882: WSH_DEBUG_SV.pop(l_module_name);
4883: END IF;
4884: --
4885: IF l_cnt = 1
4886: THEN
4895: WHEN OTHERS THEN
4896: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.has_inbound_deliveries', l_module_name);
4897: --
4898: IF l_debug_on THEN
4899: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4900: END IF;
4901: --
4902: RAISE;
4903: --}
4953: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
4954: --
4955: IF l_debug_on IS NULL
4956: THEN
4957: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4958: END IF;
4959: --
4960: IF l_debug_on THEN
4961: WSH_DEBUG_SV.push(l_module_name);
4957: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4958: END IF;
4959: --
4960: IF l_debug_on THEN
4961: WSH_DEBUG_SV.push(l_module_name);
4962: WSH_DEBUG_SV.log(l_module_name,'p_trip_id',p_trip_id);
4963: WSH_DEBUG_SV.log(l_module_name,'p_stop_id',p_stop_id);
4964: END IF;
4965: --
4958: END IF;
4959: --
4960: IF l_debug_on THEN
4961: WSH_DEBUG_SV.push(l_module_name);
4962: WSH_DEBUG_SV.log(l_module_name,'p_trip_id',p_trip_id);
4963: WSH_DEBUG_SV.log(l_module_name,'p_stop_id',p_stop_id);
4964: END IF;
4965: --
4966: --
4959: --
4960: IF l_debug_on THEN
4961: WSH_DEBUG_SV.push(l_module_name);
4962: WSH_DEBUG_SV.log(l_module_name,'p_trip_id',p_trip_id);
4963: WSH_DEBUG_SV.log(l_module_name,'p_stop_id',p_stop_id);
4964: END IF;
4965: --
4966: --
4967: l_has_mixed_deliveries := 'N';
4969: IF (p_trip_id IS NOT NULL)
4970: THEN
4971: --{
4972: IF l_debug_on THEN
4973: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_VALIDATIONS.has_outbound_deliveries',WSH_DEBUG_SV.C_PROC_LEVEL);
4974: END IF;
4975: --
4976: --
4977: l_has_outbound_deliveries := WSH_TRIP_VALIDATIONS.has_outbound_deliveries
4981: );
4982: --
4983: --
4984: IF l_debug_on THEN
4985: WSH_DEBUG_SV.log(l_module_name,'l_has_outbound_deliveries',l_has_outbound_deliveries);
4986: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_VALIDATIONS.has_inbound_deliveries',WSH_DEBUG_SV.C_PROC_LEVEL);
4987: END IF;
4988: --
4989: l_has_inbound_deliveries := WSH_TRIP_VALIDATIONS.has_inbound_deliveries
4982: --
4983: --
4984: IF l_debug_on THEN
4985: WSH_DEBUG_SV.log(l_module_name,'l_has_outbound_deliveries',l_has_outbound_deliveries);
4986: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_VALIDATIONS.has_inbound_deliveries',WSH_DEBUG_SV.C_PROC_LEVEL);
4987: END IF;
4988: --
4989: l_has_inbound_deliveries := WSH_TRIP_VALIDATIONS.has_inbound_deliveries
4990: (
5009: END IF;
5010: --
5011: --
5012: IF l_debug_on THEN
5013: WSH_DEBUG_SV.log(l_module_name,'l_has_inbound_deliveries',l_has_inbound_deliveries);
5014: WSH_DEBUG_SV.log(l_module_name,'l_has_mixed_deliveries',l_has_mixed_deliveries);
5015: WSH_DEBUG_SV.pop(l_module_name);
5016: END IF;
5017: --
5010: --
5011: --
5012: IF l_debug_on THEN
5013: WSH_DEBUG_SV.log(l_module_name,'l_has_inbound_deliveries',l_has_inbound_deliveries);
5014: WSH_DEBUG_SV.log(l_module_name,'l_has_mixed_deliveries',l_has_mixed_deliveries);
5015: WSH_DEBUG_SV.pop(l_module_name);
5016: END IF;
5017: --
5018: RETURN(l_has_mixed_deliveries);
5011: --
5012: IF l_debug_on THEN
5013: WSH_DEBUG_SV.log(l_module_name,'l_has_inbound_deliveries',l_has_inbound_deliveries);
5014: WSH_DEBUG_SV.log(l_module_name,'l_has_mixed_deliveries',l_has_mixed_deliveries);
5015: WSH_DEBUG_SV.pop(l_module_name);
5016: END IF;
5017: --
5018: RETURN(l_has_mixed_deliveries);
5019: --}
5022: WHEN OTHERS THEN
5023: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.has_mixed_deliveries', l_module_name);
5024: --
5025: IF l_debug_on THEN
5026: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5027: END IF;
5028: --
5029: RAISE;
5030: --}
5051: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
5052: --
5053: IF l_debug_on IS NULL
5054: THEN
5055: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
5056: END IF;
5057: --
5058: IF l_debug_on THEN
5059: --
5056: END IF;
5057: --
5058: IF l_debug_on THEN
5059: --
5060: WSH_DEBUG_SV.push(l_module_name);
5061: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.caller',p_in_rec.caller);
5062: --
5063: END IF;
5064: --
5057: --
5058: IF l_debug_on THEN
5059: --
5060: WSH_DEBUG_SV.push(l_module_name);
5061: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.caller',p_in_rec.caller);
5062: --
5063: END IF;
5064: --
5065: x_return_status := FND_API.G_RET_STS_SUCCESS;
5756: END IF;
5757:
5758:
5759: IF l_debug_on THEN
5760: WSH_DEBUG_SV.log(l_module_name,'l_attributes',l_attributes);
5761: WSH_DEBUG_SV.log(l_module_name,'length(l_attributes)',length(l_attributes));
5762: END IF;
5763:
5764:
5757:
5758:
5759: IF l_debug_on THEN
5760: WSH_DEBUG_SV.log(l_module_name,'l_attributes',l_attributes);
5761: WSH_DEBUG_SV.log(l_module_name,'length(l_attributes)',length(l_attributes));
5762: END IF;
5763:
5764:
5765: IF l_attributes IS NULL THEN
5764:
5765: IF l_attributes IS NULL THEN
5766: --no message to be shown to the user
5767: IF l_debug_on THEN
5768: WSH_DEBUG_SV.pop(l_module_name);
5769: END IF;
5770: RETURN;
5771: --
5772: ELSE
5780: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
5781: THEN
5782: x_return_status := l_return_status;
5783: IF l_debug_on THEN
5784: wsh_debug_sv.logmsg(l_module_name,'Error returned by wsh_utilities.process_message',WSH_DEBUG_SV.C_PROC_LEVEL);
5785: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5786: wsh_debug_sv.pop(l_module_name);
5787: END IF;
5788: return;
5781: THEN
5782: x_return_status := l_return_status;
5783: IF l_debug_on THEN
5784: wsh_debug_sv.logmsg(l_module_name,'Error returned by wsh_utilities.process_message',WSH_DEBUG_SV.C_PROC_LEVEL);
5785: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5786: wsh_debug_sv.pop(l_module_name);
5787: END IF;
5788: return;
5789: ELSE
5782: x_return_status := l_return_status;
5783: IF l_debug_on THEN
5784: wsh_debug_sv.logmsg(l_module_name,'Error returned by wsh_utilities.process_message',WSH_DEBUG_SV.C_PROC_LEVEL);
5785: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5786: wsh_debug_sv.pop(l_module_name);
5787: END IF;
5788: return;
5789: ELSE
5790: x_return_status := wsh_util_core.G_RET_STS_WARNING;
5793:
5794:
5795:
5796: IF l_debug_on THEN
5797: WSH_DEBUG_SV.pop(l_module_name);
5798: END IF;
5799: --
5800:
5801:
5803: WHEN OTHERS THEN
5804: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
5805: --
5806: IF l_debug_on THEN
5807: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5808: END IF;
5809: --
5810: END user_non_updatable_columns;
5811:
5949: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
5950: --
5951:
5952: IF l_debug_on IS NULL THEN
5953: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
5954: END IF;
5955:
5956: --
5957: IF l_debug_on THEN
5954: END IF;
5955:
5956: --
5957: IF l_debug_on THEN
5958: WSH_DEBUG_SV.push(l_module_name);
5959: WSH_DEBUG_SV.log(l_module_name,'Trip ID ', p_trip_id);
5960: END IF;
5961:
5962: -- SSN Change
5955:
5956: --
5957: IF l_debug_on THEN
5958: WSH_DEBUG_SV.push(l_module_name);
5959: WSH_DEBUG_SV.log(l_module_name,'Trip ID ', p_trip_id);
5960: END IF;
5961:
5962: -- SSN Change
5963: -- Date validations are applicable only for Profile option = PAD and not if it is set to SSN
5962: -- SSN Change
5963: -- Date validations are applicable only for Profile option = PAD and not if it is set to SSN
5964: IF WSH_TRIPS_ACTIONS.GET_STOP_SEQ_MODE = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_SSN THEN
5965: IF l_debug_on THEN
5966: WSH_DEBUG_SV.logmsg(l_module_name,'Stop Sequence Mode is SSN');
5967: WSH_DEBUG_SV.pop(l_module_name);
5968: END IF;
5969: RETURN; -- these validations are not required for profile option of SSN
5970: END IF;
5963: -- Date validations are applicable only for Profile option = PAD and not if it is set to SSN
5964: IF WSH_TRIPS_ACTIONS.GET_STOP_SEQ_MODE = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_SSN THEN
5965: IF l_debug_on THEN
5966: WSH_DEBUG_SV.logmsg(l_module_name,'Stop Sequence Mode is SSN');
5967: WSH_DEBUG_SV.pop(l_module_name);
5968: END IF;
5969: RETURN; -- these validations are not required for profile option of SSN
5970: END IF;
5971:
5983: CLOSE get_invalid_planned_dates;
5984:
5985: -- Bug 3782135
5986: IF l_debug_on THEN
5987: WSH_DEBUG_SV.log(l_module_name,'Before Validating Arrival Dates',p_trip_id);
5988: END IF;
5989:
5990: OPEN get_invalid_plarrival_dates;
5991: FETCH get_invalid_plarrival_dates
5992: INTO l_invalid_plarrival_date;
5993: l_found := get_invalid_plarrival_dates%FOUND;
5994: CLOSE get_invalid_plarrival_dates;
5995: IF l_debug_on THEN
5996: WSH_DEBUG_SV.log(l_module_name,'After Validating Arrival Dates',p_trip_id);
5997: END IF;
5998:
5999: IF l_found THEN
6000: IF l_debug_on THEN
5997: END IF;
5998:
5999: IF l_found THEN
6000: IF l_debug_on THEN
6001: WSH_DEBUG_SV.log(l_module_name,'Stop ID',l_invalid_plarrival_date.cur_stop_id);
6002: WSH_DEBUG_SV.log(l_module_name,'Seq',l_invalid_plarrival_date.cur_stop_seq_num);
6003: END IF;
6004: raise invalid_arrival_date;
6005: END IF;
5998:
5999: IF l_found THEN
6000: IF l_debug_on THEN
6001: WSH_DEBUG_SV.log(l_module_name,'Stop ID',l_invalid_plarrival_date.cur_stop_id);
6002: WSH_DEBUG_SV.log(l_module_name,'Seq',l_invalid_plarrival_date.cur_stop_seq_num);
6003: END IF;
6004: raise invalid_arrival_date;
6005: END IF;
6006: -- End of Bug 3782135
6017: i := l_del_to_unassign.first;
6018: WHILE i is not NULL LOOP
6019:
6020: IF l_debug_on THEN
6021: WSH_DEBUG_SV.logmsg(l_module_name,'unassign delivery '|| l_del_to_unassign(i));
6022: END IF;
6023:
6024: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_UNASSIGN_TRIP');
6025: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',
6032: i := l_del_to_unassign.next(i);
6033: END LOOP;
6034:
6035: IF l_debug_on THEN
6036: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.UNASSIGN_TRIP',WSH_DEBUG_SV.C_PROC_LEVEL);
6037: END IF;
6038:
6039: WSH_TRIPS_ACTIONS.unassign_trip
6040: (p_del_rows => l_del_to_unassign,
6043:
6044: IF l_return_status in (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
6045: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6046: IF l_debug_on THEN
6047: WSH_DEBUG_SV.pop(l_module_name);
6048: END IF;
6049: return;
6050: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
6051: l_num_warn := l_num_warn + 1;
6066: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6067: END IF;
6068:
6069: IF l_debug_on THEN
6070: WSH_DEBUG_SV.pop(l_module_name);
6071: END IF;
6072:
6073: EXCEPTION
6074:
6076: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6077: FND_MESSAGE.SET_NAME('WSH', 'WSH_TRIP_ID_REQUIRED');
6078: wsh_util_core.add_message(x_return_status, l_module_name);
6079: IF l_debug_on THEN
6080: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR: Trip ID is NULL');
6081: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_input');
6082: END IF;
6083:
6084: WHEN invalid_stop_date THEN
6077: FND_MESSAGE.SET_NAME('WSH', 'WSH_TRIP_ID_REQUIRED');
6078: wsh_util_core.add_message(x_return_status, l_module_name);
6079: IF l_debug_on THEN
6080: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR: Trip ID is NULL');
6081: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_input');
6082: END IF;
6083:
6084: WHEN invalid_stop_date THEN
6085: IF get_invalid_planned_dates%ISOPEN THEN
6104: END IF;
6105: wsh_util_core.add_message(x_return_status, l_module_name);
6106:
6107: IF l_debug_on THEN
6108: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_stop_date');
6109: END IF;
6110:
6111: -- Bug 3782135
6112: WHEN invalid_arrival_date THEN
6116: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(l_invalid_plarrival_date.cur_stop_id,p_caller));
6117: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
6118:
6119: IF l_debug_on THEN
6120: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_planned_arrival_date');
6121: END IF;
6122:
6123: -- End of Bug 3782135
6124: WHEN Others THEN
6136: END IF;
6137: wsh_util_core.default_handler('WSH_TRIP_STOPS_VALIDATIONS.Validate_Stop_Dates',l_module_name);
6138: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6139: IF l_debug_on THEN
6140: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
6141: END IF;
6142:
6143: END Validate_Stop_Dates;
6144: