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

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

174:
175:
176: EXCEPTION
177: WHEN OTHERS THEN
178: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
179: fnd_message.set_token('NAME','IGF_GR_RFMS_DISB_ORIG.UPD_RFMS_DISB');
180: igs_ge_msg_stack.add;
181: app_exception.raise_exception;
182: END upd_rfms_disb;

Line 179: fnd_message.set_token('NAME','IGF_GR_RFMS_DISB_ORIG.UPD_RFMS_DISB');

175:
176: EXCEPTION
177: WHEN OTHERS THEN
178: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
179: fnd_message.set_token('NAME','IGF_GR_RFMS_DISB_ORIG.UPD_RFMS_DISB');
180: igs_ge_msg_stack.add;
181: app_exception.raise_exception;
182: END upd_rfms_disb;
183:

Line 228: fnd_message.set_name('IGF','IGF_GR_ORIG_DATA_REQD');

224: IF p_rfms_rec.disb_ref_num IS NULL OR
225: p_rfms_rec.db_cr_flag IS NULL OR
226: p_rfms_rec.disb_amt IS NULL THEN
227: fnd_file.new_line(fnd_file.log,1);
228: fnd_message.set_name('IGF','IGF_GR_ORIG_DATA_REQD');
229: fnd_message.set_token('PER_NUM',igf_gr_gen.get_per_num(p_rfms_rec.base_id));
230: fnd_file.put_line(fnd_file.log,fnd_message.get);
231: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','DISB_REF_NUM'),50) || ' : ' ||p_rfms_rec.disb_ref_num);
232: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','DB_CR_FLAG'),50) || ' : ' ||p_rfms_rec.db_cr_flag);

Line 229: fnd_message.set_token('PER_NUM',igf_gr_gen.get_per_num(p_rfms_rec.base_id));

225: p_rfms_rec.db_cr_flag IS NULL OR
226: p_rfms_rec.disb_amt IS NULL THEN
227: fnd_file.new_line(fnd_file.log,1);
228: fnd_message.set_name('IGF','IGF_GR_ORIG_DATA_REQD');
229: fnd_message.set_token('PER_NUM',igf_gr_gen.get_per_num(p_rfms_rec.base_id));
230: fnd_file.put_line(fnd_file.log,fnd_message.get);
231: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','DISB_REF_NUM'),50) || ' : ' ||p_rfms_rec.disb_ref_num);
232: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','DB_CR_FLAG'),50) || ' : ' ||p_rfms_rec.db_cr_flag);
233: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','DISB_AMT'),50) || ' : ' ||p_rfms_rec.disb_amt);

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

226: p_rfms_rec.disb_amt IS NULL THEN
227: fnd_file.new_line(fnd_file.log,1);
228: fnd_message.set_name('IGF','IGF_GR_ORIG_DATA_REQD');
229: fnd_message.set_token('PER_NUM',igf_gr_gen.get_per_num(p_rfms_rec.base_id));
230: fnd_file.put_line(fnd_file.log,fnd_message.get);
231: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','DISB_REF_NUM'),50) || ' : ' ||p_rfms_rec.disb_ref_num);
232: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','DB_CR_FLAG'),50) || ' : ' ||p_rfms_rec.db_cr_flag);
233: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','DISB_AMT'),50) || ' : ' ||p_rfms_rec.disb_amt);
234: fnd_file.new_line(fnd_file.log,1);

Line 271: fnd_message.set_name('IGF','IGF_GR_VERF_STAT_W');

267: p_num_of_records := p_num_of_records + 1;
268:
269: ELSE
270:
271: fnd_message.set_name('IGF','IGF_GR_VERF_STAT_W');
272: fnd_message.set_token('ORIG_ID',igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ORIGINATION_ID') ||
273: ' : ' || p_rfms_rec.origination_id ||
274: ' , ' || igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','DISB_REF_NUM') ||
275: ' : ' || p_rfms_rec.disb_ref_num);

Line 272: fnd_message.set_token('ORIG_ID',igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ORIGINATION_ID') ||

268:
269: ELSE
270:
271: fnd_message.set_name('IGF','IGF_GR_VERF_STAT_W');
272: fnd_message.set_token('ORIG_ID',igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ORIGINATION_ID') ||
273: ' : ' || p_rfms_rec.origination_id ||
274: ' , ' || igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','DISB_REF_NUM') ||
275: ' : ' || p_rfms_rec.disb_ref_num);
276:

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

273: ' : ' || p_rfms_rec.origination_id ||
274: ' , ' || igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','DISB_REF_NUM') ||
275: ' : ' || p_rfms_rec.disb_ref_num);
276:
277: fnd_file.put_line(fnd_file.log,fnd_message.get);
278: END IF;
279: ELSE
280:
281: IF (g_header_written = 'N') THEN

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

301: WHEN igf_gr_gen.no_file_version THEN
302: RAISE;
303:
304: WHEN OTHERS THEN
305: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
306: fnd_message.set_token('NAME','IGF_GR_RFMS_DISB_ORIG.PREPARE_DATA');
307: igs_ge_msg_stack.add;
308: app_exception.raise_exception;
309:

Line 306: fnd_message.set_token('NAME','IGF_GR_RFMS_DISB_ORIG.PREPARE_DATA');

302: RAISE;
303:
304: WHEN OTHERS THEN
305: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
306: fnd_message.set_token('NAME','IGF_GR_RFMS_DISB_ORIG.PREPARE_DATA');
307: igs_ge_msg_stack.add;
308: app_exception.raise_exception;
309:
310: END prepare_data;

Line 340: fnd_message.set_name('IGF','IGF_GR_NO_RFMS_ORIG');

336: l_msg_str_1 := RPAD(p_batch_id,50) ||
337: RPAD(p_origination_id,50);
338:
339: fnd_file.put_line(fnd_file.log,'');
340: fnd_message.set_name('IGF','IGF_GR_NO_RFMS_ORIG');
341: fnd_file.put_line(fnd_file.log,fnd_message.get);
342: fnd_file.put_line(fnd_file.log,' ');
343: fnd_file.put_line(fnd_file.log,l_msg_str_0);
344: fnd_file.put_line(fnd_file.log,RPAD('-',100,'-'));

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

337: RPAD(p_origination_id,50);
338:
339: fnd_file.put_line(fnd_file.log,'');
340: fnd_message.set_name('IGF','IGF_GR_NO_RFMS_ORIG');
341: fnd_file.put_line(fnd_file.log,fnd_message.get);
342: fnd_file.put_line(fnd_file.log,' ');
343: fnd_file.put_line(fnd_file.log,l_msg_str_0);
344: fnd_file.put_line(fnd_file.log,RPAD('-',100,'-'));
345:

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

347:
348:
349: EXCEPTION
350: WHEN others THEN
351: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
352: fnd_message.set_token('NAME','IGF_GR_RFMS_ORIG.LOG_MESSAGE');
353: igs_ge_msg_stack.add;
354: app_exception.raise_exception;
355: END log_message;

Line 352: fnd_message.set_token('NAME','IGF_GR_RFMS_ORIG.LOG_MESSAGE');

348:
349: EXCEPTION
350: WHEN others THEN
351: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
352: fnd_message.set_token('NAME','IGF_GR_RFMS_ORIG.LOG_MESSAGE');
353: igs_ge_msg_stack.add;
354: app_exception.raise_exception;
355: END log_message;
356:

Line 387: fnd_message.set_name('IGF','IGF_GR_RECORDS_UPDATED');

383: l_msg_str_1 := RPAD(p_origination_id,30) ||
384: RPAD(p_disb_ref_num,30);
385:
386: IF l_msg_prn_1 = TRUE THEN
387: fnd_message.set_name('IGF','IGF_GR_RECORDS_UPDATED');
388: fnd_file.put_line(fnd_file.output,fnd_message.get);
389: fnd_file.new_line(fnd_file.output,1);
390: fnd_file.put_line(fnd_file.output,l_msg_str_0);
391: fnd_file.put_line(fnd_file.output,RPAD('-',100,'-'));

Line 388: fnd_file.put_line(fnd_file.output,fnd_message.get);

384: RPAD(p_disb_ref_num,30);
385:
386: IF l_msg_prn_1 = TRUE THEN
387: fnd_message.set_name('IGF','IGF_GR_RECORDS_UPDATED');
388: fnd_file.put_line(fnd_file.output,fnd_message.get);
389: fnd_file.new_line(fnd_file.output,1);
390: fnd_file.put_line(fnd_file.output,l_msg_str_0);
391: fnd_file.put_line(fnd_file.output,RPAD('-',100,'-'));
392: l_msg_prn_1 := FALSE;

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

395:
396:
397: EXCEPTION
398: WHEN others THEN
399: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
400: fnd_message.set_token('NAME','IGF_GR_RFMS_ORIG.LOG_MESSAGE');
401: igs_ge_msg_stack.add;
402: app_exception.raise_exception;
403: END out_message;

Line 400: fnd_message.set_token('NAME','IGF_GR_RFMS_ORIG.LOG_MESSAGE');

396:
397: EXCEPTION
398: WHEN others THEN
399: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
400: fnd_message.set_token('NAME','IGF_GR_RFMS_ORIG.LOG_MESSAGE');
401: igs_ge_msg_stack.add;
402: app_exception.raise_exception;
403: END out_message;
404:

Line 445: fnd_message.set_name('IGF','IGF_GR_REC_CONTAIN_EDIT_CODES');

441: BEGIN
442:
443: IF NVL(TO_NUMBER(RTRIM(LTRIM(p_edit_code))),0) > 0 THEN
444: fnd_file.new_line(fnd_file.log,1);
445: fnd_message.set_name('IGF','IGF_GR_REC_CONTAIN_EDIT_CODES');
446: fnd_file.put_line(fnd_file.log,fnd_message.get);
447:
448: l_msg_str_0 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ORIGINATION_ID'),50) ||
449: RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','DISB_REF_NUM'),50);

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

442:
443: IF NVL(TO_NUMBER(RTRIM(LTRIM(p_edit_code))),0) > 0 THEN
444: fnd_file.new_line(fnd_file.log,1);
445: fnd_message.set_name('IGF','IGF_GR_REC_CONTAIN_EDIT_CODES');
446: fnd_file.put_line(fnd_file.log,fnd_message.get);
447:
448: l_msg_str_0 := RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ORIGINATION_ID'),50) ||
449: RPAD(igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','DISB_REF_NUM'),50);
450:

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

479:
480: EXCEPTION
481:
482: WHEN others THEN
483: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
484: fnd_message.set_token('NAME','IGF_GR_RFMS_ORIG.LOG_MESSAGE');
485: igs_ge_msg_stack.add;
486: app_exception.raise_exception;
487:

Line 484: fnd_message.set_token('NAME','IGF_GR_RFMS_ORIG.LOG_MESSAGE');

480: EXCEPTION
481:
482: WHEN others THEN
483: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
484: fnd_message.set_token('NAME','IGF_GR_RFMS_ORIG.LOG_MESSAGE');
485: igs_ge_msg_stack.add;
486: app_exception.raise_exception;
487:
488: END log_rej_message;

Line 598: fnd_message.set_name('IGF','IGF_GR_NO_RFMS_ORIG');

594: -- message is logged into log file and relevent details are also shown
595: IF cur_rfms_disb%NOTFOUND THEN
596: CLOSE cur_rfms_disb;
597: IF (g_persid_grp IS NULL)THEN
598: fnd_message.set_name('IGF','IGF_GR_NO_RFMS_ORIG');
599: igs_ge_msg_stack.add;
600: fnd_file.put_line(fnd_file.log,fnd_message.get);
601: RAISE no_data_in_table;
602: ELSE

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

596: CLOSE cur_rfms_disb;
597: IF (g_persid_grp IS NULL)THEN
598: fnd_message.set_name('IGF','IGF_GR_NO_RFMS_ORIG');
599: igs_ge_msg_stack.add;
600: fnd_file.put_line(fnd_file.log,fnd_message.get);
601: RAISE no_data_in_table;
602: ELSE
603: RAISE next_record;
604: END IF;

Line 643: fnd_message.set_name('IGF','IGF_GR_RFMS_ORG_ID');

639: -- Student in Context has changed so do the Transaction Check as well Attending Pell child check.
640: l_running_orig_id := rec_rfms_disb.origination_id ;
641: l_valid_rec := TRUE;
642:
643: fnd_message.set_name('IGF','IGF_GR_RFMS_ORG_ID');
644: fnd_message.set_token('ORIG_ID',l_running_orig_id);
645: fnd_file.put_line(fnd_file.log,fnd_message.get);
646:
647: -- Get The Payment ISIR Transaction Number

Line 644: fnd_message.set_token('ORIG_ID',l_running_orig_id);

640: l_running_orig_id := rec_rfms_disb.origination_id ;
641: l_valid_rec := TRUE;
642:
643: fnd_message.set_name('IGF','IGF_GR_RFMS_ORG_ID');
644: fnd_message.set_token('ORIG_ID',l_running_orig_id);
645: fnd_file.put_line(fnd_file.log,fnd_message.get);
646:
647: -- Get The Payment ISIR Transaction Number
648: cur_pymnt_isir_rec := NULL;

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

641: l_valid_rec := TRUE;
642:
643: fnd_message.set_name('IGF','IGF_GR_RFMS_ORG_ID');
644: fnd_message.set_token('ORIG_ID',l_running_orig_id);
645: fnd_file.put_line(fnd_file.log,fnd_message.get);
646:
647: -- Get The Payment ISIR Transaction Number
648: cur_pymnt_isir_rec := NULL;
649: OPEN cur_pymnt_isir(rec_rfms_disb.base_id);

Line 658: fnd_message.set_name('IGF','IGF_AP_NO_PAYMENT_ISIR');

654: IF rec_rfms_disb.transaction_num <> NVL(cur_pymnt_isir_rec.transaction_num,-1) THEN
655: l_valid_rec := FALSE;
656:
657: IF cur_pymnt_isir_rec.transaction_num IS NULL THEN
658: fnd_message.set_name('IGF','IGF_AP_NO_PAYMENT_ISIR');
659: fnd_file.put_line(fnd_file.log,fnd_message.get);
660: ELSE
661: fnd_message.set_name('IGF','IGF_GR_PYMNT_ISIR_MISMATCH');
662: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

655: l_valid_rec := FALSE;
656:
657: IF cur_pymnt_isir_rec.transaction_num IS NULL THEN
658: fnd_message.set_name('IGF','IGF_AP_NO_PAYMENT_ISIR');
659: fnd_file.put_line(fnd_file.log,fnd_message.get);
660: ELSE
661: fnd_message.set_name('IGF','IGF_GR_PYMNT_ISIR_MISMATCH');
662: fnd_file.put_line(fnd_file.log,fnd_message.get);
663: END IF;

Line 661: fnd_message.set_name('IGF','IGF_GR_PYMNT_ISIR_MISMATCH');

657: IF cur_pymnt_isir_rec.transaction_num IS NULL THEN
658: fnd_message.set_name('IGF','IGF_AP_NO_PAYMENT_ISIR');
659: fnd_file.put_line(fnd_file.log,fnd_message.get);
660: ELSE
661: fnd_message.set_name('IGF','IGF_GR_PYMNT_ISIR_MISMATCH');
662: fnd_file.put_line(fnd_file.log,fnd_message.get);
663: END IF;
664: END IF;
665:

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

658: fnd_message.set_name('IGF','IGF_AP_NO_PAYMENT_ISIR');
659: fnd_file.put_line(fnd_file.log,fnd_message.get);
660: ELSE
661: fnd_message.set_name('IGF','IGF_GR_PYMNT_ISIR_MISMATCH');
662: fnd_file.put_line(fnd_file.log,fnd_message.get);
663: END IF;
664: END IF;
665:
666: -- check if attending pell is a child of reporting pell id.

Line 678: FND_MESSAGE.SET_NAME('IGF', 'IGF_GR_ATTEND_PELL_NOT_SETUP');

674: -- If Attending pell child record does not exist?
675: IF (cur_attending_pell%NOTFOUND) THEN
676: l_valid_rec := FALSE;
677:
678: FND_MESSAGE.SET_NAME('IGF', 'IGF_GR_ATTEND_PELL_NOT_SETUP');
679: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
680: END IF;
681: CLOSE cur_attending_pell;
682:

Line 679: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

675: IF (cur_attending_pell%NOTFOUND) THEN
676: l_valid_rec := FALSE;
677:
678: FND_MESSAGE.SET_NAME('IGF', 'IGF_GR_ATTEND_PELL_NOT_SETUP');
679: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
680: END IF;
681: CLOSE cur_attending_pell;
682:
683: -- Check if sum of disbursement amounts is less than origination record's amount.

Line 691: fnd_message.set_name('IGF','IGF_GR_PELL_DIFF_AMTS');

687: CLOSE cur_disb_amt_tot;
688:
689: IF (rec_rfms_disb.pell_amount < rec_disb_amt_tot.disb_amt_tot) THEN
690: l_valid_rec := FALSE;
691: fnd_message.set_name('IGF','IGF_GR_PELL_DIFF_AMTS');
692: FND_MESSAGE.SET_TOKEN('DISB_AMT', TO_CHAR(rec_disb_amt_tot.disb_amt_tot));
693: FND_MESSAGE.SET_TOKEN('PELL_TOT', TO_CHAR(rec_rfms_disb.pell_amount));
694:
695: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 692: FND_MESSAGE.SET_TOKEN('DISB_AMT', TO_CHAR(rec_disb_amt_tot.disb_amt_tot));

688:
689: IF (rec_rfms_disb.pell_amount < rec_disb_amt_tot.disb_amt_tot) THEN
690: l_valid_rec := FALSE;
691: fnd_message.set_name('IGF','IGF_GR_PELL_DIFF_AMTS');
692: FND_MESSAGE.SET_TOKEN('DISB_AMT', TO_CHAR(rec_disb_amt_tot.disb_amt_tot));
693: FND_MESSAGE.SET_TOKEN('PELL_TOT', TO_CHAR(rec_rfms_disb.pell_amount));
694:
695: fnd_file.put_line(fnd_file.log,fnd_message.get);
696: END IF;

Line 693: FND_MESSAGE.SET_TOKEN('PELL_TOT', TO_CHAR(rec_rfms_disb.pell_amount));

689: IF (rec_rfms_disb.pell_amount < rec_disb_amt_tot.disb_amt_tot) THEN
690: l_valid_rec := FALSE;
691: fnd_message.set_name('IGF','IGF_GR_PELL_DIFF_AMTS');
692: FND_MESSAGE.SET_TOKEN('DISB_AMT', TO_CHAR(rec_disb_amt_tot.disb_amt_tot));
693: FND_MESSAGE.SET_TOKEN('PELL_TOT', TO_CHAR(rec_rfms_disb.pell_amount));
694:
695: fnd_file.put_line(fnd_file.log,fnd_message.get);
696: END IF;
697:

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

691: fnd_message.set_name('IGF','IGF_GR_PELL_DIFF_AMTS');
692: FND_MESSAGE.SET_TOKEN('DISB_AMT', TO_CHAR(rec_disb_amt_tot.disb_amt_tot));
693: FND_MESSAGE.SET_TOKEN('PELL_TOT', TO_CHAR(rec_rfms_disb.pell_amount));
694:
695: fnd_file.put_line(fnd_file.log,fnd_message.get);
696: END IF;
697:
698: -- if Context student record is invalid for sending his disbersements
699: -- due to transaction number mismatch or attending pell child does not exist.

Line 739: fnd_message.set_name('IGF','IGF_GR_ORIG_REC_NUM');

735: l_amount_total,
736: l_batch_id);
737:
738: fnd_file.new_line(fnd_file.log,1);
739: fnd_message.set_name('IGF','IGF_GR_ORIG_REC_NUM');
740: fnd_message.set_token('TOT_NUM',TO_CHAR(l_num_of_rec));
741: fnd_file.put_line(fnd_file.log,fnd_message.get);
742: -- p_num_of_rec || ' records written into data file
743: fnd_file.new_line(fnd_file.log,1);

Line 740: fnd_message.set_token('TOT_NUM',TO_CHAR(l_num_of_rec));

736: l_batch_id);
737:
738: fnd_file.new_line(fnd_file.log,1);
739: fnd_message.set_name('IGF','IGF_GR_ORIG_REC_NUM');
740: fnd_message.set_token('TOT_NUM',TO_CHAR(l_num_of_rec));
741: fnd_file.put_line(fnd_file.log,fnd_message.get);
742: -- p_num_of_rec || ' records written into data file
743: fnd_file.new_line(fnd_file.log,1);
744:

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

737:
738: fnd_file.new_line(fnd_file.log,1);
739: fnd_message.set_name('IGF','IGF_GR_ORIG_REC_NUM');
740: fnd_message.set_token('TOT_NUM',TO_CHAR(l_num_of_rec));
741: fnd_file.put_line(fnd_file.log,fnd_message.get);
742: -- p_num_of_rec || ' records written into data file
743: fnd_file.new_line(fnd_file.log,1);
744:
745: IF l_num_of_rec > 0 THEN

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

757: RAISE;
758: WHEN next_record THEN
759: RAISE;
760: WHEN OTHERS THEN
761: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
762: fnd_message.set_token('NAME','IGF_GR_RFMS_DISB_ORIG.RFMS_DISB_ORIG');
763: igs_ge_msg_stack.add;
764: app_exception.raise_exception;
765: END rfms_disb_orig;

Line 762: fnd_message.set_token('NAME','IGF_GR_RFMS_DISB_ORIG.RFMS_DISB_ORIG');

758: WHEN next_record THEN
759: RAISE;
760: WHEN OTHERS THEN
761: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
762: fnd_message.set_token('NAME','IGF_GR_RFMS_DISB_ORIG.RFMS_DISB_ORIG');
763: igs_ge_msg_stack.add;
764: app_exception.raise_exception;
765: END rfms_disb_orig;
766:

Line 832: fnd_message.set_name('IGF','IGF_GR_VRSN_MISMTCH');

828: --
829: igf_gr_gen.match_file_version (g_ver_num, l_batch_id, lv_message);
830:
831: IF lv_message = 'IGF_GR_VRSN_MISMTCH' THEN
832: fnd_message.set_name('IGF','IGF_GR_VRSN_MISMTCH');
833: fnd_message.set_token('CYCL',SUBSTR(l_batch_id,3,4));
834: fnd_message.set_token('BATCH',l_batch_id);
835: fnd_message.set_token('VRSN',g_ver_num);
836: fnd_message.set_token('AWD_YR',g_alt_code);

Line 833: fnd_message.set_token('CYCL',SUBSTR(l_batch_id,3,4));

829: igf_gr_gen.match_file_version (g_ver_num, l_batch_id, lv_message);
830:
831: IF lv_message = 'IGF_GR_VRSN_MISMTCH' THEN
832: fnd_message.set_name('IGF','IGF_GR_VRSN_MISMTCH');
833: fnd_message.set_token('CYCL',SUBSTR(l_batch_id,3,4));
834: fnd_message.set_token('BATCH',l_batch_id);
835: fnd_message.set_token('VRSN',g_ver_num);
836: fnd_message.set_token('AWD_YR',g_alt_code);
837: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 834: fnd_message.set_token('BATCH',l_batch_id);

830:
831: IF lv_message = 'IGF_GR_VRSN_MISMTCH' THEN
832: fnd_message.set_name('IGF','IGF_GR_VRSN_MISMTCH');
833: fnd_message.set_token('CYCL',SUBSTR(l_batch_id,3,4));
834: fnd_message.set_token('BATCH',l_batch_id);
835: fnd_message.set_token('VRSN',g_ver_num);
836: fnd_message.set_token('AWD_YR',g_alt_code);
837: fnd_file.put_line(fnd_file.log,fnd_message.get);
838: RAISE invalid_version;

Line 835: fnd_message.set_token('VRSN',g_ver_num);

831: IF lv_message = 'IGF_GR_VRSN_MISMTCH' THEN
832: fnd_message.set_name('IGF','IGF_GR_VRSN_MISMTCH');
833: fnd_message.set_token('CYCL',SUBSTR(l_batch_id,3,4));
834: fnd_message.set_token('BATCH',l_batch_id);
835: fnd_message.set_token('VRSN',g_ver_num);
836: fnd_message.set_token('AWD_YR',g_alt_code);
837: fnd_file.put_line(fnd_file.log,fnd_message.get);
838: RAISE invalid_version;
839: END IF;

Line 836: fnd_message.set_token('AWD_YR',g_alt_code);

832: fnd_message.set_name('IGF','IGF_GR_VRSN_MISMTCH');
833: fnd_message.set_token('CYCL',SUBSTR(l_batch_id,3,4));
834: fnd_message.set_token('BATCH',l_batch_id);
835: fnd_message.set_token('VRSN',g_ver_num);
836: fnd_message.set_token('AWD_YR',g_alt_code);
837: fnd_file.put_line(fnd_file.log,fnd_message.get);
838: RAISE invalid_version;
839: END IF;
840:

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

833: fnd_message.set_token('CYCL',SUBSTR(l_batch_id,3,4));
834: fnd_message.set_token('BATCH',l_batch_id);
835: fnd_message.set_token('VRSN',g_ver_num);
836: fnd_message.set_token('AWD_YR',g_alt_code);
837: fnd_file.put_line(fnd_file.log,fnd_message.get);
838: RAISE invalid_version;
839: END IF;
840:
841: IF l_number_rec > 0 THEN

Line 916: fnd_message.set_name('IGF','IGF_GR_DISB_INVALID_RECORD');

912: -- The exception caught here will be the data format exceptions
913: WHEN OTHERS THEN
914: lf_count := lf_count + 1;
915: fnd_file.put_line(fnd_file.log, ' ' );
916: fnd_message.set_name('IGF','IGF_GR_DISB_INVALID_RECORD');
917: fnd_message.set_token('ORIG_ID',l_rfms.origination_id);
918: -- Cannot Process Record for Origination ORIG_ID as it contains corrupt data
919: fnd_file.put_line(fnd_file.log,fnd_message.get);
920:

Line 917: fnd_message.set_token('ORIG_ID',l_rfms.origination_id);

913: WHEN OTHERS THEN
914: lf_count := lf_count + 1;
915: fnd_file.put_line(fnd_file.log, ' ' );
916: fnd_message.set_name('IGF','IGF_GR_DISB_INVALID_RECORD');
917: fnd_message.set_token('ORIG_ID',l_rfms.origination_id);
918: -- Cannot Process Record for Origination ORIG_ID as it contains corrupt data
919: fnd_file.put_line(fnd_file.log,fnd_message.get);
920:
921: fnd_message.set_name('IGF','IGF_SL_SKIPPING');

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

915: fnd_file.put_line(fnd_file.log, ' ' );
916: fnd_message.set_name('IGF','IGF_GR_DISB_INVALID_RECORD');
917: fnd_message.set_token('ORIG_ID',l_rfms.origination_id);
918: -- Cannot Process Record for Origination ORIG_ID as it contains corrupt data
919: fnd_file.put_line(fnd_file.log,fnd_message.get);
920:
921: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
922: fnd_file.put_line(fnd_file.log,fnd_message.get);
923: fnd_file.put_line(fnd_file.log, ' ' );

Line 921: fnd_message.set_name('IGF','IGF_SL_SKIPPING');

917: fnd_message.set_token('ORIG_ID',l_rfms.origination_id);
918: -- Cannot Process Record for Origination ORIG_ID as it contains corrupt data
919: fnd_file.put_line(fnd_file.log,fnd_message.get);
920:
921: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
922: fnd_file.put_line(fnd_file.log,fnd_message.get);
923: fnd_file.put_line(fnd_file.log, ' ' );
924:
925: RAISE igf_gr_gen.skip_this_record;

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

918: -- Cannot Process Record for Origination ORIG_ID as it contains corrupt data
919: fnd_file.put_line(fnd_file.log,fnd_message.get);
920:
921: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
922: fnd_file.put_line(fnd_file.log,fnd_message.get);
923: fnd_file.put_line(fnd_file.log, ' ' );
924:
925: RAISE igf_gr_gen.skip_this_record;
926:

Line 944: fnd_message.set_name('IGF','IGF_GR_NO_RFMS_ORIG');

940:
941: IF cur_disb_orig%NOTFOUND THEN
942: CLOSE cur_disb_orig;
943: fnd_file.put_line(fnd_file.log,' ');
944: fnd_message.set_name('IGF','IGF_GR_NO_RFMS_ORIG');
945: fnd_file.put_line(fnd_file.log,fnd_message.get);
946: --write to log file
947: log_message(l_batch_id,LTRIM(RTRIM(SUBSTR(rec_data.record_data,1,23))));
948: RAISE igf_gr_gen.skip_this_record;

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

941: IF cur_disb_orig%NOTFOUND THEN
942: CLOSE cur_disb_orig;
943: fnd_file.put_line(fnd_file.log,' ');
944: fnd_message.set_name('IGF','IGF_GR_NO_RFMS_ORIG');
945: fnd_file.put_line(fnd_file.log,fnd_message.get);
946: --write to log file
947: log_message(l_batch_id,LTRIM(RTRIM(SUBSTR(rec_data.record_data,1,23))));
948: RAISE igf_gr_gen.skip_this_record;
949: END IF;

Line 954: fnd_message.set_name('IGF','IGF_GR_DISB_BATCH_MISMATCH');

950:
951: ----Bug #2938258
952: IF l_rfmb_id<>rec_disb_orig.rfmb_id THEN
953:
954: fnd_message.set_name('IGF','IGF_GR_DISB_BATCH_MISMATCH');
955: fnd_message.set_token('BATCH_ID',l_batch_id);
956: fnd_message.set_token('DISB_ID',l_rfms.origination_id );
957: fnd_file.put_line(fnd_file.log,fnd_message.get);
958: fnd_file.new_line(fnd_file.log,1);

Line 955: fnd_message.set_token('BATCH_ID',l_batch_id);

951: ----Bug #2938258
952: IF l_rfmb_id<>rec_disb_orig.rfmb_id THEN
953:
954: fnd_message.set_name('IGF','IGF_GR_DISB_BATCH_MISMATCH');
955: fnd_message.set_token('BATCH_ID',l_batch_id);
956: fnd_message.set_token('DISB_ID',l_rfms.origination_id );
957: fnd_file.put_line(fnd_file.log,fnd_message.get);
958: fnd_file.new_line(fnd_file.log,1);
959: RAISE igf_gr_gen.skip_this_record;

Line 956: fnd_message.set_token('DISB_ID',l_rfms.origination_id );

952: IF l_rfmb_id<>rec_disb_orig.rfmb_id THEN
953:
954: fnd_message.set_name('IGF','IGF_GR_DISB_BATCH_MISMATCH');
955: fnd_message.set_token('BATCH_ID',l_batch_id);
956: fnd_message.set_token('DISB_ID',l_rfms.origination_id );
957: fnd_file.put_line(fnd_file.log,fnd_message.get);
958: fnd_file.new_line(fnd_file.log,1);
959: RAISE igf_gr_gen.skip_this_record;
960: END IF;

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

953:
954: fnd_message.set_name('IGF','IGF_GR_DISB_BATCH_MISMATCH');
955: fnd_message.set_token('BATCH_ID',l_batch_id);
956: fnd_message.set_token('DISB_ID',l_rfms.origination_id );
957: fnd_file.put_line(fnd_file.log,fnd_message.get);
958: fnd_file.new_line(fnd_file.log,1);
959: RAISE igf_gr_gen.skip_this_record;
960: END IF;
961:

Line 965: fnd_message.set_name('IGF','IGF_GR_DISB_NOT_IN_SENT');

961:
962: IF rec_disb_orig.disb_ack_act_status <> 'S' THEN
963:
964:
965: fnd_message.set_name('IGF','IGF_GR_DISB_NOT_IN_SENT');
966: fnd_message.set_token('DISB_ID',l_rfms.origination_id );
967: SYSTEM_STATUS := igf_aw_gen.lookup_desc('IGF_GR_ORIG_STATUS',rec_disb_orig.disb_ack_act_status);
968: fnd_message.set_token('SYS_STATUS',SYSTEM_STATUS );
969: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 966: fnd_message.set_token('DISB_ID',l_rfms.origination_id );

962: IF rec_disb_orig.disb_ack_act_status <> 'S' THEN
963:
964:
965: fnd_message.set_name('IGF','IGF_GR_DISB_NOT_IN_SENT');
966: fnd_message.set_token('DISB_ID',l_rfms.origination_id );
967: SYSTEM_STATUS := igf_aw_gen.lookup_desc('IGF_GR_ORIG_STATUS',rec_disb_orig.disb_ack_act_status);
968: fnd_message.set_token('SYS_STATUS',SYSTEM_STATUS );
969: fnd_file.put_line(fnd_file.log,fnd_message.get);
970: fnd_file.new_line(fnd_file.log,1);

Line 968: fnd_message.set_token('SYS_STATUS',SYSTEM_STATUS );

964:
965: fnd_message.set_name('IGF','IGF_GR_DISB_NOT_IN_SENT');
966: fnd_message.set_token('DISB_ID',l_rfms.origination_id );
967: SYSTEM_STATUS := igf_aw_gen.lookup_desc('IGF_GR_ORIG_STATUS',rec_disb_orig.disb_ack_act_status);
968: fnd_message.set_token('SYS_STATUS',SYSTEM_STATUS );
969: fnd_file.put_line(fnd_file.log,fnd_message.get);
970: fnd_file.new_line(fnd_file.log,1);
971:
972: RAISE igf_gr_gen.skip_this_record;

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

965: fnd_message.set_name('IGF','IGF_GR_DISB_NOT_IN_SENT');
966: fnd_message.set_token('DISB_ID',l_rfms.origination_id );
967: SYSTEM_STATUS := igf_aw_gen.lookup_desc('IGF_GR_ORIG_STATUS',rec_disb_orig.disb_ack_act_status);
968: fnd_message.set_token('SYS_STATUS',SYSTEM_STATUS );
969: fnd_file.put_line(fnd_file.log,fnd_message.get);
970: fnd_file.new_line(fnd_file.log,1);
971:
972: RAISE igf_gr_gen.skip_this_record;
973: END IF;

Line 1021: fnd_message.set_name('IGF','IGF_GR_DIFF_PELL_DISB');

1017:
1018: IF l_rfms.disb_accpt_amt <> l_rfms.disb_amt THEN
1019:
1020: igf_gr_gen.insert_sys_holds(rec_award.award_id,rec_disb_orig.disb_ref_num,'PELL');
1021: fnd_message.set_name('IGF','IGF_GR_DIFF_PELL_DISB');
1022: fnd_message.set_token('ORIG_ID',l_rfms.origination_id);
1023: fnd_message.set_token('DISB_NUM',l_rfms.disb_ref_num);
1024: fnd_file.put_line(fnd_file.log,fnd_message.get);
1025:

Line 1022: fnd_message.set_token('ORIG_ID',l_rfms.origination_id);

1018: IF l_rfms.disb_accpt_amt <> l_rfms.disb_amt THEN
1019:
1020: igf_gr_gen.insert_sys_holds(rec_award.award_id,rec_disb_orig.disb_ref_num,'PELL');
1021: fnd_message.set_name('IGF','IGF_GR_DIFF_PELL_DISB');
1022: fnd_message.set_token('ORIG_ID',l_rfms.origination_id);
1023: fnd_message.set_token('DISB_NUM',l_rfms.disb_ref_num);
1024: fnd_file.put_line(fnd_file.log,fnd_message.get);
1025:
1026: fnd_message.set_name('IGF','IGF_GR_REPORTED_AMT');

Line 1023: fnd_message.set_token('DISB_NUM',l_rfms.disb_ref_num);

1019:
1020: igf_gr_gen.insert_sys_holds(rec_award.award_id,rec_disb_orig.disb_ref_num,'PELL');
1021: fnd_message.set_name('IGF','IGF_GR_DIFF_PELL_DISB');
1022: fnd_message.set_token('ORIG_ID',l_rfms.origination_id);
1023: fnd_message.set_token('DISB_NUM',l_rfms.disb_ref_num);
1024: fnd_file.put_line(fnd_file.log,fnd_message.get);
1025:
1026: fnd_message.set_name('IGF','IGF_GR_REPORTED_AMT');
1027: fnd_message.set_token('AMT', TO_CHAR(l_rfms.disb_amt));

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

1020: igf_gr_gen.insert_sys_holds(rec_award.award_id,rec_disb_orig.disb_ref_num,'PELL');
1021: fnd_message.set_name('IGF','IGF_GR_DIFF_PELL_DISB');
1022: fnd_message.set_token('ORIG_ID',l_rfms.origination_id);
1023: fnd_message.set_token('DISB_NUM',l_rfms.disb_ref_num);
1024: fnd_file.put_line(fnd_file.log,fnd_message.get);
1025:
1026: fnd_message.set_name('IGF','IGF_GR_REPORTED_AMT');
1027: fnd_message.set_token('AMT', TO_CHAR(l_rfms.disb_amt));
1028: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 1026: fnd_message.set_name('IGF','IGF_GR_REPORTED_AMT');

1022: fnd_message.set_token('ORIG_ID',l_rfms.origination_id);
1023: fnd_message.set_token('DISB_NUM',l_rfms.disb_ref_num);
1024: fnd_file.put_line(fnd_file.log,fnd_message.get);
1025:
1026: fnd_message.set_name('IGF','IGF_GR_REPORTED_AMT');
1027: fnd_message.set_token('AMT', TO_CHAR(l_rfms.disb_amt));
1028: fnd_file.put_line(fnd_file.log,fnd_message.get);
1029:
1030: fnd_message.set_name('IGF','IGF_GR_RECEIVED_AMT');

Line 1027: fnd_message.set_token('AMT', TO_CHAR(l_rfms.disb_amt));

1023: fnd_message.set_token('DISB_NUM',l_rfms.disb_ref_num);
1024: fnd_file.put_line(fnd_file.log,fnd_message.get);
1025:
1026: fnd_message.set_name('IGF','IGF_GR_REPORTED_AMT');
1027: fnd_message.set_token('AMT', TO_CHAR(l_rfms.disb_amt));
1028: fnd_file.put_line(fnd_file.log,fnd_message.get);
1029:
1030: fnd_message.set_name('IGF','IGF_GR_RECEIVED_AMT');
1031: fnd_message.set_token('AMT', TO_CHAR(l_rfms.disb_accpt_amt));

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

1024: fnd_file.put_line(fnd_file.log,fnd_message.get);
1025:
1026: fnd_message.set_name('IGF','IGF_GR_REPORTED_AMT');
1027: fnd_message.set_token('AMT', TO_CHAR(l_rfms.disb_amt));
1028: fnd_file.put_line(fnd_file.log,fnd_message.get);
1029:
1030: fnd_message.set_name('IGF','IGF_GR_RECEIVED_AMT');
1031: fnd_message.set_token('AMT', TO_CHAR(l_rfms.disb_accpt_amt));
1032: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 1030: fnd_message.set_name('IGF','IGF_GR_RECEIVED_AMT');

1026: fnd_message.set_name('IGF','IGF_GR_REPORTED_AMT');
1027: fnd_message.set_token('AMT', TO_CHAR(l_rfms.disb_amt));
1028: fnd_file.put_line(fnd_file.log,fnd_message.get);
1029:
1030: fnd_message.set_name('IGF','IGF_GR_RECEIVED_AMT');
1031: fnd_message.set_token('AMT', TO_CHAR(l_rfms.disb_accpt_amt));
1032: fnd_file.put_line(fnd_file.log,fnd_message.get);
1033: fnd_file.new_line(fnd_file.log,1);
1034:

Line 1031: fnd_message.set_token('AMT', TO_CHAR(l_rfms.disb_accpt_amt));

1027: fnd_message.set_token('AMT', TO_CHAR(l_rfms.disb_amt));
1028: fnd_file.put_line(fnd_file.log,fnd_message.get);
1029:
1030: fnd_message.set_name('IGF','IGF_GR_RECEIVED_AMT');
1031: fnd_message.set_token('AMT', TO_CHAR(l_rfms.disb_accpt_amt));
1032: fnd_file.put_line(fnd_file.log,fnd_message.get);
1033: fnd_file.new_line(fnd_file.log,1);
1034:
1035: END IF;

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

1028: fnd_file.put_line(fnd_file.log,fnd_message.get);
1029:
1030: fnd_message.set_name('IGF','IGF_GR_RECEIVED_AMT');
1031: fnd_message.set_token('AMT', TO_CHAR(l_rfms.disb_accpt_amt));
1032: fnd_file.put_line(fnd_file.log,fnd_message.get);
1033: fnd_file.new_line(fnd_file.log,1);
1034:
1035: END IF;
1036:

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

1051:
1052: END LOOP;
1053:
1054: IF l_actual_rec <> l_number_rec THEN
1055: fnd_message.set_name('IGF','IGF_GE_RECORD_NUM_NOT_MATCH');
1056: igs_ge_msg_stack.add;
1057: RAISE igf_gr_gen.file_not_loaded;
1058: END IF;
1059:

Line 1064: fnd_message.set_name('IGF','IGF_GR_FILE_REC_CNT');

1060: END; -- Inner Begin
1061:
1062: fnd_file.new_line(fnd_file.log,2);
1063:
1064: fnd_message.set_name('IGF','IGF_GR_FILE_REC_CNT');
1065: fnd_message.set_token('CNT',l_number_rec);
1066: fnd_file.put_line(fnd_file.log,fnd_message.get);
1067:
1068: fnd_message.set_name('IGF','IGF_GR_FILE_REC_PAS');

Line 1065: fnd_message.set_token('CNT',l_number_rec);

1061:
1062: fnd_file.new_line(fnd_file.log,2);
1063:
1064: fnd_message.set_name('IGF','IGF_GR_FILE_REC_CNT');
1065: fnd_message.set_token('CNT',l_number_rec);
1066: fnd_file.put_line(fnd_file.log,fnd_message.get);
1067:
1068: fnd_message.set_name('IGF','IGF_GR_FILE_REC_PAS');
1069: fnd_message.set_token('CNT',lp_count);

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

1062: fnd_file.new_line(fnd_file.log,2);
1063:
1064: fnd_message.set_name('IGF','IGF_GR_FILE_REC_CNT');
1065: fnd_message.set_token('CNT',l_number_rec);
1066: fnd_file.put_line(fnd_file.log,fnd_message.get);
1067:
1068: fnd_message.set_name('IGF','IGF_GR_FILE_REC_PAS');
1069: fnd_message.set_token('CNT',lp_count);
1070: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 1068: fnd_message.set_name('IGF','IGF_GR_FILE_REC_PAS');

1064: fnd_message.set_name('IGF','IGF_GR_FILE_REC_CNT');
1065: fnd_message.set_token('CNT',l_number_rec);
1066: fnd_file.put_line(fnd_file.log,fnd_message.get);
1067:
1068: fnd_message.set_name('IGF','IGF_GR_FILE_REC_PAS');
1069: fnd_message.set_token('CNT',lp_count);
1070: fnd_file.put_line(fnd_file.log,fnd_message.get);
1071:
1072: fnd_message.set_name('IGF','IGF_GR_FILE_REC_FAL');

Line 1069: fnd_message.set_token('CNT',lp_count);

1065: fnd_message.set_token('CNT',l_number_rec);
1066: fnd_file.put_line(fnd_file.log,fnd_message.get);
1067:
1068: fnd_message.set_name('IGF','IGF_GR_FILE_REC_PAS');
1069: fnd_message.set_token('CNT',lp_count);
1070: fnd_file.put_line(fnd_file.log,fnd_message.get);
1071:
1072: fnd_message.set_name('IGF','IGF_GR_FILE_REC_FAL');
1073: fnd_message.set_token('CNT',lf_count);

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

1066: fnd_file.put_line(fnd_file.log,fnd_message.get);
1067:
1068: fnd_message.set_name('IGF','IGF_GR_FILE_REC_PAS');
1069: fnd_message.set_token('CNT',lp_count);
1070: fnd_file.put_line(fnd_file.log,fnd_message.get);
1071:
1072: fnd_message.set_name('IGF','IGF_GR_FILE_REC_FAL');
1073: fnd_message.set_token('CNT',lf_count);
1074: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 1072: fnd_message.set_name('IGF','IGF_GR_FILE_REC_FAL');

1068: fnd_message.set_name('IGF','IGF_GR_FILE_REC_PAS');
1069: fnd_message.set_token('CNT',lp_count);
1070: fnd_file.put_line(fnd_file.log,fnd_message.get);
1071:
1072: fnd_message.set_name('IGF','IGF_GR_FILE_REC_FAL');
1073: fnd_message.set_token('CNT',lf_count);
1074: fnd_file.put_line(fnd_file.log,fnd_message.get);
1075:
1076: END IF; -- if l_num_rec --

Line 1073: fnd_message.set_token('CNT',lf_count);

1069: fnd_message.set_token('CNT',lp_count);
1070: fnd_file.put_line(fnd_file.log,fnd_message.get);
1071:
1072: fnd_message.set_name('IGF','IGF_GR_FILE_REC_FAL');
1073: fnd_message.set_token('CNT',lf_count);
1074: fnd_file.put_line(fnd_file.log,fnd_message.get);
1075:
1076: END IF; -- if l_num_rec --
1077:

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

1070: fnd_file.put_line(fnd_file.log,fnd_message.get);
1071:
1072: fnd_message.set_name('IGF','IGF_GR_FILE_REC_FAL');
1073: fnd_message.set_token('CNT',lf_count);
1074: fnd_file.put_line(fnd_file.log,fnd_message.get);
1075:
1076: END IF; -- if l_num_rec --
1077:
1078: EXCEPTION

Line 1090: fnd_message.set_name('IGF','IGF_SL_GR_BATCH_DOES_NO_EXIST');

1086: WHEN no_data_in_table THEN
1087: RAISE;
1088: WHEN igf_gr_gen.batch_not_in_system THEN
1089: -- Bug # 4008991
1090: fnd_message.set_name('IGF','IGF_SL_GR_BATCH_DOES_NO_EXIST');
1091: fnd_message.set_token('BATCH_ID',l_batch_id);
1092: RAISE;
1093: WHEN igf_gr_gen.file_not_loaded THEN
1094: RAISE;

Line 1091: fnd_message.set_token('BATCH_ID',l_batch_id);

1087: RAISE;
1088: WHEN igf_gr_gen.batch_not_in_system THEN
1089: -- Bug # 4008991
1090: fnd_message.set_name('IGF','IGF_SL_GR_BATCH_DOES_NO_EXIST');
1091: fnd_message.set_token('BATCH_ID',l_batch_id);
1092: RAISE;
1093: WHEN igf_gr_gen.file_not_loaded THEN
1094: RAISE;
1095: WHEN OTHERS THEN

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

1092: RAISE;
1093: WHEN igf_gr_gen.file_not_loaded THEN
1094: RAISE;
1095: WHEN OTHERS THEN
1096: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1097: fnd_message.set_token('NAME','IGF_GR_RFMS_DISB_ORIG.RFMS_DISB_ACK');
1098: igs_ge_msg_stack.add;
1099: app_exception.raise_exception;
1100: END rfms_disb_ack;

Line 1097: fnd_message.set_token('NAME','IGF_GR_RFMS_DISB_ORIG.RFMS_DISB_ACK');

1093: WHEN igf_gr_gen.file_not_loaded THEN
1094: RAISE;
1095: WHEN OTHERS THEN
1096: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1097: fnd_message.set_token('NAME','IGF_GR_RFMS_DISB_ORIG.RFMS_DISB_ACK');
1098: igs_ge_msg_stack.add;
1099: app_exception.raise_exception;
1100: END rfms_disb_ack;
1101:

Line 1208: fnd_message.set_name('IGF','IGF_GR_COD_NO_DISB');

1204: -- If the award year is FULL_PARTICIPANT then raise the error message
1205: -- and stop processing else continue the process
1206: IF l_cod_year_flag THEN
1207:
1208: fnd_message.set_name('IGF','IGF_GR_COD_NO_DISB');
1209: fnd_file.put_line(fnd_file.log,fnd_message.get);
1210: RETURN;
1211:
1212: END IF;

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

1205: -- and stop processing else continue the process
1206: IF l_cod_year_flag THEN
1207:
1208: fnd_message.set_name('IGF','IGF_GR_COD_NO_DISB');
1209: fnd_file.put_line(fnd_file.log,fnd_message.get);
1210: RETURN;
1211:
1212: END IF;
1213:

Line 1216: FND_MESSAGE.SET_NAME('IGF', 'IGF_GR_PORIG_INCOMPAT');

1212: END IF;
1213:
1214: -- FA 126. base_id and attending pell are mutually exclusive.
1215: IF (base_id IS NOT NULL AND p_attending_pell IS NOT NULL) OR (p_pers_id_grp IS NOT NULL AND p_attending_pell IS NOT NULL) THEN
1216: FND_MESSAGE.SET_NAME('IGF', 'IGF_GR_PORIG_INCOMPAT');
1217: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
1218: RETURN;
1219: END IF;
1220:

Line 1217: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

1213:
1214: -- FA 126. base_id and attending pell are mutually exclusive.
1215: IF (base_id IS NOT NULL AND p_attending_pell IS NOT NULL) OR (p_pers_id_grp IS NOT NULL AND p_attending_pell IS NOT NULL) THEN
1216: FND_MESSAGE.SET_NAME('IGF', 'IGF_GR_PORIG_INCOMPAT');
1217: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
1218: RETURN;
1219: END IF;
1220:
1221: IF l_ci_cal_type IS NULL OR l_ci_sequence_number IS NULL THEN

Line 1328: fnd_message.set_name('IGF','IGF_DB_NO_PER_GRP');

1324: IF l_error = l_record THEN
1325: RAISE no_data_in_table;
1326: END IF;
1327: ELSE
1328: fnd_message.set_name('IGF','IGF_DB_NO_PER_GRP');
1329: fnd_file.put_line(fnd_file.log,fnd_message.get);
1330: END IF;
1331: ELSE
1332: RAISE param_error;

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

1325: RAISE no_data_in_table;
1326: END IF;
1327: ELSE
1328: fnd_message.set_name('IGF','IGF_DB_NO_PER_GRP');
1329: fnd_file.put_line(fnd_file.log,fnd_message.get);
1330: END IF;
1331: ELSE
1332: RAISE param_error;
1333: END IF;

Line 1341: errbuf := fnd_message.get_string('IGF','IGF_GR_VERSION_NOTFOUND');

1337: EXCEPTION
1338: WHEN igf_gr_gen.no_file_version THEN
1339: ROLLBACK;
1340: retcode := 2;
1341: errbuf := fnd_message.get_string('IGF','IGF_GR_VERSION_NOTFOUND');
1342: fnd_file.put_line(fnd_file.log,errbuf);
1343: WHEN batch_not_created THEN
1344: ROLLBACK;
1345: WHEN param_error THEN

Line 1348: errbuf := fnd_message.get_string('IGF','IGF_AW_PARAM_ERR');

1344: ROLLBACK;
1345: WHEN param_error THEN
1346: ROLLBACK;
1347: retcode := 2;
1348: errbuf := fnd_message.get_string('IGF','IGF_AW_PARAM_ERR');
1349: fnd_file.put_line(fnd_file.log,errbuf);
1350: WHEN no_data_in_table THEN
1351: ROLLBACK;
1352: errbuf := fnd_message.get_string('IGF','IGF_AP_NO_DATA_FOUND');

Line 1352: errbuf := fnd_message.get_string('IGF','IGF_AP_NO_DATA_FOUND');

1348: errbuf := fnd_message.get_string('IGF','IGF_AW_PARAM_ERR');
1349: fnd_file.put_line(fnd_file.log,errbuf);
1350: WHEN no_data_in_table THEN
1351: ROLLBACK;
1352: errbuf := fnd_message.get_string('IGF','IGF_AP_NO_DATA_FOUND');
1353: fnd_file.put_line(fnd_file.log,errbuf);
1354: WHEN OTHERS THEN
1355: ROLLBACK;
1356: retcode := 2;

Line 1357: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION') || SQLERRM;

1353: fnd_file.put_line(fnd_file.log,errbuf);
1354: WHEN OTHERS THEN
1355: ROLLBACK;
1356: retcode := 2;
1357: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION') || SQLERRM;
1358: igs_ge_msg_stack.conc_exception_hndl;
1359: END main;
1360:
1361:

Line 1408: fnd_message.set_name('IGF','IGF_GR_COD_NO_DISB_ACK');

1404: -- If the award year is FULL_PARTICIPANT then raise the error message
1405: -- and stop processing else continue the process
1406: IF igf_sl_dl_validation.check_full_participant (l_ci_cal_type,l_ci_sequence_number,'PELL') THEN
1407:
1408: fnd_message.set_name('IGF','IGF_GR_COD_NO_DISB_ACK');
1409: fnd_file.put_line(fnd_file.log,fnd_message.get);
1410: RETURN;
1411:
1412: END IF;

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

1405: -- and stop processing else continue the process
1406: IF igf_sl_dl_validation.check_full_participant (l_ci_cal_type,l_ci_sequence_number,'PELL') THEN
1407:
1408: fnd_message.set_name('IGF','IGF_GR_COD_NO_DISB_ACK');
1409: fnd_file.put_line(fnd_file.log,fnd_message.get);
1410: RETURN;
1411:
1412: END IF;
1413:

Line 1439: errbuf := fnd_message.get_string('IGF','IGF_GR_VERSION_NOTFOUND');

1435:
1436: WHEN igf_gr_gen.no_file_version THEN
1437: ROLLBACK;
1438: retcode := 2;
1439: errbuf := fnd_message.get_string('IGF','IGF_GR_VERSION_NOTFOUND');
1440: fnd_file.put_line(fnd_file.log,errbuf);
1441:
1442: WHEN batch_not_created THEN
1443: ROLLBACK;

Line 1448: errbuf := fnd_message.get_string('IGF','IGF_AW_PARAM_ERR');

1444:
1445: WHEN param_error THEN
1446: ROLLBACK;
1447: retcode := 2;
1448: errbuf := fnd_message.get_string('IGF','IGF_AW_PARAM_ERR');
1449: fnd_file.put_line(fnd_file.log,errbuf);
1450:
1451: WHEN igf_gr_gen.corrupt_data_file THEN
1452: ROLLBACK;

Line 1454: errbuf := fnd_message.get_string('IGF','IGF_GR_CORRUPT_DATA_FILE');

1450:
1451: WHEN igf_gr_gen.corrupt_data_file THEN
1452: ROLLBACK;
1453: retcode := 2;
1454: errbuf := fnd_message.get_string('IGF','IGF_GR_CORRUPT_DATA_FILE');
1455: fnd_file.put_line(fnd_file.log,errbuf);
1456:
1457: WHEN igf_gr_gen.batch_not_in_system THEN
1458: ROLLBACK;

Line 1460: errbuf := fnd_message.get; -- Bug # 4008991

1456:
1457: WHEN igf_gr_gen.batch_not_in_system THEN
1458: ROLLBACK;
1459: retcode := 2;
1460: errbuf := fnd_message.get; -- Bug # 4008991
1461: fnd_file.put_line(fnd_file.log,errbuf);
1462:
1463: WHEN igf_gr_gen.file_not_loaded THEN
1464: ROLLBACK;

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

1462:
1463: WHEN igf_gr_gen.file_not_loaded THEN
1464: ROLLBACK;
1465: retcode := 2;
1466: errbuf := fnd_message.get_string('IGF','IGF_GE_FILE_NOT_LOADED');
1467: fnd_file.put_line(fnd_file.log,errbuf);
1468:
1469: WHEN no_data_in_table THEN
1470: ROLLBACK;

Line 1471: errbuf := fnd_message.get_string('IGF','IGF_AP_NO_DATA_FOUND');

1467: fnd_file.put_line(fnd_file.log,errbuf);
1468:
1469: WHEN no_data_in_table THEN
1470: ROLLBACK;
1471: errbuf := fnd_message.get_string('IGF','IGF_AP_NO_DATA_FOUND');
1472: fnd_file.put_line(fnd_file.log,errbuf);
1473:
1474: WHEN OTHERS THEN
1475: ROLLBACK;

Line 1477: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION') || SQLERRM;

1473:
1474: WHEN OTHERS THEN
1475: ROLLBACK;
1476: retcode := 2;
1477: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION') || SQLERRM;
1478: igs_ge_msg_stack.conc_exception_hndl;
1479:
1480: END main_ack;
1481: