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

Line 124: insert into ece_error (creation_date, run_id, line_id, text)

120: EC_DEBUG.PL(3, 'stmt_1: ',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)

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 126: insert into ece_error (creation_date, run_id, line_id, text)

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);
130: end;

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 128: insert into ece_error (creation_date, run_id, line_id, text)

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;
132:

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 138: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);

134: exception
135: when others then
136: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_EXTRACT_UTILS_PUB.Select_Clause');
137: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','xProgress');
138: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
139: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
140:
141: EC_DEBUG.PL(0,'EC','ECE_PLSQL_POS_NOT_FOUND','COLUMN_NAME', 'to_char(g_error_count)');
142:

Line 139: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

135: when others then
136: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_EXTRACT_UTILS_PUB.Select_Clause');
137: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','xProgress');
138: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
139: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
140:
141: EC_DEBUG.PL(0,'EC','ECE_PLSQL_POS_NOT_FOUND','COLUMN_NAME', 'to_char(g_error_count)');
142:
143: if g_error_count > 0 then

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 516: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);

512: when others
513: then
514: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_EXTRACT_UTILS_PUB.Insert_into_Interface_tbl');
515: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','xProgress');
516: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
517: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
518:
519: EC_DEBUG.PL(0,'EC','ECE_PLSQL_POS_NOT_FOUND','COLUMN_NAME', 'to_char(g_error_count)');
520:

Line 517: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

513: then
514: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_EXTRACT_UTILS_PUB.Insert_into_Interface_tbl');
515: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','xProgress');
516: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
517: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
518:
519: EC_DEBUG.PL(0,'EC','ECE_PLSQL_POS_NOT_FOUND','COLUMN_NAME', 'to_char(g_error_count)');
520:
521: if g_error_count > 0 then

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 667: insert into ece_error (run_id, line_id, text) values

663: 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

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 687: insert into ece_error (run_id, line_id, text) values

683: 'b'||k,
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';

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 699: insert into ece_error (run_id, line_id, text) values

695: 1,
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;

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 713: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);

709: dummy := dbms_sql.execute(p_Insert_cur);
710: exception
711: when others then
712: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_EXTRACT_UTILS_PUB.insert_into_prod_interface');
713: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
714: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
715: EC_DEBUG.PL(0,'EC','ECE_PLSQL_POS_NOT_FOUND','COLUMN_NAME', g_error_count);
716:
717: if g_error_count > 0 then

Line 714: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

710: exception
711: when others then
712: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_EXTRACT_UTILS_PUB.insert_into_prod_interface');
713: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
714: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
715: EC_DEBUG.PL(0,'EC','ECE_PLSQL_POS_NOT_FOUND','COLUMN_NAME', g_error_count);
716:
717: if g_error_count > 0 then
718: EC_DEBUG.PL(0,'EC','ECE_PLSQL_VALUE','VALUE', p_apps_tbl(g_error_count).value);

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 910: ece_error_handling_pvt.print_parse_error(

906:
907: EXCEPTION
908: WHEN OTHERS THEN
909: ROLLBACK TO insert_into_prod_interface_pvt;
910: ece_error_handling_pvt.print_parse_error(
911: dbms_sql.last_error_position,
912: cInsert_stmt);
913: fnd_msg_pub.count_and_get(
914: p_count => x_msg_count,

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;

Line 990: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);

986:
987: EXCEPTION
988: WHEN OTHERS THEN
989: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_EXTRACT_UTILS_PUB.insert_into_prod_interface_pvt');
990: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
991: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
992:
993: EC_DEBUG.PL(0,'EC','ECE_PLSQL_POS_NOT_FOUND','COLUMN_NAME', 'to_char(g_error_count)');
994:

Line 991: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

987: EXCEPTION
988: WHEN OTHERS THEN
989: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_EXTRACT_UTILS_PUB.insert_into_prod_interface_pvt');
990: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
991: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
992:
993: EC_DEBUG.PL(0,'EC','ECE_PLSQL_POS_NOT_FOUND','COLUMN_NAME', 'to_char(g_error_count)');
994:
995: IF g_error_count > 0 THEN

Line 1049: ece_error_handling_pvt.print_parse_error(

1045: fnd_msg_pub.count_and_get(
1046: p_count => x_msg_count,
1047: p_data => x_msg_data);
1048: WHEN OTHERS THEN
1049: ece_error_handling_pvt.print_parse_error(
1050: dbms_sql.last_error_position,
1051: '');
1052: ROLLBACK TO insert_into_prod_interface_pvt;
1053: x_return_status := fnd_api.g_ret_sts_error;

Line 1108: ec_debug.pl(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);

1104: app_exception.raise_exception;
1105:
1106: WHEN OTHERS THEN
1107: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_EXTRACT_UTILS_PUB.FIND_POS');
1108: ec_debug.pl(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
1109: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1110: app_exception.raise_exception;
1111:
1112: END find_pos;

Line 1109: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

1105:
1106: WHEN OTHERS THEN
1107: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_EXTRACT_UTILS_PUB.FIND_POS');
1108: ec_debug.pl(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
1109: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1110: app_exception.raise_exception;
1111:
1112: END find_pos;
1113:

Line 1151: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);

1147: EC_DEBUG.PL(0,'EC','ECE_PLSQL_POS_NOT_FOUND','COLUMN_NAME', 'upper(cCol_name)');
1148: app_exception.raise_exception;
1149: WHEN OTHERS THEN
1150: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_EXTRACT_UTILS_PUB.POS_OF');
1151: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
1152: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1153: app_exception.raise_exception;
1154: END pos_of;
1155:

Line 1152: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

1148: app_exception.raise_exception;
1149: WHEN OTHERS THEN
1150: EC_DEBUG.PL(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_EXTRACT_UTILS_PUB.POS_OF');
1151: EC_DEBUG.PL(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
1152: EC_DEBUG.PL(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1153: app_exception.raise_exception;
1154: END pos_of;
1155:
1156: -- 2823215

Line 1200: ec_debug.pl(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);

1196: app_exception.raise_exception;
1197:
1198: WHEN OTHERS THEN
1199: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_EXTRACT_UTILS_PUB.EXT_GET_VALUE');
1200: ec_debug.pl(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
1201: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1202: app_exception.raise_exception;
1203: END ext_get_value;
1204:

Line 1201: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

1197:
1198: WHEN OTHERS THEN
1199: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_EXTRACT_UTILS_PUB.EXT_GET_VALUE');
1200: ec_debug.pl(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
1201: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1202: app_exception.raise_exception;
1203: END ext_get_value;
1204:
1205: PROCEDURE ext_insert_value(

Line 1225: ec_debug.pl(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);

1221:
1222: EXCEPTION
1223: WHEN OTHERS THEN
1224: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_EXTRACT_UTILS_PUB.EXT_INSERT_VALUE');
1225: ec_debug.pl(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
1226: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1227: app_exception.raise_exception;
1228: end ext_insert_value;
1229:

Line 1226: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);

1222: EXCEPTION
1223: WHEN OTHERS THEN
1224: ec_debug.pl(0,'EC','ECE_PROGRAM_ERROR','PROGRESS_LEVEL','ECE_EXTRACT_UTILS_PUB.EXT_INSERT_VALUE');
1225: ec_debug.pl(0,'EC','ECE_ERROR_CODE','ERROR_CODE',SQLCODE);
1226: ec_debug.pl(0,'EC','ECE_ERROR_MESSAGE','ERROR_MESSAGE',SQLERRM);
1227: app_exception.raise_exception;
1228: end ext_insert_value;
1229:
1230: END ece_extract_utils_pub;