APPS.FTE_ACS_CACHE_PKG dependencies on FTE_ACS_RULE_UTIL_PKG

Line 1139: -- If flag is not set then call FTE_ACS_RULE_UTIL_PKG.SET_overlap_FLAG

1135: -- ALGORITHM :
1136: -- 1, Drop the cache if number of groups is more than the limit.
1137: -- 2. Query for all the rules within a group.
1138: -- 3. Check if overlap flag is set for a sample rule.
1139: -- If flag is not set then call FTE_ACS_RULE_UTIL_PKG.SET_overlap_FLAG
1140: -- 4. For all Rules
1141: -- Get all the attributes for a rule.
1142: -- Put the respective attributes in respective caches.
1143: --

Line 1255: FTE_ACS_RULE_UTIL_PKG.SET_RANGE_OVERLAP_FLAG(p_group_id => p_group_id);

1251: --
1252: -- overlap flag needs to be set
1253: --
1254:
1255: FTE_ACS_RULE_UTIL_PKG.SET_RANGE_OVERLAP_FLAG(p_group_id => p_group_id);
1256:
1257: --
1258: -- Delete Rule Tab and query again.
1259: --

Line 3448: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_ACS_RULE_UTIL_PKG.CONV_TO_BASE_UOM');

3444: -- Change weight
3445: IF (l_group_cache_rec.weight_uom_code <> p_info.weight_uom_code) THEN
3446:
3447: IF l_debug_on THEN
3448: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_ACS_RULE_UTIL_PKG.CONV_TO_BASE_UOM');
3449: END IF;
3450: --
3451: l_weight_val:=FTE_ACS_RULE_UTIL_PKG.CONV_TO_BASE_UOM(p_input_value => p_info.weight,
3452: p_from_uom => p_info.weight_uom_code,

Line 3451: l_weight_val:=FTE_ACS_RULE_UTIL_PKG.CONV_TO_BASE_UOM(p_input_value => p_info.weight,

3447: IF l_debug_on THEN
3448: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_ACS_RULE_UTIL_PKG.CONV_TO_BASE_UOM');
3449: END IF;
3450: --
3451: l_weight_val:=FTE_ACS_RULE_UTIL_PKG.CONV_TO_BASE_UOM(p_input_value => p_info.weight,
3452: p_from_uom => p_info.weight_uom_code,
3453: p_to_uom => l_group_cache_rec.weight_uom_code);
3454:
3455: IF (l_weight_val < 0 ) THEN

Line 3475: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_ACS_RULE_UTIL_PKG.CONV_TO_BASE_UOM');

3471: -- Change volume
3472: IF (l_group_cache_rec.volume_uom_code <> p_info.volume_uom_code) THEN
3473:
3474: IF l_debug_on THEN
3475: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_ACS_RULE_UTIL_PKG.CONV_TO_BASE_UOM');
3476: END IF;
3477: --
3478: l_volume_val:=FTE_ACS_RULE_UTIL_PKG.CONV_TO_BASE_UOM(p_input_value => p_info.volume,
3479: p_from_uom => p_info.volume_uom_code,

Line 3478: l_volume_val:=FTE_ACS_RULE_UTIL_PKG.CONV_TO_BASE_UOM(p_input_value => p_info.volume,

3474: IF l_debug_on THEN
3475: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit FTE_ACS_RULE_UTIL_PKG.CONV_TO_BASE_UOM');
3476: END IF;
3477: --
3478: l_volume_val:=FTE_ACS_RULE_UTIL_PKG.CONV_TO_BASE_UOM(p_input_value => p_info.volume,
3479: p_from_uom => p_info.volume_uom_code,
3480: p_to_uom => l_group_cache_rec.volume_uom_code);
3481:
3482: IF (l_volume_val < 0 ) THEN

Line 3499: FTE_ACS_RULE_UTIL_PKG.get_formated_regions(

3495:
3496: -- We encapsulate region type 3 as
3497: -- pregion(Region type 2,1,0) + postal code
3498:
3499: FTE_ACS_RULE_UTIL_PKG.get_formated_regions(
3500: p_location_id => p_info.ship_from_location_id,
3501: x_region_tab => from_pregion_tab,
3502: x_all_region_tab => from_all_region_tab,
3503: x_postal_zone_tab => from_postal_zone_tab,

Line 3554: FTE_ACS_RULE_UTIL_PKG.get_formated_regions(

3550:
3551:
3552: IF (l_attribute_tab.EXISTS(g_to_reg_idx)) THEN
3553:
3554: FTE_ACS_RULE_UTIL_PKG.get_formated_regions(
3555: p_location_id => p_info.ship_to_location_id,
3556: x_region_tab => to_pregion_tab,
3557: x_all_region_tab => to_all_region_tab,
3558: x_postal_zone_tab => to_postal_zone_tab,

Line 3598: FTE_ACS_RULE_UTIL_PKG.get_postal_code(p_location_id => p_info.ship_from_location_id,

3594:
3595:
3596: IF (l_attribute_tab.EXISTS(g_fr_post_idx)) THEN
3597:
3598: FTE_ACS_RULE_UTIL_PKG.get_postal_code(p_location_id => p_info.ship_from_location_id,
3599: x_postal_code => from_postal_code,
3600: x_return_status => l_return_status);
3601:
3602: IF l_debug_on THEN

Line 3631: FTE_ACS_RULE_UTIL_PKG.get_postal_code(p_location_id => p_info.ship_to_location_id,

3627:
3628:
3629: IF (l_attribute_tab.EXISTS(g_to_post_idx)) THEN
3630:
3631: FTE_ACS_RULE_UTIL_PKG.get_postal_code(p_location_id => p_info.ship_to_location_id,
3632: x_postal_code => to_postal_code,
3633: x_return_status => l_return_status);
3634:
3635: IF l_debug_on THEN