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 STRINGARRAY

Line 186: p_tokens => STRINGARRAY('NAME'),

182: EXCEPTION
183: WHEN NO_DATA_FOUND THEN
184: x_status := 2;
185: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_SEL_INVALID_CARRIER',
186: p_tokens => STRINGARRAY('NAME'),
187: p_values => STRINGARRAY(p_carrier_name));
188:
189: FTE_UTIL_PKG.Write_OutFile(p_msg => x_error_msg,
190: p_module_name => l_module_name,

Line 187: p_values => STRINGARRAY(p_carrier_name));

183: WHEN NO_DATA_FOUND THEN
184: x_status := 2;
185: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_SEL_INVALID_CARRIER',
186: p_tokens => STRINGARRAY('NAME'),
187: p_values => STRINGARRAY(p_carrier_name));
188:
189: FTE_UTIL_PKG.Write_OutFile(p_msg => x_error_msg,
190: p_module_name => l_module_name,
191: p_category => 'D',

Line 209: p_tokens => STRINGARRAY('CARRIER'),

205: --+
206: IF (g_carrier_unit_basis IS NULL) THEN
207: x_status := 2;
208: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CARRIER_RATE_BASIS_NOT_SET',
209: p_tokens => STRINGARRAY('CARRIER'),
210: p_values => STRINGARRAY(p_carrier_name));
211: FTE_UTIL_PKG.Write_OutFile( p_msg => x_error_msg,
212: p_module_name => l_module_name,
213: p_category => 'B',

Line 210: p_values => STRINGARRAY(p_carrier_name));

206: IF (g_carrier_unit_basis IS NULL) THEN
207: x_status := 2;
208: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CARRIER_RATE_BASIS_NOT_SET',
209: p_tokens => STRINGARRAY('CARRIER'),
210: p_values => STRINGARRAY(p_carrier_name));
211: FTE_UTIL_PKG.Write_OutFile( p_msg => x_error_msg,
212: p_module_name => l_module_name,
213: p_category => 'B',
214: p_line_number => p_line_number);

Line 328: p_tokens => STRINGARRAY('RATE_BASIS','CARRIER'),

324: IF (p_rate_basis <> g_carrier_unit_basis) THEN
325:
326: x_status := 2;
327: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_RATE_BASIS_NO_MATCH',
328: p_tokens => STRINGARRAY('RATE_BASIS','CARRIER'),
329: p_values => STRINGARRAY(p_rate_basis,p_carrier_name));
330: FTE_UTIL_PKG.Write_OutFile( p_msg => x_error_msg,
331: p_module_name => l_module_name,
332: p_category => 'D',

Line 329: p_values => STRINGARRAY(p_rate_basis,p_carrier_name));

325:
326: x_status := 2;
327: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_RATE_BASIS_NO_MATCH',
328: p_tokens => STRINGARRAY('RATE_BASIS','CARRIER'),
329: p_values => STRINGARRAY(p_rate_basis,p_carrier_name));
330: FTE_UTIL_PKG.Write_OutFile( p_msg => x_error_msg,
331: p_module_name => l_module_name,
332: p_category => 'D',
333: p_line_number => p_line_number);

Line 358: p_tokens => STRINGARRAY('RATE_BASIS_UOM','CARRIER'),

354: -- The rate basis uom did not match that of the carrier
355: --+
356: IF (x_status = 3) THEN
357: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_RATE_BASIS_UOM_NO_MATCH',
358: p_tokens => STRINGARRAY('RATE_BASIS_UOM','CARRIER'),
359: p_values => STRINGARRAY(p_rate_basis_uom,p_carrier_name));
360: FTE_UTIL_PKG.Write_OutFile( p_msg => x_error_msg,
361: p_module_name => l_module_name,
362: p_category => 'D',

Line 359: p_values => STRINGARRAY(p_rate_basis_uom,p_carrier_name));

