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

Line 256: l_filehandle UTL_FILE.FILE_TYPE;

252: P_FILENAME in varchar2,
253: P_CLOB in clob
254: ) is
255:
256: l_filehandle UTL_FILE.FILE_TYPE;
257: l_clob clob;
258:
259: l_current_position integer := 1;
260: l_amount_to_read integer := 0;

Line 274: l_filehandle := UTL_FILE.FOPEN(p_Directory, p_Filename,'w');

270: 'wf.plsql.WF_EVENT_SYNCHRONIZE_PKG.CREATECLOBFILE.Begin',
271: 'Entered Create Clob File: '||p_Directory||'-'||p_Filename);
272: end if;
273:
274: l_filehandle := UTL_FILE.FOPEN(p_Directory, p_Filename,'w');
275:
276: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
277: wf_log_pkg.string(wf_log_pkg.level_statement,
278: 'wf.plsql.WF_EVENT_SYNCHRONIZE_PKG.CREATECLOBFILE.file_handle',

Line 285: utl_file.putf(l_filehandle, g_begin_clob);

281:
282: --
283: -- At in Begin Sync Tag
284: --
285: utl_file.putf(l_filehandle, g_begin_clob);
286: utl_file.new_line(l_filehandle, 1);
287:
288: --
289: LOOP

Line 286: utl_file.new_line(l_filehandle, 1);

282: --
283: -- At in Begin Sync Tag
284: --
285: utl_file.putf(l_filehandle, g_begin_clob);
286: utl_file.new_line(l_filehandle, 1);
287:
288: --
289: LOOP
290: --

Line 314: utl_file.putf(l_filehandle, l_messagedata);

310:
311: l_messagedata := dbms_lob.substr(p_clob, l_amount_to_read,
312: l_begin_position);
313:
314: utl_file.putf(l_filehandle, l_messagedata);
315:
316: utl_file.new_line(l_filehandle, 1);
317:
318: END LOOP;

Line 316: utl_file.new_line(l_filehandle, 1);

312: l_begin_position);
313:
314: utl_file.putf(l_filehandle, l_messagedata);
315:
316: utl_file.new_line(l_filehandle, 1);
317:
318: END LOOP;
319:
320: /**

Line 326: utl_file.putf(l_filehandle, l_messagedata);

322:
323: l_messagedata := dbms_lob.substr(p_clob, l_splice_size,
324: l_current_position);
325:
326: utl_file.putf(l_filehandle, l_messagedata);
327:
328: wf_log_pkg.string(6, 'WF_EVENT_SYNCHRONIZE_PKG.CREATEFILE',
329: substr(l_messagedata,1,l_splice_size));
330:

Line 344: utl_file.putf(l_filehandle, g_end_clob);

340: **/
341: --
342: -- Add in End Sync Tag
343: --
344: utl_file.putf(l_filehandle, g_end_clob);
345:
346: utl_file.new_line(l_filehandle, 1);
347:
348: utl_file.fclose(l_filehandle);

Line 346: utl_file.new_line(l_filehandle, 1);

342: -- Add in End Sync Tag
343: --
344: utl_file.putf(l_filehandle, g_end_clob);
345:
346: utl_file.new_line(l_filehandle, 1);
347:
348: utl_file.fclose(l_filehandle);
349:
350: exception

Line 348: utl_file.fclose(l_filehandle);

344: utl_file.putf(l_filehandle, g_end_clob);
345:
346: utl_file.new_line(l_filehandle, 1);
347:
348: utl_file.fclose(l_filehandle);
349:
350: exception
351: when others then
352: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'CREATECLOBFILE', p_Directory||

Line 368: l_filehandle UTL_FILE.FILE_TYPE;

364: P_DIRECTORY in varchar2,
365: P_FILENAME in varchar2
366: ) is
367:
368: l_filehandle UTL_FILE.FILE_TYPE;
369: l_workingclob clob;
370: l_clob clob;
371: l_buffer varchar2(32000);
372: l_clobsize integer;

Line 377: raise utl_file.invalid_path;

373:
374: begin
375:
376: if (p_directory is null or p_filename is null) then
377: raise utl_file.invalid_path;
378: end if;
379:
380: l_filehandle := UTL_FILE.FOPEN(p_Directory, p_Filename,'r');
381:

Line 380: l_filehandle := UTL_FILE.FOPEN(p_Directory, p_Filename,'r');

376: if (p_directory is null or p_filename is null) then
377: raise utl_file.invalid_path;
378: end if;
379:
380: l_filehandle := UTL_FILE.FOPEN(p_Directory, p_Filename,'r');
381:
382: dbms_lob.createtemporary(l_clob, FALSE, DBMS_LOB.CALL);
383:
384: LOOP

Line 388: utl_file.get_line(l_filehandle, l_buffer);

384: LOOP
385: begin
386: dbms_lob.createtemporary( l_workingclob, FALSE, DBMS_LOB.CALL);
387:
388: utl_file.get_line(l_filehandle, l_buffer);
389:
390: if length(l_buffer) > 0 then
391: dbms_lob.write(l_workingclob, length(l_buffer), 1, l_buffer);
392: dbms_lob.append(l_clob,l_workingclob);

Line 419: when utl_file.invalid_path then

415:
416: wf_event_synchronize_pkg.uploadsyncclob( l_clob);
417:
418: exception
419: when utl_file.invalid_path then
420: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,
421: p_Filename,null);
422: wf_core.raise('WFE_INVALID_PATH');
423: when utl_file.invalid_mode then

Line 423: when utl_file.invalid_mode then

419: when utl_file.invalid_path then
420: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,
421: p_Filename,null);
422: wf_core.raise('WFE_INVALID_PATH');
423: when utl_file.invalid_mode then
424: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,
425: p_Filename,null);
426: wf_core.raise('WFE_INVALID_MODE');
427: when utl_file.invalid_operation then

Line 427: when utl_file.invalid_operation then

423: when utl_file.invalid_mode then
424: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,
425: p_Filename,null);
426: wf_core.raise('WFE_INVALID_MODE');
427: when utl_file.invalid_operation then
428: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,
429: p_Filename,null);
430: wf_core.raise('WFE_INVALID_OPERATION');
431: when utl_file.read_error then

Line 431: when utl_file.read_error then

427: when utl_file.invalid_operation then
428: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,
429: p_Filename,null);
430: wf_core.raise('WFE_INVALID_OPERATION');
431: when utl_file.read_error then
432: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,
433: p_Filename,null);
434: wf_core.raise('WFE_READ_ERROR');
435: when utl_file.internal_error then

Line 435: when utl_file.internal_error then

431: when utl_file.read_error then
432: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,
433: p_Filename,null);
434: wf_core.raise('WFE_READ_ERROR');
435: when utl_file.internal_error then
436: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,
437: p_Filename,null);
438: wf_core.raise('WFE_INTERNAL_ERROR');
439: when utl_file.invalid_filehandle then

Line 439: when utl_file.invalid_filehandle then

435: when utl_file.internal_error then
436: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,
437: p_Filename,null);
438: wf_core.raise('WFE_INTERNAL_ERROR');
439: when utl_file.invalid_filehandle then
440: wf_core.context('WF_EVENT_SYNCHRONIZE_PKG', 'UPLOADFILE', p_Directory,
441: p_Filename,null);
442: wf_core.raise('WFE_INVALID_FILEHANDLE');
443: when others then