APPS.WSH_DELIVERY_AUTOCREATE dependencies on WSH_TRIPS

Line 4188: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRIPS_ACTIONS.Unassign_Trip',WSH_DEBUG_SV.C_PROC_LEVEL);

4184:
4185: IF l_trip_id IS NOT NULL THEN
4186:
4187: IF l_debug_on THEN
4188: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRIPS_ACTIONS.Unassign_Trip',WSH_DEBUG_SV.C_PROC_LEVEL);
4189: END IF;
4190: WSH_TRIPS_ACTIONS.Unassign_Trip(p_del_rows => l_trip_del_tab,
4191: p_trip_id => l_trip_id,
4192: x_return_status => l_return_status);

Line 4190: WSH_TRIPS_ACTIONS.Unassign_Trip(p_del_rows => l_trip_del_tab,

4186:
4187: IF l_debug_on THEN
4188: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRIPS_ACTIONS.Unassign_Trip',WSH_DEBUG_SV.C_PROC_LEVEL);
4189: END IF;
4190: WSH_TRIPS_ACTIONS.Unassign_Trip(p_del_rows => l_trip_del_tab,
4191: p_trip_id => l_trip_id,
4192: x_return_status => l_return_status);
4193:
4194: wsh_util_core.api_post_call

Line 4227: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRIPS_ACTIONS.assign_Trip',WSH_DEBUG_SV.C_PROC_LEVEL);

4223:
4224: END IF;
4225:
4226: IF l_debug_on THEN
4227: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRIPS_ACTIONS.assign_Trip',WSH_DEBUG_SV.C_PROC_LEVEL);
4228: END IF;
4229: WSH_TRIPS_ACTIONS.assign_trip(
4230: p_del_rows => l_delivery_id_tab,
4231: p_trip_id => l_trip_id,

Line 4229: WSH_TRIPS_ACTIONS.assign_trip(

4225:
4226: IF l_debug_on THEN
4227: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRIPS_ACTIONS.assign_Trip',WSH_DEBUG_SV.C_PROC_LEVEL);
4228: END IF;
4229: WSH_TRIPS_ACTIONS.assign_trip(
4230: p_del_rows => l_delivery_id_tab,
4231: p_trip_id => l_trip_id,
4232: p_pickup_location_id => l_del_attributes.initial_pickup_location_id,
4233: p_dropoff_location_id => l_del_attributes.ultimate_dropoff_location_id,

Line 4253: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRIPS_ACTIONS.autocreate_trip_multi',WSH_DEBUG_SV.C_PROC_LEVEL);

4249: -- Autocreate trip for consol del
4250: l_trip_name_tab(1) := p_trip_prefix;
4251:
4252: IF l_debug_on THEN
4253: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRIPS_ACTIONS.autocreate_trip_multi',WSH_DEBUG_SV.C_PROC_LEVEL);
4254: END IF;
4255: WSH_TRIPS_ACTIONS.autocreate_trip_multi(
4256: p_del_rows => l_delivery_id_tab,
4257: x_trip_ids => l_trip_id_tab,

Line 4255: WSH_TRIPS_ACTIONS.autocreate_trip_multi(

4251:
4252: IF l_debug_on THEN
4253: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRIPS_ACTIONS.autocreate_trip_multi',WSH_DEBUG_SV.C_PROC_LEVEL);
4254: END IF;
4255: WSH_TRIPS_ACTIONS.autocreate_trip_multi(
4256: p_del_rows => l_delivery_id_tab,
4257: x_trip_ids => l_trip_id_tab,
4258: x_trip_names => l_trip_name_tab,
4259: x_return_status => l_return_status);

Line 4300: update wsh_trips set

4296: x_num_errors => l_num_errors
4297: );
4298:
4299: IF p_trip_prefix IS NOT NULL THEN
4300: update wsh_trips set
4301: name = p_trip_prefix ||'-'|| name
4302: where trip_id = l_trip_id_tab(1);
4303: END IF;
4304: