DBA Data[Home] [Help]

APPS.WSH_TMS_RELEASE dependencies on WSH_UTIL_VALIDATE

Line 1982: WSH_UTIL_VALIDATE.VALIDATE_LOCATION

1978: GOTO trip_error;
1979: END;--}
1980:
1981:
1982: WSH_UTIL_VALIDATE.VALIDATE_LOCATION
1983: (p_location_id =>l_location_id,
1984: x_return_status => l_rs);
1985:
1986: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

Line 2605: IF (wsh_util_validate.check_wms_org(l_organization_id) = 'Y') THEN --{

2601: -- Getting info for the first record as the info. will be same even if several deliveries have the same pick up stop
2602: FETCH c_dock_appt_rec INTO l_dock_name, l_organization_id, l_start_time, l_end_time;
2603: CLOSE c_dock_appt_rec;
2604: IF (l_organization_id IS NOT NULL) THEN --{
2605: IF (wsh_util_validate.check_wms_org(l_organization_id) = 'Y') THEN --{
2606: IF l_debug_on THEN
2607: WSH_DEBUG_SV.log(l_module_name,'Calling WSH_SHIPPING_PARAMS_PVT.GET',WSH_DEBUG_SV.C_PROC_LEVEL);
2608: END IF;
2609: WSH_SHIPPING_PARAMS_PVT.GET(p_organization_id => l_organization_id,

Line 3281: WSH_UTIL_VALIDATE.Validate_Carrier(

3277: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
3278: CLOSE c_get_currency_code;
3279: GOTO trip_error;
3280: ELSE
3281: WSH_UTIL_VALIDATE.Validate_Carrier(
3282: p_carrier_name => NULL,
3283: x_carrier_id => l_carrier_id,
3284: x_return_status => l_rs);
3285:

Line 3287: WSH_DEBUG_SV.log(l_module_name,'Return Status from WSH_UTIL_VALIDATE.Validate_Carrier:',l_rs);

3283: x_carrier_id => l_carrier_id,
3284: x_return_status => l_rs);
3285:
3286: IF l_debug_on THEN
3287: WSH_DEBUG_SV.log(l_module_name,'Return Status from WSH_UTIL_VALIDATE.Validate_Carrier:',l_rs);
3288: END IF;
3289:
3290: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3291: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 3317: WSH_UTIL_VALIDATE.Validate_Currency(

3313:
3314: -- Per ECO 5008405, Validate GC3 sent currency
3315: -- Need to adjust precision, dependent on WSHUTVLB new parameter
3316: IF ( l_freight_info_tab(l_count).currency_code <> fnd_api.g_miss_char ) THEN--{
3317: WSH_UTIL_VALIDATE.Validate_Currency(
3318: p_currency_code => l_freight_info_tab(l_count).currency_code,
3319: p_currency_name => NULL,
3320: p_amount => l_freight_info_tab(l_count).unit_amount,
3321: p_otm_enabled => 'Y', -- OTM R12

Line 3326: WSH_DEBUG_SV.log(l_module_name,'Return Status from WSH_UTIL_VALIDATE.Validate_Currency:',l_rs);

3322: x_return_status => l_rs,
3323: x_adjusted_amount => l_freight_info_tab(l_count).unit_amount); -- OTM R12
3324:
3325: IF l_debug_on THEN
3326: WSH_DEBUG_SV.log(l_module_name,'Return Status from WSH_UTIL_VALIDATE.Validate_Currency:',l_rs);
3327: END IF;
3328: -- Handle error here !!!
3329: -- ECO 5008405 handle here !!!
3330: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

Line 3576: AND WSH_UTIL_VALIDATE.CHECK_WMS_ORG(wnd.organization_id) = 'Y'

3572: wsh_delivery_legs wdl,
3573: wsh_delivery_assignments wda, wsh_delivery_details wdd
3574: WHERE wdl.drop_off_stop_id = c_drop_off_stop_id
3575: AND wdl.delivery_id = wnd.delivery_id
3576: AND WSH_UTIL_VALIDATE.CHECK_WMS_ORG(wnd.organization_id) = 'Y'
3577: AND wnd.delivery_id = wda.delivery_id
3578: AND wda.delivery_detail_id = wdd.delivery_detail_id
3579: FOR UPDATE OF wnd.loading_sequence, wdd.load_seq_number NOWAIT;
3580: