DBA Data[Home] [Help]

APPS.WSH_TRIPS_GRP dependencies on WSH_ACTIONS_LEVELS

Line 670: WSH_ACTIONS_LEVELS.set_validation_level (

666: END IF;
667: l_index := p_rec_attr_tab.NEXT(l_index);
668: END LOOP;
669:
670: WSH_ACTIONS_LEVELS.set_validation_level (
671: p_entity => 'TRIP',
672: p_caller => p_action_prms.caller,
673: p_phase => p_action_prms.phase,
674: p_action =>p_action_prms.action_code ,

Line 683: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_ACTION_ENABLED_LVL) = 1 THEN

679: wsh_util_core.api_post_call(p_return_status =>l_return_status,
680: x_num_warnings =>l_num_warning,
681: x_num_errors =>l_num_errors);
682:
683: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_ACTION_ENABLED_LVL) = 1 THEN
684: -- R12 Select Carrier
685: -- Changes inside Is_Action_Enabled
686:
687: WSH_TRIP_VALIDATIONS.Is_Action_Enabled(

Line 704: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_LOCK_RECORDS_LVL) = 1 THEN

700: p_raise_error_flag => FALSE);
701: END IF;
702:
703:
704: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_LOCK_RECORDS_LVL) = 1 THEN
705: IF NOT ( p_action_prms.caller = 'WSH_FSTRX'
706: AND p_action_prms.action_code = 'DELETE'
707: ) THEN --BUG 4354579
708: WSH_TRIPS_PVT.lock_trip(p_rec_attr_tab => p_rec_attr_tab,

Line 723: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_TRIP_CONFIRM_DEFAULT_LVL) = 1 THEN

719:
720: END IF;
721: END IF;
722:
723: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_TRIP_CONFIRM_DEFAULT_LVL) = 1 THEN
724:
725: WSH_TRIPS_ACTIONS.Get_Trip_Defaults(p_trip_id => l_trip_id_tab(1),
726: p_trip_name => p_action_prms.trip_name,
727: x_def_rec => x_def_rec,

Line 825: wsh_debug_sv.log (l_module_name,'C_TRIP_STOP_VALIDATION_LVL',WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_TRIP_STOP_VALIDATION_LVL));

821:
822:
823:
824: IF l_debug_on THEN
825: wsh_debug_sv.log (l_module_name,'C_TRIP_STOP_VALIDATION_LVL',WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_TRIP_STOP_VALIDATION_LVL));
826: END IF;
827:
828: IF (WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_TRIP_STOP_VALIDATION_LVL) = 1 )
829: AND ( p_action_prms.action_code IN ( 'FIRM', 'PLAN' , 'UNPLAN'))

Line 828: IF (WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_TRIP_STOP_VALIDATION_LVL) = 1 )

824: IF l_debug_on THEN
825: wsh_debug_sv.log (l_module_name,'C_TRIP_STOP_VALIDATION_LVL',WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_TRIP_STOP_VALIDATION_LVL));
826: END IF;
827:
828: IF (WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_TRIP_STOP_VALIDATION_LVL) = 1 )
829: AND ( p_action_prms.action_code IN ( 'FIRM', 'PLAN' , 'UNPLAN'))
830: AND (WSH_UTIL_CORE.FTE_IS_INSTALLED = 'Y')
831: THEN
832: FOR i IN l_trip_id_tab.FIRST..l_trip_id_tab.last LOOP

Line 964: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_DOCUMENT_SETS_LVL)=1 THEN

960: x_num_warnings =>l_num_warning,
961: x_num_errors =>l_num_errors);
962:
963: ELSIF p_action_prms.action_code = 'PRINT-DOC-SETS' THEN
964: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_DOCUMENT_SETS_LVL)=1 THEN
965:
966: IF l_report_set_id IS NULL THEN
967: FND_MESSAGE.SET_NAME('WSH','WSH_DOC_MISSING');
968: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);

Line 1917: IF ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_CREATE_MIXED_TRIP_LVL) = 1 )

1913: l_action := 'ADD';
1914: END IF;
1915:
1916: -- J-IB-NPARIKH-{
1917: IF ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_CREATE_MIXED_TRIP_LVL) = 1 )
1918: THEN
1919: --{
1920: IF p_trip_info_tab(l_index).shipments_type_flag = 'M'
1921: THEN

Line 1932: IF ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_FREIGHT_CARRIER_LVL) = 1 )

1928: --
1929: -- J-IB-NPARIKH-}
1930:
1931: --get the trip info from db for these specific validations
1932: IF ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_FREIGHT_CARRIER_LVL) = 1 )
1933: OR ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_VEH_ORG_LVL) = 1
1934: AND p_trip_info_tab(l_index).vehicle_organization_id = fnd_api.G_MISS_NUM )
1935: OR ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_CONSOL_ALLW_LVL) = 1 ) THEN
1936:

Line 1933: OR ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_VEH_ORG_LVL) = 1

1929: -- J-IB-NPARIKH-}
1930:
1931: --get the trip info from db for these specific validations
1932: IF ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_FREIGHT_CARRIER_LVL) = 1 )
1933: OR ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_VEH_ORG_LVL) = 1
1934: AND p_trip_info_tab(l_index).vehicle_organization_id = fnd_api.G_MISS_NUM )
1935: OR ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_CONSOL_ALLW_LVL) = 1 ) THEN
1936:
1937: OPEN get_trip_info(p_trip_info_tab(l_index).trip_id);

Line 1935: OR ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_CONSOL_ALLW_LVL) = 1 ) THEN

1931: --get the trip info from db for these specific validations
1932: IF ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_FREIGHT_CARRIER_LVL) = 1 )
1933: OR ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_VEH_ORG_LVL) = 1
1934: AND p_trip_info_tab(l_index).vehicle_organization_id = fnd_api.G_MISS_NUM )
1935: OR ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_CONSOL_ALLW_LVL) = 1 ) THEN
1936:
1937: OPEN get_trip_info(p_trip_info_tab(l_index).trip_id);
1938: FETCH get_trip_info INTO
1939: l_db_trip_info.consolidation_allowed,

Line 1950: IF ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_TRIP_NAME_LVL) = 1 ) THEN

1946: l_db_trip_info.lane_id ;
1947: CLOSE get_trip_info;
1948: END IF;
1949:
1950: IF ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_TRIP_NAME_LVL) = 1 ) THEN
1951: IF (p_trip_info_tab(l_index).trip_id IS NOT NULL ) THEN
1952: l_dummy := NULL;
1953: ELSE
1954: l_dummy := p_trip_info_tab(l_index).name;

Line 1969: IF ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_ARR_AFTER_TRIP_LVL) = 1 ) THEN

1965: x_num_warnings =>l_num_warnings,
1966: x_num_errors =>l_num_errors);
1967: END IF;
1968:
1969: IF ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_ARR_AFTER_TRIP_LVL) = 1 ) THEN
1970: WSH_TRIP_VALIDATIONS.Validate_Arrive_after_trip (
1971: p_trip_id => p_trip_info_tab(l_index).trip_id,
1972: p_arr_after_trip_id => p_trip_info_tab(l_index).arrive_after_trip_id,
1973: p_arr_after_trip_name => p_trip_info_tab(l_index).arrive_after_trip_name,

Line 1984: IF ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_FREIGHT_CARRIER_LVL) = 1 ) THEN

1980: x_num_warnings =>l_num_warnings,
1981: x_num_errors =>l_num_errors);
1982: END IF;
1983:
1984: IF ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_FREIGHT_CARRIER_LVL) = 1 ) THEN
1985: WSH_UTIL_VALIDATE.validate_freight_carrier(
1986: p_ship_method_name => p_trip_info_tab(l_index).ship_method_name,
1987: x_ship_method_code => p_trip_info_tab(l_index).ship_method_code,
1988: p_carrier_name => NULL,

Line 2050: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_FREIGHT_TERMS_LVL) = 1 THEN

2046: x_num_errors =>l_num_errors);
2047: END IF;
2048: END IF;
2049:
2050: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_FREIGHT_TERMS_LVL) = 1 THEN
2051: --
2052: wsh_util_validate.validate_freight_terms(
2053: p_freight_terms_code => p_trip_info_tab(l_index).freight_terms_code,
2054: p_freight_terms_name => NULL,

Line 2068: IF ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_VEH_ITEM_LVL) = 1 ) THEN

2064: x_num_errors => l_num_errors);
2065: --
2066: END IF;
2067:
2068: IF ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_VEH_ITEM_LVL) = 1 ) THEN
2069: IF (p_trip_info_tab(l_index).vehicle_item_id IS NOT NULL ) THEN
2070: l_dummy := NULL;
2071: ELSE
2072: l_dummy := p_trip_info_tab(l_index).vehicle_item_desc;

Line 2109: IF ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_VEH_ORG_LVL) = 1 ) THEN

2105: x_num_errors =>l_num_errors);
2106:
2107: END IF;
2108:
2109: IF ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_VEH_ORG_LVL) = 1 ) THEN
2110:
2111: IF (p_trip_info_tab(l_index).vehicle_organization_id = fnd_api.G_MISS_NUM ) THEN --Bug 3534623
2112: p_trip_info_tab(l_index).vehicle_organization_id:=l_db_trip_info.vehicle_organization_id;
2113: END IF;

Line 2190: IF ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_TRIP_SMC_LVL) = 1 ) THEN

2186: END IF;
2187:
2188: END IF;
2189:
2190: IF ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_TRIP_SMC_LVL) = 1 ) THEN
2191: IF (p_trip_info_tab(l_index).ship_method_code IS NOT NULL ) THEN
2192: l_dummy := NULL;
2193: ELSE
2194: l_dummy := p_trip_info_tab(l_index).ship_method_name;

Line 2208: IF ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_CONSOL_ALLW_LVL) = 1 ) THEN

2204: x_num_warnings =>l_num_warnings,
2205: x_num_errors =>l_num_errors);
2206: END IF;
2207:
2208: IF ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_CONSOL_ALLW_LVL) = 1 ) THEN
2209: WSH_TRIP_VALIDATIONS.Validate_Consol_Allowed(
2210: p_trip_info => p_trip_info_tab(l_index),
2211: p_db_trip_info => l_db_trip_info,
2212: x_return_status => l_return_status);

Line 2222: IF ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_TRIP_STOP_VALIDATION_LVL) = 1 ) THEN

2218: x_num_errors =>l_num_errors);
2219: END IF;
2220:
2221: IF (WSH_UTIL_CORE.FTE_IS_INSTALLED = 'Y') THEN
2222: IF ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_TRIP_STOP_VALIDATION_LVL) = 1 ) THEN
2223:
2224: -- 4106444 -skattama
2225: -- After Trip is modified
2226: -- If mode is other than TRUCK, the stops should not be greater than 2

Line 2503: WSH_ACTIONS_LEVELS.set_validation_level (

2499: l_p_trip_info_tab:=p_trip_info_tab;
2500: END IF;
2501:
2502:
2503: WSH_ACTIONS_LEVELS.set_validation_level (
2504: p_entity => 'TRIP',
2505: p_caller => p_in_rec.caller,
2506: p_phase => p_in_rec.phase,
2507: p_action => p_in_rec.action_code,

Line 2511: WSH_DEBUG_SV.log(l_module_name,'WSH_ACTIONS_LEVELS.set_validation_level l_return_status',l_return_status);

2507: p_action => p_in_rec.action_code,
2508: x_return_status => l_return_status);
2509:
2510: IF l_debug_on THEN
2511: WSH_DEBUG_SV.log(l_module_name,'WSH_ACTIONS_LEVELS.set_validation_level l_return_status',l_return_status);
2512: END IF;
2513:
2514: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2515: x_num_warnings =>l_num_warnings,

Line 2518: IF ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_DISABLED_LIST_LVL) = 1 ) THEN

2514: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2515: x_num_warnings =>l_num_warnings,
2516: x_num_errors =>l_num_errors);
2517:
2518: IF ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_DISABLED_LIST_LVL) = 1 ) THEN
2519: l_index := l_p_trip_info_tab.FIRST;
2520: WHILE l_index IS NOT NULL LOOP
2521: BEGIN
2522: SAVEPOINT l_sp_disabled_list;

Line 2560: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_VALIDATE_CONSTRAINTS_LVL) = 1 THEN --{

2556: IF l_debug_on THEN
2557: WSH_DEBUG_SV.log(l_module_name,'count, l_num_errors',l_trip_info_tab.COUNT ||','||l_num_errors);
2558: END IF;
2559:
2560: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_VALIDATE_CONSTRAINTS_LVL) = 1 THEN --{
2561: --Compatiblity Changes
2562: IF (wsh_util_core.fte_is_installed = 'Y') THEN
2563:
2564: WSH_FTE_COMP_CONSTRAINT_PKG.validate_constraint_main(