117: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
118: --
119: IF l_debug_on IS NULL
120: THEN
121: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
122: END IF;
123: --
124: IF l_debug_on THEN
125: WSH_DEBUG_SV.push(l_module_name);
121: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
122: END IF;
123: --
124: IF l_debug_on THEN
125: WSH_DEBUG_SV.push(l_module_name);
126: END IF;
127:
128: l_initial_pickup_loc_id := p_carrier_sel_result_rec.initial_pickup_location_id;
129: l_ultimate_dropoff_loc_id := p_carrier_sel_result_rec.ultimate_dropoff_location_id;
130: l_initial_pickup_date := p_carrier_sel_result_rec.pickup_date;
131: l_ultimate_dropoff_date := p_carrier_sel_result_rec.dropoff_date;
132:
133: IF l_debug_on THEN
134: WSH_DEBUG_SV.logmsg(l_module_name,'p_delivery_id :'||p_delivery_id);
135: WSH_DEBUG_SV.logmsg(l_module_name,'l_initial_pickup_loc_id :'||l_initial_pickup_loc_id);
136: WSH_DEBUG_SV.logmsg(l_module_name,'l_ultimate_dropoff_loc_id :'||l_ultimate_dropoff_loc_id);
137: WSH_DEBUG_SV.logmsg(l_module_name,'l_initial_pickup_date :'||l_initial_pickup_date);
138: WSH_DEBUG_SV.logmsg(l_module_name,'l_ultimate_dropoff_date :'||l_ultimate_dropoff_date);
131: l_ultimate_dropoff_date := p_carrier_sel_result_rec.dropoff_date;
132:
133: IF l_debug_on THEN
134: WSH_DEBUG_SV.logmsg(l_module_name,'p_delivery_id :'||p_delivery_id);
135: WSH_DEBUG_SV.logmsg(l_module_name,'l_initial_pickup_loc_id :'||l_initial_pickup_loc_id);
136: WSH_DEBUG_SV.logmsg(l_module_name,'l_ultimate_dropoff_loc_id :'||l_ultimate_dropoff_loc_id);
137: WSH_DEBUG_SV.logmsg(l_module_name,'l_initial_pickup_date :'||l_initial_pickup_date);
138: WSH_DEBUG_SV.logmsg(l_module_name,'l_ultimate_dropoff_date :'||l_ultimate_dropoff_date);
139: END IF;
132:
133: IF l_debug_on THEN
134: WSH_DEBUG_SV.logmsg(l_module_name,'p_delivery_id :'||p_delivery_id);
135: WSH_DEBUG_SV.logmsg(l_module_name,'l_initial_pickup_loc_id :'||l_initial_pickup_loc_id);
136: WSH_DEBUG_SV.logmsg(l_module_name,'l_ultimate_dropoff_loc_id :'||l_ultimate_dropoff_loc_id);
137: WSH_DEBUG_SV.logmsg(l_module_name,'l_initial_pickup_date :'||l_initial_pickup_date);
138: WSH_DEBUG_SV.logmsg(l_module_name,'l_ultimate_dropoff_date :'||l_ultimate_dropoff_date);
139: END IF;
140:
133: IF l_debug_on THEN
134: WSH_DEBUG_SV.logmsg(l_module_name,'p_delivery_id :'||p_delivery_id);
135: WSH_DEBUG_SV.logmsg(l_module_name,'l_initial_pickup_loc_id :'||l_initial_pickup_loc_id);
136: WSH_DEBUG_SV.logmsg(l_module_name,'l_ultimate_dropoff_loc_id :'||l_ultimate_dropoff_loc_id);
137: WSH_DEBUG_SV.logmsg(l_module_name,'l_initial_pickup_date :'||l_initial_pickup_date);
138: WSH_DEBUG_SV.logmsg(l_module_name,'l_ultimate_dropoff_date :'||l_ultimate_dropoff_date);
139: END IF;
140:
141: l_index := 1;
134: WSH_DEBUG_SV.logmsg(l_module_name,'p_delivery_id :'||p_delivery_id);
135: WSH_DEBUG_SV.logmsg(l_module_name,'l_initial_pickup_loc_id :'||l_initial_pickup_loc_id);
136: WSH_DEBUG_SV.logmsg(l_module_name,'l_ultimate_dropoff_loc_id :'||l_ultimate_dropoff_loc_id);
137: WSH_DEBUG_SV.logmsg(l_module_name,'l_initial_pickup_date :'||l_initial_pickup_date);
138: WSH_DEBUG_SV.logmsg(l_module_name,'l_ultimate_dropoff_date :'||l_ultimate_dropoff_date);
139: END IF;
140:
141: l_index := 1;
142:
301: l_trip_id := l_trip_out_rec_tab(1).trip_id;
302: l_trip_name := l_trip_out_rec_tab(1).trip_name;
303:
304: IF l_debug_on THEN
305: WSH_DEBUG_SV.logmsg(l_module_name,'Trip Created: l_trip_id :'||l_trip_id);
306: WSH_DEBUG_SV.logmsg(l_module_name,'Trip Created: l_trip_name :'||l_trip_name);
307: END IF;
308:
309: IF l_initial_pickup_date IS NULL AND l_ultimate_dropoff_date IS NULL THEN
302: l_trip_name := l_trip_out_rec_tab(1).trip_name;
303:
304: IF l_debug_on THEN
305: WSH_DEBUG_SV.logmsg(l_module_name,'Trip Created: l_trip_id :'||l_trip_id);
306: WSH_DEBUG_SV.logmsg(l_module_name,'Trip Created: l_trip_name :'||l_trip_name);
307: END IF;
308:
309: IF l_initial_pickup_date IS NULL AND l_ultimate_dropoff_date IS NULL THEN
310: l_initial_pickup_date := sysdate;
315: l_ultimate_dropoff_date := l_initial_pickup_date + WSH_TRIPS_ACTIONS.C_TEN_MINUTES;
316: END IF;
317:
318: IF l_debug_on THEN
319: WSH_DEBUG_SV.logmsg(l_module_name,'l_initial_pickup_date :'||l_initial_pickup_date);
320: WSH_DEBUG_SV.logmsg(l_module_name,'l_ultimate_dropoff_date :'||l_ultimate_dropoff_date);
321: END IF;
322:
323: l_pickup_stop_info.TRIP_ID := l_trip_id;
316: END IF;
317:
318: IF l_debug_on THEN
319: WSH_DEBUG_SV.logmsg(l_module_name,'l_initial_pickup_date :'||l_initial_pickup_date);
320: WSH_DEBUG_SV.logmsg(l_module_name,'l_ultimate_dropoff_date :'||l_ultimate_dropoff_date);
321: END IF;
322:
323: l_pickup_stop_info.TRIP_ID := l_trip_id;
324: l_pickup_stop_info.STOP_LOCATION_ID := l_initial_pickup_loc_id;
350: raise FND_API.G_EXC_UNEXPECTED_ERROR;
351: END IF;
352:
353: IF l_debug_on THEN
354: WSH_DEBUG_SV.logmsg(l_module_name,'Stop1: stop_id :'||l_pickup_stop_out_tab(1).stop_id);
355: END IF;
356:
357: l_dropoff_stop_info.TRIP_ID := l_trip_id;
358: l_dropoff_stop_info.STOP_LOCATION_ID := l_ultimate_dropoff_loc_id ;
381: raise FND_API.G_EXC_UNEXPECTED_ERROR;
382: END IF;
383:
384: IF l_debug_on THEN
385: WSH_DEBUG_SV.logmsg(l_module_name,'Stop2: stop_id :'||l_dropoff_stop_out_tab(1).stop_id);
386: END IF;
387:
388: l_action_prms.caller := l_caller;
389: l_action_prms.phase :=NULL ;
458: x_trip_id := l_trip_id;
459: x_trip_name := l_trip_name;
460:
461: IF l_debug_on THEN
462: WSH_DEBUG_SV.pop(l_module_name);
463: END IF;
464: --}
465: EXCEPTION
466:
473: CLOSE c_dlvy_attr_csr;
474: END IF;
475:
476: IF l_debug_on THEN
477: WSH_DEBUG_SV.pop(l_module_name,'When Others');
478: END IF;
479:
480: END CARRIER_SEL_CREATE_TRIP;
481:
515: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
516: --
517: IF l_debug_on IS NULL
518: THEN
519: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
520: END IF;
521:
522: IF l_debug_on THEN
523: WSH_DEBUG_SV.push(l_module_name);
519: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
520: END IF;
521:
522: IF l_debug_on THEN
523: WSH_DEBUG_SV.push(l_module_name);
524: --
525: WSH_DEBUG_SV.log(l_module_name,'P_RULE_ID',P_RULE_ID);
526: END IF;
527:
521:
522: IF l_debug_on THEN
523: WSH_DEBUG_SV.push(l_module_name);
524: --
525: WSH_DEBUG_SV.log(l_module_name,'P_RULE_ID',P_RULE_ID);
526: END IF;
527:
528: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
529:
560: END IF ;
561: END IF;
562:
563: IF l_debug_on THEN
564: WSH_DEBUG_SV.POP (l_module_name);
565: END IF;
566:
567: EXCEPTION
568:
580: FND_MESSAGE.SET_TOKEN('RULE_NAME',l_rule_name);
581: wsh_util_core.add_message(x_return_status);
582:
583: IF l_debug_on THEN
584: WSH_DEBUG_SV.pop(l_module_name);
585: END IF;
586:
587: WHEN others THEN
588:
589: WSH_UTIL_CORE.default_handler('FTE_ACS_TRIP_PKG.GET_RANKED_RESULTS');
590: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
591:
592: IF l_debug_on THEN
593: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
594: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
595: END IF;
596: --
597:
590: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
591:
592: IF l_debug_on THEN
593: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
594: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
595: END IF;
596: --
597:
598: END GET_RANKED_RESULTS;