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:
342: -- Directly setting to Send, as the Trans_rec() procedure picks up only the
343: -- picks up record belonging to this dbth_id
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;
371:
372: -- main
373: BEGIN
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;
393:
394: --Write the details of Parameters Passed into LOG File.
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:
460: -- FA 122 Loan Enhancements derive the paramters to be passed to the c_lor cursor
461: IF p_dl_loan_catg = 'DL_STAFFORD' THEN
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:
1046: -- Write the Trailer Record into the Output file.
1047: fnd_file.put_line(FND_FILE.OUTPUT, lv_data_record);
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;
1206:
1207: END igf_sl_dl_chg_orig;