DBA Data[Home] [Help]

APPS.WSH_TP_RELEASE dependencies on WSH_DELIVERY_VALIDATIONS

Line 899: WSH_DELIVERY_VALIDATIONS.get_delivery_information

895: --l_new_version_number_tab.delete;
896: l_tms_update := 'Y';
897: l_is_delivery_empty := NULL;
898:
899: WSH_DELIVERY_VALIDATIONS.get_delivery_information
900: (p_delivery_id => p_in_ids(i),
901: x_delivery_rec => l_delivery_info,
902: x_return_status => l_return_status);
903:

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

1575:
1576: IF (p_entity='TRIP') THEN
1577: FOR del_cur IN c_deliveries(p_entity_id) LOOP
1578:
1579: wsh_delivery_validations.check_plan(p_delivery_id => del_cur.delivery_id,
1580: x_return_status => x_return_status);
1581: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) OR (x_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1582: rollback to before_firm;
1583: FND_MESSAGE.SET_NAME('WSH','WSH_DELIVERY_CANNOT_FIRM');

Line 2800: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;

2796: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
2797: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
2798: l_tms_update VARCHAR2(1);
2799: l_trip_not_found VARCHAR2(1);
2800: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;
2801: l_tms_version_number WSH_NEW_DELIVERIES.TMS_VERSION_NUMBER%TYPE;
2802: l_return_status VARCHAR2(1);
2803: l_gc3_is_installed VARCHAR2(1);
2804: --l_sysdate DATE;

Line 3048: WSH_DELIVERY_VALIDATIONS.get_trip_information

3044: l_delivery_info_tab.DELETE;
3045: --l_new_interface_flag_tab.DELETE;
3046:
3047: --get trip information for delivery, no update when trip not OPEN
3048: WSH_DELIVERY_VALIDATIONS.get_trip_information
3049: (p_delivery_id => l_delivery_id,
3050: x_trip_info_rec => l_trip_info_rec,
3051: x_return_status => l_return_status);
3052:

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

3050: x_trip_info_rec => l_trip_info_rec,
3051: x_return_status => l_return_status);
3052:
3053: IF l_debug_on THEN
3054: WSH_DEBUG_SV.log(l_module_name, 'Return Status after WSH_DELIVERY_VALIDATIONS.get_trip_information', l_return_status);
3055: END IF;
3056:
3057: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
3058: x_return_status := l_return_status;

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

3056:
3057: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
3058: x_return_status := l_return_status;
3059: IF l_debug_on THEN
3060: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_VALIDATIONS.get_trip_information');
3061: END IF;
3062: RAISE e_gc3_exception;
3063: END IF;
3064:

Line 3075: WSH_DELIVERY_VALIDATIONS.get_delivery_information(

3071: -- suffice, no need for NVL or l_trip_not_found=N
3072: IF ((l_trip_info_rec.status_code = 'OP') OR
3073: (l_trip_not_found = 'Y')) THEN--{
3074:
3075: WSH_DELIVERY_VALIDATIONS.get_delivery_information(
3076: p_delivery_id => l_delivery_id,
3077: x_delivery_rec => l_delivery_info,
3078: x_return_status => l_return_status);
3079:

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

3077: x_delivery_rec => l_delivery_info,
3078: x_return_status => l_return_status);
3079:
3080: IF l_debug_on THEN
3081: WSH_DEBUG_SV.log(l_module_name, 'Return Status after WSH_DELIVERY_VALIDATIONS.get_delivery_information', l_return_status);
3082: END IF;
3083:
3084: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
3085: x_return_status := l_return_status;

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

3083:
3084: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
3085: x_return_status := l_return_status;
3086: IF l_debug_on THEN
3087: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_DELIVERY_VALIDATIONS.get_delivery_information');
3088: END IF;
3089: RAISE e_gc3_exception;
3090: END IF;
3091: