eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_HE_CREATE_EXTRACT_PKG dependencies on FND_MESSAGE

Line 100: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');

96:
97: EXCEPTION
98: WHEN OTHERS THEN
99: p_directory := NULL ;
100: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
101: FND_MESSAGE.SET_TOKEN('NAME','IGS_HE_CREATE_EXTRACT_PKG.CREATE_DIRECTORY'||' - '||SQLERRM);
102: IGS_GE_MSG_STACK.ADD;
103: App_Exception.Raise_Exception;
104:

Line 101: FND_MESSAGE.SET_TOKEN('NAME','IGS_HE_CREATE_EXTRACT_PKG.CREATE_DIRECTORY'||' - '||SQLERRM);

97: EXCEPTION
98: WHEN OTHERS THEN
99: p_directory := NULL ;
100: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
101: FND_MESSAGE.SET_TOKEN('NAME','IGS_HE_CREATE_EXTRACT_PKG.CREATE_DIRECTORY'||' - '||SQLERRM);
102: IGS_GE_MSG_STACK.ADD;
103: App_Exception.Raise_Exception;
104:
105: END create_directory ;

Line 210: fnd_message.set_name('IGS','IGS_HE_PROC_SUBM');

206: CLOSE c_extract_dtls;
207:
208:
209: -- Log Header
210: fnd_message.set_name('IGS','IGS_HE_PROC_SUBM');
211: fnd_message.set_token('SUBMISSION_NAME',l_extract_dtls.submission_name);
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);

Line 211: fnd_message.set_token('SUBMISSION_NAME',l_extract_dtls.submission_name);

207:
208:
209: -- Log Header
210: fnd_message.set_name('IGS','IGS_HE_PROC_SUBM');
211: fnd_message.set_token('SUBMISSION_NAME',l_extract_dtls.submission_name);
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);

Line 212: fnd_message.set_token('USER_RETURN_SUBCLASS',l_extract_dtls.user_return_subclass);

208:
209: -- Log Header
210: fnd_message.set_name('IGS','IGS_HE_PROC_SUBM');
211: fnd_message.set_token('SUBMISSION_NAME',l_extract_dtls.submission_name);
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());

Line 213: fnd_message.set_token('RETURN_NAME',l_extract_dtls.return_name);

209: -- Log Header
210: fnd_message.set_name('IGS','IGS_HE_PROC_SUBM');
211: fnd_message.set_token('SUBMISSION_NAME',l_extract_dtls.submission_name);
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:

Line 214: fnd_message.set_token('ENROLMENT_START_DATE',l_extract_dtls.enrolment_start_date);

210: fnd_message.set_name('IGS','IGS_HE_PROC_SUBM');
211: fnd_message.set_token('SUBMISSION_NAME',l_extract_dtls.submission_name);
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:

Line 215: fnd_message.set_token('ENROLMENT_END_DATE',l_extract_dtls.enrolment_end_date);

211: fnd_message.set_token('SUBMISSION_NAME',l_extract_dtls.submission_name);
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

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 224: fnd_message.set_name('IGS','IGS_HE_FILE_DIR_ERROR');

220: create_directory(l_filepath);
221:
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;

Line 225: errbuf := fnd_message.get;

221:
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 ;

Line 238: fnd_message.set_name('IGS','IGS_HE_FILE_OPEN_ERROR');

234: l_file := NULL;
235: l_file := UTL_FILE.FOPEN (l_filepath, l_extract_dtls.file_name, 'w');
236: EXCEPTION
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;

Line 239: fnd_message.set_token('1', l_filepath || '/' || l_extract_dtls.file_name);

235: l_file := UTL_FILE.FOPEN (l_filepath, l_extract_dtls.file_name, 'w');
236: EXCEPTION
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;

Line 240: errbuf := fnd_message.get;

236: EXCEPTION
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;

Line 290: fnd_message.set_name('IGS','IGS_HE_UT_PRSN_ID_GRP_ERR');

286: -- Use library to get dynamic persion id group members
287: l_prs_grp_sql := IGS_PE_DYNAMIC_PERSID_GROUP.IGS_GET_DYNAMIC_SQL(p_person_id_grp, l_prs_grp_status);
288:
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';

Line 291: fnd_message.set_token('PRSNIDGRP',p_person_id_grp);

287: l_prs_grp_sql := IGS_PE_DYNAMIC_PERSID_GROUP.IGS_GET_DYNAMIC_SQL(p_person_id_grp, l_prs_grp_status);
288:
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;

Line 292: errbuf := fnd_message.get();

288:
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;

Line 362: fnd_message.set_name('IGS','IGS_HE_NO_DTLS_TO_OP');

358:
359: -- Make sure there are some lines in the extract otherwise no point in continuing
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;

Line 363: errbuf := fnd_message.get;

359: -- Make sure there are some lines in the extract otherwise no point in continuing
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:

Line 432: fnd_message.set_name('IGS', 'IGS_HE_FILE_WRITE_ERROR');

428: BEGIN
429: utl_file.put (l_file, l_final_value );
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;

Line 433: fnd_message.set_token('1', l_filepath || '/' || l_extract_dtls.file_name);

429: utl_file.put (l_file, l_final_value );
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:

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 465: fnd_message.set_name('IGS','IGS_HE_FILE_CLOSE_ERROR');

461: utl_file.fclose( l_file );
462: END IF;
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;

Line 466: fnd_message.set_token('1', l_filepath || '/' || l_extract_dtls.file_name);

462: END IF;
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;

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 468: errbuf := fnd_message.get ;

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;
472:

Line 479: fnd_message.set_name('IGS','IGS_HE_FILE_LINES_WRITTEN');

475: SET file_location = l_filepath
476: WHERE extract_run_id = p_extract_run_id;
477:
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:

Line 480: fnd_message.set_token('NUMLINES', l_line_count);

476: WHERE extract_run_id = p_extract_run_id;
477:
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:

Line 481: fnd_message.set_token('FILE', l_filepath || '/' || l_extract_dtls.file_name);

477:
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

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 498: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

494: CLOSE c_extract_line;
495: END IF;
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:

Line 499: Fnd_Message.Set_Token('NAME','igs_he_create_extract_pkg.create_file - ' ||SQLERRM);

495: END IF;
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;

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: