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.ECE_EXTRACT_UTILS_PUB dependencies on ECE_ERROR_S

Line 125: values( sysdate, 76451, ece_error_s.nextval, stmt_1);

121: EC_DEBUG.PL(3, 'stmt_2: ',stmt_2);
122: EC_DEBUG.PL(3, 'stmt_3: ',stmt_3);
123: end if;
124: insert into ece_error (creation_date, run_id, line_id, text)
125: values( sysdate, 76451, ece_error_s.nextval, stmt_1);
126: insert into ece_error (creation_date, run_id, line_id, text)
127: values( sysdate, 76451, ece_error_s.nextval, stmt_2);
128: insert into ece_error (creation_date, run_id, line_id, text)
129: values( sysdate, 76451, ece_error_s.nextval, stmt_3);

Line 127: values( sysdate, 76451, ece_error_s.nextval, stmt_2);

123: end if;
124: insert into ece_error (creation_date, run_id, line_id, text)
125: values( sysdate, 76451, ece_error_s.nextval, stmt_1);
126: insert into ece_error (creation_date, run_id, line_id, text)
127: values( sysdate, 76451, ece_error_s.nextval, stmt_2);
128: insert into ece_error (creation_date, run_id, line_id, text)
129: values( sysdate, 76451, ece_error_s.nextval, stmt_3);
130: end;
131: end if;

Line 129: values( sysdate, 76451, ece_error_s.nextval, stmt_3);

125: values( sysdate, 76451, ece_error_s.nextval, stmt_1);
126: insert into ece_error (creation_date, run_id, line_id, text)
127: values( sysdate, 76451, ece_error_s.nextval, stmt_2);
128: insert into ece_error (creation_date, run_id, line_id, text)
129: values( sysdate, 76451, ece_error_s.nextval, stmt_3);
130: end;
131: end if;
132:
133: EC_DEBUG.POP('ece_extract_utils_pub.select_clause');

Line 496: insert into ece_error (run_id, line_id, text) values( 478, ece_error_s.nextval, stmt_1);

492: EC_DEBUG.PL(3, 'stmt_3: ',stmt_3);
493: EC_DEBUG.PL(3, 'stmt_4: ',stmt_4);
494: EC_DEBUG.PL(3, 'stmt_5: ',stmt_5);
495: end if;
496: insert into ece_error (run_id, line_id, text) values( 478, ece_error_s.nextval, stmt_1);
497: insert into ece_error (run_id, line_id, text) values( 478, ece_error_s.nextval, stmt_2);
498: insert into ece_error (run_id, line_id, text) values( 478, ece_error_s.nextval, stmt_3);
499: insert into ece_error (run_id, line_id, text) values( 478, ece_error_s.nextval, stmt_4);
500: insert into ece_error (run_id, line_id, text) values( 478, ece_error_s.nextval, stmt_5);

Line 497: insert into ece_error (run_id, line_id, text) values( 478, ece_error_s.nextval, stmt_2);

493: EC_DEBUG.PL(3, 'stmt_4: ',stmt_4);
494: EC_DEBUG.PL(3, 'stmt_5: ',stmt_5);
495: end if;
496: insert into ece_error (run_id, line_id, text) values( 478, ece_error_s.nextval, stmt_1);
497: insert into ece_error (run_id, line_id, text) values( 478, ece_error_s.nextval, stmt_2);
498: insert into ece_error (run_id, line_id, text) values( 478, ece_error_s.nextval, stmt_3);
499: insert into ece_error (run_id, line_id, text) values( 478, ece_error_s.nextval, stmt_4);
500: insert into ece_error (run_id, line_id, text) values( 478, ece_error_s.nextval, stmt_5);
501: end;

Line 498: insert into ece_error (run_id, line_id, text) values( 478, ece_error_s.nextval, stmt_3);

494: EC_DEBUG.PL(3, 'stmt_5: ',stmt_5);
495: end if;
496: insert into ece_error (run_id, line_id, text) values( 478, ece_error_s.nextval, stmt_1);
497: insert into ece_error (run_id, line_id, text) values( 478, ece_error_s.nextval, stmt_2);
498: insert into ece_error (run_id, line_id, text) values( 478, ece_error_s.nextval, stmt_3);
499: insert into ece_error (run_id, line_id, text) values( 478, ece_error_s.nextval, stmt_4);
500: insert into ece_error (run_id, line_id, text) values( 478, ece_error_s.nextval, stmt_5);
501: end;
502: --commit;

Line 499: insert into ece_error (run_id, line_id, text) values( 478, ece_error_s.nextval, stmt_4);

495: end if;
496: insert into ece_error (run_id, line_id, text) values( 478, ece_error_s.nextval, stmt_1);
497: insert into ece_error (run_id, line_id, text) values( 478, ece_error_s.nextval, stmt_2);
498: insert into ece_error (run_id, line_id, text) values( 478, ece_error_s.nextval, stmt_3);
499: insert into ece_error (run_id, line_id, text) values( 478, ece_error_s.nextval, stmt_4);
500: insert into ece_error (run_id, line_id, text) values( 478, ece_error_s.nextval, stmt_5);
501: end;
502: --commit;
503: end if;

Line 500: insert into ece_error (run_id, line_id, text) values( 478, ece_error_s.nextval, stmt_5);

496: insert into ece_error (run_id, line_id, text) values( 478, ece_error_s.nextval, stmt_1);
497: insert into ece_error (run_id, line_id, text) values( 478, ece_error_s.nextval, stmt_2);
498: insert into ece_error (run_id, line_id, text) values( 478, ece_error_s.nextval, stmt_3);
499: insert into ece_error (run_id, line_id, text) values( 478, ece_error_s.nextval, stmt_4);
500: insert into ece_error (run_id, line_id, text) values( 478, ece_error_s.nextval, stmt_5);
501: end;
502: --commit;
503: end if;
504:

Line 617: insert into ece_error (run_id, line_id, text) values( 78, ece_error_s.nextval, stmt_1);

613: stmt_3 varchar2(2000) := substrb(cInsert_stmt, 4001, 2000);
614: stmt_4 varchar2(2000) := substrb(cInsert_stmt, 6001, 2000);
615: stmt_5 varchar2(2000) := substrb(cInsert_stmt, 8001, 2000);
616: begin
617: insert into ece_error (run_id, line_id, text) values( 78, ece_error_s.nextval, stmt_1);
618: insert into ece_error (run_id, line_id, text) values( 78, ece_error_s.nextval, stmt_2);
619: insert into ece_error (run_id, line_id, text) values( 78, ece_error_s.nextval, stmt_3);
620: insert into ece_error (run_id, line_id, text) values( 78, ece_error_s.nextval, stmt_4);
621: insert into ece_error (run_id, line_id, text) values( 78, ece_error_s.nextval, stmt_5);

Line 618: insert into ece_error (run_id, line_id, text) values( 78, ece_error_s.nextval, stmt_2);

614: stmt_4 varchar2(2000) := substrb(cInsert_stmt, 6001, 2000);
615: stmt_5 varchar2(2000) := substrb(cInsert_stmt, 8001, 2000);
616: begin
617: insert into ece_error (run_id, line_id, text) values( 78, ece_error_s.nextval, stmt_1);
618: insert into ece_error (run_id, line_id, text) values( 78, ece_error_s.nextval, stmt_2);
619: insert into ece_error (run_id, line_id, text) values( 78, ece_error_s.nextval, stmt_3);
620: insert into ece_error (run_id, line_id, text) values( 78, ece_error_s.nextval, stmt_4);
621: insert into ece_error (run_id, line_id, text) values( 78, ece_error_s.nextval, stmt_5);
622: end;

Line 619: insert into ece_error (run_id, line_id, text) values( 78, ece_error_s.nextval, stmt_3);

615: stmt_5 varchar2(2000) := substrb(cInsert_stmt, 8001, 2000);
616: begin
617: insert into ece_error (run_id, line_id, text) values( 78, ece_error_s.nextval, stmt_1);
618: insert into ece_error (run_id, line_id, text) values( 78, ece_error_s.nextval, stmt_2);
619: insert into ece_error (run_id, line_id, text) values( 78, ece_error_s.nextval, stmt_3);
620: insert into ece_error (run_id, line_id, text) values( 78, ece_error_s.nextval, stmt_4);
621: insert into ece_error (run_id, line_id, text) values( 78, ece_error_s.nextval, stmt_5);
622: end;
623: --commit;

Line 620: insert into ece_error (run_id, line_id, text) values( 78, ece_error_s.nextval, stmt_4);

616: begin
617: insert into ece_error (run_id, line_id, text) values( 78, ece_error_s.nextval, stmt_1);
618: insert into ece_error (run_id, line_id, text) values( 78, ece_error_s.nextval, stmt_2);
619: insert into ece_error (run_id, line_id, text) values( 78, ece_error_s.nextval, stmt_3);
620: insert into ece_error (run_id, line_id, text) values( 78, ece_error_s.nextval, stmt_4);
621: insert into ece_error (run_id, line_id, text) values( 78, ece_error_s.nextval, stmt_5);
622: end;
623: --commit;
624: end if;

Line 621: insert into ece_error (run_id, line_id, text) values( 78, ece_error_s.nextval, stmt_5);

617: insert into ece_error (run_id, line_id, text) values( 78, ece_error_s.nextval, stmt_1);
618: insert into ece_error (run_id, line_id, text) values( 78, ece_error_s.nextval, stmt_2);
619: insert into ece_error (run_id, line_id, text) values( 78, ece_error_s.nextval, stmt_3);
620: insert into ece_error (run_id, line_id, text) values( 78, ece_error_s.nextval, stmt_4);
621: insert into ece_error (run_id, line_id, text) values( 78, ece_error_s.nextval, stmt_5);
622: end;
623: --commit;
624: end if;
625:

Line 668: ( 88, ece_error_s.nextval, 'b' ||k|| ' = '||d_date);

664:
665: if (debug_mode_on_prod)
666: then
667: insert into ece_error (run_id, line_id, text) values
668: ( 88, ece_error_s.nextval, 'b' ||k|| ' = '||d_date);
669: end if;
670: elsif 'NUMBER' = p_apps_tbl(k).data_type
671: then
672: xProgress := 'EXTUB-30-1230';

Line 688: ( 88, ece_error_s.nextval, 'b'||k|| ' ='||n_number);

684: n_number);
685: if (debug_mode_on_prod)
686: then
687: insert into ece_error (run_id, line_id, text) values
688: ( 88, ece_error_s.nextval, 'b'||k|| ' ='||n_number);
689: end if;
690: else
691: xProgress := 'EXTUB-30-1270';
692: dbms_sql.bind_variable(p_Insert_cur,

Line 700: ( 88, ece_error_s.nextval, 'b'||k|| ' ='||p_apps_tbl(k).value);

696: p_apps_tbl(k).data_length));
697: if (debug_mode_on_prod)
698: then
699: insert into ece_error (run_id, line_id, text) values
700: ( 88, ece_error_s.nextval, 'b'||k|| ' ='||p_apps_tbl(k).value);
701: end if;
702: end if;
703: --commit;
704: end if;

Line 893: INSERT INTO ece_error(run_id,line_id,text) VALUES(78,ece_error_s.NEXTVAL,stmt_1);

889: EC_DEBUG.PL(3, 'stmt_3: ',stmt_3);
890: EC_DEBUG.PL(3, 'stmt_4: ',stmt_4);
891: EC_DEBUG.PL(3, 'stmt_5: ',stmt_5);
892: end if;
893: INSERT INTO ece_error(run_id,line_id,text) VALUES(78,ece_error_s.NEXTVAL,stmt_1);
894: INSERT INTO ece_error(run_id,line_id,text) VALUES(78,ece_error_s.NEXTVAL,stmt_2);
895: INSERT INTO ece_error(run_id,line_id,text) VALUES(78,ece_error_s.NEXTVAL,stmt_3);
896: INSERT INTO ece_error(run_id,line_id,text) VALUES(78,ece_error_s.NEXTVAL,stmt_4);
897: INSERT INTO ece_error(run_id,line_id,text) VALUES(78,ece_error_s.NEXTVAL,stmt_5);

Line 894: INSERT INTO ece_error(run_id,line_id,text) VALUES(78,ece_error_s.NEXTVAL,stmt_2);

890: EC_DEBUG.PL(3, 'stmt_4: ',stmt_4);
891: EC_DEBUG.PL(3, 'stmt_5: ',stmt_5);
892: end if;
893: INSERT INTO ece_error(run_id,line_id,text) VALUES(78,ece_error_s.NEXTVAL,stmt_1);
894: INSERT INTO ece_error(run_id,line_id,text) VALUES(78,ece_error_s.NEXTVAL,stmt_2);
895: INSERT INTO ece_error(run_id,line_id,text) VALUES(78,ece_error_s.NEXTVAL,stmt_3);
896: INSERT INTO ece_error(run_id,line_id,text) VALUES(78,ece_error_s.NEXTVAL,stmt_4);
897: INSERT INTO ece_error(run_id,line_id,text) VALUES(78,ece_error_s.NEXTVAL,stmt_5);
898: END;

Line 895: INSERT INTO ece_error(run_id,line_id,text) VALUES(78,ece_error_s.NEXTVAL,stmt_3);

891: EC_DEBUG.PL(3, 'stmt_5: ',stmt_5);
892: end if;
893: INSERT INTO ece_error(run_id,line_id,text) VALUES(78,ece_error_s.NEXTVAL,stmt_1);
894: INSERT INTO ece_error(run_id,line_id,text) VALUES(78,ece_error_s.NEXTVAL,stmt_2);
895: INSERT INTO ece_error(run_id,line_id,text) VALUES(78,ece_error_s.NEXTVAL,stmt_3);
896: INSERT INTO ece_error(run_id,line_id,text) VALUES(78,ece_error_s.NEXTVAL,stmt_4);
897: INSERT INTO ece_error(run_id,line_id,text) VALUES(78,ece_error_s.NEXTVAL,stmt_5);
898: END;
899: -- COMMIT;

Line 896: INSERT INTO ece_error(run_id,line_id,text) VALUES(78,ece_error_s.NEXTVAL,stmt_4);

892: end if;
893: INSERT INTO ece_error(run_id,line_id,text) VALUES(78,ece_error_s.NEXTVAL,stmt_1);
894: INSERT INTO ece_error(run_id,line_id,text) VALUES(78,ece_error_s.NEXTVAL,stmt_2);
895: INSERT INTO ece_error(run_id,line_id,text) VALUES(78,ece_error_s.NEXTVAL,stmt_3);
896: INSERT INTO ece_error(run_id,line_id,text) VALUES(78,ece_error_s.NEXTVAL,stmt_4);
897: INSERT INTO ece_error(run_id,line_id,text) VALUES(78,ece_error_s.NEXTVAL,stmt_5);
898: END;
899: -- COMMIT;
900: END IF;

Line 897: INSERT INTO ece_error(run_id,line_id,text) VALUES(78,ece_error_s.NEXTVAL,stmt_5);

893: INSERT INTO ece_error(run_id,line_id,text) VALUES(78,ece_error_s.NEXTVAL,stmt_1);
894: INSERT INTO ece_error(run_id,line_id,text) VALUES(78,ece_error_s.NEXTVAL,stmt_2);
895: INSERT INTO ece_error(run_id,line_id,text) VALUES(78,ece_error_s.NEXTVAL,stmt_3);
896: INSERT INTO ece_error(run_id,line_id,text) VALUES(78,ece_error_s.NEXTVAL,stmt_4);
897: INSERT INTO ece_error(run_id,line_id,text) VALUES(78,ece_error_s.NEXTVAL,stmt_5);
898: END;
899: -- COMMIT;
900: END IF;
901:

Line 950: INSERT INTO ece_error(run_id,line_id,text) VALUES(88,ece_error_s.NEXTVAL,'b' || k || ' = ' || d_date);

946: xProgress := 'EXTUB-30-1220';
947: dbms_sql.bind_variable(p_Insert_cur,'b'|| k,d_date);
948:
949: IF debug_mode_on_prod THEN
950: INSERT INTO ece_error(run_id,line_id,text) VALUES(88,ece_error_s.NEXTVAL,'b' || k || ' = ' || d_date);
951: END IF;
952: ELSIF 'NUMBER' = p_apps_tbl(k).data_type THEN
953: xProgress := 'EXTUB-30-1230';
954: IF p_apps_tbl(k).value IS NOT NULL THEN

Line 969: INSERT INTO ece_error(run_id,line_id,text) VALUES(88,ece_error_s.NEXTVAL,'b' || k || ' =' || n_number);

965: xProgress := 'EXTUB-30-1260';
966: dbms_sql.bind_variable(p_Insert_cur,'b' || k,n_number);
967:
968: IF debug_mode_on_prod THEN
969: INSERT INTO ece_error(run_id,line_id,text) VALUES(88,ece_error_s.NEXTVAL,'b' || k || ' =' || n_number);
970: END IF;
971: ELSE
972: xProgress := 'EXTUB-30-1270';
973: dbms_sql.bind_variable(p_Insert_cur,'b' || k,SUBSTR(p_apps_tbl(k).value,1,p_apps_tbl(k).data_length));

Line 976: INSERT INTO ece_error(run_id,line_id,text) VALUES(88,ece_error_s.NEXTVAL,'b' || k || ' =' || p_apps_tbl(k).value);

972: xProgress := 'EXTUB-30-1270';
973: dbms_sql.bind_variable(p_Insert_cur,'b' || k,SUBSTR(p_apps_tbl(k).value,1,p_apps_tbl(k).data_length));
974:
975: IF debug_mode_on_prod THEN
976: INSERT INTO ece_error(run_id,line_id,text) VALUES(88,ece_error_s.NEXTVAL,'b' || k || ' =' || p_apps_tbl(k).value);
977: END IF;
978: END IF;
979:
980: --commit;