APPS.FTE_PARCEL_LOADER dependencies on FTE_VALIDATION_PKG

Line 246: FOR i IN 1..FTE_VALIDATION_PKG.SERVICE.COUNT LOOP

242: FTE_UTIL_PKG.ENTER_DEBUG(l_module_name);
243:
244: x_status := -1;
245:
246: FOR i IN 1..FTE_VALIDATION_PKG.SERVICE.COUNT LOOP
247: l_lane_data(FTE_VALIDATION_PKG.SERVICE(i)) := null;
248: l_service_data(FTE_VALIDATION_PKG.SERVICE(i)) := null;
249: l_rate_data(FTE_VALIDATION_PKG.SERVICE(i)) := null;
250: l_lane_header(FTE_VALIDATION_PKG.SERVICE(i)) := i;

Line 247: l_lane_data(FTE_VALIDATION_PKG.SERVICE(i)) := null;

243:
244: x_status := -1;
245:
246: FOR i IN 1..FTE_VALIDATION_PKG.SERVICE.COUNT LOOP
247: l_lane_data(FTE_VALIDATION_PKG.SERVICE(i)) := null;
248: l_service_data(FTE_VALIDATION_PKG.SERVICE(i)) := null;
249: l_rate_data(FTE_VALIDATION_PKG.SERVICE(i)) := null;
250: l_lane_header(FTE_VALIDATION_PKG.SERVICE(i)) := i;
251: END LOOP;

Line 248: l_service_data(FTE_VALIDATION_PKG.SERVICE(i)) := null;

244: x_status := -1;
245:
246: FOR i IN 1..FTE_VALIDATION_PKG.SERVICE.COUNT LOOP
247: l_lane_data(FTE_VALIDATION_PKG.SERVICE(i)) := null;
248: l_service_data(FTE_VALIDATION_PKG.SERVICE(i)) := null;
249: l_rate_data(FTE_VALIDATION_PKG.SERVICE(i)) := null;
250: l_lane_header(FTE_VALIDATION_PKG.SERVICE(i)) := i;
251: END LOOP;
252:

Line 249: l_rate_data(FTE_VALIDATION_PKG.SERVICE(i)) := null;

245:
246: FOR i IN 1..FTE_VALIDATION_PKG.SERVICE.COUNT LOOP
247: l_lane_data(FTE_VALIDATION_PKG.SERVICE(i)) := null;
248: l_service_data(FTE_VALIDATION_PKG.SERVICE(i)) := null;
249: l_rate_data(FTE_VALIDATION_PKG.SERVICE(i)) := null;
250: l_lane_header(FTE_VALIDATION_PKG.SERVICE(i)) := i;
251: END LOOP;
252:
253: FOR i IN 1..FTE_VALIDATION_PKG.SERVICE_RATING_SETUP.COUNT LOOP

Line 250: l_lane_header(FTE_VALIDATION_PKG.SERVICE(i)) := i;

246: FOR i IN 1..FTE_VALIDATION_PKG.SERVICE.COUNT LOOP
247: l_lane_data(FTE_VALIDATION_PKG.SERVICE(i)) := null;
248: l_service_data(FTE_VALIDATION_PKG.SERVICE(i)) := null;
249: l_rate_data(FTE_VALIDATION_PKG.SERVICE(i)) := null;
250: l_lane_header(FTE_VALIDATION_PKG.SERVICE(i)) := i;
251: END LOOP;
252:
253: FOR i IN 1..FTE_VALIDATION_PKG.SERVICE_RATING_SETUP.COUNT LOOP
254: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(i)) := null;

Line 253: FOR i IN 1..FTE_VALIDATION_PKG.SERVICE_RATING_SETUP.COUNT LOOP

249: l_rate_data(FTE_VALIDATION_PKG.SERVICE(i)) := null;
250: l_lane_header(FTE_VALIDATION_PKG.SERVICE(i)) := i;
251: END LOOP;
252:
253: FOR i IN 1..FTE_VALIDATION_PKG.SERVICE_RATING_SETUP.COUNT LOOP
254: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(i)) := null;
255: l_rate_header(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(i)) := i;
256: END LOOP;
257:

Line 254: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(i)) := null;

250: l_lane_header(FTE_VALIDATION_PKG.SERVICE(i)) := i;
251: END LOOP;
252:
253: FOR i IN 1..FTE_VALIDATION_PKG.SERVICE_RATING_SETUP.COUNT LOOP
254: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(i)) := null;
255: l_rate_header(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(i)) := i;
256: END LOOP;
257:
258: FOR i IN 1..FTE_VALIDATION_PKG.ZONE.COUNT LOOP

Line 255: l_rate_header(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(i)) := i;

251: END LOOP;
252:
253: FOR i IN 1..FTE_VALIDATION_PKG.SERVICE_RATING_SETUP.COUNT LOOP
254: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(i)) := null;
255: l_rate_header(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(i)) := i;
256: END LOOP;
257:
258: FOR i IN 1..FTE_VALIDATION_PKG.ZONE.COUNT LOOP
259: l_zone_header(FTE_VALIDATION_PKG.ZONE(i)) := i;

Line 258: FOR i IN 1..FTE_VALIDATION_PKG.ZONE.COUNT LOOP

254: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(i)) := null;
255: l_rate_header(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(i)) := i;
256: END LOOP;
257:
258: FOR i IN 1..FTE_VALIDATION_PKG.ZONE.COUNT LOOP
259: l_zone_header(FTE_VALIDATION_PKG.ZONE(i)) := i;
260: END LOOP;
261:
262: g_dest_zones(g_dest_zones.COUNT+1) := g_origin_zone;

Line 259: l_zone_header(FTE_VALIDATION_PKG.ZONE(i)) := i;

255: l_rate_header(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(i)) := i;
256: END LOOP;
257:
258: FOR i IN 1..FTE_VALIDATION_PKG.ZONE.COUNT LOOP
259: l_zone_header(FTE_VALIDATION_PKG.ZONE(i)) := i;
260: END LOOP;
261:
262: g_dest_zones(g_dest_zones.COUNT+1) := g_origin_zone;
263:

Line 289: l_lane_data(FTE_VALIDATION_PKG.SERVICE(2)) := 'SERVICE';

285: IF (INSTR(UPPER(g_service_columns(j)), 'LETTER') > 0) THEN
286: l_basis := 'CONTAINER';
287: END IF;
288:
289: l_lane_data(FTE_VALIDATION_PKG.SERVICE(2)) := 'SERVICE';
290: l_lane_data(FTE_VALIDATION_PKG.SERVICE(1)) := 'ADD';
291: l_lane_data(FTE_VALIDATION_PKG.SERVICE(4)) := l_dest_values(1)||'-'||g_dest_id;
292: l_lane_data(FTE_VALIDATION_PKG.SERVICE(11)) := g_origin_zone(FTE_VALIDATION_PKG.ZONE(2));
293: l_lane_data(FTE_VALIDATION_PKG.SERVICE(17)) := l_dest_values(1);

Line 290: l_lane_data(FTE_VALIDATION_PKG.SERVICE(1)) := 'ADD';

286: l_basis := 'CONTAINER';
287: END IF;
288:
289: l_lane_data(FTE_VALIDATION_PKG.SERVICE(2)) := 'SERVICE';
290: l_lane_data(FTE_VALIDATION_PKG.SERVICE(1)) := 'ADD';
291: l_lane_data(FTE_VALIDATION_PKG.SERVICE(4)) := l_dest_values(1)||'-'||g_dest_id;
292: l_lane_data(FTE_VALIDATION_PKG.SERVICE(11)) := g_origin_zone(FTE_VALIDATION_PKG.ZONE(2));
293: l_lane_data(FTE_VALIDATION_PKG.SERVICE(17)) := l_dest_values(1);
294: l_lane_data(FTE_VALIDATION_PKG.SERVICE(5)) := g_chart_info(2);

Line 291: l_lane_data(FTE_VALIDATION_PKG.SERVICE(4)) := l_dest_values(1)||'-'||g_dest_id;

287: END IF;
288:
289: l_lane_data(FTE_VALIDATION_PKG.SERVICE(2)) := 'SERVICE';
290: l_lane_data(FTE_VALIDATION_PKG.SERVICE(1)) := 'ADD';
291: l_lane_data(FTE_VALIDATION_PKG.SERVICE(4)) := l_dest_values(1)||'-'||g_dest_id;
292: l_lane_data(FTE_VALIDATION_PKG.SERVICE(11)) := g_origin_zone(FTE_VALIDATION_PKG.ZONE(2));
293: l_lane_data(FTE_VALIDATION_PKG.SERVICE(17)) := l_dest_values(1);
294: l_lane_data(FTE_VALIDATION_PKG.SERVICE(5)) := g_chart_info(2);
295: l_lane_data(FTE_VALIDATION_PKG.SERVICE(21)) := l_basis;

Line 292: l_lane_data(FTE_VALIDATION_PKG.SERVICE(11)) := g_origin_zone(FTE_VALIDATION_PKG.ZONE(2));

288:
289: l_lane_data(FTE_VALIDATION_PKG.SERVICE(2)) := 'SERVICE';
290: l_lane_data(FTE_VALIDATION_PKG.SERVICE(1)) := 'ADD';
291: l_lane_data(FTE_VALIDATION_PKG.SERVICE(4)) := l_dest_values(1)||'-'||g_dest_id;
292: l_lane_data(FTE_VALIDATION_PKG.SERVICE(11)) := g_origin_zone(FTE_VALIDATION_PKG.ZONE(2));
293: l_lane_data(FTE_VALIDATION_PKG.SERVICE(17)) := l_dest_values(1);
294: l_lane_data(FTE_VALIDATION_PKG.SERVICE(5)) := g_chart_info(2);
295: l_lane_data(FTE_VALIDATION_PKG.SERVICE(21)) := l_basis;
296: l_lane_data(FTE_VALIDATION_PKG.SERVICE(23)) := g_chart_info(6);

Line 293: l_lane_data(FTE_VALIDATION_PKG.SERVICE(17)) := l_dest_values(1);

289: l_lane_data(FTE_VALIDATION_PKG.SERVICE(2)) := 'SERVICE';
290: l_lane_data(FTE_VALIDATION_PKG.SERVICE(1)) := 'ADD';
291: l_lane_data(FTE_VALIDATION_PKG.SERVICE(4)) := l_dest_values(1)||'-'||g_dest_id;
292: l_lane_data(FTE_VALIDATION_PKG.SERVICE(11)) := g_origin_zone(FTE_VALIDATION_PKG.ZONE(2));
293: l_lane_data(FTE_VALIDATION_PKG.SERVICE(17)) := l_dest_values(1);
294: l_lane_data(FTE_VALIDATION_PKG.SERVICE(5)) := g_chart_info(2);
295: l_lane_data(FTE_VALIDATION_PKG.SERVICE(21)) := l_basis;
296: l_lane_data(FTE_VALIDATION_PKG.SERVICE(23)) := g_chart_info(6);
297: l_lane_data(FTE_VALIDATION_PKG.SERVICE(3)) := g_chart_info(4);

Line 294: l_lane_data(FTE_VALIDATION_PKG.SERVICE(5)) := g_chart_info(2);

290: l_lane_data(FTE_VALIDATION_PKG.SERVICE(1)) := 'ADD';
291: l_lane_data(FTE_VALIDATION_PKG.SERVICE(4)) := l_dest_values(1)||'-'||g_dest_id;
292: l_lane_data(FTE_VALIDATION_PKG.SERVICE(11)) := g_origin_zone(FTE_VALIDATION_PKG.ZONE(2));
293: l_lane_data(FTE_VALIDATION_PKG.SERVICE(17)) := l_dest_values(1);
294: l_lane_data(FTE_VALIDATION_PKG.SERVICE(5)) := g_chart_info(2);
295: l_lane_data(FTE_VALIDATION_PKG.SERVICE(21)) := l_basis;
296: l_lane_data(FTE_VALIDATION_PKG.SERVICE(23)) := g_chart_info(6);
297: l_lane_data(FTE_VALIDATION_PKG.SERVICE(3)) := g_chart_info(4);
298: l_lane_data('EDITABLE_FLAG') := 'N';

Line 295: l_lane_data(FTE_VALIDATION_PKG.SERVICE(21)) := l_basis;

291: l_lane_data(FTE_VALIDATION_PKG.SERVICE(4)) := l_dest_values(1)||'-'||g_dest_id;
292: l_lane_data(FTE_VALIDATION_PKG.SERVICE(11)) := g_origin_zone(FTE_VALIDATION_PKG.ZONE(2));
293: l_lane_data(FTE_VALIDATION_PKG.SERVICE(17)) := l_dest_values(1);
294: l_lane_data(FTE_VALIDATION_PKG.SERVICE(5)) := g_chart_info(2);
295: l_lane_data(FTE_VALIDATION_PKG.SERVICE(21)) := l_basis;
296: l_lane_data(FTE_VALIDATION_PKG.SERVICE(23)) := g_chart_info(6);
297: l_lane_data(FTE_VALIDATION_PKG.SERVICE(3)) := g_chart_info(4);
298: l_lane_data('EDITABLE_FLAG') := 'N';
299: l_lane_data(FTE_VALIDATION_PKG.SERVICE(32)) := g_chart_info(8);

Line 296: l_lane_data(FTE_VALIDATION_PKG.SERVICE(23)) := g_chart_info(6);

292: l_lane_data(FTE_VALIDATION_PKG.SERVICE(11)) := g_origin_zone(FTE_VALIDATION_PKG.ZONE(2));
293: l_lane_data(FTE_VALIDATION_PKG.SERVICE(17)) := l_dest_values(1);
294: l_lane_data(FTE_VALIDATION_PKG.SERVICE(5)) := g_chart_info(2);
295: l_lane_data(FTE_VALIDATION_PKG.SERVICE(21)) := l_basis;
296: l_lane_data(FTE_VALIDATION_PKG.SERVICE(23)) := g_chart_info(6);
297: l_lane_data(FTE_VALIDATION_PKG.SERVICE(3)) := g_chart_info(4);
298: l_lane_data('EDITABLE_FLAG') := 'N';
299: l_lane_data(FTE_VALIDATION_PKG.SERVICE(32)) := g_chart_info(8);
300: l_lane_data(FTE_VALIDATION_PKG.SERVICE(33)) := g_chart_info(9);

Line 297: l_lane_data(FTE_VALIDATION_PKG.SERVICE(3)) := g_chart_info(4);

293: l_lane_data(FTE_VALIDATION_PKG.SERVICE(17)) := l_dest_values(1);
294: l_lane_data(FTE_VALIDATION_PKG.SERVICE(5)) := g_chart_info(2);
295: l_lane_data(FTE_VALIDATION_PKG.SERVICE(21)) := l_basis;
296: l_lane_data(FTE_VALIDATION_PKG.SERVICE(23)) := g_chart_info(6);
297: l_lane_data(FTE_VALIDATION_PKG.SERVICE(3)) := g_chart_info(4);
298: l_lane_data('EDITABLE_FLAG') := 'N';
299: l_lane_data(FTE_VALIDATION_PKG.SERVICE(32)) := g_chart_info(8);
300: l_lane_data(FTE_VALIDATION_PKG.SERVICE(33)) := g_chart_info(9);
301:

Line 299: l_lane_data(FTE_VALIDATION_PKG.SERVICE(32)) := g_chart_info(8);

295: l_lane_data(FTE_VALIDATION_PKG.SERVICE(21)) := l_basis;
296: l_lane_data(FTE_VALIDATION_PKG.SERVICE(23)) := g_chart_info(6);
297: l_lane_data(FTE_VALIDATION_PKG.SERVICE(3)) := g_chart_info(4);
298: l_lane_data('EDITABLE_FLAG') := 'N';
299: l_lane_data(FTE_VALIDATION_PKG.SERVICE(32)) := g_chart_info(8);
300: l_lane_data(FTE_VALIDATION_PKG.SERVICE(33)) := g_chart_info(9);
301:
302: g_dest_id := g_dest_id + 1;
303:

Line 300: l_lane_data(FTE_VALIDATION_PKG.SERVICE(33)) := g_chart_info(9);

296: l_lane_data(FTE_VALIDATION_PKG.SERVICE(23)) := g_chart_info(6);
297: l_lane_data(FTE_VALIDATION_PKG.SERVICE(3)) := g_chart_info(4);
298: l_lane_data('EDITABLE_FLAG') := 'N';
299: l_lane_data(FTE_VALIDATION_PKG.SERVICE(32)) := g_chart_info(8);
300: l_lane_data(FTE_VALIDATION_PKG.SERVICE(33)) := g_chart_info(9);
301:
302: g_dest_id := g_dest_id + 1;
303:
304: l_service_data(FTE_VALIDATION_PKG.SERVICE(2)) := 'SERVICE_LEVEL';

Line 304: l_service_data(FTE_VALIDATION_PKG.SERVICE(2)) := 'SERVICE_LEVEL';

300: l_lane_data(FTE_VALIDATION_PKG.SERVICE(33)) := g_chart_info(9);
301:
302: g_dest_id := g_dest_id + 1;
303:
304: l_service_data(FTE_VALIDATION_PKG.SERVICE(2)) := 'SERVICE_LEVEL';
305: l_service_data(FTE_VALIDATION_PKG.SERVICE(1)) := 'ADD';
306: l_service_data(FTE_VALIDATION_PKG.SERVICE(19)) := g_service_columns(j);
307:
308: l_rate_data(FTE_VALIDATION_PKG.SERVICE(2)) := 'RATE_CHART';

Line 305: l_service_data(FTE_VALIDATION_PKG.SERVICE(1)) := 'ADD';

301:
302: g_dest_id := g_dest_id + 1;
303:
304: l_service_data(FTE_VALIDATION_PKG.SERVICE(2)) := 'SERVICE_LEVEL';
305: l_service_data(FTE_VALIDATION_PKG.SERVICE(1)) := 'ADD';
306: l_service_data(FTE_VALIDATION_PKG.SERVICE(19)) := g_service_columns(j);
307:
308: l_rate_data(FTE_VALIDATION_PKG.SERVICE(2)) := 'RATE_CHART';
309: l_rate_data(FTE_VALIDATION_PKG.SERVICE(1)) := 'ADD';

Line 306: l_service_data(FTE_VALIDATION_PKG.SERVICE(19)) := g_service_columns(j);

302: g_dest_id := g_dest_id + 1;
303:
304: l_service_data(FTE_VALIDATION_PKG.SERVICE(2)) := 'SERVICE_LEVEL';
305: l_service_data(FTE_VALIDATION_PKG.SERVICE(1)) := 'ADD';
306: l_service_data(FTE_VALIDATION_PKG.SERVICE(19)) := g_service_columns(j);
307:
308: l_rate_data(FTE_VALIDATION_PKG.SERVICE(2)) := 'RATE_CHART';
309: l_rate_data(FTE_VALIDATION_PKG.SERVICE(1)) := 'ADD';
310: l_rate_data(FTE_VALIDATION_PKG.SERVICE(22)) := g_chart_info(5) || l_dest_values(j+1);

Line 308: l_rate_data(FTE_VALIDATION_PKG.SERVICE(2)) := 'RATE_CHART';

304: l_service_data(FTE_VALIDATION_PKG.SERVICE(2)) := 'SERVICE_LEVEL';
305: l_service_data(FTE_VALIDATION_PKG.SERVICE(1)) := 'ADD';
306: l_service_data(FTE_VALIDATION_PKG.SERVICE(19)) := g_service_columns(j);
307:
308: l_rate_data(FTE_VALIDATION_PKG.SERVICE(2)) := 'RATE_CHART';
309: l_rate_data(FTE_VALIDATION_PKG.SERVICE(1)) := 'ADD';
310: l_rate_data(FTE_VALIDATION_PKG.SERVICE(22)) := g_chart_info(5) || l_dest_values(j+1);
311:
312: l_lane_table(l_lane_table.COUNT+1) := l_lane_data;

Line 309: l_rate_data(FTE_VALIDATION_PKG.SERVICE(1)) := 'ADD';

305: l_service_data(FTE_VALIDATION_PKG.SERVICE(1)) := 'ADD';
306: l_service_data(FTE_VALIDATION_PKG.SERVICE(19)) := g_service_columns(j);
307:
308: l_rate_data(FTE_VALIDATION_PKG.SERVICE(2)) := 'RATE_CHART';
309: l_rate_data(FTE_VALIDATION_PKG.SERVICE(1)) := 'ADD';
310: l_rate_data(FTE_VALIDATION_PKG.SERVICE(22)) := g_chart_info(5) || l_dest_values(j+1);
311:
312: l_lane_table(l_lane_table.COUNT+1) := l_lane_data;
313: l_lane_table(l_lane_table.COUNT+1) := l_service_data;

Line 310: l_rate_data(FTE_VALIDATION_PKG.SERVICE(22)) := g_chart_info(5) || l_dest_values(j+1);

306: l_service_data(FTE_VALIDATION_PKG.SERVICE(19)) := g_service_columns(j);
307:
308: l_rate_data(FTE_VALIDATION_PKG.SERVICE(2)) := 'RATE_CHART';
309: l_rate_data(FTE_VALIDATION_PKG.SERVICE(1)) := 'ADD';
310: l_rate_data(FTE_VALIDATION_PKG.SERVICE(22)) := g_chart_info(5) || l_dest_values(j+1);
311:
312: l_lane_table(l_lane_table.COUNT+1) := l_lane_data;
313: l_lane_table(l_lane_table.COUNT+1) := l_service_data;
314: l_lane_table(l_lane_table.COUNT+1) := l_rate_data;

Line 325: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(1)) := 'SYNC';

321: END IF;
322:
323: IF (g_setup_info(k)(1) IS NOT NULL AND g_setup_info(k)(1) = g_service_columns(j)) THEN
324:
325: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(1)) := 'SYNC';
326: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(2)) := g_chart_info(4);
327: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(3)) := l_lane_data(FTE_VALIDATION_PKG.SERVICE(4));
328: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(4)) := g_setup_info(k)(2);
329: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(5)) := g_setup_info(k)(3);

Line 326: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(2)) := g_chart_info(4);

322:
323: IF (g_setup_info(k)(1) IS NOT NULL AND g_setup_info(k)(1) = g_service_columns(j)) THEN
324:
325: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(1)) := 'SYNC';
326: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(2)) := g_chart_info(4);
327: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(3)) := l_lane_data(FTE_VALIDATION_PKG.SERVICE(4));
328: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(4)) := g_setup_info(k)(2);
329: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(5)) := g_setup_info(k)(3);
330: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(6)) := g_setup_info(k)(4);

Line 327: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(3)) := l_lane_data(FTE_VALIDATION_PKG.SERVICE(4));

323: IF (g_setup_info(k)(1) IS NOT NULL AND g_setup_info(k)(1) = g_service_columns(j)) THEN
324:
325: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(1)) := 'SYNC';
326: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(2)) := g_chart_info(4);
327: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(3)) := l_lane_data(FTE_VALIDATION_PKG.SERVICE(4));
328: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(4)) := g_setup_info(k)(2);
329: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(5)) := g_setup_info(k)(3);
330: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(6)) := g_setup_info(k)(4);
331: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(7)) := g_setup_info(k)(5);

Line 328: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(4)) := g_setup_info(k)(2);

324:
325: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(1)) := 'SYNC';
326: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(2)) := g_chart_info(4);
327: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(3)) := l_lane_data(FTE_VALIDATION_PKG.SERVICE(4));
328: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(4)) := g_setup_info(k)(2);
329: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(5)) := g_setup_info(k)(3);
330: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(6)) := g_setup_info(k)(4);
331: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(7)) := g_setup_info(k)(5);
332: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(8)) := g_setup_info(k)(6);

Line 329: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(5)) := g_setup_info(k)(3);

325: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(1)) := 'SYNC';
326: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(2)) := g_chart_info(4);
327: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(3)) := l_lane_data(FTE_VALIDATION_PKG.SERVICE(4));
328: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(4)) := g_setup_info(k)(2);
329: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(5)) := g_setup_info(k)(3);
330: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(6)) := g_setup_info(k)(4);
331: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(7)) := g_setup_info(k)(5);
332: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(8)) := g_setup_info(k)(6);
333: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(9)) := g_setup_info(k)(7);

Line 330: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(6)) := g_setup_info(k)(4);

326: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(2)) := g_chart_info(4);
327: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(3)) := l_lane_data(FTE_VALIDATION_PKG.SERVICE(4));
328: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(4)) := g_setup_info(k)(2);
329: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(5)) := g_setup_info(k)(3);
330: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(6)) := g_setup_info(k)(4);
331: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(7)) := g_setup_info(k)(5);
332: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(8)) := g_setup_info(k)(6);
333: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(9)) := g_setup_info(k)(7);
334: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(10)) := g_setup_info(k)(8);

Line 331: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(7)) := g_setup_info(k)(5);

327: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(3)) := l_lane_data(FTE_VALIDATION_PKG.SERVICE(4));
328: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(4)) := g_setup_info(k)(2);
329: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(5)) := g_setup_info(k)(3);
330: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(6)) := g_setup_info(k)(4);
331: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(7)) := g_setup_info(k)(5);
332: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(8)) := g_setup_info(k)(6);
333: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(9)) := g_setup_info(k)(7);
334: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(10)) := g_setup_info(k)(8);
335:

Line 332: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(8)) := g_setup_info(k)(6);

328: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(4)) := g_setup_info(k)(2);
329: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(5)) := g_setup_info(k)(3);
330: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(6)) := g_setup_info(k)(4);
331: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(7)) := g_setup_info(k)(5);
332: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(8)) := g_setup_info(k)(6);
333: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(9)) := g_setup_info(k)(7);
334: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(10)) := g_setup_info(k)(8);
335:
336: l_rate_table(l_rate_table.COUNT+1) := l_setup_data;

Line 333: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(9)) := g_setup_info(k)(7);

329: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(5)) := g_setup_info(k)(3);
330: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(6)) := g_setup_info(k)(4);
331: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(7)) := g_setup_info(k)(5);
332: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(8)) := g_setup_info(k)(6);
333: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(9)) := g_setup_info(k)(7);
334: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(10)) := g_setup_info(k)(8);
335:
336: l_rate_table(l_rate_table.COUNT+1) := l_setup_data;
337:

Line 334: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(10)) := g_setup_info(k)(8);

330: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(6)) := g_setup_info(k)(4);
331: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(7)) := g_setup_info(k)(5);
332: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(8)) := g_setup_info(k)(6);
333: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(9)) := g_setup_info(k)(7);
334: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(10)) := g_setup_info(k)(8);
335:
336: l_rate_table(l_rate_table.COUNT+1) := l_setup_data;
337:
338: l_index := k + 1;

Line 342: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(1)) := 'SYNC';

338: l_index := k + 1;
339:
340: -- looping through the table after the service is found and before the next service
341: WHILE (l_index <= g_setup_info.COUNT AND g_setup_info(l_index)(1) IS NULL) LOOP
342: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(1)) := 'SYNC';
343: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(2)) := g_chart_info(4);
344: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(3)) := l_lane_data(FTE_VALIDATION_PKG.SERVICE(4));
345: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(4)) := g_setup_info(l_index)(2);
346: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(5)) := g_setup_info(l_index)(3);

Line 343: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(2)) := g_chart_info(4);

339:
340: -- looping through the table after the service is found and before the next service
341: WHILE (l_index <= g_setup_info.COUNT AND g_setup_info(l_index)(1) IS NULL) LOOP
342: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(1)) := 'SYNC';
343: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(2)) := g_chart_info(4);
344: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(3)) := l_lane_data(FTE_VALIDATION_PKG.SERVICE(4));
345: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(4)) := g_setup_info(l_index)(2);
346: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(5)) := g_setup_info(l_index)(3);
347: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(6)) := g_setup_info(l_index)(4);

Line 344: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(3)) := l_lane_data(FTE_VALIDATION_PKG.SERVICE(4));

340: -- looping through the table after the service is found and before the next service
341: WHILE (l_index <= g_setup_info.COUNT AND g_setup_info(l_index)(1) IS NULL) LOOP
342: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(1)) := 'SYNC';
343: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(2)) := g_chart_info(4);
344: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(3)) := l_lane_data(FTE_VALIDATION_PKG.SERVICE(4));
345: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(4)) := g_setup_info(l_index)(2);
346: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(5)) := g_setup_info(l_index)(3);
347: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(6)) := g_setup_info(l_index)(4);
348: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(7)) := g_setup_info(l_index)(5);

Line 345: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(4)) := g_setup_info(l_index)(2);

341: WHILE (l_index <= g_setup_info.COUNT AND g_setup_info(l_index)(1) IS NULL) LOOP
342: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(1)) := 'SYNC';
343: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(2)) := g_chart_info(4);
344: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(3)) := l_lane_data(FTE_VALIDATION_PKG.SERVICE(4));
345: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(4)) := g_setup_info(l_index)(2);
346: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(5)) := g_setup_info(l_index)(3);
347: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(6)) := g_setup_info(l_index)(4);
348: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(7)) := g_setup_info(l_index)(5);
349: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(8)) := g_setup_info(l_index)(6);

Line 346: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(5)) := g_setup_info(l_index)(3);

342: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(1)) := 'SYNC';
343: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(2)) := g_chart_info(4);
344: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(3)) := l_lane_data(FTE_VALIDATION_PKG.SERVICE(4));
345: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(4)) := g_setup_info(l_index)(2);
346: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(5)) := g_setup_info(l_index)(3);
347: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(6)) := g_setup_info(l_index)(4);
348: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(7)) := g_setup_info(l_index)(5);
349: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(8)) := g_setup_info(l_index)(6);
350: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(9)) := g_setup_info(l_index)(7);

Line 347: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(6)) := g_setup_info(l_index)(4);

343: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(2)) := g_chart_info(4);
344: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(3)) := l_lane_data(FTE_VALIDATION_PKG.SERVICE(4));
345: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(4)) := g_setup_info(l_index)(2);
346: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(5)) := g_setup_info(l_index)(3);
347: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(6)) := g_setup_info(l_index)(4);
348: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(7)) := g_setup_info(l_index)(5);
349: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(8)) := g_setup_info(l_index)(6);
350: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(9)) := g_setup_info(l_index)(7);
351: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(10)) := g_setup_info(l_index)(8);

Line 348: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(7)) := g_setup_info(l_index)(5);

344: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(3)) := l_lane_data(FTE_VALIDATION_PKG.SERVICE(4));
345: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(4)) := g_setup_info(l_index)(2);
346: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(5)) := g_setup_info(l_index)(3);
347: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(6)) := g_setup_info(l_index)(4);
348: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(7)) := g_setup_info(l_index)(5);
349: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(8)) := g_setup_info(l_index)(6);
350: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(9)) := g_setup_info(l_index)(7);
351: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(10)) := g_setup_info(l_index)(8);
352:

Line 349: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(8)) := g_setup_info(l_index)(6);

345: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(4)) := g_setup_info(l_index)(2);
346: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(5)) := g_setup_info(l_index)(3);
347: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(6)) := g_setup_info(l_index)(4);
348: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(7)) := g_setup_info(l_index)(5);
349: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(8)) := g_setup_info(l_index)(6);
350: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(9)) := g_setup_info(l_index)(7);
351: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(10)) := g_setup_info(l_index)(8);
352:
353: l_rate_table(l_rate_table.COUNT+1) := l_setup_data;

Line 350: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(9)) := g_setup_info(l_index)(7);

346: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(5)) := g_setup_info(l_index)(3);
347: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(6)) := g_setup_info(l_index)(4);
348: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(7)) := g_setup_info(l_index)(5);
349: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(8)) := g_setup_info(l_index)(6);
350: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(9)) := g_setup_info(l_index)(7);
351: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(10)) := g_setup_info(l_index)(8);
352:
353: l_rate_table(l_rate_table.COUNT+1) := l_setup_data;
354: l_index := l_index + 1;

Line 351: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(10)) := g_setup_info(l_index)(8);

347: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(6)) := g_setup_info(l_index)(4);
348: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(7)) := g_setup_info(l_index)(5);
349: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(8)) := g_setup_info(l_index)(6);
350: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(9)) := g_setup_info(l_index)(7);
351: l_setup_data(FTE_VALIDATION_PKG.SERVICE_RATING_SETUP(10)) := g_setup_info(l_index)(8);
352:
353: l_rate_table(l_rate_table.COUNT+1) := l_setup_data;
354: l_index := l_index + 1;
355: END LOOP;

Line 483: FTE_VALIDATION_PKG.VALIDATE_COLUMNS(p_keys => p_block_header,

479:
480: x_status := -1;
481:
482: --verify the column name
483: FTE_VALIDATION_PKG.VALIDATE_COLUMNS(p_keys => p_block_header,
484: p_type => 'RATING_ZONE_CHART',
485: p_line_number => p_line_number+1,
486: x_status => x_status,
487: x_error_msg => x_error_msg);

Line 497: FTE_VALIDATION_PKG.VALIDATE_RATING_ZONE_CHART(p_values => l_values,

493: --now the body of the block
494: FOR i IN p_block_data.FIRST..p_block_data.LAST LOOP
495: l_values := p_block_data(i);
496:
497: FTE_VALIDATION_PKG.VALIDATE_RATING_ZONE_CHART(p_values => l_values,
498: p_line_number => p_line_number+i+1,
499: p_chart_info => g_chart_info,
500: x_status => x_status,
501: x_error_msg => x_error_msg);

Line 548: FTE_VALIDATION_PKG.VALIDATE_COLUMNS(p_keys => p_block_header,

544:
545: x_status := -1;
546:
547: --verify the column name
548: FTE_VALIDATION_PKG.VALIDATE_COLUMNS(p_keys => p_block_header,
549: p_type => 'RATING_SETUP',
550: p_line_number => p_line_number+1,
551: x_status => x_status,
552: x_error_msg => x_error_msg);

Line 562: FTE_VALIDATION_PKG.VALIDATE_RATING_SETUP(p_values => l_values,

558: --now the body of the block
559: FOR i IN p_block_data.FIRST..p_block_data.LAST LOOP
560: l_values := p_block_data(i);
561:
562: FTE_VALIDATION_PKG.VALIDATE_RATING_SETUP(p_values => l_values,
563: p_line_number => p_line_number+i+1,
564: p_setup_info => g_setup_info,
565: p_last_service_type => g_last_service_type,
566: x_status => x_status,

Line 621: FTE_VALIDATION_PKG.VALIDATE_COLUMNS(p_keys => p_block_header,

617:
618: x_status := -1;
619:
620: --verify the column name
621: FTE_VALIDATION_PKG.VALIDATE_COLUMNS(p_keys => p_block_header,
622: p_type => 'ORIGIN',
623: p_line_number => p_line_number+1,
624: x_status => x_status,
625: x_error_msg => x_error_msg);

Line 635: FTE_VALIDATION_PKG.VALIDATE_ORIGIN(p_values => l_values,

631: --now the body of the block
632: FOR i IN p_block_data.FIRST..p_block_data.LAST LOOP
633: l_values := p_block_data(i);
634:
635: FTE_VALIDATION_PKG.VALIDATE_ORIGIN(p_values => l_values,
636: p_line_number => p_line_number+i+1,
637: p_origin => l_origin,
638: x_status => x_status,
639: x_error_msg => x_error_msg);

Line 656: g_origin_zone(FTE_VALIDATION_PKG.ZONE(1)) := 'ADD';

652:
653: l_origin_postal_from := g_postal_from;
654: l_origin_postal_to := g_postal_to;
655:
656: g_origin_zone(FTE_VALIDATION_PKG.ZONE(1)) := 'ADD';
657: g_origin_zone(FTE_VALIDATION_PKG.ZONE(2)) := g_chart_info(1) || '-' || l_origin_postal_from;
658: g_origin_zone(FTE_VALIDATION_PKG.ZONE(5)) := l_origin_city;
659: g_origin_zone(FTE_VALIDATION_PKG.ZONE(4)) := l_origin_state;
660: g_origin_zone(FTE_VALIDATION_PKG.ZONE(3)) := l_origin_country;

Line 657: g_origin_zone(FTE_VALIDATION_PKG.ZONE(2)) := g_chart_info(1) || '-' || l_origin_postal_from;

653: l_origin_postal_from := g_postal_from;
654: l_origin_postal_to := g_postal_to;
655:
656: g_origin_zone(FTE_VALIDATION_PKG.ZONE(1)) := 'ADD';
657: g_origin_zone(FTE_VALIDATION_PKG.ZONE(2)) := g_chart_info(1) || '-' || l_origin_postal_from;
658: g_origin_zone(FTE_VALIDATION_PKG.ZONE(5)) := l_origin_city;
659: g_origin_zone(FTE_VALIDATION_PKG.ZONE(4)) := l_origin_state;
660: g_origin_zone(FTE_VALIDATION_PKG.ZONE(3)) := l_origin_country;
661: g_origin_zone(FTE_VALIDATION_PKG.ZONE(6)) := l_origin_postal_from;

Line 658: g_origin_zone(FTE_VALIDATION_PKG.ZONE(5)) := l_origin_city;

654: l_origin_postal_to := g_postal_to;
655:
656: g_origin_zone(FTE_VALIDATION_PKG.ZONE(1)) := 'ADD';
657: g_origin_zone(FTE_VALIDATION_PKG.ZONE(2)) := g_chart_info(1) || '-' || l_origin_postal_from;
658: g_origin_zone(FTE_VALIDATION_PKG.ZONE(5)) := l_origin_city;
659: g_origin_zone(FTE_VALIDATION_PKG.ZONE(4)) := l_origin_state;
660: g_origin_zone(FTE_VALIDATION_PKG.ZONE(3)) := l_origin_country;
661: g_origin_zone(FTE_VALIDATION_PKG.ZONE(6)) := l_origin_postal_from;
662: g_origin_zone(FTE_VALIDATION_PKG.ZONE(7)) := l_origin_postal_to;

Line 659: g_origin_zone(FTE_VALIDATION_PKG.ZONE(4)) := l_origin_state;

655:
656: g_origin_zone(FTE_VALIDATION_PKG.ZONE(1)) := 'ADD';
657: g_origin_zone(FTE_VALIDATION_PKG.ZONE(2)) := g_chart_info(1) || '-' || l_origin_postal_from;
658: g_origin_zone(FTE_VALIDATION_PKG.ZONE(5)) := l_origin_city;
659: g_origin_zone(FTE_VALIDATION_PKG.ZONE(4)) := l_origin_state;
660: g_origin_zone(FTE_VALIDATION_PKG.ZONE(3)) := l_origin_country;
661: g_origin_zone(FTE_VALIDATION_PKG.ZONE(6)) := l_origin_postal_from;
662: g_origin_zone(FTE_VALIDATION_PKG.ZONE(7)) := l_origin_postal_to;
663:

Line 660: g_origin_zone(FTE_VALIDATION_PKG.ZONE(3)) := l_origin_country;

656: g_origin_zone(FTE_VALIDATION_PKG.ZONE(1)) := 'ADD';
657: g_origin_zone(FTE_VALIDATION_PKG.ZONE(2)) := g_chart_info(1) || '-' || l_origin_postal_from;
658: g_origin_zone(FTE_VALIDATION_PKG.ZONE(5)) := l_origin_city;
659: g_origin_zone(FTE_VALIDATION_PKG.ZONE(4)) := l_origin_state;
660: g_origin_zone(FTE_VALIDATION_PKG.ZONE(3)) := l_origin_country;
661: g_origin_zone(FTE_VALIDATION_PKG.ZONE(6)) := l_origin_postal_from;
662: g_origin_zone(FTE_VALIDATION_PKG.ZONE(7)) := l_origin_postal_to;
663:
664: -- enhancement for patchset I : hjpark on 12/13/2002

Line 661: g_origin_zone(FTE_VALIDATION_PKG.ZONE(6)) := l_origin_postal_from;

657: g_origin_zone(FTE_VALIDATION_PKG.ZONE(2)) := g_chart_info(1) || '-' || l_origin_postal_from;
658: g_origin_zone(FTE_VALIDATION_PKG.ZONE(5)) := l_origin_city;
659: g_origin_zone(FTE_VALIDATION_PKG.ZONE(4)) := l_origin_state;
660: g_origin_zone(FTE_VALIDATION_PKG.ZONE(3)) := l_origin_country;
661: g_origin_zone(FTE_VALIDATION_PKG.ZONE(6)) := l_origin_postal_from;
662: g_origin_zone(FTE_VALIDATION_PKG.ZONE(7)) := l_origin_postal_to;
663:
664: -- enhancement for patchset I : hjpark on 12/13/2002
665: -- make the previously loaded data obsolete, if any

Line 662: g_origin_zone(FTE_VALIDATION_PKG.ZONE(7)) := l_origin_postal_to;

658: g_origin_zone(FTE_VALIDATION_PKG.ZONE(5)) := l_origin_city;
659: g_origin_zone(FTE_VALIDATION_PKG.ZONE(4)) := l_origin_state;
660: g_origin_zone(FTE_VALIDATION_PKG.ZONE(3)) := l_origin_country;
661: g_origin_zone(FTE_VALIDATION_PKG.ZONE(6)) := l_origin_postal_from;
662: g_origin_zone(FTE_VALIDATION_PKG.ZONE(7)) := l_origin_postal_to;
663:
664: -- enhancement for patchset I : hjpark on 12/13/2002
665: -- make the previously loaded data obsolete, if any
666:

Line 756: FTE_VALIDATION_PKG.VALIDATE_DESTINATION(p_values => l_values,

752: FOR i IN p_block_data.FIRST..p_block_data.LAST LOOP
753:
754: l_values := p_block_data(i);
755:
756: FTE_VALIDATION_PKG.VALIDATE_DESTINATION(p_values => l_values,
757: p_line_number => p_line_number+i+1,
758: p_price_prefix => g_chart_info(5),
759: p_carrier_id => TO_NUMBER(g_chart_info(7)),
760: p_origin_zone => g_origin_zone,

Line 782: l_dest_zone_name := g_origin_zone(FTE_VALIDATION_PKG.ZONE(2));

778:
779: l_dest_postal_from := g_postal_from;
780: l_dest_postal_to := g_postal_to;
781:
782: l_dest_zone_name := g_origin_zone(FTE_VALIDATION_PKG.ZONE(2));
783:
784: IF(FTE_BULKLOAD_PKG.g_debug_on) THEN
785: FTE_UTIL_PKG.WRITE_LogFile(l_module_name,'l_dest_zone_name',l_dest_zone_name);
786: END IF;

Line 808: IF (l_dest_zone_name = g_origin_zone(FTE_VALIDATION_PKG.ZONE(2))) THEN

804:
805: --+
806: -- l_name_value was not found in the g_dest_indexes table
807: --+
808: IF (l_dest_zone_name = g_origin_zone(FTE_VALIDATION_PKG.ZONE(2))) THEN
809: g_dest_indexes(g_dest_indexes.COUNT+1) := STRINGARRAY(l_name_value, g_dest_id);
810: l_dest_zone_name := l_dest_zone_name || '-' || g_dest_id;
811: g_dest_id := g_dest_id + 1;
812: END IF;

Line 837: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(1)) := 'ADD';

833:
834: END IF;
835:
836: l_count := g_dest_zones.COUNT+1;
837: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(1)) := 'ADD';
838: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(2)) := l_dest_zone_name;
839: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(5)) := l_dest_city;
840: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(4)) := l_dest_state;
841: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(3)) := l_dest_country;

Line 838: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(2)) := l_dest_zone_name;

834: END IF;
835:
836: l_count := g_dest_zones.COUNT+1;
837: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(1)) := 'ADD';
838: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(2)) := l_dest_zone_name;
839: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(5)) := l_dest_city;
840: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(4)) := l_dest_state;
841: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(3)) := l_dest_country;
842: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(6)) := l_dest_postal_from;

Line 839: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(5)) := l_dest_city;

835:
836: l_count := g_dest_zones.COUNT+1;
837: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(1)) := 'ADD';
838: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(2)) := l_dest_zone_name;
839: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(5)) := l_dest_city;
840: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(4)) := l_dest_state;
841: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(3)) := l_dest_country;
842: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(6)) := l_dest_postal_from;
843: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(7)) := l_dest_postal_to;

Line 840: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(4)) := l_dest_state;

836: l_count := g_dest_zones.COUNT+1;
837: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(1)) := 'ADD';
838: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(2)) := l_dest_zone_name;
839: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(5)) := l_dest_city;
840: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(4)) := l_dest_state;
841: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(3)) := l_dest_country;
842: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(6)) := l_dest_postal_from;
843: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(7)) := l_dest_postal_to;
844:

Line 841: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(3)) := l_dest_country;

837: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(1)) := 'ADD';
838: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(2)) := l_dest_zone_name;
839: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(5)) := l_dest_city;
840: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(4)) := l_dest_state;
841: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(3)) := l_dest_country;
842: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(6)) := l_dest_postal_from;
843: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(7)) := l_dest_postal_to;
844:
845: END LOOP;

Line 842: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(6)) := l_dest_postal_from;

838: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(2)) := l_dest_zone_name;
839: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(5)) := l_dest_city;
840: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(4)) := l_dest_state;
841: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(3)) := l_dest_country;
842: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(6)) := l_dest_postal_from;
843: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(7)) := l_dest_postal_to;
844:
845: END LOOP;
846:

Line 843: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(7)) := l_dest_postal_to;

839: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(5)) := l_dest_city;
840: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(4)) := l_dest_state;
841: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(3)) := l_dest_country;
842: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(6)) := l_dest_postal_from;
843: g_dest_zones(l_count)(FTE_VALIDATION_PKG.ZONE(7)) := l_dest_postal_to;
844:
845: END LOOP;
846:
847: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);