DBA Data[Home] [Help]

APPS.WSH_TMS_RELEASE dependencies on WSH_UTIL_VALIDATE

Line 1990: WSH_UTIL_VALIDATE.VALIDATE_LOCATION

1986: GOTO trip_error;
1987: END;--}
1988:
1989:
1990: WSH_UTIL_VALIDATE.VALIDATE_LOCATION
1991: (p_location_id =>l_location_id,
1992: x_return_status => l_rs);
1993:
1994: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

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

2609: -- Getting info for the first record as the info. will be same even if several deliveries have the same pick up stop
2610: FETCH c_dock_appt_rec INTO l_dock_name, l_organization_id, l_start_time, l_end_time;
2611: CLOSE c_dock_appt_rec;
2612: IF (l_organization_id IS NOT NULL) THEN --{
2613: IF (wsh_util_validate.check_wms_org(l_organization_id) = 'Y') THEN --{
2614: IF l_debug_on THEN
2615: WSH_DEBUG_SV.log(l_module_name,'Calling WSH_SHIPPING_PARAMS_PVT.GET',WSH_DEBUG_SV.C_PROC_LEVEL);
2616: END IF;
2617: WSH_SHIPPING_PARAMS_PVT.GET(p_organization_id => l_organization_id,

Line 3289: WSH_UTIL_VALIDATE.Validate_Carrier(

3285: WSH_UTIL_CORE.ADD_MESSAGE(WSH_UTIL_CORE.G_RET_STS_ERROR);
3286: CLOSE c_get_currency_code;
3287: GOTO trip_error;
3288: ELSE
3289: WSH_UTIL_VALIDATE.Validate_Carrier(
3290: p_carrier_name => NULL,
3291: x_carrier_id => l_carrier_id,
3292: x_return_status => l_rs);
3293:

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

3291: x_carrier_id => l_carrier_id,
3292: x_return_status => l_rs);
3293:
3294: IF l_debug_on THEN
3295: WSH_DEBUG_SV.log(l_module_name,'Return Status from WSH_UTIL_VALIDATE.Validate_Carrier:',l_rs);
3296: END IF;
3297:
3298: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
3299: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 3325: WSH_UTIL_VALIDATE.Validate_Currency(

3321:
3322: -- Per ECO 5008405, Validate GC3 sent currency
3323: -- Need to adjust precision, dependent on WSHUTVLB new parameter
3324: IF ( l_freight_info_tab(l_count).currency_code <> fnd_api.g_miss_char ) THEN--{
3325: WSH_UTIL_VALIDATE.Validate_Currency(
3326: p_currency_code => l_freight_info_tab(l_count).currency_code,
3327: p_currency_name => NULL,
3328: p_amount => l_freight_info_tab(l_count).unit_amount,
3329: p_otm_enabled => 'Y', -- OTM R12

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

3330: x_return_status => l_rs,
3331: x_adjusted_amount => l_freight_info_tab(l_count).unit_amount); -- OTM R12
3332:
3333: IF l_debug_on THEN
3334: WSH_DEBUG_SV.log(l_module_name,'Return Status from WSH_UTIL_VALIDATE.Validate_Currency:',l_rs);
3335: END IF;
3336: -- Handle error here !!!
3337: -- ECO 5008405 handle here !!!
3338: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

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

3580: wsh_delivery_legs wdl,
3581: wsh_delivery_assignments wda, wsh_delivery_details wdd
3582: WHERE wdl.drop_off_stop_id = c_drop_off_stop_id
3583: AND wdl.delivery_id = wnd.delivery_id
3584: AND WSH_UTIL_VALIDATE.CHECK_WMS_ORG(wnd.organization_id) = 'Y'
3585: AND wnd.delivery_id = wda.delivery_id
3586: AND wda.delivery_detail_id = wdd.delivery_detail_id
3587: FOR UPDATE OF wnd.loading_sequence, wdd.load_seq_number NOWAIT;
3588: