APPS.MSC_PHUB_UTIL dependencies on UTL_FILE

Line 277: l_log utl_file.file_type := null;

273: end if;
274: end validate_icx_session;
275:
276: procedure set_log_file(p_log_dir varchar2, p_log_file varchar2) is
277: l_log utl_file.file_type := null;
278: begin
279: if (p_log_dir is null or p_log_file is null) then
280: g_log_dir := null;
281: g_log_file := null;

Line 315: ' where p.name=''utl_file_dir'''||

311: ' select dir'||
312: ' from'||
313: ' (select trim(p.value) dir'||
314: ' from v$parameter2 p, dba_directories d'||
315: ' where p.name=''utl_file_dir'''||
316: ' and d.directory_name(+)=''ECX_UTL_LOG_DIR_OBJ'''||
317: ' and d.owner(+)=''SYS'''||
318: ' and trim(p.value)=d.directory_path(+)'||
319: ' order by d.directory_name'||

Line 337: utl_file.fremove(g_log_dir, g_log_file);

333: end init_log;
334:
335: procedure delete_log is
336: begin
337: utl_file.fremove(g_log_dir, g_log_file);
338: exception
339: when others then null;
340: end delete_log;
341:

Line 355: l_log utl_file.file_type := null;

351:
352: procedure log(p_level number, p_message varchar2)
353: is
354: t timestamp;
355: l_log utl_file.file_type := null;
356: begin
357: if (g_log_level < p_level) then
358: return;
359: end if;

Line 366: l_log := utl_file.fopen(g_log_dir, g_log_file, 'a', 16384);

362: --dbms_output.put_line(to_char(t, 'YYYY-MM-DD HH24:MI:SS')||': '||p_message); --xxx
363: fnd_file.put_line(fnd_file.log, to_char(t, 'YYYY-MM-DD HH24:MI:SS')||': '||p_message);
364:
365: if (g_log_file is not null) then
366: l_log := utl_file.fopen(g_log_dir, g_log_file, 'a', 16384);
367: utl_file.put_line(l_log, to_char(t, 'YYYY-MM-DD HH24:MI:SS')||': '||p_message);
368: utl_file.fflush(l_log);
369: utl_file.fclose(l_log);
370: end if;

Line 367: utl_file.put_line(l_log, to_char(t, 'YYYY-MM-DD HH24:MI:SS')||': '||p_message);

363: fnd_file.put_line(fnd_file.log, to_char(t, 'YYYY-MM-DD HH24:MI:SS')||': '||p_message);
364:
365: if (g_log_file is not null) then
366: l_log := utl_file.fopen(g_log_dir, g_log_file, 'a', 16384);
367: utl_file.put_line(l_log, to_char(t, 'YYYY-MM-DD HH24:MI:SS')||': '||p_message);
368: utl_file.fflush(l_log);
369: utl_file.fclose(l_log);
370: end if;
371: end log;

Line 368: utl_file.fflush(l_log);

364:
365: if (g_log_file is not null) then
366: l_log := utl_file.fopen(g_log_dir, g_log_file, 'a', 16384);
367: utl_file.put_line(l_log, to_char(t, 'YYYY-MM-DD HH24:MI:SS')||': '||p_message);
368: utl_file.fflush(l_log);
369: utl_file.fclose(l_log);
370: end if;
371: end log;
372:

Line 369: utl_file.fclose(l_log);

365: if (g_log_file is not null) then
366: l_log := utl_file.fopen(g_log_dir, g_log_file, 'a', 16384);
367: utl_file.put_line(l_log, to_char(t, 'YYYY-MM-DD HH24:MI:SS')||': '||p_message);
368: utl_file.fflush(l_log);
369: utl_file.fclose(l_log);
370: end if;
371: end log;
372:
373: function suffix(p_dblink varchar2) return varchar2 is