355: --+
356: IF (x_status = 3) THEN
357: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_RATE_BASIS_UOM_NO_MATCH',
358: p_tokens => STRINGARRAY('RATE_BASIS_UOM','CARRIER'),
359: p_values => STRINGARRAY(p_rate_basis_uom,p_carrier_name));
360: FTE_UTIL_PKG.Write_OutFile( p_msg => x_error_msg,
361: p_module_name => l_module_name,
362: p_category => 'D',
363: p_line_number => p_line_number);

Line 651: l_lane_numbers STRINGARRAY;

647: RETURN BOOLEAN IS
648:
649: l_lane_loaded BOOLEAN := true;
650: l_name VARCHAR2(50);
651: l_lane_numbers STRINGARRAY;
652: l_lane_services STRINGARRAY;
653: l_carrier_ids NUMBER_TAB;
654:
655: l_num_of_lanes NUMBER;

Line 652: l_lane_services STRINGARRAY;

648:
649: l_lane_loaded BOOLEAN := true;
650: l_name VARCHAR2(50);
651: l_lane_numbers STRINGARRAY;
652: l_lane_services STRINGARRAY;
653: l_carrier_ids NUMBER_TAB;
654:
655: l_num_of_lanes NUMBER;
656:

Line 720: p_tokens => STRINGARRAY('CARRIER','RATE_CHART','SERVICE'),

716: IF (g_carrier_id <> l_carrier_ids(i)) THEN
717: x_status := 2;
718: l_lane_loaded := false;
719: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_CARRIER_LANE_MISMATCH',
720: p_tokens => STRINGARRAY('CARRIER','RATE_CHART','SERVICE'),
721: p_values => STRINGARRAY(p_carrier_name,p_chart_name,l_lane_numbers(i)));
722: FTE_UTIL_PKG.Write_OutFile( p_msg => x_error_msg,
723: p_module_name => l_module_name,
724: p_category => 'D',

Line 721: p_values => STRINGARRAY(p_carrier_name,p_chart_name,l_lane_numbers(i)));

717: x_status := 2;
718: l_lane_loaded := false;
719: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_CARRIER_LANE_MISMATCH',
720: p_tokens => STRINGARRAY('CARRIER','RATE_CHART','SERVICE'),
721: p_values => STRINGARRAY(p_carrier_name,p_chart_name,l_lane_numbers(i)));
722: FTE_UTIL_PKG.Write_OutFile( p_msg => x_error_msg,
723: p_module_name => l_module_name,
724: p_category => 'D',
725: p_line_number => p_line_number);

Line 731: p_tokens => STRINGARRAY('RATE_CHART','SERVICE'),

727: ELSIF (p_service_level <> l_lane_services(i)) THEN
728: x_status := 2;
729: l_lane_loaded := false;
730: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_SERV_LEVEL_LANE_MISMATCH',
731: p_tokens => STRINGARRAY('RATE_CHART','SERVICE'),
732: p_values => STRINGARRAY(p_chart_name,l_lane_numbers(i)));
733: FTE_UTIL_PKG.Write_OutFile( p_msg => x_error_msg,
734: p_module_name => l_module_name,
735: p_category => 'D',

Line 732: p_values => STRINGARRAY(p_chart_name,l_lane_numbers(i)));

728: x_status := 2;
729: l_lane_loaded := false;
730: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_SERV_LEVEL_LANE_MISMATCH',
731: p_tokens => STRINGARRAY('RATE_CHART','SERVICE'),
732: p_values => STRINGARRAY(p_chart_name,l_lane_numbers(i)));
733: FTE_UTIL_PKG.Write_OutFile( p_msg => x_error_msg,
734: p_module_name => l_module_name,
735: p_category => 'D',
736: p_line_number => p_line_number);

Line 1138: g_layovr_charges := STRINGARRAY();

1134: --_________________________________________________________________________________--
1135:
1136: PROCEDURE RESET_CHART_INFO IS
1137: BEGIN
1138: g_layovr_charges := STRINGARRAY();
1139: g_layovr_breaks := STRINGARRAY();
1140: g_chart_name := NULL;
1141: g_wknd_layovr_uom := NULL;
1142: EXCEPTION

