APPS.INV_UTILITY_PVT dependencies on UTL_FILE

Line 7: pg_fp UTL_FILE.file_type;

3:
4: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_UTILITY_PVT';
5: pg_file_name VARCHAR2(100) := NULL;
6: pg_path_name VARCHAR2(100) := NULL;
7: pg_fp UTL_FILE.file_type;
8:
9: /*=======================================================
10: API name : get_log_dir
11: Type : Private

Line 12: Function : Get path name defined from utl_file_dir

8:
9: /*=======================================================
10: API name : get_log_dir
11: Type : Private
12: Function : Get path name defined from utl_file_dir
13: ========================================================*/
14: PROCEDURE get_log_dir(
15: x_return_status OUT NOCOPY VARCHAR2
16: , x_msg_count OUT NOCOPY NUMBER

Line 27: WHERE UPPER(NAME) = 'UTL_FILE_DIR';

23:
24: CURSOR get_filedebugdir IS
25: SELECT RTRIM(LTRIM(VALUE))
26: FROM v$parameter
27: WHERE UPPER(NAME) = 'UTL_FILE_DIR';
28:
29: BEGIN
30: OPEN get_filedebugdir;
31: FETCH get_filedebugdir INTO l_write_dir;

Line 60: UTL_FILE.put_line(pg_fp, line);

56:
57: PROCEDURE write_debug_file(line IN VARCHAR2) IS
58: BEGIN
59: IF (pg_file_name IS NOT NULL) THEN
60: UTL_FILE.put_line(pg_fp, line);
61: UTL_FILE.fflush(pg_fp);
62: END IF;
63: END write_debug_file;
64:

Line 61: UTL_FILE.fflush(pg_fp);

57: PROCEDURE write_debug_file(line IN VARCHAR2) IS
58: BEGIN
59: IF (pg_file_name IS NOT NULL) THEN
60: UTL_FILE.put_line(pg_fp, line);
61: UTL_FILE.fflush(pg_fp);
62: END IF;
63: END write_debug_file;
64:
65: /*=======================================================

Line 78: pg_fp := UTL_FILE.fopen(p_path_name, p_file_name, 'a');

74: , x_msg_count OUT NOCOPY NUMBER
75: , x_msg_data OUT NOCOPY VARCHAR2
76: ) IS
77: BEGIN
78: pg_fp := UTL_FILE.fopen(p_path_name, p_file_name, 'a');
79: pg_file_name := p_file_name;
80: pg_path_name := p_path_name;
81: EXCEPTION
82: WHEN UTL_FILE.invalid_path THEN

Line 82: WHEN UTL_FILE.invalid_path THEN

78: pg_fp := UTL_FILE.fopen(p_path_name, p_file_name, 'a');
79: pg_file_name := p_file_name;
80: pg_path_name := p_path_name;
81: EXCEPTION
82: WHEN UTL_FILE.invalid_path THEN
83: x_return_status := fnd_api.g_ret_sts_error;
84: WHEN UTL_FILE.invalid_mode THEN
85: x_return_status := fnd_api.g_ret_sts_error;
86: END open_debug_file;

Line 84: WHEN UTL_FILE.invalid_mode THEN

80: pg_path_name := p_path_name;
81: EXCEPTION
82: WHEN UTL_FILE.invalid_path THEN
83: x_return_status := fnd_api.g_ret_sts_error;
84: WHEN UTL_FILE.invalid_mode THEN
85: x_return_status := fnd_api.g_ret_sts_error;
86: END open_debug_file;
87:
88: /*=======================================================

Line 97: UTL_FILE.fclose(pg_fp);

93:
94: PROCEDURE close_debug_file IS
95: BEGIN
96: IF (pg_file_name IS NOT NULL) THEN
97: UTL_FILE.fclose(pg_fp);
98: END IF;
99: END close_debug_file;
100: END inv_utility_pvt;