DBA Data[Home] [Help]

APPS.WSH_DELIVERY_LEGS_ACTIONS dependencies on WSH_TRIP_STOPS_VALIDATIONS

Line 291: l_stop_in_rec WSH_TRIP_STOPS_VALIDATIONS.chkClose_in_rec_type;

287: l_routing_request_flag VARCHAR2(30);
288: l_chkStop_status_code VARCHAR2(30);
289: l_has_mixed_deliveries VARCHAR2(10);
290: l_stop_opened VARCHAR2(10);
291: l_stop_in_rec WSH_TRIP_STOPS_VALIDATIONS.chkClose_in_rec_type;
292: l_leg_complete boolean;
293:
294: l_exception_name varchar2(30);
295: l_msg varchar2(2000);

Line 813: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_VALIDATIONS.GET_NEW_SEQUENCE_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);

809: --
810: -- Debug Statements
811: --
812: IF l_debug_on THEN
813: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_VALIDATIONS.GET_NEW_SEQUENCE_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
814: END IF;
815: --
816: WSH_TRIP_STOPS_VALIDATIONS.get_new_sequence_number
817: (x_stop_sequence_number => l_pickup_stop_seq,

Line 816: WSH_TRIP_STOPS_VALIDATIONS.get_new_sequence_number

812: IF l_debug_on THEN
813: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_VALIDATIONS.GET_NEW_SEQUENCE_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
814: END IF;
815: --
816: WSH_TRIP_STOPS_VALIDATIONS.get_new_sequence_number
817: (x_stop_sequence_number => l_pickup_stop_seq,
818: p_trip_id => p_trip_id,
819: p_status_code => 'OP',
820: p_stop_id => null, -- as of now no validations

Line 1071: -- by calling WSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag

1067: -- J-IB-NPARIKH-{
1068: --
1069: --
1070: -- For an existing stop, calculate value of shipments type flag
1071: -- by calling WSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag
1072: --
1073: IF l_debug_on THEN
1074: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WWSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag',WSH_DEBUG_SV.C_PROC_LEVEL);
1075: END IF;

Line 1074: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WWSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag',WSH_DEBUG_SV.C_PROC_LEVEL);

1070: -- For an existing stop, calculate value of shipments type flag
1071: -- by calling WSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag
1072: --
1073: IF l_debug_on THEN
1074: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WWSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag',WSH_DEBUG_SV.C_PROC_LEVEL);
1075: END IF;
1076: --
1077: WSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag
1078: (

Line 1077: WSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag

1073: IF l_debug_on THEN
1074: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WWSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag',WSH_DEBUG_SV.C_PROC_LEVEL);
1075: END IF;
1076: --
1077: WSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag
1078: (
1079: p_trip_id => p_trip_id,
1080: p_stop_id => l_pickup_stop_id,
1081: p_action => 'ASSIGN',

Line 1219: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_VALIDATIONS.GET_NEW_SEQUENCE_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);

1215: IF l_dropoff_stop_seq is NULL and l_dropoff_stop_id is NULL THEN
1216:
1217: IF l_pregen_seq = 'N' THEN --{
1218: IF l_debug_on THEN
1219: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_VALIDATIONS.GET_NEW_SEQUENCE_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
1220: END IF;
1221: --
1222:
1223: WSH_TRIP_STOPS_VALIDATIONS.get_new_sequence_number

Line 1223: WSH_TRIP_STOPS_VALIDATIONS.get_new_sequence_number

1219: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_VALIDATIONS.GET_NEW_SEQUENCE_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
1220: END IF;
1221: --
1222:
1223: WSH_TRIP_STOPS_VALIDATIONS.get_new_sequence_number
1224: (x_stop_sequence_number => l_dropoff_stop_seq,
1225: p_trip_id => p_trip_id,
1226: p_status_code => 'OP',
1227: p_stop_id => null, -- as of now no validations

Line 1493: -- by calling WSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag

1489: -- J-IB-NPARIKH-{
1490: --
1491: --
1492: -- For an existing stop, calculate value of shipments type flag
1493: -- by calling WSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag
1494: --
1495: IF l_debug_on THEN
1496: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WWSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag',WSH_DEBUG_SV.C_PROC_LEVEL);
1497: END IF;

Line 1496: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WWSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag',WSH_DEBUG_SV.C_PROC_LEVEL);

1492: -- For an existing stop, calculate value of shipments type flag
1493: -- by calling WSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag
1494: --
1495: IF l_debug_on THEN
1496: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WWSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag',WSH_DEBUG_SV.C_PROC_LEVEL);
1497: END IF;
1498: --
1499: WSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag
1500: (

Line 1499: WSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag

1495: IF l_debug_on THEN
1496: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WWSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag',WSH_DEBUG_SV.C_PROC_LEVEL);
1497: END IF;
1498: --
1499: WSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag
1500: (
1501: p_trip_id => p_trip_id,
1502: p_stop_id => l_dropoff_stop_id,
1503: p_action => 'ASSIGN',

Line 1767: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WWSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag',WSH_DEBUG_SV.C_PROC_LEVEL);

1763: IF p_pickup_stop_id IS NOT NULL
1764: THEN
1765: --{
1766: IF l_debug_on THEN
1767: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WWSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag',WSH_DEBUG_SV.C_PROC_LEVEL);
1768: END IF;
1769: --
1770: --
1771: -- For an existing stop, calculate value of shipments type flag

Line 1772: -- by calling WSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag

1768: END IF;
1769: --
1770: --
1771: -- For an existing stop, calculate value of shipments type flag
1772: -- by calling WSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag
1773: --
1774: WSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag
1775: (
1776: p_trip_id => p_trip_id,

Line 1774: WSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag

1770: --
1771: -- For an existing stop, calculate value of shipments type flag
1772: -- by calling WSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag
1773: --
1774: WSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag
1775: (
1776: p_trip_id => p_trip_id,
1777: p_stop_id => p_pickup_stop_id,
1778: p_action => 'ASSIGN',

Line 1840: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WWSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag',WSH_DEBUG_SV.C_PROC_LEVEL);

1836: IF p_dropoff_stop_id IS NOT NULL
1837: THEN
1838: --{
1839: IF l_debug_on THEN
1840: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WWSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag',WSH_DEBUG_SV.C_PROC_LEVEL);
1841: END IF;
1842: --
1843: --
1844: -- For an existing stop, calculate value of shipments type flag

Line 1845: -- by calling WSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag

1841: END IF;
1842: --
1843: --
1844: -- For an existing stop, calculate value of shipments type flag
1845: -- by calling WSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag
1846: --
1847: WSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag
1848: (
1849: p_trip_id => p_trip_id,

Line 1847: WSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag

1843: --
1844: -- For an existing stop, calculate value of shipments type flag
1845: -- by calling WSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag
1846: --
1847: WSH_TRIP_STOPS_VALIDATIONS.refreshShipmentsTypeFlag
1848: (
1849: p_trip_id => p_trip_id,
1850: p_stop_id => p_dropoff_stop_id,
1851: p_action => 'ASSIGN',