Line 1139: g_layovr_breaks := STRINGARRAY();

1135:
1136: PROCEDURE RESET_CHART_INFO IS
1137: BEGIN
1138: g_layovr_charges := STRINGARRAY();
1139: g_layovr_breaks := STRINGARRAY();
1140: g_chart_name := NULL;
1141: g_wknd_layovr_uom := NULL;
1142: EXCEPTION
1143: WHEN OTHERS THEN

Line 1176: PROCEDURE CREATE_BREAKS(p_break_charges IN STRINGARRAY,

1172: -- x_error_msg, the corresponding error meassge, --
1173: -- if any exception occurs during the process. --
1174: --_________________________________________________________________________________--
1175:
1176: PROCEDURE CREATE_BREAKS(p_break_charges IN STRINGARRAY,
1177: p_break_limits IN STRINGARRAY,
1178: p_break_start IN NUMBER,
1179: p_break_gap IN NUMBER,
1180: p_rate_type IN VARCHAR2,

Line 1177: p_break_limits IN STRINGARRAY,

1173: -- if any exception occurs during the process. --
1174: --_________________________________________________________________________________--
1175:
1176: PROCEDURE CREATE_BREAKS(p_break_charges IN STRINGARRAY,
1177: p_break_limits IN STRINGARRAY,
1178: p_break_start IN NUMBER,
1179: p_break_gap IN NUMBER,
1180: p_rate_type IN VARCHAR2,
1181: p_attribute_type IN VARCHAR2,

Line 1314: l_charge_info STRINGARRAY;

1310: l_subtype VARCHAR2(30);
1311: l_uom VARCHAR2(30);
1312: l_count NUMBER;
1313: l_chart_type VARCHAR2(30);
1314: l_charge_info STRINGARRAY;
1315: l_formula_id NUMBER;
1316: l_carrier_name VARCHAR2(100);
1317:
1318: l_rate_hdr_data FTE_BULKLOAD_PKG.data_values_tbl;

Line 1636: p_tokens => STRINGARRAY('BASIS','VEHICLE'),

1632: --+
1633: IF (INSTR(l_charge_str, l_str) > 0) THEN
1634: IF (p_basis <> 'DISTANCE') THEN
1635: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_DUPLICATE_BASIS_LINE',
1636: p_tokens => STRINGARRAY('BASIS','VEHICLE'),
1637: p_values => STRINGARRAY(p_basis,p_vehicle));
1638: FTE_UTIL_PKG.Write_OutFile(p_msg => x_error_msg,
1639: p_module_name => l_module_name,
1640: p_category => 'D',

Line 1637: p_values => STRINGARRAY(p_basis,p_vehicle));

1633: IF (INSTR(l_charge_str, l_str) > 0) THEN
1634: IF (p_basis <> 'DISTANCE') THEN
1635: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_DUPLICATE_BASIS_LINE',
1636: p_tokens => STRINGARRAY('BASIS','VEHICLE'),
1637: p_values => STRINGARRAY(p_basis,p_vehicle));
1638: FTE_UTIL_PKG.Write_OutFile(p_msg => x_error_msg,
1639: p_module_name => l_module_name,
1640: p_category => 'D',
1641: p_line_number => p_line_number);

Line 1657: p_tokens => STRINGARRAY('BASIS','VEHICLE'),

1653: --
1654: ELSIF (INSTR(l_charge_str, 'B:'||p_basis||':V:'||p_vehicle||':U:'||p_uom) > 0) THEN
1655: IF (p_basis <> 'DISTANCE') THEN
1656: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_DUPLICATE_BASIS_LINE',
1657: p_tokens => STRINGARRAY('BASIS','VEHICLE'),
1658: p_values => STRINGARRAY(p_basis,p_vehicle));
1659: FTE_UTIL_PKG.Write_OutFile( p_msg => x_error_msg,
1660: p_module_name => l_module_name,
1661: p_category => 'D',

Line 1658: p_values => STRINGARRAY(p_basis,p_vehicle));

1654: ELSIF (INSTR(l_charge_str, 'B:'||p_basis||':V:'||p_vehicle||':U:'||p_uom) > 0) THEN
1655: IF (p_basis <> 'DISTANCE') THEN
1656: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_DUPLICATE_BASIS_LINE',
1657: p_tokens => STRINGARRAY('BASIS','VEHICLE'),
1658: p_values => STRINGARRAY(p_basis,p_vehicle));
1659: FTE_UTIL_PKG.Write_OutFile( p_msg => x_error_msg,
1660: p_module_name => l_module_name,
1661: p_category => 'D',
1662: p_line_number => p_line_number);

Line 1666: p_tokens => STRINGARRAY('BASIS','VEHICLE'),

1662: p_line_number => p_line_number);
1663: x_status := 2;
1664: ELSE
1665: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_MULTIPLE_MIN_CHARGES',
1666: p_tokens => STRINGARRAY('BASIS','VEHICLE'),
1667: p_values => STRINGARRAY(p_basis,p_vehicle));
1668: FTE_UTIL_PKG.Write_OutFile(p_msg => x_error_msg,
1669: p_module_name => l_module_name,
1670: p_category => 'D',

Line 1667: p_values => STRINGARRAY(p_basis,p_vehicle));

1663: x_status := 2;
1664: ELSE
1665: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_MULTIPLE_MIN_CHARGES',
1666: p_tokens => STRINGARRAY('BASIS','VEHICLE'),
1667: p_values => STRINGARRAY(p_basis,p_vehicle));
1668: FTE_UTIL_PKG.Write_OutFile(p_msg => x_error_msg,
1669: p_module_name => l_module_name,
1670: p_category => 'D',
1671: p_line_number => p_line_number);

Line 1685: p_tokens => STRINGARRAY('BASIS','VEHICLE'),

1681: -- similar preceding line (basis, vehicle) with different uom.
1682: --
1683: ELSIF (INSTR(l_charge_str, 'B:' || p_basis || ':V:'||p_vehicle) > 0) THEN
1684: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_MULTIPLE_UOMS',
1685: p_tokens => STRINGARRAY('BASIS','VEHICLE'),
1686: p_values => STRINGARRAY(p_basis,p_vehicle));
1687: FTE_UTIL_PKG.Write_OutFile(p_msg => x_error_msg,
1688: p_module_name => l_module_name,
1689: p_category => 'D',

Line 1686: p_values => STRINGARRAY(p_basis,p_vehicle));

1682: --
1683: ELSIF (INSTR(l_charge_str, 'B:' || p_basis || ':V:'||p_vehicle) > 0) THEN
1684: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_MULTIPLE_UOMS',
1685: p_tokens => STRINGARRAY('BASIS','VEHICLE'),
1686: p_values => STRINGARRAY(p_basis,p_vehicle));
1687: FTE_UTIL_PKG.Write_OutFile(p_msg => x_error_msg,
1688: p_module_name => l_module_name,
1689: p_category => 'D',
1690: p_line_number => p_line_number);

Line 1880: l_prc_param_ids STRINGARRAY;

1876: l_lane_service VARCHAR2(30);
1877:
1878: -- For Facility Modifiers
1879: l_currency VARCHAR2(30);
1880: l_prc_param_ids STRINGARRAY;
1881: l_prc_param_values STRINGARRAY;
1882: l_parameter_id NUMBER;
1883: l_rate_basis VARCHAR2(30);
1884: l_rate_basis_uom VARCHAR2(30);

Line 1881: l_prc_param_values STRINGARRAY;

1877:
1878: -- For Facility Modifiers
1879: l_currency VARCHAR2(30);
1880: l_prc_param_ids STRINGARRAY;
1881: l_prc_param_values STRINGARRAY;
1882: l_parameter_id NUMBER;
1883: l_rate_basis VARCHAR2(30);
1884: l_rate_basis_uom VARCHAR2(30);
1885: l_modifier_id NUMBER;

Line 1981: p_tokens => STRINGARRAY('TYPE'),

1977:
1978: IF (l_linenum_temp = 0 OR x_status <> -1) THEN
1979: x_status := 2;
1980: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_UI_NO_LINES',
1981: p_tokens => STRINGARRAY('TYPE'),
1982: p_values => STRINGARRAY(FTE_UTIL_PKG.GET_MSG('FTE_TL_ACCESSORIALS')));
1983: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1984: p_msg => x_error_msg,
1985: p_category => 'D');

Line 1982: p_values => STRINGARRAY(FTE_UTIL_PKG.GET_MSG('FTE_TL_ACCESSORIALS')));

1978: IF (l_linenum_temp = 0 OR x_status <> -1) THEN
1979: x_status := 2;
1980: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_UI_NO_LINES',
1981: p_tokens => STRINGARRAY('TYPE'),
1982: p_values => STRINGARRAY(FTE_UTIL_PKG.GET_MSG('FTE_TL_ACCESSORIALS')));
1983: FTE_UTIL_PKG.WRITE_OUTFILE(p_module_name => l_module_name,
1984: p_msg => x_error_msg,
1985: p_category => 'D');
1986: FTE_UTIL_PKG.Exit_Debug(l_module_name);

Line 2345: l_prc_param_ids := STRINGARRAY(57, 58, 59, 60);

2341: FTE_UTIL_PKG.Exit_Debug(l_module_name);
2342: RETURN;
2343: END IF;
2344:
2345: l_prc_param_ids := STRINGARRAY(57, 58, 59, 60);
2346: l_prc_param_values := STRINGARRAY(l_rate_basis, l_rate_basis_uom, l_list_header_id, l_currency);
2347:
2348: --+
2349: -- Insert Facility Data into FTE_PRC_PARAMETERS

Line 2346: l_prc_param_values := STRINGARRAY(l_rate_basis, l_rate_basis_uom, l_list_header_id, l_currency);

2342: RETURN;
2343: END IF;
2344:
2345: l_prc_param_ids := STRINGARRAY(57, 58, 59, 60);
2346: l_prc_param_values := STRINGARRAY(l_rate_basis, l_rate_basis_uom, l_list_header_id, l_currency);
2347:
2348: --+
2349: -- Insert Facility Data into FTE_PRC_PARAMETERS
2350: --+

Line 2678: PROCEDURE PROCESS_STOPOFF_CHARGES(p_break_charges IN STRINGARRAY,

2674: --
2675: -- Parameters
2676: --_________________________________________________________________________________--
2677:
2678: PROCEDURE PROCESS_STOPOFF_CHARGES(p_break_charges IN STRINGARRAY,
2679: p_num_free_stops IN NUMBER,
2680: p_process_id IN NUMBER,
2681: x_linenum IN OUT NOCOPY NUMBER,
2682: p_line_number IN NUMBER,

Line 2686: l_break_charges STRINGARRAY;

2682: p_line_number IN NUMBER,
2683: x_error_msg OUT NOCOPY VARCHAR2,
2684: x_status OUT NOCOPY NUMBER) IS
2685:
2686: l_break_charges STRINGARRAY;
2687: l_break_limits STRINGARRAY := STRINGARRAY();
2688: l_subtype VARCHAR2(30);
2689: l_type VARCHAR2(30);
2690: l_rate_type VARCHAR2(30);

Line 2687: l_break_limits STRINGARRAY := STRINGARRAY();

2683: x_error_msg OUT NOCOPY VARCHAR2,
2684: x_status OUT NOCOPY NUMBER) IS
2685:
2686: l_break_charges STRINGARRAY;
2687: l_break_limits STRINGARRAY := STRINGARRAY();
2688: l_subtype VARCHAR2(30);
2689: l_type VARCHAR2(30);
2690: l_rate_type VARCHAR2(30);
2691: l_break_type VARCHAR2(30);

Line 2724: -- But, check additional stop off charges, which is the last element in the STRINGARRAY.

2720:
2721: --+
2722: -- Remove any NULL breaks
2723: -- If any of the stop off charges are NULL, we delete the remaining breaks are also.
2724: -- But, check additional stop off charges, which is the last element in the STRINGARRAY.
2725: --+
2726: FOR i IN 1..l_break_charges.COUNT LOOP
2727:
2728: IF (l_break_charges(i) IS NULL) THEN

Line 3253: p_tokens => STRINGARRAY('BASIS','LOAD'),

3249:
3250: IF (x_status = 3) THEN
3251: x_status := 2;
3252: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_INVALID_BASIS',
3253: p_tokens => STRINGARRAY('BASIS','LOAD'),
3254: p_values => STRINGARRAY(p_basis,p_load_type));
3255: FTE_UTIL_PKG.Write_OutFile( p_msg => x_error_msg,
3256: p_module_name => l_module_name,
3257: p_category => 'D',

Line 3254: p_values => STRINGARRAY(p_basis,p_load_type));

3250: IF (x_status = 3) THEN
3251: x_status := 2;
3252: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_INVALID_BASIS',
3253: p_tokens => STRINGARRAY('BASIS','LOAD'),
3254: p_values => STRINGARRAY(p_basis,p_load_type));
3255: FTE_UTIL_PKG.Write_OutFile( p_msg => x_error_msg,
3256: p_module_name => l_module_name,
3257: p_category => 'D',
3258: p_line_number => p_line_number );

Line 3730: l_break_charges STRINGARRAY;

3726: l_out_rt_chg_uom VARCHAR2(20);
3727: l_rate_basis VARCHAR2(20);
3728: l_rate_basis_uom VARCHAR2(20);
3729: l_break_type VARCHAR2(30);
3730: l_break_charges STRINGARRAY;
3731: l_attribute_type VARCHAR2(50);
3732: l_attribute_value VARCHAR2(50);
3733: l_context VARCHAR2(50);
3734: l_load_type_prefix VARCHAR2(30);

Line 3833: p_tokens => STRINGARRAY('ENTITY'),

3829: l_wkday_layovr_chg < 0 ) THEN
3830:
3831: x_status := 2;
3832: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_VALUE_ERROR',
3833: p_tokens => STRINGARRAY('ENTITY'),
3834: p_values => STRINGARRAY('Charge'));
3835: FTE_UTIL_PKG.Write_OutFile( p_msg => x_error_msg,
3836: p_module_name => l_module_name,
3837: p_category => 'D',

Line 3834: p_values => STRINGARRAY('Charge'));

3830:
3831: x_status := 2;
3832: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_VALUE_ERROR',
3833: p_tokens => STRINGARRAY('ENTITY'),
3834: p_values => STRINGARRAY('Charge'));
3835: FTE_UTIL_PKG.Write_OutFile( p_msg => x_error_msg,
3836: p_module_name => l_module_name,
3837: p_category => 'D',
3838: p_line_number => p_line_number);

Line 3917: p_tokens => STRINGARRAY('UOM'),

3913:
3914: IF (x_status <> -1 OR l_rate_basis_uom IS NULL) THEN
3915: x_status := 2;
3916: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_UOM_INVALID',
3917: p_tokens => STRINGARRAY('UOM'),
3918: p_values => STRINGARRAY(l_rate_basis_uom));
3919: FTE_UTIL_PKG.WRITE_OUTFILE(p_msg => x_error_msg,
3920: p_module_name => l_module_name,
3921: p_category => 'D',

Line 3918: p_values => STRINGARRAY(l_rate_basis_uom));

3914: IF (x_status <> -1 OR l_rate_basis_uom IS NULL) THEN
3915: x_status := 2;
3916: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_UOM_INVALID',
3917: p_tokens => STRINGARRAY('UOM'),
3918: p_values => STRINGARRAY(l_rate_basis_uom));
3919: FTE_UTIL_PKG.WRITE_OUTFILE(p_msg => x_error_msg,
3920: p_module_name => l_module_name,
3921: p_category => 'D',
3922: p_line_number => p_line_number);

Line 4091: l_break_charges := STRINGARRAY(0,

4087: FTE_UTIL_PKG.Exit_Debug(l_module_name);
4088: RETURN;
4089: END IF;
4090:
4091: l_break_charges := STRINGARRAY(0,
4092: l_stop_chg_1, l_stop_chg_2,
4093: l_stop_chg_3, l_stop_chg_4,
4094: l_stop_chg_5, l_stop_chg_x);
4095:

Line 4302: l_assoc_rc_ids STRINGARRAY;

4298: l_linenum NUMBER;
4299: l_chart_type VARCHAR2(50);
4300: l_status VARCHAR2(4000);
4301: l_service_level VARCHAR2(30);
4302: l_assoc_rc_ids STRINGARRAY;
4303:
4304: l_values FTE_BULKLOAD_PKG.data_values_tbl;
4305: l_rate_hdr_data FTE_BULKLOAD_PKG.data_values_tbl;
4306: l_rate_line_data FTE_BULKLOAD_PKG.data_values_tbl;

Line 5062: p_tokens => STRINGARRAY('ENTITY'),

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',
5062: p_tokens => STRINGARRAY('ENTITY'),
5063: p_values => STRINGARRAY('RATE'));
5064: FTE_UTIL_PKG.Write_OutFile(p_msg => x_error_msg,
5065: p_module_name => l_module_name,
5066: p_category => 'D',

Line 5063: p_values => STRINGARRAY('RATE'));

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',
5062: p_tokens => STRINGARRAY('ENTITY'),
5063: p_values => STRINGARRAY('RATE'));
5064: FTE_UTIL_PKG.Write_OutFile(p_msg => x_error_msg,
5065: p_module_name => l_module_name,
5066: p_category => 'D',
5067: p_line_number => p_line_number + i + 1);

Line 5137: p_tokens => STRINGARRAY('ENTITY'),

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',
5137: p_tokens => STRINGARRAY('ENTITY'),
5138: p_values => STRINGARRAY('RATE'));
5139: FTE_UTIL_PKG.Write_OutFile( p_msg => x_error_msg,
5140: p_module_name => l_module_name,
5141: p_category => 'D',

Line 5138: p_values => STRINGARRAY('RATE'));

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',
5137: p_tokens => STRINGARRAY('ENTITY'),
5138: p_values => STRINGARRAY('RATE'));
5139: FTE_UTIL_PKG.Write_OutFile( p_msg => x_error_msg,
5140: p_module_name => l_module_name,
5141: p_category => 'D',
5142: p_line_number => p_line_number + i + 1);

Line 5359: l_assoc_modifier_ids STRINGARRAY;

5355: l_description VARCHAR2(200);
5356: l_linenum NUMBER;
5357: l_precedence NUMBER;
5358: l_deadhead BOOLEAN := FALSE;
5359: l_assoc_modifier_ids STRINGARRAY;
5360:
5361: --+
5362: -- Used for Rate Chart Deletion
5363: --+

Line 5364: l_deleted_rate_charts STRINGARRAY;

5360:
5361: --+
5362: -- Used for Rate Chart Deletion
5363: --+
5364: l_deleted_rate_charts STRINGARRAY;
5365: l_del_count NUMBER := 0;
5366:
5367:
5368: --+

Line 5436: p_tokens => STRINGARRAY('ENTITY'),

5432: l_rate := FTE_UTIL_PKG.GET_DATA('RATE', l_values);
5433: IF (l_rate < 0 ) THEN
5434: x_status := 2;
5435: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_VALUE_ERROR',
5436: p_tokens => STRINGARRAY('ENTITY'),
5437: p_values => STRINGARRAY('RATE'));
5438: FTE_UTIL_PKG.Write_OutFile(p_msg => x_error_msg,
5439: p_module_name => l_module_name,
5440: p_category => 'D',

Line 5437: p_values => STRINGARRAY('RATE'));

5433: IF (l_rate < 0 ) THEN
5434: x_status := 2;
5435: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_VALUE_ERROR',
5436: p_tokens => STRINGARRAY('ENTITY'),
5437: p_values => STRINGARRAY('RATE'));
5438: FTE_UTIL_PKG.Write_OutFile(p_msg => x_error_msg,
5439: p_module_name => l_module_name,
5440: p_category => 'D',
5441: p_line_number => p_line_number + i + 1);

Line 5462: p_tokens => STRINGARRAY('ENTITY'),

5458: IF (l_min_charge IS NOT NULL ) THEN
5459: IF (l_min_charge < 0 ) THEN
5460: x_status := 2;
5461: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_VALUE_ERROR',
5462: p_tokens => STRINGARRAY('ENTITY'),
5463: p_values => STRINGARRAY('MINIMUM_CHARGE'));
5464: FTE_UTIL_PKG.Write_OutFile(p_msg => x_error_msg,
5465: p_module_name => l_module_name,
5466: p_category => 'D',

Line 5463: p_values => STRINGARRAY('MINIMUM_CHARGE'));

5459: IF (l_min_charge < 0 ) THEN
5460: x_status := 2;
5461: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_VALUE_ERROR',
5462: p_tokens => STRINGARRAY('ENTITY'),
5463: p_values => STRINGARRAY('MINIMUM_CHARGE'));
5464: FTE_UTIL_PKG.Write_OutFile(p_msg => x_error_msg,
5465: p_module_name => l_module_name,
5466: p_category => 'D',
5467: p_line_number => p_line_number + i + 1);

Line 5579: p_tokens => STRINGARRAY('ENTITY'),

5575: IF (p_doValidate) THEN
5576: IF (l_rate < 0 ) THEN
5577: x_status := 2;
5578: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_VALUE_ERROR',
5579: p_tokens => STRINGARRAY('ENTITY'),
5580: p_values => STRINGARRAY('RATE'));
5581: FTE_UTIL_PKG.Write_OutFile(p_msg => x_error_msg,
5582: p_module_name => l_module_name,
5583: p_category => 'D',

Line 5580: p_values => STRINGARRAY('RATE'));

5576: IF (l_rate < 0 ) THEN
5577: x_status := 2;
5578: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_VALUE_ERROR',
5579: p_tokens => STRINGARRAY('ENTITY'),
5580: p_values => STRINGARRAY('RATE'));
5581: FTE_UTIL_PKG.Write_OutFile(p_msg => x_error_msg,
5582: p_module_name => l_module_name,
5583: p_category => 'D',
5584: p_line_number => p_line_number + i + 1);

Line 5592: p_tokens => STRINGARRAY('ENTITY'),

5588:
5589: IF (l_min_charge < 0) THEN
5590: x_status := 2;
5591: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_VALUE_ERROR',
5592: p_tokens => STRINGARRAY('ENTITY'),
5593: p_values => STRINGARRAY('MINIMUM_CHARGE'));
5594: FTE_UTIL_PKG.Write_OutFile(p_msg => x_error_msg,
5595: p_module_name => l_module_name,
5596: p_category => 'D',

Line 5593: p_values => STRINGARRAY('MINIMUM_CHARGE'));

5589: IF (l_min_charge < 0) THEN
5590: x_status := 2;
5591: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_VALUE_ERROR',
5592: p_tokens => STRINGARRAY('ENTITY'),
5593: p_values => STRINGARRAY('MINIMUM_CHARGE'));
5594: FTE_UTIL_PKG.Write_OutFile(p_msg => x_error_msg,
5595: p_module_name => l_module_name,
5596: p_category => 'D',
5597: p_line_number => p_line_number + i + 1);