APPS.MSC_CL_GMP_UTILITY dependencies on UTL_FILE

Line 6187: /* Get the directory specified in the 'utl_file_dir' in init.ora file */

6183: mtq_index := 0 ;
6184:
6185: return_status := TRUE;
6186:
6187: /* Get the directory specified in the 'utl_file_dir' in init.ora file */
6188: BEGIN
6189: SELECT substrb(translate(ltrim(value),',',' '), 1,
6190: instr(translate(ltrim(value),',',' '),' ') - 1)
6191: INTO p_location

Line 6193: WHERE name = 'utl_file_dir';

6189: SELECT substrb(translate(ltrim(value),',',' '), 1,
6190: instr(translate(ltrim(value),',',' '),' ') - 1)
6191: INTO p_location
6192: FROM v$parameter
6193: WHERE name = 'utl_file_dir';
6194: EXCEPTION
6195: WHEN OTHERS THEN
6196: return_status := FALSE;
6197: log_message('directory select failed ');

Line 6339: LOG UTL_FILE.file_type;

6335: PROCEDURE gmp_putline (
6336: v_text IN VARCHAR2,
6337: v_mode IN VARCHAR2 )
6338: IS
6339: LOG UTL_FILE.file_type;
6340: BEGIN
6341:
6342: IF p_location IS NOT NULL THEN
6343: LOG :=

Line 6344: UTL_FILE.fopen ( p_location, 'GMPBM11B.log', v_mode );

6340: BEGIN
6341:
6342: IF p_location IS NOT NULL THEN
6343: LOG :=
6344: UTL_FILE.fopen ( p_location, 'GMPBM11B.log', v_mode );
6345: UTL_FILE.put_line ( LOG, v_text );
6346: UTL_FILE.fflush ( LOG );
6347: UTL_FILE.fclose ( LOG );
6348: ELSE

Line 6345: UTL_FILE.put_line ( LOG, v_text );

6341:
6342: IF p_location IS NOT NULL THEN
6343: LOG :=
6344: UTL_FILE.fopen ( p_location, 'GMPBM11B.log', v_mode );
6345: UTL_FILE.put_line ( LOG, v_text );
6346: UTL_FILE.fflush ( LOG );
6347: UTL_FILE.fclose ( LOG );
6348: ELSE
6349: NULL ;

Line 6346: UTL_FILE.fflush ( LOG );

6342: IF p_location IS NOT NULL THEN
6343: LOG :=
6344: UTL_FILE.fopen ( p_location, 'GMPBM11B.log', v_mode );
6345: UTL_FILE.put_line ( LOG, v_text );
6346: UTL_FILE.fflush ( LOG );
6347: UTL_FILE.fclose ( LOG );
6348: ELSE
6349: NULL ;
6350: END IF;

Line 6347: UTL_FILE.fclose ( LOG );

6343: LOG :=
6344: UTL_FILE.fopen ( p_location, 'GMPBM11B.log', v_mode );
6345: UTL_FILE.put_line ( LOG, v_text );
6346: UTL_FILE.fflush ( LOG );
6347: UTL_FILE.fclose ( LOG );
6348: ELSE
6349: NULL ;
6350: END IF;
6351: END gmp_putline;