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.QPR_LOAD_MEAS_DATA dependencies on DBMS_UTILITY

Line 129: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

125: return(s_sql);
126: exception
127: when OTHERS then
128: log_debug('ERROR FORMING MEASURE SELECT...');
129: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
130: raise;
131: end get_select_meas_sql;
132:
133: procedure assign_val_to_ins(src_ctr in PLS_INTEGER) is

Line 193: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

189: r_insrecs.MEASURE_UOM(l_ins_ctr) := r_srcrecs.MEASURE_UOM(src_ctr);
190: exception
191: when OTHERS then
192: log_debug('ERROR ASSIGNING VALUES TO INSERT...');
193: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
194: raise;
195: end assign_val_to_ins;
196:
197: procedure assign_upd_measure_values(src_ctr in PLS_INTEGER) is

Line 243: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

239: r_updrecs.MEASURE_UOM(l_upd_ctr) := r_srcrecs.MEASURE_UOM(src_ctr);
240: exception
241: when OTHERS then
242: log_debug('ERROR ASSIGNING VALUES TO UPDATE...');
243: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
244: raise;
245: end assign_upd_measure_values;
246:
247: procedure delete_ins_rec_data is

Line 307: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

303: r_insrecs.MEASURE_UOM.delete;
304: exception
305: when OTHERS then
306: log_debug('ERROR CLEARING INSERT REC BUFFER...');
307: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
308: raise;
309: end delete_ins_rec_data;
310:
311: procedure delete_upd_rec_data is

Line 358: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

354: r_updrecs.MEASURE_UOM.delete;
355: exception
356: when OTHERS then
357: log_debug('ERROR CLEARING UPDATE REC BUFFER...');
358: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
359: raise;
360: end delete_upd_rec_data;
361:
362: procedure insert_measdata is

Line 500: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

496: g_request_id);
497: exception
498: when OTHERS then
499: log_debug('ERROR INSERTING FACT DATA...');
500: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
501: raise;
502: end insert_measdata;
503:
504: procedure update_measdata is

Line 559: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

555: where MEASURE_VALUE_ID = r_updrecs.MEASURE_VALUE_ID(i);
556: exception
557: when OTHERS then
558: log_debug( 'ERROR UPDATING FACT DATA... ');
559: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
560: raise;
561: end update_measdata;
562:
563: procedure insert_update_meas_data(p_date_from in varchar2,

Line 743: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

739: close c_srcdata;
740: exception
741: when OTHERS then
742: log_debug('ERROR INSERTING/UPDATING FACT DATA... ');
743: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
744: raise;
745: end insert_update_meas_data;
746:
747: function get_deal_sql(p_src_tbl_name in varchar2, p_tgt_tbl_name in varchar2)

Line 795: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

791: log_debug(p_tgt_tbl_name || ' definition not found');
792: raise;
793: when OTHERS then
794: log_debug('ERROR IN FORMING DEAL SQL');
795: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
796: raise;
797: end get_deal_sql;
798:
799: function insert_update_deal_hdr(

Line 965: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

961: return(l_req_int_hdr_id);
962: exception
963: when OTHERS then
964: log_debug('ERROR IN INSERTING/UPDATING DEAL INTERFACE HEADER');
965: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
966: raise;
967: end insert_update_deal_hdr;
968:
969: procedure assign_ins_deal_lines(p_qtn_ictr in number, p_src_ctr in number) is

Line 1096: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

1092:
1093: exception
1094: when OTHERS then
1095: log_debug('ERROR ASSIGNING VALUES TO INSERT IN INTERFACE LINE RECORD');
1096: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1097: raise;
1098: end assign_ins_deal_lines;
1099:
1100: procedure assign_upd_deal_lines(p_qtn_uctr in number, p_src_ctr in number,

Line 1229: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

1225:
1226: exception
1227: when OTHERS then
1228: log_debug('ERROR ASSIGNING VALUES TO UPDATE INTERFACE LINE RECORD');
1229: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1230: raise;
1231: end assign_upd_deal_lines;
1232:
1233: procedure del_ins_deal_lines is

Line 1293: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

1289:
1290: exception
1291: when OTHERS then
1292: log_debug('ERROR IN CLEARING INTERFACE LINE RECORD');
1293: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1294: raise;
1295: end del_ins_deal_lines;
1296:
1297: procedure del_upd_deal_lines is

Line 1358: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

1354:
1355: exception
1356: when OTHERS then
1357: log_debug('ERROR IN CLEARING INTERFACE LINE RECORD');
1358: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1359: raise;
1360: end del_upd_deal_lines;
1361:
1362: procedure insert_deal_lines(

Line 1499: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

1495: del_ins_deal_lines;
1496: exception
1497: when OTHERS then
1498: log_debug('ERROR INSERTING VALUES TO DEAL INTERFACE LINE');
1499: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1500: raise;
1501: end insert_deal_lines;
1502:
1503: procedure update_deal_lines is

Line 1573: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

1569: del_upd_deal_lines;
1570: exception
1571: when OTHERS then
1572: log_debug('ERROR IN UPDATING DEAL INTERFACE LINES');
1573: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1574: raise;
1575: end update_deal_lines;
1576:
1577: procedure insert_update_deal_lines(

Line 1663: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

1659: end loop;
1660: -- end if;
1661: exception
1662: when OTHERS then
1663: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1664: raise;
1665: end insert_update_deal_lines;
1666:
1667: procedure insert_deal_adjs(p_header_id in number, p_sql in varchar2) is

Line 1768: log_debug(dbms_utility.format_error_backtrace);

1764: t_adj_rec.delete;
1765: end loop;
1766: exception
1767: when OTHERS then
1768: log_debug(dbms_utility.format_error_backtrace);
1769: raise;
1770: end insert_deal_adjs;
1771:
1772: procedure fill_measure_data(errbuf out nocopy varchar2,

Line 1932: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

1928: when OTHERS then
1929: retcode := 2;
1930: errbuf := 'ERROR: ' || substr(sqlerrm, 1, 1000);
1931: log_debug('ERROR IN LOADING QUOTE DATA');
1932: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1933: raise;
1934: end;
1935:
1936: procedure load_quote_data_api(errbuf out nocopy varchar2,

Line 2012: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

2008: when OTHERS then
2009: retcode := 2;
2010: errbuf := 'ERROR: ' || substr(sqlerrm, 1, 1000);
2011: log_debug('ERROR IN LOADING QUOTE DATA');
2012: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
2013: raise;
2014: end load_quote_data_api;
2015:
2016: function is_source_quote_changed(errbuf out nocopy varchar2,