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.

[Home] [Help]

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 1225: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

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

Line 1289: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

1285:
1286: exception
1287: when OTHERS then
1288: log_debug('ERROR IN CLEARING INTERFACE LINE RECORD');
1289: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1290: raise;
1291: end del_ins_deal_lines;
1292:
1293: procedure del_upd_deal_lines is

Line 1354: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

1350:
1351: exception
1352: when OTHERS then
1353: log_debug('ERROR IN CLEARING INTERFACE LINE RECORD');
1354: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1355: raise;
1356: end del_upd_deal_lines;
1357:
1358: procedure insert_deal_lines(

Line 1495: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

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

Line 1569: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

1565: del_upd_deal_lines;
1566: exception
1567: when OTHERS then
1568: log_debug('ERROR IN UPDATING DEAL INTERFACE LINES');
1569: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1570: raise;
1571: end update_deal_lines;
1572:
1573: procedure insert_update_deal_lines(

Line 1650: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

1646: end loop;
1647: -- end if;
1648: exception
1649: when OTHERS then
1650: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1651: raise;
1652: end insert_update_deal_lines;
1653:
1654: procedure insert_deal_adjs(p_header_id in number, p_sql in varchar2) is

Line 1755: log_debug(dbms_utility.format_error_backtrace);

1751: t_adj_rec.delete;
1752: end loop;
1753: exception
1754: when OTHERS then
1755: log_debug(dbms_utility.format_error_backtrace);
1756: raise;
1757: end insert_deal_adjs;
1758:
1759: procedure fill_measure_data(errbuf out nocopy varchar2,

Line 1919: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

1915: when OTHERS then
1916: retcode := 2;
1917: errbuf := 'ERROR: ' || substr(sqlerrm, 1, 1000);
1918: log_debug('ERROR IN LOADING QUOTE DATA');
1919: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1920: raise;
1921: end;
1922:
1923: procedure load_quote_data_api(errbuf out nocopy varchar2,

Line 1999: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

1995: when OTHERS then
1996: retcode := 2;
1997: errbuf := 'ERROR: ' || substr(sqlerrm, 1, 1000);
1998: log_debug('ERROR IN LOADING QUOTE DATA');
1999: log_debug(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
2000: raise;
2001: end load_quote_data_api;
2002:
2003: function is_source_quote_changed(errbuf out nocopy varchar2,