APPS.WSH_DELIVERY_AUTOCREATE dependencies on WSH_TRIPS

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

4443:
4444: IF l_trip_id IS NOT NULL THEN
4445:
4446: IF l_debug_on THEN
4447: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRIPS_ACTIONS.Unassign_Trip',WSH_DEBUG_SV.C_PROC_LEVEL);
4448: END IF;
4449: WSH_TRIPS_ACTIONS.Unassign_Trip(p_del_rows => l_trip_del_tab,
4450: p_trip_id => l_trip_id,
4451: x_return_status => l_return_status);

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

4445:
4446: IF l_debug_on THEN
4447: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRIPS_ACTIONS.Unassign_Trip',WSH_DEBUG_SV.C_PROC_LEVEL);
4448: END IF;
4449: WSH_TRIPS_ACTIONS.Unassign_Trip(p_del_rows => l_trip_del_tab,
4450: p_trip_id => l_trip_id,
4451: x_return_status => l_return_status);
4452:
4453: wsh_util_core.api_post_call

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

4482:
4483: END IF;
4484:
4485: IF l_debug_on THEN
4486: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRIPS_ACTIONS.assign_Trip',WSH_DEBUG_SV.C_PROC_LEVEL);
4487: END IF;
4488: WSH_TRIPS_ACTIONS.assign_trip(
4489: p_del_rows => l_delivery_id_tab,
4490: p_trip_id => l_trip_id,

Line 4488: WSH_TRIPS_ACTIONS.assign_trip(

4484:
4485: IF l_debug_on THEN
4486: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRIPS_ACTIONS.assign_Trip',WSH_DEBUG_SV.C_PROC_LEVEL);
4487: END IF;
4488: WSH_TRIPS_ACTIONS.assign_trip(
4489: p_del_rows => l_delivery_id_tab,
4490: p_trip_id => l_trip_id,
4491: p_pickup_location_id => l_del_attributes.initial_pickup_location_id,
4492: p_dropoff_location_id => l_del_attributes.ultimate_dropoff_location_id,

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

4508: -- Autocreate trip for consol del
4509: l_trip_name_tab(1) := p_trip_prefix;
4510:
4511: IF l_debug_on THEN
4512: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRIPS_ACTIONS.autocreate_trip_multi',WSH_DEBUG_SV.C_PROC_LEVEL);
4513: END IF;
4514: WSH_TRIPS_ACTIONS.autocreate_trip_multi(
4515: p_del_rows => l_delivery_id_tab,
4516: x_trip_ids => l_trip_id_tab,

Line 4514: WSH_TRIPS_ACTIONS.autocreate_trip_multi(

4510:
4511: IF l_debug_on THEN
4512: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRIPS_ACTIONS.autocreate_trip_multi',WSH_DEBUG_SV.C_PROC_LEVEL);
4513: END IF;
4514: WSH_TRIPS_ACTIONS.autocreate_trip_multi(
4515: p_del_rows => l_delivery_id_tab,
4516: x_trip_ids => l_trip_id_tab,
4517: x_trip_names => l_trip_name_tab,
4518: x_return_status => l_return_status);

Line 4559: update wsh_trips set

4555: x_num_errors => l_num_errors
4556: );
4557:
4558: IF p_trip_prefix IS NOT NULL THEN
4559: update wsh_trips set
4560: name = p_trip_prefix ||'-'|| name
4561: where trip_id = l_trip_id_tab(1);
4562: END IF;
4563: