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_TL_LOADER dependencies on FND_NUMBER

Line 426: qc.qualifier_attr_value = Fnd_Number.Number_To_Canonical(g_carrier_id) AND

422: WHERE
423: lh.list_header_id = b.list_header_id AND
424: qc.qualifier_attribute = 'QUALIFIER_ATTRIBUTE1' AND
425: qc.qualifier_context = 'PARTY' AND
426: qc.qualifier_attr_value = Fnd_Number.Number_To_Canonical(g_carrier_id) AND
427: qc.list_header_id = lh.list_header_id AND
428: qs.qualifier_attribute = 'QUALIFIER_ATTRIBUTE10' AND
429: qs.qualifier_context = 'LOGISTICS' AND
430: qs.qualifier_attr_value = p_service_level AND

Line 1053: l_attribute_data('LINE_NUMBER') := Fnd_Number.Number_To_Canonical(p_linenum);

1049: FTE_UTIL_PKG.Enter_Debug(l_module_name);
1050: x_status := -1;
1051:
1052: l_attribute_data('ACTION') := 'ADD';
1053: l_attribute_data('LINE_NUMBER') := Fnd_Number.Number_To_Canonical(p_linenum);
1054: l_attribute_data('ATTRIBUTE') := p_attribute_type;
1055: l_attribute_data('ATTRIBUTE_VALUE') := p_attribute_value;
1056: l_attribute_data('ATTRIBUTE_VALUE_TO') := p_attribute_value_to;
1057: l_attribute_data('CONTEXT') := p_context;

Line 1211: l_rate := Fnd_Number.Canonical_To_Number(p_break_charges(l_index1));

1207: l_index2 := p_break_limits.FIRST;
1208:
1209: FOR i IN 1..p_break_charges.COUNT LOOP
1210:
1211: l_rate := Fnd_Number.Canonical_To_Number(p_break_charges(l_index1));
1212: l_break_min := l_break_max + p_break_gap;
1213: l_break_max := Fnd_Number.Canonical_To_Number(p_break_limits(l_index2));
1214: x_linenum := x_linenum + 1;
1215:

Line 1213: l_break_max := Fnd_Number.Canonical_To_Number(p_break_limits(l_index2));

1209: FOR i IN 1..p_break_charges.COUNT LOOP
1210:
1211: l_rate := Fnd_Number.Canonical_To_Number(p_break_charges(l_index1));
1212: l_break_min := l_break_max + p_break_gap;
1213: l_break_max := Fnd_Number.Canonical_To_Number(p_break_limits(l_index2));
1214: x_linenum := x_linenum + 1;
1215:
1216: IF (FTE_BULKLOAD_PKG.g_debug_on) THEN
1217: FTE_UTIL_PKG.Write_LogFile(l_module_name, 'x_linenum ' || x_linenum);

Line 1225: l_rate_break_data('LOWER_LIMIT'):= Fnd_Number.Number_To_Canonical(l_break_min);

1221: END IF;
1222:
1223: l_rate_break_data('ACTION') := 'ADD'; --G_ACTION;
1224: l_rate_break_data('LINE_NUMBER'):= x_linenum;
1225: l_rate_break_data('LOWER_LIMIT'):= Fnd_Number.Number_To_Canonical(l_break_min);
1226: l_rate_break_data('UPPER_LIMIT'):= Fnd_Number.Number_To_Canonical(l_break_max);
1227: l_rate_break_data('RATE') := Fnd_Number.Number_To_Canonical(l_rate);
1228: l_rate_break_data('RATE_TYPE') := p_rate_type;
1229: l_rate_break_data('ATTRIBUTE') := p_attribute_type;

Line 1226: l_rate_break_data('UPPER_LIMIT'):= Fnd_Number.Number_To_Canonical(l_break_max);

1222:
1223: l_rate_break_data('ACTION') := 'ADD'; --G_ACTION;
1224: l_rate_break_data('LINE_NUMBER'):= x_linenum;
1225: l_rate_break_data('LOWER_LIMIT'):= Fnd_Number.Number_To_Canonical(l_break_min);
1226: l_rate_break_data('UPPER_LIMIT'):= Fnd_Number.Number_To_Canonical(l_break_max);
1227: l_rate_break_data('RATE') := Fnd_Number.Number_To_Canonical(l_rate);
1228: l_rate_break_data('RATE_TYPE') := p_rate_type;
1229: l_rate_break_data('ATTRIBUTE') := p_attribute_type;
1230: l_rate_break_data('TYPE') := 'ACCESSORIAL_SURCHARGE';

Line 1227: l_rate_break_data('RATE') := Fnd_Number.Number_To_Canonical(l_rate);

1223: l_rate_break_data('ACTION') := 'ADD'; --G_ACTION;
1224: l_rate_break_data('LINE_NUMBER'):= x_linenum;
1225: l_rate_break_data('LOWER_LIMIT'):= Fnd_Number.Number_To_Canonical(l_break_min);
1226: l_rate_break_data('UPPER_LIMIT'):= Fnd_Number.Number_To_Canonical(l_break_max);
1227: l_rate_break_data('RATE') := Fnd_Number.Number_To_Canonical(l_rate);
1228: l_rate_break_data('RATE_TYPE') := p_rate_type;
1229: l_rate_break_data('ATTRIBUTE') := p_attribute_type;
1230: l_rate_break_data('TYPE') := 'ACCESSORIAL_SURCHARGE';
1231:

Line 1446: l_mincharge := Fnd_Number.Canonical_To_Number(l_charge_info(l_count+7));

1442:
1443: l_basis := l_charge_info(l_count + 1);
1444: l_vehicle_type := l_charge_info(l_count + 3);
1445: l_uom := l_charge_info(l_count + 5);
1446: l_mincharge := Fnd_Number.Canonical_To_Number(l_charge_info(l_count+7));
1447:
1448: IF (l_basis = 'DISTANCE') THEN
1449: l_subtype := FTE_RTG_GLOBALS.G_C_MIN_DISTANCE_CH;
1450: ELSIF (l_basis = 'TIME') THEN

Line 1473: l_rate_line_data('FIXED_RATE') := Fnd_Number.Number_To_Canonical(l_mincharge);

1469: --
1470: l_rate_line_data('ACTION') := G_ACTION;
1471: l_rate_line_data('LINE_NUMBER') := l_linenum;
1472: l_rate_line_data('DESCRIPTION') := l_description;
1473: l_rate_line_data('FIXED_RATE') := Fnd_Number.Number_To_Canonical(l_mincharge);
1474: l_rate_line_data('UOM') := l_uom;
1475: l_rate_line_data('RATE_BREAK_TYPE') := 'POINT';
1476: l_rate_line_data('RATE_TYPE') := 'LUMPSUM';
1477: l_rate_line_data('TYPE') := l_type;

Line 1603: l_str := 'B:' || p_basis || ':V:' || p_vehicle||':U:'|| p_uom ||':C:' || Fnd_Number.Number_To_Canonical(p_charge) || ':';

1599:
1600: --+
1601: -- Create the minimum charge string.
1602: --+
1603: l_str := 'B:' || p_basis || ':V:' || p_vehicle||':U:'|| p_uom ||':C:' || Fnd_Number.Number_To_Canonical(p_charge) || ':';
1604:
1605: FOR i IN 1.. Chart_Names.COUNT LOOP
1606: IF (p_chart_name = Chart_Names(i)) THEN
1607: IF (NOT Chart_Min_Charges.EXISTS(i)) THEN

Line 1819: p_break_start => Fnd_Number.Canonical_To_Number('0'),

1815: END IF;
1816:
1817: CREATE_BREAKS (p_break_charges => g_layovr_charges,
1818: p_break_limits => g_layovr_breaks,
1819: p_break_start => Fnd_Number.Canonical_To_Number('0'),
1820: p_break_gap => Fnd_Number.Canonical_To_Number('0'),
1821: p_rate_type => 'LUMPSUM',
1822: p_attribute_type => 'TL_WEEKEND_LAYOVER_MILEAGE',
1823: p_process_id => p_process_id,

Line 1820: p_break_gap => Fnd_Number.Canonical_To_Number('0'),

1816:
1817: CREATE_BREAKS (p_break_charges => g_layovr_charges,
1818: p_break_limits => g_layovr_breaks,
1819: p_break_start => Fnd_Number.Canonical_To_Number('0'),
1820: p_break_gap => Fnd_Number.Canonical_To_Number('0'),
1821: p_rate_type => 'LUMPSUM',
1822: p_attribute_type => 'TL_WEEKEND_LAYOVER_MILEAGE',
1823: p_process_id => p_process_id,
1824: x_linenum => x_linenum,

Line 2214: q.qualifier_attr_value = Fnd_Number.Number_To_Canonical(g_carrier_id) AND

2210: WHERE
2211: lh.list_header_id = b.list_header_id AND
2212: lh.list_header_id = q.list_header_id AND
2213: q.qualifier_context = 'PARTY' AND
2214: q.qualifier_attr_value = Fnd_Number.Number_To_Canonical(g_carrier_id) AND
2215: lh.name = l_chart_name AND
2216: lh.language = userenv('LANG');
2217:
2218: EXCEPTION

Line 2303: Fnd_Number.Canonical_To_Number(qual.qualifier_attr_value)

2299: BEGIN
2300:
2301: SELECT
2302: modc.list_header_id,
2303: Fnd_Number.Canonical_To_Number(qual.qualifier_attr_value)
2304: INTO
2305: l_modifier_id,
2306: l_list_header_id
2307: FROM

Line 2465: l_rate_line_data('PERCENTAGE') := Fnd_Number.Number_To_Canonical(p_charge);

2461: l_rate_line_data('DESCRIPTION') := l_description;
2462: l_rate_line_data('VOLUME_TYPE') := 'TOTAL_QUANTITY';
2463: l_rate_line_data('SUBTYPE') := l_subtype;
2464: l_rate_line_data('TYPE') := l_type;
2465: l_rate_line_data('PERCENTAGE') := Fnd_Number.Number_To_Canonical(p_charge);
2466: l_rate_line_data('UOM') := g_unit_uom;
2467:
2468: l_rate_line_block_tbl(1) := l_rate_line_data;
2469:

Line 2597: l_rate_line_data('FIXED_RATE') := Fnd_Number.Number_To_Canonical(p_charge);

2593: l_rate_line_data('DESCRIPTION'):= l_description;
2594: l_rate_line_data('VOLUME_TYPE'):= 'TOTAL_QUANTITY';
2595: l_rate_line_data('SUBTYPE') := l_subtype;
2596: l_rate_line_data('TYPE') := l_type;
2597: l_rate_line_data('FIXED_RATE') := Fnd_Number.Number_To_Canonical(p_charge);
2598: l_rate_line_data('UOM') := g_unit_uom;
2599:
2600: l_rate_line_block_tbl(1) := l_rate_line_data;
2601:

Line 2648: p_attribute_value => Fnd_Number.Number_To_Canonical(l_zone_id),

2644: l_context := FTE_RTG_GLOBALS.G_AX_DESTINATION_ZONE;
2645: END IF;
2646:
2647: ADD_ATTRIBUTE (p_attribute_type => l_attribute_type,
2648: p_attribute_value => Fnd_Number.Number_To_Canonical(l_zone_id),
2649: p_attribute_value_to => NULL,
2650: p_context => l_context,
2651: p_comp_operator => NULL,
2652: p_linenum => x_linenum,

Line 2815: l_break_limits(1) := Fnd_Number.Number_To_Canonical(l_break_start);

2811: --+
2812: -- create the break limits
2813: --+
2814: l_break_limits.EXTEND;
2815: l_break_limits(1) := Fnd_Number.Number_To_Canonical(l_break_start);
2816:
2817: FOR i IN 2..l_break_charges.COUNT LOOP
2818: l_break_limits.EXTEND;
2819: l_break_limits(i) := Fnd_Number.Number_To_Canonical(Fnd_Number.Canonical_To_Number(l_break_limits(i-1)) + 1);

Line 2819: l_break_limits(i) := Fnd_Number.Number_To_Canonical(Fnd_Number.Canonical_To_Number(l_break_limits(i-1)) + 1);

2815: l_break_limits(1) := Fnd_Number.Number_To_Canonical(l_break_start);
2816:
2817: FOR i IN 2..l_break_charges.COUNT LOOP
2818: l_break_limits.EXTEND;
2819: l_break_limits(i) := Fnd_Number.Number_To_Canonical(Fnd_Number.Canonical_To_Number(l_break_limits(i-1)) + 1);
2820: END LOOP;
2821:
2822: l_break_limits(l_break_limits.COUNT) := g_max_number;
2823:

Line 2833: p_break_start => Fnd_Number.Canonical_To_Number('0'),

2829: END IF;
2830:
2831: CREATE_BREAKS(p_break_charges => l_break_charges,
2832: p_break_limits => l_break_limits,
2833: p_break_start => Fnd_Number.Canonical_To_Number('0'),
2834: p_break_gap => Fnd_Number.Canonical_To_Number('0'),
2835: p_rate_type => l_rate_type,
2836: p_attribute_type => 'TL_NUM_STOPS',
2837: p_process_id => p_process_id,

Line 2834: p_break_gap => Fnd_Number.Canonical_To_Number('0'),

2830:
2831: CREATE_BREAKS(p_break_charges => l_break_charges,
2832: p_break_limits => l_break_limits,
2833: p_break_start => Fnd_Number.Canonical_To_Number('0'),
2834: p_break_gap => Fnd_Number.Canonical_To_Number('0'),
2835: p_rate_type => l_rate_type,
2836: p_attribute_type => 'TL_NUM_STOPS',
2837: p_process_id => p_process_id,
2838: x_linenum => x_linenum,

Line 3301: l_rate_line_data('RATE') := Fnd_Number.Number_To_Canonical(l_rate);

3297:
3298: l_rate_line_data('ACTION') := G_ACTION;
3299: l_rate_line_data('LINE_NUMBER') := x_linenum;
3300: l_rate_line_data('DESCRIPTION') := l_description;
3301: l_rate_line_data('RATE') := Fnd_Number.Number_To_Canonical(l_rate);
3302: l_rate_line_data('UOM') := g_unit_uom;
3303: l_rate_line_data('VOLUME_TYPE') := 'TOTAL_QUANTITY';
3304: l_rate_line_data('TYPE') := l_type;
3305: l_rate_line_data('RATE_TYPE') := l_rate_type;

Line 3413: l_attr_value_to := Fnd_Number.Number_To_Canonical(ROUND(p_min_charge/p_charge, 1));

3409: l_rate := p_charge;
3410: l_subtype2 := l_subtype;
3411: l_rate_type := 'BLOCK_UNIT';
3412: ELSE
3413: l_attr_value_to := Fnd_Number.Number_To_Canonical(ROUND(p_min_charge/p_charge, 1));
3414: l_rate := p_min_charge;
3415: l_subtype2 := l_subtype_min;
3416: l_rate_type := 'LUMPSUM';
3417: END IF;

Line 3425: l_rate_break_data('RATE') := Fnd_Number.Number_To_Canonical(l_rate);

3421: l_rate_break_data('ACTION') := G_ACTION;
3422: l_rate_break_data('LINE_NUMBER'):= x_linenum;
3423: l_rate_break_data('LOWER_LIMIT'):= 0;
3424: l_rate_break_data('UPPER_LIMIT'):= l_attr_value_to;
3425: l_rate_break_data('RATE') := Fnd_Number.Number_To_Canonical(l_rate);
3426: l_rate_break_data('RATE_TYPE') := l_rate_type;
3427: l_rate_break_data('ATTRIBUTE') := l_attr2_type;
3428: l_rate_break_data('TYPE') := l_type;
3429: l_rate_break_data('SUBTYPE') := l_subtype2;

Line 3452: l_attr_value_from := Fnd_Number.Canonical_To_Number(l_attr_value_to);

3448:
3449: -- Break 2
3450: IF (l_min_break) THEN
3451: x_linenum := x_linenum + 1;
3452: l_attr_value_from := Fnd_Number.Canonical_To_Number(l_attr_value_to);
3453: l_attr_value_to := g_max_number;
3454: l_rate := p_charge;
3455: l_rate_type := 'BLOCK_UNIT';
3456:

Line 3459: l_rate_break_data('LOWER_LIMIT'):= Fnd_Number.Number_To_Canonical(l_attr_value_from);

3455: l_rate_type := 'BLOCK_UNIT';
3456:
3457: l_rate_break_data('ACTION') := G_ACTION;
3458: l_rate_break_data('LINE_NUMBER'):= x_linenum;
3459: l_rate_break_data('LOWER_LIMIT'):= Fnd_Number.Number_To_Canonical(l_attr_value_from);
3460: l_rate_break_data('UPPER_LIMIT'):= Fnd_Number.Number_To_Canonical(l_attr_value_to);
3461: l_rate_break_data('RATE') := Fnd_Number.Number_To_Canonical(l_rate);
3462: l_rate_break_data('RATE_TYPE') := l_rate_type;
3463: l_rate_break_data('ATTRIBUTE') := l_attr2_type;

Line 3460: l_rate_break_data('UPPER_LIMIT'):= Fnd_Number.Number_To_Canonical(l_attr_value_to);

3456:
3457: l_rate_break_data('ACTION') := G_ACTION;
3458: l_rate_break_data('LINE_NUMBER'):= x_linenum;
3459: l_rate_break_data('LOWER_LIMIT'):= Fnd_Number.Number_To_Canonical(l_attr_value_from);
3460: l_rate_break_data('UPPER_LIMIT'):= Fnd_Number.Number_To_Canonical(l_attr_value_to);
3461: l_rate_break_data('RATE') := Fnd_Number.Number_To_Canonical(l_rate);
3462: l_rate_break_data('RATE_TYPE') := l_rate_type;
3463: l_rate_break_data('ATTRIBUTE') := l_attr2_type;
3464: l_rate_break_data('TYPE') := l_type;

Line 3461: l_rate_break_data('RATE') := Fnd_Number.Number_To_Canonical(l_rate);

3457: l_rate_break_data('ACTION') := G_ACTION;
3458: l_rate_break_data('LINE_NUMBER'):= x_linenum;
3459: l_rate_break_data('LOWER_LIMIT'):= Fnd_Number.Number_To_Canonical(l_attr_value_from);
3460: l_rate_break_data('UPPER_LIMIT'):= Fnd_Number.Number_To_Canonical(l_attr_value_to);
3461: l_rate_break_data('RATE') := Fnd_Number.Number_To_Canonical(l_rate);
3462: l_rate_break_data('RATE_TYPE') := l_rate_type;
3463: l_rate_break_data('ATTRIBUTE') := l_attr2_type;
3464: l_rate_break_data('TYPE') := l_type;
3465: l_rate_break_data('SUBTYPE') := l_subtype;

Line 3782: l_stop_chg_1 := Fnd_Number.Canonical_To_Number(l_stop_chg_1);

3778:
3779: l_rate_basis := UPPER(l_rate_basis);
3780:
3781: BEGIN
3782: l_stop_chg_1 := Fnd_Number.Canonical_To_Number(l_stop_chg_1);
3783: l_stop_chg_2 := Fnd_Number.Canonical_To_Number(l_stop_chg_2);
3784: l_stop_chg_3 := Fnd_Number.Canonical_To_Number(l_stop_chg_3);
3785: l_stop_chg_4 := Fnd_Number.Canonical_To_Number(l_stop_chg_4);
3786: l_stop_chg_5 := Fnd_Number.Canonical_To_Number(l_stop_chg_5);

Line 3783: l_stop_chg_2 := Fnd_Number.Canonical_To_Number(l_stop_chg_2);

3779: l_rate_basis := UPPER(l_rate_basis);
3780:
3781: BEGIN
3782: l_stop_chg_1 := Fnd_Number.Canonical_To_Number(l_stop_chg_1);
3783: l_stop_chg_2 := Fnd_Number.Canonical_To_Number(l_stop_chg_2);
3784: l_stop_chg_3 := Fnd_Number.Canonical_To_Number(l_stop_chg_3);
3785: l_stop_chg_4 := Fnd_Number.Canonical_To_Number(l_stop_chg_4);
3786: l_stop_chg_5 := Fnd_Number.Canonical_To_Number(l_stop_chg_5);
3787: l_stop_chg_x := Fnd_Number.Canonical_To_Number(l_stop_chg_x);

Line 3784: l_stop_chg_3 := Fnd_Number.Canonical_To_Number(l_stop_chg_3);

3780:
3781: BEGIN
3782: l_stop_chg_1 := Fnd_Number.Canonical_To_Number(l_stop_chg_1);
3783: l_stop_chg_2 := Fnd_Number.Canonical_To_Number(l_stop_chg_2);
3784: l_stop_chg_3 := Fnd_Number.Canonical_To_Number(l_stop_chg_3);
3785: l_stop_chg_4 := Fnd_Number.Canonical_To_Number(l_stop_chg_4);
3786: l_stop_chg_5 := Fnd_Number.Canonical_To_Number(l_stop_chg_5);
3787: l_stop_chg_x := Fnd_Number.Canonical_To_Number(l_stop_chg_x);
3788: l_out_rt_chg := Fnd_Number.Canonical_To_Number(l_out_rt_chg);

Line 3785: l_stop_chg_4 := Fnd_Number.Canonical_To_Number(l_stop_chg_4);

3781: BEGIN
3782: l_stop_chg_1 := Fnd_Number.Canonical_To_Number(l_stop_chg_1);
3783: l_stop_chg_2 := Fnd_Number.Canonical_To_Number(l_stop_chg_2);
3784: l_stop_chg_3 := Fnd_Number.Canonical_To_Number(l_stop_chg_3);
3785: l_stop_chg_4 := Fnd_Number.Canonical_To_Number(l_stop_chg_4);
3786: l_stop_chg_5 := Fnd_Number.Canonical_To_Number(l_stop_chg_5);
3787: l_stop_chg_x := Fnd_Number.Canonical_To_Number(l_stop_chg_x);
3788: l_out_rt_chg := Fnd_Number.Canonical_To_Number(l_out_rt_chg);
3789: l_handling_chg := Fnd_Number.Canonical_To_Number(l_handling_chg);

Line 3786: l_stop_chg_5 := Fnd_Number.Canonical_To_Number(l_stop_chg_5);

3782: l_stop_chg_1 := Fnd_Number.Canonical_To_Number(l_stop_chg_1);
3783: l_stop_chg_2 := Fnd_Number.Canonical_To_Number(l_stop_chg_2);
3784: l_stop_chg_3 := Fnd_Number.Canonical_To_Number(l_stop_chg_3);
3785: l_stop_chg_4 := Fnd_Number.Canonical_To_Number(l_stop_chg_4);
3786: l_stop_chg_5 := Fnd_Number.Canonical_To_Number(l_stop_chg_5);
3787: l_stop_chg_x := Fnd_Number.Canonical_To_Number(l_stop_chg_x);
3788: l_out_rt_chg := Fnd_Number.Canonical_To_Number(l_out_rt_chg);
3789: l_handling_chg := Fnd_Number.Canonical_To_Number(l_handling_chg);
3790: l_min_handling_chg := Fnd_Number.Canonical_To_Number(l_min_handling_chg);

Line 3787: l_stop_chg_x := Fnd_Number.Canonical_To_Number(l_stop_chg_x);

3783: l_stop_chg_2 := Fnd_Number.Canonical_To_Number(l_stop_chg_2);
3784: l_stop_chg_3 := Fnd_Number.Canonical_To_Number(l_stop_chg_3);
3785: l_stop_chg_4 := Fnd_Number.Canonical_To_Number(l_stop_chg_4);
3786: l_stop_chg_5 := Fnd_Number.Canonical_To_Number(l_stop_chg_5);
3787: l_stop_chg_x := Fnd_Number.Canonical_To_Number(l_stop_chg_x);
3788: l_out_rt_chg := Fnd_Number.Canonical_To_Number(l_out_rt_chg);
3789: l_handling_chg := Fnd_Number.Canonical_To_Number(l_handling_chg);
3790: l_min_handling_chg := Fnd_Number.Canonical_To_Number(l_min_handling_chg);
3791: l_ld_chg := Fnd_Number.Canonical_To_Number(l_ld_chg);

Line 3788: l_out_rt_chg := Fnd_Number.Canonical_To_Number(l_out_rt_chg);

3784: l_stop_chg_3 := Fnd_Number.Canonical_To_Number(l_stop_chg_3);
3785: l_stop_chg_4 := Fnd_Number.Canonical_To_Number(l_stop_chg_4);
3786: l_stop_chg_5 := Fnd_Number.Canonical_To_Number(l_stop_chg_5);
3787: l_stop_chg_x := Fnd_Number.Canonical_To_Number(l_stop_chg_x);
3788: l_out_rt_chg := Fnd_Number.Canonical_To_Number(l_out_rt_chg);
3789: l_handling_chg := Fnd_Number.Canonical_To_Number(l_handling_chg);
3790: l_min_handling_chg := Fnd_Number.Canonical_To_Number(l_min_handling_chg);
3791: l_ld_chg := Fnd_Number.Canonical_To_Number(l_ld_chg);
3792: l_min_ld_chg := Fnd_Number.Canonical_To_Number(l_min_ld_chg);

Line 3789: l_handling_chg := Fnd_Number.Canonical_To_Number(l_handling_chg);

3785: l_stop_chg_4 := Fnd_Number.Canonical_To_Number(l_stop_chg_4);
3786: l_stop_chg_5 := Fnd_Number.Canonical_To_Number(l_stop_chg_5);
3787: l_stop_chg_x := Fnd_Number.Canonical_To_Number(l_stop_chg_x);
3788: l_out_rt_chg := Fnd_Number.Canonical_To_Number(l_out_rt_chg);
3789: l_handling_chg := Fnd_Number.Canonical_To_Number(l_handling_chg);
3790: l_min_handling_chg := Fnd_Number.Canonical_To_Number(l_min_handling_chg);
3791: l_ld_chg := Fnd_Number.Canonical_To_Number(l_ld_chg);
3792: l_min_ld_chg := Fnd_Number.Canonical_To_Number(l_min_ld_chg);
3793: l_unld_chg := Fnd_Number.Canonical_To_Number(l_unld_chg);

Line 3790: l_min_handling_chg := Fnd_Number.Canonical_To_Number(l_min_handling_chg);

3786: l_stop_chg_5 := Fnd_Number.Canonical_To_Number(l_stop_chg_5);
3787: l_stop_chg_x := Fnd_Number.Canonical_To_Number(l_stop_chg_x);
3788: l_out_rt_chg := Fnd_Number.Canonical_To_Number(l_out_rt_chg);
3789: l_handling_chg := Fnd_Number.Canonical_To_Number(l_handling_chg);
3790: l_min_handling_chg := Fnd_Number.Canonical_To_Number(l_min_handling_chg);
3791: l_ld_chg := Fnd_Number.Canonical_To_Number(l_ld_chg);
3792: l_min_ld_chg := Fnd_Number.Canonical_To_Number(l_min_ld_chg);
3793: l_unld_chg := Fnd_Number.Canonical_To_Number(l_unld_chg);
3794: l_min_unld_chg := Fnd_Number.Canonical_To_Number(l_min_unld_chg);

Line 3791: l_ld_chg := Fnd_Number.Canonical_To_Number(l_ld_chg);

3787: l_stop_chg_x := Fnd_Number.Canonical_To_Number(l_stop_chg_x);
3788: l_out_rt_chg := Fnd_Number.Canonical_To_Number(l_out_rt_chg);
3789: l_handling_chg := Fnd_Number.Canonical_To_Number(l_handling_chg);
3790: l_min_handling_chg := Fnd_Number.Canonical_To_Number(l_min_handling_chg);
3791: l_ld_chg := Fnd_Number.Canonical_To_Number(l_ld_chg);
3792: l_min_ld_chg := Fnd_Number.Canonical_To_Number(l_min_ld_chg);
3793: l_unld_chg := Fnd_Number.Canonical_To_Number(l_unld_chg);
3794: l_min_unld_chg := Fnd_Number.Canonical_To_Number(l_min_unld_chg);
3795: l_asst_unld_chg := Fnd_Number.Canonical_To_Number(l_asst_unld_chg);

Line 3792: l_min_ld_chg := Fnd_Number.Canonical_To_Number(l_min_ld_chg);

3788: l_out_rt_chg := Fnd_Number.Canonical_To_Number(l_out_rt_chg);
3789: l_handling_chg := Fnd_Number.Canonical_To_Number(l_handling_chg);
3790: l_min_handling_chg := Fnd_Number.Canonical_To_Number(l_min_handling_chg);
3791: l_ld_chg := Fnd_Number.Canonical_To_Number(l_ld_chg);
3792: l_min_ld_chg := Fnd_Number.Canonical_To_Number(l_min_ld_chg);
3793: l_unld_chg := Fnd_Number.Canonical_To_Number(l_unld_chg);
3794: l_min_unld_chg := Fnd_Number.Canonical_To_Number(l_min_unld_chg);
3795: l_asst_unld_chg := Fnd_Number.Canonical_To_Number(l_asst_unld_chg);
3796: l_min_asst_unld_chg := Fnd_Number.Canonical_To_Number(l_min_asst_unld_chg);

Line 3793: l_unld_chg := Fnd_Number.Canonical_To_Number(l_unld_chg);

3789: l_handling_chg := Fnd_Number.Canonical_To_Number(l_handling_chg);
3790: l_min_handling_chg := Fnd_Number.Canonical_To_Number(l_min_handling_chg);
3791: l_ld_chg := Fnd_Number.Canonical_To_Number(l_ld_chg);
3792: l_min_ld_chg := Fnd_Number.Canonical_To_Number(l_min_ld_chg);
3793: l_unld_chg := Fnd_Number.Canonical_To_Number(l_unld_chg);
3794: l_min_unld_chg := Fnd_Number.Canonical_To_Number(l_min_unld_chg);
3795: l_asst_unld_chg := Fnd_Number.Canonical_To_Number(l_asst_unld_chg);
3796: l_min_asst_unld_chg := Fnd_Number.Canonical_To_Number(l_min_asst_unld_chg);
3797: l_asst_ld_chg := Fnd_Number.Canonical_To_Number(l_asst_ld_chg);

Line 3794: l_min_unld_chg := Fnd_Number.Canonical_To_Number(l_min_unld_chg);

3790: l_min_handling_chg := Fnd_Number.Canonical_To_Number(l_min_handling_chg);
3791: l_ld_chg := Fnd_Number.Canonical_To_Number(l_ld_chg);
3792: l_min_ld_chg := Fnd_Number.Canonical_To_Number(l_min_ld_chg);
3793: l_unld_chg := Fnd_Number.Canonical_To_Number(l_unld_chg);
3794: l_min_unld_chg := Fnd_Number.Canonical_To_Number(l_min_unld_chg);
3795: l_asst_unld_chg := Fnd_Number.Canonical_To_Number(l_asst_unld_chg);
3796: l_min_asst_unld_chg := Fnd_Number.Canonical_To_Number(l_min_asst_unld_chg);
3797: l_asst_ld_chg := Fnd_Number.Canonical_To_Number(l_asst_ld_chg);
3798: l_min_asst_ld_chg := Fnd_Number.Canonical_To_Number(l_min_asst_ld_chg);

Line 3795: l_asst_unld_chg := Fnd_Number.Canonical_To_Number(l_asst_unld_chg);

3791: l_ld_chg := Fnd_Number.Canonical_To_Number(l_ld_chg);
3792: l_min_ld_chg := Fnd_Number.Canonical_To_Number(l_min_ld_chg);
3793: l_unld_chg := Fnd_Number.Canonical_To_Number(l_unld_chg);
3794: l_min_unld_chg := Fnd_Number.Canonical_To_Number(l_min_unld_chg);
3795: l_asst_unld_chg := Fnd_Number.Canonical_To_Number(l_asst_unld_chg);
3796: l_min_asst_unld_chg := Fnd_Number.Canonical_To_Number(l_min_asst_unld_chg);
3797: l_asst_ld_chg := Fnd_Number.Canonical_To_Number(l_asst_ld_chg);
3798: l_min_asst_ld_chg := Fnd_Number.Canonical_To_Number(l_min_asst_ld_chg);
3799: l_cont_mv_dsct_prcnt:= Fnd_Number.Canonical_To_Number(l_cont_mv_dsct_prcnt);

Line 3796: l_min_asst_unld_chg := Fnd_Number.Canonical_To_Number(l_min_asst_unld_chg);

3792: l_min_ld_chg := Fnd_Number.Canonical_To_Number(l_min_ld_chg);
3793: l_unld_chg := Fnd_Number.Canonical_To_Number(l_unld_chg);
3794: l_min_unld_chg := Fnd_Number.Canonical_To_Number(l_min_unld_chg);
3795: l_asst_unld_chg := Fnd_Number.Canonical_To_Number(l_asst_unld_chg);
3796: l_min_asst_unld_chg := Fnd_Number.Canonical_To_Number(l_min_asst_unld_chg);
3797: l_asst_ld_chg := Fnd_Number.Canonical_To_Number(l_asst_ld_chg);
3798: l_min_asst_ld_chg := Fnd_Number.Canonical_To_Number(l_min_asst_ld_chg);
3799: l_cont_mv_dsct_prcnt:= Fnd_Number.Canonical_To_Number(l_cont_mv_dsct_prcnt);
3800: l_wkday_layovr_chg := Fnd_Number.Canonical_To_Number(l_wkday_layovr_chg);

Line 3797: l_asst_ld_chg := Fnd_Number.Canonical_To_Number(l_asst_ld_chg);

3793: l_unld_chg := Fnd_Number.Canonical_To_Number(l_unld_chg);
3794: l_min_unld_chg := Fnd_Number.Canonical_To_Number(l_min_unld_chg);
3795: l_asst_unld_chg := Fnd_Number.Canonical_To_Number(l_asst_unld_chg);
3796: l_min_asst_unld_chg := Fnd_Number.Canonical_To_Number(l_min_asst_unld_chg);
3797: l_asst_ld_chg := Fnd_Number.Canonical_To_Number(l_asst_ld_chg);
3798: l_min_asst_ld_chg := Fnd_Number.Canonical_To_Number(l_min_asst_ld_chg);
3799: l_cont_mv_dsct_prcnt:= Fnd_Number.Canonical_To_Number(l_cont_mv_dsct_prcnt);
3800: l_wkday_layovr_chg := Fnd_Number.Canonical_To_Number(l_wkday_layovr_chg);
3801: EXCEPTION

Line 3798: l_min_asst_ld_chg := Fnd_Number.Canonical_To_Number(l_min_asst_ld_chg);

3794: l_min_unld_chg := Fnd_Number.Canonical_To_Number(l_min_unld_chg);
3795: l_asst_unld_chg := Fnd_Number.Canonical_To_Number(l_asst_unld_chg);
3796: l_min_asst_unld_chg := Fnd_Number.Canonical_To_Number(l_min_asst_unld_chg);
3797: l_asst_ld_chg := Fnd_Number.Canonical_To_Number(l_asst_ld_chg);
3798: l_min_asst_ld_chg := Fnd_Number.Canonical_To_Number(l_min_asst_ld_chg);
3799: l_cont_mv_dsct_prcnt:= Fnd_Number.Canonical_To_Number(l_cont_mv_dsct_prcnt);
3800: l_wkday_layovr_chg := Fnd_Number.Canonical_To_Number(l_wkday_layovr_chg);
3801: EXCEPTION
3802: WHEN OTHERS THEN

Line 3799: l_cont_mv_dsct_prcnt:= Fnd_Number.Canonical_To_Number(l_cont_mv_dsct_prcnt);

3795: l_asst_unld_chg := Fnd_Number.Canonical_To_Number(l_asst_unld_chg);
3796: l_min_asst_unld_chg := Fnd_Number.Canonical_To_Number(l_min_asst_unld_chg);
3797: l_asst_ld_chg := Fnd_Number.Canonical_To_Number(l_asst_ld_chg);
3798: l_min_asst_ld_chg := Fnd_Number.Canonical_To_Number(l_min_asst_ld_chg);
3799: l_cont_mv_dsct_prcnt:= Fnd_Number.Canonical_To_Number(l_cont_mv_dsct_prcnt);
3800: l_wkday_layovr_chg := Fnd_Number.Canonical_To_Number(l_wkday_layovr_chg);
3801: EXCEPTION
3802: WHEN OTHERS THEN
3803: x_status := 2;

Line 3800: l_wkday_layovr_chg := Fnd_Number.Canonical_To_Number(l_wkday_layovr_chg);

3796: l_min_asst_unld_chg := Fnd_Number.Canonical_To_Number(l_min_asst_unld_chg);
3797: l_asst_ld_chg := Fnd_Number.Canonical_To_Number(l_asst_ld_chg);
3798: l_min_asst_ld_chg := Fnd_Number.Canonical_To_Number(l_min_asst_ld_chg);
3799: l_cont_mv_dsct_prcnt:= Fnd_Number.Canonical_To_Number(l_cont_mv_dsct_prcnt);
3800: l_wkday_layovr_chg := Fnd_Number.Canonical_To_Number(l_wkday_layovr_chg);
3801: EXCEPTION
3802: WHEN OTHERS THEN
3803: x_status := 2;
3804: FTE_UTIL_PKG.Write_LogFile(l_module_name,'Unexcepted Error ', sqlerrm);

Line 4037: l_rate_line_data('PERCENTAGE') := Fnd_Number.Number_To_Canonical(l_cont_mv_dsct_prcnt);

4033: l_rate_line_data('UOM') := g_unit_uom;
4034: l_rate_line_data('VOLUME_TYPE') := 'TOTAL_QUANTITY';
4035: l_rate_line_data('TYPE') := l_type;
4036: l_rate_line_data('SUBTYPE') := l_subtype;
4037: l_rate_line_data('PERCENTAGE') := Fnd_Number.Number_To_Canonical(l_cont_mv_dsct_prcnt);
4038:
4039: l_rate_line_block_tbl(1) := l_rate_line_data;
4040:
4041: FTE_RATE_CHART_LOADER.PROCESS_RATE_LINE(p_block_header => g_dummy_block_hdr_tbl,

Line 5056: l_wkend_layovr_dist_brk := Fnd_Number.Canonical_To_Number(l_wkend_layovr_dist_brk);

5052: l_wkend_layovr_dist_uom := FTE_UTIL_PKG.GET_DATA('DISTANCE_UOM_FOR_WEEKEND_LAYOVER_CHARGES', l_values);
5053: l_wkend_layovr_dist_brk := FTE_UTIL_PKG.GET_DATA('WEEKEND_LAYOVER_DISTANCE_BREAK', l_values);
5054: l_rate := FTE_UTIL_PKG.GET_DATA('CHARGES', l_values);
5055:
5056: l_wkend_layovr_dist_brk := Fnd_Number.Canonical_To_Number(l_wkend_layovr_dist_brk);
5057: l_rate := Fnd_Number.Canonical_To_Number(l_rate);
5058:
5059: IF (l_rate < 0) THEN
5060: x_status := 2;

Line 5057: l_rate := Fnd_Number.Canonical_To_Number(l_rate);

5053: l_wkend_layovr_dist_brk := FTE_UTIL_PKG.GET_DATA('WEEKEND_LAYOVER_DISTANCE_BREAK', l_values);
5054: l_rate := FTE_UTIL_PKG.GET_DATA('CHARGES', l_values);
5055:
5056: l_wkend_layovr_dist_brk := Fnd_Number.Canonical_To_Number(l_wkend_layovr_dist_brk);
5057: l_rate := Fnd_Number.Canonical_To_Number(l_rate);
5058:
5059: IF (l_rate < 0) THEN
5060: x_status := 2;
5061: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_VALUE_ERROR',

Line 5126: g_layovr_breaks(g_layovr_breaks.COUNT) := Fnd_Number.Number_To_Canonical(l_wkend_layovr_dist_brk);

5122: ELSE
5123: g_wknd_layovr_uom := l_wkend_layovr_dist_uom;
5124: g_layovr_breaks.EXTEND;
5125: g_layovr_charges.EXTEND;
5126: g_layovr_breaks(g_layovr_breaks.COUNT) := Fnd_Number.Number_To_Canonical(l_wkend_layovr_dist_brk);
5127: g_layovr_charges(g_layovr_charges.COUNT) := Fnd_Number.Number_To_Canonical(l_rate);
5128: END IF;
5129:
5130: ELSIF (l_type IN ('O', 'D', 'F')) THEN

Line 5127: g_layovr_charges(g_layovr_charges.COUNT) := Fnd_Number.Number_To_Canonical(l_rate);

5123: g_wknd_layovr_uom := l_wkend_layovr_dist_uom;
5124: g_layovr_breaks.EXTEND;
5125: g_layovr_charges.EXTEND;
5126: g_layovr_breaks(g_layovr_breaks.COUNT) := Fnd_Number.Number_To_Canonical(l_wkend_layovr_dist_brk);
5127: g_layovr_charges(g_layovr_charges.COUNT) := Fnd_Number.Number_To_Canonical(l_rate);
5128: END IF;
5129:
5130: ELSIF (l_type IN ('O', 'D', 'F')) THEN
5131:

Line 5132: l_rate := Fnd_Number.Canonical_To_Number(FTE_UTIL_PKG.GET_DATA('SURCHARGES', l_values));

5128: END IF;
5129:
5130: ELSIF (l_type IN ('O', 'D', 'F')) THEN
5131:
5132: l_rate := Fnd_Number.Canonical_To_Number(FTE_UTIL_PKG.GET_DATA('SURCHARGES', l_values));
5133:
5134: IF (l_rate < 0) THEN
5135: x_status := 2;
5136: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_VALUE_ERROR',

Line 5520: l_rate := Fnd_Number.Canonical_To_Number(l_rate);

5516:
5517: G_ACTION := UPPER(G_ACTION);
5518: l_dist_type := UPPER(l_dist_type);
5519: l_rate_basis := UPPER(l_rate_basis);
5520: l_rate := Fnd_Number.Canonical_To_Number(l_rate);
5521: l_min_charge := Fnd_Number.Canonical_To_Number(l_min_charge);
5522:
5523: IF (p_doValidate) THEN
5524:

Line 5521: l_min_charge := Fnd_Number.Canonical_To_Number(l_min_charge);

5517: G_ACTION := UPPER(G_ACTION);
5518: l_dist_type := UPPER(l_dist_type);
5519: l_rate_basis := UPPER(l_rate_basis);
5520: l_rate := Fnd_Number.Canonical_To_Number(l_rate);
5521: l_min_charge := Fnd_Number.Canonical_To_Number(l_min_charge);
5522:
5523: IF (p_doValidate) THEN
5524:
5525: FTE_VALIDATION_PKG.VALIDATE_ACTION(p_action => G_ACTION,

Line 6098: l_rate_line_data('RATE') := Fnd_Number.Number_To_Canonical(l_rate);

6094:
6095: l_rate_line_data('ACTION') := G_ACTION;
6096: l_rate_line_data('LINE_NUMBER') := l_linenum;
6097: l_rate_line_data('DESCRIPTION') := l_description;
6098: l_rate_line_data('RATE') := Fnd_Number.Number_To_Canonical(l_rate);
6099: l_rate_line_data('UOM') := l_rate_basis_uom;
6100: l_rate_line_data('VOLUME_TYPE') := 'TOTAL_QUANTITY';
6101: l_rate_line_data('ATTRIBUTE1') := l_attribute;
6102: l_rate_line_data('PRECEDENCE') := l_precedence;

Line 6237: l_rate_line_data('RATE') := Fnd_Number.Number_To_Canonical(l_rate);

6233:
6234: l_rate_line_data('ACTION') := G_ACTION;
6235: l_rate_line_data('LINE_NUMBER') := l_linenum;
6236: l_rate_line_data('DESCRIPTION') := l_description;
6237: l_rate_line_data('RATE') := Fnd_Number.Number_To_Canonical(l_rate);
6238: l_rate_line_data('UOM') := l_rate_basis_uom;
6239: l_rate_line_data('VOLUME_TYPE') := 'TOTAL_QUANTITY';
6240: l_rate_line_data('ATTRIBUTE1') := l_attribute;
6241: l_rate_line_data('PRECEDENCE') := l_precedence;