DBA Data[Home] [Help]

APPS.IGF_SL_DL_ORIG dependencies on FND_MESSAGE

Line 272: fnd_message.set_name('IGF','IGF_SL_COD_NO_ORIG');

268:
269: -- Check whether the award year is full participant
270: IF (igf_sl_dl_validation.check_full_participant (lv_cal_type, lv_cal_seq_num,'DL') ) THEN
271: -- Log an error message
272: fnd_message.set_name('IGF','IGF_SL_COD_NO_ORIG');
273: fnd_file.put_line(fnd_file.log,fnd_message.get);
274: raise yr_full_participant;
275: END IF;
276:

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

269: -- Check whether the award year is full participant
270: IF (igf_sl_dl_validation.check_full_participant (lv_cal_type, lv_cal_seq_num,'DL') ) THEN
271: -- Log an error message
272: fnd_message.set_name('IGF','IGF_SL_COD_NO_ORIG');
273: fnd_file.put_line(fnd_file.log,fnd_message.get);
274: raise yr_full_participant;
275: END IF;
276:
277:

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

279: OPEN cur_alternate_code;
280: FETCH cur_alternate_code INTO l_alternate_code;
281: IF cur_alternate_code%NOTFOUND THEN
282: CLOSE cur_alternate_code;
283: fnd_message.set_name('IGF','IGF_SL_NO_CALENDAR');
284: IGS_GE_MSG_STACK.ADD;
285: fnd_file.put_line(fnd_file.log,fnd_message.get);
286:
287: app_exception.raise_exception;

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

281: IF cur_alternate_code%NOTFOUND THEN
282: CLOSE cur_alternate_code;
283: fnd_message.set_name('IGF','IGF_SL_NO_CALENDAR');
284: IGS_GE_MSG_STACK.ADD;
285: fnd_file.put_line(fnd_file.log,fnd_message.get);
286:
287: app_exception.raise_exception;
288: END IF;
289: CLOSE cur_alternate_code;

Line 324: fnd_message.set_name('IGF','IGF_DB_DL_VERSION_FALSE');

320:
321: EXCEPTION
322: WHEN NO_DATA_FOUND THEN
323:
324: fnd_message.set_name('IGF','IGF_DB_DL_VERSION_FALSE');
325: fnd_file.put_line(fnd_file.log,fnd_message.get);
326:
327: RAISE NO_DATA_FOUND;
328: END;

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

321: EXCEPTION
322: WHEN NO_DATA_FOUND THEN
323:
324: fnd_message.set_name('IGF','IGF_DB_DL_VERSION_FALSE');
325: fnd_file.put_line(fnd_file.log,fnd_message.get);
326:
327: RAISE NO_DATA_FOUND;
328: END;
329:

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

366: lv_cal_type, lv_cal_seq_num, 'DL_ORIG_SEND', p_school_code,
367: lv_dbth_id, lv_batch_id, lv_mesg_class, Header_Rec);
368: FETCH Header_Rec into lv_data_header_record;
369: IF Header_Rec%NOTFOUND THEN
370: fnd_message.set_name ('IGF', 'IGF_GE_HDR_CREATE_ERROR');
371: igs_ge_msg_stack.add;
372: app_exception.raise_exception;
373: END IF;
374:

Line 902: fnd_message.set_name('IGF','IGF_SL_LOAN_ORIGINATED');

898:
899: IF l_display <> 'Y' THEN
900: --Display mesg in LOG File that Records have been originated and an Output file has been created.
901: fnd_file.new_line(fnd_file.log,2);
902: fnd_message.set_name('IGF','IGF_SL_LOAN_ORIGINATED');
903: fnd_message.set_token('LOAN_CATEG',l_para_rec(1));
904: fnd_message.set_token('FILE_VERSION',lv_dl_version);
905: fnd_file.put_line(fnd_file.log,fnd_message.get);
906: fnd_file.new_line(fnd_file.log,2);

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

899: IF l_display <> 'Y' THEN
900: --Display mesg in LOG File that Records have been originated and an Output file has been created.
901: fnd_file.new_line(fnd_file.log,2);
902: fnd_message.set_name('IGF','IGF_SL_LOAN_ORIGINATED');
903: fnd_message.set_token('LOAN_CATEG',l_para_rec(1));
904: fnd_message.set_token('FILE_VERSION',lv_dl_version);
905: fnd_file.put_line(fnd_file.log,fnd_message.get);
906: fnd_file.new_line(fnd_file.log,2);
907: l_display :='Y';

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

900: --Display mesg in LOG File that Records have been originated and an Output file has been created.
901: fnd_file.new_line(fnd_file.log,2);
902: fnd_message.set_name('IGF','IGF_SL_LOAN_ORIGINATED');
903: fnd_message.set_token('LOAN_CATEG',l_para_rec(1));
904: fnd_message.set_token('FILE_VERSION',lv_dl_version);
905: fnd_file.put_line(fnd_file.log,fnd_message.get);
906: fnd_file.new_line(fnd_file.log,2);
907: l_display :='Y';
908: END IF;

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

901: fnd_file.new_line(fnd_file.log,2);
902: fnd_message.set_name('IGF','IGF_SL_LOAN_ORIGINATED');
903: fnd_message.set_token('LOAN_CATEG',l_para_rec(1));
904: fnd_message.set_token('FILE_VERSION',lv_dl_version);
905: fnd_file.put_line(fnd_file.log,fnd_message.get);
906: fnd_file.new_line(fnd_file.log,2);
907: l_display :='Y';
908: END IF;
909:

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

1094: -- Write the Trailer Record
1095: igf_sl_dl_record.DLTrailer_cur(lv_dl_version, lv_num_of_rec, Trailer_Rec);
1096: FETCH Trailer_Rec into lv_data_record;
1097: IF Header_Rec%NOTFOUND THEN
1098: fnd_message.set_name ('IGF', 'IGF_GE_TRL_CREATE_ERROR');
1099: igs_ge_msg_stack.add;
1100: app_exception.raise_exception;
1101: END IF;
1102: -- Write the Trailer Record into the Output file.

Line 1105: fnd_file.put_line(fnd_file.log,fnd_message.get_string('IGF','IGF_SL_NO_LOAN_ORIG_DATA'));

1101: END IF;
1102: -- Write the Trailer Record into the Output file.
1103: fnd_file.put_line(FND_FILE.OUTPUT, lv_data_record);
1104: ELSE
1105: fnd_file.put_line(fnd_file.log,fnd_message.get_string('IGF','IGF_SL_NO_LOAN_ORIG_DATA'));
1106: --MN 27-Dec-2004 In case there are no records getting generated, the V state will be reverted back.
1107: ROLLBACK;
1108: END IF;
1109:

Line 1123: fnd_file.put_line(fnd_file.log,fnd_message.get_string('IGF','IGF_SL_NO_LOAN_ORIG_DATA'));

1119: -- of exiting a process if there is not Data.
1120: COMMIT; -- Commit is done here, so that the "Validation reject details" get committed.
1121: retcode := 0;
1122: errbuf := NULL;
1123: fnd_file.put_line(fnd_file.log,fnd_message.get_string('IGF','IGF_SL_NO_LOAN_ORIG_DATA'));
1124:
1125: WHEN yr_full_participant THEN
1126: NULL;
1127:

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

1134: CLOSE c_loans;
1135: END IF;
1136:
1137: retcode := 2;
1138: errbuf := fnd_message.get_string('IGF','IGF_GE_LOCK_ERROR');
1139: igs_ge_msg_stack.conc_exception_hndl;
1140:
1141: WHEN OTHERS THEN
1142: ROLLBACK;

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

1143: IF c_loans%ISOPEN THEN
1144: CLOSE c_loans;
1145: END IF;
1146: retcode := 2;
1147: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION');
1148: fnd_file.put_line(fnd_file.log,SQLERRM);
1149: igs_ge_msg_stack.conc_exception_hndl;
1150: END dl_originate;
1151: