APPS.IGS_HE_CREATE_EXTRACT_PKG dependencies on FND_FILE

Line 216: fnd_file.put_line(fnd_file.log,fnd_message.get());

212: fnd_message.set_token('USER_RETURN_SUBCLASS',l_extract_dtls.user_return_subclass);
213: fnd_message.set_token('RETURN_NAME',l_extract_dtls.return_name);
214: fnd_message.set_token('ENROLMENT_START_DATE',l_extract_dtls.enrolment_start_date);
215: fnd_message.set_token('ENROLMENT_END_DATE',l_extract_dtls.enrolment_end_date);
216: fnd_file.put_line(fnd_file.log,fnd_message.get());
217:
218:
219: -- Get file directory
220: create_directory(l_filepath);

Line 226: fnd_file.put_line(fnd_file.log, errbuf);

222: -- If directory is NULL return with error
223: IF l_filepath IS NULL THEN
224: fnd_message.set_name('IGS','IGS_HE_FILE_DIR_ERROR');
225: errbuf := fnd_message.get;
226: fnd_file.put_line(fnd_file.log, errbuf);
227: retcode:=2;
228: RETURN;
229: END IF ;
230:

Line 241: fnd_file.put_line(fnd_file.log, errbuf);

237: WHEN OTHERS THEN
238: fnd_message.set_name('IGS','IGS_HE_FILE_OPEN_ERROR');
239: fnd_message.set_token('1', l_filepath || '/' || l_extract_dtls.file_name);
240: errbuf := fnd_message.get;
241: fnd_file.put_line(fnd_file.log, errbuf);
242: retcode := 2;
243: RETURN;
244: END;
245:

Line 293: fnd_file.put_line(fnd_file.log, errbuf); -- this message need to be displayed to user.

289: IF l_prs_grp_status <> 'S' THEN
290: fnd_message.set_name('IGS','IGS_HE_UT_PRSN_ID_GRP_ERR');
291: fnd_message.set_token('PRSNIDGRP',p_person_id_grp);
292: errbuf := fnd_message.get();
293: fnd_file.put_line(fnd_file.log, errbuf); -- this message need to be displayed to user.
294: retcode := '2';
295: RETURN;
296: END IF;
297:

Line 364: fnd_file.put_line(fnd_file.log, errbuf);

360: IF c_extract_line%NOTFOUND THEN
361: CLOSE c_extract_line;
362: fnd_message.set_name('IGS','IGS_HE_NO_DTLS_TO_OP');
363: errbuf := fnd_message.get;
364: fnd_file.put_line(fnd_file.log, errbuf);
365: retcode := 1;
366: RETURN;
367:
368: ELSE

Line 434: fnd_file.put_line(fnd_file.log, fnd_message.get);

430: EXCEPTION
431: WHEN UTL_FILE.WRITE_ERROR THEN
432: fnd_message.set_name('IGS', 'IGS_HE_FILE_WRITE_ERROR');
433: fnd_message.set_token('1', l_filepath || '/' || l_extract_dtls.file_name);
434: fnd_file.put_line(fnd_file.log, fnd_message.get);
435: RAISE;
436: END;
437:
438: l_final_value :='';

Line 467: fnd_file.put_line(fnd_file.log, fnd_message.get);

463: EXCEPTION
464: WHEN OTHERS THEN
465: fnd_message.set_name('IGS','IGS_HE_FILE_CLOSE_ERROR');
466: fnd_message.set_token('1', l_filepath || '/' || l_extract_dtls.file_name);
467: fnd_file.put_line(fnd_file.log, fnd_message.get);
468: errbuf := fnd_message.get ;
469: retcode := 2;
470: RETURN;
471: END;

Line 482: fnd_file.put_line(fnd_file.log, fnd_message.get);

478: -- Log lines written and filename
479: fnd_message.set_name('IGS','IGS_HE_FILE_LINES_WRITTEN');
480: fnd_message.set_token('NUMLINES', l_line_count);
481: fnd_message.set_token('FILE', l_filepath || '/' || l_extract_dtls.file_name);
482: fnd_file.put_line(fnd_file.log, fnd_message.get);
483:
484:
485: EXCEPTION
486: WHEN OTHERS THEN

Line 500: fnd_file.put_line(fnd_file.log, fnd_message.get);

496:
497: retcode := 2;
498: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
499: Fnd_Message.Set_Token('NAME','igs_he_create_extract_pkg.create_file - ' ||SQLERRM);
500: fnd_file.put_line(fnd_file.log, fnd_message.get);
501: App_Exception.Raise_Exception;
502:
503: END create_file;
504: