DBA Data[Home] [Help]

APPS.WSH_TRIP_STOPS_GRP dependencies on WSH_UTIL_VALIDATE

Line 127: wsh_util_validate.validate_trip_name(

123: IF FND_API.to_Boolean(p_init_msg_list) THEN
124: FND_MSG_PUB.initialize;
125: END IF;
126:
127: wsh_util_validate.validate_trip_name(
128: l_trip_id,
129: p_stop_info.trip_name,
130: l_return_status);
131:

Line 143: wsh_util_validate.validate_location(

139: --
140: IF l_stop_location_id <> WSH_UTIL_CORE.C_NULL_SF_LOCN_ID -- J-IB-NPARIKH
141: OR l_stop_location_id IS NULL
142: THEN
143: wsh_util_validate.validate_location(
144: l_stop_location_id,
145: p_stop_info.stop_location_code,
146: l_return_status);
147:

Line 153: wsh_util_validate.validate_stop_name(

149: x_num_warnings =>l_num_warning,
150: x_num_errors =>l_num_errors);
151: END IF;
152:
153: wsh_util_validate.validate_stop_name(
154: l_stop_id,
155: l_trip_id,
156: l_stop_location_id,
157: p_stop_info.planned_departure_date,

Line 365: wsh_util_validate.validate_trip_name(

361: IF FND_API.to_Boolean(p_init_msg_list) THEN
362: FND_MSG_PUB.initialize;
363: END IF;
364:
365: wsh_util_validate.validate_trip_name(
366: l_trip_id,
367: p_trip_name,
368: l_return_status);
369:

Line 381: wsh_util_validate.validate_location(

377: --
378: IF l_stop_location_id <> WSH_UTIL_CORE.C_NULL_SF_LOCN_ID -- J-IB-NPARIKH
379: OR l_stop_location_id IS NULL
380: THEN
381: wsh_util_validate.validate_location(
382: l_stop_location_id,
383: p_stop_location_code,
384: l_return_status);
385:

Line 391: wsh_util_validate.validate_stop_name(

387: x_num_warnings =>l_num_warning,
388: x_num_errors =>l_num_errors);
389: END IF;
390:
391: wsh_util_validate.validate_stop_name(
392: l_stop_id,
393: l_trip_id,
394: l_stop_location_id,
395: p_planned_dep_date,

Line 716: WSH_UTIL_VALIDATE.Validate_Stop_Name (

712: l_next := p_rec_attr_tab.FIRST;
713: --
714: WHILE l_next IS NOT NULL LOOP
715: l_stop_id := p_rec_attr_tab(l_next).stop_id;
716: WSH_UTIL_VALIDATE.Validate_Stop_Name (
717: p_stop_id => l_stop_id,
718: p_trip_id => p_rec_attr_tab(l_next).trip_id,
719: p_stop_location_id => NULL, -- not needed
720: p_planned_dep_date => NULL, -- not needed

Line 723: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_Stop_Name l_return_status',l_return_status);

719: p_stop_location_id => NULL, -- not needed
720: p_planned_dep_date => NULL, -- not needed
721: x_return_status => l_return_status);
722: IF l_debug_on THEN
723: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_Stop_Name l_return_status',l_return_status);
724: END IF;
725: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
726: x_num_warnings =>l_num_warning,
727: x_num_errors =>l_num_errors);

Line 1097: WSH_UTIL_VALIDATE.validate_report_set(

1093: wsh_debug_sv.log (l_module_name,'WSH_DOC_MISSING');
1094: END IF;
1095: RAISE FND_API.G_EXC_ERROR;
1096: END IF;
1097: WSH_UTIL_VALIDATE.validate_report_set(
1098: p_report_set_id => l_report_set_id,
1099: p_report_set_name => NULL,
1100: x_return_status => l_return_status);
1101: wsh_util_core.api_post_call(p_return_status =>l_return_status,

Line 1982: WSH_UTIL_VALIDATE.Validate_Stop_Name (

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,
1985: p_stop_location_id => NULL, -- not needed
1986: p_planned_dep_date => NULL, -- not needed

Line 1989: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_Stop_Name l_return_status',l_return_status);

1985: p_stop_location_id => NULL, -- not needed
1986: p_planned_dep_date => NULL, -- not needed
1987: x_return_status => l_return_status);
1988: IF l_debug_on THEN
1989: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_Stop_Name l_return_status',l_return_status);
1990: END IF;
1991: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
1992: x_num_warnings =>l_num_warnings,
1993: x_num_errors =>l_num_errors);

Line 2013: WSH_UTIL_VALIDATE.Validate_Trip_Name (

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);
2017: IF l_debug_on THEN

Line 2018: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_Trip_Name l_return_status',l_return_status);

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);
2017: IF l_debug_on THEN
2018: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_Trip_Name l_return_status',l_return_status);
2019: END IF;
2020: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2021: x_num_warnings =>l_num_warnings,
2022: x_num_errors =>l_num_errors);

Line 2026: WSH_UTIL_VALIDATE.Validate_Trip_status (

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);
2030: IF l_debug_on THEN

Line 2031: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_Trip_status l_return_status',l_return_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);
2030: IF l_debug_on THEN
2031: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_Trip_status l_return_status',l_return_status);
2032: END IF;
2033: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2034: x_num_warnings =>l_num_warnings,
2035: x_num_errors =>l_num_errors);

Line 2047: WSH_UTIL_VALIDATE.Validate_Location (

2043: --
2044: IF p_rec_attr_tab(l_index).stop_location_id <> WSH_UTIL_CORE.C_NULL_SF_LOCN_ID -- J-IB-NPARIKH
2045: OR p_rec_attr_tab(l_index).stop_location_id IS NULL
2046: THEN
2047: WSH_UTIL_VALIDATE.Validate_Location (
2048: p_location_id => p_rec_attr_tab(l_index).stop_location_id,
2049: p_location_code => p_rec_attr_tab(l_index).stop_location_code,
2050: x_return_status => l_return_status,
2051: p_isWshLocation => l_isWshLocation);

Line 2053: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_Location l_return_status',l_return_status);

2049: p_location_code => p_rec_attr_tab(l_index).stop_location_code,
2050: x_return_status => l_return_status,
2051: p_isWshLocation => l_isWshLocation);
2052: IF l_debug_on THEN
2053: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_Location l_return_status',l_return_status);
2054: END IF;
2055: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2056: x_num_warnings =>l_num_warnings,
2057: x_num_errors =>l_num_errors);

Line 2069: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.validate_planned_trip l_return_status',l_return_status);

2065: p_stop_sequence_number => p_rec_attr_tab(l_index).stop_sequence_number,
2066: x_return_status => l_return_status);
2067:
2068: IF l_debug_on THEN
2069: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.validate_planned_trip l_return_status',l_return_status);
2070: END IF;
2071: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2072: x_num_warnings =>l_num_warnings,
2073: x_num_errors =>l_num_errors);

Line 2077: wsh_util_validate.validate_uom (

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,
2081: p_rec_attr_tab(l_index).weight_uom_desc,

Line 2084: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.validate_uom-WEIGHT l_return_status',l_return_status);

2080: p_rec_attr_tab(l_index).weight_uom_code,
2081: p_rec_attr_tab(l_index).weight_uom_desc,
2082: l_return_status);
2083: IF l_debug_on THEN
2084: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.validate_uom-WEIGHT l_return_status',l_return_status);
2085: END IF;
2086: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2087: x_num_warnings =>l_num_warnings,
2088: x_num_errors =>l_num_errors);

Line 2092: wsh_util_validate.validate_uom (

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,
2096: p_rec_attr_tab(l_index).volume_uom_desc,

Line 2099: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.validate_uom-VOLUME l_return_status',l_return_status);

2095: p_rec_attr_tab(l_index).volume_uom_code,
2096: p_rec_attr_tab(l_index).volume_uom_desc,
2097: l_return_status);
2098: IF l_debug_on THEN
2099: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.validate_uom-VOLUME l_return_status',l_return_status);
2100: END IF;
2101: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2102: x_num_warnings =>l_num_warnings,
2103: x_num_errors =>l_num_errors);

Line 2108: WSH_UTIL_VALIDATE.validate_from_to_dates (

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);
2112: IF l_debug_on THEN

Line 2113: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.validate_from_to_dates l_return_status',l_return_status);

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);
2112: IF l_debug_on THEN
2113: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.validate_from_to_dates l_return_status',l_return_status);
2114: END IF;
2115: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2116: x_num_warnings =>l_num_warnings,
2117: x_num_errors =>l_num_errors);

Line 2134: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_SSN l_return_status',l_return_status);

2130: p_status_code => l_status_code,
2131: x_return_status => l_return_status);
2132:
2133: IF l_debug_on THEN
2134: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_SSN l_return_status',l_return_status);
2135: END IF;
2136: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2137: x_num_warnings =>l_num_warnings,
2138: x_num_errors =>l_num_errors);

Line 2150: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_Trip_Name l_return_status',l_return_status);

2146: p_trip_rec => l_trip_rec,
2147: p_action => l_action,
2148: x_return_status => l_return_status);
2149: IF l_debug_on THEN
2150: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_Trip_Name l_return_status',l_return_status);
2151: END IF;
2152: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2153: x_num_warnings =>l_num_warnings,
2154: x_num_errors =>l_num_errors);

Line 2754: WSH_UTIL_VALIDATE.Validate_Trip_MultiStops (

2750: -- 4106444 -skattama
2751: -- After Trip is created and internal location is linked
2752: -- If mode is other than TRUCK, the stops should not be greater than 2
2753: IF( WSH_UTIL_CORE.FTE_Is_Installed = 'Y') THEN
2754: WSH_UTIL_VALIDATE.Validate_Trip_MultiStops (
2755: p_trip_id => l_rec_attr_tab(x_index_id_tab(l_index)).trip_id,
2756: p_mode_of_transport => l_mode_of_transport,
2757: x_return_status => l_return_status);
2758: IF l_debug_on THEN

Line 2759: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_MultiStops l_return_status',l_return_status);

2755: p_trip_id => l_rec_attr_tab(x_index_id_tab(l_index)).trip_id,
2756: p_mode_of_transport => l_mode_of_transport,
2757: x_return_status => l_return_status);
2758: IF l_debug_on THEN
2759: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_MultiStops l_return_status',l_return_status);
2760: END IF;
2761: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2762: x_num_warnings =>l_num_warnings,
2763: x_num_errors =>l_num_errors);

Line 2881: WSH_UTIL_VALIDATE.Validate_Trip_MultiStops (

2877: -- 4106444 - skattama
2878: -- After Trip is updated with stop and internal location is linked/delinked
2879: -- If mode is other than TRUCK, the stops of the trip should not be greater than 2
2880: IF( WSH_UTIL_CORE.FTE_Is_Installed = 'Y') THEN
2881: WSH_UTIL_VALIDATE.Validate_Trip_MultiStops (
2882: p_trip_id => l_rec_attr_tab(x_index_id_tab(l_index)).trip_id,
2883: p_mode_of_transport => l_mode_of_transport,
2884: x_return_status => l_return_status);
2885: IF l_debug_on THEN

Line 2886: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_MultiStops l_return_status',l_return_status);

2882: p_trip_id => l_rec_attr_tab(x_index_id_tab(l_index)).trip_id,
2883: p_mode_of_transport => l_mode_of_transport,
2884: x_return_status => l_return_status);
2885: IF l_debug_on THEN
2886: WSH_DEBUG_SV.log(l_module_name,'WSH_UTIL_VALIDATE.Validate_MultiStops l_return_status',l_return_status);
2887: END IF;
2888: WSH_UTIL_CORE.api_post_call(p_return_status =>l_return_status,
2889: x_num_warnings =>l_num_warnings,
2890: x_num_errors =>l_num_errors);