DBA Data[Home] [Help]

APPS.WSH_TP_RELEASE dependencies on WSH_DELIVERY_VALIDATIONS

Line 826: WSH_DELIVERY_VALIDATIONS.get_delivery_information

822: --l_new_version_number_tab.delete;
823: l_tms_update := 'Y';
824: l_is_delivery_empty := NULL;
825:
826: WSH_DELIVERY_VALIDATIONS.get_delivery_information
827: (p_delivery_id => p_in_ids(i),
828: x_delivery_rec => l_delivery_info,
829: x_return_status => l_return_status);
830:

Line 1434: wsh_delivery_validations.check_plan(p_delivery_id => del_cur.delivery_id,

1430:
1431: IF (p_entity='TRIP') THEN
1432: FOR del_cur IN c_deliveries(p_entity_id) LOOP
1433:
1434: wsh_delivery_validations.check_plan(p_delivery_id => del_cur.delivery_id,
1435: x_return_status => x_return_status);
1436: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1437: rollback to before_firm;
1438: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_CANNOT_FIRM');

Line 2653: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;

2649: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
2650: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
2651: l_tms_update VARCHAR2(1);
2652: l_trip_not_found VARCHAR2(1);
2653: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;
2654: l_tms_version_number WSH_NEW_DELIVERIES.TMS_VERSION_NUMBER%TYPE;
2655: l_return_status VARCHAR2(1);
2656: l_gc3_is_installed VARCHAR2(1);
2657: --l_sysdate DATE;

Line 2901: WSH_DELIVERY_VALIDATIONS.get_trip_information

2897: l_delivery_info_tab.DELETE;
2898: --l_new_interface_flag_tab.DELETE;
2899:
2900: --get trip information for delivery, no update when trip not OPEN
2901: WSH_DELIVERY_VALIDATIONS.get_trip_information
2902: (p_delivery_id => l_delivery_id,
2903: x_trip_info_rec => l_trip_info_rec,
2904: x_return_status => l_return_status);
2905:

Line 2907: WSH_DEBUG_SV.log(l_module_name, 'Return Status after WSH_DELIVERY_VALIDATIONS.get_trip_information', l_return_status);

2903: x_trip_info_rec => l_trip_info_rec,
2904: x_return_status => l_return_status);
2905:
2906: IF l_debug_on THEN
2907: WSH_DEBUG_SV.log(l_module_name, 'Return Status after WSH_DELIVERY_VALIDATIONS.get_trip_information', l_return_status);
2908: END IF;
2909:
2910: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
2911: x_return_status := l_return_status;

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

2909:
2910: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
2911: x_return_status := l_return_status;
2912: IF l_debug_on THEN
2913: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_VALIDATIONS.get_trip_information');
2914: END IF;
2915: RAISE e_gc3_exception;
2916: END IF;
2917:

Line 2928: WSH_DELIVERY_VALIDATIONS.get_delivery_information(

2924: -- suffice, no need for NVL or l_trip_not_found=N
2925: IF ((l_trip_info_rec.status_code = 'OP') OR
2926: (l_trip_not_found = 'Y')) THEN--{
2927:
2928: WSH_DELIVERY_VALIDATIONS.get_delivery_information(
2929: p_delivery_id => l_delivery_id,
2930: x_delivery_rec => l_delivery_info,
2931: x_return_status => l_return_status);
2932:

Line 2934: WSH_DEBUG_SV.log(l_module_name, 'Return Status after WSH_DELIVERY_VALIDATIONS.get_delivery_information', l_return_status);

2930: x_delivery_rec => l_delivery_info,
2931: x_return_status => l_return_status);
2932:
2933: IF l_debug_on THEN
2934: WSH_DEBUG_SV.log(l_module_name, 'Return Status after WSH_DELIVERY_VALIDATIONS.get_delivery_information', l_return_status);
2935: END IF;
2936:
2937: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
2938: x_return_status := l_return_status;

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

2936:
2937: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
2938: x_return_status := l_return_status;
2939: IF l_debug_on THEN
2940: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_VALIDATIONS.get_delivery_information');
2941: END IF;
2942: RAISE e_gc3_exception;
2943: END IF;
2944: