APPS.JAI_CMN_UTILS_PKG dependencies on UTL_FILE

Line 482: v_myfilehandle UTL_FILE.FILE_TYPE;

478: PROCEDURE print_log (
479: filename VARCHAR2,
480: text_to_write VARCHAR2
481: ) IS
482: v_myfilehandle UTL_FILE.FILE_TYPE;
483: v_utl_location VARCHAR2(40) ;
484: lv_name varchar2(30);
485: BEGIN
486: lv_name := 'utl_file_dir'; --rchandan for bug#4428980

Line 486: lv_name := 'utl_file_dir'; --rchandan for bug#4428980

482: v_myfilehandle UTL_FILE.FILE_TYPE;
483: v_utl_location VARCHAR2(40) ;
484: lv_name varchar2(30);
485: BEGIN
486: lv_name := 'utl_file_dir'; --rchandan for bug#4428980
487: SELECT
488: decode(substr (value,1,instr(value,',') -1) ,
489: null ,
490: value ,

Line 499: v_myfilehandle := utl_file.fopen(v_utl_location,filename,'A');

495: v$parameter
496: WHERE
497: name = lv_name; --rchandan for bug#4428980
498:
499: v_myfilehandle := utl_file.fopen(v_utl_location,filename,'A');
500:
501: utl_file.put_line(v_myfilehandle,text_to_write);
502:
503: utl_file.fclose(v_myfilehandle);

Line 501: utl_file.put_line(v_myfilehandle,text_to_write);

497: name = lv_name; --rchandan for bug#4428980
498:
499: v_myfilehandle := utl_file.fopen(v_utl_location,filename,'A');
500:
501: utl_file.put_line(v_myfilehandle,text_to_write);
502:
503: utl_file.fclose(v_myfilehandle);
504:
505: EXCEPTION

Line 503: utl_file.fclose(v_myfilehandle);

499: v_myfilehandle := utl_file.fopen(v_utl_location,filename,'A');
500:
501: utl_file.put_line(v_myfilehandle,text_to_write);
502:
503: utl_file.fclose(v_myfilehandle);
504:
505: EXCEPTION
506: WHEN OTHERS THEN
507: Null;