DBA Data[Home] [Help]

APPS.WSH_DELIVERY_DETAILS_ACTIONS dependencies on WSH_DELIVERY_VALIDATIONS

Line 1766: l_has_lines := WSH_DELIVERY_VALIDATIONS.has_lines

1762: END IF;
1763: --
1764: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1765: --
1766: l_has_lines := WSH_DELIVERY_VALIDATIONS.has_lines
1767: (
1768: p_delivery_id => p_delivery_id
1769: );
1770: --

Line 2098: WSH_DELIVERY_VALIDATIONS.get_delivery_information(

2094: ELSIF (l_is_delivery_empty = 'N') THEN
2095: IF (p_tms_interface_flag IS NOT NULL) THEN
2096: l_tms_interface_flag := p_tms_interface_flag;
2097: ELSE
2098: WSH_DELIVERY_VALIDATIONS.get_delivery_information(
2099: p_delivery_id => p_delivery_id,
2100: x_delivery_rec => l_delivery_info,
2101: x_return_status => l_return_status);
2102:

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

2101: x_return_status => l_return_status);
2102:
2103: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
2104: IF l_debug_on THEN
2105: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_VALIDATIONS.get_delivery_information');
2106: END IF;
2107: raise FND_API.G_EXC_ERROR;
2108: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
2109: l_num_warnings := l_num_warnings + 1;

Line 2292: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;

2288: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
2289: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
2290: l_tms_update VARCHAR2(1);
2291: l_trip_not_found VARCHAR2(1);
2292: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;
2293: l_tms_version_number WSH_NEW_DELIVERIES.TMS_VERSION_NUMBER%TYPE;
2294: l_gc3_is_installed VARCHAR2(1);
2295:
2296: -- End of OTM R12 : update delivery

Line 3064: WSH_DELIVERY_VALIDATIONS.get_trip_information

3060: nvl(l_del_id_for_container.ignore_for_planning, 'N') = 'N') THEN
3061: l_trip_not_found := 'N';
3062:
3063: --get trip information for delivery, no update when trip not OPEN
3064: WSH_DELIVERY_VALIDATIONS.get_trip_information
3065: (p_delivery_id => l_del_id_for_container.delivery_id,
3066: x_trip_info_rec => l_trip_info_rec,
3067: x_return_status => l_return_status);
3068:

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

3068:
3069: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
3070: x_return_status := l_return_status;
3071: IF l_debug_on THEN
3072: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_VALIDATIONS.get_trip_information');
3073: WSH_DEBUG_SV.pop(l_module_name);
3074: END IF;
3075: RETURN;
3076: END IF;

Line 3086: WSH_DELIVERY_VALIDATIONS.get_delivery_information(

3082: -- only do changes when there's no trip or trip status is OPEN
3083: IF (l_trip_info_rec.status_code = 'OP' OR
3084: l_trip_not_found = 'Y') THEN
3085:
3086: WSH_DELIVERY_VALIDATIONS.get_delivery_information(
3087: p_delivery_id => l_del_id_for_container.delivery_id,
3088: x_delivery_rec => l_delivery_info,
3089: x_return_status => l_return_status);
3090:

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

3090:
3091: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
3092: x_return_status := l_return_status;
3093: IF l_debug_on THEN
3094: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_VALIDATIONS.get_delivery_information');
3095: WSH_DEBUG_SV.pop(l_module_name);
3096: END IF;
3097: RETURN;
3098: END IF;

Line 4247: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;

4243: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
4244: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
4245: l_tms_update VARCHAR2(1);
4246: l_trip_not_found VARCHAR2(1);
4247: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;
4248: l_tms_version_number WSH_NEW_DELIVERIES.TMS_VERSION_NUMBER%TYPE;
4249: l_gc3_is_installed VARCHAR2(1);
4250:
4251: -- End of OTM R12 : update delivery

Line 4692: WSH_DELIVERY_VALIDATIONS.get_trip_information

4688: nvl(l_del.ignore_for_planning, 'N') = 'N') THEN
4689: l_trip_not_found := 'N';
4690:
4691: --get trip information for delivery, no update when trip not OPEN
4692: WSH_DELIVERY_VALIDATIONS.get_trip_information
4693: (p_delivery_id => p_delivery_id,
4694: x_trip_info_rec => l_trip_info_rec,
4695: x_return_status => l_return_status);
4696:

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

4696:
4697: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
4698: x_return_status := l_return_status;
4699: IF l_debug_on THEN
4700: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_VALIDATIONS.get_trip_information');
4701: WSH_DEBUG_SV.pop(l_module_name);
4702: END IF;
4703: RETURN;
4704: END IF;

Line 4714: WSH_DELIVERY_VALIDATIONS.get_delivery_information(

4710: -- only do changes when there's no trip or trip status is OPEN
4711: IF (l_trip_info_rec.status_code = 'OP' OR
4712: l_trip_not_found = 'Y') THEN
4713:
4714: WSH_DELIVERY_VALIDATIONS.get_delivery_information(
4715: p_delivery_id => p_delivery_id,
4716: x_delivery_rec => l_delivery_info,
4717: x_return_status => l_return_status);
4718:

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

4718:
4719: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
4720: x_return_status := l_return_status;
4721: IF l_debug_on THEN
4722: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_VALIDATIONS.get_delivery_information');
4723: WSH_DEBUG_SV.pop(l_module_name);
4724: END IF;
4725: RETURN;
4726: END IF;

Line 5287: l_has_lines := WSH_DELIVERY_VALIDATIONS.has_lines

5283: END IF;
5284: --
5285: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5286: --
5287: l_has_lines := WSH_DELIVERY_VALIDATIONS.has_lines
5288: (
5289: p_delivery_id => p_delivery_id
5290: );
5291: --

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

8600: FOR UPDATE NOWAIT;
8601:
8602: IF l_debug_on THEN
8603: WSH_DEBUG_SV.log(l_module_name,'Locking for Delivery id ',l_delivery_id1);
8604: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.has_lines',WSH_DEBUG_SV.C_PROC_LEVEL);
8605: END IF;
8606:
8607: -- J-IB-NPARIKH-{
8608: --

Line 8611: l_has_lines := WSH_DELIVERY_VALIDATIONS.has_lines

8607: -- J-IB-NPARIKH-{
8608: --
8609: -- Determine if delivery has any non-container lines
8610: --
8611: l_has_lines := WSH_DELIVERY_VALIDATIONS.has_lines
8612: (
8613: p_delivery_id => p_delivery_id
8614: );
8615: --