DBA Data[Home] [Help]

APPS.IGF_SL_DL_CHG_ORIG dependencies on FND_MESSAGE

Line 334: fnd_message.set_name('IGF','IGF_SL_NO_CHG_CODE');

330: OPEN c_chg_code;
331: FETCH c_chg_code INTO lc_chg_code;
332: IF c_chg_code%NOTFOUND THEN
333: CLOSE c_chg_code;
334: fnd_message.set_name('IGF','IGF_SL_NO_CHG_CODE');
335: fnd_message.set_token('FLD_NAME', igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS', p_field_name));
336: fnd_message.set_token('LOAN_CATG', igf_aw_gen.lookup_desc('IGF_SL_DL_LOAN_CATG',p_dl_loan_catg));
337: fnd_message.set_token('DL_VERSION',igf_aw_gen.lookup_desc('IGF_SL_DL_VERSION', lv_dl_version ));
338: igs_ge_msg_stack.add;

Line 335: fnd_message.set_token('FLD_NAME', igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS', p_field_name));

331: FETCH c_chg_code INTO lc_chg_code;
332: IF c_chg_code%NOTFOUND THEN
333: CLOSE c_chg_code;
334: fnd_message.set_name('IGF','IGF_SL_NO_CHG_CODE');
335: fnd_message.set_token('FLD_NAME', igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS', p_field_name));
336: fnd_message.set_token('LOAN_CATG', igf_aw_gen.lookup_desc('IGF_SL_DL_LOAN_CATG',p_dl_loan_catg));
337: fnd_message.set_token('DL_VERSION',igf_aw_gen.lookup_desc('IGF_SL_DL_VERSION', lv_dl_version ));
338: igs_ge_msg_stack.add;
339: app_exception.raise_exception;

Line 336: fnd_message.set_token('LOAN_CATG', igf_aw_gen.lookup_desc('IGF_SL_DL_LOAN_CATG',p_dl_loan_catg));

332: IF c_chg_code%NOTFOUND THEN
333: CLOSE c_chg_code;
334: fnd_message.set_name('IGF','IGF_SL_NO_CHG_CODE');
335: fnd_message.set_token('FLD_NAME', igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS', p_field_name));
336: fnd_message.set_token('LOAN_CATG', igf_aw_gen.lookup_desc('IGF_SL_DL_LOAN_CATG',p_dl_loan_catg));
337: fnd_message.set_token('DL_VERSION',igf_aw_gen.lookup_desc('IGF_SL_DL_VERSION', lv_dl_version ));
338: igs_ge_msg_stack.add;
339: app_exception.raise_exception;
340: END IF;

Line 337: fnd_message.set_token('DL_VERSION',igf_aw_gen.lookup_desc('IGF_SL_DL_VERSION', lv_dl_version ));

333: CLOSE c_chg_code;
334: fnd_message.set_name('IGF','IGF_SL_NO_CHG_CODE');
335: fnd_message.set_token('FLD_NAME', igf_aw_gen.lookup_desc('IGF_SL_LOAN_FIELDS', p_field_name));
336: fnd_message.set_token('LOAN_CATG', igf_aw_gen.lookup_desc('IGF_SL_DL_LOAN_CATG',p_dl_loan_catg));
337: fnd_message.set_token('DL_VERSION',igf_aw_gen.lookup_desc('IGF_SL_DL_VERSION', lv_dl_version ));
338: igs_ge_msg_stack.add;
339: app_exception.raise_exception;
340: END IF;
341:

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

361: WHEN OTHERS THEN
362: IF c_chg_code%ISOPEN THEN
363: CLOSE c_chg_code;
364: END IF;
365: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
366: fnd_message.set_token('NAME','IGF_SL_DL_CHG_ORIG.COMP_LOR_LOC');
367: fnd_file.put_line(fnd_file.log,SQLERRM);
368: igs_ge_msg_stack.add;
369: app_exception.raise_exception;

Line 366: fnd_message.set_token('NAME','IGF_SL_DL_CHG_ORIG.COMP_LOR_LOC');

362: IF c_chg_code%ISOPEN THEN
363: CLOSE c_chg_code;
364: END IF;
365: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
366: fnd_message.set_token('NAME','IGF_SL_DL_CHG_ORIG.COMP_LOR_LOC');
367: fnd_file.put_line(fnd_file.log,SQLERRM);
368: igs_ge_msg_stack.add;
369: app_exception.raise_exception;
370: END comp_lor_loc;

Line 386: fnd_message.set_name('IGF','IGF_SL_NO_CALENDAR');

382: OPEN cur_alternate_code;
383: FETCH cur_alternate_code INTO l_alternate_code;
384: IF cur_alternate_code%NOTFOUND THEN
385: CLOSE cur_alternate_code;
386: fnd_message.set_name('IGF','IGF_SL_NO_CALENDAR');
387: IGS_GE_MSG_STACK.ADD;
388: fnd_file.put_line(fnd_file.log,fnd_message.get);
389:
390: app_exception.raise_exception;

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

384: IF cur_alternate_code%NOTFOUND THEN
385: CLOSE cur_alternate_code;
386: fnd_message.set_name('IGF','IGF_SL_NO_CALENDAR');
387: IGS_GE_MSG_STACK.ADD;
388: fnd_file.put_line(fnd_file.log,fnd_message.get);
389:
390: app_exception.raise_exception;
391: END IF;
392: CLOSE cur_alternate_code;

Line 416: fnd_message.set_name('IGF','IGF_SL_COD_NO_CHG_ORIG');

412: fnd_file.put_line(fnd_file.log,RPAD(c_get_sch_code_rec.meaning,50,' ')||':'||RPAD(' ',4,' ')||p_school_code);
413:
414: IF (igf_sl_dl_validation.check_full_participant (lv_cal_type, lv_cal_seq_num,'DL') ) THEN
415: -- Log an error message
416: fnd_message.set_name('IGF','IGF_SL_COD_NO_CHG_ORIG');
417: fnd_file.put_line(fnd_file.log,fnd_message.get);
418: raise yr_full_participant;
419: END IF;
420:

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

413:
414: IF (igf_sl_dl_validation.check_full_participant (lv_cal_type, lv_cal_seq_num,'DL') ) THEN
415: -- Log an error message
416: fnd_message.set_name('IGF','IGF_SL_COD_NO_CHG_ORIG');
417: fnd_file.put_line(fnd_file.log,fnd_message.get);
418: raise yr_full_participant;
419: END IF;
420:
421: --Get the Direct Loan File Spec Version Bug :-2490289 DL Header and Trailer Formatting Error.

Line 427: fnd_message.set_name('IGF','IGF_SL_NO_DL_SETUP');

423: BEGIN
424: lv_dl_version := igf_sl_gen.get_dl_version(lv_cal_type, lv_cal_seq_num);
425: EXCEPTION
426: WHEN NO_DATA_FOUND THEN
427: fnd_message.set_name('IGF','IGF_SL_NO_DL_SETUP');
428: fnd_file.put_line(fnd_file.log,fnd_message.get);
429: RAISE NO_DATA_FOUND;
430: END;
431:

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

424: lv_dl_version := igf_sl_gen.get_dl_version(lv_cal_type, lv_cal_seq_num);
425: EXCEPTION
426: WHEN NO_DATA_FOUND THEN
427: fnd_message.set_name('IGF','IGF_SL_NO_DL_SETUP');
428: fnd_file.put_line(fnd_file.log,fnd_message.get);
429: RAISE NO_DATA_FOUND;
430: END;
431:
432: -- Initialise the Data Record field

Line 455: fnd_message.set_name ('IGF', 'IGF_GE_HDR_CREATE_ERROR');

451: lv_dbth_id, lv_batch_id, lv_mesg_class, Header_Rec);
452: FETCH Header_Rec into lv_data_record;
453:
454: IF Header_Rec%NOTFOUND THEN
455: fnd_message.set_name ('IGF', 'IGF_GE_HDR_CREATE_ERROR');
456: igs_ge_msg_stack.add;
457: app_exception.raise_exception;
458: END IF;
459:

Line 495: fnd_message.set_name('IGF','IGF_SL_NO_LOR_LOC_REC');

491: OPEN c_lor_loc(lc_lor.loan_id);
492: FETCH c_lor_loc INTO lc_lor_loc;
493: IF c_lor_loc%NOTFOUND THEN
494: CLOSE c_lor_loc;
495: fnd_message.set_name('IGF','IGF_SL_NO_LOR_LOC_REC');
496: fnd_message.set_token('LOAN_NUMBER',lc_lor.loan_number);
497: fnd_file.put_line(fnd_file.log,' ');
498: fnd_file.put_line(fnd_file.log,fnd_message.get);
499:

Line 496: fnd_message.set_token('LOAN_NUMBER',lc_lor.loan_number);

492: FETCH c_lor_loc INTO lc_lor_loc;
493: IF c_lor_loc%NOTFOUND THEN
494: CLOSE c_lor_loc;
495: fnd_message.set_name('IGF','IGF_SL_NO_LOR_LOC_REC');
496: fnd_message.set_token('LOAN_NUMBER',lc_lor.loan_number);
497: fnd_file.put_line(fnd_file.log,' ');
498: fnd_file.put_line(fnd_file.log,fnd_message.get);
499:
500: RAISE SKIP_LOAN;

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

494: CLOSE c_lor_loc;
495: fnd_message.set_name('IGF','IGF_SL_NO_LOR_LOC_REC');
496: fnd_message.set_token('LOAN_NUMBER',lc_lor.loan_number);
497: fnd_file.put_line(fnd_file.log,' ');
498: fnd_file.put_line(fnd_file.log,fnd_message.get);
499:
500: RAISE SKIP_LOAN;
501: END IF;
502:

Line 510: fnd_message.set_name('IGF','IGF_GE_REC_NO_DATA_FOUND');

506: OPEN cur_isir_depend_status(lc_lor.base_id);
507: FETCH cur_isir_depend_status INTO l_dependency_status;
508: IF cur_isir_depend_status%NOTFOUND THEN
509: CLOSE cur_isir_depend_status;
510: fnd_message.set_name('IGF','IGF_GE_REC_NO_DATA_FOUND');
511: fnd_message.set_token('P_RECORD',' Payment ISIR');
512: fnd_file.put_line(fnd_file.log,' ');
513: fnd_file.put_line(fnd_file.log,fnd_message.get);
514: RAISE SKIP_LOAN;

Line 511: fnd_message.set_token('P_RECORD',' Payment ISIR');

507: FETCH cur_isir_depend_status INTO l_dependency_status;
508: IF cur_isir_depend_status%NOTFOUND THEN
509: CLOSE cur_isir_depend_status;
510: fnd_message.set_name('IGF','IGF_GE_REC_NO_DATA_FOUND');
511: fnd_message.set_token('P_RECORD',' Payment ISIR');
512: fnd_file.put_line(fnd_file.log,' ');
513: fnd_file.put_line(fnd_file.log,fnd_message.get);
514: RAISE SKIP_LOAN;
515: END IF;

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

509: CLOSE cur_isir_depend_status;
510: fnd_message.set_name('IGF','IGF_GE_REC_NO_DATA_FOUND');
511: fnd_message.set_token('P_RECORD',' Payment ISIR');
512: fnd_file.put_line(fnd_file.log,' ');
513: fnd_file.put_line(fnd_file.log,fnd_message.get);
514: RAISE SKIP_LOAN;
515: END IF;
516:
517: --Code added for bug 3603289 start

Line 993: fnd_message.set_name('IGF','IGF_SL_LOAN_CHG_ORIG');

989:
990:
991: IF l_display <> 'Y' THEN
992: --Display mesg in LOG File that Change Records have been originated and an Output file has been created.
993: fnd_message.set_name('IGF','IGF_SL_LOAN_CHG_ORIG');
994: fnd_message.set_token('LOAN_CATEG',l_para_rec(1));
995: fnd_message.set_token('FILE_VERSION',lv_dl_version);
996: fnd_file.put_line(fnd_file.log,fnd_message.get);
997: l_display :='Y';

Line 994: fnd_message.set_token('LOAN_CATEG',l_para_rec(1));

990:
991: IF l_display <> 'Y' THEN
992: --Display mesg in LOG File that Change Records have been originated and an Output file has been created.
993: fnd_message.set_name('IGF','IGF_SL_LOAN_CHG_ORIG');
994: fnd_message.set_token('LOAN_CATEG',l_para_rec(1));
995: fnd_message.set_token('FILE_VERSION',lv_dl_version);
996: fnd_file.put_line(fnd_file.log,fnd_message.get);
997: l_display :='Y';
998: END IF;

Line 995: fnd_message.set_token('FILE_VERSION',lv_dl_version);

991: IF l_display <> 'Y' THEN
992: --Display mesg in LOG File that Change Records have been originated and an Output file has been created.
993: fnd_message.set_name('IGF','IGF_SL_LOAN_CHG_ORIG');
994: fnd_message.set_token('LOAN_CATEG',l_para_rec(1));
995: fnd_message.set_token('FILE_VERSION',lv_dl_version);
996: fnd_file.put_line(fnd_file.log,fnd_message.get);
997: l_display :='Y';
998: END IF;
999:

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

992: --Display mesg in LOG File that Change Records have been originated and an Output file has been created.
993: fnd_message.set_name('IGF','IGF_SL_LOAN_CHG_ORIG');
994: fnd_message.set_token('LOAN_CATEG',l_para_rec(1));
995: fnd_message.set_token('FILE_VERSION',lv_dl_version);
996: fnd_file.put_line(fnd_file.log,fnd_message.get);
997: l_display :='Y';
998: END IF;
999:
1000:

Line 1041: fnd_message.set_name ('IGF', 'IGF_GE_TRL_CREATE_ERROR');

1037: -- Write the Trailer Record
1038: igf_sl_dl_record.DLTrailer_cur(lv_dl_version, p_tot_rec_count, Trailer_Rec);
1039: FETCH Trailer_Rec into lv_data_record;
1040: IF Trailer_Rec%NOTFOUND THEN
1041: fnd_message.set_name ('IGF', 'IGF_GE_TRL_CREATE_ERROR');
1042: igs_ge_msg_stack.add;
1043: app_exception.raise_exception;
1044: END IF;
1045:

Line 1060: fnd_message.set_name('IGF','IGF_SL_NO_LOAN_CHG_ORIG');

1056: --Bug No:2332668
1057: IF l_display='N' THEN
1058: fnd_file.put_line(fnd_file.log,' ');
1059: fnd_file.put_line(fnd_file.log,' ');
1060: fnd_message.set_name('IGF','IGF_SL_NO_LOAN_CHG_ORIG');
1061: fnd_file.put_line(fnd_file.log,fnd_message.get);
1062:
1063: END IF;
1064:

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

1057: IF l_display='N' THEN
1058: fnd_file.put_line(fnd_file.log,' ');
1059: fnd_file.put_line(fnd_file.log,' ');
1060: fnd_message.set_name('IGF','IGF_SL_NO_LOAN_CHG_ORIG');
1061: fnd_file.put_line(fnd_file.log,fnd_message.get);
1062:
1063: END IF;
1064:
1065:

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

1085: IF cur_disb_loc%ISOPEN THEN
1086: CLOSE cur_disb_loc;
1087: END IF;
1088: retcode := 2;
1089: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION');
1090: fnd_file.put_line(fnd_file.log,SQLERRM);
1091: igs_ge_msg_stack.conc_exception_hndl;
1092: END chg_originate;
1093:

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

1196: WHEN OTHERS THEN
1197: IF cur_chg_rec%ISOPEN THEN
1198: CLOSE cur_chg_rec;
1199: END IF;
1200: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1201: fnd_message.set_token('NAME','IGF_SL_DL_CHG_ORIG.TRANS_REC');
1202: fnd_file.put_line(fnd_file.log,SQLERRM);
1203: igs_ge_msg_stack.add;
1204: app_exception.raise_exception;

Line 1201: fnd_message.set_token('NAME','IGF_SL_DL_CHG_ORIG.TRANS_REC');

1197: IF cur_chg_rec%ISOPEN THEN
1198: CLOSE cur_chg_rec;
1199: END IF;
1200: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
1201: fnd_message.set_token('NAME','IGF_SL_DL_CHG_ORIG.TRANS_REC');
1202: fnd_file.put_line(fnd_file.log,SQLERRM);
1203: igs_ge_msg_stack.add;
1204: app_exception.raise_exception;
1205: END Trans_Rec;