APPS.MSC_CL_GMP_UTILITY dependencies on UTL_FILE

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

6602: mtq_index := 0 ;
6603:
6604: return_status := TRUE;
6605:
6606: /* Get the directory specified in the 'utl_file_dir' in init.ora file */
6607: BEGIN
6608: SELECT substrb(translate(ltrim(value),',',' '), 1,
6609: instr(translate(ltrim(value),',',' '),' ') - 1)
6610: INTO p_location

Line 6612: WHERE name = 'utl_file_dir';

6608: SELECT substrb(translate(ltrim(value),',',' '), 1,
6609: instr(translate(ltrim(value),',',' '),' ') - 1)
6610: INTO p_location
6611: FROM v$parameter
6612: WHERE name = 'utl_file_dir';
6613: EXCEPTION
6614: WHEN OTHERS THEN
6615: return_status := FALSE;
6616: log_message('directory select failed ');

Line 6758: LOG UTL_FILE.file_type;

6754: PROCEDURE gmp_putline (
6755: v_text IN VARCHAR2,
6756: v_mode IN VARCHAR2 )
6757: IS
6758: LOG UTL_FILE.file_type;
6759: BEGIN
6760:
6761: IF p_location IS NOT NULL THEN
6762: LOG :=

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

6759: BEGIN
6760:
6761: IF p_location IS NOT NULL THEN
6762: LOG :=
6763: UTL_FILE.fopen ( p_location, 'GMPBM11B.log', v_mode );
6764: UTL_FILE.put_line ( LOG, v_text );
6765: UTL_FILE.fflush ( LOG );
6766: UTL_FILE.fclose ( LOG );
6767: ELSE

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

6760:
6761: IF p_location IS NOT NULL THEN
6762: LOG :=
6763: UTL_FILE.fopen ( p_location, 'GMPBM11B.log', v_mode );
6764: UTL_FILE.put_line ( LOG, v_text );
6765: UTL_FILE.fflush ( LOG );
6766: UTL_FILE.fclose ( LOG );
6767: ELSE
6768: NULL ;

Line 6765: UTL_FILE.fflush ( LOG );

6761: IF p_location IS NOT NULL THEN
6762: LOG :=
6763: UTL_FILE.fopen ( p_location, 'GMPBM11B.log', v_mode );
6764: UTL_FILE.put_line ( LOG, v_text );
6765: UTL_FILE.fflush ( LOG );
6766: UTL_FILE.fclose ( LOG );
6767: ELSE
6768: NULL ;
6769: END IF;

Line 6766: UTL_FILE.fclose ( LOG );

6762: LOG :=
6763: UTL_FILE.fopen ( p_location, 'GMPBM11B.log', v_mode );
6764: UTL_FILE.put_line ( LOG, v_text );
6765: UTL_FILE.fflush ( LOG );
6766: UTL_FILE.fclose ( LOG );
6767: ELSE
6768: NULL ;
6769: END IF;
6770: END gmp_putline;