eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FTE_FREIGHT_PRICING_SPECIAL dependencies on FND_NUMBER

Line 309: IF (nvl(fnd_number.canonical_to_number(p_param_rec.value_from),0) = 0

305:
306: IF (p_param_rec.lane_function = 'NONE' and p_param_rec.parameter_sub_type = 'MIN_CHARGE' AND
307: p_param_rec.parameter_name = 'MIN_CHARGE_AMT') THEN
308: --g_special_flags.minimum_charge_flag := decode(nvl(p_param_rec.value_from,0),0,'N','Y');
309: IF (nvl(fnd_number.canonical_to_number(p_param_rec.value_from),0) = 0
310: OR p_param_rec.currency_code IS NULL) THEN
311: g_special_flags.minimum_charge_flag := 'N';
312: ELSE
313: g_special_flags.minimum_charge_flag := 'Y';

Line 431: ELSIF (fnd_number.canonical_to_number(g_lane_parameters(i).value_from) < 0) THEN

427: IF (g_lane_parameters(i).value_from is null) THEN
428: fte_freight_pricing_util.print_msg(l_log_level,'deficit wt break point null');
429: l_invalid_df_wt_break_found := true;
430: --raise fte_freight_pricing_util.g_invalid_wt_break;
431: ELSIF (fnd_number.canonical_to_number(g_lane_parameters(i).value_from) < 0) THEN
432: fte_freight_pricing_util.print_msg(l_log_level,'deficit wt break point '||g_lane_parameters(i).value_from);
433: l_invalid_df_wt_break_found := true;
434: --raise fte_freight_pricing_util.g_invalid_wt_break;
435: ELSE

Line 472: ELSIF (fnd_number.canonical_to_number(g_lane_parameters(i).value_from) <= 0) THEN

468: AND g_lane_parameters(i).parameter_sub_type = 'HUNDREDWT'
469: AND g_lane_parameters(i).parameter_name = 'MIN_PACKAGE_WT') THEN
470: IF (g_lane_parameters(i).value_from IS NULL) THEN
471: g_lane_parameters(i).value_from := 0;
472: ELSIF (fnd_number.canonical_to_number(g_lane_parameters(i).value_from) <= 0) THEN
473: fte_freight_pricing_util.print_msg(l_log_level,'parcel hundredwt min_package_wt '||g_lane_parameters(i).value_from||' set to 0');
474: g_lane_parameters(i).value_from := 0;
475: ELSE
476: IF (g_lane_parameters(i).uom_code is null) THEN

Line 487: IF (fnd_number.canonical_to_number(g_lane_parameters(i).value_from) > 0 AND g_lane_parameters(i).currency_code is not null) THEN

483: IF (g_lane_parameters(i).lane_function = 'NONE'
484: AND g_lane_parameters(i).parameter_sub_type = 'MIN_CHARGE'
485: AND g_lane_parameters(i).parameter_name = 'MIN_CHARGE_AMT') THEN
486: IF (g_lane_parameters(i).value_from is not null) THEN
487: IF (fnd_number.canonical_to_number(g_lane_parameters(i).value_from) > 0 AND g_lane_parameters(i).currency_code is not null) THEN
488: g_special_flags.minimum_charge_flag := 'Y';
489: END IF;
490: END IF;
491: END IF;

Line 496: IF (fnd_number.canonical_to_number(g_lane_parameters(i).value_from) > 0) THEN

492:
493: IF (g_lane_parameters(i).parameter_sub_type = 'DIM_WT'
494: AND g_lane_parameters(i).parameter_name = 'FACTOR'
495: AND g_lane_parameters(i).value_from IS NOT NULL) THEN
496: IF (fnd_number.canonical_to_number(g_lane_parameters(i).value_from) > 0) THEN
497: l_dim_wt_factor_ok := true;
498: END IF;
499: END IF;
500:

Line 523: ELSIF (fnd_number.canonical_to_number(g_lane_parameters(i).value_from) <= 0) THEN

519: IF (g_lane_parameters(i).parameter_sub_type = 'DIM_WT'
520: AND g_lane_parameters(i).parameter_name = 'MIN_PACKAGE_VOLUME') THEN
521: IF (g_lane_parameters(i).value_from IS NULL) THEN
522: g_lane_parameters(i).value_from := '0';
523: ELSIF (fnd_number.canonical_to_number(g_lane_parameters(i).value_from) <= 0) THEN
524: fte_freight_pricing_util.print_msg(l_log_level,'dim_wt min_package_volume '||g_lane_parameters(i).value_from||' set to 0');
525: g_lane_parameters(i).value_from := '0';
526: ELSE
527: IF (g_lane_parameters(i).uom_code is null) THEN

Line 950: dim_wt_factor := nvl(fnd_number.canonical_to_number(g_lane_parameters(i).value_from),194);

946: LOOP
947: l_lane_id := g_lane_parameters(i).lane_id;
948: IF (g_lane_parameters(i).parameter_sub_type = 'DIM_WT'
949: AND g_lane_parameters(i).parameter_name = 'FACTOR') THEN
950: dim_wt_factor := nvl(fnd_number.canonical_to_number(g_lane_parameters(i).value_from),194);
951: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'dim_wt_factor = '||dim_wt_factor);
952: END IF;
953: IF (g_lane_parameters(i).parameter_sub_type = 'DIM_WT'
954: AND g_lane_parameters(i).parameter_name = 'WT_UOM') THEN

Line 970: min_vol_param := fnd_number.canonical_to_number(g_lane_parameters(i).value_from);

966: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'dim_uom_param = '||dim_uom_param);
967: END IF;
968: IF (g_lane_parameters(i).parameter_sub_type = 'DIM_WT'
969: AND g_lane_parameters(i).parameter_name = 'MIN_PACKAGE_VOLUME') THEN
970: min_vol_param := fnd_number.canonical_to_number(g_lane_parameters(i).value_from);
971: min_vol_uom := g_lane_parameters(i).uom_code;
972: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'min_vol_param = '||min_vol_param);
973: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'min_vol_uom = '||min_vol_uom);
974: END IF;

Line 1955: fnd_number.canonical_to_number(g_lane_parameters(i).value_from),

1951: 0,-- Within same UOM class
1952: --5,
1953: nvl(FND_PROFILE.Value ('QP_INV_DECIMAL_PRECISION'),10),
1954: -- Bug 2360273 : precision same as QP's precision
1955: fnd_number.canonical_to_number(g_lane_parameters(i).value_from),
1956: g_lane_parameters(i).uom_code,
1957: p_total_wt_uom,
1958: NULL,
1959: NULL);

Line 1974: l_curr_break := fnd_number.canonical_to_number(g_lane_parameters(i).value_from);

1970: g_lane_parameters(i).value_from,
1971: 0); -- Within same UOM class
1972: */
1973: ELSE
1974: l_curr_break := fnd_number.canonical_to_number(g_lane_parameters(i).value_from);
1975: END IF;
1976:
1977: l_curr_diff := l_curr_break - p_total_wt;
1978: IF (l_curr_diff < l_least_diff AND l_curr_diff >= 0) THEN

Line 2089: min_charge_amt := fnd_number.canonical_to_number(g_lane_parameters(i).value_from);

2085: IF (i IS NOT NULL) THEN
2086: LOOP
2087: IF (g_lane_parameters(i).parameter_sub_type = 'MIN_CHARGE'
2088: AND g_lane_parameters(i).parameter_name = 'MIN_CHARGE_AMT') THEN
2089: min_charge_amt := fnd_number.canonical_to_number(g_lane_parameters(i).value_from);
2090: currency := g_lane_parameters(i).currency_code;
2091: END IF;
2092:
2093: EXIT WHEN (i >= g_lane_parameters.LAST);

Line 3546: min_package_wt := fnd_number.canonical_to_number(g_lane_parameters(i).value_from);

3542: LOOP
3543: IF (g_lane_parameters(i).parameter_sub_type = 'HUNDREDWT'
3544: AND g_lane_parameters(i).lane_function = 'PARCEL'
3545: AND g_lane_parameters(i).parameter_name = 'MIN_PACKAGE_WT') THEN
3546: min_package_wt := fnd_number.canonical_to_number(g_lane_parameters(i).value_from);
3547: min_wt_uom := g_lane_parameters(i).uom_code;
3548: END IF;
3549:
3550: EXIT WHEN (i >= g_lane_parameters.LAST);