APPS.GMI_OM_ALLOC_API_PUB dependencies on UTL_FILE

Line 1990: WHERE name = 'utl_file_dir';

1986:
1987: CURSOR get_log_file_location IS
1988: SELECT NVL( SUBSTR( value, 1, instr( value, ',')-1), value) location, USERENV('SESSIONID') sessionid
1989: FROM v$parameter
1990: WHERE name = 'utl_file_dir';
1991:
1992: l_location VARCHAR2(255);
1993: l_log UTL_FILE.file_type;
1994: l_time VARCHAR2(10);

Line 1993: l_log UTL_FILE.file_type;

1989: FROM v$parameter
1990: WHERE name = 'utl_file_dir';
1991:
1992: l_location VARCHAR2(255);
1993: l_log UTL_FILE.file_type;
1994: l_time VARCHAR2(10);
1995: l_file_name VARCHAR2(80);
1996: l_sessionid NUMBER := 0;
1997: l_debug_level VARCHAR2(240) := TO_NUMBER(NVL(fnd_profile.value ('ONT_DEBUG_LEVEL'),0));

Line 2017: l_log := UTL_FILE.fopen(l_location, l_file_name, 'a');

2013: CLOSE get_log_file_location;
2014:
2015: l_file_name := l_file_name || l_sessionid;
2016:
2017: l_log := UTL_FILE.fopen(l_location, l_file_name, 'a');
2018:
2019: IF UTL_FILE.IS_OPEN(l_log) THEN
2020: UTL_FILE.put_line(l_log, p_msg);
2021: UTL_FILE.fflush(l_log);

Line 2019: IF UTL_FILE.IS_OPEN(l_log) THEN

2015: l_file_name := l_file_name || l_sessionid;
2016:
2017: l_log := UTL_FILE.fopen(l_location, l_file_name, 'a');
2018:
2019: IF UTL_FILE.IS_OPEN(l_log) THEN
2020: UTL_FILE.put_line(l_log, p_msg);
2021: UTL_FILE.fflush(l_log);
2022: UTL_FILE.fclose(l_log);
2023: END IF;

Line 2020: UTL_FILE.put_line(l_log, p_msg);

2016:
2017: l_log := UTL_FILE.fopen(l_location, l_file_name, 'a');
2018:
2019: IF UTL_FILE.IS_OPEN(l_log) THEN
2020: UTL_FILE.put_line(l_log, p_msg);
2021: UTL_FILE.fflush(l_log);
2022: UTL_FILE.fclose(l_log);
2023: END IF;
2024:

Line 2021: UTL_FILE.fflush(l_log);

2017: l_log := UTL_FILE.fopen(l_location, l_file_name, 'a');
2018:
2019: IF UTL_FILE.IS_OPEN(l_log) THEN
2020: UTL_FILE.put_line(l_log, p_msg);
2021: UTL_FILE.fflush(l_log);
2022: UTL_FILE.fclose(l_log);
2023: END IF;
2024:
2025: END IF;

Line 2022: UTL_FILE.fclose(l_log);

2018:
2019: IF UTL_FILE.IS_OPEN(l_log) THEN
2020: UTL_FILE.put_line(l_log, p_msg);
2021: UTL_FILE.fflush(l_log);
2022: UTL_FILE.fclose(l_log);
2023: END IF;
2024:
2025: END IF;
2026: