APPS.IGS_EN_NSC_FILE_PRNT_PKG dependencies on UTL_FILE

Line 77: l_file_ptr UTL_FILE.FILE_TYPE;

73: )
74: IS
75:
76: l_api_name CONSTANT VARCHAR2(30) := 'Generate_file';
77: l_file_ptr UTL_FILE.FILE_TYPE;
78: l_attr_list attrib_list_tbl_type;
79: l_group_list group_list_tbl_type;
80: l_total_groups NUMBER(10);
81: l_group_count NUMBER(10);

Line 124: l_file_ptr := UTL_FILE.FOPEN ( p_dirpath, p_file_name, 'a' );

120: g_debug_mode := FND_API.TO_BOOLEAN(p_debug_mode);
121: --Opening file
122: Put_Debug_Msg('Opening file: '||p_dirpath||p_file_name);
123:
124: l_file_ptr := UTL_FILE.FOPEN ( p_dirpath, p_file_name, 'a' );
125:
126: Put_Debug_Msg('Init visual data');
127: --Init visual data
128: Init_format_data (

Line 169: UTL_FILE.PUT_LINE ( l_file_ptr, l_line );

165: END LOOP; --End of list of attributes
166:
167: -- Put line into the file
168:
169: UTL_FILE.PUT_LINE ( l_file_ptr, l_line );
170: UTL_FILE.FFLUSH ( l_file_ptr );
171:
172: END LOOP; --End of versions list
173: END LOOP; -- End of Group Loop

Line 170: UTL_FILE.FFLUSH ( l_file_ptr );

166:
167: -- Put line into the file
168:
169: UTL_FILE.PUT_LINE ( l_file_ptr, l_line );
170: UTL_FILE.FFLUSH ( l_file_ptr );
171:
172: END LOOP; --End of versions list
173: END LOOP; -- End of Group Loop
174:

Line 177: IF (UTL_FILE.IS_OPEN ( l_file_ptr )) THEN

173: END LOOP; -- End of Group Loop
174:
175: Put_Debug_Msg('Closing file');
176:
177: IF (UTL_FILE.IS_OPEN ( l_file_ptr )) THEN
178: UTL_FILE.FCLOSE ( l_file_ptr );
179: END IF;
180:
181: EXCEPTION

Line 178: UTL_FILE.FCLOSE ( l_file_ptr );

174:
175: Put_Debug_Msg('Closing file');
176:
177: IF (UTL_FILE.IS_OPEN ( l_file_ptr )) THEN
178: UTL_FILE.FCLOSE ( l_file_ptr );
179: END IF;
180:
181: EXCEPTION
182: WHEN UTL_FILE.INVALID_PATH THEN

Line 182: WHEN UTL_FILE.INVALID_PATH THEN

178: UTL_FILE.FCLOSE ( l_file_ptr );
179: END IF;
180:
181: EXCEPTION
182: WHEN UTL_FILE.INVALID_PATH THEN
183: ROLLBACK TO Generate_file;
184: x_return_status := FND_API.G_RET_STS_ERROR;
185: FND_MESSAGE.set_name('IGS', 'IGS_EN_INVALID_PATH');
186: FND_MSG_PUB.Add;

Line 188: WHEN UTL_FILE.WRITE_ERROR THEN

184: x_return_status := FND_API.G_RET_STS_ERROR;
185: FND_MESSAGE.set_name('IGS', 'IGS_EN_INVALID_PATH');
186: FND_MSG_PUB.Add;
187:
188: WHEN UTL_FILE.WRITE_ERROR THEN
189: ROLLBACK TO Generate_file;
190: x_return_status := FND_API.G_RET_STS_ERROR;
191: FND_MESSAGE.set_name('IGS', 'IGS_EN_WRITE_ERROR');
192: FND_MSG_PUB.Add;

Line 194: WHEN UTL_FILE.INVALID_FILEHANDLE THEN

190: x_return_status := FND_API.G_RET_STS_ERROR;
191: FND_MESSAGE.set_name('IGS', 'IGS_EN_WRITE_ERROR');
192: FND_MSG_PUB.Add;
193:
194: WHEN UTL_FILE.INVALID_FILEHANDLE THEN
195: ROLLBACK TO Generate_file;
196: x_return_status := FND_API.G_RET_STS_ERROR;
197: FND_MESSAGE.set_name('IGS', 'IGS_EN_INVALID_FILEHANDLE');
198: FND_MSG_PUB.Add;

Line 205: IF (UTL_FILE.IS_OPEN ( l_file_ptr )) THEN

201:
202: ROLLBACK TO Generate_file;
203: Put_Debug_Msg('EXC_ERROR exception');
204: x_return_status := FND_API.G_RET_STS_ERROR;
205: IF (UTL_FILE.IS_OPEN ( l_file_ptr )) THEN
206: UTL_FILE.FCLOSE ( l_file_ptr );
207: END IF;
208: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
209: p_data => x_msg_data );

Line 206: UTL_FILE.FCLOSE ( l_file_ptr );

202: ROLLBACK TO Generate_file;
203: Put_Debug_Msg('EXC_ERROR exception');
204: x_return_status := FND_API.G_RET_STS_ERROR;
205: IF (UTL_FILE.IS_OPEN ( l_file_ptr )) THEN
206: UTL_FILE.FCLOSE ( l_file_ptr );
207: END IF;
208: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count,
209: p_data => x_msg_data );
210:

Line 217: IF (UTL_FILE.IS_OPEN ( l_file_ptr )) THEN

213: ROLLBACK TO Generate_file;
214: Put_Debug_Msg('UNEXPECTED_ERROR exception');
215:
216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
217: IF (UTL_FILE.IS_OPEN ( l_file_ptr )) THEN
218: UTL_FILE.FCLOSE ( l_file_ptr );
219: END IF;
220: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
221: p_data => x_msg_data );

Line 218: UTL_FILE.FCLOSE ( l_file_ptr );

214: Put_Debug_Msg('UNEXPECTED_ERROR exception');
215:
216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
217: IF (UTL_FILE.IS_OPEN ( l_file_ptr )) THEN
218: UTL_FILE.FCLOSE ( l_file_ptr );
219: END IF;
220: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
221: p_data => x_msg_data );
222:

Line 233: IF (UTL_FILE.IS_OPEN ( l_file_ptr )) THEN

229: IF (FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
230: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
231: END IF;
232:
233: IF (UTL_FILE.IS_OPEN ( l_file_ptr )) THEN
234: UTL_FILE.FCLOSE ( l_file_ptr );
235: END IF;
236:
237: END Generate_file;

Line 234: UTL_FILE.FCLOSE ( l_file_ptr );

230: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
231: END IF;
232:
233: IF (UTL_FILE.IS_OPEN ( l_file_ptr )) THEN
234: UTL_FILE.FCLOSE ( l_file_ptr );
235: END IF;
236:
237: END Generate_file;
238: