APPS.JAI_CMN_UTILS_PKG dependencies on UTL_FILE

Line 566: v_myfilehandle UTL_FILE.FILE_TYPE;

562: PROCEDURE print_log (
563: filename VARCHAR2,
564: text_to_write VARCHAR2
565: ) IS
566: v_myfilehandle UTL_FILE.FILE_TYPE;
567: v_utl_location VARCHAR2(40) ;
568: lv_name varchar2(30);
569: BEGIN
570: lv_name := 'utl_file_dir'; --rchandan for bug#4428980

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

566: v_myfilehandle UTL_FILE.FILE_TYPE;
567: v_utl_location VARCHAR2(40) ;
568: lv_name varchar2(30);
569: BEGIN
570: lv_name := 'utl_file_dir'; --rchandan for bug#4428980
571: SELECT
572: decode(substr (value,1,instr(value,',') -1) ,
573: null ,
574: value ,

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

579: v$parameter
580: WHERE
581: name = lv_name; --rchandan for bug#4428980
582:
583: v_myfilehandle := utl_file.fopen(v_utl_location,filename,'A');
584:
585: utl_file.put_line(v_myfilehandle,text_to_write);
586:
587: utl_file.fclose(v_myfilehandle);

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

581: name = lv_name; --rchandan for bug#4428980
582:
583: v_myfilehandle := utl_file.fopen(v_utl_location,filename,'A');
584:
585: utl_file.put_line(v_myfilehandle,text_to_write);
586:
587: utl_file.fclose(v_myfilehandle);
588:
589: EXCEPTION

Line 587: utl_file.fclose(v_myfilehandle);

583: v_myfilehandle := utl_file.fopen(v_utl_location,filename,'A');
584:
585: utl_file.put_line(v_myfilehandle,text_to_write);
586:
587: utl_file.fclose(v_myfilehandle);
588:
589: EXCEPTION
590: WHEN OTHERS THEN
591: Null;