[Home] [Help]
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:
2177: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2178: --
2179: IF l_debug_on IS NULL
2180: THEN
2181: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2182: END IF;
2183: --
2184: IF l_debug_on THEN
2185: WSH_DEBUG_SV.push(l_module_name);
2181: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2182: END IF;
2183: --
2184: IF l_debug_on THEN
2185: WSH_DEBUG_SV.push(l_module_name);
2186: --
2187: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
2188: WSH_DEBUG_SV.log(l_module_name,'p_action',p_action);
2189: END IF;
2183: --
2184: IF l_debug_on THEN
2185: WSH_DEBUG_SV.push(l_module_name);
2186: --
2187: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
2188: WSH_DEBUG_SV.log(l_module_name,'p_action',p_action);
2189: END IF;
2190:
2191: -- call initialize API and get the pl/sql table
2184: IF l_debug_on THEN
2185: WSH_DEBUG_SV.push(l_module_name);
2186: --
2187: WSH_DEBUG_SV.log(l_module_name,'p_caller',p_caller);
2188: WSH_DEBUG_SV.log(l_module_name,'p_action',p_action);
2189: END IF;
2190:
2191: -- call initialize API and get the pl/sql table
2192: Init_Trip_Actions_Tbl(
2194: x_trip_actions_tab => l_trip_actions_tab,
2195: x_return_status => x_return_status);
2196:
2197: IF l_debug_on THEN
2198: WSH_DEBUG_SV.log(l_module_name,'Init_Detail_Actions_Tbl x_return_status',x_return_status);
2199: END IF;
2200:
2201: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
2202: raise error_in_init_actions;
2211: l_caller := p_caller;
2212: --
2213: --
2214: IF l_debug_on THEN
2215: wsh_debug_sv.log(l_module_name, 'l_caller', l_caller);
2216: END IF;
2217: --
2218: --
2219: -- Actions on inbound trips are allowed only if caller
2244: END IF;
2245: --
2246: --
2247: IF l_debug_on THEN
2248: wsh_debug_sv.log(l_module_name, 'l_caller-modified', l_caller);
2249: END IF;
2250: -- J-IB-NPARIKH-}
2251: --
2252: -- section a
2267: ) THEN
2268:
2269: IF l_trip_actions_tab(l_loop_counter).message_name IS NOT NULL THEN
2270: IF l_debug_on THEN
2271: wsh_debug_sv.log(l_module_name, 'Message Name is', l_trip_actions_tab(l_loop_counter).message_name);
2272: END IF;
2273: FND_MESSAGE.SET_NAME('WSH',l_trip_actions_tab(l_loop_counter).message_name);
2274: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error);
2275: END IF;
2298: x_error_ids => l_error_ids,
2299: x_valid_index_tab => l_valid_index_tab);
2300:
2301: IF l_debug_on THEN
2302: WSH_DEBUG_SV.log(l_module_name,'WSH_DELIVERY_VALIDATIONS.Is_Action_Enabled l_return_status',l_return_status);
2303: END IF;
2304:
2305: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS)
2306: AND (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)
2330: ELSIF p_action = 'SELECT-CARRIER' THEN
2331:
2332: IF p_trip_rec_tab(j).lane_id IS NOT NULL THEN
2333: IF l_debug_on THEN
2334: wsh_debug_sv.log(l_module_name, 'Trip has lane id : ', p_trip_rec_tab(j).lane_id);
2335: END IF;
2336: FND_MESSAGE.SET_NAME('WSH','WSH_FTE_SEL_TRIP_LANE');
2337: FND_MESSAGE.SET_TOKEN('TRIPID',p_trip_rec_tab(j).trip_id);
2338: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error);
2344:
2345: --IF l_move_id IS NOT NULL THEN
2346: IF l_move_id <> -1 THEN
2347: IF l_debug_on THEN
2348: wsh_debug_sv.log(l_module_name, 'Trip has continuous move id id : ', l_move_id);
2349: END IF;
2350: FND_MESSAGE.SET_NAME('WSH','WSH_FTE_SEL_TRIP_MOVE');
2351: FND_MESSAGE.SET_TOKEN('TRIPID',p_trip_rec_tab(j).trip_id);
2352: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error);
2402: --
2403: END IF;
2404:
2405: IF l_debug_on THEN
2406: WSH_DEBUG_SV.pop(l_module_name);
2407: END IF;
2408:
2409: EXCEPTION
2410: WHEN error_in_init_actions THEN
2408:
2409: EXCEPTION
2410: WHEN error_in_init_actions THEN
2411: IF l_debug_on THEN
2412: WSH_DEBUG_SV.logmsg(l_module_name,'error_in_init_actions exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2413: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:error_in_init_actions');
2414: END IF;
2415:
2416: WHEN OTHERS THEN
2409: EXCEPTION
2410: WHEN error_in_init_actions THEN
2411: IF l_debug_on THEN
2412: WSH_DEBUG_SV.logmsg(l_module_name,'error_in_init_actions exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2413: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:error_in_init_actions');
2414: END IF;
2415:
2416: WHEN OTHERS THEN
2417: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.IS_ACTION_ENABLED');
2416: WHEN OTHERS THEN
2417: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.IS_ACTION_ENABLED');
2418: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2419: IF l_debug_on THEN
2420: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2421: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2422: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2423: END IF;
2424: END Is_Action_Enabled;
2417: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.IS_ACTION_ENABLED');
2418: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2419: IF l_debug_on THEN
2420: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2421: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2422: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2423: END IF;
2424: END Is_Action_Enabled;
2425:
2418: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2419: IF l_debug_on THEN
2420: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2421: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2422: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2423: END IF;
2424: END Is_Action_Enabled;
2425:
2426:
2450: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2451: --
2452: IF l_debug_on IS NULL
2453: THEN
2454: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2455: END IF;
2456: --
2457: IF l_debug_on THEN
2458: WSH_DEBUG_SV.push(l_module_name);
2454: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2455: END IF;
2456: --
2457: IF l_debug_on THEN
2458: WSH_DEBUG_SV.push(l_module_name);
2459: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
2460: WSH_DEBUG_SV.log(l_module_name,'p_arr_after_trip_id',p_arr_after_trip_id);
2461: WSH_DEBUG_SV.log(l_module_name,'p_arr_after_trip_name',p_arr_after_trip_name);
2462: END IF;
2455: END IF;
2456: --
2457: IF l_debug_on THEN
2458: WSH_DEBUG_SV.push(l_module_name);
2459: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
2460: WSH_DEBUG_SV.log(l_module_name,'p_arr_after_trip_id',p_arr_after_trip_id);
2461: WSH_DEBUG_SV.log(l_module_name,'p_arr_after_trip_name',p_arr_after_trip_name);
2462: END IF;
2463:
2456: --
2457: IF l_debug_on THEN
2458: WSH_DEBUG_SV.push(l_module_name);
2459: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
2460: WSH_DEBUG_SV.log(l_module_name,'p_arr_after_trip_id',p_arr_after_trip_id);
2461: WSH_DEBUG_SV.log(l_module_name,'p_arr_after_trip_name',p_arr_after_trip_name);
2462: END IF;
2463:
2464: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2457: IF l_debug_on THEN
2458: WSH_DEBUG_SV.push(l_module_name);
2459: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',P_TRIP_ID);
2460: WSH_DEBUG_SV.log(l_module_name,'p_arr_after_trip_id',p_arr_after_trip_id);
2461: WSH_DEBUG_SV.log(l_module_name,'p_arr_after_trip_name',p_arr_after_trip_name);
2462: END IF;
2463:
2464: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2465:
2469: )
2470: ) THEN
2471: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2472: IF l_debug_on THEN
2473: WSH_DEBUG_SV.pop(l_module_name);
2474: END IF;
2475: RETURN;
2476: END IF;
2477:
2501: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
2502: END IF;
2503:
2504: IF l_debug_on THEN
2505: WSH_DEBUG_SV.pop(l_module_name);
2506: END IF;
2507:
2508: EXCEPTION
2509: WHEN OTHERS THEN
2509: WHEN OTHERS THEN
2510: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.VALIDATE_ARRIVE_AFTER_TRIP');
2511: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2512: IF l_debug_on THEN
2513: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2514: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2515: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2516: END IF;
2517: END Validate_Arrive_after_trip;
2510: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.VALIDATE_ARRIVE_AFTER_TRIP');
2511: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2512: IF l_debug_on THEN
2513: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2514: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2515: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2516: END IF;
2517: END Validate_Arrive_after_trip;
2518:
2511: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2512: IF l_debug_on THEN
2513: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2514: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2515: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2516: END IF;
2517: END Validate_Arrive_after_trip;
2518:
2519:
2540: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2541: --
2542: IF l_debug_on IS NULL
2543: THEN
2544: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2545: END IF;
2546: --
2547:
2548:
2561: l_mode_of_transport :=p_db_trip_info.mode_of_transport;
2562: l_lane_id :=p_db_trip_info.lane_id;
2563:
2564: IF l_debug_on THEN
2565: WSH_DEBUG_SV.push(l_module_name);
2566: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',p_trip_info.trip_id);
2567: WSH_DEBUG_SV.log(l_module_name,'p_consolidation_allowed',p_trip_info.consolidation_allowed);
2568: WSH_DEBUG_SV.log(l_module_name,'p_veh_item_id',p_trip_info.vehicle_item_id);
2569: WSH_DEBUG_SV.log(l_module_name,'p_veh_org_id',p_trip_info.vehicle_organization_id);
2562: l_lane_id :=p_db_trip_info.lane_id;
2563:
2564: IF l_debug_on THEN
2565: WSH_DEBUG_SV.push(l_module_name);
2566: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',p_trip_info.trip_id);
2567: WSH_DEBUG_SV.log(l_module_name,'p_consolidation_allowed',p_trip_info.consolidation_allowed);
2568: WSH_DEBUG_SV.log(l_module_name,'p_veh_item_id',p_trip_info.vehicle_item_id);
2569: WSH_DEBUG_SV.log(l_module_name,'p_veh_org_id',p_trip_info.vehicle_organization_id);
2570: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_code',p_trip_info.ship_method_code);
2563:
2564: IF l_debug_on THEN
2565: WSH_DEBUG_SV.push(l_module_name);
2566: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',p_trip_info.trip_id);
2567: WSH_DEBUG_SV.log(l_module_name,'p_consolidation_allowed',p_trip_info.consolidation_allowed);
2568: WSH_DEBUG_SV.log(l_module_name,'p_veh_item_id',p_trip_info.vehicle_item_id);
2569: WSH_DEBUG_SV.log(l_module_name,'p_veh_org_id',p_trip_info.vehicle_organization_id);
2570: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_code',p_trip_info.ship_method_code);
2571: WSH_DEBUG_SV.log(l_module_name,'p_carrier_id',p_trip_info.carrier_id);
2564: IF l_debug_on THEN
2565: WSH_DEBUG_SV.push(l_module_name);
2566: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',p_trip_info.trip_id);
2567: WSH_DEBUG_SV.log(l_module_name,'p_consolidation_allowed',p_trip_info.consolidation_allowed);
2568: WSH_DEBUG_SV.log(l_module_name,'p_veh_item_id',p_trip_info.vehicle_item_id);
2569: WSH_DEBUG_SV.log(l_module_name,'p_veh_org_id',p_trip_info.vehicle_organization_id);
2570: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_code',p_trip_info.ship_method_code);
2571: WSH_DEBUG_SV.log(l_module_name,'p_carrier_id',p_trip_info.carrier_id);
2572: WSH_DEBUG_SV.log(l_module_name,'p_service_level',p_trip_info.service_level);
2565: WSH_DEBUG_SV.push(l_module_name);
2566: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',p_trip_info.trip_id);
2567: WSH_DEBUG_SV.log(l_module_name,'p_consolidation_allowed',p_trip_info.consolidation_allowed);
2568: WSH_DEBUG_SV.log(l_module_name,'p_veh_item_id',p_trip_info.vehicle_item_id);
2569: WSH_DEBUG_SV.log(l_module_name,'p_veh_org_id',p_trip_info.vehicle_organization_id);
2570: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_code',p_trip_info.ship_method_code);
2571: WSH_DEBUG_SV.log(l_module_name,'p_carrier_id',p_trip_info.carrier_id);
2572: WSH_DEBUG_SV.log(l_module_name,'p_service_level',p_trip_info.service_level);
2573: WSH_DEBUG_SV.log(l_module_name,'p_mode_of_transport',p_trip_info.mode_of_transport);
2566: WSH_DEBUG_SV.log(l_module_name,'P_TRIP_ID',p_trip_info.trip_id);
2567: WSH_DEBUG_SV.log(l_module_name,'p_consolidation_allowed',p_trip_info.consolidation_allowed);
2568: WSH_DEBUG_SV.log(l_module_name,'p_veh_item_id',p_trip_info.vehicle_item_id);
2569: WSH_DEBUG_SV.log(l_module_name,'p_veh_org_id',p_trip_info.vehicle_organization_id);
2570: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_code',p_trip_info.ship_method_code);
2571: WSH_DEBUG_SV.log(l_module_name,'p_carrier_id',p_trip_info.carrier_id);
2572: WSH_DEBUG_SV.log(l_module_name,'p_service_level',p_trip_info.service_level);
2573: WSH_DEBUG_SV.log(l_module_name,'p_mode_of_transport',p_trip_info.mode_of_transport);
2574: WSH_DEBUG_SV.log(l_module_name,'p_lane_id',p_trip_info.lane_id);
2567: WSH_DEBUG_SV.log(l_module_name,'p_consolidation_allowed',p_trip_info.consolidation_allowed);
2568: WSH_DEBUG_SV.log(l_module_name,'p_veh_item_id',p_trip_info.vehicle_item_id);
2569: WSH_DEBUG_SV.log(l_module_name,'p_veh_org_id',p_trip_info.vehicle_organization_id);
2570: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_code',p_trip_info.ship_method_code);
2571: WSH_DEBUG_SV.log(l_module_name,'p_carrier_id',p_trip_info.carrier_id);
2572: WSH_DEBUG_SV.log(l_module_name,'p_service_level',p_trip_info.service_level);
2573: WSH_DEBUG_SV.log(l_module_name,'p_mode_of_transport',p_trip_info.mode_of_transport);
2574: WSH_DEBUG_SV.log(l_module_name,'p_lane_id',p_trip_info.lane_id);
2575:
2568: WSH_DEBUG_SV.log(l_module_name,'p_veh_item_id',p_trip_info.vehicle_item_id);
2569: WSH_DEBUG_SV.log(l_module_name,'p_veh_org_id',p_trip_info.vehicle_organization_id);
2570: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_code',p_trip_info.ship_method_code);
2571: WSH_DEBUG_SV.log(l_module_name,'p_carrier_id',p_trip_info.carrier_id);
2572: WSH_DEBUG_SV.log(l_module_name,'p_service_level',p_trip_info.service_level);
2573: WSH_DEBUG_SV.log(l_module_name,'p_mode_of_transport',p_trip_info.mode_of_transport);
2574: WSH_DEBUG_SV.log(l_module_name,'p_lane_id',p_trip_info.lane_id);
2575:
2576: WSH_DEBUG_SV.log(l_module_name,'l_consolidation_allowed',l_consolidation_allowed);
2569: WSH_DEBUG_SV.log(l_module_name,'p_veh_org_id',p_trip_info.vehicle_organization_id);
2570: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_code',p_trip_info.ship_method_code);
2571: WSH_DEBUG_SV.log(l_module_name,'p_carrier_id',p_trip_info.carrier_id);
2572: WSH_DEBUG_SV.log(l_module_name,'p_service_level',p_trip_info.service_level);
2573: WSH_DEBUG_SV.log(l_module_name,'p_mode_of_transport',p_trip_info.mode_of_transport);
2574: WSH_DEBUG_SV.log(l_module_name,'p_lane_id',p_trip_info.lane_id);
2575:
2576: WSH_DEBUG_SV.log(l_module_name,'l_consolidation_allowed',l_consolidation_allowed);
2577: WSH_DEBUG_SV.log(l_module_name,'l_veh_item_id',l_vehicle_item_id);
2570: WSH_DEBUG_SV.log(l_module_name,'p_ship_method_code',p_trip_info.ship_method_code);
2571: WSH_DEBUG_SV.log(l_module_name,'p_carrier_id',p_trip_info.carrier_id);
2572: WSH_DEBUG_SV.log(l_module_name,'p_service_level',p_trip_info.service_level);
2573: WSH_DEBUG_SV.log(l_module_name,'p_mode_of_transport',p_trip_info.mode_of_transport);
2574: WSH_DEBUG_SV.log(l_module_name,'p_lane_id',p_trip_info.lane_id);
2575:
2576: WSH_DEBUG_SV.log(l_module_name,'l_consolidation_allowed',l_consolidation_allowed);
2577: WSH_DEBUG_SV.log(l_module_name,'l_veh_item_id',l_vehicle_item_id);
2578: WSH_DEBUG_SV.log(l_module_name,'l_veh_org_id',l_vehicle_organization_id);
2572: WSH_DEBUG_SV.log(l_module_name,'p_service_level',p_trip_info.service_level);
2573: WSH_DEBUG_SV.log(l_module_name,'p_mode_of_transport',p_trip_info.mode_of_transport);
2574: WSH_DEBUG_SV.log(l_module_name,'p_lane_id',p_trip_info.lane_id);
2575:
2576: WSH_DEBUG_SV.log(l_module_name,'l_consolidation_allowed',l_consolidation_allowed);
2577: WSH_DEBUG_SV.log(l_module_name,'l_veh_item_id',l_vehicle_item_id);
2578: WSH_DEBUG_SV.log(l_module_name,'l_veh_org_id',l_vehicle_organization_id);
2579: WSH_DEBUG_SV.log(l_module_name,'l_ship_method_code',l_ship_method_code);
2580: WSH_DEBUG_SV.log(l_module_name,'l_carrier_id',l_carrier_id);
2573: WSH_DEBUG_SV.log(l_module_name,'p_mode_of_transport',p_trip_info.mode_of_transport);
2574: WSH_DEBUG_SV.log(l_module_name,'p_lane_id',p_trip_info.lane_id);
2575:
2576: WSH_DEBUG_SV.log(l_module_name,'l_consolidation_allowed',l_consolidation_allowed);
2577: WSH_DEBUG_SV.log(l_module_name,'l_veh_item_id',l_vehicle_item_id);
2578: WSH_DEBUG_SV.log(l_module_name,'l_veh_org_id',l_vehicle_organization_id);
2579: WSH_DEBUG_SV.log(l_module_name,'l_ship_method_code',l_ship_method_code);
2580: WSH_DEBUG_SV.log(l_module_name,'l_carrier_id',l_carrier_id);
2581: WSH_DEBUG_SV.log(l_module_name,'l_service_level',l_service_level);
2574: WSH_DEBUG_SV.log(l_module_name,'p_lane_id',p_trip_info.lane_id);
2575:
2576: WSH_DEBUG_SV.log(l_module_name,'l_consolidation_allowed',l_consolidation_allowed);
2577: WSH_DEBUG_SV.log(l_module_name,'l_veh_item_id',l_vehicle_item_id);
2578: WSH_DEBUG_SV.log(l_module_name,'l_veh_org_id',l_vehicle_organization_id);
2579: WSH_DEBUG_SV.log(l_module_name,'l_ship_method_code',l_ship_method_code);
2580: WSH_DEBUG_SV.log(l_module_name,'l_carrier_id',l_carrier_id);
2581: WSH_DEBUG_SV.log(l_module_name,'l_service_level',l_service_level);
2582: WSH_DEBUG_SV.log(l_module_name,'l_mode_of_transport',l_mode_of_transport);
2575:
2576: WSH_DEBUG_SV.log(l_module_name,'l_consolidation_allowed',l_consolidation_allowed);
2577: WSH_DEBUG_SV.log(l_module_name,'l_veh_item_id',l_vehicle_item_id);
2578: WSH_DEBUG_SV.log(l_module_name,'l_veh_org_id',l_vehicle_organization_id);
2579: WSH_DEBUG_SV.log(l_module_name,'l_ship_method_code',l_ship_method_code);
2580: WSH_DEBUG_SV.log(l_module_name,'l_carrier_id',l_carrier_id);
2581: WSH_DEBUG_SV.log(l_module_name,'l_service_level',l_service_level);
2582: WSH_DEBUG_SV.log(l_module_name,'l_mode_of_transport',l_mode_of_transport);
2583: WSH_DEBUG_SV.log(l_module_name,'l_lane_id',l_lane_id);
2576: WSH_DEBUG_SV.log(l_module_name,'l_consolidation_allowed',l_consolidation_allowed);
2577: WSH_DEBUG_SV.log(l_module_name,'l_veh_item_id',l_vehicle_item_id);
2578: WSH_DEBUG_SV.log(l_module_name,'l_veh_org_id',l_vehicle_organization_id);
2579: WSH_DEBUG_SV.log(l_module_name,'l_ship_method_code',l_ship_method_code);
2580: WSH_DEBUG_SV.log(l_module_name,'l_carrier_id',l_carrier_id);
2581: WSH_DEBUG_SV.log(l_module_name,'l_service_level',l_service_level);
2582: WSH_DEBUG_SV.log(l_module_name,'l_mode_of_transport',l_mode_of_transport);
2583: WSH_DEBUG_SV.log(l_module_name,'l_lane_id',l_lane_id);
2584: END IF;
2577: WSH_DEBUG_SV.log(l_module_name,'l_veh_item_id',l_vehicle_item_id);
2578: WSH_DEBUG_SV.log(l_module_name,'l_veh_org_id',l_vehicle_organization_id);
2579: WSH_DEBUG_SV.log(l_module_name,'l_ship_method_code',l_ship_method_code);
2580: WSH_DEBUG_SV.log(l_module_name,'l_carrier_id',l_carrier_id);
2581: WSH_DEBUG_SV.log(l_module_name,'l_service_level',l_service_level);
2582: WSH_DEBUG_SV.log(l_module_name,'l_mode_of_transport',l_mode_of_transport);
2583: WSH_DEBUG_SV.log(l_module_name,'l_lane_id',l_lane_id);
2584: END IF;
2585:
2578: WSH_DEBUG_SV.log(l_module_name,'l_veh_org_id',l_vehicle_organization_id);
2579: WSH_DEBUG_SV.log(l_module_name,'l_ship_method_code',l_ship_method_code);
2580: WSH_DEBUG_SV.log(l_module_name,'l_carrier_id',l_carrier_id);
2581: WSH_DEBUG_SV.log(l_module_name,'l_service_level',l_service_level);
2582: WSH_DEBUG_SV.log(l_module_name,'l_mode_of_transport',l_mode_of_transport);
2583: WSH_DEBUG_SV.log(l_module_name,'l_lane_id',l_lane_id);
2584: END IF;
2585:
2586:
2579: WSH_DEBUG_SV.log(l_module_name,'l_ship_method_code',l_ship_method_code);
2580: WSH_DEBUG_SV.log(l_module_name,'l_carrier_id',l_carrier_id);
2581: WSH_DEBUG_SV.log(l_module_name,'l_service_level',l_service_level);
2582: WSH_DEBUG_SV.log(l_module_name,'l_mode_of_transport',l_mode_of_transport);
2583: WSH_DEBUG_SV.log(l_module_name,'l_lane_id',l_lane_id);
2584: END IF;
2585:
2586:
2587: --if lane_id, carrier_id, ship_method_code, service_level, mode_of_transport are changed
2610:
2611: END IF;
2612:
2613: IF l_debug_on THEN
2614: WSH_DEBUG_SV.pop(l_module_name);
2615: END IF;
2616:
2617: EXCEPTION
2618: WHEN OTHERS THEN
2618: WHEN OTHERS THEN
2619: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.VALIDATE_CONSOL_ALLOWED');
2620: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2621: IF l_debug_on THEN
2622: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2623: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2624: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2625: END IF;
2626: END Validate_Consol_Allowed;
2619: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.VALIDATE_CONSOL_ALLOWED');
2620: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2621: IF l_debug_on THEN
2622: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2623: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2624: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2625: END IF;
2626: END Validate_Consol_Allowed;
2627:
2620: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2621: IF l_debug_on THEN
2622: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2623: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2624: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2625: END IF;
2626: END Validate_Consol_Allowed;
2627:
2628:
3489: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3490: --
3491: IF l_debug_on IS NULL
3492: THEN
3493: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3494: END IF;
3495: --
3496: IF l_debug_on THEN
3497: --
3494: END IF;
3495: --
3496: IF l_debug_on THEN
3497: --
3498: WSH_DEBUG_SV.push(l_module_name);
3499: WSH_DEBUG_SV.log(l_module_name,'trip_id',p_trip_rec.trip_id);
3500: WSH_DEBUG_SV.log(l_module_name,'Action', p_in_rec.action_code);
3501: WSH_DEBUG_SV.log(l_module_name,'Caller', p_in_rec.caller);
3502: --
3495: --
3496: IF l_debug_on THEN
3497: --
3498: WSH_DEBUG_SV.push(l_module_name);
3499: WSH_DEBUG_SV.log(l_module_name,'trip_id',p_trip_rec.trip_id);
3500: WSH_DEBUG_SV.log(l_module_name,'Action', p_in_rec.action_code);
3501: WSH_DEBUG_SV.log(l_module_name,'Caller', p_in_rec.caller);
3502: --
3503: END IF;
3496: IF l_debug_on THEN
3497: --
3498: WSH_DEBUG_SV.push(l_module_name);
3499: WSH_DEBUG_SV.log(l_module_name,'trip_id',p_trip_rec.trip_id);
3500: WSH_DEBUG_SV.log(l_module_name,'Action', p_in_rec.action_code);
3501: WSH_DEBUG_SV.log(l_module_name,'Caller', p_in_rec.caller);
3502: --
3503: END IF;
3504: --
3497: --
3498: WSH_DEBUG_SV.push(l_module_name);
3499: WSH_DEBUG_SV.log(l_module_name,'trip_id',p_trip_rec.trip_id);
3500: WSH_DEBUG_SV.log(l_module_name,'Action', p_in_rec.action_code);
3501: WSH_DEBUG_SV.log(l_module_name,'Caller', p_in_rec.caller);
3502: --
3503: END IF;
3504: --
3505: x_return_status := FND_API.G_RET_STS_SUCCESS;
3506: --
3507: IF p_in_rec.action_code = 'CREATE' THEN
3508: --
3509: IF l_debug_on THEN
3510: WSH_DEBUG_SV.log(l_module_name,'calling eliminate_displayonly_fields');
3511: END IF;
3512: --
3513: -- nothing else need to be disabled
3514: --
3516: --
3517: --3509004:public api changes
3518: /*
3519: IF l_debug_on THEN
3520: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
3521: WSH_DEBUG_SV.pop(l_module_name);
3522: END IF;
3523: -- RETURN;
3524: --
3517: --3509004:public api changes
3518: /*
3519: IF l_debug_on THEN
3520: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
3521: WSH_DEBUG_SV.pop(l_module_name);
3522: END IF;
3523: -- RETURN;
3524: --
3525: */
3542: x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
3543: THEN
3544: --
3545: IF l_debug_on THEN
3546: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
3547: WSH_DEBUG_SV.pop(l_module_name);
3548: END IF;
3549: RETURN;
3550: --
3543: THEN
3544: --
3545: IF l_debug_on THEN
3546: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
3547: WSH_DEBUG_SV.pop(l_module_name);
3548: END IF;
3549: RETURN;
3550: --
3551: END IF;
3622:
3623: --
3624: --
3625: IF l_debug_on THEN
3626: WSH_DEBUG_SV.log(l_module_name,'list.COUNT',l_disabled_list.COUNT);
3627: END IF;
3628: --
3629: IF l_disabled_list.COUNT = 0 THEN
3630: --
3628: --
3629: IF l_disabled_list.COUNT = 0 THEN
3630: --
3631: IF l_debug_on THEN
3632: WSH_DEBUG_SV.log(l_module_name,'calling eliminate_displayonly_fields');
3633: END IF;
3634: --
3635: -- nothing else need to be disabled
3636: --
3642: --
3643: IF l_debug_on THEN
3644: FOR i in 1..l_disabled_list.COUNT
3645: LOOP
3646: WSH_DEBUG_SV.log(l_module_name,'list values',l_disabled_list(i));
3647: END LOOP;
3648: WSH_DEBUG_SV.log(l_module_name,'calling enable_from_list');
3649: END IF;
3650: --enable the columns matching the l_disabled_list
3644: FOR i in 1..l_disabled_list.COUNT
3645: LOOP
3646: WSH_DEBUG_SV.log(l_module_name,'list values',l_disabled_list(i));
3647: END LOOP;
3648: WSH_DEBUG_SV.log(l_module_name,'calling enable_from_list');
3649: END IF;
3650: --enable the columns matching the l_disabled_list
3651: enable_from_list(l_disabled_list,
3652: p_trip_rec,
3665: --
3666: IF l_debug_on THEN
3667: FOR i in 1..l_disabled_list.COUNT
3668: LOOP
3669: WSH_DEBUG_SV.log(l_module_name,'list values',l_disabled_list(i));
3670: END LOOP;
3671: WSH_DEBUG_SV.log(l_module_name,'First element is not FULL');
3672: WSH_DEBUG_SV.log(l_module_name,'calling eliminate_displayonly_fields');
3673: END IF;
3667: FOR i in 1..l_disabled_list.COUNT
3668: LOOP
3669: WSH_DEBUG_SV.log(l_module_name,'list values',l_disabled_list(i));
3670: END LOOP;
3671: WSH_DEBUG_SV.log(l_module_name,'First element is not FULL');
3672: WSH_DEBUG_SV.log(l_module_name,'calling eliminate_displayonly_fields');
3673: END IF;
3674: --
3675: eliminate_displayonly_fields (p_trip_rec,p_in_rec,x_trip_rec);
3668: LOOP
3669: WSH_DEBUG_SV.log(l_module_name,'list values',l_disabled_list(i));
3670: END LOOP;
3671: WSH_DEBUG_SV.log(l_module_name,'First element is not FULL');
3672: WSH_DEBUG_SV.log(l_module_name,'calling eliminate_displayonly_fields');
3673: END IF;
3674: --
3675: eliminate_displayonly_fields (p_trip_rec,p_in_rec,x_trip_rec);
3676: --
3674: --
3675: eliminate_displayonly_fields (p_trip_rec,p_in_rec,x_trip_rec);
3676: --
3677: IF l_debug_on THEN
3678: WSH_DEBUG_SV.log(l_module_name,'calling disable_from_list');
3679: END IF;
3680: -- The fileds in the list are getting disabled
3681: disable_from_list(l_disabled_list,
3682: l_db_col_rec,
3707: --
3708: END IF;
3709: --
3710: IF l_debug_on THEN
3711: WSH_DEBUG_SV.pop(l_module_name);
3712: END IF;
3713: --
3714: EXCEPTION
3715: WHEN e_all_disabled THEN
3718: FND_MESSAGE.Set_Token('ENTITY_ID',p_trip_rec.trip_id);
3719: wsh_util_core.add_message(x_return_status,l_module_name);
3720: IF l_debug_on THEN
3721: -- Nothing is updateable
3722: WSH_DEBUG_SV.pop(l_module_name,'e_all_disabled');
3723: END IF;
3724: WHEN e_dp_no_entity THEN
3725: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3726: -- the message for this is set in original get_disabled_list
3724: WHEN e_dp_no_entity THEN
3725: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3726: -- the message for this is set in original get_disabled_list
3727: IF l_debug_on THEN
3728: WSH_DEBUG_SV.pop(l_module_name,'e_dp_no_entity');
3729: END IF;
3730: WHEN e_bad_field THEN
3731: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3732: FND_MESSAGE.SET_NAME('WSH','WSH_BAD_FIELD_NAME');
3732: FND_MESSAGE.SET_NAME('WSH','WSH_BAD_FIELD_NAME');
3733: FND_MESSAGE.Set_Token('FIELD_NAME',l_field_name);
3734: wsh_util_core.add_message(x_return_status,l_module_name);
3735: IF l_debug_on THEN
3736: WSH_DEBUG_SV.log(l_module_name,'Bad field name passed to the list:'
3737: ,l_field_name);
3738: WSH_DEBUG_SV.pop(l_module_name,'e_bad_field');
3739: END IF;
3740:
3734: wsh_util_core.add_message(x_return_status,l_module_name);
3735: IF l_debug_on THEN
3736: WSH_DEBUG_SV.log(l_module_name,'Bad field name passed to the list:'
3737: ,l_field_name);
3738: WSH_DEBUG_SV.pop(l_module_name,'e_bad_field');
3739: END IF;
3740:
3741: WHEN OTHERS THEN
3742: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.get_disabled_list'
3742: wsh_util_core.default_handler('WSH_DETAILS_VALIDATIONS.get_disabled_list'
3743: ,l_module_name);
3744: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3745: IF l_debug_on THEN
3746: WSH_DEBUG_SV.log(l_module_name,'Error:',SUBSTR(SQLERRM,1,200));
3747: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3748: END IF;
3749: END Get_Disabled_List;
3750:
3743: ,l_module_name);
3744: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3745: IF l_debug_on THEN
3746: WSH_DEBUG_SV.log(l_module_name,'Error:',SUBSTR(SQLERRM,1,200));
3747: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3748: END IF;
3749: END Get_Disabled_List;
3750:
3751:
3769: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3770: --
3771: IF l_debug_on IS NULL
3772: THEN
3773: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3774: END IF;
3775:
3776: --OTM R12, glog proj, use Global Variable
3777: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
3927: -- bug 5837425
3928:
3929: --
3930: IF l_debug_on THEN
3931: WSH_DEBUG_SV.push(l_module_name);
3932: --
3933: WSH_DEBUG_SV.log(l_module_name,'p_action', p_action);
3934: END IF;
3935: --
3929: --
3930: IF l_debug_on THEN
3931: WSH_DEBUG_SV.push(l_module_name);
3932: --
3933: WSH_DEBUG_SV.log(l_module_name,'p_action', p_action);
3934: END IF;
3935: --
3936: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3937:
3935: --
3936: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3937:
3938: IF l_debug_on THEN
3939: WSH_DEBUG_SV.pop(l_module_name);
3940: END IF;
3941:
3942: EXCEPTION
3943: -- OTM R12, glog proj
3945: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_TRIP_VALIDATIONS.init_trip_actions_tbl'
3946: ,l_module_name);
3947: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3948: IF l_debug_on THEN
3949: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3950: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3951: END IF;
3952:
3953:
3946: ,l_module_name);
3947: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3948: IF l_debug_on THEN
3949: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3950: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3951: END IF;
3952:
3953:
3954: END Init_Trip_Actions_Tbl;
4057: --
4058: l_debug_on := wsh_debug_interface.g_debug;
4059: --
4060: IF l_debug_on IS NULL THEN
4061: l_debug_on := wsh_debug_sv.is_debug_enabled;
4062: END IF;
4063: --
4064: IF l_debug_on THEN
4065: wsh_debug_sv.push(l_module_name);
4061: l_debug_on := wsh_debug_sv.is_debug_enabled;
4062: END IF;
4063: --
4064: IF l_debug_on THEN
4065: wsh_debug_sv.push(l_module_name);
4066: --
4067: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.trip_id ', p_in_rec.trip_id );
4068: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.name ', p_in_rec.name );
4069: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.put_messages', p_in_rec.put_messages);
4063: --
4064: IF l_debug_on THEN
4065: wsh_debug_sv.push(l_module_name);
4066: --
4067: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.trip_id ', p_in_rec.trip_id );
4068: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.name ', p_in_rec.name );
4069: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.put_messages', p_in_rec.put_messages);
4070: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.manual_flag ', p_in_rec.manual_flag );
4071: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.caller ', p_in_rec.caller );
4064: IF l_debug_on THEN
4065: wsh_debug_sv.push(l_module_name);
4066: --
4067: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.trip_id ', p_in_rec.trip_id );
4068: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.name ', p_in_rec.name );
4069: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.put_messages', p_in_rec.put_messages);
4070: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.manual_flag ', p_in_rec.manual_flag );
4071: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.caller ', p_in_rec.caller );
4072: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.actual_date ', p_in_rec.actual_date );
4065: wsh_debug_sv.push(l_module_name);
4066: --
4067: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.trip_id ', p_in_rec.trip_id );
4068: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.name ', p_in_rec.name );
4069: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.put_messages', p_in_rec.put_messages);
4070: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.manual_flag ', p_in_rec.manual_flag );
4071: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.caller ', p_in_rec.caller );
4072: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.actual_date ', p_in_rec.actual_date );
4073: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.stop_id ', p_in_rec.stop_id );
4066: --
4067: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.trip_id ', p_in_rec.trip_id );
4068: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.name ', p_in_rec.name );
4069: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.put_messages', p_in_rec.put_messages);
4070: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.manual_flag ', p_in_rec.manual_flag );
4071: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.caller ', p_in_rec.caller );
4072: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.actual_date ', p_in_rec.actual_date );
4073: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.stop_id ', p_in_rec.stop_id );
4074: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.linked_stop_id ', p_in_rec.linked_stop_id );
4067: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.trip_id ', p_in_rec.trip_id );
4068: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.name ', p_in_rec.name );
4069: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.put_messages', p_in_rec.put_messages);
4070: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.manual_flag ', p_in_rec.manual_flag );
4071: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.caller ', p_in_rec.caller );
4072: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.actual_date ', p_in_rec.actual_date );
4073: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.stop_id ', p_in_rec.stop_id );
4074: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.linked_stop_id ', p_in_rec.linked_stop_id );
4075: END IF;
4068: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.name ', p_in_rec.name );
4069: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.put_messages', p_in_rec.put_messages);
4070: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.manual_flag ', p_in_rec.manual_flag );
4071: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.caller ', p_in_rec.caller );
4072: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.actual_date ', p_in_rec.actual_date );
4073: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.stop_id ', p_in_rec.stop_id );
4074: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.linked_stop_id ', p_in_rec.linked_stop_id );
4075: END IF;
4076: --
4069: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.put_messages', p_in_rec.put_messages);
4070: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.manual_flag ', p_in_rec.manual_flag );
4071: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.caller ', p_in_rec.caller );
4072: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.actual_date ', p_in_rec.actual_date );
4073: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.stop_id ', p_in_rec.stop_id );
4074: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.linked_stop_id ', p_in_rec.linked_stop_id );
4075: END IF;
4076: --
4077: --
4070: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.manual_flag ', p_in_rec.manual_flag );
4071: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.caller ', p_in_rec.caller );
4072: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.actual_date ', p_in_rec.actual_date );
4073: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.stop_id ', p_in_rec.stop_id );
4074: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.linked_stop_id ', p_in_rec.linked_stop_id );
4075: END IF;
4076: --
4077: --
4078: l_num_warnings := 0;
4097: --
4098:
4099: -- Check for Exceptions against the Trip
4100: IF l_debug_on THEN
4101: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.Check_Exceptions',WSH_DEBUG_SV.C_PROC_LEVEL);
4102: END IF;
4103: l_exceptions_tab.delete;
4104: l_exp_logged := FALSE;
4105: l_exp_warning := FALSE;
4213: --
4214: -- Debug Statements
4215: --
4216: IF l_debug_on THEN
4217: WSH_DEBUG_SV.pop(l_module_name);
4218: END IF;
4219: --
4220: --}
4221: EXCEPTION
4230: --
4231: --
4232: --
4233: IF l_debug_on THEN
4234: WSH_DEBUG_SV.logmsg(l_module_name,'e_not_allowed exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4235: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:e_not_allowed');
4236: END IF;
4237: --
4238: WHEN wsh_util_core.e_not_allowed_warning THEN
4231: --
4232: --
4233: IF l_debug_on THEN
4234: WSH_DEBUG_SV.logmsg(l_module_name,'e_not_allowed exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4235: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:e_not_allowed');
4236: END IF;
4237: --
4238: WHEN wsh_util_core.e_not_allowed_warning THEN
4239: IF l_num_warnings > 0
4246: x_allowed := 'NW';
4247: --
4248: --
4249: IF l_debug_on THEN
4250: WSH_DEBUG_SV.logmsg(l_module_name,'e_not_allowed_warning exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4251: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:e_not_allowed_warning');
4252: END IF;
4253: --
4254: WHEN FND_API.G_EXC_ERROR THEN
4247: --
4248: --
4249: IF l_debug_on THEN
4250: WSH_DEBUG_SV.logmsg(l_module_name,'e_not_allowed_warning exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4251: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:e_not_allowed_warning');
4252: END IF;
4253: --
4254: WHEN FND_API.G_EXC_ERROR THEN
4255:
4255:
4256: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4257: --
4258: IF l_debug_on THEN
4259: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4260: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4261: END IF;
4262: --
4263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4256: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4257: --
4258: IF l_debug_on THEN
4259: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4260: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4261: END IF;
4262: --
4263: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4264:
4264:
4265: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4266: --
4267: IF l_debug_on THEN
4268: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4269: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4270: END IF;
4271: --
4272: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
4265: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4266: --
4267: IF l_debug_on THEN
4268: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4269: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4270: END IF;
4271: --
4272: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
4273: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4272: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
4273: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4274: --
4275: IF l_debug_on THEN
4276: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4277: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
4278: END IF;
4279: --
4280: WHEN OTHERS THEN
4273: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4274: --
4275: IF l_debug_on THEN
4276: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4277: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
4278: END IF;
4279: --
4280: WHEN OTHERS THEN
4281:
4282: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4283: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.check_Close',l_module_name);
4284: --
4285: IF l_debug_on THEN
4286: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4287: END IF;
4288: --
4289: --}
4290: END check_Close;
4353: --
4354: l_debug_on := wsh_debug_interface.g_debug;
4355: --
4356: IF l_debug_on IS NULL THEN
4357: l_debug_on := wsh_debug_sv.is_debug_enabled;
4358: END IF;
4359: --
4360: IF l_debug_on THEN
4361: wsh_debug_sv.push(l_module_name);
4357: l_debug_on := wsh_debug_sv.is_debug_enabled;
4358: END IF;
4359: --
4360: IF l_debug_on THEN
4361: wsh_debug_sv.push(l_module_name);
4362: --
4363: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.trip_id ', p_in_rec.trip_id );
4364: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.name ', p_in_rec.name );
4365: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.put_messages', p_in_rec.put_messages);
4359: --
4360: IF l_debug_on THEN
4361: wsh_debug_sv.push(l_module_name);
4362: --
4363: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.trip_id ', p_in_rec.trip_id );
4364: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.name ', p_in_rec.name );
4365: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.put_messages', p_in_rec.put_messages);
4366: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.manual_flag ', p_in_rec.manual_flag );
4367: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.caller ', p_in_rec.caller );
4360: IF l_debug_on THEN
4361: wsh_debug_sv.push(l_module_name);
4362: --
4363: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.trip_id ', p_in_rec.trip_id );
4364: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.name ', p_in_rec.name );
4365: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.put_messages', p_in_rec.put_messages);
4366: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.manual_flag ', p_in_rec.manual_flag );
4367: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.caller ', p_in_rec.caller );
4368: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.actual_date ', p_in_rec.actual_date );
4361: wsh_debug_sv.push(l_module_name);
4362: --
4363: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.trip_id ', p_in_rec.trip_id );
4364: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.name ', p_in_rec.name );
4365: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.put_messages', p_in_rec.put_messages);
4366: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.manual_flag ', p_in_rec.manual_flag );
4367: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.caller ', p_in_rec.caller );
4368: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.actual_date ', p_in_rec.actual_date );
4369: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.stop_id ', p_in_rec.stop_id );
4362: --
4363: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.trip_id ', p_in_rec.trip_id );
4364: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.name ', p_in_rec.name );
4365: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.put_messages', p_in_rec.put_messages);
4366: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.manual_flag ', p_in_rec.manual_flag );
4367: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.caller ', p_in_rec.caller );
4368: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.actual_date ', p_in_rec.actual_date );
4369: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.stop_id ', p_in_rec.stop_id );
4370: END IF;
4363: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.trip_id ', p_in_rec.trip_id );
4364: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.name ', p_in_rec.name );
4365: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.put_messages', p_in_rec.put_messages);
4366: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.manual_flag ', p_in_rec.manual_flag );
4367: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.caller ', p_in_rec.caller );
4368: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.actual_date ', p_in_rec.actual_date );
4369: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.stop_id ', p_in_rec.stop_id );
4370: END IF;
4371: --
4364: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.name ', p_in_rec.name );
4365: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.put_messages', p_in_rec.put_messages);
4366: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.manual_flag ', p_in_rec.manual_flag );
4367: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.caller ', p_in_rec.caller );
4368: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.actual_date ', p_in_rec.actual_date );
4369: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.stop_id ', p_in_rec.stop_id );
4370: END IF;
4371: --
4372: --
4365: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.put_messages', p_in_rec.put_messages);
4366: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.manual_flag ', p_in_rec.manual_flag );
4367: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.caller ', p_in_rec.caller );
4368: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.actual_date ', p_in_rec.actual_date );
4369: wsh_debug_sv.LOG(l_module_name, 'p_in_rec.stop_id ', p_in_rec.stop_id );
4370: END IF;
4371: --
4372: --
4373: l_num_warnings := 0;
4396: --
4397:
4398: -- Check for Exceptions against the Trip
4399: IF l_debug_on THEN
4400: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_XC_UTIL.Check_Exceptions',WSH_DEBUG_SV.C_PROC_LEVEL);
4401: END IF;
4402: l_exceptions_tab.delete;
4403: l_exp_logged := FALSE;
4404: l_exp_warning := FALSE;
4506: --
4507: -- Debug Statements
4508: --
4509: IF l_debug_on THEN
4510: WSH_DEBUG_SV.pop(l_module_name);
4511: END IF;
4512: --
4513: --}
4514: EXCEPTION
4524: x_allowed := 'N';
4525: --
4526: --
4527: IF l_debug_on THEN
4528: WSH_DEBUG_SV.logmsg(l_module_name,'e_not_allowed exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4529: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:e_not_allowed');
4530: END IF;
4531: --
4532: WHEN wsh_util_core.e_not_allowed_warning THEN
4525: --
4526: --
4527: IF l_debug_on THEN
4528: WSH_DEBUG_SV.logmsg(l_module_name,'e_not_allowed exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4529: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:e_not_allowed');
4530: END IF;
4531: --
4532: WHEN wsh_util_core.e_not_allowed_warning THEN
4533: IF l_num_warnings > 0
4540: x_allowed := 'NW';
4541: --
4542: --
4543: IF l_debug_on THEN
4544: WSH_DEBUG_SV.logmsg(l_module_name,'e_not_allowed_warning exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4545: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:e_not_allowed_warning');
4546: END IF;
4547: --
4548: WHEN FND_API.G_EXC_ERROR THEN
4541: --
4542: --
4543: IF l_debug_on THEN
4544: WSH_DEBUG_SV.logmsg(l_module_name,'e_not_allowed_warning exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4545: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:e_not_allowed_warning');
4546: END IF;
4547: --
4548: WHEN FND_API.G_EXC_ERROR THEN
4549:
4549:
4550: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4551: --
4552: IF l_debug_on THEN
4553: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4554: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4555: END IF;
4556: --
4557: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4550: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4551: --
4552: IF l_debug_on THEN
4553: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4554: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4555: END IF;
4556: --
4557: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4558:
4558:
4559: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4560: --
4561: IF l_debug_on THEN
4562: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4563: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4564: END IF;
4565: --
4566: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
4559: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4560: --
4561: IF l_debug_on THEN
4562: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4563: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4564: END IF;
4565: --
4566: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
4567: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4566: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
4567: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4568: --
4569: IF l_debug_on THEN
4570: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4571: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
4572: END IF;
4573: --
4574: WHEN OTHERS THEN
4567: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4568: --
4569: IF l_debug_on THEN
4570: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4571: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
4572: END IF;
4573: --
4574: WHEN OTHERS THEN
4575:
4576: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4577: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.check_inTransit',l_module_name);
4578: --
4579: IF l_debug_on THEN
4580: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4581: END IF;
4582: --
4583: --}
4584: END check_inTransit;
4627: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
4628: --
4629: IF l_debug_on IS NULL
4630: THEN
4631: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4632: END IF;
4633: --
4634: IF l_debug_on THEN
4635: WSH_DEBUG_SV.push(l_module_name);
4631: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4632: END IF;
4633: --
4634: IF l_debug_on THEN
4635: WSH_DEBUG_SV.push(l_module_name);
4636: WSH_DEBUG_SV.log(l_module_name,'p_trip_id',p_trip_id);
4637: WSH_DEBUG_SV.log(l_module_name,'p_action',p_action);
4638: END IF;
4639: --
4632: END IF;
4633: --
4634: IF l_debug_on THEN
4635: WSH_DEBUG_SV.push(l_module_name);
4636: WSH_DEBUG_SV.log(l_module_name,'p_trip_id',p_trip_id);
4637: WSH_DEBUG_SV.log(l_module_name,'p_action',p_action);
4638: END IF;
4639: --
4640: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4633: --
4634: IF l_debug_on THEN
4635: WSH_DEBUG_SV.push(l_module_name);
4636: WSH_DEBUG_SV.log(l_module_name,'p_trip_id',p_trip_id);
4637: WSH_DEBUG_SV.log(l_module_name,'p_action',p_action);
4638: END IF;
4639: --
4640: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4641: --
4660: --}
4661: END IF;
4662: --
4663: IF l_debug_on THEN
4664: WSH_DEBUG_SV.pop(l_module_name);
4665: END IF;
4666: --}
4667: EXCEPTION
4668: --{
4672: FND_MESSAGE.SET_TOKEN('TRIP_NAME', l_trip_rec.name);
4673: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
4674: --
4675: IF l_debug_on THEN
4676: WSH_DEBUG_SV.logmsg(l_module_name,'e_not_allowed exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4677: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:e_not_allowed');
4678: END IF;
4679: --
4680: WHEN OTHERS THEN
4673: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
4674: --
4675: IF l_debug_on THEN
4676: WSH_DEBUG_SV.logmsg(l_module_name,'e_not_allowed exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4677: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:e_not_allowed');
4678: END IF;
4679: --
4680: WHEN OTHERS THEN
4681: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4680: WHEN OTHERS THEN
4681: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4682: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.validate_trip_status', l_module_name);
4683: IF l_debug_on THEN
4684: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4685: END IF;
4686: --}
4687: END validate_trip_status;
4688: --
4748: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
4749: --
4750: IF l_debug_on IS NULL
4751: THEN
4752: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4753: END IF;
4754: --
4755: IF l_debug_on THEN
4756: WSH_DEBUG_SV.push(l_module_name);
4752: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4753: END IF;
4754: --
4755: IF l_debug_on THEN
4756: WSH_DEBUG_SV.push(l_module_name);
4757: WSH_DEBUG_SV.log(l_module_name,'p_trip_id',p_trip_id);
4758: WSH_DEBUG_SV.log(l_module_name,'p_stop_id',p_stop_id);
4759: END IF;
4760: --
4753: END IF;
4754: --
4755: IF l_debug_on THEN
4756: WSH_DEBUG_SV.push(l_module_name);
4757: WSH_DEBUG_SV.log(l_module_name,'p_trip_id',p_trip_id);
4758: WSH_DEBUG_SV.log(l_module_name,'p_stop_id',p_stop_id);
4759: END IF;
4760: --
4761: --
4754: --
4755: IF l_debug_on THEN
4756: WSH_DEBUG_SV.push(l_module_name);
4757: WSH_DEBUG_SV.log(l_module_name,'p_trip_id',p_trip_id);
4758: WSH_DEBUG_SV.log(l_module_name,'p_stop_id',p_stop_id);
4759: END IF;
4760: --
4761: --
4762: l_cnt := 0;
4771: END IF;
4772: --
4773: --
4774: IF l_debug_on THEN
4775: WSH_DEBUG_SV.log(l_module_name,'l_cnt',l_cnt);
4776: WSH_DEBUG_SV.pop(l_module_name);
4777: END IF;
4778: --
4779: IF l_cnt = 1
4772: --
4773: --
4774: IF l_debug_on THEN
4775: WSH_DEBUG_SV.log(l_module_name,'l_cnt',l_cnt);
4776: WSH_DEBUG_SV.pop(l_module_name);
4777: END IF;
4778: --
4779: IF l_cnt = 1
4780: THEN
4788: WHEN OTHERS THEN
4789: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.has_outbound_deliveries', l_module_name);
4790: --
4791: IF l_debug_on THEN
4792: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4793: END IF;
4794: --
4795: RAISE;
4796: --}
4858: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
4859: --
4860: IF l_debug_on IS NULL
4861: THEN
4862: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4863: END IF;
4864: --
4865: IF l_debug_on THEN
4866: WSH_DEBUG_SV.push(l_module_name);
4862: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4863: END IF;
4864: --
4865: IF l_debug_on THEN
4866: WSH_DEBUG_SV.push(l_module_name);
4867: WSH_DEBUG_SV.log(l_module_name,'p_trip_id',p_trip_id);
4868: WSH_DEBUG_SV.log(l_module_name,'p_stop_id',p_stop_id);
4869: END IF;
4870: --
4863: END IF;
4864: --
4865: IF l_debug_on THEN
4866: WSH_DEBUG_SV.push(l_module_name);
4867: WSH_DEBUG_SV.log(l_module_name,'p_trip_id',p_trip_id);
4868: WSH_DEBUG_SV.log(l_module_name,'p_stop_id',p_stop_id);
4869: END IF;
4870: --
4871: --
4864: --
4865: IF l_debug_on THEN
4866: WSH_DEBUG_SV.push(l_module_name);
4867: WSH_DEBUG_SV.log(l_module_name,'p_trip_id',p_trip_id);
4868: WSH_DEBUG_SV.log(l_module_name,'p_stop_id',p_stop_id);
4869: END IF;
4870: --
4871: --
4872: l_cnt := 0;
4880: --}
4881: END IF;
4882: --
4883: IF l_debug_on THEN
4884: WSH_DEBUG_SV.log(l_module_name,'l_cnt',l_cnt);
4885: WSH_DEBUG_SV.pop(l_module_name);
4886: END IF;
4887: --
4888: IF l_cnt = 1
4881: END IF;
4882: --
4883: IF l_debug_on THEN
4884: WSH_DEBUG_SV.log(l_module_name,'l_cnt',l_cnt);
4885: WSH_DEBUG_SV.pop(l_module_name);
4886: END IF;
4887: --
4888: IF l_cnt = 1
4889: THEN
4898: WHEN OTHERS THEN
4899: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.has_inbound_deliveries', l_module_name);
4900: --
4901: IF l_debug_on THEN
4902: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4903: END IF;
4904: --
4905: RAISE;
4906: --}
4956: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
4957: --
4958: IF l_debug_on IS NULL
4959: THEN
4960: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4961: END IF;
4962: --
4963: IF l_debug_on THEN
4964: WSH_DEBUG_SV.push(l_module_name);
4960: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4961: END IF;
4962: --
4963: IF l_debug_on THEN
4964: WSH_DEBUG_SV.push(l_module_name);
4965: WSH_DEBUG_SV.log(l_module_name,'p_trip_id',p_trip_id);
4966: WSH_DEBUG_SV.log(l_module_name,'p_stop_id',p_stop_id);
4967: END IF;
4968: --
4961: END IF;
4962: --
4963: IF l_debug_on THEN
4964: WSH_DEBUG_SV.push(l_module_name);
4965: WSH_DEBUG_SV.log(l_module_name,'p_trip_id',p_trip_id);
4966: WSH_DEBUG_SV.log(l_module_name,'p_stop_id',p_stop_id);
4967: END IF;
4968: --
4969: --
4962: --
4963: IF l_debug_on THEN
4964: WSH_DEBUG_SV.push(l_module_name);
4965: WSH_DEBUG_SV.log(l_module_name,'p_trip_id',p_trip_id);
4966: WSH_DEBUG_SV.log(l_module_name,'p_stop_id',p_stop_id);
4967: END IF;
4968: --
4969: --
4970: l_has_mixed_deliveries := 'N';
4972: IF (p_trip_id IS NOT NULL)
4973: THEN
4974: --{
4975: IF l_debug_on THEN
4976: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_VALIDATIONS.has_outbound_deliveries',WSH_DEBUG_SV.C_PROC_LEVEL);
4977: END IF;
4978: --
4979: --
4980: l_has_outbound_deliveries := WSH_TRIP_VALIDATIONS.has_outbound_deliveries
4984: );
4985: --
4986: --
4987: IF l_debug_on THEN
4988: WSH_DEBUG_SV.log(l_module_name,'l_has_outbound_deliveries',l_has_outbound_deliveries);
4989: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_VALIDATIONS.has_inbound_deliveries',WSH_DEBUG_SV.C_PROC_LEVEL);
4990: END IF;
4991: --
4992: l_has_inbound_deliveries := WSH_TRIP_VALIDATIONS.has_inbound_deliveries
4985: --
4986: --
4987: IF l_debug_on THEN
4988: WSH_DEBUG_SV.log(l_module_name,'l_has_outbound_deliveries',l_has_outbound_deliveries);
4989: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_VALIDATIONS.has_inbound_deliveries',WSH_DEBUG_SV.C_PROC_LEVEL);
4990: END IF;
4991: --
4992: l_has_inbound_deliveries := WSH_TRIP_VALIDATIONS.has_inbound_deliveries
4993: (
5012: END IF;
5013: --
5014: --
5015: IF l_debug_on THEN
5016: WSH_DEBUG_SV.log(l_module_name,'l_has_inbound_deliveries',l_has_inbound_deliveries);
5017: WSH_DEBUG_SV.log(l_module_name,'l_has_mixed_deliveries',l_has_mixed_deliveries);
5018: WSH_DEBUG_SV.pop(l_module_name);
5019: END IF;
5020: --
5013: --
5014: --
5015: IF l_debug_on THEN
5016: WSH_DEBUG_SV.log(l_module_name,'l_has_inbound_deliveries',l_has_inbound_deliveries);
5017: WSH_DEBUG_SV.log(l_module_name,'l_has_mixed_deliveries',l_has_mixed_deliveries);
5018: WSH_DEBUG_SV.pop(l_module_name);
5019: END IF;
5020: --
5021: RETURN(l_has_mixed_deliveries);
5014: --
5015: IF l_debug_on THEN
5016: WSH_DEBUG_SV.log(l_module_name,'l_has_inbound_deliveries',l_has_inbound_deliveries);
5017: WSH_DEBUG_SV.log(l_module_name,'l_has_mixed_deliveries',l_has_mixed_deliveries);
5018: WSH_DEBUG_SV.pop(l_module_name);
5019: END IF;
5020: --
5021: RETURN(l_has_mixed_deliveries);
5022: --}
5025: WHEN OTHERS THEN
5026: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.has_mixed_deliveries', l_module_name);
5027: --
5028: IF l_debug_on THEN
5029: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5030: END IF;
5031: --
5032: RAISE;
5033: --}
5054: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
5055: --
5056: IF l_debug_on IS NULL
5057: THEN
5058: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
5059: END IF;
5060: --
5061: IF l_debug_on THEN
5062: --
5059: END IF;
5060: --
5061: IF l_debug_on THEN
5062: --
5063: WSH_DEBUG_SV.push(l_module_name);
5064: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.caller',p_in_rec.caller);
5065: --
5066: END IF;
5067: --
5060: --
5061: IF l_debug_on THEN
5062: --
5063: WSH_DEBUG_SV.push(l_module_name);
5064: WSH_DEBUG_SV.log(l_module_name,'p_in_rec.caller',p_in_rec.caller);
5065: --
5066: END IF;
5067: --
5068: x_return_status := FND_API.G_RET_STS_SUCCESS;
5759: END IF;
5760:
5761:
5762: IF l_debug_on THEN
5763: WSH_DEBUG_SV.log(l_module_name,'l_attributes',l_attributes);
5764: WSH_DEBUG_SV.log(l_module_name,'length(l_attributes)',length(l_attributes));
5765: END IF;
5766:
5767:
5760:
5761:
5762: IF l_debug_on THEN
5763: WSH_DEBUG_SV.log(l_module_name,'l_attributes',l_attributes);
5764: WSH_DEBUG_SV.log(l_module_name,'length(l_attributes)',length(l_attributes));
5765: END IF;
5766:
5767:
5768: IF l_attributes IS NULL THEN
5767:
5768: IF l_attributes IS NULL THEN
5769: --no message to be shown to the user
5770: IF l_debug_on THEN
5771: WSH_DEBUG_SV.pop(l_module_name);
5772: END IF;
5773: RETURN;
5774: --
5775: ELSE
5783: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
5784: THEN
5785: x_return_status := l_return_status;
5786: IF l_debug_on THEN
5787: wsh_debug_sv.logmsg(l_module_name,'Error returned by wsh_utilities.process_message',WSH_DEBUG_SV.C_PROC_LEVEL);
5788: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5789: wsh_debug_sv.pop(l_module_name);
5790: END IF;
5791: return;
5784: THEN
5785: x_return_status := l_return_status;
5786: IF l_debug_on THEN
5787: wsh_debug_sv.logmsg(l_module_name,'Error returned by wsh_utilities.process_message',WSH_DEBUG_SV.C_PROC_LEVEL);
5788: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5789: wsh_debug_sv.pop(l_module_name);
5790: END IF;
5791: return;
5792: ELSE
5785: x_return_status := l_return_status;
5786: IF l_debug_on THEN
5787: wsh_debug_sv.logmsg(l_module_name,'Error returned by wsh_utilities.process_message',WSH_DEBUG_SV.C_PROC_LEVEL);
5788: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5789: wsh_debug_sv.pop(l_module_name);
5790: END IF;
5791: return;
5792: ELSE
5793: x_return_status := wsh_util_core.G_RET_STS_WARNING;
5796:
5797:
5798:
5799: IF l_debug_on THEN
5800: WSH_DEBUG_SV.pop(l_module_name);
5801: END IF;
5802: --
5803:
5804:
5806: WHEN OTHERS THEN
5807: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
5808: --
5809: IF l_debug_on THEN
5810: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5811: END IF;
5812: --
5813: END user_non_updatable_columns;
5814:
5952: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
5953: --
5954:
5955: IF l_debug_on IS NULL THEN
5956: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
5957: END IF;
5958:
5959: --
5960: IF l_debug_on THEN
5957: END IF;
5958:
5959: --
5960: IF l_debug_on THEN
5961: WSH_DEBUG_SV.push(l_module_name);
5962: WSH_DEBUG_SV.log(l_module_name,'Trip ID ', p_trip_id);
5963: END IF;
5964:
5965: -- SSN Change
5958:
5959: --
5960: IF l_debug_on THEN
5961: WSH_DEBUG_SV.push(l_module_name);
5962: WSH_DEBUG_SV.log(l_module_name,'Trip ID ', p_trip_id);
5963: END IF;
5964:
5965: -- SSN Change
5966: -- Date validations are applicable only for Profile option = PAD and not if it is set to SSN
5965: -- SSN Change
5966: -- Date validations are applicable only for Profile option = PAD and not if it is set to SSN
5967: IF WSH_TRIPS_ACTIONS.GET_STOP_SEQ_MODE = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_SSN THEN
5968: IF l_debug_on THEN
5969: WSH_DEBUG_SV.logmsg(l_module_name,'Stop Sequence Mode is SSN');
5970: WSH_DEBUG_SV.pop(l_module_name);
5971: END IF;
5972: RETURN; -- these validations are not required for profile option of SSN
5973: END IF;
5966: -- Date validations are applicable only for Profile option = PAD and not if it is set to SSN
5967: IF WSH_TRIPS_ACTIONS.GET_STOP_SEQ_MODE = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_SSN THEN
5968: IF l_debug_on THEN
5969: WSH_DEBUG_SV.logmsg(l_module_name,'Stop Sequence Mode is SSN');
5970: WSH_DEBUG_SV.pop(l_module_name);
5971: END IF;
5972: RETURN; -- these validations are not required for profile option of SSN
5973: END IF;
5974:
5986: CLOSE get_invalid_planned_dates;
5987:
5988: -- Bug 3782135
5989: IF l_debug_on THEN
5990: WSH_DEBUG_SV.log(l_module_name,'Before Validating Arrival Dates',p_trip_id);
5991: END IF;
5992:
5993: OPEN get_invalid_plarrival_dates;
5994: FETCH get_invalid_plarrival_dates
5995: INTO l_invalid_plarrival_date;
5996: l_found := get_invalid_plarrival_dates%FOUND;
5997: CLOSE get_invalid_plarrival_dates;
5998: IF l_debug_on THEN
5999: WSH_DEBUG_SV.log(l_module_name,'After Validating Arrival Dates',p_trip_id);
6000: END IF;
6001:
6002: IF l_found THEN
6003: IF l_debug_on THEN
6000: END IF;
6001:
6002: IF l_found THEN
6003: IF l_debug_on THEN
6004: WSH_DEBUG_SV.log(l_module_name,'Stop ID',l_invalid_plarrival_date.cur_stop_id);
6005: WSH_DEBUG_SV.log(l_module_name,'Seq',l_invalid_plarrival_date.cur_stop_seq_num);
6006: END IF;
6007: raise invalid_arrival_date;
6008: END IF;
6001:
6002: IF l_found THEN
6003: IF l_debug_on THEN
6004: WSH_DEBUG_SV.log(l_module_name,'Stop ID',l_invalid_plarrival_date.cur_stop_id);
6005: WSH_DEBUG_SV.log(l_module_name,'Seq',l_invalid_plarrival_date.cur_stop_seq_num);
6006: END IF;
6007: raise invalid_arrival_date;
6008: END IF;
6009: -- End of Bug 3782135
6020: i := l_del_to_unassign.first;
6021: WHILE i is not NULL LOOP
6022:
6023: IF l_debug_on THEN
6024: WSH_DEBUG_SV.logmsg(l_module_name,'unassign delivery '|| l_del_to_unassign(i));
6025: END IF;
6026:
6027: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_UNASSIGN_TRIP');
6028: FND_MESSAGE.SET_TOKEN('DELIVERY_NAME',
6035: i := l_del_to_unassign.next(i);
6036: END LOOP;
6037:
6038: IF l_debug_on THEN
6039: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.UNASSIGN_TRIP',WSH_DEBUG_SV.C_PROC_LEVEL);
6040: END IF;
6041:
6042: WSH_TRIPS_ACTIONS.unassign_trip
6043: (p_del_rows => l_del_to_unassign,
6046:
6047: IF l_return_status in (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
6048: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6049: IF l_debug_on THEN
6050: WSH_DEBUG_SV.pop(l_module_name);
6051: END IF;
6052: return;
6053: ELSIF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
6054: l_num_warn := l_num_warn + 1;
6069: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
6070: END IF;
6071:
6072: IF l_debug_on THEN
6073: WSH_DEBUG_SV.pop(l_module_name);
6074: END IF;
6075:
6076: EXCEPTION
6077:
6079: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6080: FND_MESSAGE.SET_NAME('WSH', 'WSH_TRIP_ID_REQUIRED');
6081: wsh_util_core.add_message(x_return_status, l_module_name);
6082: IF l_debug_on THEN
6083: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR: Trip ID is NULL');
6084: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_input');
6085: END IF;
6086:
6087: WHEN invalid_stop_date THEN
6080: FND_MESSAGE.SET_NAME('WSH', 'WSH_TRIP_ID_REQUIRED');
6081: wsh_util_core.add_message(x_return_status, l_module_name);
6082: IF l_debug_on THEN
6083: WSH_DEBUG_SV.logmsg(l_module_name,'ERROR: Trip ID is NULL');
6084: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_input');
6085: END IF;
6086:
6087: WHEN invalid_stop_date THEN
6088: IF get_invalid_planned_dates%ISOPEN THEN
6107: END IF;
6108: wsh_util_core.add_message(x_return_status, l_module_name);
6109:
6110: IF l_debug_on THEN
6111: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_stop_date');
6112: END IF;
6113:
6114: -- Bug 3782135
6115: WHEN invalid_arrival_date THEN
6119: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(l_invalid_plarrival_date.cur_stop_id,p_caller));
6120: wsh_util_core.add_message(wsh_util_core.g_ret_sts_error, l_module_name);
6121:
6122: IF l_debug_on THEN
6123: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_planned_arrival_date');
6124: END IF;
6125:
6126: -- End of Bug 3782135
6127: WHEN Others THEN
6139: END IF;
6140: wsh_util_core.default_handler('WSH_TRIP_STOPS_VALIDATIONS.Validate_Stop_Dates',l_module_name);
6141: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6142: IF l_debug_on THEN
6143: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
6144: END IF;
6145:
6146: END Validate_Stop_Dates;
6147: