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.FII_TIME_API dependencies on FND_FILE

Line 1319: -- for fnd_file.

1315: -- It returns 1 boolean: has_missing_date
1316: -- It also prints out message in the output file if there's gap;
1317: -- in particular, the minimum and maximum of these missing dates.
1318: -- This procedure requires the setup of files and directory
1319: -- for fnd_file.
1320: -- Output: true/false
1321: -- Error: If any sql error occurs, will report it to the log file;
1322: -- and an exception is raised.
1323: -- --------------------------------------------------------------------

Line 1342: fnd_file.put_line(FND_FILE.OUTPUT, fnd_message.get);

1338:
1339: fnd_message.set_name('FII','FII_DBI_CHECK_TIME_GAPS');
1340: fnd_message.set_token('FROM_DATE', fnd_date.date_to_displayDT(l_from_date));
1341: fnd_message.set_token('TO_DATE', fnd_date.date_to_displayDT(l_to_date));
1342: fnd_file.put_line(FND_FILE.OUTPUT, fnd_message.get);
1343: fnd_file.put_line(FND_FILE.OUTPUT, '');
1344:
1345: -- handle NULL dates input
1346: if (p_from_date is NULL) then

Line 1343: fnd_file.put_line(FND_FILE.OUTPUT, '');

1339: fnd_message.set_name('FII','FII_DBI_CHECK_TIME_GAPS');
1340: fnd_message.set_token('FROM_DATE', fnd_date.date_to_displayDT(l_from_date));
1341: fnd_message.set_token('TO_DATE', fnd_date.date_to_displayDT(l_to_date));
1342: fnd_file.put_line(FND_FILE.OUTPUT, fnd_message.get);
1343: fnd_file.put_line(FND_FILE.OUTPUT, '');
1344:
1345: -- handle NULL dates input
1346: if (p_from_date is NULL) then
1347: raise_application_error(-20000,'Error in input for check_missing_date: ' ||

Line 1389: fnd_file.put_line(FND_FILE.OUTPUT, fnd_message.get);

1385: fnd_message.set_token('FROM_DATE',
1386: fnd_date.date_to_displayDT(l_min_missing_date));
1387: fnd_message.set_token('TO_DATE',
1388: fnd_date.date_to_displayDT(l_max_missing_date));
1389: fnd_file.put_line(FND_FILE.OUTPUT, fnd_message.get);
1390: fnd_file.put_line(FND_FILE.OUTPUT, '');
1391: else
1392: fnd_message.set_name('FII','FII_DBI_NO_TIME_GAPS');
1393: fnd_file.put_line(FND_FILE.OUTPUT, fnd_message.get);

Line 1390: fnd_file.put_line(FND_FILE.OUTPUT, '');

1386: fnd_date.date_to_displayDT(l_min_missing_date));
1387: fnd_message.set_token('TO_DATE',
1388: fnd_date.date_to_displayDT(l_max_missing_date));
1389: fnd_file.put_line(FND_FILE.OUTPUT, fnd_message.get);
1390: fnd_file.put_line(FND_FILE.OUTPUT, '');
1391: else
1392: fnd_message.set_name('FII','FII_DBI_NO_TIME_GAPS');
1393: fnd_file.put_line(FND_FILE.OUTPUT, fnd_message.get);
1394: fnd_file.put_line(FND_FILE.OUTPUT, '');

Line 1393: fnd_file.put_line(FND_FILE.OUTPUT, fnd_message.get);

1389: fnd_file.put_line(FND_FILE.OUTPUT, fnd_message.get);
1390: fnd_file.put_line(FND_FILE.OUTPUT, '');
1391: else
1392: fnd_message.set_name('FII','FII_DBI_NO_TIME_GAPS');
1393: fnd_file.put_line(FND_FILE.OUTPUT, fnd_message.get);
1394: fnd_file.put_line(FND_FILE.OUTPUT, '');
1395: end if;
1396:
1397: exception

Line 1394: fnd_file.put_line(FND_FILE.OUTPUT, '');

1390: fnd_file.put_line(FND_FILE.OUTPUT, '');
1391: else
1392: fnd_message.set_name('FII','FII_DBI_NO_TIME_GAPS');
1393: fnd_file.put_line(FND_FILE.OUTPUT, fnd_message.get);
1394: fnd_file.put_line(FND_FILE.OUTPUT, '');
1395: end if;
1396:
1397: exception
1398: when others then

Line 1399: fnd_file.put_line(FND_FILE.LOG, 'Error occurred in procedure: check_missing_date...');

1395: end if;
1396:
1397: exception
1398: when others then
1399: fnd_file.put_line(FND_FILE.LOG, 'Error occurred in procedure: check_missing_date...');
1400: fnd_file.put_line(FND_FILE.LOG, sqlcode || ' : ' || sqlerrm);
1401: raise;
1402: end check_missing_date;
1403:

Line 1400: fnd_file.put_line(FND_FILE.LOG, sqlcode || ' : ' || sqlerrm);

1396:
1397: exception
1398: when others then
1399: fnd_file.put_line(FND_FILE.LOG, 'Error occurred in procedure: check_missing_date...');
1400: fnd_file.put_line(FND_FILE.LOG, sqlcode || ' : ' || sqlerrm);
1401: raise;
1402: end check_missing_date;
1403:
1404: -- -------------------------------------------------------------------

Line 1480: fnd_file.put_line(FND_FILE.LOG, 'Error occurred in procedure: check_missing_date...');

1476: end if;
1477:
1478: exception
1479: when others then
1480: fnd_file.put_line(FND_FILE.LOG, 'Error occurred in procedure: check_missing_date...');
1481: fnd_file.put_line(FND_FILE.LOG, sqlcode || ' : ' || sqlerrm);
1482: raise;
1483: end check_missing_date;
1484:

Line 1481: fnd_file.put_line(FND_FILE.LOG, sqlcode || ' : ' || sqlerrm);

1477:
1478: exception
1479: when others then
1480: fnd_file.put_line(FND_FILE.LOG, 'Error occurred in procedure: check_missing_date...');
1481: fnd_file.put_line(FND_FILE.LOG, sqlcode || ' : ' || sqlerrm);
1482: raise;
1483: end check_missing_date;
1484:
1485: -----------------------------------------------------------------------