DBA Data[Home] [Help]

APPS.WSH_TRIP_STOPS_ACTIONS dependencies on WSH_TRIP_VALIDATIONS

Line 711: WSH_TRIP_VALIDATIONS.check_stop_arrive

707: IF l_debug_on THEN
708: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_VALIDATIONS.CHECK_STOP_ARRIVE',WSH_DEBUG_SV.C_PROC_LEVEL);
709: END IF;
710: --
711: WSH_TRIP_VALIDATIONS.check_stop_arrive
712: (
713: p_stop_id => p_stop_rows(i),
714: x_linked_stop_id => l_linked_stop_id, --wr if not null, must be open.
715: x_return_status => l_return_status

Line 1553: l_trip_in_rec WSH_TRIP_VALIDATIONS.ChgStatus_in_rec_type;

1549: l_dlvy_orgid_tbl wsh_util_core.id_tab_type;
1550: l_warehouse_type VARCHAR2(30);
1551: l_cms_flag VARCHAR2(1);
1552: l_in_rec WSH_DELIVERY_VALIDATIONS.ChgStatus_in_rec_type;
1553: l_trip_in_rec WSH_TRIP_VALIDATIONS.ChgStatus_in_rec_type;
1554: l_stop_in_rec WSH_TRIP_STOPS_VALIDATIONS.chkClose_in_rec_type;
1555: --
1556: --
1557: l_stop_closed VARCHAR2(10);

Line 2335: -- 02.01 If trip status is Closed, call WSH_TRIP_VALIDATIONS.check_close which

2331: --
2332: -- It performs following steps:
2333: -- 01. Update stop status to open and actual departure date to null
2334: -- 02. Check the trip status (given by input parameter p_in_rec1.trip_status_code)
2335: -- 02.01 If trip status is Closed, call WSH_TRIP_VALIDATIONS.check_close which
2336: -- will indicate if trip can be(or remain) closed or not. If not, set trip
2337: -- status to in-transit.
2338: -- 02.02 If trip status is in-transit, call WSH_TRIP_VALIDATIONS.check_intransit which
2339: -- will indicate if trip can be(or remain) in-transit or not. If not, set trip

Line 2338: -- 02.02 If trip status is in-transit, call WSH_TRIP_VALIDATIONS.check_intransit which

2334: -- 02. Check the trip status (given by input parameter p_in_rec1.trip_status_code)
2335: -- 02.01 If trip status is Closed, call WSH_TRIP_VALIDATIONS.check_close which
2336: -- will indicate if trip can be(or remain) closed or not. If not, set trip
2337: -- status to in-transit.
2338: -- 02.02 If trip status is in-transit, call WSH_TRIP_VALIDATIONS.check_intransit which
2339: -- will indicate if trip can be(or remain) in-transit or not. If not, set trip
2340: -- status to open.
2341: --========================================================================
2342: --

Line 2434: l_trip_in_rec WSH_TRIP_VALIDATIONS.ChgStatus_in_rec_type;

2430: l_trip_Status_code VARCHAR2(30);
2431: l_stop_opened VARCHAR2(10);
2432: l_allowed VARCHAR2(10);
2433: --
2434: l_trip_in_rec WSH_TRIP_VALIDATIONS.ChgStatus_in_rec_type;
2435: l_stop_in_rec WSH_TRIP_STOPS_VALIDATIONS.chkClose_in_rec_type;
2436: l_stop_id_tbl WSH_UTIL_CORE.id_tab_type;
2437: l_stop_cnt NUMBER := 0;
2438: l_index NUMBER;

Line 2627: -- Trip is Closed, call WSH_TRIP_VALIDATIONS.check_close which will indicate

2623: IF l_trip_status_code = 'CL'
2624: THEN
2625: --{
2626: --
2627: -- Trip is Closed, call WSH_TRIP_VALIDATIONS.check_close which will indicate
2628: -- if trip can be(or remain) closed or not.
2629: --
2630: l_trip_in_rec.trip_id := p_in_rec1.trip_id;
2631: l_trip_in_rec.name := p_in_rec1.trip_name;

Line 2641: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_VALIDATIONS.check_close',WSH_DEBUG_SV.C_PROC_LEVEL);

2637: l_trip_in_rec.stop_id := NULL; --p_in_Rec.stop_id;
2638: --
2639: --
2640: IF l_debug_on THEN
2641: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_VALIDATIONS.check_close',WSH_DEBUG_SV.C_PROC_LEVEL);
2642: END IF;
2643: --
2644: WSH_TRIP_VALIDATIONS.check_close
2645: (

Line 2644: WSH_TRIP_VALIDATIONS.check_close

2640: IF l_debug_on THEN
2641: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_VALIDATIONS.check_close',WSH_DEBUG_SV.C_PROC_LEVEL);
2642: END IF;
2643: --
2644: WSH_TRIP_VALIDATIONS.check_close
2645: (
2646: p_in_rec => l_trip_in_rec,
2647: x_return_status => l_return_status,
2648: x_allowed => l_Allowed

Line 2677: -- Trip is in-transit, call WSH_TRIP_VALIDATIONS.check_inTransit which will indicate

2673: THEN
2674: --{
2675:
2676: --
2677: -- Trip is in-transit, call WSH_TRIP_VALIDATIONS.check_inTransit which will indicate
2678: -- if trip can be(or remain) in-transit or not.
2679: --
2680: l_trip_in_rec.trip_id := p_in_rec1.trip_id;
2681: l_trip_in_rec.name := p_in_rec1.trip_name;

Line 2691: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_VALIDATIONS.check_inTransit',WSH_DEBUG_SV.C_PROC_LEVEL);

2687: l_trip_in_rec.stop_id := NULL; --p_in_Rec.stop_id;
2688: --
2689: --
2690: IF l_debug_on THEN
2691: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_VALIDATIONS.check_inTransit',WSH_DEBUG_SV.C_PROC_LEVEL);
2692: END IF;
2693: --
2694: WSH_TRIP_VALIDATIONS.check_inTransit
2695: (

Line 2694: WSH_TRIP_VALIDATIONS.check_inTransit

2690: IF l_debug_on THEN
2691: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_VALIDATIONS.check_inTransit',WSH_DEBUG_SV.C_PROC_LEVEL);
2692: END IF;
2693: --
2694: WSH_TRIP_VALIDATIONS.check_inTransit
2695: (
2696: p_in_rec => l_trip_in_rec,
2697: x_return_status => l_return_status,
2698: x_allowed => l_Allowed