APPS.QPR_COLLECT_UOM_DATA dependencies on FND_FILE

Line 46: fnd_file.put_line(fnd_file.log, 'ERROR INSERTING UOM_DATA...');

42: sys_date, user_id, sys_date, user_id,
43: login_id, prg_appl_id, prg_id, request_id) ;
44: exception
45: when OTHERS then
46: fnd_file.put_line(fnd_file.log, 'ERROR INSERTING UOM_DATA...');
47: fnd_file.put_line(fnd_file.log, DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
48: raise;
49: end insert_uom_data;
50:

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

43: login_id, prg_appl_id, prg_id, request_id) ;
44: exception
45: when OTHERS then
46: fnd_file.put_line(fnd_file.log, 'ERROR INSERTING UOM_DATA...');
47: fnd_file.put_line(fnd_file.log, DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
48: raise;
49: end insert_uom_data;
50:
51: procedure collect_uom_data(errbuf out nocopy varchar2,

Line 73: fnd_file.put_line(fnd_file.log,

69: open c_get_uom_data for s_sql;
70: loop
71: fetch c_get_uom_data bulk collect into r_uom_data limit nrows;
72: exit when r_uom_data.FROM_UOM_CLASS.count = 0;
73: fnd_file.put_line(fnd_file.log,
74: 'Record count: ' || r_uom_data.FROM_UOM_CLASS.count);
75: insert_uom_data(p_instance_id);
76: bfound := true;
77: end loop;

Line 80: fnd_file.put_line(fnd_file.log, 'No data retrieved from source');

76: bfound := true;
77: end loop;
78: commit;
79: if bfound = false then
80: fnd_file.put_line(fnd_file.log, 'No data retrieved from source');
81: end if;
82: else
83: fnd_file.put_line(fnd_file.log,
84: 'Rates not fetched to ODS as parameter QPR_PULL_UOM_CONV_TO_ODS is No/not set');

Line 83: fnd_file.put_line(fnd_file.log,

79: if bfound = false then
80: fnd_file.put_line(fnd_file.log, 'No data retrieved from source');
81: end if;
82: else
83: fnd_file.put_line(fnd_file.log,
84: 'Rates not fetched to ODS as parameter QPR_PULL_UOM_CONV_TO_ODS is No/not set');
85: end if;
86: exception
87: when OTHERS then

Line 90: fnd_file.put_line(fnd_file.log, substr(sqlerrm, 1, 1000));

86: exception
87: when OTHERS then
88: retcode := -1;
89: errbuf := 'ERROR: ' || substr(sqlerrm, 1, 1000);
90: fnd_file.put_line(fnd_file.log, substr(sqlerrm, 1, 1000));
91: fnd_file.put_line(fnd_file.log, 'CANNOT POPULATE UOM CONVERSION DATA');
92: rollback;
93: end collect_uom_data;
94: END;

Line 91: fnd_file.put_line(fnd_file.log, 'CANNOT POPULATE UOM CONVERSION DATA');

87: when OTHERS then
88: retcode := -1;
89: errbuf := 'ERROR: ' || substr(sqlerrm, 1, 1000);
90: fnd_file.put_line(fnd_file.log, substr(sqlerrm, 1, 1000));
91: fnd_file.put_line(fnd_file.log, 'CANNOT POPULATE UOM CONVERSION DATA');
92: rollback;
93: end collect_uom_data;
94: END;
95: