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.IGF_SL_DL_CHG_ACK dependencies on FND_MESSAGE

Line 162: fnd_message.set_name('IGF','IGF_GE_FILE_NOT_COMPLETE');

158: l_rec_batch_rej_code,
159: l_rec_batch_type;
160: IF c_header%NOTFOUND THEN
161: CLOSE c_header;
162: fnd_message.set_name('IGF','IGF_GE_FILE_NOT_COMPLETE');
163: -- Message : Response File uploaded is not complete.
164: igs_ge_msg_stack.add;
165: RAISE FILE_NOT_LOADED;
166: END IF;

Line 176: fnd_message.set_name('IGF','IGF_GE_INVALID_FILE');

172: g_dl_version, l_dl_file_type, l_dl_loan_catg);
173: IF g_dl_version = 'INVALID-FILE'
174: OR l_dl_file_type = 'INVALID-FILE'
175: OR l_dl_file_type <> 'DL_CHG_ACK' THEN
176: fnd_message.set_name('IGF','IGF_GE_INVALID_FILE');
177: -- Message : This is not a valid file
178: igs_ge_msg_stack.add;
179: RAISE FILE_NOT_LOADED;
180: END IF;

Line 195: fnd_message.set_name('IGF','IGF_SL_DL_CHG_ACK_FILE');

191: CLOSE c_get_award_year;
192:
193:
194: -- This is an Direct Loan Change Acknowledgment File
195: fnd_message.set_name('IGF','IGF_SL_DL_CHG_ACK_FILE');
196: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
197: fnd_file.put_line(fnd_file.log,' ');
198:
199:

Line 196: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

192:
193:
194: -- This is an Direct Loan Change Acknowledgment File
195: fnd_message.set_name('IGF','IGF_SL_DL_CHG_ACK_FILE');
196: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
197: fnd_file.put_line(fnd_file.log,' ');
198:
199:
200: -- Check whether the File was Fully transferred.

Line 207: fnd_message.set_name('IGF','IGF_GE_FILE_NOT_COMPLETE');

203: FETCH c_trailer into l_last_lort_id, l_number_rec, l_accept_rec,
204: l_reject_rec, l_pending_rec;
205: IF c_trailer%NOTFOUND THEN
206: CLOSE c_trailer;
207: fnd_message.set_name('IGF','IGF_GE_FILE_NOT_COMPLETE');
208: igs_ge_msg_stack.add;
209: RAISE FILE_NOT_LOADED;
210: END IF;
211: CLOSE c_trailer;

Line 216: fnd_message.set_name('IGF','IGF_GE_BATCH_REJECTED');

212:
213:
214: -- Check if the entire batch was rejected for any reason or not
215: IF LTRIM(RTRIM(l_rec_batch_rej_code)) IS NOT NULL THEN
216: fnd_message.set_name('IGF','IGF_GE_BATCH_REJECTED');
217: fnd_message.set_token('BATCH', l_rec_batch_id);
218: fnd_message.set_token('REASON', igf_aw_gen.lookup_desc('IGF_SL_DL_BATCH_REJ',l_rec_batch_rej_code));
219: -- Message : Batch #BATCH was rejected. Reason : #REASON.
220: igs_ge_msg_stack.add;

Line 217: fnd_message.set_token('BATCH', l_rec_batch_id);

213:
214: -- Check if the entire batch was rejected for any reason or not
215: IF LTRIM(RTRIM(l_rec_batch_rej_code)) IS NOT NULL THEN
216: fnd_message.set_name('IGF','IGF_GE_BATCH_REJECTED');
217: fnd_message.set_token('BATCH', l_rec_batch_id);
218: fnd_message.set_token('REASON', igf_aw_gen.lookup_desc('IGF_SL_DL_BATCH_REJ',l_rec_batch_rej_code));
219: -- Message : Batch #BATCH was rejected. Reason : #REASON.
220: igs_ge_msg_stack.add;
221: RAISE FILE_NOT_LOADED;

Line 218: fnd_message.set_token('REASON', igf_aw_gen.lookup_desc('IGF_SL_DL_BATCH_REJ',l_rec_batch_rej_code));

214: -- Check if the entire batch was rejected for any reason or not
215: IF LTRIM(RTRIM(l_rec_batch_rej_code)) IS NOT NULL THEN
216: fnd_message.set_name('IGF','IGF_GE_BATCH_REJECTED');
217: fnd_message.set_token('BATCH', l_rec_batch_id);
218: fnd_message.set_token('REASON', igf_aw_gen.lookup_desc('IGF_SL_DL_BATCH_REJ',l_rec_batch_rej_code));
219: -- Message : Batch #BATCH was rejected. Reason : #REASON.
220: igs_ge_msg_stack.add;
221: RAISE FILE_NOT_LOADED;
222: END IF;

Line 289: fnd_message.set_name('IGF','IGF_GE_RECORD_NUM_NOT_MATCH');

285: END IF;
286: END LOOP;
287: END LOOP;
288: IF l_actual_rec <> l_number_rec THEN
289: fnd_message.set_name('IGF','IGF_GE_RECORD_NUM_NOT_MATCH');
290: -- Message : The Actual Number of records does not match with the one mentioned in the trailer
291: igs_ge_msg_stack.add;
292: RAISE FILE_NOT_LOADED;
293: END IF;

Line 310: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

306: RAISE;
307: WHEN NOT_PHASE_IN_PARTICIPANT THEN
308: RAISE;
309: WHEN OTHERS THEN
310: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
311: fnd_message.set_token('NAME','igf_sl_dl_chg_ack.dl_load_data'||sqlerrm);
312: igs_ge_msg_stack.add;
313: app_exception.raise_exception;
314: END dl_load_data;

Line 311: fnd_message.set_token('NAME','igf_sl_dl_chg_ack.dl_load_data'||sqlerrm);

307: WHEN NOT_PHASE_IN_PARTICIPANT THEN
308: RAISE;
309: WHEN OTHERS THEN
310: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
311: fnd_message.set_token('NAME','igf_sl_dl_chg_ack.dl_load_data'||sqlerrm);
312: igs_ge_msg_stack.add;
313: app_exception.raise_exception;
314: END dl_load_data;
315:

Line 460: fnd_message.set_name('IGF','IGF_SL_NO_LOAN_NUMBER');

456: upd_loan_record(resp_rec.loan_number,l_loan_status,l_loan_chg_status, l_rec_present);
457:
458: -- If the Loan# being uploaded is not a Valid Loan#
459: IF l_rec_present = 'N' THEN
460: fnd_message.set_name('IGF','IGF_SL_NO_LOAN_NUMBER');
461: fnd_message.set_token('LOAN_NUMBER',resp_rec.loan_number);
462: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
463: -- Message : Loan ID #LOAN_NUMBER does not exist in the Financial Aid System
464:

Line 461: fnd_message.set_token('LOAN_NUMBER',resp_rec.loan_number);

457:
458: -- If the Loan# being uploaded is not a Valid Loan#
459: IF l_rec_present = 'N' THEN
460: fnd_message.set_name('IGF','IGF_SL_NO_LOAN_NUMBER');
461: fnd_message.set_token('LOAN_NUMBER',resp_rec.loan_number);
462: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
463: -- Message : Loan ID #LOAN_NUMBER does not exist in the Financial Aid System
464:
465: -- Update the Loan Change Response Record as NOT UPLOADED, Since it is INVALID

Line 462: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

458: -- If the Loan# being uploaded is not a Valid Loan#
459: IF l_rec_present = 'N' THEN
460: fnd_message.set_name('IGF','IGF_SL_NO_LOAN_NUMBER');
461: fnd_message.set_token('LOAN_NUMBER',resp_rec.loan_number);
462: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
463: -- Message : Loan ID #LOAN_NUMBER does not exist in the Financial Aid System
464:
465: -- Update the Loan Change Response Record as NOT UPLOADED, Since it is INVALID
466: upd_dl_chg_resp(l_dbth_id, resp_rec.loan_number, 'I');

Line 477: fnd_message.set_name('IGF','IGF_SL_LOAN_CHG_STATUS');

