92: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
93: --
94: IF l_debug_on IS NULL
95: THEN
96: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
97: END IF;
98: --
99: IF l_debug_on THEN
100: wsh_debug_sv.push(l_module_name);
96: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
97: END IF;
98: --
99: IF l_debug_on THEN
100: wsh_debug_sv.push(l_module_name);
101: WSH_DEBUG_SV.log(l_module_name,'action_code',p_stop_IN_rec.action_code);
102: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',p_init_msg_list );
103: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
104: WSH_DEBUG_SV.log(l_module_name,'trip_id', p_stop_info.trip_id);
97: END IF;
98: --
99: IF l_debug_on THEN
100: wsh_debug_sv.push(l_module_name);
101: WSH_DEBUG_SV.log(l_module_name,'action_code',p_stop_IN_rec.action_code);
102: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',p_init_msg_list );
103: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
104: WSH_DEBUG_SV.log(l_module_name,'trip_id', p_stop_info.trip_id);
105: WSH_DEBUG_SV.log(l_module_name,'trip_id', p_stop_info.trip_id);
98: --
99: IF l_debug_on THEN
100: wsh_debug_sv.push(l_module_name);
101: WSH_DEBUG_SV.log(l_module_name,'action_code',p_stop_IN_rec.action_code);
102: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',p_init_msg_list );
103: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
104: WSH_DEBUG_SV.log(l_module_name,'trip_id', p_stop_info.trip_id);
105: WSH_DEBUG_SV.log(l_module_name,'trip_id', p_stop_info.trip_id);
106: WSH_DEBUG_SV.log(l_module_name,'stop_location_id', p_stop_info.stop_location_id);
99: IF l_debug_on THEN
100: wsh_debug_sv.push(l_module_name);
101: WSH_DEBUG_SV.log(l_module_name,'action_code',p_stop_IN_rec.action_code);
102: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',p_init_msg_list );
103: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
104: WSH_DEBUG_SV.log(l_module_name,'trip_id', p_stop_info.trip_id);
105: WSH_DEBUG_SV.log(l_module_name,'trip_id', p_stop_info.trip_id);
106: WSH_DEBUG_SV.log(l_module_name,'stop_location_id', p_stop_info.stop_location_id);
107: WSH_DEBUG_SV.log(l_module_name,'planned_arrival_date', p_stop_info.planned_arrival_date);
100: wsh_debug_sv.push(l_module_name);
101: WSH_DEBUG_SV.log(l_module_name,'action_code',p_stop_IN_rec.action_code);
102: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',p_init_msg_list );
103: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
104: WSH_DEBUG_SV.log(l_module_name,'trip_id', p_stop_info.trip_id);
105: WSH_DEBUG_SV.log(l_module_name,'trip_id', p_stop_info.trip_id);
106: WSH_DEBUG_SV.log(l_module_name,'stop_location_id', p_stop_info.stop_location_id);
107: WSH_DEBUG_SV.log(l_module_name,'planned_arrival_date', p_stop_info.planned_arrival_date);
108: WSH_DEBUG_SV.log(l_module_name,'planned_departure_date', p_stop_info.planned_departure_date);
101: WSH_DEBUG_SV.log(l_module_name,'action_code',p_stop_IN_rec.action_code);
102: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',p_init_msg_list );
103: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
104: WSH_DEBUG_SV.log(l_module_name,'trip_id', p_stop_info.trip_id);
105: WSH_DEBUG_SV.log(l_module_name,'trip_id', p_stop_info.trip_id);
106: WSH_DEBUG_SV.log(l_module_name,'stop_location_id', p_stop_info.stop_location_id);
107: WSH_DEBUG_SV.log(l_module_name,'planned_arrival_date', p_stop_info.planned_arrival_date);
108: WSH_DEBUG_SV.log(l_module_name,'planned_departure_date', p_stop_info.planned_departure_date);
109: END IF;
102: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',p_init_msg_list );
103: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
104: WSH_DEBUG_SV.log(l_module_name,'trip_id', p_stop_info.trip_id);
105: WSH_DEBUG_SV.log(l_module_name,'trip_id', p_stop_info.trip_id);
106: WSH_DEBUG_SV.log(l_module_name,'stop_location_id', p_stop_info.stop_location_id);
107: WSH_DEBUG_SV.log(l_module_name,'planned_arrival_date', p_stop_info.planned_arrival_date);
108: WSH_DEBUG_SV.log(l_module_name,'planned_departure_date', p_stop_info.planned_departure_date);
109: END IF;
110:
103: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
104: WSH_DEBUG_SV.log(l_module_name,'trip_id', p_stop_info.trip_id);
105: WSH_DEBUG_SV.log(l_module_name,'trip_id', p_stop_info.trip_id);
106: WSH_DEBUG_SV.log(l_module_name,'stop_location_id', p_stop_info.stop_location_id);
107: WSH_DEBUG_SV.log(l_module_name,'planned_arrival_date', p_stop_info.planned_arrival_date);
108: WSH_DEBUG_SV.log(l_module_name,'planned_departure_date', p_stop_info.planned_departure_date);
109: END IF;
110:
111: -- Standard call to check for call compatibility
104: WSH_DEBUG_SV.log(l_module_name,'trip_id', p_stop_info.trip_id);
105: WSH_DEBUG_SV.log(l_module_name,'trip_id', p_stop_info.trip_id);
106: WSH_DEBUG_SV.log(l_module_name,'stop_location_id', p_stop_info.stop_location_id);
107: WSH_DEBUG_SV.log(l_module_name,'planned_arrival_date', p_stop_info.planned_arrival_date);
108: WSH_DEBUG_SV.log(l_module_name,'planned_departure_date', p_stop_info.planned_departure_date);
109: END IF;
110:
111: -- Standard call to check for call compatibility
112: IF NOT FND_API.Compatible_API_Call
156: l_stop_location_id,
157: p_stop_info.planned_departure_date,
158: l_return_status);
159: IF l_debug_on THEN
160: WSH_DEBUG_SV.log(l_module_name,'l_stop_id', l_stop_id);
161: END IF;
162:
163: wsh_util_core.api_post_call(p_return_status =>l_return_status,
164: x_num_warnings =>l_num_warning,
191: , p_count => x_msg_count
192: , p_data => x_msg_data
193: );
194: IF l_debug_on THEN
195: WSH_DEBUG_SV.pop(l_module_name);
196: END IF;
197: EXCEPTION
198:
199: WHEN FND_API.G_EXC_ERROR THEN
207: , p_count => x_msg_count
208: , p_data => x_msg_data
209: );
210: IF l_debug_on THEN
211: WSH_DEBUG_SV.log(l_module_name,'l_stop_id', l_stop_id);
212: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:G_EXC_ERROR ');
213: END IF;
214:
215:
208: , p_data => x_msg_data
209: );
210: IF l_debug_on THEN
211: WSH_DEBUG_SV.log(l_module_name,'l_stop_id', l_stop_id);
212: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:G_EXC_ERROR ');
213: END IF;
214:
215:
216: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
225: , p_count => x_msg_count
226: , p_data => x_msg_data
227: );
228: IF l_debug_on THEN
229: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
230: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
231: END IF;
232:
233: WHEN OTHERS THEN
226: , p_data => x_msg_data
227: );
228: IF l_debug_on THEN
229: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
230: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
231: END IF;
232:
233: WHEN OTHERS THEN
234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
245: , p_count => x_msg_count
246: , p_data => x_msg_data
247: );
248: IF l_debug_on THEN
249: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
250: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
251: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
252: END IF;
253: END Stop_Action_New;
246: , p_data => x_msg_data
247: );
248: IF l_debug_on THEN
249: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
250: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
251: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
252: END IF;
253: END Stop_Action_New;
254:
247: );
248: IF l_debug_on THEN
249: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
250: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
251: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
252: END IF;
253: END Stop_Action_New;
254:
255:
329: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
330: --
331: IF l_debug_on IS NULL
332: THEN
333: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
334: END IF;
335: --
336: IF l_debug_on THEN
337: wsh_debug_sv.push (l_module_name);
333: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
334: END IF;
335: --
336: IF l_debug_on THEN
337: wsh_debug_sv.push (l_module_name);
338: wsh_debug_sv.log (l_module_name,'p_action_code',p_action_code);
339: wsh_debug_sv.log (l_module_name,'p_stop_id',p_stop_id);
340: wsh_debug_sv.log (l_module_name,'p_trip_id',p_trip_id);
341: wsh_debug_sv.log (l_module_name,'p_trip_name',p_trip_name);
334: END IF;
335: --
336: IF l_debug_on THEN
337: wsh_debug_sv.push (l_module_name);
338: wsh_debug_sv.log (l_module_name,'p_action_code',p_action_code);
339: wsh_debug_sv.log (l_module_name,'p_stop_id',p_stop_id);
340: wsh_debug_sv.log (l_module_name,'p_trip_id',p_trip_id);
341: wsh_debug_sv.log (l_module_name,'p_trip_name',p_trip_name);
342: wsh_debug_sv.log (l_module_name,'p_stop_location_id',p_stop_location_id);
335: --
336: IF l_debug_on THEN
337: wsh_debug_sv.push (l_module_name);
338: wsh_debug_sv.log (l_module_name,'p_action_code',p_action_code);
339: wsh_debug_sv.log (l_module_name,'p_stop_id',p_stop_id);
340: wsh_debug_sv.log (l_module_name,'p_trip_id',p_trip_id);
341: wsh_debug_sv.log (l_module_name,'p_trip_name',p_trip_name);
342: wsh_debug_sv.log (l_module_name,'p_stop_location_id',p_stop_location_id);
343: wsh_debug_sv.log (l_module_name,'p_stop_location_code',p_stop_location_code);
336: IF l_debug_on THEN
337: wsh_debug_sv.push (l_module_name);
338: wsh_debug_sv.log (l_module_name,'p_action_code',p_action_code);
339: wsh_debug_sv.log (l_module_name,'p_stop_id',p_stop_id);
340: wsh_debug_sv.log (l_module_name,'p_trip_id',p_trip_id);
341: wsh_debug_sv.log (l_module_name,'p_trip_name',p_trip_name);
342: wsh_debug_sv.log (l_module_name,'p_stop_location_id',p_stop_location_id);
343: wsh_debug_sv.log (l_module_name,'p_stop_location_code',p_stop_location_code);
344: wsh_debug_sv.log (l_module_name,'p_planned_dep_date',p_planned_dep_date);
337: wsh_debug_sv.push (l_module_name);
338: wsh_debug_sv.log (l_module_name,'p_action_code',p_action_code);
339: wsh_debug_sv.log (l_module_name,'p_stop_id',p_stop_id);
340: wsh_debug_sv.log (l_module_name,'p_trip_id',p_trip_id);
341: wsh_debug_sv.log (l_module_name,'p_trip_name',p_trip_name);
342: wsh_debug_sv.log (l_module_name,'p_stop_location_id',p_stop_location_id);
343: wsh_debug_sv.log (l_module_name,'p_stop_location_code',p_stop_location_code);
344: wsh_debug_sv.log (l_module_name,'p_planned_dep_date',p_planned_dep_date);
345: wsh_debug_sv.log (l_module_name,'p_actual_date',p_actual_date);
338: wsh_debug_sv.log (l_module_name,'p_action_code',p_action_code);
339: wsh_debug_sv.log (l_module_name,'p_stop_id',p_stop_id);
340: wsh_debug_sv.log (l_module_name,'p_trip_id',p_trip_id);
341: wsh_debug_sv.log (l_module_name,'p_trip_name',p_trip_name);
342: wsh_debug_sv.log (l_module_name,'p_stop_location_id',p_stop_location_id);
343: wsh_debug_sv.log (l_module_name,'p_stop_location_code',p_stop_location_code);
344: wsh_debug_sv.log (l_module_name,'p_planned_dep_date',p_planned_dep_date);
345: wsh_debug_sv.log (l_module_name,'p_actual_date',p_actual_date);
346: wsh_debug_sv.log (l_module_name,'p_defer_interface_flag',p_defer_interface_flag);
339: wsh_debug_sv.log (l_module_name,'p_stop_id',p_stop_id);
340: wsh_debug_sv.log (l_module_name,'p_trip_id',p_trip_id);
341: wsh_debug_sv.log (l_module_name,'p_trip_name',p_trip_name);
342: wsh_debug_sv.log (l_module_name,'p_stop_location_id',p_stop_location_id);
343: wsh_debug_sv.log (l_module_name,'p_stop_location_code',p_stop_location_code);
344: wsh_debug_sv.log (l_module_name,'p_planned_dep_date',p_planned_dep_date);
345: wsh_debug_sv.log (l_module_name,'p_actual_date',p_actual_date);
346: wsh_debug_sv.log (l_module_name,'p_defer_interface_flag',p_defer_interface_flag);
347: END IF;
340: wsh_debug_sv.log (l_module_name,'p_trip_id',p_trip_id);
341: wsh_debug_sv.log (l_module_name,'p_trip_name',p_trip_name);
342: wsh_debug_sv.log (l_module_name,'p_stop_location_id',p_stop_location_id);
343: wsh_debug_sv.log (l_module_name,'p_stop_location_code',p_stop_location_code);
344: wsh_debug_sv.log (l_module_name,'p_planned_dep_date',p_planned_dep_date);
345: wsh_debug_sv.log (l_module_name,'p_actual_date',p_actual_date);
346: wsh_debug_sv.log (l_module_name,'p_defer_interface_flag',p_defer_interface_flag);
347: END IF;
348:
341: wsh_debug_sv.log (l_module_name,'p_trip_name',p_trip_name);
342: wsh_debug_sv.log (l_module_name,'p_stop_location_id',p_stop_location_id);
343: wsh_debug_sv.log (l_module_name,'p_stop_location_code',p_stop_location_code);
344: wsh_debug_sv.log (l_module_name,'p_planned_dep_date',p_planned_dep_date);
345: wsh_debug_sv.log (l_module_name,'p_actual_date',p_actual_date);
346: wsh_debug_sv.log (l_module_name,'p_defer_interface_flag',p_defer_interface_flag);
347: END IF;
348:
349: -- Standard call to check for call compatibility
342: wsh_debug_sv.log (l_module_name,'p_stop_location_id',p_stop_location_id);
343: wsh_debug_sv.log (l_module_name,'p_stop_location_code',p_stop_location_code);
344: wsh_debug_sv.log (l_module_name,'p_planned_dep_date',p_planned_dep_date);
345: wsh_debug_sv.log (l_module_name,'p_actual_date',p_actual_date);
346: wsh_debug_sv.log (l_module_name,'p_defer_interface_flag',p_defer_interface_flag);
347: END IF;
348:
349: -- Standard call to check for call compatibility
350: IF NOT FND_API.Compatible_API_Call
394: l_stop_location_id,
395: p_planned_dep_date,
396: l_return_status);
397: IF l_debug_on THEN
398: WSH_DEBUG_SV.log(l_module_name,'l_stop_id', l_stop_id);
399: END IF;
400:
401: wsh_util_core.api_post_call(p_return_status =>l_return_status,
402: x_num_warnings =>l_num_warning,
428: , p_count => x_msg_count
429: , p_data => x_msg_data
430: );
431: IF l_debug_on THEN
432: wsh_debug_sv.pop (l_module_name);
433: END IF;
434: EXCEPTION
435:
436: WHEN FND_API.G_EXC_ERROR THEN
445: , p_count => x_msg_count
446: , p_data => x_msg_data
447: );
448: IF l_debug_on THEN
449: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
450: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
451: END IF;
452:
453: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
446: , p_data => x_msg_data
447: );
448: IF l_debug_on THEN
449: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
450: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
451: END IF;
452:
453: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
462: , p_count => x_msg_count
463: , p_data => x_msg_data
464: );
465: IF l_debug_on THEN
466: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
467: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
468: END IF;
469:
470: WHEN OTHERS THEN
463: , p_data => x_msg_data
464: );
465: IF l_debug_on THEN
466: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
467: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
468: END IF;
469:
470: WHEN OTHERS THEN
471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
482: , p_count => x_msg_count
483: , p_data => x_msg_data
484: );
485: IF l_debug_on THEN
486: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
487: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
488: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
489: END IF;
490:
483: , p_data => x_msg_data
484: );
485: IF l_debug_on THEN
486: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
487: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
488: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
489: END IF;
490:
491: END Stop_Action;
484: );
485: IF l_debug_on THEN
486: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
487: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
488: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
489: END IF;
490:
491: END Stop_Action;
492:
605: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
606: --
607: IF l_debug_on IS NULL
608: THEN
609: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
610: END IF;
611: --
612: SAVEPOINT s_stop_action_grp;
613: IF l_debug_on THEN
610: END IF;
611: --
612: SAVEPOINT s_stop_action_grp;
613: IF l_debug_on THEN
614: wsh_debug_sv.push (l_module_name);
615: wsh_debug_sv.log (l_module_name,'p_api_version_number',
616: p_api_version_number);
617: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);
618: wsh_debug_sv.log (l_module_name,'p_commit',p_commit);
611: --
612: SAVEPOINT s_stop_action_grp;
613: IF l_debug_on THEN
614: wsh_debug_sv.push (l_module_name);
615: wsh_debug_sv.log (l_module_name,'p_api_version_number',
616: p_api_version_number);
617: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);
618: wsh_debug_sv.log (l_module_name,'p_commit',p_commit);
619: wsh_debug_sv.log (l_module_name,'action_code',p_action_prms.action_code);
613: IF l_debug_on THEN
614: wsh_debug_sv.push (l_module_name);
615: wsh_debug_sv.log (l_module_name,'p_api_version_number',
616: p_api_version_number);
617: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);
618: wsh_debug_sv.log (l_module_name,'p_commit',p_commit);
619: wsh_debug_sv.log (l_module_name,'action_code',p_action_prms.action_code);
620: wsh_debug_sv.log (l_module_name,'caller',p_action_prms.caller);
621: wsh_debug_sv.log (l_module_name,'COUNT',p_rec_attr_tab.COUNT);
614: wsh_debug_sv.push (l_module_name);
615: wsh_debug_sv.log (l_module_name,'p_api_version_number',
616: p_api_version_number);
617: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);
618: wsh_debug_sv.log (l_module_name,'p_commit',p_commit);
619: wsh_debug_sv.log (l_module_name,'action_code',p_action_prms.action_code);
620: wsh_debug_sv.log (l_module_name,'caller',p_action_prms.caller);
621: wsh_debug_sv.log (l_module_name,'COUNT',p_rec_attr_tab.COUNT);
622: END IF;
615: wsh_debug_sv.log (l_module_name,'p_api_version_number',
616: p_api_version_number);
617: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);
618: wsh_debug_sv.log (l_module_name,'p_commit',p_commit);
619: wsh_debug_sv.log (l_module_name,'action_code',p_action_prms.action_code);
620: wsh_debug_sv.log (l_module_name,'caller',p_action_prms.caller);
621: wsh_debug_sv.log (l_module_name,'COUNT',p_rec_attr_tab.COUNT);
622: END IF;
623:
616: p_api_version_number);
617: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);
618: wsh_debug_sv.log (l_module_name,'p_commit',p_commit);
619: wsh_debug_sv.log (l_module_name,'action_code',p_action_prms.action_code);
620: wsh_debug_sv.log (l_module_name,'caller',p_action_prms.caller);
621: wsh_debug_sv.log (l_module_name,'COUNT',p_rec_attr_tab.COUNT);
622: END IF;
623:
624: IF FND_API.to_Boolean(p_init_msg_list) THEN
617: wsh_debug_sv.log (l_module_name,'p_init_msg_list',p_init_msg_list);
618: wsh_debug_sv.log (l_module_name,'p_commit',p_commit);
619: wsh_debug_sv.log (l_module_name,'action_code',p_action_prms.action_code);
620: wsh_debug_sv.log (l_module_name,'caller',p_action_prms.caller);
621: wsh_debug_sv.log (l_module_name,'COUNT',p_rec_attr_tab.COUNT);
622: END IF;
623:
624: IF FND_API.to_Boolean(p_init_msg_list) THEN
625: FND_MSG_PUB.initialize;
685: --
686: END IF;
687:
688: IF l_debug_on THEN
689: wsh_debug_sv.log (l_module_name,'stop_id',
690: p_rec_attr_tab(l_next).stop_id);
691: wsh_debug_sv.log (l_module_name,'status_code',
692: p_rec_attr_tab(l_next).status_code);
693: END IF;
687:
688: IF l_debug_on THEN
689: wsh_debug_sv.log (l_module_name,'stop_id',
690: p_rec_attr_tab(l_next).stop_id);
691: wsh_debug_sv.log (l_module_name,'status_code',
692: p_rec_attr_tab(l_next).status_code);
693: END IF;
694: l_next := p_rec_attr_tab.NEXT(l_next);
695: END LOOP;
719: p_stop_location_id => NULL, -- not needed
720: p_planned_dep_date => NULL, -- not needed
721: x_return_status => l_return_status);
722: IF l_debug_on THEN
723: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_Stop_Name l_return_status',l_return_status);
724: END IF;
725: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
726: x_num_warnings =>l_num_warning,
727: x_num_errors =>l_num_errors);
777: wsh_util_core.add_message(x_return_status,l_module_name);
778: END IF;
779: --
780: IF l_debug_on THEN
781: wsh_debug_sv.logmsg(l_module_name, 'WSH_DISABLE_ACTION');
782: END IF;
783: --
784: RAISE FND_API.G_EXC_ERROR;
785: --}
785: --}
786: END IF;
787:
788: IF l_debug_on THEN
789: wsh_debug_sv.log (l_module_name,'l_num_warning',l_num_warning);
790: END IF;
791:
792:
793: IF l_num_warning > 0 AND p_action_prms.caller = 'WSH_FSTRX' THEN
794: x_stop_out_rec.selection_issue_flag := 'Y';
795: END IF;
796:
797: IF l_debug_on THEN
798: wsh_debug_sv.log (l_module_name,'C_STOP_DEFAULTS_LVL', WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_STOP_DEFAULTS_LVL));
799: END IF;
800:
801: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_STOP_DEFAULTS_LVL)=1 THEN
802: IF l_status_code = 'OP' THEN
810: --Bugfix 4070732 { Phase 1 just call the rest API
811: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
812: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
813: IF l_debug_on THEN
814: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
815: END IF;
816:
817: WSH_UTIL_CORE.reset_stops_for_load_tender(
818: p_reset_flags => TRUE,
818: p_reset_flags => TRUE,
819: x_return_status => x_return_status);
820:
821: IF l_debug_on THEN
822: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
823: END IF;
824: END IF;
825: END IF;
826: --}
824: END IF;
825: END IF;
826: --}
827: IF l_debug_on THEN
828: WSH_DEBUG_SV.pop(l_module_name);
829: END IF;
830: RETURN;
831: END IF;
832: ELSIF l_status_code = 'AR' THEN
840: --Bugfix 4070732 { Phase one just call the reset API
841: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
842: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
843: IF l_debug_on THEN
844: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
845: END IF;
846: WSH_UTIL_CORE.reset_stops_for_load_tender(
847: p_reset_flags => TRUE,
848: x_return_status => x_return_status);
847: p_reset_flags => TRUE,
848: x_return_status => x_return_status);
849:
850: IF l_debug_on THEN
851: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
852: END IF;
853:
854: END IF;
855: END IF;
854: END IF;
855: END IF;
856: --}
857: IF l_debug_on THEN
858: WSH_DEBUG_SV.pop(l_module_name);
859: END IF;
860: RETURN;
861: END IF;
862: END IF;
869: FND_MESSAGE.SET_NAME('WSH', 'WSH_DISABLE_ACTION_WARN');
870: wsh_util_core.add_message(x_return_status,l_module_name);
871: --
872: IF l_debug_on THEN
873: wsh_debug_sv.logmsg(l_module_name, 'WSH_DISABLE_ACTION_WARN');
874: END IF;
875: --
876: IF p_action_prms.caller = 'WSH_FSTRX' THEN
877: RAISE WSH_UTIL_CORE.G_EXC_WARNING;
891: l_return_status := NULL;
892: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
893: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
894: IF l_debug_on THEN
895: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
896: END IF;
897: WSH_UTIL_CORE.reset_stops_for_load_tender(
898: p_reset_flags => TRUE,
899: x_return_status => x_return_status);
898: p_reset_flags => TRUE,
899: x_return_status => x_return_status);
900:
901: IF l_debug_on THEN
902: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
903: END IF;
904:
905: END IF;
906: END IF;
939: x_return_status => l_return_status);
940:
941:
942: IF l_debug_on THEN
943: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_constraint_main',l_return_status);
944: wsh_debug_sv.log(l_module_name,'validate_result After Calling validate_constraint_main',l_cc_validate_result);
945: wsh_debug_sv.log(l_module_name,'msg_count After Calling validate_constraint_main',l_msg_count);
946: wsh_debug_sv.log(l_module_name,'msg_data After Calling validate_constraint_main',l_msg_data);
947: wsh_debug_sv.log(l_module_name,'fail_ids count After Calling validate_constraint_main',l_cc_fail_ids.COUNT);
940:
941:
942: IF l_debug_on THEN
943: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_constraint_main',l_return_status);
944: wsh_debug_sv.log(l_module_name,'validate_result After Calling validate_constraint_main',l_cc_validate_result);
945: wsh_debug_sv.log(l_module_name,'msg_count After Calling validate_constraint_main',l_msg_count);
946: wsh_debug_sv.log(l_module_name,'msg_data After Calling validate_constraint_main',l_msg_data);
947: wsh_debug_sv.log(l_module_name,'fail_ids count After Calling validate_constraint_main',l_cc_fail_ids.COUNT);
948: END IF;
941:
942: IF l_debug_on THEN
943: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_constraint_main',l_return_status);
944: wsh_debug_sv.log(l_module_name,'validate_result After Calling validate_constraint_main',l_cc_validate_result);
945: wsh_debug_sv.log(l_module_name,'msg_count After Calling validate_constraint_main',l_msg_count);
946: wsh_debug_sv.log(l_module_name,'msg_data After Calling validate_constraint_main',l_msg_data);
947: wsh_debug_sv.log(l_module_name,'fail_ids count After Calling validate_constraint_main',l_cc_fail_ids.COUNT);
948: END IF;
949: --
942: IF l_debug_on THEN
943: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_constraint_main',l_return_status);
944: wsh_debug_sv.log(l_module_name,'validate_result After Calling validate_constraint_main',l_cc_validate_result);
945: wsh_debug_sv.log(l_module_name,'msg_count After Calling validate_constraint_main',l_msg_count);
946: wsh_debug_sv.log(l_module_name,'msg_data After Calling validate_constraint_main',l_msg_data);
947: wsh_debug_sv.log(l_module_name,'fail_ids count After Calling validate_constraint_main',l_cc_fail_ids.COUNT);
948: END IF;
949: --
950:
943: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_constraint_main',l_return_status);
944: wsh_debug_sv.log(l_module_name,'validate_result After Calling validate_constraint_main',l_cc_validate_result);
945: wsh_debug_sv.log(l_module_name,'msg_count After Calling validate_constraint_main',l_msg_count);
946: wsh_debug_sv.log(l_module_name,'msg_data After Calling validate_constraint_main',l_msg_data);
947: wsh_debug_sv.log(l_module_name,'fail_ids count After Calling validate_constraint_main',l_cc_fail_ids.COUNT);
948: END IF;
949: --
950:
951: IF l_return_status=wsh_util_core.g_ret_sts_error THEN
952: --fix l_rec_attr_tab to have only successful records
953: l_cc_count_success:=1;
954:
955: IF l_debug_on THEN
956: wsh_debug_sv.log(l_module_name,'l_stop_id_tab.count before removing failed lines',l_stop_id_tab.COUNT);
957: END IF;
958:
959: IF l_cc_fail_ids.COUNT>0 AND l_stop_id_tab.COUNT>0 THEN
960:
973: --
974: -- Debug Statements
975: --
976: IF l_debug_on THEN
977: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
978: END IF;
979: --tkt
980: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(l_cc_fail_ids(j),p_action_prms.caller));
981: wsh_util_core.add_message(l_return_status);
997: -- csun 10+ internal location change
998: l_delete_tmp_tab := l_delete_t;
999: ELSE
1000: IF l_debug_on THEN
1001: wsh_debug_sv.logmsg(l_module_name,'all lines errored in compatibility check');
1002: END IF;
1003: wsh_util_core.api_post_call(
1004: p_return_status => l_return_status,
1005: x_num_warnings => l_num_warning,
1038: x_valid_ids_tab => l_stop_id_tab,
1039: x_return_status => l_return_status);
1040:
1041: if l_debug_on then
1042: wsh_debug_sv.log(l_module_name, 'l_stop_id_tab count', l_stop_id_tab.count);
1043: end if;
1044:
1045: wsh_util_core.api_post_call( p_return_status =>l_return_status,
1046: x_num_warnings =>l_num_warning,
1089: IF l_report_set_id IS NULL THEN
1090: FND_MESSAGE.SET_NAME('WSH','WSH_DOC_MISSING');
1091: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1092: IF l_debug_on THEN
1093: wsh_debug_sv.log (l_module_name,'WSH_DOC_MISSING');
1094: END IF;
1095: RAISE FND_API.G_EXC_ERROR;
1096: END IF;
1097: WSH_UTIL_VALIDATE.validate_report_set(
1155:
1156: ELSIF p_action_prms.action_code = 'UPDATE-STATUS' THEN
1157:
1158: IF l_debug_on THEN
1159: wsh_debug_sv.log (l_module_name,'stop_action',
1160: p_action_prms.stop_action);
1161: wsh_debug_sv.log (l_module_name,'actual_date',
1162: p_action_prms.actual_date);
1163: wsh_debug_sv.log (l_module_name,'defer_interface_flag',
1157:
1158: IF l_debug_on THEN
1159: wsh_debug_sv.log (l_module_name,'stop_action',
1160: p_action_prms.stop_action);
1161: wsh_debug_sv.log (l_module_name,'actual_date',
1162: p_action_prms.actual_date);
1163: wsh_debug_sv.log (l_module_name,'defer_interface_flag',
1164: p_action_prms.defer_interface_flag);
1165: wsh_debug_sv.log (l_module_name,'C_TRIP_STOP_VALIDATION_LVL',WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_TRIP_STOP_VALIDATION_LVL));
1159: wsh_debug_sv.log (l_module_name,'stop_action',
1160: p_action_prms.stop_action);
1161: wsh_debug_sv.log (l_module_name,'actual_date',
1162: p_action_prms.actual_date);
1163: wsh_debug_sv.log (l_module_name,'defer_interface_flag',
1164: p_action_prms.defer_interface_flag);
1165: wsh_debug_sv.log (l_module_name,'C_TRIP_STOP_VALIDATION_LVL',WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_TRIP_STOP_VALIDATION_LVL));
1166: END IF;
1167:
1161: wsh_debug_sv.log (l_module_name,'actual_date',
1162: p_action_prms.actual_date);
1163: wsh_debug_sv.log (l_module_name,'defer_interface_flag',
1164: p_action_prms.defer_interface_flag);
1165: wsh_debug_sv.log (l_module_name,'C_TRIP_STOP_VALIDATION_LVL',WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_TRIP_STOP_VALIDATION_LVL));
1166: END IF;
1167:
1168: -- BUG 4247388 - FP:11I10-12.0: if actual date is NULL, always default to SYSDATE here
1169: -- (whether updating status to Arrived or Closed) to ensure that
1172: -- with their initial pick up stops' actual departure dates.
1173: l_actual_date := NVL(p_action_prms.actual_date, SYSDATE);
1174:
1175: IF l_debug_on THEN
1176: wsh_debug_sv.log (l_module_name,'l_actual_date', l_actual_date);
1177: END IF;
1178:
1179:
1180: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_TRIP_STOP_VALIDATION_LVL) = 1
1210: EXCEPTION
1211: WHEN FND_API.G_EXC_ERROR THEN
1212: ROLLBACK TO s_clean_loop_grp;
1213: IF l_debug_on THEN
1214: wsh_debug_sv.log (l_module_name,'G_EXC_ERROR in the loop');
1215: END IF;
1216: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1217: ROLLBACK TO s_clean_loop_grp;
1218: IF l_debug_on THEN
1215: END IF;
1216: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1217: ROLLBACK TO s_clean_loop_grp;
1218: IF l_debug_on THEN
1219: wsh_debug_sv.log (l_module_name,
1220: 'G_EXC_UNEXPECTED_ERROR in the loop');
1221: END IF;
1222: END;
1223: END LOOP;
1223: END LOOP;
1224:
1225: IF l_num_errors >= l_stop_id_tab.COUNT THEN
1226: IF l_debug_on THEN
1227: wsh_debug_sv.log (l_module_name,'All failed in the loop');
1228: END IF;
1229: RAISE FND_API.G_EXC_ERROR;
1230: END IF;
1231:
1230: END IF;
1231:
1232: IF l_num_errors >0 THEN
1233: IF l_debug_on THEN
1234: wsh_debug_sv.log (l_module_name,'l_num_errors',l_num_errors);
1235: END IF;
1236: l_num_warning := l_num_warning + l_num_errors;
1237: l_num_errors := 0;
1238: END IF;
1241: --
1242: END IF;
1243: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_CHK_UPDATE_STATUS_LVL) = 1 THEN
1244: if l_debug_on then
1245: wsh_debug_sv.log(l_module_name, 'l_stop_id_tab count', l_stop_id_tab.count);
1246: end if;
1247: WSH_TRIP_STOPS_ACTIONS.Check_Update_Stops(
1248: p_stop_rows => l_stop_id_tab,
1249: p_action => p_action_prms.stop_action,
1274: IF( WSH_UTIL_CORE.FTE_Is_Installed = 'Y') THEN
1275: IF l_stop_id_tab.count > 0 THEN
1276: --
1277: IF l_debug_on THEN
1278: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
1279: END IF;
1280: --
1281: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
1282: p_entity_type => 'STOP',
1337: OPEN c_check_trip_close(l_trip_affected_tab(i));
1338: FETCH c_check_trip_close INTO l_trip_in_rec.trip_id;
1339: IF c_check_trip_close%FOUND THEN
1340: IF l_debug_on THEN
1341: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.CHANGESTATUS',WSH_DEBUG_SV.C_PROC_LEVEL);
1342: WSH_DEBUG_SV.log(l_module_name,'Trip',l_trip_in_rec.trip_id);
1343: END IF;
1344:
1345: wsh_trips_actions.changeStatus
1338: FETCH c_check_trip_close INTO l_trip_in_rec.trip_id;
1339: IF c_check_trip_close%FOUND THEN
1340: IF l_debug_on THEN
1341: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.CHANGESTATUS',WSH_DEBUG_SV.C_PROC_LEVEL);
1342: WSH_DEBUG_SV.log(l_module_name,'Trip',l_trip_in_rec.trip_id);
1343: END IF;
1344:
1345: wsh_trips_actions.changeStatus
1346: (
1363: IF p_rec_attr_tab.COUNT > 1 THEN
1364: FND_MESSAGE.SET_NAME('WSH','WSH_UI_MULTI_SELECTION');
1365: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1366: IF l_debug_on THEN
1367: wsh_debug_sv.log (l_module_name,'WSH_UI_MULTI_SELECTION');
1368: END IF;
1369: RAISE FND_API.G_EXC_ERROR;
1370: ELSIF p_rec_attr_tab.COUNT = 1
1371: AND p_action_prms.caller <> 'WSH_FSTRX' THEN
1372: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_ACTION_CODE');
1373: FND_MESSAGE.SET_TOKEN('ACT_CODE',p_action_prms.action_code );
1374: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1375: IF l_debug_on THEN
1376: wsh_debug_sv.log (l_module_name,'WSH_INVALID_ACTION_CODE COUNT');
1377: END IF;
1378: RAISE FND_API.G_EXC_ERROR;
1379: END IF;
1380:
1383: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_ACTION_CODE');
1384: FND_MESSAGE.SET_TOKEN('ACT_CODE',p_action_prms.action_code );
1385: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1386: IF l_debug_on THEN
1387: wsh_debug_sv.log (l_module_name,'WSH_INVALID_ACTION_CODE');
1388: END IF;
1389: RAISE FND_API.G_EXC_ERROR;
1390: END IF;
1391:
1401: p_action_prms => p_action_prms,
1402: p_rec_attr_tab => p_rec_attr_tab);
1403:
1404: IF l_debug_on THEN
1405: WSH_DEBUG_SV.log(l_module_name,'after calling stop_callback l_return_status',l_return_status);
1406: END IF;
1407:
1408: wsh_util_core.api_post_call(
1409: p_return_status => l_return_status,
1418: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
1419: THEN
1420: --{
1421: IF l_debug_on THEN
1422: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);
1423: END IF;
1424:
1425: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
1426: (
1430: );
1431: --
1432: --
1433: IF l_debug_on THEN
1434: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
1435: END IF;
1436: --
1437: --
1438: WSH_UTIL_CORE.API_POST_CALL
1458: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1459: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1460:
1461: IF l_debug_on THEN
1462: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1463: END IF;
1464:
1465: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => FALSE,
1466: x_return_status => l_return_status);
1465: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => FALSE,
1466: x_return_status => l_return_status);
1467:
1468: IF l_debug_on THEN
1469: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1470: END IF;
1471:
1472: END IF;
1473:
1495:
1496: IF p_commit = FND_API.G_TRUE THEN
1497:
1498: IF l_debug_on THEN
1499: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1500: END IF;
1501: WSH_UTIL_CORE.reset_stops_for_load_tender(
1502: p_reset_flags => TRUE,
1503: x_return_status => l_return_status);
1503: x_return_status => l_return_status);
1504: ELSE
1505:
1506: IF l_debug_on THEN
1507: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1508: END IF;
1509: WSH_UTIL_CORE.Process_stops_for_load_tender(
1510: p_reset_flags => TRUE,
1511: x_return_status => l_return_status);
1511: x_return_status => l_return_status);
1512: END IF;
1513:
1514: IF l_debug_on THEN
1515: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1516: END IF;
1517:
1518: --
1519: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1553: , p_encoded => FND_API.G_FALSE
1554: );
1555:
1556: IF l_debug_on THEN
1557: WSH_DEBUG_SV.pop(l_module_name);
1558: END IF;
1559:
1560: EXCEPTION
1561: WHEN FND_API.G_EXC_ERROR THEN
1567: --Bugfix 4070732 {
1568: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1569: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1570: IF l_debug_on THEN
1571: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1572: END IF;
1573:
1574: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1575: x_return_status => l_return_status);
1575: x_return_status => l_return_status);
1576:
1577:
1578: IF l_debug_on THEN
1579: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1580: END IF;
1581: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1582: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1583: END IF;
1590: , p_data => x_msg_data
1591: , p_encoded => FND_API.G_FALSE
1592: );
1593: IF l_debug_on THEN
1594: wsh_debug_sv.log (l_module_name,'G_EXC_ERROR');
1595: WSH_DEBUG_SV.pop(l_module_name);
1596: END IF;
1597: WHEN e_req_field THEN
1598: ROLLBACK TO s_stop_action_grp;
1591: , p_encoded => FND_API.G_FALSE
1592: );
1593: IF l_debug_on THEN
1594: wsh_debug_sv.log (l_module_name,'G_EXC_ERROR');
1595: WSH_DEBUG_SV.pop(l_module_name);
1596: END IF;
1597: WHEN e_req_field THEN
1598: ROLLBACK TO s_stop_action_grp;
1599: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1601: --Bugfix 4070732 {
1602: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1603: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1604: IF l_debug_on THEN
1605: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1606: END IF;
1607:
1608: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1609: x_return_status => l_return_status);
1609: x_return_status => l_return_status);
1610:
1611:
1612: IF l_debug_on THEN
1613: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1614: END IF;
1615:
1616: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1617: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1624: , p_data => x_msg_data
1625: , p_encoded => FND_API.G_FALSE
1626: );
1627: IF l_debug_on THEN
1628: wsh_debug_sv.log (l_module_name,'G_EXC_ERROR');
1629: WSH_DEBUG_SV.pop(l_module_name);
1630: END IF;
1631: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1632: ROLLBACK TO s_stop_action_grp;
1625: , p_encoded => FND_API.G_FALSE
1626: );
1627: IF l_debug_on THEN
1628: wsh_debug_sv.log (l_module_name,'G_EXC_ERROR');
1629: WSH_DEBUG_SV.pop(l_module_name);
1630: END IF;
1631: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1632: ROLLBACK TO s_stop_action_grp;
1633: IF c_check_trip_close%ISOPEN THEN
1637: --Bugfix 4070732 {
1638: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1639: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1640: IF l_debug_on THEN
1641: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1642: END IF;
1643:
1644: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1645: x_return_status => l_return_status);
1645: x_return_status => l_return_status);
1646:
1647:
1648: IF l_debug_on THEN
1649: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1650: END IF;
1651:
1652: END IF;
1653: END IF;
1658: , p_data => x_msg_data
1659: , p_encoded => FND_API.G_FALSE
1660: );
1661: IF l_debug_on THEN
1662: wsh_debug_sv.log (l_module_name,'G_EXC_UNEXPECTED_ERROR');
1663: WSH_DEBUG_SV.pop(l_module_name);
1664: END IF;
1665: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1666: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1659: , p_encoded => FND_API.G_FALSE
1660: );
1661: IF l_debug_on THEN
1662: wsh_debug_sv.log (l_module_name,'G_EXC_UNEXPECTED_ERROR');
1663: WSH_DEBUG_SV.pop(l_module_name);
1664: END IF;
1665: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1666: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1667: --Bugfix 4070732 {
1671: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
1672: THEN
1673: --{
1674: IF l_debug_on THEN
1675: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);
1676: END IF;
1677:
1678: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
1679: (
1683: );
1684: --
1685: --
1686: IF l_debug_on THEN
1687: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
1688: END IF;
1689: --
1690: --
1691: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
1699: --
1700: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1701: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1702: IF l_debug_on THEN
1703: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1704: END IF;
1705:
1706: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => TRUE,
1707: x_return_status => l_return_status);
1706: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => TRUE,
1707: x_return_status => l_return_status);
1708:
1709: IF l_debug_on THEN
1710: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1711: END IF;
1712:
1713: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)
1714: OR (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
1724: , p_data => x_msg_data
1725: , p_encoded => FND_API.G_FALSE
1726: );
1727: IF l_debug_on THEN
1728: wsh_debug_sv.log (l_module_name,'G_EXC_WARNING');
1729: WSH_DEBUG_SV.pop(l_module_name);
1730: END IF;
1731: WHEN OTHERS THEN
1732: ROLLBACK TO s_stop_action_grp;
1725: , p_encoded => FND_API.G_FALSE
1726: );
1727: IF l_debug_on THEN
1728: wsh_debug_sv.log (l_module_name,'G_EXC_WARNING');
1729: WSH_DEBUG_SV.pop(l_module_name);
1730: END IF;
1731: WHEN OTHERS THEN
1732: ROLLBACK TO s_stop_action_grp;
1733: IF c_check_trip_close%ISOPEN THEN
1741: --Bugfix 4070732 {
1742: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
1743: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
1744: IF l_debug_on THEN
1745: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
1746: END IF;
1747:
1748: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
1749: x_return_status => l_return_status);
1749: x_return_status => l_return_status);
1750:
1751:
1752: IF l_debug_on THEN
1753: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
1754: END IF;
1755:
1756: END IF;
1757: END IF;
1761: , p_data => x_msg_data
1762: , p_encoded => FND_API.G_FALSE
1763: );
1764: IF l_debug_on THEN
1765: wsh_debug_sv.log (l_module_name,'Others',substr(sqlerrm,1,200));
1766: WSH_DEBUG_SV.pop(l_module_name);
1767: END IF;
1768:
1769: END Stop_Action;
1762: , p_encoded => FND_API.G_FALSE
1763: );
1764: IF l_debug_on THEN
1765: wsh_debug_sv.log (l_module_name,'Others',substr(sqlerrm,1,200));
1766: WSH_DEBUG_SV.pop(l_module_name);
1767: END IF;
1768:
1769: END Stop_Action;
1770:
1790: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1791: --
1792: IF l_debug_on IS NULL
1793: THEN
1794: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1795: END IF;
1796: --
1797: IF l_debug_on THEN
1798: WSH_DEBUG_SV.push(l_module_name);
1794: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1795: END IF;
1796: --
1797: IF l_debug_on THEN
1798: WSH_DEBUG_SV.push(l_module_name);
1799: WSH_DEBUG_SV.log(l_module_name,'p_grp_stop_rec.STOP_ID',p_grp_stop_rec.STOP_ID);
1800: WSH_DEBUG_SV.log(l_module_name,'p_grp_stop_rec.TRIP_ID',p_grp_stop_rec.TRIP_ID);
1801: WSH_DEBUG_SV.log(l_module_name,'p_grp_stop_rec.TRIP_NAME',p_grp_stop_rec.TRIP_NAME);
1802: END IF;
1795: END IF;
1796: --
1797: IF l_debug_on THEN
1798: WSH_DEBUG_SV.push(l_module_name);
1799: WSH_DEBUG_SV.log(l_module_name,'p_grp_stop_rec.STOP_ID',p_grp_stop_rec.STOP_ID);
1800: WSH_DEBUG_SV.log(l_module_name,'p_grp_stop_rec.TRIP_ID',p_grp_stop_rec.TRIP_ID);
1801: WSH_DEBUG_SV.log(l_module_name,'p_grp_stop_rec.TRIP_NAME',p_grp_stop_rec.TRIP_NAME);
1802: END IF;
1803:
1796: --
1797: IF l_debug_on THEN
1798: WSH_DEBUG_SV.push(l_module_name);
1799: WSH_DEBUG_SV.log(l_module_name,'p_grp_stop_rec.STOP_ID',p_grp_stop_rec.STOP_ID);
1800: WSH_DEBUG_SV.log(l_module_name,'p_grp_stop_rec.TRIP_ID',p_grp_stop_rec.TRIP_ID);
1801: WSH_DEBUG_SV.log(l_module_name,'p_grp_stop_rec.TRIP_NAME',p_grp_stop_rec.TRIP_NAME);
1802: END IF;
1803:
1804: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1797: IF l_debug_on THEN
1798: WSH_DEBUG_SV.push(l_module_name);
1799: WSH_DEBUG_SV.log(l_module_name,'p_grp_stop_rec.STOP_ID',p_grp_stop_rec.STOP_ID);
1800: WSH_DEBUG_SV.log(l_module_name,'p_grp_stop_rec.TRIP_ID',p_grp_stop_rec.TRIP_ID);
1801: WSH_DEBUG_SV.log(l_module_name,'p_grp_stop_rec.TRIP_NAME',p_grp_stop_rec.TRIP_NAME);
1802: END IF;
1803:
1804: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1805:
1877: x_pvt_stop_rec.PENDING_INTERFACE_FLAG := p_grp_stop_rec.PENDING_INTERFACE_FLAG;
1878: x_pvt_stop_rec.TRANSACTION_HEADER_ID := p_grp_stop_rec.TRANSACTION_HEADER_ID;
1879:
1880: IF l_debug_on THEN
1881: WSH_DEBUG_SV.pop(l_module_name);
1882: END IF;
1883: EXCEPTION
1884: WHEN OTHERS THEN
1885: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_FTE_INTEGRATION.map_stopgrp_to_pvt',l_module_name);
1885: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_FTE_INTEGRATION.map_stopgrp_to_pvt',l_module_name);
1886: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1887: --
1888: IF l_debug_on THEN
1889: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1890: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1891: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1892: END IF;
1893: --
1886: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1887: --
1888: IF l_debug_on THEN
1889: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1890: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1891: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1892: END IF;
1893: --
1894: END map_stopgrp_to_pvt;
1887: --
1888: IF l_debug_on THEN
1889: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1890: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1891: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1892: END IF;
1893: --
1894: END map_stopgrp_to_pvt;
1895:
1936: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1937: --
1938: IF l_debug_on IS NULL
1939: THEN
1940: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1941: END IF;
1942: --
1943: SAVEPOINT validate_stop_grp;
1944: IF l_debug_on THEN
1941: END IF;
1942: --
1943: SAVEPOINT validate_stop_grp;
1944: IF l_debug_on THEN
1945: wsh_debug_sv.push(l_module_name);
1946: WSH_DEBUG_SV.log(l_module_name,'p_action_code',p_action_code );
1947: END IF;
1948:
1949: IF p_caller IN ( 'WSH_FSTRX','WSH_TPW_INBOUND')
1942: --
1943: SAVEPOINT validate_stop_grp;
1944: IF l_debug_on THEN
1945: wsh_debug_sv.push(l_module_name);
1946: WSH_DEBUG_SV.log(l_module_name,'p_action_code',p_action_code );
1947: END IF;
1948:
1949: IF p_caller IN ( 'WSH_FSTRX','WSH_TPW_INBOUND')
1950: OR p_caller LIKE 'FTE%' THEN
1955: BEGIN
1956: SAVEPOINT validate_stop_loop_grp;
1957:
1958: IF l_debug_on THEN
1959: WSH_DEBUG_SV.log(l_module_name,'status_code',p_rec_attr_tab(l_index).status_code);
1960: WSH_DEBUG_SV.log(l_module_name,'stop_id',p_rec_attr_tab(l_index).stop_id);
1961: WSH_DEBUG_SV.log(l_module_name,'trip_id',p_rec_attr_tab(l_index).trip_id);
1962: WSH_DEBUG_SV.log(l_module_name,'trip_name',p_rec_attr_tab(l_index).trip_name);
1963: WSH_DEBUG_SV.log(l_module_name,'stop_location_id',p_rec_attr_tab(l_index).stop_location_id);
1956: SAVEPOINT validate_stop_loop_grp;
1957:
1958: IF l_debug_on THEN
1959: WSH_DEBUG_SV.log(l_module_name,'status_code',p_rec_attr_tab(l_index).status_code);
1960: WSH_DEBUG_SV.log(l_module_name,'stop_id',p_rec_attr_tab(l_index).stop_id);
1961: WSH_DEBUG_SV.log(l_module_name,'trip_id',p_rec_attr_tab(l_index).trip_id);
1962: WSH_DEBUG_SV.log(l_module_name,'trip_name',p_rec_attr_tab(l_index).trip_name);
1963: WSH_DEBUG_SV.log(l_module_name,'stop_location_id',p_rec_attr_tab(l_index).stop_location_id);
1964: WSH_DEBUG_SV.log(l_module_name,'stop_location_code',p_rec_attr_tab(l_index).stop_location_code);
1957:
1958: IF l_debug_on THEN
1959: WSH_DEBUG_SV.log(l_module_name,'status_code',p_rec_attr_tab(l_index).status_code);
1960: WSH_DEBUG_SV.log(l_module_name,'stop_id',p_rec_attr_tab(l_index).stop_id);
1961: WSH_DEBUG_SV.log(l_module_name,'trip_id',p_rec_attr_tab(l_index).trip_id);
1962: WSH_DEBUG_SV.log(l_module_name,'trip_name',p_rec_attr_tab(l_index).trip_name);
1963: WSH_DEBUG_SV.log(l_module_name,'stop_location_id',p_rec_attr_tab(l_index).stop_location_id);
1964: WSH_DEBUG_SV.log(l_module_name,'stop_location_code',p_rec_attr_tab(l_index).stop_location_code);
1965: WSH_DEBUG_SV.log(l_module_name,'stop_sequence_number',p_rec_attr_tab(l_index).stop_sequence_number);
1958: IF l_debug_on THEN
1959: WSH_DEBUG_SV.log(l_module_name,'status_code',p_rec_attr_tab(l_index).status_code);
1960: WSH_DEBUG_SV.log(l_module_name,'stop_id',p_rec_attr_tab(l_index).stop_id);
1961: WSH_DEBUG_SV.log(l_module_name,'trip_id',p_rec_attr_tab(l_index).trip_id);
1962: WSH_DEBUG_SV.log(l_module_name,'trip_name',p_rec_attr_tab(l_index).trip_name);
1963: WSH_DEBUG_SV.log(l_module_name,'stop_location_id',p_rec_attr_tab(l_index).stop_location_id);
1964: WSH_DEBUG_SV.log(l_module_name,'stop_location_code',p_rec_attr_tab(l_index).stop_location_code);
1965: WSH_DEBUG_SV.log(l_module_name,'stop_sequence_number',p_rec_attr_tab(l_index).stop_sequence_number);
1966: WSH_DEBUG_SV.log(l_module_name,'weight_uom_code',p_rec_attr_tab(l_index).weight_uom_code);
1959: WSH_DEBUG_SV.log(l_module_name,'status_code',p_rec_attr_tab(l_index).status_code);
1960: WSH_DEBUG_SV.log(l_module_name,'stop_id',p_rec_attr_tab(l_index).stop_id);
1961: WSH_DEBUG_SV.log(l_module_name,'trip_id',p_rec_attr_tab(l_index).trip_id);
1962: WSH_DEBUG_SV.log(l_module_name,'trip_name',p_rec_attr_tab(l_index).trip_name);
1963: WSH_DEBUG_SV.log(l_module_name,'stop_location_id',p_rec_attr_tab(l_index).stop_location_id);
1964: WSH_DEBUG_SV.log(l_module_name,'stop_location_code',p_rec_attr_tab(l_index).stop_location_code);
1965: WSH_DEBUG_SV.log(l_module_name,'stop_sequence_number',p_rec_attr_tab(l_index).stop_sequence_number);
1966: WSH_DEBUG_SV.log(l_module_name,'weight_uom_code',p_rec_attr_tab(l_index).weight_uom_code);
1967: WSH_DEBUG_SV.log(l_module_name,'volume_uom_code',p_rec_attr_tab(l_index).volume_uom_code);
1960: WSH_DEBUG_SV.log(l_module_name,'stop_id',p_rec_attr_tab(l_index).stop_id);
1961: WSH_DEBUG_SV.log(l_module_name,'trip_id',p_rec_attr_tab(l_index).trip_id);
1962: WSH_DEBUG_SV.log(l_module_name,'trip_name',p_rec_attr_tab(l_index).trip_name);
1963: WSH_DEBUG_SV.log(l_module_name,'stop_location_id',p_rec_attr_tab(l_index).stop_location_id);
1964: WSH_DEBUG_SV.log(l_module_name,'stop_location_code',p_rec_attr_tab(l_index).stop_location_code);
1965: WSH_DEBUG_SV.log(l_module_name,'stop_sequence_number',p_rec_attr_tab(l_index).stop_sequence_number);
1966: WSH_DEBUG_SV.log(l_module_name,'weight_uom_code',p_rec_attr_tab(l_index).weight_uom_code);
1967: WSH_DEBUG_SV.log(l_module_name,'volume_uom_code',p_rec_attr_tab(l_index).volume_uom_code);
1968: WSH_DEBUG_SV.log(l_module_name,'planned_arrival_date',p_rec_attr_tab(l_index).planned_arrival_date);
1961: WSH_DEBUG_SV.log(l_module_name,'trip_id',p_rec_attr_tab(l_index).trip_id);
1962: WSH_DEBUG_SV.log(l_module_name,'trip_name',p_rec_attr_tab(l_index).trip_name);
1963: WSH_DEBUG_SV.log(l_module_name,'stop_location_id',p_rec_attr_tab(l_index).stop_location_id);
1964: WSH_DEBUG_SV.log(l_module_name,'stop_location_code',p_rec_attr_tab(l_index).stop_location_code);
1965: WSH_DEBUG_SV.log(l_module_name,'stop_sequence_number',p_rec_attr_tab(l_index).stop_sequence_number);
1966: WSH_DEBUG_SV.log(l_module_name,'weight_uom_code',p_rec_attr_tab(l_index).weight_uom_code);
1967: WSH_DEBUG_SV.log(l_module_name,'volume_uom_code',p_rec_attr_tab(l_index).volume_uom_code);
1968: WSH_DEBUG_SV.log(l_module_name,'planned_arrival_date',p_rec_attr_tab(l_index).planned_arrival_date);
1969: WSH_DEBUG_SV.log(l_module_name,'planned_departure_date',p_rec_attr_tab(l_index).planned_departure_date);
1962: WSH_DEBUG_SV.log(l_module_name,'trip_name',p_rec_attr_tab(l_index).trip_name);
1963: WSH_DEBUG_SV.log(l_module_name,'stop_location_id',p_rec_attr_tab(l_index).stop_location_id);
1964: WSH_DEBUG_SV.log(l_module_name,'stop_location_code',p_rec_attr_tab(l_index).stop_location_code);
1965: WSH_DEBUG_SV.log(l_module_name,'stop_sequence_number',p_rec_attr_tab(l_index).stop_sequence_number);
1966: WSH_DEBUG_SV.log(l_module_name,'weight_uom_code',p_rec_attr_tab(l_index).weight_uom_code);
1967: WSH_DEBUG_SV.log(l_module_name,'volume_uom_code',p_rec_attr_tab(l_index).volume_uom_code);
1968: WSH_DEBUG_SV.log(l_module_name,'planned_arrival_date',p_rec_attr_tab(l_index).planned_arrival_date);
1969: WSH_DEBUG_SV.log(l_module_name,'planned_departure_date',p_rec_attr_tab(l_index).planned_departure_date);
1970: END IF;
1963: WSH_DEBUG_SV.log(l_module_name,'stop_location_id',p_rec_attr_tab(l_index).stop_location_id);
1964: WSH_DEBUG_SV.log(l_module_name,'stop_location_code',p_rec_attr_tab(l_index).stop_location_code);
1965: WSH_DEBUG_SV.log(l_module_name,'stop_sequence_number',p_rec_attr_tab(l_index).stop_sequence_number);
1966: WSH_DEBUG_SV.log(l_module_name,'weight_uom_code',p_rec_attr_tab(l_index).weight_uom_code);
1967: WSH_DEBUG_SV.log(l_module_name,'volume_uom_code',p_rec_attr_tab(l_index).volume_uom_code);
1968: WSH_DEBUG_SV.log(l_module_name,'planned_arrival_date',p_rec_attr_tab(l_index).planned_arrival_date);
1969: WSH_DEBUG_SV.log(l_module_name,'planned_departure_date',p_rec_attr_tab(l_index).planned_departure_date);
1970: END IF;
1971:
1964: WSH_DEBUG_SV.log(l_module_name,'stop_location_code',p_rec_attr_tab(l_index).stop_location_code);
1965: WSH_DEBUG_SV.log(l_module_name,'stop_sequence_number',p_rec_attr_tab(l_index).stop_sequence_number);
1966: WSH_DEBUG_SV.log(l_module_name,'weight_uom_code',p_rec_attr_tab(l_index).weight_uom_code);
1967: WSH_DEBUG_SV.log(l_module_name,'volume_uom_code',p_rec_attr_tab(l_index).volume_uom_code);
1968: WSH_DEBUG_SV.log(l_module_name,'planned_arrival_date',p_rec_attr_tab(l_index).planned_arrival_date);
1969: WSH_DEBUG_SV.log(l_module_name,'planned_departure_date',p_rec_attr_tab(l_index).planned_departure_date);
1970: END IF;
1971:
1972: IF p_action_code = 'UPDATE' THEN
1965: WSH_DEBUG_SV.log(l_module_name,'stop_sequence_number',p_rec_attr_tab(l_index).stop_sequence_number);
1966: WSH_DEBUG_SV.log(l_module_name,'weight_uom_code',p_rec_attr_tab(l_index).weight_uom_code);
1967: WSH_DEBUG_SV.log(l_module_name,'volume_uom_code',p_rec_attr_tab(l_index).volume_uom_code);
1968: WSH_DEBUG_SV.log(l_module_name,'planned_arrival_date',p_rec_attr_tab(l_index).planned_arrival_date);
1969: WSH_DEBUG_SV.log(l_module_name,'planned_departure_date',p_rec_attr_tab(l_index).planned_departure_date);
1970: END IF;
1971:
1972: IF p_action_code = 'UPDATE' THEN
1973: l_status_code := p_rec_attr_tab(l_index).status_code;
1985: p_stop_location_id => NULL, -- not needed
1986: p_planned_dep_date => NULL, -- not needed
1987: x_return_status => l_return_status);
1988: IF l_debug_on THEN
1989: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_Stop_Name l_return_status',l_return_status);
1990: END IF;
1991: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
1992: x_num_warnings =>l_num_warnings,
1993: x_num_errors =>l_num_errors);
2014: p_trip_id => p_rec_attr_tab(l_index).trip_id,
2015: p_trip_name => p_rec_attr_tab(l_index).trip_name,
2016: x_return_status => l_return_status);
2017: IF l_debug_on THEN
2018: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_Trip_Name l_return_status',l_return_status);
2019: END IF;
2020: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2021: x_num_warnings =>l_num_warnings,
2022: x_num_errors =>l_num_errors);
2027: p_trip_id => p_rec_attr_tab(l_index).trip_id,
2028: p_action => p_action_code,
2029: x_return_status => l_return_status);
2030: IF l_debug_on THEN
2031: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_Trip_status l_return_status',l_return_status);
2032: END IF;
2033: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2034: x_num_warnings =>l_num_warnings,
2035: x_num_errors =>l_num_errors);
2049: p_location_code => p_rec_attr_tab(l_index).stop_location_code,
2050: x_return_status => l_return_status,
2051: p_isWshLocation => l_isWshLocation);
2052: IF l_debug_on THEN
2053: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_Location l_return_status',l_return_status);
2054: END IF;
2055: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2056: x_num_warnings =>l_num_warnings,
2057: x_num_errors =>l_num_errors);
2065: p_stop_sequence_number => p_rec_attr_tab(l_index).stop_sequence_number,
2066: x_return_status => l_return_status);
2067:
2068: IF l_debug_on THEN
2069: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.validate_planned_trip l_return_status',l_return_status);
2070: END IF;
2071: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2072: x_num_warnings =>l_num_warnings,
2073: x_num_errors =>l_num_errors);
2080: p_rec_attr_tab(l_index).weight_uom_code,
2081: p_rec_attr_tab(l_index).weight_uom_desc,
2082: l_return_status);
2083: IF l_debug_on THEN
2084: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.validate_uom-WEIGHT l_return_status',l_return_status);
2085: END IF;
2086: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2087: x_num_warnings =>l_num_warnings,
2088: x_num_errors =>l_num_errors);
2095: p_rec_attr_tab(l_index).volume_uom_code,
2096: p_rec_attr_tab(l_index).volume_uom_desc,
2097: l_return_status);
2098: IF l_debug_on THEN
2099: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.validate_uom-VOLUME l_return_status',l_return_status);
2100: END IF;
2101: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2102: x_num_warnings =>l_num_warnings,
2103: x_num_errors =>l_num_errors);
2109: p_from_date => p_rec_attr_tab(l_index).planned_arrival_date,
2110: p_to_date =>p_rec_attr_tab(l_index).planned_departure_date,
2111: x_return_status => l_return_status);
2112: IF l_debug_on THEN
2113: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.validate_from_to_dates l_return_status',l_return_status);
2114: END IF;
2115: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2116: x_num_warnings =>l_num_warnings,
2117: x_num_errors =>l_num_errors);
2130: p_status_code => l_status_code,
2131: x_return_status => l_return_status);
2132:
2133: IF l_debug_on THEN
2134: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_SSN l_return_status',l_return_status);
2135: END IF;
2136: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2137: x_num_warnings =>l_num_warnings,
2138: x_num_errors =>l_num_errors);
2146: p_trip_rec => l_trip_rec,
2147: p_action => l_action,
2148: x_return_status => l_return_status);
2149: IF l_debug_on THEN
2150: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_Trip_Name l_return_status',l_return_status);
2151: END IF;
2152: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2153: x_num_warnings =>l_num_warnings,
2154: x_num_errors =>l_num_errors);
2175: END IF; --}
2176: x_valid_id_index_tab(x_valid_id_index_tab.COUNT + 1) := l_index;
2177:
2178: IF l_debug_on THEN
2179: WSH_DEBUG_SV.log(l_module_name,'l_num_errors',l_num_errors);
2180: WSH_DEBUG_SV.log(l_module_name,'l_index',l_index);
2181: END IF;
2182: EXCEPTION
2183: -- J-IB-NPARIKH-{
2176: x_valid_id_index_tab(x_valid_id_index_tab.COUNT + 1) := l_index;
2177:
2178: IF l_debug_on THEN
2179: WSH_DEBUG_SV.log(l_module_name,'l_num_errors',l_num_errors);
2180: WSH_DEBUG_SV.log(l_module_name,'l_index',l_index);
2181: END IF;
2182: EXCEPTION
2183: -- J-IB-NPARIKH-{
2184: WHEN e_mixed_Stop_error THEN
2186: l_num_errors := l_num_errors + 1;
2187: FND_MESSAGE.SET_NAME('WSH', 'WSH_MIXED_STOP_ERROR');
2188: WSH_UTIL_CORE.ADD_MESSAGE(wsh_util_core.g_ret_sts_error, l_module_name);
2189: IF l_debug_on THEN
2190: WSH_DEBUG_SV.logmsg(l_module_name,'e_mixed_Stop_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2191: END IF;
2192: -- J-IB-NPARIKH-}
2193:
2194: WHEN fnd_api.g_exc_error THEN
2216: END IF;
2217:
2218:
2219: IF l_debug_on THEN
2220: WSH_DEBUG_SV.pop(l_module_name);
2221: END IF;
2222: EXCEPTION
2223: WHEN FND_API.G_EXC_ERROR THEN
2224: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR ;
2226: p_count => x_msg_count,
2227: p_data => x_msg_data,
2228: p_encoded => FND_API.G_FALSE);
2229: IF l_debug_on THEN
2230: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2231: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2232: END IF;
2233: ROLLBACK TO SAVEPOINT validate_stop_grp;
2234:
2227: p_data => x_msg_data,
2228: p_encoded => FND_API.G_FALSE);
2229: IF l_debug_on THEN
2230: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2231: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2232: END IF;
2233: ROLLBACK TO SAVEPOINT validate_stop_grp;
2234:
2235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2238: p_count => x_msg_count,
2239: p_data => x_msg_data,
2240: p_encoded => FND_API.G_FALSE);
2241: IF l_debug_on THEN
2242: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2243: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2244: END IF;
2245: ROLLBACK TO SAVEPOINT validate_stop_grp;
2246:
2239: p_data => x_msg_data,
2240: p_encoded => FND_API.G_FALSE);
2241: IF l_debug_on THEN
2242: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2243: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2244: END IF;
2245: ROLLBACK TO SAVEPOINT validate_stop_grp;
2246:
2247: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2250: p_count => x_msg_count,
2251: p_data => x_msg_data,
2252: p_encoded => FND_API.G_FALSE);
2253: IF l_debug_on THEN
2254: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2255: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2256: END IF;
2257:
2258: WHEN OTHERS THEN
2251: p_data => x_msg_data,
2252: p_encoded => FND_API.G_FALSE);
2253: IF l_debug_on THEN
2254: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2255: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2256: END IF;
2257:
2258: WHEN OTHERS THEN
2259: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2262: p_count => x_msg_count,
2263: p_data => x_msg_data,
2264: p_encoded => FND_API.G_FALSE);
2265: IF l_debug_on THEN
2266: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2267: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2268: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2269: END IF;
2270: ROLLBACK TO SAVEPOINT validate_stop_grp;
2263: p_data => x_msg_data,
2264: p_encoded => FND_API.G_FALSE);
2265: IF l_debug_on THEN
2266: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2267: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2268: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2269: END IF;
2270: ROLLBACK TO SAVEPOINT validate_stop_grp;
2271: END Validate_Stop;
2264: p_encoded => FND_API.G_FALSE);
2265: IF l_debug_on THEN
2266: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2267: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2268: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2269: END IF;
2270: ROLLBACK TO SAVEPOINT validate_stop_grp;
2271: END Validate_Stop;
2272:
2409: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2410: --
2411: IF l_debug_on IS NULL
2412: THEN
2413: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2414: END IF;
2415: --
2416: l_stop_seq_mode := WSH_TRIPS_ACTIONS.GET_STOP_SEQ_MODE; -- SSN change
2417:
2419:
2420: l_trips.delete;
2421:
2422: IF l_debug_on THEN
2423: wsh_debug_sv.push (l_module_name, 'Create_Update_Stop');
2424: wsh_debug_sv.log (l_module_name,'p_in_rec.action_code',p_in_rec.action_code);
2425: wsh_debug_sv.log (l_module_name,'p_in_rec.caller',p_in_rec.caller);
2426: wsh_debug_sv.log (l_module_name,'p_in_rec.phase',p_in_rec.phase);
2427: wsh_debug_sv.log (l_module_name,'(p_rec_attr_tab.count',p_rec_attr_tab.count);
2420: l_trips.delete;
2421:
2422: IF l_debug_on THEN
2423: wsh_debug_sv.push (l_module_name, 'Create_Update_Stop');
2424: wsh_debug_sv.log (l_module_name,'p_in_rec.action_code',p_in_rec.action_code);
2425: wsh_debug_sv.log (l_module_name,'p_in_rec.caller',p_in_rec.caller);
2426: wsh_debug_sv.log (l_module_name,'p_in_rec.phase',p_in_rec.phase);
2427: wsh_debug_sv.log (l_module_name,'(p_rec_attr_tab.count',p_rec_attr_tab.count);
2428: END IF;
2421:
2422: IF l_debug_on THEN
2423: wsh_debug_sv.push (l_module_name, 'Create_Update_Stop');
2424: wsh_debug_sv.log (l_module_name,'p_in_rec.action_code',p_in_rec.action_code);
2425: wsh_debug_sv.log (l_module_name,'p_in_rec.caller',p_in_rec.caller);
2426: wsh_debug_sv.log (l_module_name,'p_in_rec.phase',p_in_rec.phase);
2427: wsh_debug_sv.log (l_module_name,'(p_rec_attr_tab.count',p_rec_attr_tab.count);
2428: END IF;
2429:
2422: IF l_debug_on THEN
2423: wsh_debug_sv.push (l_module_name, 'Create_Update_Stop');
2424: wsh_debug_sv.log (l_module_name,'p_in_rec.action_code',p_in_rec.action_code);
2425: wsh_debug_sv.log (l_module_name,'p_in_rec.caller',p_in_rec.caller);
2426: wsh_debug_sv.log (l_module_name,'p_in_rec.phase',p_in_rec.phase);
2427: wsh_debug_sv.log (l_module_name,'(p_rec_attr_tab.count',p_rec_attr_tab.count);
2428: END IF;
2429:
2430: IF NOT FND_API.Compatible_API_Call(l_api_version_number, p_api_version_number,l_api_name,G_PKG_NAME) THEN
2423: wsh_debug_sv.push (l_module_name, 'Create_Update_Stop');
2424: wsh_debug_sv.log (l_module_name,'p_in_rec.action_code',p_in_rec.action_code);
2425: wsh_debug_sv.log (l_module_name,'p_in_rec.caller',p_in_rec.caller);
2426: wsh_debug_sv.log (l_module_name,'p_in_rec.phase',p_in_rec.phase);
2427: wsh_debug_sv.log (l_module_name,'(p_rec_attr_tab.count',p_rec_attr_tab.count);
2428: END IF;
2429:
2430: IF NOT FND_API.Compatible_API_Call(l_api_version_number, p_api_version_number,l_api_name,G_PKG_NAME) THEN
2431: IF l_debug_on THEN
2428: END IF;
2429:
2430: IF NOT FND_API.Compatible_API_Call(l_api_version_number, p_api_version_number,l_api_name,G_PKG_NAME) THEN
2431: IF l_debug_on THEN
2432: WSH_DEBUG_SV.logmsg(l_module_name,'Not compatible');
2433: END IF;
2434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2435: END IF;
2436:
2486: p_action => p_in_rec.action_code,
2487: x_return_status => l_return_status);
2488:
2489: IF l_debug_on THEN
2490: WSH_DEBUG_SV.log(l_module_name,'WSH_ACTIONS_LEVELS.set_validation_level l_return_status',l_return_status);
2491: END IF;
2492:
2493: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2494: x_num_warnings =>l_num_warnings,
2500: WHILE l_index IS NOT NULL LOOP
2501: BEGIN
2502: SAVEPOINT s_stop_disabled_list_grp;
2503: IF l_debug_on THEN
2504: WSH_DEBUG_SV.log(l_module_name,'stop_id,trip_id',p_rec_attr_tab(l_index).stop_id||','||
2505: p_rec_attr_tab(l_index).trip_id);
2506: END IF;
2507:
2508: WSH_TRIP_STOPS_validations.get_disabled_list(
2541: l_rec_attr_tab := p_rec_attr_tab;
2542: END IF;
2543:
2544: IF l_debug_on THEN
2545: WSH_DEBUG_SV.log(l_module_name,'count, l_num_errors',l_rec_attr_tab.COUNT ||','||l_num_errors);
2546: END IF;
2547:
2548: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_VALIDATE_CONSTRAINTS_LVL) = 1 THEN --{
2549: --Compatiblity Changes
2585: x_msg_data => l_msg_data,
2586: x_return_status => l_return_status);
2587:
2588: IF l_debug_on THEN
2589: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_constraint_main',l_return_status);
2590: wsh_debug_sv.log(l_module_name,'validate_result After Calling validate_constraint_main',l_cc_validate_result);
2591: wsh_debug_sv.log(l_module_name,'msg_count After Calling validate_constraint_main',l_msg_count);
2592: wsh_debug_sv.log(l_module_name,'msg_data After Calling validate_constraint_main',l_msg_data);
2593: wsh_debug_sv.log(l_module_name,'fail_ids count After Calling validate_constraint_main',l_cc_fail_ids.COUNT);
2586: x_return_status => l_return_status);
2587:
2588: IF l_debug_on THEN
2589: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_constraint_main',l_return_status);
2590: wsh_debug_sv.log(l_module_name,'validate_result After Calling validate_constraint_main',l_cc_validate_result);
2591: wsh_debug_sv.log(l_module_name,'msg_count After Calling validate_constraint_main',l_msg_count);
2592: wsh_debug_sv.log(l_module_name,'msg_data After Calling validate_constraint_main',l_msg_data);
2593: wsh_debug_sv.log(l_module_name,'fail_ids count After Calling validate_constraint_main',l_cc_fail_ids.COUNT);
2594: wsh_debug_sv.log(l_module_name,'l_cc_line_groups.count count After Calling validate_constraint_main',l_cc_line_groups.COUNT);
2587:
2588: IF l_debug_on THEN
2589: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_constraint_main',l_return_status);
2590: wsh_debug_sv.log(l_module_name,'validate_result After Calling validate_constraint_main',l_cc_validate_result);
2591: wsh_debug_sv.log(l_module_name,'msg_count After Calling validate_constraint_main',l_msg_count);
2592: wsh_debug_sv.log(l_module_name,'msg_data After Calling validate_constraint_main',l_msg_data);
2593: wsh_debug_sv.log(l_module_name,'fail_ids count After Calling validate_constraint_main',l_cc_fail_ids.COUNT);
2594: wsh_debug_sv.log(l_module_name,'l_cc_line_groups.count count After Calling validate_constraint_main',l_cc_line_groups.COUNT);
2595: wsh_debug_sv.log(l_module_name,'group_info count After Calling validate_constraint_main',l_cc_group_info.COUNT);
2588: IF l_debug_on THEN
2589: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_constraint_main',l_return_status);
2590: wsh_debug_sv.log(l_module_name,'validate_result After Calling validate_constraint_main',l_cc_validate_result);
2591: wsh_debug_sv.log(l_module_name,'msg_count After Calling validate_constraint_main',l_msg_count);
2592: wsh_debug_sv.log(l_module_name,'msg_data After Calling validate_constraint_main',l_msg_data);
2593: wsh_debug_sv.log(l_module_name,'fail_ids count After Calling validate_constraint_main',l_cc_fail_ids.COUNT);
2594: wsh_debug_sv.log(l_module_name,'l_cc_line_groups.count count After Calling validate_constraint_main',l_cc_line_groups.COUNT);
2595: wsh_debug_sv.log(l_module_name,'group_info count After Calling validate_constraint_main',l_cc_group_info.COUNT);
2596: END IF;
2589: wsh_debug_sv.log(l_module_name,'Return Status After Calling validate_constraint_main',l_return_status);
2590: wsh_debug_sv.log(l_module_name,'validate_result After Calling validate_constraint_main',l_cc_validate_result);
2591: wsh_debug_sv.log(l_module_name,'msg_count After Calling validate_constraint_main',l_msg_count);
2592: wsh_debug_sv.log(l_module_name,'msg_data After Calling validate_constraint_main',l_msg_data);
2593: wsh_debug_sv.log(l_module_name,'fail_ids count After Calling validate_constraint_main',l_cc_fail_ids.COUNT);
2594: wsh_debug_sv.log(l_module_name,'l_cc_line_groups.count count After Calling validate_constraint_main',l_cc_line_groups.COUNT);
2595: wsh_debug_sv.log(l_module_name,'group_info count After Calling validate_constraint_main',l_cc_group_info.COUNT);
2596: END IF;
2597: --
2590: wsh_debug_sv.log(l_module_name,'validate_result After Calling validate_constraint_main',l_cc_validate_result);
2591: wsh_debug_sv.log(l_module_name,'msg_count After Calling validate_constraint_main',l_msg_count);
2592: wsh_debug_sv.log(l_module_name,'msg_data After Calling validate_constraint_main',l_msg_data);
2593: wsh_debug_sv.log(l_module_name,'fail_ids count After Calling validate_constraint_main',l_cc_fail_ids.COUNT);
2594: wsh_debug_sv.log(l_module_name,'l_cc_line_groups.count count After Calling validate_constraint_main',l_cc_line_groups.COUNT);
2595: wsh_debug_sv.log(l_module_name,'group_info count After Calling validate_constraint_main',l_cc_group_info.COUNT);
2596: END IF;
2597: --
2598:
2591: wsh_debug_sv.log(l_module_name,'msg_count After Calling validate_constraint_main',l_msg_count);
2592: wsh_debug_sv.log(l_module_name,'msg_data After Calling validate_constraint_main',l_msg_data);
2593: wsh_debug_sv.log(l_module_name,'fail_ids count After Calling validate_constraint_main',l_cc_fail_ids.COUNT);
2594: wsh_debug_sv.log(l_module_name,'l_cc_line_groups.count count After Calling validate_constraint_main',l_cc_line_groups.COUNT);
2595: wsh_debug_sv.log(l_module_name,'group_info count After Calling validate_constraint_main',l_cc_group_info.COUNT);
2596: END IF;
2597: --
2598:
2599: --fix p_rec_attr_tab to have only successful records if there are some failed lines
2600: IF l_return_status=wsh_util_core.g_ret_sts_error THEN
2601: l_cc_count_success:=1;
2602:
2603: IF l_debug_on THEN
2604: wsh_debug_sv.log(l_module_name,'l_rec_attr_tab count before removing failed lines',l_rec_attr_tab.COUNT);
2605: END IF;
2606:
2607: IF l_cc_fail_ids.COUNT>0 AND l_rec_attr_tab.COUNT>0 THEN
2608: IF l_cc_fail_ids.COUNT=l_rec_attr_tab.COUNT THEN
2606:
2607: IF l_cc_fail_ids.COUNT>0 AND l_rec_attr_tab.COUNT>0 THEN
2608: IF l_cc_fail_ids.COUNT=l_rec_attr_tab.COUNT THEN
2609: IF l_debug_on THEN
2610: wsh_debug_sv.logmsg(l_module_name,'all stops failed compatibility check');
2611: END IF;
2612: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_COMP_FAILED');
2613: wsh_util_core.api_post_call(
2614: p_return_status => l_return_status,
2628: IF (p_in_rec.action_code='CREATE' AND l_rec_attr_tab(i).stop_id is null
2629: AND i=l_cc_fail_ids(j)) THEN
2630: b_cc_linefailed:=TRUE;
2631: IF l_debug_on THEN
2632: wsh_debug_sv.logmsg(l_module_name,'compatibility check failed for stop create');
2633: END IF;
2634: FND_MESSAGE.SET_NAME('WSH','WSH_STOP_COMP_FAILED');
2635: ELSIF (l_rec_attr_tab(i).stop_id=l_cc_fail_ids(j)) THEN
2636: b_cc_linefailed:=TRUE;
2654: END IF; --fail_ids count>0
2655:
2656:
2657: IF l_debug_on THEN
2658: wsh_debug_sv.log(l_module_name,'l_rec_attr_tab count after removing failed lines',l_rec_attr_tab.COUNT);
2659: END IF;
2660:
2661: END IF;--error
2662:
2679: x_valid_id_index_tab => x_index_id_tab,
2680: x_return_status => l_return_status);
2681:
2682: IF l_debug_on THEN
2683: WSH_DEBUG_SV.log(l_module_name,'Validate_stop l_return_status',l_return_status);
2684: END IF;
2685:
2686: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2687: x_num_warnings =>l_num_warnings,
2708: -- Do not allow creation of Trip Stop for GC3 created trips
2709: -- from UI or Public API, only allowed from Inbound Message
2710: -- received from GC3
2711: IF l_debug_on THEN
2712: WSH_DEBUG_SV.log(l_module_name,'l_ignore',l_ignore);
2713: WSH_DEBUG_SV.log(l_module_name,'l_tp_plan_name',l_tp_plan_name);
2714: WSH_DEBUG_SV.log(l_module_name,'l_gc3_is_installed',l_gc3_is_installed);
2715: END IF;
2716:
2709: -- from UI or Public API, only allowed from Inbound Message
2710: -- received from GC3
2711: IF l_debug_on THEN
2712: WSH_DEBUG_SV.log(l_module_name,'l_ignore',l_ignore);
2713: WSH_DEBUG_SV.log(l_module_name,'l_tp_plan_name',l_tp_plan_name);
2714: WSH_DEBUG_SV.log(l_module_name,'l_gc3_is_installed',l_gc3_is_installed);
2715: END IF;
2716:
2717: IF (l_ignore = 'N' AND
2710: -- received from GC3
2711: IF l_debug_on THEN
2712: WSH_DEBUG_SV.log(l_module_name,'l_ignore',l_ignore);
2713: WSH_DEBUG_SV.log(l_module_name,'l_tp_plan_name',l_tp_plan_name);
2714: WSH_DEBUG_SV.log(l_module_name,'l_gc3_is_installed',l_gc3_is_installed);
2715: END IF;
2716:
2717: IF (l_ignore = 'N' AND
2718: l_tp_plan_name IS NOT NULL AND
2755: p_trip_id => l_rec_attr_tab(x_index_id_tab(l_index)).trip_id,
2756: p_mode_of_transport => l_mode_of_transport,
2757: x_return_status => l_return_status);
2758: IF l_debug_on THEN
2759: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_MultiStops l_return_status',l_return_status);
2760: END IF;
2761: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2762: x_num_warnings =>l_num_warnings,
2763: x_num_errors =>l_num_errors);
2780:
2781: -- begin csun 10+ internal location
2782: IF l_stop_rec.stop_location_id <> l_rec_attr_tab(x_index_id_tab(l_index)).stop_location_id THEN
2783: IF l_debug_on THEN
2784: wsh_debug_sv.logmsg(l_module_name,'stop location id has been changed');
2785: END IF;
2786: WSH_LOCATIONS_PKG.Convert_internal_cust_location(
2787: p_internal_cust_location_id => l_rec_attr_tab(x_index_id_tab(l_index)).stop_location_id,
2788: x_internal_org_location_id => l_rec_attr_tab(x_index_id_tab(l_index)).physical_location_id,
2791: IF l_return_status in (FND_API.G_RET_STS_UNEXP_ERROR, FND_API.G_RET_STS_ERROR) THEN
2792: RAISE get_physical_loc_err;
2793: END IF;
2794: IF l_debug_on THEN
2795: wsh_debug_sv.log(l_module_name,'l_stop_rec.physical_location_id' , l_stop_rec.physical_location_id);
2796: wsh_debug_sv.log(l_module_name,'l_rec_attr_tab(x_index_id_tab(l_index)).physical_location_id' ,l_rec_attr_tab(x_index_id_tab(l_index)).physical_location_id);
2797: END IF;
2798: -- delink the physical stop id
2799: IF nvl(l_stop_rec.physical_location_id, -99) <> nvl(l_rec_attr_tab(x_index_id_tab(l_index)).physical_location_id, -99) THEN
2792: RAISE get_physical_loc_err;
2793: END IF;
2794: IF l_debug_on THEN
2795: wsh_debug_sv.log(l_module_name,'l_stop_rec.physical_location_id' , l_stop_rec.physical_location_id);
2796: wsh_debug_sv.log(l_module_name,'l_rec_attr_tab(x_index_id_tab(l_index)).physical_location_id' ,l_rec_attr_tab(x_index_id_tab(l_index)).physical_location_id);
2797: END IF;
2798: -- delink the physical stop id
2799: IF nvl(l_stop_rec.physical_location_id, -99) <> nvl(l_rec_attr_tab(x_index_id_tab(l_index)).physical_location_id, -99) THEN
2800: l_stop_rec.physical_stop_id := NULL;
2823: -- if mode is SSN, linked dummy stop's planned dates have
2824: -- to be synchronized (which will also take care of SSN changes).
2825:
2826: IF l_debug_on THEN
2827: wsh_debug_sv.logmsg(l_module_name,'PAD or PDD has been changed');
2828: wsh_debug_sv.logmsg(l_module_name,'Physical Loc'||l_rec_attr_tab(x_index_id_tab(l_index)).physical_location_id);
2829: END IF;
2830:
2831: -- begin csun 10+ internal location
2824: -- to be synchronized (which will also take care of SSN changes).
2825:
2826: IF l_debug_on THEN
2827: wsh_debug_sv.logmsg(l_module_name,'PAD or PDD has been changed');
2828: wsh_debug_sv.logmsg(l_module_name,'Physical Loc'||l_rec_attr_tab(x_index_id_tab(l_index)).physical_location_id);
2829: END IF;
2830:
2831: -- begin csun 10+ internal location
2832: -- if the dates of physical stop is changed, change the dates of
2842: -- if mode is SSN and SSN alone is changed,
2843: -- need to synchronize linked dummy stops.
2844:
2845: IF l_debug_on THEN
2846: wsh_debug_sv.logmsg(l_module_name,'SSN has been changed');
2847: wsh_debug_sv.logmsg(l_module_name,'Physical Loc'||l_rec_attr_tab(x_index_id_tab(l_index)).physical_location_id);
2848: END IF;
2849:
2850: -- if the SSN of physical stop is changed, change the SSN of
2843: -- need to synchronize linked dummy stops.
2844:
2845: IF l_debug_on THEN
2846: wsh_debug_sv.logmsg(l_module_name,'SSN has been changed');
2847: wsh_debug_sv.logmsg(l_module_name,'Physical Loc'||l_rec_attr_tab(x_index_id_tab(l_index)).physical_location_id);
2848: END IF;
2849:
2850: -- if the SSN of physical stop is changed, change the SSN of
2851: -- corresponding internal stop
2856: END IF;
2857:
2858: IF l_handle_internal_stops THEN
2859: IF l_debug_on THEN
2860: wsh_debug_sv.logmsg(l_module_name,'handle internal stop TRUE');
2861: END IF;
2862: l_trips(1) := l_rec_attr_tab(x_index_id_tab(l_index)).trip_id;
2863:
2864: WSH_TRIPS_ACTIONS.Handle_Internal_Stops(
2882: p_trip_id => l_rec_attr_tab(x_index_id_tab(l_index)).trip_id,
2883: p_mode_of_transport => l_mode_of_transport,
2884: x_return_status => l_return_status);
2885: IF l_debug_on THEN
2886: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_MultiStops l_return_status',l_return_status);
2887: END IF;
2888: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2889: x_num_warnings =>l_num_warnings,
2890: x_num_errors =>l_num_errors);
2900: l_status_code := 'OP';
2901: END IF;
2902:
2903: IF l_debug_on THEN
2904: wsh_debug_sv.logmsg(l_module_name,p_in_rec.action_code);
2905: wsh_debug_sv.log(l_module_name,'WSH_UTIL_CORE.FTE_Is_Installed', WSH_UTIL_CORE.FTE_Is_Installed);
2906: END IF;
2907:
2908: --TL Rating
2901: END IF;
2902:
2903: IF l_debug_on THEN
2904: wsh_debug_sv.logmsg(l_module_name,p_in_rec.action_code);
2905: wsh_debug_sv.log(l_module_name,'WSH_UTIL_CORE.FTE_Is_Installed', WSH_UTIL_CORE.FTE_Is_Installed);
2906: END IF;
2907:
2908: --TL Rating
2909: IF (p_in_rec.action_code = 'CREATE' ) THEN
2915: -- Mark as reprice required only when certain conditions are met
2916: -- during update.
2917:
2918: IF l_debug_on THEN
2919: wsh_debug_sv.log(l_module_name,'l_rec_attr_tab(x_index_id_tab(l_index)).planned_arrival_date', l_rec_attr_tab(x_index_id_tab(l_index)).planned_arrival_date);
2920: wsh_debug_sv.log(l_module_name,'l_rec_attr_tab(x_index_id_tab(l_index)).planned_departure_date', l_rec_attr_tab(x_index_id_tab(l_index)).planned_departure_date);
2921: wsh_debug_sv.log(l_module_name,'l_stop_rec.planned_arrival_date', l_stop_rec.planned_arrival_date);
2922: wsh_debug_sv.log(l_module_name,'l_stop_rec.planned_departure_date', l_stop_rec.planned_departure_date);
2923: END IF;
2916: -- during update.
2917:
2918: IF l_debug_on THEN
2919: wsh_debug_sv.log(l_module_name,'l_rec_attr_tab(x_index_id_tab(l_index)).planned_arrival_date', l_rec_attr_tab(x_index_id_tab(l_index)).planned_arrival_date);
2920: wsh_debug_sv.log(l_module_name,'l_rec_attr_tab(x_index_id_tab(l_index)).planned_departure_date', l_rec_attr_tab(x_index_id_tab(l_index)).planned_departure_date);
2921: wsh_debug_sv.log(l_module_name,'l_stop_rec.planned_arrival_date', l_stop_rec.planned_arrival_date);
2922: wsh_debug_sv.log(l_module_name,'l_stop_rec.planned_departure_date', l_stop_rec.planned_departure_date);
2923: END IF;
2924:
2917:
2918: IF l_debug_on THEN
2919: wsh_debug_sv.log(l_module_name,'l_rec_attr_tab(x_index_id_tab(l_index)).planned_arrival_date', l_rec_attr_tab(x_index_id_tab(l_index)).planned_arrival_date);
2920: wsh_debug_sv.log(l_module_name,'l_rec_attr_tab(x_index_id_tab(l_index)).planned_departure_date', l_rec_attr_tab(x_index_id_tab(l_index)).planned_departure_date);
2921: wsh_debug_sv.log(l_module_name,'l_stop_rec.planned_arrival_date', l_stop_rec.planned_arrival_date);
2922: wsh_debug_sv.log(l_module_name,'l_stop_rec.planned_departure_date', l_stop_rec.planned_departure_date);
2923: END IF;
2924:
2925:
2918: IF l_debug_on THEN
2919: wsh_debug_sv.log(l_module_name,'l_rec_attr_tab(x_index_id_tab(l_index)).planned_arrival_date', l_rec_attr_tab(x_index_id_tab(l_index)).planned_arrival_date);
2920: wsh_debug_sv.log(l_module_name,'l_rec_attr_tab(x_index_id_tab(l_index)).planned_departure_date', l_rec_attr_tab(x_index_id_tab(l_index)).planned_departure_date);
2921: wsh_debug_sv.log(l_module_name,'l_stop_rec.planned_arrival_date', l_stop_rec.planned_arrival_date);
2922: wsh_debug_sv.log(l_module_name,'l_stop_rec.planned_departure_date', l_stop_rec.planned_departure_date);
2923: END IF;
2924:
2925:
2926: IF (NVL(l_rec_attr_tab(x_index_id_tab(l_index)).planned_arrival_date, FND_API.G_MISS_DATE) <>
2930: OR (NVL(l_rec_attr_tab(x_index_id_tab(l_index)).stop_location_id, FND_API.G_MISS_NUM) <>
2931: NVL(l_stop_rec.stop_location_id, FND_API.G_MISS_NUM)) THEN
2932:
2933: IF l_debug_on THEN
2934: wsh_debug_sv.log(l_module_name,'details marked count', l_details_marked.COUNT);
2935: END IF;
2936:
2937: l_details_marked(l_details_marked.COUNT+1):=l_rec_attr_tab(x_index_id_tab(l_index)).stop_id;
2938:
2936:
2937: l_details_marked(l_details_marked.COUNT+1):=l_rec_attr_tab(x_index_id_tab(l_index)).stop_id;
2938:
2939: IF l_debug_on THEN
2940: wsh_debug_sv.log(l_module_name,'details marked count', l_details_marked.COUNT);
2941: END IF;
2942:
2943: ELSIF NVL(l_rec_attr_tab(x_index_id_tab(l_index)).WKEND_LAYOVER_STOPS, FND_API.G_MISS_NUM) <>
2944: NVL(l_stop_rec.WKEND_LAYOVER_STOPS, FND_API.G_MISS_NUM)
2986: --
2987: -- Debug Statements
2988: --
2989: IF l_debug_on THEN
2990: WSH_DEBUG_SV.logmsg(l_module_name,'GC3_TRIP exception has occured.');
2991: END IF;
2992: --
2993:
2994: --OTM R12, glog proj, other cursors are closed in OUTER exception
3001: --
3002: -- Debug Statements
3003: --
3004: IF l_debug_on THEN
3005: WSH_DEBUG_SV.logmsg(l_module_name,'NO_DATA_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3006: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
3007: END IF;
3008: --
3009:
3002: -- Debug Statements
3003: --
3004: IF l_debug_on THEN
3005: WSH_DEBUG_SV.logmsg(l_module_name,'NO_DATA_FOUND exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3006: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
3007: END IF;
3008: --
3009:
3010:
3048: p_action_prms => l_action_prms,
3049: p_rec_attr_tab => l_rec_attr_tab);
3050:
3051: IF l_debug_on THEN
3052: WSH_DEBUG_SV.log(l_module_name,'after calling stop_callback l_return_status',l_return_status);
3053: END IF;
3054:
3055: wsh_util_core.api_post_call(
3056: p_return_status => l_return_status,
3063: IF( WSH_UTIL_CORE.FTE_Is_Installed = 'Y') THEN
3064: IF l_details_marked.count > 0 THEN
3065: --
3066: IF l_debug_on THEN
3067: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_LEGS_ACTIONS.MARK_REPRICE_REQUIRED',WSH_DEBUG_SV.C_PROC_LEVEL);
3068: END IF;
3069: --
3070: WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required(
3071: p_entity_type => 'STOP',
3085:
3086:
3087: --bug 2796095
3088: IF l_debug_on THEN
3089: WSH_DEBUG_SV.log(l_module_name,'l_trip_id_tab.count',l_trip_id_tab.count);
3090: END IF;
3091: IF ( l_trip_id_tab.count > 0 ) THEN
3092:
3093: l_index := l_trip_id_tab.FIRST;
3093: l_index := l_trip_id_tab.FIRST;
3094: WHILE l_index IS NOT NULL LOOP
3095: FOR stop_rec IN c_get_all_trip_stops(l_trip_id_tab(l_index)) LOOP
3096: IF l_debug_on THEN
3097: WSH_DEBUG_SV.log(l_module_name,'Stop_id',stop_rec.stop_id);
3098: END IF;
3099:
3100: x_stop_wt_vol_out_tab(l_stop_index).stop_id := stop_rec.stop_id;
3101: x_stop_wt_vol_out_tab(l_stop_index).departure_gross_weight :=stop_rec.departure_gross_weight;
3109: l_index := l_trip_id_tab.NEXT(l_index);
3110: END LOOP;
3111: END IF;
3112: IF l_debug_on THEN
3113: WSH_DEBUG_SV.log(l_module_name,'x_stop_wt_vol_out_tab.count',x_stop_wt_vol_out_tab.count);
3114: END IF;
3115: --bug 2796095
3116: --
3117: -- K LPN CONV. rv
3119: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
3120: THEN
3121: --{
3122: IF l_debug_on THEN
3123: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);
3124: END IF;
3125:
3126:
3127: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
3132: );
3133: --
3134: --
3135: IF l_debug_on THEN
3136: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
3137: END IF;
3138: --
3139: --
3140: WSH_UTIL_CORE.API_POST_CALL
3165: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3166: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
3167:
3168: IF l_debug_on THEN
3169: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
3170: END IF;
3171:
3172: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => FALSE,
3173: x_return_status => l_return_status);
3172: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => FALSE,
3173: x_return_status => l_return_status);
3174:
3175: IF l_debug_on THEN
3176: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
3177: END IF;
3178: END IF;
3179: --}
3180: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR
3201:
3202: IF FND_API.TO_BOOLEAN(p_commit) THEN
3203:
3204: IF l_debug_on THEN
3205: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
3206: END IF;
3207: WSH_UTIL_CORE.reset_stops_for_load_tender(
3208: p_reset_flags => TRUE,
3209: x_return_status => l_return_status);
3209: x_return_status => l_return_status);
3210: ELSE
3211:
3212: IF l_debug_on THEN
3213: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
3214: END IF;
3215: WSH_UTIL_CORE.Process_stops_for_load_tender(
3216: p_reset_flags => TRUE,
3217: x_return_status => l_return_status);
3217: x_return_status => l_return_status);
3218: END IF;
3219:
3220: IF l_debug_on THEN
3221: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
3222: END IF;
3223:
3224: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
3225: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3253: p_encoded => FND_API.G_FALSE );
3254:
3255:
3256: IF l_debug_on THEN
3257: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
3258: WSH_DEBUG_SV.pop(l_module_name);
3259: END IF;
3260:
3261:
3254:
3255:
3256: IF l_debug_on THEN
3257: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
3258: WSH_DEBUG_SV.pop(l_module_name);
3259: END IF;
3260:
3261:
3262: EXCEPTION
3274: --Bugfix 4070732 {
3275: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
3276: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
3277: IF l_debug_on THEN
3278: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
3279: END IF;
3280:
3281: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
3282: x_return_status => l_return_status);
3282: x_return_status => l_return_status);
3283:
3284:
3285: IF l_debug_on THEN
3286: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
3287: END IF;
3288:
3289: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
3290: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3296: p_count => x_msg_count,
3297: p_data => x_msg_data,
3298: p_encoded => FND_API.G_FALSE);
3299: IF l_debug_on THEN
3300: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3301: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');
3302: END IF;
3303: ROLLBACK TO create_update_stop_grp;
3304:
3297: p_data => x_msg_data,
3298: p_encoded => FND_API.G_FALSE);
3299: IF l_debug_on THEN
3300: WSH_DEBUG_SV.logmsg(l_module_name,'RECORD_LOCKED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3301: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:RECORD_LOCKED');
3302: END IF;
3303: ROLLBACK TO create_update_stop_grp;
3304:
3305: WHEN FND_API.G_EXC_ERROR THEN
3314: --Bugfix 4070732 {
3315: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
3316: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
3317: IF l_debug_on THEN
3318: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
3319: END IF;
3320:
3321: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
3322: x_return_status => l_return_status);
3322: x_return_status => l_return_status);
3323:
3324:
3325: IF l_debug_on THEN
3326: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
3327: END IF;
3328:
3329: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
3330: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3337: p_count => x_msg_count,
3338: p_data => x_msg_data,
3339: p_encoded => FND_API.G_FALSE);
3340: IF l_debug_on THEN
3341: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3342: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3343: END IF;
3344:
3345: ROLLBACK TO create_update_stop_grp;
3338: p_data => x_msg_data,
3339: p_encoded => FND_API.G_FALSE);
3340: IF l_debug_on THEN
3341: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3342: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3343: END IF;
3344:
3345: ROLLBACK TO create_update_stop_grp;
3346:
3357: --Bugfix 4070732 {
3358: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
3359: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
3360: IF l_debug_on THEN
3361: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
3362: END IF;
3363:
3364: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
3365: x_return_status => l_return_status);
3365: x_return_status => l_return_status);
3366:
3367:
3368: IF l_debug_on THEN
3369: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
3370: END IF;
3371:
3372: END IF;
3373: END IF;
3376: p_count => x_msg_count,
3377: p_data => x_msg_data,
3378: p_encoded => FND_API.G_FALSE);
3379: IF l_debug_on THEN
3380: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3381: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3382: END IF;
3383: ROLLBACK TO create_update_stop_grp;
3384:
3377: p_data => x_msg_data,
3378: p_encoded => FND_API.G_FALSE);
3379: IF l_debug_on THEN
3380: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3381: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
3382: END IF;
3383: ROLLBACK TO create_update_stop_grp;
3384:
3385: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
3397: IF WSH_WMS_LPN_GRP.G_CALLBACK_REQUIRED = 'Y'
3398: THEN
3399: --{
3400: IF l_debug_on THEN
3401: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',WSH_DEBUG_SV.C_PROC_LEVEL);
3402: END IF;
3403:
3404: WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS
3405: (
3409: );
3410: --
3411: --
3412: IF l_debug_on THEN
3413: WSH_DEBUG_SV.log(l_module_name,'Return status after calling WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS',l_return_status);
3414: END IF;
3415: --
3416: --
3417: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
3426: --Bugfix 4070732 {
3427: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
3428: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
3429: IF l_debug_on THEN
3430: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Process_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
3431: END IF;
3432:
3433: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => TRUE,
3434: x_return_status => l_return_status);
3433: WSH_UTIL_CORE.Process_stops_for_load_tender(p_reset_flags => TRUE,
3434: x_return_status => l_return_status);
3435:
3436: IF l_debug_on THEN
3437: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
3438: END IF;
3439:
3440: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR
3441: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3449: p_count => x_msg_count,
3450: p_data => x_msg_data,
3451: p_encoded => FND_API.G_FALSE);
3452: IF l_debug_on THEN
3453: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3454: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
3455: END IF;
3456:
3457: WHEN OTHERS THEN
3450: p_data => x_msg_data,
3451: p_encoded => FND_API.G_FALSE);
3452: IF l_debug_on THEN
3453: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3454: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
3455: END IF;
3456:
3457: WHEN OTHERS THEN
3458: -- OTM R12, glog proj, close cursors
3467: --Bugfix 4070732 {
3468: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN
3469: IF NOT(WSH_UTIL_CORE.G_CALL_FTE_LOAD_TENDER_API) THEN
3470: IF l_debug_on THEN
3471: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.Reset_stops_for_load_tender',WSH_DEBUG_SV.C_PROC_LEVEL);
3472: END IF;
3473:
3474: WSH_UTIL_CORE.Reset_stops_for_load_tender(p_reset_flags => TRUE,
3475: x_return_status => l_return_status);
3475: x_return_status => l_return_status);
3476:
3477:
3478: IF l_debug_on THEN
3479: WSH_DEBUG_SV.log(l_module_name,'l_return_status',l_return_status);
3480: END IF;
3481:
3482: END IF;
3483: END IF;
3486: p_count => x_msg_count,
3487: p_data => x_msg_data,
3488: p_encoded => FND_API.G_FALSE);
3489: IF l_debug_on THEN
3490: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
3491: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3492: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3493: END IF;
3494: ROLLBACK TO create_update_stop_grp;
3487: p_data => x_msg_data,
3488: p_encoded => FND_API.G_FALSE);
3489: IF l_debug_on THEN
3490: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
3491: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3492: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3493: END IF;
3494: ROLLBACK TO create_update_stop_grp;
3495:
3488: p_encoded => FND_API.G_FALSE);
3489: IF l_debug_on THEN
3490: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
3491: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3492: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3493: END IF;
3494: ROLLBACK TO create_update_stop_grp;
3495:
3496: END CREATE_UPDATE_STOP;
3550: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3551: --
3552: IF l_debug_on IS NULL
3553: THEN
3554: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3555: END IF;
3556: --
3557: IF l_debug_on THEN
3558: wsh_debug_sv.push (l_module_name, 'Create_Update_Stop');
3554: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3555: END IF;
3556: --
3557: IF l_debug_on THEN
3558: wsh_debug_sv.push (l_module_name, 'Create_Update_Stop');
3559: wsh_debug_sv.log (l_module_name,'p_action_code',p_action_code);
3560: wsh_debug_sv.log (l_module_name,'p_stop_info.trip_id',p_stop_info.trip_id);
3561: wsh_debug_sv.log (l_module_name,'p_stop_info.trip_name',p_trip_name);
3562: wsh_debug_sv.log (l_module_name,'p_stop_info.stop_id',p_stop_info.stop_id);
3555: END IF;
3556: --
3557: IF l_debug_on THEN
3558: wsh_debug_sv.push (l_module_name, 'Create_Update_Stop');
3559: wsh_debug_sv.log (l_module_name,'p_action_code',p_action_code);
3560: wsh_debug_sv.log (l_module_name,'p_stop_info.trip_id',p_stop_info.trip_id);
3561: wsh_debug_sv.log (l_module_name,'p_stop_info.trip_name',p_trip_name);
3562: wsh_debug_sv.log (l_module_name,'p_stop_info.stop_id',p_stop_info.stop_id);
3563: wsh_debug_sv.log (l_module_name,'p_stop_info.stop_location_id',p_stop_info.stop_location_id);
3556: --
3557: IF l_debug_on THEN
3558: wsh_debug_sv.push (l_module_name, 'Create_Update_Stop');
3559: wsh_debug_sv.log (l_module_name,'p_action_code',p_action_code);
3560: wsh_debug_sv.log (l_module_name,'p_stop_info.trip_id',p_stop_info.trip_id);
3561: wsh_debug_sv.log (l_module_name,'p_stop_info.trip_name',p_trip_name);
3562: wsh_debug_sv.log (l_module_name,'p_stop_info.stop_id',p_stop_info.stop_id);
3563: wsh_debug_sv.log (l_module_name,'p_stop_info.stop_location_id',p_stop_info.stop_location_id);
3564: wsh_debug_sv.log (l_module_name,'p_stop_info.stop_location_code',p_stop_info.stop_location_code);
3557: IF l_debug_on THEN
3558: wsh_debug_sv.push (l_module_name, 'Create_Update_Stop');
3559: wsh_debug_sv.log (l_module_name,'p_action_code',p_action_code);
3560: wsh_debug_sv.log (l_module_name,'p_stop_info.trip_id',p_stop_info.trip_id);
3561: wsh_debug_sv.log (l_module_name,'p_stop_info.trip_name',p_trip_name);
3562: wsh_debug_sv.log (l_module_name,'p_stop_info.stop_id',p_stop_info.stop_id);
3563: wsh_debug_sv.log (l_module_name,'p_stop_info.stop_location_id',p_stop_info.stop_location_id);
3564: wsh_debug_sv.log (l_module_name,'p_stop_info.stop_location_code',p_stop_info.stop_location_code);
3565: wsh_debug_sv.log (l_module_name,'p_stop_location_code',p_stop_location_code);
3558: wsh_debug_sv.push (l_module_name, 'Create_Update_Stop');
3559: wsh_debug_sv.log (l_module_name,'p_action_code',p_action_code);
3560: wsh_debug_sv.log (l_module_name,'p_stop_info.trip_id',p_stop_info.trip_id);
3561: wsh_debug_sv.log (l_module_name,'p_stop_info.trip_name',p_trip_name);
3562: wsh_debug_sv.log (l_module_name,'p_stop_info.stop_id',p_stop_info.stop_id);
3563: wsh_debug_sv.log (l_module_name,'p_stop_info.stop_location_id',p_stop_info.stop_location_id);
3564: wsh_debug_sv.log (l_module_name,'p_stop_info.stop_location_code',p_stop_info.stop_location_code);
3565: wsh_debug_sv.log (l_module_name,'p_stop_location_code',p_stop_location_code);
3566: wsh_debug_sv.log (l_module_name,'p_stop_info.stop_sequence_number',p_stop_info.stop_sequence_number);
3559: wsh_debug_sv.log (l_module_name,'p_action_code',p_action_code);
3560: wsh_debug_sv.log (l_module_name,'p_stop_info.trip_id',p_stop_info.trip_id);
3561: wsh_debug_sv.log (l_module_name,'p_stop_info.trip_name',p_trip_name);
3562: wsh_debug_sv.log (l_module_name,'p_stop_info.stop_id',p_stop_info.stop_id);
3563: wsh_debug_sv.log (l_module_name,'p_stop_info.stop_location_id',p_stop_info.stop_location_id);
3564: wsh_debug_sv.log (l_module_name,'p_stop_info.stop_location_code',p_stop_info.stop_location_code);
3565: wsh_debug_sv.log (l_module_name,'p_stop_location_code',p_stop_location_code);
3566: wsh_debug_sv.log (l_module_name,'p_stop_info.stop_sequence_number',p_stop_info.stop_sequence_number);
3567: END IF;
3560: wsh_debug_sv.log (l_module_name,'p_stop_info.trip_id',p_stop_info.trip_id);
3561: wsh_debug_sv.log (l_module_name,'p_stop_info.trip_name',p_trip_name);
3562: wsh_debug_sv.log (l_module_name,'p_stop_info.stop_id',p_stop_info.stop_id);
3563: wsh_debug_sv.log (l_module_name,'p_stop_info.stop_location_id',p_stop_info.stop_location_id);
3564: wsh_debug_sv.log (l_module_name,'p_stop_info.stop_location_code',p_stop_info.stop_location_code);
3565: wsh_debug_sv.log (l_module_name,'p_stop_location_code',p_stop_location_code);
3566: wsh_debug_sv.log (l_module_name,'p_stop_info.stop_sequence_number',p_stop_info.stop_sequence_number);
3567: END IF;
3568:
3561: wsh_debug_sv.log (l_module_name,'p_stop_info.trip_name',p_trip_name);
3562: wsh_debug_sv.log (l_module_name,'p_stop_info.stop_id',p_stop_info.stop_id);
3563: wsh_debug_sv.log (l_module_name,'p_stop_info.stop_location_id',p_stop_info.stop_location_id);
3564: wsh_debug_sv.log (l_module_name,'p_stop_info.stop_location_code',p_stop_info.stop_location_code);
3565: wsh_debug_sv.log (l_module_name,'p_stop_location_code',p_stop_location_code);
3566: wsh_debug_sv.log (l_module_name,'p_stop_info.stop_sequence_number',p_stop_info.stop_sequence_number);
3567: END IF;
3568:
3569: IF l_debug_on THEN
3562: wsh_debug_sv.log (l_module_name,'p_stop_info.stop_id',p_stop_info.stop_id);
3563: wsh_debug_sv.log (l_module_name,'p_stop_info.stop_location_id',p_stop_info.stop_location_id);
3564: wsh_debug_sv.log (l_module_name,'p_stop_info.stop_location_code',p_stop_info.stop_location_code);
3565: wsh_debug_sv.log (l_module_name,'p_stop_location_code',p_stop_location_code);
3566: wsh_debug_sv.log (l_module_name,'p_stop_info.stop_sequence_number',p_stop_info.stop_sequence_number);
3567: END IF;
3568:
3569: IF l_debug_on THEN
3570: wsh_debug_sv.push (l_module_name, 'Create_Update_Stop');
3566: wsh_debug_sv.log (l_module_name,'p_stop_info.stop_sequence_number',p_stop_info.stop_sequence_number);
3567: END IF;
3568:
3569: IF l_debug_on THEN
3570: wsh_debug_sv.push (l_module_name, 'Create_Update_Stop');
3571: END IF;
3572:
3573: IF NOT FND_API.Compatible_API_Call (l_api_version_number,p_api_version_number ,l_api_name ,G_PKG_NAME) THEN
3574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3582: p_grp_stop_rec => p_stop_info,
3583: x_pvt_stop_rec => l_pvt_stop_rec,
3584: x_return_status => x_return_status);
3585: IF l_debug_on THEN
3586: wsh_debug_sv.log (l_module_name, 'map_stoppub_to_pvt x_return_status',x_return_status);
3587: END IF;
3588: IF ( x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
3589: raise FND_API.G_EXC_ERROR;
3590: END IF;
3625: x_msg_count => x_msg_count,
3626: x_msg_data => x_msg_data);
3627:
3628: IF l_debug_on THEN
3629: WSH_DEBUG_SV.log(l_module_name,'WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP x_return_status',x_return_status);
3630: END IF;
3631:
3632: IF ( x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS AND l_stop_out_tab.count > 0) THEN
3633: x_stop_id := l_stop_out_tab(l_stop_out_tab.FIRST).stop_id;
3638: p_data => x_msg_data
3639: , p_encoded => FND_API.G_FALSE);
3640:
3641: IF l_debug_on THEN
3642: WSH_DEBUG_SV.pop(l_module_name);
3643: END IF;
3644:
3645: EXCEPTION
3646: WHEN OTHERS THEN
3646: WHEN OTHERS THEN
3647: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3648: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');
3649: IF l_debug_on THEN
3650: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
3651: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3652: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3653: END IF;
3654:
3647: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3648: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');
3649: IF l_debug_on THEN
3650: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
3651: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3652: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3653: END IF;
3654:
3655: END CREATE_UPDATE_STOP;
3648: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');
3649: IF l_debug_on THEN
3650: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
3651: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3652: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3653: END IF;
3654:
3655: END CREATE_UPDATE_STOP;
3656:
3701: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3702: --
3703: IF l_debug_on IS NULL
3704: THEN
3705: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3706: END IF;
3707: --
3708: IF l_debug_on THEN
3709: wsh_debug_sv.push(l_module_name);
3705: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3706: END IF;
3707: --
3708: IF l_debug_on THEN
3709: wsh_debug_sv.push(l_module_name);
3710: WSH_DEBUG_SV.log(l_module_name,'action_code',p_stop_IN_rec.action_code);
3711: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',p_init_msg_list );
3712: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
3713: WSH_DEBUG_SV.log(l_module_name,'trip_id', p_stop_info.trip_id);
3706: END IF;
3707: --
3708: IF l_debug_on THEN
3709: wsh_debug_sv.push(l_module_name);
3710: WSH_DEBUG_SV.log(l_module_name,'action_code',p_stop_IN_rec.action_code);
3711: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',p_init_msg_list );
3712: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
3713: WSH_DEBUG_SV.log(l_module_name,'trip_id', p_stop_info.trip_id);
3714: WSH_DEBUG_SV.log(l_module_name,'stop_location_id', p_stop_info.stop_location_id);
3707: --
3708: IF l_debug_on THEN
3709: wsh_debug_sv.push(l_module_name);
3710: WSH_DEBUG_SV.log(l_module_name,'action_code',p_stop_IN_rec.action_code);
3711: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',p_init_msg_list );
3712: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
3713: WSH_DEBUG_SV.log(l_module_name,'trip_id', p_stop_info.trip_id);
3714: WSH_DEBUG_SV.log(l_module_name,'stop_location_id', p_stop_info.stop_location_id);
3715: WSH_DEBUG_SV.log(l_module_name,'stop_sequence_number', p_stop_info.stop_sequence_number);
3708: IF l_debug_on THEN
3709: wsh_debug_sv.push(l_module_name);
3710: WSH_DEBUG_SV.log(l_module_name,'action_code',p_stop_IN_rec.action_code);
3711: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',p_init_msg_list );
3712: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
3713: WSH_DEBUG_SV.log(l_module_name,'trip_id', p_stop_info.trip_id);
3714: WSH_DEBUG_SV.log(l_module_name,'stop_location_id', p_stop_info.stop_location_id);
3715: WSH_DEBUG_SV.log(l_module_name,'stop_sequence_number', p_stop_info.stop_sequence_number);
3716: WSH_DEBUG_SV.log(l_module_name,'planned_arrival_date', p_stop_info.planned_arrival_date);
3709: wsh_debug_sv.push(l_module_name);
3710: WSH_DEBUG_SV.log(l_module_name,'action_code',p_stop_IN_rec.action_code);
3711: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',p_init_msg_list );
3712: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
3713: WSH_DEBUG_SV.log(l_module_name,'trip_id', p_stop_info.trip_id);
3714: WSH_DEBUG_SV.log(l_module_name,'stop_location_id', p_stop_info.stop_location_id);
3715: WSH_DEBUG_SV.log(l_module_name,'stop_sequence_number', p_stop_info.stop_sequence_number);
3716: WSH_DEBUG_SV.log(l_module_name,'planned_arrival_date', p_stop_info.planned_arrival_date);
3717: WSH_DEBUG_SV.log(l_module_name,'planned_departure_date', p_stop_info.planned_departure_date);
3710: WSH_DEBUG_SV.log(l_module_name,'action_code',p_stop_IN_rec.action_code);
3711: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',p_init_msg_list );
3712: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
3713: WSH_DEBUG_SV.log(l_module_name,'trip_id', p_stop_info.trip_id);
3714: WSH_DEBUG_SV.log(l_module_name,'stop_location_id', p_stop_info.stop_location_id);
3715: WSH_DEBUG_SV.log(l_module_name,'stop_sequence_number', p_stop_info.stop_sequence_number);
3716: WSH_DEBUG_SV.log(l_module_name,'planned_arrival_date', p_stop_info.planned_arrival_date);
3717: WSH_DEBUG_SV.log(l_module_name,'planned_departure_date', p_stop_info.planned_departure_date);
3718: WSH_DEBUG_SV.log(l_module_name,'actual_arrival_date', p_stop_info.actual_arrival_date);
3711: WSH_DEBUG_SV.log(l_module_name,'p_init_msg_list',p_init_msg_list );
3712: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
3713: WSH_DEBUG_SV.log(l_module_name,'trip_id', p_stop_info.trip_id);
3714: WSH_DEBUG_SV.log(l_module_name,'stop_location_id', p_stop_info.stop_location_id);
3715: WSH_DEBUG_SV.log(l_module_name,'stop_sequence_number', p_stop_info.stop_sequence_number);
3716: WSH_DEBUG_SV.log(l_module_name,'planned_arrival_date', p_stop_info.planned_arrival_date);
3717: WSH_DEBUG_SV.log(l_module_name,'planned_departure_date', p_stop_info.planned_departure_date);
3718: WSH_DEBUG_SV.log(l_module_name,'actual_arrival_date', p_stop_info.actual_arrival_date);
3719: WSH_DEBUG_SV.log(l_module_name,'actual_departure_date', p_stop_info.actual_departure_date);
3712: WSH_DEBUG_SV.log(l_module_name,'p_commit',p_commit);
3713: WSH_DEBUG_SV.log(l_module_name,'trip_id', p_stop_info.trip_id);
3714: WSH_DEBUG_SV.log(l_module_name,'stop_location_id', p_stop_info.stop_location_id);
3715: WSH_DEBUG_SV.log(l_module_name,'stop_sequence_number', p_stop_info.stop_sequence_number);
3716: WSH_DEBUG_SV.log(l_module_name,'planned_arrival_date', p_stop_info.planned_arrival_date);
3717: WSH_DEBUG_SV.log(l_module_name,'planned_departure_date', p_stop_info.planned_departure_date);
3718: WSH_DEBUG_SV.log(l_module_name,'actual_arrival_date', p_stop_info.actual_arrival_date);
3719: WSH_DEBUG_SV.log(l_module_name,'actual_departure_date', p_stop_info.actual_departure_date);
3720: WSH_DEBUG_SV.log(l_module_name,'departure_gross_weight', p_stop_info.departure_gross_weight);
3713: WSH_DEBUG_SV.log(l_module_name,'trip_id', p_stop_info.trip_id);
3714: WSH_DEBUG_SV.log(l_module_name,'stop_location_id', p_stop_info.stop_location_id);
3715: WSH_DEBUG_SV.log(l_module_name,'stop_sequence_number', p_stop_info.stop_sequence_number);
3716: WSH_DEBUG_SV.log(l_module_name,'planned_arrival_date', p_stop_info.planned_arrival_date);
3717: WSH_DEBUG_SV.log(l_module_name,'planned_departure_date', p_stop_info.planned_departure_date);
3718: WSH_DEBUG_SV.log(l_module_name,'actual_arrival_date', p_stop_info.actual_arrival_date);
3719: WSH_DEBUG_SV.log(l_module_name,'actual_departure_date', p_stop_info.actual_departure_date);
3720: WSH_DEBUG_SV.log(l_module_name,'departure_gross_weight', p_stop_info.departure_gross_weight);
3721: WSH_DEBUG_SV.log(l_module_name,'departure_net_weight', p_stop_info.departure_net_weight);
3714: WSH_DEBUG_SV.log(l_module_name,'stop_location_id', p_stop_info.stop_location_id);
3715: WSH_DEBUG_SV.log(l_module_name,'stop_sequence_number', p_stop_info.stop_sequence_number);
3716: WSH_DEBUG_SV.log(l_module_name,'planned_arrival_date', p_stop_info.planned_arrival_date);
3717: WSH_DEBUG_SV.log(l_module_name,'planned_departure_date', p_stop_info.planned_departure_date);
3718: WSH_DEBUG_SV.log(l_module_name,'actual_arrival_date', p_stop_info.actual_arrival_date);
3719: WSH_DEBUG_SV.log(l_module_name,'actual_departure_date', p_stop_info.actual_departure_date);
3720: WSH_DEBUG_SV.log(l_module_name,'departure_gross_weight', p_stop_info.departure_gross_weight);
3721: WSH_DEBUG_SV.log(l_module_name,'departure_net_weight', p_stop_info.departure_net_weight);
3722: WSH_DEBUG_SV.log(l_module_name,'weight_uom_code', p_stop_info.weight_uom_code);
3715: WSH_DEBUG_SV.log(l_module_name,'stop_sequence_number', p_stop_info.stop_sequence_number);
3716: WSH_DEBUG_SV.log(l_module_name,'planned_arrival_date', p_stop_info.planned_arrival_date);
3717: WSH_DEBUG_SV.log(l_module_name,'planned_departure_date', p_stop_info.planned_departure_date);
3718: WSH_DEBUG_SV.log(l_module_name,'actual_arrival_date', p_stop_info.actual_arrival_date);
3719: WSH_DEBUG_SV.log(l_module_name,'actual_departure_date', p_stop_info.actual_departure_date);
3720: WSH_DEBUG_SV.log(l_module_name,'departure_gross_weight', p_stop_info.departure_gross_weight);
3721: WSH_DEBUG_SV.log(l_module_name,'departure_net_weight', p_stop_info.departure_net_weight);
3722: WSH_DEBUG_SV.log(l_module_name,'weight_uom_code', p_stop_info.weight_uom_code);
3723: WSH_DEBUG_SV.log(l_module_name,'departure_volume', p_stop_info.departure_volume);
3716: WSH_DEBUG_SV.log(l_module_name,'planned_arrival_date', p_stop_info.planned_arrival_date);
3717: WSH_DEBUG_SV.log(l_module_name,'planned_departure_date', p_stop_info.planned_departure_date);
3718: WSH_DEBUG_SV.log(l_module_name,'actual_arrival_date', p_stop_info.actual_arrival_date);
3719: WSH_DEBUG_SV.log(l_module_name,'actual_departure_date', p_stop_info.actual_departure_date);
3720: WSH_DEBUG_SV.log(l_module_name,'departure_gross_weight', p_stop_info.departure_gross_weight);
3721: WSH_DEBUG_SV.log(l_module_name,'departure_net_weight', p_stop_info.departure_net_weight);
3722: WSH_DEBUG_SV.log(l_module_name,'weight_uom_code', p_stop_info.weight_uom_code);
3723: WSH_DEBUG_SV.log(l_module_name,'departure_volume', p_stop_info.departure_volume);
3724: WSH_DEBUG_SV.log(l_module_name,'volume_uom_code', p_stop_info.volume_uom_code);
3717: WSH_DEBUG_SV.log(l_module_name,'planned_departure_date', p_stop_info.planned_departure_date);
3718: WSH_DEBUG_SV.log(l_module_name,'actual_arrival_date', p_stop_info.actual_arrival_date);
3719: WSH_DEBUG_SV.log(l_module_name,'actual_departure_date', p_stop_info.actual_departure_date);
3720: WSH_DEBUG_SV.log(l_module_name,'departure_gross_weight', p_stop_info.departure_gross_weight);
3721: WSH_DEBUG_SV.log(l_module_name,'departure_net_weight', p_stop_info.departure_net_weight);
3722: WSH_DEBUG_SV.log(l_module_name,'weight_uom_code', p_stop_info.weight_uom_code);
3723: WSH_DEBUG_SV.log(l_module_name,'departure_volume', p_stop_info.departure_volume);
3724: WSH_DEBUG_SV.log(l_module_name,'volume_uom_code', p_stop_info.volume_uom_code);
3725: WSH_DEBUG_SV.log(l_module_name,'departure_seal_code', p_stop_info.departure_seal_code);
3718: WSH_DEBUG_SV.log(l_module_name,'actual_arrival_date', p_stop_info.actual_arrival_date);
3719: WSH_DEBUG_SV.log(l_module_name,'actual_departure_date', p_stop_info.actual_departure_date);
3720: WSH_DEBUG_SV.log(l_module_name,'departure_gross_weight', p_stop_info.departure_gross_weight);
3721: WSH_DEBUG_SV.log(l_module_name,'departure_net_weight', p_stop_info.departure_net_weight);
3722: WSH_DEBUG_SV.log(l_module_name,'weight_uom_code', p_stop_info.weight_uom_code);
3723: WSH_DEBUG_SV.log(l_module_name,'departure_volume', p_stop_info.departure_volume);
3724: WSH_DEBUG_SV.log(l_module_name,'volume_uom_code', p_stop_info.volume_uom_code);
3725: WSH_DEBUG_SV.log(l_module_name,'departure_seal_code', p_stop_info.departure_seal_code);
3726: WSH_DEBUG_SV.log(l_module_name,'departure_fill_percent', p_stop_info.departure_fill_percent);
3719: WSH_DEBUG_SV.log(l_module_name,'actual_departure_date', p_stop_info.actual_departure_date);
3720: WSH_DEBUG_SV.log(l_module_name,'departure_gross_weight', p_stop_info.departure_gross_weight);
3721: WSH_DEBUG_SV.log(l_module_name,'departure_net_weight', p_stop_info.departure_net_weight);
3722: WSH_DEBUG_SV.log(l_module_name,'weight_uom_code', p_stop_info.weight_uom_code);
3723: WSH_DEBUG_SV.log(l_module_name,'departure_volume', p_stop_info.departure_volume);
3724: WSH_DEBUG_SV.log(l_module_name,'volume_uom_code', p_stop_info.volume_uom_code);
3725: WSH_DEBUG_SV.log(l_module_name,'departure_seal_code', p_stop_info.departure_seal_code);
3726: WSH_DEBUG_SV.log(l_module_name,'departure_fill_percent', p_stop_info.departure_fill_percent);
3727: WSH_DEBUG_SV.log(l_module_name,'lock_stop_id', p_stop_info.departure_fill_percent);
3720: WSH_DEBUG_SV.log(l_module_name,'departure_gross_weight', p_stop_info.departure_gross_weight);
3721: WSH_DEBUG_SV.log(l_module_name,'departure_net_weight', p_stop_info.departure_net_weight);
3722: WSH_DEBUG_SV.log(l_module_name,'weight_uom_code', p_stop_info.weight_uom_code);
3723: WSH_DEBUG_SV.log(l_module_name,'departure_volume', p_stop_info.departure_volume);
3724: WSH_DEBUG_SV.log(l_module_name,'volume_uom_code', p_stop_info.volume_uom_code);
3725: WSH_DEBUG_SV.log(l_module_name,'departure_seal_code', p_stop_info.departure_seal_code);
3726: WSH_DEBUG_SV.log(l_module_name,'departure_fill_percent', p_stop_info.departure_fill_percent);
3727: WSH_DEBUG_SV.log(l_module_name,'lock_stop_id', p_stop_info.departure_fill_percent);
3728: WSH_DEBUG_SV.log(l_module_name,'pending_interface_flag', p_stop_info.pending_interface_flag);
3721: WSH_DEBUG_SV.log(l_module_name,'departure_net_weight', p_stop_info.departure_net_weight);
3722: WSH_DEBUG_SV.log(l_module_name,'weight_uom_code', p_stop_info.weight_uom_code);
3723: WSH_DEBUG_SV.log(l_module_name,'departure_volume', p_stop_info.departure_volume);
3724: WSH_DEBUG_SV.log(l_module_name,'volume_uom_code', p_stop_info.volume_uom_code);
3725: WSH_DEBUG_SV.log(l_module_name,'departure_seal_code', p_stop_info.departure_seal_code);
3726: WSH_DEBUG_SV.log(l_module_name,'departure_fill_percent', p_stop_info.departure_fill_percent);
3727: WSH_DEBUG_SV.log(l_module_name,'lock_stop_id', p_stop_info.departure_fill_percent);
3728: WSH_DEBUG_SV.log(l_module_name,'pending_interface_flag', p_stop_info.pending_interface_flag);
3729: WSH_DEBUG_SV.log(l_module_name,'transaction_header_id', p_stop_info.transaction_header_id);
3722: WSH_DEBUG_SV.log(l_module_name,'weight_uom_code', p_stop_info.weight_uom_code);
3723: WSH_DEBUG_SV.log(l_module_name,'departure_volume', p_stop_info.departure_volume);
3724: WSH_DEBUG_SV.log(l_module_name,'volume_uom_code', p_stop_info.volume_uom_code);
3725: WSH_DEBUG_SV.log(l_module_name,'departure_seal_code', p_stop_info.departure_seal_code);
3726: WSH_DEBUG_SV.log(l_module_name,'departure_fill_percent', p_stop_info.departure_fill_percent);
3727: WSH_DEBUG_SV.log(l_module_name,'lock_stop_id', p_stop_info.departure_fill_percent);
3728: WSH_DEBUG_SV.log(l_module_name,'pending_interface_flag', p_stop_info.pending_interface_flag);
3729: WSH_DEBUG_SV.log(l_module_name,'transaction_header_id', p_stop_info.transaction_header_id);
3730: WSH_DEBUG_SV.log(l_module_name,'wsh_location_id', p_stop_info.wsh_location_id);
3723: WSH_DEBUG_SV.log(l_module_name,'departure_volume', p_stop_info.departure_volume);
3724: WSH_DEBUG_SV.log(l_module_name,'volume_uom_code', p_stop_info.volume_uom_code);
3725: WSH_DEBUG_SV.log(l_module_name,'departure_seal_code', p_stop_info.departure_seal_code);
3726: WSH_DEBUG_SV.log(l_module_name,'departure_fill_percent', p_stop_info.departure_fill_percent);
3727: WSH_DEBUG_SV.log(l_module_name,'lock_stop_id', p_stop_info.departure_fill_percent);
3728: WSH_DEBUG_SV.log(l_module_name,'pending_interface_flag', p_stop_info.pending_interface_flag);
3729: WSH_DEBUG_SV.log(l_module_name,'transaction_header_id', p_stop_info.transaction_header_id);
3730: WSH_DEBUG_SV.log(l_module_name,'wsh_location_id', p_stop_info.wsh_location_id);
3731: WSH_DEBUG_SV.log(l_module_name,'tracking_drilldown_flag', p_stop_info.tracking_drilldown_flag);
3724: WSH_DEBUG_SV.log(l_module_name,'volume_uom_code', p_stop_info.volume_uom_code);
3725: WSH_DEBUG_SV.log(l_module_name,'departure_seal_code', p_stop_info.departure_seal_code);
3726: WSH_DEBUG_SV.log(l_module_name,'departure_fill_percent', p_stop_info.departure_fill_percent);
3727: WSH_DEBUG_SV.log(l_module_name,'lock_stop_id', p_stop_info.departure_fill_percent);
3728: WSH_DEBUG_SV.log(l_module_name,'pending_interface_flag', p_stop_info.pending_interface_flag);
3729: WSH_DEBUG_SV.log(l_module_name,'transaction_header_id', p_stop_info.transaction_header_id);
3730: WSH_DEBUG_SV.log(l_module_name,'wsh_location_id', p_stop_info.wsh_location_id);
3731: WSH_DEBUG_SV.log(l_module_name,'tracking_drilldown_flag', p_stop_info.tracking_drilldown_flag);
3732: WSH_DEBUG_SV.log(l_module_name,'tracking_remarks', p_stop_info.tracking_remarks);
3725: WSH_DEBUG_SV.log(l_module_name,'departure_seal_code', p_stop_info.departure_seal_code);
3726: WSH_DEBUG_SV.log(l_module_name,'departure_fill_percent', p_stop_info.departure_fill_percent);
3727: WSH_DEBUG_SV.log(l_module_name,'lock_stop_id', p_stop_info.departure_fill_percent);
3728: WSH_DEBUG_SV.log(l_module_name,'pending_interface_flag', p_stop_info.pending_interface_flag);
3729: WSH_DEBUG_SV.log(l_module_name,'transaction_header_id', p_stop_info.transaction_header_id);
3730: WSH_DEBUG_SV.log(l_module_name,'wsh_location_id', p_stop_info.wsh_location_id);
3731: WSH_DEBUG_SV.log(l_module_name,'tracking_drilldown_flag', p_stop_info.tracking_drilldown_flag);
3732: WSH_DEBUG_SV.log(l_module_name,'tracking_remarks', p_stop_info.tracking_remarks);
3733: WSH_DEBUG_SV.log(l_module_name,'carrier_est_departure_date', p_stop_info.carrier_est_departure_date);
3726: WSH_DEBUG_SV.log(l_module_name,'departure_fill_percent', p_stop_info.departure_fill_percent);
3727: WSH_DEBUG_SV.log(l_module_name,'lock_stop_id', p_stop_info.departure_fill_percent);
3728: WSH_DEBUG_SV.log(l_module_name,'pending_interface_flag', p_stop_info.pending_interface_flag);
3729: WSH_DEBUG_SV.log(l_module_name,'transaction_header_id', p_stop_info.transaction_header_id);
3730: WSH_DEBUG_SV.log(l_module_name,'wsh_location_id', p_stop_info.wsh_location_id);
3731: WSH_DEBUG_SV.log(l_module_name,'tracking_drilldown_flag', p_stop_info.tracking_drilldown_flag);
3732: WSH_DEBUG_SV.log(l_module_name,'tracking_remarks', p_stop_info.tracking_remarks);
3733: WSH_DEBUG_SV.log(l_module_name,'carrier_est_departure_date', p_stop_info.carrier_est_departure_date);
3734: WSH_DEBUG_SV.log(l_module_name,'carrier_est_arrival_date', p_stop_info.carrier_est_arrival_date);
3727: WSH_DEBUG_SV.log(l_module_name,'lock_stop_id', p_stop_info.departure_fill_percent);
3728: WSH_DEBUG_SV.log(l_module_name,'pending_interface_flag', p_stop_info.pending_interface_flag);
3729: WSH_DEBUG_SV.log(l_module_name,'transaction_header_id', p_stop_info.transaction_header_id);
3730: WSH_DEBUG_SV.log(l_module_name,'wsh_location_id', p_stop_info.wsh_location_id);
3731: WSH_DEBUG_SV.log(l_module_name,'tracking_drilldown_flag', p_stop_info.tracking_drilldown_flag);
3732: WSH_DEBUG_SV.log(l_module_name,'tracking_remarks', p_stop_info.tracking_remarks);
3733: WSH_DEBUG_SV.log(l_module_name,'carrier_est_departure_date', p_stop_info.carrier_est_departure_date);
3734: WSH_DEBUG_SV.log(l_module_name,'carrier_est_arrival_date', p_stop_info.carrier_est_arrival_date);
3735: WSH_DEBUG_SV.log(l_module_name,'loading_start_datetime', p_stop_info.loading_start_datetime);
3728: WSH_DEBUG_SV.log(l_module_name,'pending_interface_flag', p_stop_info.pending_interface_flag);
3729: WSH_DEBUG_SV.log(l_module_name,'transaction_header_id', p_stop_info.transaction_header_id);
3730: WSH_DEBUG_SV.log(l_module_name,'wsh_location_id', p_stop_info.wsh_location_id);
3731: WSH_DEBUG_SV.log(l_module_name,'tracking_drilldown_flag', p_stop_info.tracking_drilldown_flag);
3732: WSH_DEBUG_SV.log(l_module_name,'tracking_remarks', p_stop_info.tracking_remarks);
3733: WSH_DEBUG_SV.log(l_module_name,'carrier_est_departure_date', p_stop_info.carrier_est_departure_date);
3734: WSH_DEBUG_SV.log(l_module_name,'carrier_est_arrival_date', p_stop_info.carrier_est_arrival_date);
3735: WSH_DEBUG_SV.log(l_module_name,'loading_start_datetime', p_stop_info.loading_start_datetime);
3736: WSH_DEBUG_SV.log(l_module_name,'loading_end_datetime', p_stop_info.loading_end_datetime);
3729: WSH_DEBUG_SV.log(l_module_name,'transaction_header_id', p_stop_info.transaction_header_id);
3730: WSH_DEBUG_SV.log(l_module_name,'wsh_location_id', p_stop_info.wsh_location_id);
3731: WSH_DEBUG_SV.log(l_module_name,'tracking_drilldown_flag', p_stop_info.tracking_drilldown_flag);
3732: WSH_DEBUG_SV.log(l_module_name,'tracking_remarks', p_stop_info.tracking_remarks);
3733: WSH_DEBUG_SV.log(l_module_name,'carrier_est_departure_date', p_stop_info.carrier_est_departure_date);
3734: WSH_DEBUG_SV.log(l_module_name,'carrier_est_arrival_date', p_stop_info.carrier_est_arrival_date);
3735: WSH_DEBUG_SV.log(l_module_name,'loading_start_datetime', p_stop_info.loading_start_datetime);
3736: WSH_DEBUG_SV.log(l_module_name,'loading_end_datetime', p_stop_info.loading_end_datetime);
3737: WSH_DEBUG_SV.log(l_module_name,'unloading_start_datetime', p_stop_info.unloading_start_datetime);
3730: WSH_DEBUG_SV.log(l_module_name,'wsh_location_id', p_stop_info.wsh_location_id);
3731: WSH_DEBUG_SV.log(l_module_name,'tracking_drilldown_flag', p_stop_info.tracking_drilldown_flag);
3732: WSH_DEBUG_SV.log(l_module_name,'tracking_remarks', p_stop_info.tracking_remarks);
3733: WSH_DEBUG_SV.log(l_module_name,'carrier_est_departure_date', p_stop_info.carrier_est_departure_date);
3734: WSH_DEBUG_SV.log(l_module_name,'carrier_est_arrival_date', p_stop_info.carrier_est_arrival_date);
3735: WSH_DEBUG_SV.log(l_module_name,'loading_start_datetime', p_stop_info.loading_start_datetime);
3736: WSH_DEBUG_SV.log(l_module_name,'loading_end_datetime', p_stop_info.loading_end_datetime);
3737: WSH_DEBUG_SV.log(l_module_name,'unloading_start_datetime', p_stop_info.unloading_start_datetime);
3738: WSH_DEBUG_SV.log(l_module_name,'unloading_end_datetime', p_stop_info.unloading_end_datetime);
3731: WSH_DEBUG_SV.log(l_module_name,'tracking_drilldown_flag', p_stop_info.tracking_drilldown_flag);
3732: WSH_DEBUG_SV.log(l_module_name,'tracking_remarks', p_stop_info.tracking_remarks);
3733: WSH_DEBUG_SV.log(l_module_name,'carrier_est_departure_date', p_stop_info.carrier_est_departure_date);
3734: WSH_DEBUG_SV.log(l_module_name,'carrier_est_arrival_date', p_stop_info.carrier_est_arrival_date);
3735: WSH_DEBUG_SV.log(l_module_name,'loading_start_datetime', p_stop_info.loading_start_datetime);
3736: WSH_DEBUG_SV.log(l_module_name,'loading_end_datetime', p_stop_info.loading_end_datetime);
3737: WSH_DEBUG_SV.log(l_module_name,'unloading_start_datetime', p_stop_info.unloading_start_datetime);
3738: WSH_DEBUG_SV.log(l_module_name,'unloading_end_datetime', p_stop_info.unloading_end_datetime);
3739: END IF;
3732: WSH_DEBUG_SV.log(l_module_name,'tracking_remarks', p_stop_info.tracking_remarks);
3733: WSH_DEBUG_SV.log(l_module_name,'carrier_est_departure_date', p_stop_info.carrier_est_departure_date);
3734: WSH_DEBUG_SV.log(l_module_name,'carrier_est_arrival_date', p_stop_info.carrier_est_arrival_date);
3735: WSH_DEBUG_SV.log(l_module_name,'loading_start_datetime', p_stop_info.loading_start_datetime);
3736: WSH_DEBUG_SV.log(l_module_name,'loading_end_datetime', p_stop_info.loading_end_datetime);
3737: WSH_DEBUG_SV.log(l_module_name,'unloading_start_datetime', p_stop_info.unloading_start_datetime);
3738: WSH_DEBUG_SV.log(l_module_name,'unloading_end_datetime', p_stop_info.unloading_end_datetime);
3739: END IF;
3740:
3733: WSH_DEBUG_SV.log(l_module_name,'carrier_est_departure_date', p_stop_info.carrier_est_departure_date);
3734: WSH_DEBUG_SV.log(l_module_name,'carrier_est_arrival_date', p_stop_info.carrier_est_arrival_date);
3735: WSH_DEBUG_SV.log(l_module_name,'loading_start_datetime', p_stop_info.loading_start_datetime);
3736: WSH_DEBUG_SV.log(l_module_name,'loading_end_datetime', p_stop_info.loading_end_datetime);
3737: WSH_DEBUG_SV.log(l_module_name,'unloading_start_datetime', p_stop_info.unloading_start_datetime);
3738: WSH_DEBUG_SV.log(l_module_name,'unloading_end_datetime', p_stop_info.unloading_end_datetime);
3739: END IF;
3740:
3741: IF NOT FND_API.Compatible_API_Call (l_api_version_number,p_api_version_number ,l_api_name ,G_PKG_NAME) THEN
3734: WSH_DEBUG_SV.log(l_module_name,'carrier_est_arrival_date', p_stop_info.carrier_est_arrival_date);
3735: WSH_DEBUG_SV.log(l_module_name,'loading_start_datetime', p_stop_info.loading_start_datetime);
3736: WSH_DEBUG_SV.log(l_module_name,'loading_end_datetime', p_stop_info.loading_end_datetime);
3737: WSH_DEBUG_SV.log(l_module_name,'unloading_start_datetime', p_stop_info.unloading_start_datetime);
3738: WSH_DEBUG_SV.log(l_module_name,'unloading_end_datetime', p_stop_info.unloading_end_datetime);
3739: END IF;
3740:
3741: IF NOT FND_API.Compatible_API_Call (l_api_version_number,p_api_version_number ,l_api_name ,G_PKG_NAME) THEN
3742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3750: p_grp_stop_rec => p_stop_info,
3751: x_pvt_stop_rec => l_pvt_stop_rec,
3752: x_return_status => x_return_status);
3753: IF l_debug_on THEN
3754: wsh_debug_sv.log (l_module_name, 'map_stoppub_to_pvt x_return_status',x_return_status);
3755: END IF;
3756: IF ( x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
3757: raise FND_API.G_EXC_ERROR;
3758: END IF;
3770: x_msg_count => x_msg_count,
3771: x_msg_data => x_msg_data);
3772:
3773: IF l_debug_on THEN
3774: WSH_DEBUG_SV.log(l_module_name,'WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP x_return_status',x_return_status);
3775: END IF;
3776:
3777: IF ( x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS AND l_stop_out_tab.count > 0) THEN
3778: x_stop_out_rec := l_stop_out_tab(l_stop_out_tab.FIRST);
3783: p_data => x_msg_data
3784: , p_encoded => FND_API.G_FALSE);
3785:
3786: IF l_debug_on THEN
3787: WSH_DEBUG_SV.pop(l_module_name);
3788: END IF;
3789: EXCEPTION
3790: WHEN FND_API.G_EXC_ERROR THEN
3791: IF l_debug_on THEN
3788: END IF;
3789: EXCEPTION
3790: WHEN FND_API.G_EXC_ERROR THEN
3791: IF l_debug_on THEN
3792: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3793: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3794: END IF;
3795:
3796: WHEN OTHERS THEN
3789: EXCEPTION
3790: WHEN FND_API.G_EXC_ERROR THEN
3791: IF l_debug_on THEN
3792: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3793: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
3794: END IF;
3795:
3796: WHEN OTHERS THEN
3797: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3796: WHEN OTHERS THEN
3797: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3798: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');
3799: IF l_debug_on THEN
3800: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
3801: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3802: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3803: END IF;
3804:
3797: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3798: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');
3799: IF l_debug_on THEN
3800: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
3801: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3802: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3803: END IF;
3804:
3805: END CREATE_UPDATE_STOP_NEW;
3798: wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');
3799: IF l_debug_on THEN
3800: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
3801: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3802: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3803: END IF;
3804:
3805: END CREATE_UPDATE_STOP_NEW;
3806: --Harmonizing Project **heali
3823: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3824: --
3825: IF l_debug_on IS NULL
3826: THEN
3827: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3828: END IF;
3829: --
3830: IF l_debug_on THEN
3831: WSH_DEBUG_SV.push(l_module_name);
3827: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3828: END IF;
3829: --
3830: IF l_debug_on THEN
3831: WSH_DEBUG_SV.push(l_module_name);
3832: --
3833: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
3834: END IF;
3835: --
3829: --
3830: IF l_debug_on THEN
3831: WSH_DEBUG_SV.push(l_module_name);
3832: --
3833: WSH_DEBUG_SV.log(l_module_name,'P_STOP_ID',P_STOP_ID);
3834: END IF;
3835: --
3836: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3837:
3841: x_return_status => x_return_status);
3842:
3843: --
3844: IF l_debug_on THEN
3845: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
3846: WSH_DEBUG_SV.pop(l_module_name);
3847: END IF;
3848: --
3849: EXCEPTION
3842:
3843: --
3844: IF l_debug_on THEN
3845: WSH_DEBUG_SV.log(l_module_name,'x_return_status',x_return_status);
3846: WSH_DEBUG_SV.pop(l_module_name);
3847: END IF;
3848: --
3849: EXCEPTION
3850: WHEN OTHERS THEN
3851: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_TRIP_STOPS_GRP.get_stop_details_pvt',l_module_name);
3852: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3853: --
3854: IF l_debug_on THEN
3855: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3856: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3857: END IF;
3858: --
3859: END get_stop_details_pvt;
3852: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3853: --
3854: IF l_debug_on THEN
3855: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3856: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3857: END IF;
3858: --
3859: END get_stop_details_pvt;
3860:
3927: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
3928: --
3929: IF l_debug_on IS NULL
3930: THEN
3931: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
3932: END IF;
3933: --
3934: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3935:
3933: --
3934: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3935:
3936: IF l_debug_on THEN
3937: WSH_DEBUG_SV.push(l_module_name);
3938: WSH_DEBUG_SV.log(l_module_name, 'Action_Code', p_action_prms.action_code);
3939: WSH_DEBUG_SV.log(l_module_name, 'Stop Action', p_action_prms.stop_action);
3940: WSH_DEBUG_SV.log(l_module_name, 'Phase ', p_action_prms.phase);
3941: END IF;
3934: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3935:
3936: IF l_debug_on THEN
3937: WSH_DEBUG_SV.push(l_module_name);
3938: WSH_DEBUG_SV.log(l_module_name, 'Action_Code', p_action_prms.action_code);
3939: WSH_DEBUG_SV.log(l_module_name, 'Stop Action', p_action_prms.stop_action);
3940: WSH_DEBUG_SV.log(l_module_name, 'Phase ', p_action_prms.phase);
3941: END IF;
3942:
3935:
3936: IF l_debug_on THEN
3937: WSH_DEBUG_SV.push(l_module_name);
3938: WSH_DEBUG_SV.log(l_module_name, 'Action_Code', p_action_prms.action_code);
3939: WSH_DEBUG_SV.log(l_module_name, 'Stop Action', p_action_prms.stop_action);
3940: WSH_DEBUG_SV.log(l_module_name, 'Phase ', p_action_prms.phase);
3941: END IF;
3942:
3943: IF p_action_prms.action_code = 'UPDATE-STATUS'
3936: IF l_debug_on THEN
3937: WSH_DEBUG_SV.push(l_module_name);
3938: WSH_DEBUG_SV.log(l_module_name, 'Action_Code', p_action_prms.action_code);
3939: WSH_DEBUG_SV.log(l_module_name, 'Stop Action', p_action_prms.stop_action);
3940: WSH_DEBUG_SV.log(l_module_name, 'Phase ', p_action_prms.phase);
3941: END IF;
3942:
3943: IF p_action_prms.action_code = 'UPDATE-STATUS'
3944: AND p_action_prms.stop_action = 'CLOSE'
3955: INTO l_trip_id, l_stop_location_id, l_trip_status;
3956: CLOSE c_stop_trip_info;
3957:
3958: IF l_debug_on THEN
3959: wsh_debug_sv.log(l_module_name, 'Trip Id', l_trip_id);
3960: wsh_debug_sv.log(l_module_name, 'Trip Status', l_trip_status);
3961: END IF;
3962:
3963: /* With inbound logistics changes, New logic to lock trip is as follows:
3956: CLOSE c_stop_trip_info;
3957:
3958: IF l_debug_on THEN
3959: wsh_debug_sv.log(l_module_name, 'Trip Id', l_trip_id);
3960: wsh_debug_sv.log(l_module_name, 'Trip Status', l_trip_status);
3961: END IF;
3962:
3963: /* With inbound logistics changes, New logic to lock trip is as follows:
3964: If trip is open, closing any stop requires trip status to be updated and hence trip's lock is needed.
3984: p_trip_id => l_trip_id
3985: );
3986: ELSE
3987: IF l_debug_on THEN
3988: wsh_debug_sv.log(l_module_name, 'Atleast one Other stop not closed', l_dummy_stop_id);
3989: END IF;
3990: CLOSE c_unclosed_other_stops;
3991: END IF;
3992: -- }
4038: l_index := p_stop_attr_tab.NEXT(l_index);
4039: END LOOP;
4040:
4041: IF l_debug_on THEN
4042: WSH_DEBUG_SV.log(l_module_name, 'Valid ids count', x_valid_ids_tab.count);
4043: END IF;
4044:
4045: -- Check for valid_ids_tab count.
4046: -- If valid ids count > 0 ,but less than the input table count, then return warning
4066:
4067:
4068:
4069: IF l_debug_on THEN
4070: WSH_DEBUG_SV.pop(l_module_name);
4071: END IF;
4072:
4073: EXCEPTION
4074: WHEN FND_API.G_EXC_ERROR THEN
4074: WHEN FND_API.G_EXC_ERROR THEN
4075: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4076: --
4077: IF l_debug_on THEN
4078: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4079: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4080: END IF;
4081: --
4082: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4075: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4076: --
4077: IF l_debug_on THEN
4078: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4079: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
4080: END IF;
4081: --
4082: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4083: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4082: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4083: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4084: --
4085: IF l_debug_on THEN
4086: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4087: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4088: END IF;
4089: --
4090: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
4083: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4084: --
4085: IF l_debug_on THEN
4086: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4087: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4088: END IF;
4089: --
4090: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
4091: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4090: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
4091: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4092: --
4093: IF l_debug_on THEN
4094: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4095: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
4096: END IF;
4097: --
4098: WHEN OTHERS THEN
4091: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4092: --
4093: IF l_debug_on THEN
4094: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
4095: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
4096: END IF;
4097: --
4098: WHEN OTHERS THEN
4099: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4100: wsh_util_core.default_handler('WSH_DELIVERIES_GRP.LOCK_RELATED_ENTITY');
4101:
4102: --
4103: IF l_debug_on THEN
4104: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4105: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4106: END IF;
4107: --
4108:
4101:
4102: --
4103: IF l_debug_on THEN
4104: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4105: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
4106: END IF;
4107: --
4108:
4109: END Lock_Related_Entity;
4153: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
4154: --
4155: IF l_debug_on IS NULL
4156: THEN
4157: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4158: END IF;
4159: --
4160: IF l_debug_on THEN
4161: wsh_debug_sv.push(l_module_name);
4157: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
4158: END IF;
4159: --
4160: IF l_debug_on THEN
4161: wsh_debug_sv.push(l_module_name);
4162: WSH_DEBUG_SV.log(l_module_name,'p_stop_tab.count', p_stop_tab.count);
4163: WSH_DEBUG_SV.log(l_module_name,'p_caller', p_caller );
4164: END IF;
4165:
4158: END IF;
4159: --
4160: IF l_debug_on THEN
4161: wsh_debug_sv.push(l_module_name);
4162: WSH_DEBUG_SV.log(l_module_name,'p_stop_tab.count', p_stop_tab.count);
4163: WSH_DEBUG_SV.log(l_module_name,'p_caller', p_caller );
4164: END IF;
4165:
4166: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4159: --
4160: IF l_debug_on THEN
4161: wsh_debug_sv.push(l_module_name);
4162: WSH_DEBUG_SV.log(l_module_name,'p_stop_tab.count', p_stop_tab.count);
4163: WSH_DEBUG_SV.log(l_module_name,'p_caller', p_caller );
4164: END IF;
4165:
4166: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
4167: x_stop_delete_tab.delete;
4243: x_stop_delete_tab := l_stop_delete_tab;
4244:
4245:
4246: IF l_debug_on THEN
4247: WSH_DEBUG_SV.pop(l_module_name);
4248: END IF;
4249:
4250: EXCEPTION
4251:
4256:
4257: wsh_util_core.default_handler('WSH_TRIP_STOPS_VALIDATIONS.Add_to_Delete_List',l_module_name);
4258: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4259: IF l_debug_on THEN
4260: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
4261: END IF;
4262:
4263: END Add_to_Delete_List;
4264: