APPS.CSI_CTR_GEN_UTILITY_PVT dependencies on UTL_FILE

Line 38: l_file_handle utl_file.file_type;

34: IS
35: l_message VARCHAR2(4000);
36: l_sid NUMBER;
37: l_os_user VARCHAR2(30);
38: l_file_handle utl_file.file_type;
39:
40: -- l_log_file VARCHAR2(30) := fnd_profile.value('CSI_LOGFILE_NAME'); -- Bug 7197402
41: -- l_log_file_path VARCHAR2(240) := fnd_profile.value('CSI_LOGFILE_PATH'); -- Bug 7197402
42: -- l_stop_on_debug_error VARCHAR2(10) := fnd_profile.value('CSI_STOP_AT_DEBUG_ERROR'); -- Bug 7197402

Line 88: l_file_handle := UTL_FILE.FOPEN(g_debug_file_path, l_log_file, 'a');

84: null;
85: END;
86: END IF;
87:
88: l_file_handle := UTL_FILE.FOPEN(g_debug_file_path, l_log_file, 'a');
89: UTL_FILE.PUT_LINE (l_file_handle, l_message);
90: UTL_FILE.FFLUSH(l_file_handle);
91: UTL_FILE.FCLOSE(l_file_handle);
92: END IF;

Line 89: UTL_FILE.PUT_LINE (l_file_handle, l_message);

85: END;
86: END IF;
87:
88: l_file_handle := UTL_FILE.FOPEN(g_debug_file_path, l_log_file, 'a');
89: UTL_FILE.PUT_LINE (l_file_handle, l_message);
90: UTL_FILE.FFLUSH(l_file_handle);
91: UTL_FILE.FCLOSE(l_file_handle);
92: END IF;
93: EXCEPTION

Line 90: UTL_FILE.FFLUSH(l_file_handle);

86: END IF;
87:
88: l_file_handle := UTL_FILE.FOPEN(g_debug_file_path, l_log_file, 'a');
89: UTL_FILE.PUT_LINE (l_file_handle, l_message);
90: UTL_FILE.FFLUSH(l_file_handle);
91: UTL_FILE.FCLOSE(l_file_handle);
92: END IF;
93: EXCEPTION
94: WHEN UTL_FILE.INVALID_PATH THEN

Line 91: UTL_FILE.FCLOSE(l_file_handle);

87:
88: l_file_handle := UTL_FILE.FOPEN(g_debug_file_path, l_log_file, 'a');
89: UTL_FILE.PUT_LINE (l_file_handle, l_message);
90: UTL_FILE.FFLUSH(l_file_handle);
91: UTL_FILE.FCLOSE(l_file_handle);
92: END IF;
93: EXCEPTION
94: WHEN UTL_FILE.INVALID_PATH THEN
95: FND_MESSAGE.Set_Name('CSI', 'CSI_CTR_API_INVALID_PATH');

Line 94: WHEN UTL_FILE.INVALID_PATH THEN

90: UTL_FILE.FFLUSH(l_file_handle);
91: UTL_FILE.FCLOSE(l_file_handle);
92: END IF;
93: EXCEPTION
94: WHEN UTL_FILE.INVALID_PATH THEN
95: FND_MESSAGE.Set_Name('CSI', 'CSI_CTR_API_INVALID_PATH');
96: FND_MSG_PUB.ADD;
97:
98: IF (g_stop_on_debug_error = 'Y') THEN

Line 102: WHEN UTL_FILE.INVALID_MODE THEN

98: IF (g_stop_on_debug_error = 'Y') THEN
99: RAISE FND_API.G_EXC_ERROR;
100: END IF;
101:
102: WHEN UTL_FILE.INVALID_MODE THEN
103: FND_MESSAGE.Set_Name('CSI', 'CSI_CTR_API_INVALID_MODE');
104: FND_MSG_PUB.ADD;
105: IF (g_stop_on_debug_error = 'Y') THEN
106: RAISE FND_API.G_EXC_ERROR;

Line 109: WHEN UTL_FILE.INVALID_FILEHANDLE THEN

105: IF (g_stop_on_debug_error = 'Y') THEN
106: RAISE FND_API.G_EXC_ERROR;
107: END IF;
108:
109: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
110: FND_MESSAGE.Set_Name('CSI', 'CSI_CTR_API_INVALID_FILEHANDLE');
111: FND_MSG_PUB.ADD;
112: IF (g_stop_on_debug_error = 'Y') THEN
113: RAISE FND_API.G_EXC_ERROR;

Line 116: WHEN UTL_FILE.INVALID_OPERATION THEN

112: IF (g_stop_on_debug_error = 'Y') THEN
113: RAISE FND_API.G_EXC_ERROR;
114: END IF;
115:
116: WHEN UTL_FILE.INVALID_OPERATION THEN
117: FND_MESSAGE.Set_Name('CSI', 'CSI_CTR_API_INVALID_OPERATION');
118: FND_MSG_PUB.ADD;
119: IF (g_stop_on_debug_error = 'Y') THEN
120: RAISE FND_API.G_EXC_ERROR;

Line 123: WHEN UTL_FILE.WRITE_ERROR THEN

119: IF (g_stop_on_debug_error = 'Y') THEN
120: RAISE FND_API.G_EXC_ERROR;
121: END IF;
122:
123: WHEN UTL_FILE.WRITE_ERROR THEN
124: FND_MESSAGE.Set_Name('CSI', 'CSI_CTR_API_WRITE_ERROR');
125: FND_MSG_PUB.ADD;
126: IF (g_stop_on_debug_error = 'Y') THEN
127: RAISE FND_API.G_EXC_ERROR;