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_PNOTE_ACK dependencies on FND_MESSAGE

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

204: l_rec_batch_rej_code,
205: l_rec_batch_type;
206: IF c_header%NOTFOUND THEN
207: CLOSE c_header;
208: fnd_message.set_name('IGF','IGF_GE_FILE_NOT_COMPLETE');
209: -- Message : Response File uploaded is not complete.
210: igs_ge_msg_stack.add;
211: RAISE FILE_NOT_LOADED;
212: END IF;

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

223: IF l_dl_file_type = 'DL_PNOTE_ACK'
224: AND l_dl_loan_catg in ('DL_STAFFORD','DL_PLUS','DL_STAFFORD_PLUS') THEN
225: NULL;
226: ELSE
227: fnd_message.set_name('IGF','IGF_GE_INVALID_FILE');
228: -- Message : This is not a valid file
229: igs_ge_msg_stack.add;
230: RAISE FILE_NOT_LOADED;
231: END IF;

Line 235: fnd_message.set_name('IGF','IGF_SL_DL_ORIG_PNOTE_FILE');

231: END IF;
232:
233: IF l_dl_loan_catg in ('DL_STAFFORD','DL_PLUS','DL_STAFFORD_PLUS') THEN
234: -- This is an Direct Loan Promissory Note Acknowledgment File
235: fnd_message.set_name('IGF','IGF_SL_DL_ORIG_PNOTE_FILE');
236: fnd_file.put_line(fnd_file.log,FND_MESSAGE.GET);
237:
238: END IF;
239:

Line 236: fnd_file.put_line(fnd_file.log,FND_MESSAGE.GET);

232:
233: IF l_dl_loan_catg in ('DL_STAFFORD','DL_PLUS','DL_STAFFORD_PLUS') THEN
234: -- This is an Direct Loan Promissory Note Acknowledgment File
235: fnd_message.set_name('IGF','IGF_SL_DL_ORIG_PNOTE_FILE');
236: fnd_file.put_line(fnd_file.log,FND_MESSAGE.GET);
237:
238: END IF;
239:
240: -- Get the System Award Year from l_dl_version

Line 253: fnd_message.set_name('IGF','IGF_SL_COD_NO_PNOTE_ACK');

249: -- If the award year is FULL_PARTICIPANT then raise the error message
250: -- and stop processing else continue the process
251: IF l_cod_year_flag THEN
252:
253: fnd_message.set_name('IGF','IGF_SL_COD_NO_PNOTE_ACK');
254: fnd_file.put_line(fnd_file.log,fnd_message.get);
255: RETURN;
256:
257: END IF;

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

250: -- and stop processing else continue the process
251: IF l_cod_year_flag THEN
252:
253: fnd_message.set_name('IGF','IGF_SL_COD_NO_PNOTE_ACK');
254: fnd_file.put_line(fnd_file.log,fnd_message.get);
255: RETURN;
256:
257: END IF;
258:

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

262: FETCH c_trailer into l_last_lort_id, l_number_rec, l_accept_rec,
263: l_reject_rec, l_pending_rec;
264: IF c_trailer%NOTFOUND THEN
265: CLOSE c_trailer;
266: fnd_message.set_name('IGF','IGF_GE_FILE_NOT_COMPLETE');
267: igs_ge_msg_stack.add;
268: RAISE FILE_NOT_LOADED;
269: END IF;
270: CLOSE c_trailer;

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

271:
272:
273:
274: IF l_rec_batch_rej_code IS NOT NULL THEN
275: fnd_message.set_name('IGF','IGF_GE_BATCH_REJECTED');
276: fnd_message.set_token('BATCH', l_rec_batch_id);
277: fnd_message.set_token('REASON', igf_aw_gen.lookup_desc('IGF_SL_DL_BATCH_REJ',l_rec_batch_rej_code));
278: igs_ge_msg_stack.add;
279:

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

272:
273:
274: IF l_rec_batch_rej_code IS NOT NULL THEN
275: fnd_message.set_name('IGF','IGF_GE_BATCH_REJECTED');
276: fnd_message.set_token('BATCH', l_rec_batch_id);
277: fnd_message.set_token('REASON', igf_aw_gen.lookup_desc('IGF_SL_DL_BATCH_REJ',l_rec_batch_rej_code));
278: igs_ge_msg_stack.add;
279:
280: -- Message : Batch #BATCH was rejected. Reason : #REASON.

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

273:
274: IF l_rec_batch_rej_code IS NOT NULL THEN
275: fnd_message.set_name('IGF','IGF_GE_BATCH_REJECTED');
276: fnd_message.set_token('BATCH', l_rec_batch_id);
277: fnd_message.set_token('REASON', igf_aw_gen.lookup_desc('IGF_SL_DL_BATCH_REJ',l_rec_batch_rej_code));
278: igs_ge_msg_stack.add;
279:
280: -- Message : Batch #BATCH was rejected. Reason : #REASON.
281: RAISE FILE_NOT_LOADED;

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

407:
408: END IF; -- End of condition for VERSION.
409:
410: IF l_actual_rec <> l_number_rec THEN
411: fnd_message.set_name('IGF','IGF_GE_RECORD_NUM_NOT_MATCH');
412: -- Message : The Actual Number of records does not match with the one mentioned in the trailer
413: igs_ge_msg_stack.add;
414: RAISE FILE_NOT_LOADED;
415: END IF;

Line 430: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

426: RAISE;
427: WHEN FILE_NOT_LOADED THEN
428: RAISE;
429: WHEN OTHERS THEN
430: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
431: fnd_message.set_token('NAME','IGF_SL_DL_PNOTE_ACK.DL_LOAD_DATA');
432: fnd_file.put_line(fnd_file.log,SQLERRM);
433: igs_ge_msg_stack.add;
434: app_exception.raise_exception;

Line 431: fnd_message.set_token('NAME','IGF_SL_DL_PNOTE_ACK.DL_LOAD_DATA');

427: WHEN FILE_NOT_LOADED THEN
428: RAISE;
429: WHEN OTHERS THEN
430: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
431: fnd_message.set_token('NAME','IGF_SL_DL_PNOTE_ACK.DL_LOAD_DATA');
432: fnd_file.put_line(fnd_file.log,SQLERRM);
433: igs_ge_msg_stack.add;
434: app_exception.raise_exception;
435: END dl_load_data;

Line 563: fnd_message.set_name('IGF','IGF_SL_DL_REJ_EXISTS');

559: -- ## with the reject Descriptions
560: IF resp_rec.pnote_rej_codes IS NOT NULL THEN
561:
562: log_message(resp_rec.loan_number);
563: fnd_message.set_name('IGF','IGF_SL_DL_REJ_EXISTS');
564: fnd_file.put_line(fnd_file.log,FND_MESSAGE.GET);
565: resp_rec.pnote_rej_codes := translate(resp_rec.pnote_rej_codes,'0',' ');
566: DECLARE
567: CURSOR c_rej IS

Line 564: fnd_file.put_line(fnd_file.log,FND_MESSAGE.GET);

560: IF resp_rec.pnote_rej_codes IS NOT NULL THEN
561:
562: log_message(resp_rec.loan_number);
563: fnd_message.set_name('IGF','IGF_SL_DL_REJ_EXISTS');
564: fnd_file.put_line(fnd_file.log,FND_MESSAGE.GET);
565: resp_rec.pnote_rej_codes := translate(resp_rec.pnote_rej_codes,'0',' ');
566: DECLARE
567: CURSOR c_rej IS
568: SELECT lookup_code, meaning FROM igf_lookups_view

Line 594: fnd_message.set_name('IGF','IGF_SL_DL_PNOTE_REJECTED');

590: OPEN cur_loanid(resp_rec.loan_number);
591:
592: FETCH cur_loanid INTO lcur_loanid;
593: log_message(resp_rec.loan_number);
594: fnd_message.set_name('IGF','IGF_SL_DL_PNOTE_REJECTED');
595: fnd_file.put_line(fnd_file.log,FND_MESSAGE.GET);
596:
597: IF cur_loanid%NOTFOUND THEN
598: CLOSE cur_loanid;

Line 595: fnd_file.put_line(fnd_file.log,FND_MESSAGE.GET);

591:
592: FETCH cur_loanid INTO lcur_loanid;
593: log_message(resp_rec.loan_number);
594: fnd_message.set_name('IGF','IGF_SL_DL_PNOTE_REJECTED');
595: fnd_file.put_line(fnd_file.log,FND_MESSAGE.GET);
596:
597: IF cur_loanid%NOTFOUND THEN
598: CLOSE cur_loanid;
599: log_message(resp_rec.loan_number);

Line 646: fnd_message.set_name('IGF','IGF_SL_DL_AlREADY_ACCEPTED');

642: -- ## then Print the message and skip the record and raise a
643: -- ## User Defined exception
644: IF tbh_rec.pnote_status='A' AND tbh_rec.pnote_ack_date IS NOT NULL THEN
645: log_message(resp_rec.loan_number);
646: fnd_message.set_name('IGF','IGF_SL_DL_AlREADY_ACCEPTED');
647: fnd_file.put_line(fnd_file.log,FND_MESSAGE.GET);
648: update_resp_edit(resp_rec.dlpnr_id,'U');
649: RAISE Rec_no_update;
650: ELSE

Line 647: fnd_file.put_line(fnd_file.log,FND_MESSAGE.GET);

643: -- ## User Defined exception
644: IF tbh_rec.pnote_status='A' AND tbh_rec.pnote_ack_date IS NOT NULL THEN
645: log_message(resp_rec.loan_number);
646: fnd_message.set_name('IGF','IGF_SL_DL_AlREADY_ACCEPTED');
647: fnd_file.put_line(fnd_file.log,FND_MESSAGE.GET);
648: update_resp_edit(resp_rec.dlpnr_id,'U');
649: RAISE Rec_no_update;
650: ELSE
651:

Line 839: fnd_message.set_name('IGF','IGF_SL_DL_INVALID_LOAN');

835:
836:
837: EXCEPTION
838: WHEN invalid_loan THEN
839: fnd_message.set_name('IGF','IGF_SL_DL_INVALID_LOAN');
840: fnd_file.put_line(fnd_file.log,FND_MESSAGE.GET);
841: WHEN Rec_no_update THEN
842: NULL;
843: WHEN no_loan_id THEN

Line 840: fnd_file.put_line(fnd_file.log,FND_MESSAGE.GET);

836:
837: EXCEPTION
838: WHEN invalid_loan THEN
839: fnd_message.set_name('IGF','IGF_SL_DL_INVALID_LOAN');
840: fnd_file.put_line(fnd_file.log,FND_MESSAGE.GET);
841: WHEN Rec_no_update THEN
842: NULL;
843: WHEN no_loan_id THEN
844: NULL;

Line 861: errbuf := fnd_message.get_string('IGF','IGF_GE_LOCK_ERROR');

857: EXCEPTION
858: WHEN app_exception.record_lock_exception THEN
859: ROLLBACK;
860: retcode := 2;
861: errbuf := fnd_message.get_string('IGF','IGF_GE_LOCK_ERROR');
862: igs_ge_msg_stack.conc_exception_hndl;
863: WHEN FILE_NOT_LOADED THEN
864: ROLLBACK;
865: retcode := 2;

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

862: igs_ge_msg_stack.conc_exception_hndl;
863: WHEN FILE_NOT_LOADED THEN
864: ROLLBACK;
865: retcode := 2;
866: errbuf := fnd_message.get_string('IGF','IGF_GE_FILE_NOT_LOADED');
867: igs_ge_msg_stack.conc_exception_hndl;
868: WHEN OTHERS THEN
869: ROLLBACK;
870: retcode := 2;

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

867: igs_ge_msg_stack.conc_exception_hndl;
868: WHEN OTHERS THEN
869: ROLLBACK;
870: retcode := 2;
871: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION');
872: fnd_file.put_line(fnd_file.log,SQLERRM);
873: igs_ge_msg_stack.conc_exception_hndl;
874:
875: END process_ack;

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

1148: EXCEPTION
1149: WHEN app_exception.record_lock_exception THEN
1150: RAISE;
1151: WHEN OTHERS THEN
1152: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1153: fnd_message.set_token('NAME','IGF_SL_DL_PNOTE_ACK.COMPARE_DISBURSEMENTS');
1154: fnd_file.put_line(fnd_file.log,SQLERRM);
1155: igs_ge_msg_stack.add;
1156: app_exception.raise_exception;

Line 1153: fnd_message.set_token('NAME','IGF_SL_DL_PNOTE_ACK.COMPARE_DISBURSEMENTS');

1149: WHEN app_exception.record_lock_exception THEN
1150: RAISE;
1151: WHEN OTHERS THEN
1152: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1153: fnd_message.set_token('NAME','IGF_SL_DL_PNOTE_ACK.COMPARE_DISBURSEMENTS');
1154: fnd_file.put_line(fnd_file.log,SQLERRM);
1155: igs_ge_msg_stack.add;
1156: app_exception.raise_exception;
1157: END compare_disbursements;