DBA Data[Home] [Help]

APPS.WSH_TRIP_STOPS_VALIDATIONS dependencies on WSH_TRIP_VALIDATIONS

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

2605: IF NVL(p_shipment_direction,'O') IN ('O','IO')
2606: THEN
2607: --{
2608: IF l_debug_on THEN
2609: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_VALIDATIONS.has_inbound_deliveries',WSH_DEBUG_SV.C_PROC_LEVEL);
2610: END IF;
2611: --
2612: IF
2613: WSH_TRIP_VALIDATIONS.has_inbound_deliveries

Line 2613: WSH_TRIP_VALIDATIONS.has_inbound_deliveries

2609: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_VALIDATIONS.has_inbound_deliveries',WSH_DEBUG_SV.C_PROC_LEVEL);
2610: END IF;
2611: --
2612: IF
2613: WSH_TRIP_VALIDATIONS.has_inbound_deliveries
2614: (
2615: p_trip_id => p_trip_id,
2616: p_stop_id => p_stop_id
2617: )

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

2630: IF NVL(p_shipment_direction,'O') NOT IN ('O','IO')
2631: THEN
2632: --{
2633: IF l_debug_on THEN
2634: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_VALIDATIONS.has_outbound_deliveries',WSH_DEBUG_SV.C_PROC_LEVEL);
2635: END IF;
2636: --
2637: IF
2638: WSH_TRIP_VALIDATIONS.has_outbound_deliveries

Line 2638: WSH_TRIP_VALIDATIONS.has_outbound_deliveries

2634: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_VALIDATIONS.has_outbound_deliveries',WSH_DEBUG_SV.C_PROC_LEVEL);
2635: END IF;
2636: --
2637: IF
2638: WSH_TRIP_VALIDATIONS.has_outbound_deliveries
2639: (
2640: p_trip_id => p_trip_id,
2641: p_stop_id => p_stop_id
2642: )

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

2660: IF NVL(p_shipment_direction,'O') IN ('O','IO')
2661: THEN
2662: --{
2663: IF l_debug_on THEN
2664: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_VALIDATIONS.has_outbound_deliveries',WSH_DEBUG_SV.C_PROC_LEVEL);
2665: END IF;
2666: --
2667: IF
2668: WSH_TRIP_VALIDATIONS.has_outbound_deliveries

Line 2668: WSH_TRIP_VALIDATIONS.has_outbound_deliveries

2664: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_VALIDATIONS.has_outbound_deliveries',WSH_DEBUG_SV.C_PROC_LEVEL);
2665: END IF;
2666: --
2667: IF
2668: WSH_TRIP_VALIDATIONS.has_outbound_deliveries
2669: (
2670: p_trip_id => p_trip_id,
2671: p_stop_id => p_stop_id
2672: )

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

2679: --}
2680: ELSE
2681: --{
2682: IF l_debug_on THEN
2683: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_VALIDATIONS.has_inbound_deliveries',WSH_DEBUG_SV.C_PROC_LEVEL);
2684: END IF;
2685: --
2686: IF
2687: WSH_TRIP_VALIDATIONS.has_inbound_deliveries

Line 2687: WSH_TRIP_VALIDATIONS.has_inbound_deliveries

2683: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_VALIDATIONS.has_inbound_deliveries',WSH_DEBUG_SV.C_PROC_LEVEL);
2684: END IF;
2685: --
2686: IF
2687: WSH_TRIP_VALIDATIONS.has_inbound_deliveries
2688: (
2689: p_trip_id => p_trip_id,
2690: p_stop_id => p_stop_id
2691: )

Line 3186: l_trip_in_rec WSH_TRIP_VALIDATIONS.ChgStatus_in_rec_type;

3182: l_stop_locationId NUMBER;
3183: l_dlvy_initialPULocationId NUMBER;
3184: --
3185: l_in_rec WSH_DELIVERY_VALIDATIONS.ChgStatus_in_rec_type;
3186: l_trip_in_rec WSH_TRIP_VALIDATIONS.ChgStatus_in_rec_type;
3187: l_wv_check_done BOOLEAN;
3188:
3189: -- Exception variables
3190: l_exceptions_tbl wsh_xc_util.XC_TAB_TYPE;

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

4800: --
4801: -- Debug Statements
4802: --
4803: IF l_debug_on THEN
4804: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_VALIDATIONS.check_inTransit',WSH_DEBUG_SV.C_PROC_LEVEL);
4805: END IF;
4806: --
4807: -- Check if trip can be set to In-Transit.
4808: --

Line 4809: WSH_TRIP_VALIDATIONS.check_inTransit

4805: END IF;
4806: --
4807: -- Check if trip can be set to In-Transit.
4808: --
4809: WSH_TRIP_VALIDATIONS.check_inTransit
4810: (
4811: p_in_rec => l_trip_in_rec,
4812: x_return_status => l_return_status,
4813: x_allowed => l_Allowed

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

4853: --
4854: -- Debug Statements
4855: --
4856: IF l_debug_on THEN
4857: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_VALIDATIONS.check_close',WSH_DEBUG_SV.C_PROC_LEVEL);
4858: END IF;
4859: --
4860: -- Check if trip can be closed.
4861: --

Line 4862: WSH_TRIP_VALIDATIONS.check_close

4858: END IF;
4859: --
4860: -- Check if trip can be closed.
4861: --
4862: WSH_TRIP_VALIDATIONS.check_close
4863: (
4864: p_in_rec => l_trip_in_rec,
4865: x_return_status => l_return_status,
4866: x_allowed => l_Allowed

Line 5000: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.CHECK_STOP_CLOSE',l_module_name);

4996: IF wsh_linked_stop_csr%ISOPEN THEN
4997: CLOSE wsh_linked_stop_csr;
4998: END IF;
4999: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
5000: wsh_util_core.default_handler('WSH_TRIP_VALIDATIONS.CHECK_STOP_CLOSE',l_module_name);
5001: --
5002: IF l_debug_on THEN
5003: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
5004: END IF;