APPS.EAM_API_LOG_PVT dependencies on UTL_FILE

Line 11: x_log_file IN OUT NOCOPY UTL_FILE.FILE_TYPE

7: p_log_file_dir IN VARCHAR2,
8: p_log_file_name IN VARCHAR2,
9:
10: x_is_logged IN OUT NOCOPY NUMBER,
11: x_log_file IN OUT NOCOPY UTL_FILE.FILE_TYPE
12: )
13: IS
14: BEGIN
15: IF x_is_logged = g_YES

Line 17: IF utl_file.is_open(x_log_file)

13: IS
14: BEGIN
15: IF x_is_logged = g_YES
16: THEN
17: IF utl_file.is_open(x_log_file)
18: THEN
19: -- file already opened, nothing more to do
20: NULL;
21: ELSE

Line 22: x_log_file := utl_file.fopen(p_log_file_dir,

18: THEN
19: -- file already opened, nothing more to do
20: NULL;
21: ELSE
22: x_log_file := utl_file.fopen(p_log_file_dir,
23: p_log_file_name,
24: 'w');
25: utl_file.put_line(x_log_file, 'Created ' || TO_CHAR(sysdate, 'DD MON YYYY HH12:MI:SS AM') ||
26: '; Log file dir=' || p_log_file_dir ||

Line 25: utl_file.put_line(x_log_file, 'Created ' || TO_CHAR(sysdate, 'DD MON YYYY HH12:MI:SS AM') ||

21: ELSE
22: x_log_file := utl_file.fopen(p_log_file_dir,
23: p_log_file_name,
24: 'w');
25: utl_file.put_line(x_log_file, 'Created ' || TO_CHAR(sysdate, 'DD MON YYYY HH12:MI:SS AM') ||
26: '; Log file dir=' || p_log_file_dir ||
27: '; Log file name=' || p_log_file_name
28: );
29: utl_file.fflush(x_log_file);

Line 29: utl_file.fflush(x_log_file);

25: utl_file.put_line(x_log_file, 'Created ' || TO_CHAR(sysdate, 'DD MON YYYY HH12:MI:SS AM') ||
26: '; Log file dir=' || p_log_file_dir ||
27: '; Log file name=' || p_log_file_name
28: );
29: utl_file.fflush(x_log_file);
30: END IF;
31: END IF;
32:
33: EXCEPTION

Line 47: p_log_file IN UTL_FILE.FILE_TYPE,

43:
44:
45: PROCEDURE Write_Log(
46: x_is_logged IN OUT NOCOPY NUMBER,
47: p_log_file IN UTL_FILE.FILE_TYPE,
48: p_log_message IN VARCHAR2
49: )
50: IS
51: BEGIN

Line 54: IF utl_file.is_open(p_log_file)

50: IS
51: BEGIN
52: IF x_is_logged = g_YES
53: THEN
54: IF utl_file.is_open(p_log_file)
55: THEN
56: utl_file.put_line(p_log_file, '> ' || p_log_message);
57: utl_file.fflush(p_log_file);
58: END IF;

Line 56: utl_file.put_line(p_log_file, '> ' || p_log_message);

52: IF x_is_logged = g_YES
53: THEN
54: IF utl_file.is_open(p_log_file)
55: THEN
56: utl_file.put_line(p_log_file, '> ' || p_log_message);
57: utl_file.fflush(p_log_file);
58: END IF;
59: END IF;
60:

Line 57: utl_file.fflush(p_log_file);

53: THEN
54: IF utl_file.is_open(p_log_file)
55: THEN
56: utl_file.put_line(p_log_file, '> ' || p_log_message);
57: utl_file.fflush(p_log_file);
58: END IF;
59: END IF;
60:
61: EXCEPTION

Line 72: p_log_file IN OUT NOCOPY UTL_FILE.FILE_TYPE

68: END IF;
69: END Write_Log;
70:
71: PROCEDURE Close_Log_Session(
72: p_log_file IN OUT NOCOPY UTL_FILE.FILE_TYPE
73: )
74: IS
75: BEGIN
76: IF utl_file.is_open(p_log_file)

Line 76: IF utl_file.is_open(p_log_file)

72: p_log_file IN OUT NOCOPY UTL_FILE.FILE_TYPE
73: )
74: IS
75: BEGIN
76: IF utl_file.is_open(p_log_file)
77: THEN
78: utl_file.fclose(p_log_file);
79: END IF;
80: END Close_Log_Session;

Line 78: utl_file.fclose(p_log_file);

74: IS
75: BEGIN
76: IF utl_file.is_open(p_log_file)
77: THEN
78: utl_file.fclose(p_log_file);
79: END IF;
80: END Close_Log_Session;
81:
82: END EAM_API_Log_PVT;