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_COLLECT_TIME_DATA dependencies on FND_FILE

Line 120: fnd_file.put_line(fnd_file.log, 'ERROR INSERTING TIME DATA');

116: prg_appl_id, prg_id, request_id);
117: clean_time_data;
118: exception
119: when OTHERS then
120: fnd_file.put_line(fnd_file.log, 'ERROR INSERTING TIME DATA');
121: fnd_file.put_line(fnd_file.log, DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
122: raise;
123: end insert_time_data;
124:

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

117: clean_time_data;
118: exception
119: when OTHERS then
120: fnd_file.put_line(fnd_file.log, 'ERROR INSERTING TIME DATA');
121: fnd_file.put_line(fnd_file.log, DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
122: raise;
123: end insert_time_data;
124:
125: procedure explode_fiscal_cal(p_instance_id in number) is

Line 134: fnd_file.put_line(fnd_file.log,

130: l_rec_ctr PLS_INTEGER := 0;
131: begin
132: for i in r_fis_cal.YEAR.first..r_fis_cal.YEAR.last loop
133: if prev_year is not null and prev_year <> r_fis_cal.YEAR(i) then
134: fnd_file.put_line(fnd_file.log,
135: 'Inserting values for fiscal year ' || prev_year || ' of calendar code '
136: || prev_cal_code);
137: insert_time_data(p_instance_id, FISCAL_CALENDAR);
138: l_rec_ctr := 0;

Line 163: fnd_file.put_line(fnd_file.log,

159: r_time_data.DAY_DESC(l_rec_ctr) := r_fis_cal.MONTH_STDT(i) + j;
160: end loop;
161: end loop;
162: if prev_year = r_fis_cal.YEAR(r_fis_cal.YEAR.last) then
163: fnd_file.put_line(fnd_file.log,
164: 'Inserting values for fiscal year ' || prev_year || ' of calendar code '
165: || prev_cal_code);
166: insert_time_data(p_instance_id, FISCAL_CALENDAR);
167: end if;

Line 170: fnd_file.put_line(fnd_file.log, 'ERROR EXPLODING FISCAL CALENDAR VALUES');

166: insert_time_data(p_instance_id, FISCAL_CALENDAR);
167: end if;
168: exception
169: when OTHERS then
170: fnd_file.put_line(fnd_file.log, 'ERROR EXPLODING FISCAL CALENDAR VALUES');
171: fnd_file.put_line(fnd_file.log, DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
172: raise;
173: end explode_fiscal_cal;
174:

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

167: end if;
168: exception
169: when OTHERS then
170: fnd_file.put_line(fnd_file.log, 'ERROR EXPLODING FISCAL CALENDAR VALUES');
171: fnd_file.put_line(fnd_file.log, DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
172: raise;
173: end explode_fiscal_cal;
174:
175: procedure decode_quarter(p_month in varchar2, p_year in varchar2,

Line 275: fnd_file.put_line(fnd_file.log,

271: s_qtr varchar2(15);
272: s_stdt varchar2(15);
273: s_etdt varchar2(15);
274: begin
275: fnd_file.put_line(fnd_file.log,
276: 'Building Gregorian Calendar for dates between ' || p_date_from || ' and '||
277: p_date_to);
278: l_num_days := (p_date_to - p_date_from) + 1;
279: l_loop_ctr := ceil(l_num_days/nrows);

Line 327: fnd_file.put_line(fnd_file.log, 'ERROR BUILDING GREGORIAN CALENDAR');

323: insert_time_data(-1, GREGORIAN_CALENDAR);
324: end loop;
325: exception
326: when OTHERS then
327: fnd_file.put_line(fnd_file.log, 'ERROR BUILDING GREGORIAN CALENDAR');
328: fnd_file.put_line(fnd_file.log, DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
329: raise;
330: end build_gregorian_cal;
331:

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

324: end loop;
325: exception
326: when OTHERS then
327: fnd_file.put_line(fnd_file.log, 'ERROR BUILDING GREGORIAN CALENDAR');
328: fnd_file.put_line(fnd_file.log, DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
329: raise;
330: end build_gregorian_cal;
331:
332: procedure collect_time_data(errbuf out nocopy varchar2,

Line 379: fnd_file.put_line(fnd_file.log, 'There does not exist calendar: '||p_calendar_code||' for the specified instance.');

375: fetch c_check_cal_code into l_count_cal;
376: close c_check_cal_code;
377:
378: if (l_count_cal = 0) then
379: fnd_file.put_line(fnd_file.log, 'There does not exist calendar: '||p_calendar_code||' for the specified instance.');
380: retcode := 1;
381: end if;
382:
383: -- End of modification to handle bug 5920571

Line 422: fnd_file.put_line(fnd_file.log,

418: bfound := true;
419: end loop;
420: close c_get_cal_data;
421: if bfound = false then
422: fnd_file.put_line(fnd_file.log,
423: 'No data retrieved from source for given date range and calendar code');
424: end if;
425: else
426: raise UNSUP_CAL_TYPE;

Line 433: fnd_file.put_line(fnd_file.log, ' UNSUPPORTED CALENDAR TYPE');

429: exception
430: when UNSUP_CAL_TYPE then
431: retcode := -1;
432: errbuf := 'ERROR: UNSUPPORTED CALENDAR TYPE';
433: fnd_file.put_line(fnd_file.log, ' UNSUPPORTED CALENDAR TYPE');
434: when OTHERS then
435: retcode := -1;
436: errbuf := 'ERROR: ' || substr(sqlerrm, 1, 1000);
437: fnd_file.put_line(fnd_file.log, substr(sqlerrm, 1, 1000));

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

433: fnd_file.put_line(fnd_file.log, ' UNSUPPORTED CALENDAR TYPE');
434: when OTHERS then
435: retcode := -1;
436: errbuf := 'ERROR: ' || substr(sqlerrm, 1, 1000);
437: fnd_file.put_line(fnd_file.log, substr(sqlerrm, 1, 1000));
438: fnd_file.put_line(fnd_file.log, 'CANNOT POPULATE CALENDAR DATA');
439: rollback;
440: end collect_time_data;
441: END;

Line 438: fnd_file.put_line(fnd_file.log, 'CANNOT POPULATE CALENDAR DATA');

434: when OTHERS then
435: retcode := -1;
436: errbuf := 'ERROR: ' || substr(sqlerrm, 1, 1000);
437: fnd_file.put_line(fnd_file.log, substr(sqlerrm, 1, 1000));
438: fnd_file.put_line(fnd_file.log, 'CANNOT POPULATE CALENDAR DATA');
439: rollback;
440: end collect_time_data;
441: END;
442: