DBA Data[Home] [Help]

APPS.WSH_NEW_DELIVERY_ACTIONS dependencies on WSH_TRIPS_ACTIONS

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

5855: --
5856: -- Debug Statements
5857: --
5858: IF l_debug_on THEN
5859: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.AUTOCREATE_TRIP',WSH_DEBUG_SV.C_PROC_LEVEL);
5860: END IF;
5861: --
5862:
5863: --heali :Shipment Advice change for trip Consolidation.

Line 5865: wsh_trips_actions.autocreate_trip(

5861: --
5862:
5863: --heali :Shipment Advice change for trip Consolidation.
5864: IF (p_autocreate_trip_flag = 'Y' ) THEN
5865: wsh_trips_actions.autocreate_trip(
5866: p_del_rows => l_del_rows,
5867: x_trip_id => l_trip_id,
5868: x_trip_name => l_trip_name,
5869: x_return_status => l_return_status,

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

10216: -- Call Handle Internal Stops API to link the stops
10217: l_trip_id_tab(1) := l_stop_rec.trip_id;
10218: IF l_debug_on THEN
10219: wsh_debug_sv.log(l_module_name,'trip_id' , l_stop_rec.trip_id);
10220: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.Handle_Internal_Stops',WSH_DEBUG_SV.C_PROC_LEVEL);
10221: END IF;
10222:
10223: WSH_TRIPS_ACTIONS.Handle_Internal_Stops(
10224: p_trip_ids => l_trip_id_tab,

Line 10223: WSH_TRIPS_ACTIONS.Handle_Internal_Stops(

10219: wsh_debug_sv.log(l_module_name,'trip_id' , l_stop_rec.trip_id);
10220: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.Handle_Internal_Stops',WSH_DEBUG_SV.C_PROC_LEVEL);
10221: END IF;
10222:
10223: WSH_TRIPS_ACTIONS.Handle_Internal_Stops(
10224: p_trip_ids => l_trip_id_tab,
10225: p_caller => 'WSH_UPDATE_SHIP_FROM_LOC',
10226: x_success_trip_ids => l_success_trip_ids,
10227: x_return_status => l_return_status);

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

13202:
13203: ELSE
13204: l_unassign_dels(1) := p_del_tab(i).delivery_id;
13205: IF l_debug_on THEN
13206: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRIPS_ACTIONS.Unassign_Trip',WSH_DEBUG_SV.C_PROC_LEVEL);
13207: END IF;
13208: WSH_TRIPS_ACTIONS.Unassign_Trip(p_del_rows => l_unassign_dels,
13209: p_trip_id => l_parent_trip_rec.trip_id,
13210: x_return_status => l_return_status);

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

13204: l_unassign_dels(1) := p_del_tab(i).delivery_id;
13205: IF l_debug_on THEN
13206: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRIPS_ACTIONS.Unassign_Trip',WSH_DEBUG_SV.C_PROC_LEVEL);
13207: END IF;
13208: WSH_TRIPS_ACTIONS.Unassign_Trip(p_del_rows => l_unassign_dels,
13209: p_trip_id => l_parent_trip_rec.trip_id,
13210: x_return_status => l_return_status);
13211:
13212: wsh_util_core.api_post_call

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

13408:
13409: END IF;
13410:
13411: IF l_debug_on THEN
13412: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRIPS_ACTIONS.assign_trip for ignore plan = N',WSH_DEBUG_SV.C_PROC_LEVEL);
13413: END IF;
13414: WSH_TRIPS_ACTIONS.assign_trip(
13415: p_del_rows => l_include_plan_dels,
13416: p_trip_id => l_trip_id_tab(1),

Line 13414: WSH_TRIPS_ACTIONS.assign_trip(

13410:
13411: IF l_debug_on THEN
13412: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRIPS_ACTIONS.assign_trip for ignore plan = N',WSH_DEBUG_SV.C_PROC_LEVEL);
13413: END IF;
13414: WSH_TRIPS_ACTIONS.assign_trip(
13415: p_del_rows => l_include_plan_dels,
13416: p_trip_id => l_trip_id_tab(1),
13417: p_pickup_stop_id => l_parent_trip_rec.pick_up_stop_id,
13418: p_dropoff_stop_id => l_parent_trip_rec.drop_off_stop_id,

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

13459: END IF;
13460: IF l_ignore_plan_dels.count > 0 THEN
13461:
13462: IF l_debug_on THEN
13463: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRIPS_ACTIONS.assign_trip for ignore plan = Y',WSH_DEBUG_SV.C_PROC_LEVEL);
13464: END IF;
13465:
13466: WSH_TRIPS_ACTIONS.assign_trip(
13467: p_del_rows => l_ignore_plan_dels,

Line 13466: WSH_TRIPS_ACTIONS.assign_trip(

13462: IF l_debug_on THEN
13463: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_TRIPS_ACTIONS.assign_trip for ignore plan = Y',WSH_DEBUG_SV.C_PROC_LEVEL);
13464: END IF;
13465:
13466: WSH_TRIPS_ACTIONS.assign_trip(
13467: p_del_rows => l_ignore_plan_dels,
13468: p_trip_id => l_trip_id_tab(1),
13469: p_pickup_stop_id => l_parent_trip_rec.pick_up_stop_id,
13470: p_dropoff_stop_id => l_parent_trip_rec.drop_off_stop_id,

Line 14626: WSH_TRIPS_ACTIONS.Unassign_Trip(

14622: -- delivery.
14623:
14624: FOR trip in c_second_leg(p_deliveries_tab(i)) LOOP
14625:
14626: WSH_TRIPS_ACTIONS.Unassign_Trip(
14627: p_del_rows => l_del_tab,
14628: p_trip_id => trip.trip_id,
14629: x_return_status => l_return_status);
14630:

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

14677: -- Assign delivery to trip
14678:
14679: IF l_debug_on THEN
14680: WSH_DEBUG_SV.logmsg(l_module_name,'Assigning to deconsol trip');
14681: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIPS_ACTIONS.assign_trip',WSH_DEBUG_SV.C_PROC_LEVEL);
14682: END IF;
14683:
14684:
14685: IF del.pu_date < del.do_date THEN

Line 14691: WSH_TRIPS_ACTIONS.assign_trip(

14687: ELSE
14688: l_do_date := del.pu_date + 1;
14689: END IF;
14690:
14691: WSH_TRIPS_ACTIONS.assign_trip(
14692: p_del_rows => l_del_tab,
14693: p_trip_id => l_trip_out_rec_tab(l_trip_out_rec_tab.FIRST).trip_id,
14694: p_pickup_location_id => del.pu_location,
14695: p_dropoff_location_id => del.do_location,