DBA Data[Home] [Help]

APPS.WSH_TRIP_STOPS_GRP dependencies on WSH_ACTIONS_LEVELS

Line 698: WSH_ACTIONS_LEVELS.set_validation_level (

694: l_next := p_rec_attr_tab.NEXT(l_next);
695: END LOOP;
696:
697:
698: WSH_ACTIONS_LEVELS.set_validation_level (
699: p_entity => 'STOP',
700: p_caller => p_action_prms.caller,
701: p_phase => p_action_prms.phase,
702: p_action =>p_action_prms.action_code ,

Line 710: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_STOP_NAME_LVL) = 1 THEN

706: wsh_util_core.api_post_call(p_return_status =>l_return_status,
707: x_num_warnings =>l_num_warning,
708: x_num_errors =>l_num_errors);
709:
710: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_STOP_NAME_LVL) = 1 THEN
711: -- validate the stops are eligible for action.
712: l_next := p_rec_attr_tab.FIRST;
713: --
714: WHILE l_next IS NOT NULL LOOP

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

730: END LOOP;
731: --
732: END IF;
733:
734: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_ACTION_ENABLED_LVL) = 1 THEN
735: WSH_TRIP_STOPS_validations.Is_Action_Enabled(
736: p_stop_rec_tab => l_stop_rec_tab,
737: p_action => p_action_prms.action_code,
738: p_caller => p_action_prms.caller,

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

746: p_msg_data => NULL,
747: p_raise_error_flag => FALSE);
748:
749: END IF;
750: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_LOCK_RECORDS_LVL) = 1 THEN
751: IF NOT ( p_action_prms.caller = 'WSH_FSTRX'
752: AND p_action_prms.action_code = 'DELETE'
753: ) THEN --BUG 4354579
754: WSH_TRIP_STOPS_PVT.Lock_Trip_Stop(

Line 798: wsh_debug_sv.log (l_module_name,'C_STOP_DEFAULTS_LVL', WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_STOP_DEFAULTS_LVL));

794: x_stop_out_rec.selection_issue_flag := 'Y';
795: END IF;
796:
797: IF l_debug_on THEN
798: wsh_debug_sv.log (l_module_name,'C_STOP_DEFAULTS_LVL', WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_STOP_DEFAULTS_LVL));
799: END IF;
800:
801: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_STOP_DEFAULTS_LVL)=1 THEN
802: IF l_status_code = 'OP' THEN

Line 801: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_STOP_DEFAULTS_LVL)=1 THEN

797: IF l_debug_on THEN
798: wsh_debug_sv.log (l_module_name,'C_STOP_DEFAULTS_LVL', WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_STOP_DEFAULTS_LVL));
799: END IF;
800:
801: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_STOP_DEFAULTS_LVL)=1 THEN
802: IF l_status_code = 'OP' THEN
803: x_def_rec.date_field := 'STOP.ACTUAL_ARRIVAL_DATE';
804: x_def_rec.status_code := 'AR';
805: x_def_rec.status_name := 'Arrived';

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

909: RETURN; -- Non-Generic Actions.
910: END IF;
911:
912:
913: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_VALIDATE_CONSTRAINTS_LVL) = 1 THEN --{
914: --Compatiblity Changes
915: --for autocreatetrip or if assign trip and caller is STF, phase=2
916:
917:

Line 1031: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_LOCK_RELATED_ENTITIES_LVL) = 1

1027: --Compatiblity Changes
1028: END IF ; --}
1029:
1030: -- jckwok: Bug 2684692 added the below case
1031: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_LOCK_RELATED_ENTITIES_LVL) = 1
1032: AND p_action_prms.stop_action = 'CLOSE'
1033: THEN
1034:
1035: Lock_Related_Entity(

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

1084: x_num_warnings =>l_num_warning,
1085: x_num_errors =>l_num_errors);
1086:
1087: ELSIF p_action_prms.action_code = 'PRINT-DOC-SETS' THEN
1088: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_DOCUMENT_SETS_LVL)=1 THEN
1089: IF l_report_set_id IS NULL THEN
1090: FND_MESSAGE.SET_NAME('WSH','WSH_DOC_MISSING');
1091: wsh_util_core.add_message(WSH_UTIL_CORE.G_RET_STS_ERROR,l_module_name);
1092: IF l_debug_on THEN

Line 1165: 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));

1161: wsh_debug_sv.log (l_module_name,'actual_date',
1162: p_action_prms.actual_date);
1163: wsh_debug_sv.log (l_module_name,'defer_interface_flag',
1164: p_action_prms.defer_interface_flag);
1165: 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));
1166: END IF;
1167:
1168: -- BUG 4247388 - FP:11I10-12.0: if actual date is NULL, always default to SYSDATE here
1169: -- (whether updating status to Arrived or Closed) to ensure that

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

1176: wsh_debug_sv.log (l_module_name,'l_actual_date', l_actual_date);
1177: END IF;
1178:
1179:
1180: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_TRIP_STOP_VALIDATION_LVL) = 1
1181: THEN
1182: --
1183: l_is_installed := WSH_UTIL_CORE.FTE_Is_Installed ;
1184: IF l_is_installed = 'Y' THEN

Line 1243: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_CHK_UPDATE_STATUS_LVL) = 1 THEN

1239: --
1240: END IF;
1241: --
1242: END IF;
1243: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_CHK_UPDATE_STATUS_LVL) = 1 THEN
1244: if l_debug_on then
1245: wsh_debug_sv.log(l_module_name, 'l_stop_id_tab count', l_stop_id_tab.count);
1246: end if;
1247: WSH_TRIP_STOPS_ACTIONS.Check_Update_Stops(

Line 1980: IF ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_STOP_NAME_LVL) = 1) THEN

1976: l_status_code := 'OP';
1977: l_action := 'ADD';
1978: END IF;
1979:
1980: IF ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_STOP_NAME_LVL) = 1) THEN
1981: l_stop_id := p_rec_attr_tab(l_index).stop_id;
1982: WSH_UTIL_VALIDATE.Validate_Stop_Name (
1983: p_stop_id => l_stop_id,
1984: p_trip_id => p_rec_attr_tab(l_index).trip_id,

Line 1998: IF ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_CREATE_MIXED_STOP_LVL) = 1 )

1994:
1995: END IF;
1996:
1997: -- J-IB-NPARIKH-{
1998: IF ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_CREATE_MIXED_STOP_LVL) = 1 )
1999: THEN
2000: --{
2001: IF p_rec_attr_tab(l_index).shipments_type_flag = 'M'
2002: THEN

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

2008: END IF;
2009: --
2010: -- J-IB-NPARIKH-}
2011:
2012: IF ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_TRIP_NAME_LVL) = 1 ) THEN
2013: WSH_UTIL_VALIDATE.Validate_Trip_Name (
2014: p_trip_id => p_rec_attr_tab(l_index).trip_id,
2015: p_trip_name => p_rec_attr_tab(l_index).trip_name,
2016: x_return_status => l_return_status);

Line 2025: IF ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_TRIP_STATUS_LVL) = 1 ) THEN

2021: x_num_warnings =>l_num_warnings,
2022: x_num_errors =>l_num_errors);
2023: END IF;
2024:
2025: IF ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_TRIP_STATUS_LVL) = 1 ) THEN
2026: WSH_UTIL_VALIDATE.Validate_Trip_status (
2027: p_trip_id => p_rec_attr_tab(l_index).trip_id,
2028: p_action => p_action_code,
2029: x_return_status => l_return_status);

Line 2038: IF ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_LOCATION_LVL) = 1 ) THEN

2034: x_num_warnings =>l_num_warnings,
2035: x_num_errors =>l_num_errors);
2036: END IF;
2037:
2038: IF ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_LOCATION_LVL) = 1 ) THEN
2039:
2040: -- Stop location id can be -1 for inbound stops
2041: -- in such case, we do not need to call validate location, as it wil fail
2042: -- in turn preventing any update of stop attributes

Line 2062: IF ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_PLANNED_TRIP_LVL) = 1 ) THEN

2058: END IF;
2059: END IF;
2060:
2061:
2062: IF ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_PLANNED_TRIP_LVL) = 1 ) THEN
2063: wsh_trip_validations.validate_planned_trip
2064: (p_stop_id => p_rec_attr_tab(l_index).stop_id,
2065: p_stop_sequence_number => p_rec_attr_tab(l_index).stop_sequence_number,
2066: x_return_status => l_return_status);

Line 2076: IF ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_WEIGHT_UOM_LVL) = 1 ) THEN

2072: x_num_warnings =>l_num_warnings,
2073: x_num_errors =>l_num_errors);
2074: END IF;
2075:
2076: IF ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_WEIGHT_UOM_LVL) = 1 ) THEN
2077: wsh_util_validate.validate_uom (
2078: 'WEIGHT',
2079: NULL,
2080: p_rec_attr_tab(l_index).weight_uom_code,

Line 2091: IF ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_VOLUME_UOM_LVL) = 1 ) THEN

2087: x_num_warnings =>l_num_warnings,
2088: x_num_errors =>l_num_errors);
2089: END IF;
2090:
2091: IF ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_VOLUME_UOM_LVL) = 1 ) THEN
2092: wsh_util_validate.validate_uom (
2093: 'VOLUME',
2094: NULL,
2095: p_rec_attr_tab(l_index).volume_uom_code,

Line 2107: IF ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_ARR_DEP_DATES_LVL) = 1 ) THEN

2103: x_num_errors =>l_num_errors);
2104: END IF;
2105:
2106:
2107: IF ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_ARR_DEP_DATES_LVL) = 1 ) THEN
2108: WSH_UTIL_VALIDATE.validate_from_to_dates (
2109: p_from_date => p_rec_attr_tab(l_index).planned_arrival_date,
2110: p_to_date =>p_rec_attr_tab(l_index).planned_departure_date,
2111: x_return_status => l_return_status);

Line 2123: (WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_SEQ_NUM_LVL) = 1 ) THEN

2119:
2120: -- SSN change
2121: -- Add conditional validation for stop sequence number
2122: IF (WSH_TRIPS_ACTIONS.GET_STOP_SEQ_MODE = WSH_INTERFACE_GRP.G_STOP_SEQ_MODE_SSN) AND
2123: (WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_SEQ_NUM_LVL) = 1 ) THEN
2124:
2125: IF (l_status_code = 'OP') THEN
2126: WSH_TRIP_STOPS_validations.validate_sequence_number (
2127: p_stop_id => p_rec_attr_tab(l_index).stop_id,

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

2139: END IF;
2140: END IF;
2141:
2142: IF (WSH_UTIL_CORE.FTE_IS_INSTALLED = 'Y') THEN
2143: IF ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_TRIP_STOP_VALIDATION_LVL) = 1 ) THEN
2144: WSH_FTE_INTEGRATION.trip_stop_validations
2145: (p_stop_rec => p_rec_attr_tab(l_index),
2146: p_trip_rec => l_trip_rec,
2147: p_action => l_action,

Line 2482: WSH_ACTIONS_LEVELS.set_validation_level (

2478: wsh_util_core.add_message(x_return_status,l_module_name);
2479: raise fnd_api.g_exc_error;
2480: END IF;
2481:
2482: WSH_ACTIONS_LEVELS.set_validation_level (
2483: p_entity => 'STOP',
2484: p_caller => p_in_rec.caller,
2485: p_phase => p_in_rec.phase,
2486: p_action => p_in_rec.action_code,

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

2486: p_action => p_in_rec.action_code,
2487: x_return_status => l_return_status);
2488:
2489: IF l_debug_on THEN
2490: WSH_DEBUG_SV.log(l_module_name,'WSH_ACTIONS_LEVELS.set_validation_level l_return_status',l_return_status);
2491: END IF;
2492:
2493: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2494: x_num_warnings =>l_num_warnings,

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

2494: x_num_warnings =>l_num_warnings,
2495: x_num_errors =>l_num_errors);
2496:
2497:
2498: IF ( WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_DISABLED_LIST_LVL) = 1 ) THEN
2499: l_index := p_rec_attr_tab.FIRST;
2500: WHILE l_index IS NOT NULL LOOP
2501: BEGIN
2502: SAVEPOINT s_stop_disabled_list_grp;

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

2544: IF l_debug_on THEN
2545: WSH_DEBUG_SV.log(l_module_name,'count, l_num_errors',l_rec_attr_tab.COUNT ||','||l_num_errors);
2546: END IF;
2547:
2548: IF WSH_ACTIONS_LEVELS.g_validation_level_tab(WSH_ACTIONS_LEVELS.C_VALIDATE_CONSTRAINTS_LVL) = 1 THEN --{
2549: --Compatiblity Changes
2550: IF (wsh_util_core.fte_is_installed = 'Y') THEN
2551:
2552: -- populate physical_location_id before validate_constraint_main