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_COPY_PRICE_PLAN dependencies on DBMS_UTILITY

Line 219: fnd_file.put_line(fnd_file.log, DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

215: return(rec_dim_out);
216: exception
217: when OTHERS then
218: fnd_file.put_line(fnd_file.log, 'ERROR INSERTING DIMENSIONS...');
219: fnd_file.put_line(fnd_file.log, DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
220: raise;
221: end insert_dim_values;
222:
223: function insert_dim_attr_values(p_ppdim_id in number)

Line 264: fnd_file.put_line(fnd_file.log, DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

260: return(t_old_new_dim_attr);
261: exception
262: when OTHERS then
263: fnd_file.put_line(fnd_file.log, 'ERROR INSERTING DIMENSION ATTRIBUTES..');
264: fnd_file.put_line(fnd_file.log, DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
265: raise;
266: end insert_dim_attr_values;
267:
268: function insert_hier_values(p_ppdim_id in number) return val_out_type is

Line 301: fnd_file.put_line(fnd_file.log, DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

297: return(rec_hier_out);
298: exception
299: when OTHERS then
300: fnd_file.put_line(fnd_file.log, 'ERROR INSERTING HIERARCHIES...');
301: fnd_file.put_line(fnd_file.log, DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
302: raise;
303: end insert_hier_values;
304:
305: function insert_hier_lvl_val(p_hier_id in number) return num_type is

Line 346: fnd_file.put_line(fnd_file.log, DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

342: return(t_old_new_lvl);
343: exception
344: when OTHERS then
345: fnd_file.put_line(fnd_file.log, 'ERROR INSERTING HIERARCHY LEVELS...');
346: fnd_file.put_line(fnd_file.log, DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
347: raise;
348: end insert_hier_lvl_val;
349:
350: procedure insert_lvl_attributes is

Line 378: fnd_file.put_line(fnd_file.log, DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

374: g_prg_id, g_request_id);
375: exception
376: when OTHERS then
377: fnd_file.put_line(fnd_file.log, 'ERROR INSERTING LEVEL ATTRIBUTES...');
378: fnd_file.put_line(fnd_file.log, DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
379: raise;
380: end insert_lvl_attributes;
381:
382: function insert_cube_data return val_out_type is

Line 421: fnd_file.put_line(fnd_file.log, DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

417: return(r_cub_val_out);
418: exception
419: when OTHERS then
420: fnd_file.put_line(fnd_file.log, 'ERROR INSERTING CUBE DATA...');
421: fnd_file.put_line(fnd_file.log, DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
422: raise;
423: end insert_cube_data;
424:
425: function substitute_cube_code(p_calc_exp in varchar2) return varchar2 is

Line 570: fnd_file.put_line(fnd_file.log, DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

566: return t_meas_old_new_ids;
567: exception
568: when OTHERS then
569: fnd_file.put_line(fnd_file.log, 'ERROR INSERTING CUBE MEASURES...');
570: fnd_file.put_line(fnd_file.log, DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
571: raise;
572: end insert_cub_meas;
573:
574: function insert_cub_dims(p_cube_id in number,

Line 633: fnd_file.put_line(fnd_file.log, DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

629: return(t_old_new_cub_dim);
630: exception
631: when OTHERS then
632: fnd_file.put_line(fnd_file.log, 'ERROR INSERTING CUBE DIMENSIONS...');
633: fnd_file.put_line(fnd_file.log, DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
634: raise;
635: end insert_cub_dims;
636:
637: function insert_meas_aggr(p_old_new_cub_dim in num_type,

Line 747: fnd_file.put_line(fnd_file.log, DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

743: return(r_meas_set_lvl);
744: exception
745: when OTHERS then
746: fnd_file.put_line(fnd_file.log, 'ERROR INSERTING MEASURE AGGREGATION...');
747: fnd_file.put_line(fnd_file.log, DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
748: raise;
749: end insert_meas_aggr;
750:
751: procedure insert_set_level(p_old_new_cub_dim in num_type,

Line 824: fnd_file.put_line(fnd_file.log, DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

820: g_login_id, g_prg_appl_id, g_prg_id, g_request_id);
821: exception
822: when OTHERS then
823: fnd_file.put_line(fnd_file.log, 'ERROR INSERTING CUBE SET LEVEL... ');
824: fnd_file.put_line(fnd_file.log, DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
825: raise;
826: end insert_set_level;
827:
828: procedure clean_dimattrval is

Line 1205: fnd_file.put_line(fnd_file.log, DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

1201: return(l_ret);
1202: exception
1203: when OTHERS then
1204: fnd_file.put_line(fnd_file.log,'ERROR COPYING DIMENSION RELATED DATA...');
1205: fnd_file.put_line(fnd_file.log, DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1206: raise;
1207: return(-1);
1208: end copy_dim_data;
1209:

Line 1449: fnd_file.put_line(fnd_file.log, DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

1445: return(l_ret);
1446: exception
1447: when OTHERS then
1448: fnd_file.put_line(fnd_file.log, 'ERROR COPYING CUBE RELATED DATA...');
1449: fnd_file.put_line(fnd_file.log, DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1450: raise;
1451: return(-1);
1452: end copy_cube_data;
1453:

Line 1611: fnd_file.put_line(fnd_file.log, DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

1607: errbuf := 'ERROR: ' || substr(SQLERRM,1,1000);
1608: fnd_file.put_line(fnd_file.log,
1609: 'UNABLE TO COPY PRICEPLAN/DATMART DEFINITION');
1610: fnd_file.put_line(fnd_file.log, 'ERROR: ' || substr(SQLERRM,1,1000));
1611: fnd_file.put_line(fnd_file.log, DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
1612: rollback;
1613: end copy_price_plan;
1614:
1615: END;