473: -- and also display and insert the reject codes.
474: IF l_loan_chg_status = 'R' THEN
475:
476: -- Show "Changes for Loan ID #LOAN_NUMBER were #LOAN_CHG_STATUS" on the Log File.
477: fnd_message.set_name('IGF','IGF_SL_LOAN_CHG_STATUS');
478: fnd_message.set_token('LOAN_NUMBER',resp_rec.loan_number);
479: fnd_message.set_token('LOAN_STATUS',
480: igf_aw_gen.lookup_desc('IGF_SL_REC_STATUS',l_loan_chg_status));
481: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

Line 478: fnd_message.set_token('LOAN_NUMBER',resp_rec.loan_number);

474: IF l_loan_chg_status = 'R' THEN
475:
476: -- Show "Changes for Loan ID #LOAN_NUMBER were #LOAN_CHG_STATUS" on the Log File.
477: fnd_message.set_name('IGF','IGF_SL_LOAN_CHG_STATUS');
478: fnd_message.set_token('LOAN_NUMBER',resp_rec.loan_number);
479: fnd_message.set_token('LOAN_STATUS',
480: igf_aw_gen.lookup_desc('IGF_SL_REC_STATUS',l_loan_chg_status));
481: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
482:

Line 479: fnd_message.set_token('LOAN_STATUS',

475:
476: -- Show "Changes for Loan ID #LOAN_NUMBER were #LOAN_CHG_STATUS" on the Log File.
477: fnd_message.set_name('IGF','IGF_SL_LOAN_CHG_STATUS');
478: fnd_message.set_token('LOAN_NUMBER',resp_rec.loan_number);
479: fnd_message.set_token('LOAN_STATUS',
480: igf_aw_gen.lookup_desc('IGF_SL_REC_STATUS',l_loan_chg_status));
481: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
482:
483:

Line 481: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

477: fnd_message.set_name('IGF','IGF_SL_LOAN_CHG_STATUS');
478: fnd_message.set_token('LOAN_NUMBER',resp_rec.loan_number);
479: fnd_message.set_token('LOAN_STATUS',
480: igf_aw_gen.lookup_desc('IGF_SL_REC_STATUS',l_loan_chg_status));
481: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
482:
483:
484: /************* Show Reject Details on the LOG File ***************/
485: DECLARE

Line 611: errbuf := fnd_message.get_string('IGF','IGF_GE_FILE_NOT_LOADED');

607: EXCEPTION
608: WHEN FILE_NOT_LOADED THEN
609: ROLLBACK;
610: retcode := 2;
611: errbuf := fnd_message.get_string('IGF','IGF_GE_FILE_NOT_LOADED');
612: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
613: WHEN FILE_ALREADY_LOADED THEN
614: ROLLBACK;
615: retcode := 2;

Line 616: errbuf := fnd_message.get_string('IGF','IGF_GE_BATCH_ALEARDY_LOADED');

612: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
613: WHEN FILE_ALREADY_LOADED THEN
614: ROLLBACK;
615: retcode := 2;
616: errbuf := fnd_message.get_string('IGF','IGF_GE_BATCH_ALEARDY_LOADED');
617: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
618:
619: WHEN NOT_PHASE_IN_PARTICIPANT THEN
620: ROLLBACK;

Line 621: fnd_message.set_name('IGF','IGF_SL_COD_NO_CHG_ACK');

617: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
618:
619: WHEN NOT_PHASE_IN_PARTICIPANT THEN
620: ROLLBACK;
621: fnd_message.set_name('IGF','IGF_SL_COD_NO_CHG_ACK');
622: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
623: fnd_file.put_line(fnd_file.log,' ');
624:
625: WHEN OTHERS THEN

Line 622: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);

618:
619: WHEN NOT_PHASE_IN_PARTICIPANT THEN
620: ROLLBACK;
621: fnd_message.set_name('IGF','IGF_SL_COD_NO_CHG_ACK');
622: fnd_file.put_line(FND_FILE.LOG,FND_MESSAGE.GET);
623: fnd_file.put_line(fnd_file.log,' ');
624:
625: WHEN OTHERS THEN
626: ROLLBACK;

Line 628: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION');

624:
625: WHEN OTHERS THEN
626: ROLLBACK;
627: retcode := 2;
628: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION');
629: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
630: END dl_chg_ack;
631:
632:

Line 678: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

674: END LOOP;
675:
676: EXCEPTION
677: WHEN OTHERS THEN
678: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
679: fnd_message.set_token('NAME','igf_sl_dl_chg_ack.upd_dl_chg_resp');
680: igs_ge_msg_stack.add;
681: app_exception.raise_exception;
682: END upd_dl_chg_resp;

Line 679: fnd_message.set_token('NAME','igf_sl_dl_chg_ack.upd_dl_chg_resp');

675:
676: EXCEPTION
677: WHEN OTHERS THEN
678: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
679: fnd_message.set_token('NAME','igf_sl_dl_chg_ack.upd_dl_chg_resp');
680: igs_ge_msg_stack.add;
681: app_exception.raise_exception;
682: END upd_dl_chg_resp;
683:

Line 728: fnd_message.set_name('IGF','IGF_SL_LOAN_CANCELLED');

724: IF p_loan_status ='C' THEN
725: tbh_rec.loan_status:=p_loan_status;
726: tbh_rec.loan_status_date := TRUNC(SYSDATE);
727: fnd_file.put_line(fnd_file.log,' ');
728: fnd_message.set_name('IGF','IGF_SL_LOAN_CANCELLED');
729: fnd_message.set_token('LOAN_NO',tbh_rec.loan_number);
730: --Loan Number tbh_rec.loan_number has been cancelled.
731: fnd_file.put_line(fnd_file.log,fnd_message.get);
732: END IF;

Line 729: fnd_message.set_token('LOAN_NO',tbh_rec.loan_number);

725: tbh_rec.loan_status:=p_loan_status;
726: tbh_rec.loan_status_date := TRUNC(SYSDATE);
727: fnd_file.put_line(fnd_file.log,' ');
728: fnd_message.set_name('IGF','IGF_SL_LOAN_CANCELLED');
729: fnd_message.set_token('LOAN_NO',tbh_rec.loan_number);
730: --Loan Number tbh_rec.loan_number has been cancelled.
731: fnd_file.put_line(fnd_file.log,fnd_message.get);
732: END IF;
733:

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

727: fnd_file.put_line(fnd_file.log,' ');
728: fnd_message.set_name('IGF','IGF_SL_LOAN_CANCELLED');
729: fnd_message.set_token('LOAN_NO',tbh_rec.loan_number);
730: --Loan Number tbh_rec.loan_number has been cancelled.
731: fnd_file.put_line(fnd_file.log,fnd_message.get);
732: END IF;
733:
734:
735:

Line 766: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

762: END LOOP;
763:
764: EXCEPTION
765: WHEN others THEN
766: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
767: fnd_message.set_token('NAME','igf_sl_dl_chg_ack.upd_loan_record');
768: igs_ge_msg_stack.add;
769: app_exception.raise_exception;
770: END upd_loan_record;

Line 767: fnd_message.set_token('NAME','igf_sl_dl_chg_ack.upd_loan_record');

763:
764: EXCEPTION
765: WHEN others THEN
766: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
767: fnd_message.set_token('NAME','igf_sl_dl_chg_ack.upd_loan_record');
768: igs_ge_msg_stack.add;
769: app_exception.raise_exception;
770: END upd_loan_record;
771:

Line 1013: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

1009: END LOOP;
1010:
1011: EXCEPTION
1012: WHEN others THEN
1013: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1014: fnd_message.set_token('NAME','igf_sl_dl_chg_ack.upd_lor_loc_record');
1015: igs_ge_msg_stack.add;
1016: app_exception.raise_exception;
1017: END upd_lor_loc_record;

Line 1014: fnd_message.set_token('NAME','igf_sl_dl_chg_ack.upd_lor_loc_record');

1010:
1011: EXCEPTION
1012: WHEN others THEN
1013: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1014: fnd_message.set_token('NAME','igf_sl_dl_chg_ack.upd_lor_loc_record');
1015: igs_ge_msg_stack.add;
1016: app_exception.raise_exception;
1017: END upd_lor_loc_record;
1018: