APPS.QPR_COLLECT_CURRENCY_DATA dependencies on FND_FILE

Line 41: fnd_file.put_line(fnd_file.log, 'ERROR INSERTING CURRENCT RATE DATA...');

37: p_instance_id, sys_date, user_id, sys_date, user_id,
38: login_id, prg_appl_id, prg_id, request_id) ;
39: exception
40: when OTHERS then
41: fnd_file.put_line(fnd_file.log, 'ERROR INSERTING CURRENCT RATE DATA...');
42: fnd_file.put_line(fnd_file.log, DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
43: raise;
44: end insert_curr_rate_data;
45:

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

38: login_id, prg_appl_id, prg_id, request_id) ;
39: exception
40: when OTHERS then
41: fnd_file.put_line(fnd_file.log, 'ERROR INSERTING CURRENCT RATE DATA...');
42: fnd_file.put_line(fnd_file.log, DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
43: raise;
44: end insert_curr_rate_data;
45:
46: procedure collect_currency_rates(errbuf out nocopy varchar2,

Line 81: fnd_file.put_line(fnd_file.log,

77: open c_get_curr_rate for s_sql using s_conv_type, date_from, date_to;
78: loop
79: fetch c_get_curr_rate bulk collect into r_curr_data limit nrows;
80: exit when r_curr_data.FROM_CURRENCY.count = 0;
81: fnd_file.put_line(fnd_file.log,
82: 'Record count: ' || r_curr_data.FROM_CURRENCY.count);
83: insert_curr_rate_data(p_instance_id);
84: bfound := true;
85: end loop;

Line 89: fnd_file.put_line(fnd_file.log,

85: end loop;
86: commit;
87:
88: if bfound = false then
89: fnd_file.put_line(fnd_file.log,
90: 'No data retrieved from source for given date range');
91: end if;
92: else
93: fnd_file.put_line(fnd_file.log,

Line 93: fnd_file.put_line(fnd_file.log,

89: fnd_file.put_line(fnd_file.log,
90: 'No data retrieved from source for given date range');
91: end if;
92: else
93: fnd_file.put_line(fnd_file.log,
94: 'Rates not fetched to ODS as parameter QPR_PULL_CURR_CONV_TO_ODS is No/not set');
95: end if;
96: exception
97: when OTHERS then

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

96: exception
97: when OTHERS then
98: retcode := -1;
99: errbuf := 'ERROR: ' || substr(sqlerrm, 1, 1000);
100: fnd_file.put_line(fnd_file.log, substr(sqlerrm, 1, 1000));
101: fnd_file.put_line(fnd_file.log, 'CANNOT POPULATE CURRENCY RATES');
102: rollback;
103: end collect_currency_rates;
104: END;

Line 101: fnd_file.put_line(fnd_file.log, 'CANNOT POPULATE CURRENCY RATES');

97: when OTHERS then
98: retcode := -1;
99: errbuf := 'ERROR: ' || substr(sqlerrm, 1, 1000);
100: fnd_file.put_line(fnd_file.log, substr(sqlerrm, 1, 1000));
101: fnd_file.put_line(fnd_file.log, 'CANNOT POPULATE CURRENCY RATES');
102: rollback;
103: end collect_currency_rates;
104: END;
105: