DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_ACTIONS dependencies on WSH_DELIVERY_VALIDATIONS

Line 1655: l_has_lines := WSH_DELIVERY_VALIDATIONS.has_lines

1651: END IF;
1652: --
1653: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1654: --
1655: l_has_lines := WSH_DELIVERY_VALIDATIONS.has_lines
1656: (
1657: p_delivery_id => p_delivery_id
1658: );
1659: --

Line 1987: WSH_DELIVERY_VALIDATIONS.get_delivery_information(

1983: ELSIF (l_is_delivery_empty = 'N') THEN
1984: IF (p_tms_interface_flag IS NOT NULL) THEN
1985: l_tms_interface_flag := p_tms_interface_flag;
1986: ELSE
1987: WSH_DELIVERY_VALIDATIONS.get_delivery_information(
1988: p_delivery_id => p_delivery_id,
1989: x_delivery_rec => l_delivery_info,
1990: x_return_status => l_return_status);
1991:

Line 1994: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_VALIDATIONS.get_delivery_information');

1990: x_return_status => l_return_status);
1991:
1992: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
1993: IF l_debug_on THEN
1994: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_VALIDATIONS.get_delivery_information');
1995: END IF;
1996: raise FND_API.G_EXC_ERROR;
1997: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
1998: l_num_warnings := l_num_warnings + 1;

Line 2186: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;

2182: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
2183: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
2184: l_tms_update VARCHAR2(1);
2185: l_trip_not_found VARCHAR2(1);
2186: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;
2187: l_tms_version_number WSH_NEW_DELIVERIES.TMS_VERSION_NUMBER%TYPE;
2188: l_gc3_is_installed VARCHAR2(1);
2189:
2190: -- End of OTM R12 : update delivery

Line 2919: WSH_DELIVERY_VALIDATIONS.get_trip_information

2915: nvl(l_del_id_for_container.ignore_for_planning, 'N') = 'N') THEN
2916: l_trip_not_found := 'N';
2917:
2918: --get trip information for delivery, no update when trip not OPEN
2919: WSH_DELIVERY_VALIDATIONS.get_trip_information
2920: (p_delivery_id => l_del_id_for_container.delivery_id,
2921: x_trip_info_rec => l_trip_info_rec,
2922: x_return_status => l_return_status);
2923:

Line 2927: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_VALIDATIONS.get_trip_information');

2923:
2924: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
2925: x_return_status := l_return_status;
2926: IF l_debug_on THEN
2927: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_VALIDATIONS.get_trip_information');
2928: WSH_DEBUG_SV.pop(l_module_name);
2929: END IF;
2930: RETURN;
2931: END IF;

Line 2941: WSH_DELIVERY_VALIDATIONS.get_delivery_information(

2937: -- only do changes when there's no trip or trip status is OPEN
2938: IF (l_trip_info_rec.status_code = 'OP' OR
2939: l_trip_not_found = 'Y') THEN
2940:
2941: WSH_DELIVERY_VALIDATIONS.get_delivery_information(
2942: p_delivery_id => l_del_id_for_container.delivery_id,
2943: x_delivery_rec => l_delivery_info,
2944: x_return_status => l_return_status);
2945:

Line 2949: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_VALIDATIONS.get_delivery_information');

2945:
2946: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
2947: x_return_status := l_return_status;
2948: IF l_debug_on THEN
2949: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_VALIDATIONS.get_delivery_information');
2950: WSH_DEBUG_SV.pop(l_module_name);
2951: END IF;
2952: RETURN;
2953: END IF;

Line 4100: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;

4096: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
4097: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
4098: l_tms_update VARCHAR2(1);
4099: l_trip_not_found VARCHAR2(1);
4100: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;
4101: l_tms_version_number WSH_NEW_DELIVERIES.TMS_VERSION_NUMBER%TYPE;
4102: l_gc3_is_installed VARCHAR2(1);
4103:
4104: -- End of OTM R12 : update delivery

Line 4542: WSH_DELIVERY_VALIDATIONS.get_trip_information

4538: nvl(l_del.ignore_for_planning, 'N') = 'N') THEN
4539: l_trip_not_found := 'N';
4540:
4541: --get trip information for delivery, no update when trip not OPEN
4542: WSH_DELIVERY_VALIDATIONS.get_trip_information
4543: (p_delivery_id => p_delivery_id,
4544: x_trip_info_rec => l_trip_info_rec,
4545: x_return_status => l_return_status);
4546:

Line 4550: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_VALIDATIONS.get_trip_information');

4546:
4547: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
4548: x_return_status := l_return_status;
4549: IF l_debug_on THEN
4550: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_VALIDATIONS.get_trip_information');
4551: WSH_DEBUG_SV.pop(l_module_name);
4552: END IF;
4553: RETURN;
4554: END IF;

Line 4564: WSH_DELIVERY_VALIDATIONS.get_delivery_information(

4560: -- only do changes when there's no trip or trip status is OPEN
4561: IF (l_trip_info_rec.status_code = 'OP' OR
4562: l_trip_not_found = 'Y') THEN
4563:
4564: WSH_DELIVERY_VALIDATIONS.get_delivery_information(
4565: p_delivery_id => p_delivery_id,
4566: x_delivery_rec => l_delivery_info,
4567: x_return_status => l_return_status);
4568:

Line 4572: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_VALIDATIONS.get_delivery_information');

4568:
4569: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
4570: x_return_status := l_return_status;
4571: IF l_debug_on THEN
4572: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_VALIDATIONS.get_delivery_information');
4573: WSH_DEBUG_SV.pop(l_module_name);
4574: END IF;
4575: RETURN;
4576: END IF;

Line 5134: l_has_lines := WSH_DELIVERY_VALIDATIONS.has_lines

5130: END IF;
5131: --
5132: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5133: --
5134: l_has_lines := WSH_DELIVERY_VALIDATIONS.has_lines
5135: (
5136: p_delivery_id => p_delivery_id
5137: );
5138: --

Line 8440: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.has_lines',WSH_DEBUG_SV.C_PROC_LEVEL);

8436: FOR UPDATE NOWAIT;
8437:
8438: IF l_debug_on THEN
8439: WSH_DEBUG_SV.log(l_module_name,'Locking for Delivery id ',l_delivery_id1);
8440: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.has_lines',WSH_DEBUG_SV.C_PROC_LEVEL);
8441: END IF;
8442:
8443: -- J-IB-NPARIKH-{
8444: --

Line 8447: l_has_lines := WSH_DELIVERY_VALIDATIONS.has_lines

8443: -- J-IB-NPARIKH-{
8444: --
8445: -- Determine if delivery has any non-container lines
8446: --
8447: l_has_lines := WSH_DELIVERY_VALIDATIONS.has_lines
8448: (
8449: p_delivery_id => p_delivery_id
8450: );
8451: --