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.IGF_SL_UPLOAD_XML dependencies on UTL_FILE

Line 208: lv_file UTL_FILE.FILE_TYPE;

204: tmpClob1 CLOB;
205: tmpClob CLOB;
206: MYCLOB_TEXT VARCHAR2(11000);
207: l_doc_id VARCHAR2(30);
208: lv_file UTL_FILE.FILE_TYPE;
209: ln_start_pos INTEGER;
210: ln_end_pos INTEGER;
211: l_endofdir NUMBER;
212: l_temp_endofdir NUMBER;

Line 256: lv_file := utl_file.fopen(lv_directory, lv_filename, 'r', 32767);

252: END IF;
253:
254: -- Open the file
255: BEGIN
256: lv_file := utl_file.fopen(lv_directory, lv_filename, 'r', 32767);
257: EXCEPTION
258: WHEN UTL_FILE.INVALID_PATH THEN
259: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
260: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','UTL_FILE.INVALID_PATH Exception occurred');

Line 258: WHEN UTL_FILE.INVALID_PATH THEN

254: -- Open the file
255: BEGIN
256: lv_file := utl_file.fopen(lv_directory, lv_filename, 'r', 32767);
257: EXCEPTION
258: WHEN UTL_FILE.INVALID_PATH THEN
259: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
260: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','UTL_FILE.INVALID_PATH Exception occurred');
261: END IF;
262: RAISE;

Line 260: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','UTL_FILE.INVALID_PATH Exception occurred');

256: lv_file := utl_file.fopen(lv_directory, lv_filename, 'r', 32767);
257: EXCEPTION
258: WHEN UTL_FILE.INVALID_PATH THEN
259: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
260: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','UTL_FILE.INVALID_PATH Exception occurred');
261: END IF;
262: RAISE;
263: RETURN;
264: WHEN UTL_FILE.INVALID_MODE THEN

Line 264: WHEN UTL_FILE.INVALID_MODE THEN

260: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','UTL_FILE.INVALID_PATH Exception occurred');
261: END IF;
262: RAISE;
263: RETURN;
264: WHEN UTL_FILE.INVALID_MODE THEN
265: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
266: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','UTL_FILE.INVALID_MODE Exception occurred');
267: END IF;
268: RAISE;

Line 266: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','UTL_FILE.INVALID_MODE Exception occurred');

262: RAISE;
263: RETURN;
264: WHEN UTL_FILE.INVALID_MODE THEN
265: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
266: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','UTL_FILE.INVALID_MODE Exception occurred');
267: END IF;
268: RAISE;
269: RETURN;
270: WHEN UTL_FILE.INVALID_OPERATION THEN

Line 270: WHEN UTL_FILE.INVALID_OPERATION THEN

266: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','UTL_FILE.INVALID_MODE Exception occurred');
267: END IF;
268: RAISE;
269: RETURN;
270: WHEN UTL_FILE.INVALID_OPERATION THEN
271: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
272: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','UTL_FILE.INVALID_OPERATION Exception occurred');
273: END IF;
274: RAISE;

Line 272: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','UTL_FILE.INVALID_OPERATION Exception occurred');

268: RAISE;
269: RETURN;
270: WHEN UTL_FILE.INVALID_OPERATION THEN
271: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
272: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','UTL_FILE.INVALID_OPERATION Exception occurred');
273: END IF;
274: RAISE;
275: RETURN;
276: END;

Line 304: UTL_FILE.GET_LINE(lv_file, myclob_text);

300: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
301: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug', 'Before reading line number: ' || ln_file_line_num);
302: END IF;
303:
304: UTL_FILE.GET_LINE(lv_file, myclob_text);
305:
306: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
307: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug', 'After reading line number: ' || ln_file_line_num || 'Length of the text is: ' || LENGTH(myclob_text) || 'Start of the text is: ' || SUBSTR(myclob_text, 1, 32));
308: END IF;

Line 318: UTL_FILE.FCLOSE(lv_file);

314: END LOOP;
315: EXCEPTION
316: WHEN NO_DATA_FOUND THEN
317: -- This will Auto-Close the file when EOF Reaches
318: UTL_FILE.FCLOSE(lv_file);
319: WHEN OTHERS THEN
320: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
321: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_upload_xml.main.debug','Exception occurred while creating tmpClob1');
322: END IF;