DBA Data[Home] [Help]

APPS.ECE_UTILITIES dependencies on ECE_OUTPUT_LINES_S

Line 272: ece_output_lines_s.nextval,

268:
269: if bInsertErrors then
270: insert into ece_output (run_id,line_id,text)
271: values (iRun_id,
272: ece_output_lines_s.nextval,
273: x_msg);
274: end if;
275: end;
276:

Line 296: ece_output_lines_s.nextval,

292: if bInsertErrors then
293: x_msg := 'SEED: Document types for '||cTransaction_code||' not defined in ece_lookup_values';
294: insert into ece_output (run_id,line_id,text)
295: values (iRun_id,
296: ece_output_lines_s.nextval,
297: x_msg);
298: end if;
299:
300: when TOO_MANY_ROWS then

Line 338: ece_output_lines_s.nextval,

334: if bInsertErrors then
335: x_msg := 'SEED: Output level not defined in ECE_LOOKUP_VALUES: '||eit_rec.output_level;
336: insert into ece_output (run_id,line_id,text)
337: values (iRun_id,
338: ece_output_lines_s.nextval,
339: x_msg);
340: end if;
341: WHEN others then
342: bErrors_found := TRUE;

Line 347: ece_output_lines_s.nextval,

343: if bInsertErrors then
344: x_msg := 'SEED: Err in output_level check: '||SQLERRM;
345: insert into ece_output (run_id,line_id,text)
346: values (iRun_id,
347: ece_output_lines_s.nextval,
348: x_msg);
349: end if;
350: end;
351:

Line 405: ece_output_lines_s.nextval,

401: x_errcol := eic_rec.base_column_name;
402: x_msg := 'SEED: Column not found for '||x_errtbl ||'.'||x_errcol;
403: insert into ece_output (run_id,line_id,text)
404: values (iRun_id,
405: ece_output_lines_s.nextval,
406: x_msg);
407: end if;
408: END;
409: end if;

Line 456: ece_output_lines_s.nextval,

452: x_errcol := eic_rec.interface_column_name;
453: x_msg := 'SEED: Column not found for '||x_errtbl ||'.'||x_errcol;
454: insert into ece_output (run_id,line_id,text)
455: values (iRun_id,
456: ece_output_lines_s.nextval,
457: x_msg);
458: end if;
459: WHEN wrong_datatype THEN
460: bErrors_found := TRUE;

Line 472: ece_output_lines_s.nextval,

468: x_datatype;
469:
470: insert into ece_output (run_id,line_id,text)
471: values (iRun_id,
472: ece_output_lines_s.nextval,
473: x_msg);
474: end if;
475:
476: WHEN bad_width THEN

Line 487: ece_output_lines_s.nextval,

483: x_errcol||' too short. Seeded: '||eic_rec.width||' Database: '||x_width;
484:
485: insert into ece_output (run_id,line_id,text)
486: values (iRun_id,
487: ece_output_lines_s.nextval,
488: x_msg);
489: end if;
490: WHEN key_col_not_defined then
491: bErrors_found := TRUE;

Line 498: ece_output_lines_s.nextval,

494: x_errtbl := eic_rec.interface_table_name;
495: x_msg := 'SEED: Key column not defined for '||x_errtbl;
496: insert into ece_output (run_id,line_id,text)
497: values (iRun_id,
498: ece_output_lines_s.nextval,
499: x_msg);
500: end if;
501:
502: END;

Line 544: ece_output_lines_s.nextval,

540: x_errcol := eic_rec.base_column_name;
541: x_msg := 'SEED: Seeded column '||x_errtbl ||'.'||x_errcol||' not found.';
542: insert into ece_output (run_id,line_id,text)
543: values (iRun_id,
544: ece_output_lines_s.nextval,
545: x_msg);
546: end if;
547:
548: WHEN wrong_datatype THEN

Line 558: ece_output_lines_s.nextval,

554: x_errcol||' Seeded datatype: '||x_errdatatype||' Database datatype: '||
555: x_datatype;
556: insert into ece_output (run_id,line_id,text)
557: values (iRun_id,
558: ece_output_lines_s.nextval,
559: x_msg);
560: end if;
561:
562: WHEN bad_width THEN

Line 573: ece_output_lines_s.nextval,

569: x_errcol||' too short. Seeded: '||eic_rec.width||' Database: '||x_width;
570:
571: insert into ece_output (run_id,line_id,text)
572: values (iRun_id,
573: ece_output_lines_s.nextval,
574: x_msg);
575: end if;
576: END;
577: END IF; -- if ic_rec.base_table_name is NOT NULL