DBA Data[Home] [Help]

APPS.WSH_NEW_DELIVERY_ACTIONS dependencies on WSH_TRIPS_ACTIONS

Line 5758: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.AUTOCREATE_TRIP',WSH_DEBUG_SV.C_PROC_LEVEL);

5754: --
5755: -- Debug Statements
5756: --
5757: IF l_debug_on THEN
5758: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.AUTOCREATE_TRIP',WSH_DEBUG_SV.C_PROC_LEVEL);
5759: END IF;
5760: --
5761:
5762: --heali :Shipment Advice change for trip Consolidation.

Line 5764: wsh_trips_actions.autocreate_trip(

5760: --
5761:
5762: --heali :Shipment Advice change for trip Consolidation.
5763: IF (p_autocreate_trip_flag = 'Y' ) THEN
5764: wsh_trips_actions.autocreate_trip(
5765: p_del_rows => l_del_rows,
5766: x_trip_id => l_trip_id,
5767: x_trip_name => l_trip_name,
5768: x_return_status => l_return_status,

Line 10024: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.Handle_Internal_Stops',WSH_DEBUG_SV.C_PROC_LEVEL);

10020: -- Call Handle Internal Stops API to link the stops
10021: l_trip_id_tab(1) := l_stop_rec.trip_id;
10022: IF l_debug_on THEN
10023: wsh_debug_sv.log(l_module_name,'trip_id' , l_stop_rec.trip_id);
10024: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.Handle_Internal_Stops',WSH_DEBUG_SV.C_PROC_LEVEL);
10025: END IF;
10026:
10027: WSH_TRIPS_ACTIONS.Handle_Internal_Stops(
10028: p_trip_ids => l_trip_id_tab,

Line 10027: WSH_TRIPS_ACTIONS.Handle_Internal_Stops(

10023: wsh_debug_sv.log(l_module_name,'trip_id' , l_stop_rec.trip_id);
10024: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.Handle_Internal_Stops',WSH_DEBUG_SV.C_PROC_LEVEL);
10025: END IF;
10026:
10027: WSH_TRIPS_ACTIONS.Handle_Internal_Stops(
10028: p_trip_ids => l_trip_id_tab,
10029: p_caller => 'WSH_UPDATE_SHIP_FROM_LOC',
10030: x_success_trip_ids => l_success_trip_ids,
10031: x_return_status => l_return_status);

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

13005:
13006: ELSE
13007: l_unassign_dels(1) := p_del_tab(i).delivery_id;
13008: IF l_debug_on THEN
13009: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRIPS_ACTIONS.Unassign_Trip',WSH_DEBUG_SV.C_PROC_LEVEL);
13010: END IF;
13011: WSH_TRIPS_ACTIONS.Unassign_Trip(p_del_rows => l_unassign_dels,
13012: p_trip_id => l_parent_trip_rec.trip_id,
13013: x_return_status => l_return_status);

Line 13011: WSH_TRIPS_ACTIONS.Unassign_Trip(p_del_rows => l_unassign_dels,

13007: l_unassign_dels(1) := p_del_tab(i).delivery_id;
13008: IF l_debug_on THEN
13009: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRIPS_ACTIONS.Unassign_Trip',WSH_DEBUG_SV.C_PROC_LEVEL);
13010: END IF;
13011: WSH_TRIPS_ACTIONS.Unassign_Trip(p_del_rows => l_unassign_dels,
13012: p_trip_id => l_parent_trip_rec.trip_id,
13013: x_return_status => l_return_status);
13014:
13015: wsh_util_core.api_post_call

Line 13215: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRIPS_ACTIONS.assign_trip for ignore plan = N',WSH_DEBUG_SV.C_PROC_LEVEL);

13211:
13212: END IF;
13213:
13214: IF l_debug_on THEN
13215: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRIPS_ACTIONS.assign_trip for ignore plan = N',WSH_DEBUG_SV.C_PROC_LEVEL);
13216: END IF;
13217: WSH_TRIPS_ACTIONS.assign_trip(
13218: p_del_rows => l_include_plan_dels,
13219: p_trip_id => l_trip_id_tab(1),

Line 13217: WSH_TRIPS_ACTIONS.assign_trip(

13213:
13214: IF l_debug_on THEN
13215: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRIPS_ACTIONS.assign_trip for ignore plan = N',WSH_DEBUG_SV.C_PROC_LEVEL);
13216: END IF;
13217: WSH_TRIPS_ACTIONS.assign_trip(
13218: p_del_rows => l_include_plan_dels,
13219: p_trip_id => l_trip_id_tab(1),
13220: p_pickup_stop_id => l_parent_trip_rec.pick_up_stop_id,
13221: p_dropoff_stop_id => l_parent_trip_rec.drop_off_stop_id,

Line 13266: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRIPS_ACTIONS.assign_trip for ignore plan = Y',WSH_DEBUG_SV.C_PROC_LEVEL);

13262: END IF;
13263: IF l_ignore_plan_dels.count > 0 THEN
13264:
13265: IF l_debug_on THEN
13266: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRIPS_ACTIONS.assign_trip for ignore plan = Y',WSH_DEBUG_SV.C_PROC_LEVEL);
13267: END IF;
13268:
13269: WSH_TRIPS_ACTIONS.assign_trip(
13270: p_del_rows => l_ignore_plan_dels,

Line 13269: WSH_TRIPS_ACTIONS.assign_trip(

13265: IF l_debug_on THEN
13266: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRIPS_ACTIONS.assign_trip for ignore plan = Y',WSH_DEBUG_SV.C_PROC_LEVEL);
13267: END IF;
13268:
13269: WSH_TRIPS_ACTIONS.assign_trip(
13270: p_del_rows => l_ignore_plan_dels,
13271: p_trip_id => l_trip_id_tab(1),
13272: p_pickup_stop_id => l_parent_trip_rec.pick_up_stop_id,
13273: p_dropoff_stop_id => l_parent_trip_rec.drop_off_stop_id,

Line 14429: WSH_TRIPS_ACTIONS.Unassign_Trip(

14425: -- delivery.
14426:
14427: FOR trip in c_second_leg(p_deliveries_tab(i)) LOOP
14428:
14429: WSH_TRIPS_ACTIONS.Unassign_Trip(
14430: p_del_rows => l_del_tab,
14431: p_trip_id => trip.trip_id,
14432: x_return_status => l_return_status);
14433:

Line 14484: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.assign_trip',WSH_DEBUG_SV.C_PROC_LEVEL);

14480: -- Assign delivery to trip
14481:
14482: IF l_debug_on THEN
14483: WSH_DEBUG_SV.logmsg(l_module_name,'Assigning to deconsol trip');
14484: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.assign_trip',WSH_DEBUG_SV.C_PROC_LEVEL);
14485: END IF;
14486:
14487:
14488: IF del.pu_date < del.do_date THEN

Line 14494: WSH_TRIPS_ACTIONS.assign_trip(

14490: ELSE
14491: l_do_date := del.pu_date + 1;
14492: END IF;
14493:
14494: WSH_TRIPS_ACTIONS.assign_trip(
14495: p_del_rows => l_del_tab,
14496: p_trip_id => l_trip_out_rec_tab(l_trip_out_rec_tab.FIRST).trip_id,
14497: p_pickup_location_id => del.pu_location,
14498: p_dropoff_location_id => del.do_location,