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

Line 216: fnd_message.set_name('IGS',l_v_message_name);

212: igs_fi_com_rec_interface.chk_manage_account( p_v_manage_acc => l_v_manage_acc,
213: p_v_message_name => l_v_message_name
214: );
215: IF (l_v_manage_acc IS NULL) THEN
216: fnd_message.set_name('IGS',l_v_message_name);
217: fnd_file.put_line(fnd_file.log,fnd_message.get());
218: fnd_file.new_line(fnd_file.log);
219: RAISE do_nothing;
220: END IF;

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

213: p_v_message_name => l_v_message_name
214: );
215: IF (l_v_manage_acc IS NULL) THEN
216: fnd_message.set_name('IGS',l_v_message_name);
217: fnd_file.put_line(fnd_file.log,fnd_message.get());
218: fnd_file.new_line(fnd_file.log);
219: RAISE do_nothing;
220: END IF;
221:

Line 224: fnd_message.set_name('IGS','IGS_FI_PARAMETER_NULL');

220: END IF;
221:
222: -- This Section confirms that all the mandatory parameters are passed to the process
223: IF ((p_award_year IS NULL) OR (p_rollover IS NULL) OR (p_run_mode IS NULL) OR (p_fund_id IS NULL)) THEN
224: fnd_message.set_name('IGS','IGS_FI_PARAMETER_NULL');
225: fnd_file.put_line(fnd_file.log, fnd_message.get);
226: RAISE do_nothing;
227: END IF;
228: --Validation of all mandatory parameter ends here

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

221:
222: -- This Section confirms that all the mandatory parameters are passed to the process
223: IF ((p_award_year IS NULL) OR (p_rollover IS NULL) OR (p_run_mode IS NULL) OR (p_fund_id IS NULL)) THEN
224: fnd_message.set_name('IGS','IGS_FI_PARAMETER_NULL');
225: fnd_file.put_line(fnd_file.log, fnd_message.get);
226: RAISE do_nothing;
227: END IF;
228: --Validation of all mandatory parameter ends here
229:

Line 238: fnd_message.set_name('IGS',l_err_message);

234: p_sequence_number => l_sequence_number,
235: p_err_message => l_err_message
236: );
237: IF NOT(l_ans) and l_err_message IS NOT NULL THEN
238: fnd_message.set_name('IGS',l_err_message);
239: fnd_file.put_line(fnd_file.log, fnd_message.get);
240: RAISE do_nothing;
241: END IF;
242:

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

235: p_err_message => l_err_message
236: );
237: IF NOT(l_ans) and l_err_message IS NOT NULL THEN
238: fnd_message.set_name('IGS',l_err_message);
239: fnd_file.put_line(fnd_file.log, fnd_message.get);
240: RAISE do_nothing;
241: END IF;
242:
243: --Validate the Award Year Status. If the status is not open, log the message in log file and

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

249: p_v_message_name => l_v_message_name
250: );
251: IF l_v_message_name IS NOT NULL THEN
252: IF l_v_message_name = 'IGF_SP_INVALID_AWD_YR_STATUS' THEN
253: fnd_message.set_name('IGF',l_v_message_name);
254: ELSE
255: fnd_message.set_name('IGS',l_v_message_name);
256: END IF;
257: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 255: fnd_message.set_name('IGS',l_v_message_name);

251: IF l_v_message_name IS NOT NULL THEN
252: IF l_v_message_name = 'IGF_SP_INVALID_AWD_YR_STATUS' THEN
253: fnd_message.set_name('IGF',l_v_message_name);
254: ELSE
255: fnd_message.set_name('IGS',l_v_message_name);
256: END IF;
257: fnd_file.put_line(fnd_file.log,fnd_message.get);
258: RAISE do_nothing;
259: END IF;

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

253: fnd_message.set_name('IGF',l_v_message_name);
254: ELSE
255: fnd_message.set_name('IGS',l_v_message_name);
256: END IF;
257: fnd_file.put_line(fnd_file.log,fnd_message.get);
258: RAISE do_nothing;
259: END IF;
260: END IF;
261:

Line 268: fnd_message.set_name('IGS',l_err_message);

264: p_cal_type => l_cal_type,
265: p_sequence_number => l_sequence_number,
266: p_err_message => l_err_message);
267: IF NOT(l_ans) and l_err_message IS NOT NULL THEN
268: fnd_message.set_name('IGS',l_err_message);
269: fnd_file.put_line(fnd_file.log, fnd_message.get);
270: RAISE do_nothing;
271: END IF;
272:

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

265: p_sequence_number => l_sequence_number,
266: p_err_message => l_err_message);
267: IF NOT(l_ans) and l_err_message IS NOT NULL THEN
268: fnd_message.set_name('IGS',l_err_message);
269: fnd_file.put_line(fnd_file.log, fnd_message.get);
270: RAISE do_nothing;
271: END IF;
272:
273: -- Check if succeeding awards are present for the current award year passed as

Line 281: fnd_message.set_name('IGF','IGF_AW_AWD_MAP_NOT_FND');

277: );
278: FETCH c_igf_aw_cal_rel INTO l_c_igf_aw_cal_rel;
279: IF c_igf_aw_cal_rel%NOTFOUND THEN
280: CLOSE c_igf_aw_cal_rel;
281: fnd_message.set_name('IGF','IGF_AW_AWD_MAP_NOT_FND');
282: fnd_message.set_token('FNDID',p_fund_id);
283: fnd_message.set_token('ALTCD',p_award_year);
284: fnd_file.put_line(fnd_file.log, fnd_message.get);
285: RAISE do_nothing;

Line 282: fnd_message.set_token('FNDID',p_fund_id);

278: FETCH c_igf_aw_cal_rel INTO l_c_igf_aw_cal_rel;
279: IF c_igf_aw_cal_rel%NOTFOUND THEN
280: CLOSE c_igf_aw_cal_rel;
281: fnd_message.set_name('IGF','IGF_AW_AWD_MAP_NOT_FND');
282: fnd_message.set_token('FNDID',p_fund_id);
283: fnd_message.set_token('ALTCD',p_award_year);
284: fnd_file.put_line(fnd_file.log, fnd_message.get);
285: RAISE do_nothing;
286: END IF;

Line 283: fnd_message.set_token('ALTCD',p_award_year);

279: IF c_igf_aw_cal_rel%NOTFOUND THEN
280: CLOSE c_igf_aw_cal_rel;
281: fnd_message.set_name('IGF','IGF_AW_AWD_MAP_NOT_FND');
282: fnd_message.set_token('FNDID',p_fund_id);
283: fnd_message.set_token('ALTCD',p_award_year);
284: fnd_file.put_line(fnd_file.log, fnd_message.get);
285: RAISE do_nothing;
286: END IF;
287: l_sc_cal_type := l_c_igf_aw_cal_rel.sc_cal_type;

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

280: CLOSE c_igf_aw_cal_rel;
281: fnd_message.set_name('IGF','IGF_AW_AWD_MAP_NOT_FND');
282: fnd_message.set_token('FNDID',p_fund_id);
283: fnd_message.set_token('ALTCD',p_award_year);
284: fnd_file.put_line(fnd_file.log, fnd_message.get);
285: RAISE do_nothing;
286: END IF;
287: l_sc_cal_type := l_c_igf_aw_cal_rel.sc_cal_type;
288: l_sc_sequence_number := l_c_igf_aw_cal_rel.sc_sequence_number;

Line 302: fnd_message.set_name('IGF','IGF_SP_NXT_AWD_YR_STAT_INVALID');

298: p_v_awd_yr_status => l_v_awd_yr_status_cd,
299: p_v_message_name => l_v_message_name
300: );
301: IF l_v_message_name IS NOT NULL THEN
302: fnd_message.set_name('IGF','IGF_SP_NXT_AWD_YR_STAT_INVALID');
303: fnd_message.set_token('ALT_CODE',l_c_igf_aw_cal_rel.sc_alternate_code);
304: fnd_file.put_line(fnd_file.log,fnd_message.get);
305: RAISE do_nothing;
306: END IF;

Line 303: fnd_message.set_token('ALT_CODE',l_c_igf_aw_cal_rel.sc_alternate_code);

299: p_v_message_name => l_v_message_name
300: );
301: IF l_v_message_name IS NOT NULL THEN
302: fnd_message.set_name('IGF','IGF_SP_NXT_AWD_YR_STAT_INVALID');
303: fnd_message.set_token('ALT_CODE',l_c_igf_aw_cal_rel.sc_alternate_code);
304: fnd_file.put_line(fnd_file.log,fnd_message.get);
305: RAISE do_nothing;
306: END IF;
307:

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

300: );
301: IF l_v_message_name IS NOT NULL THEN
302: fnd_message.set_name('IGF','IGF_SP_NXT_AWD_YR_STAT_INVALID');
303: fnd_message.set_token('ALT_CODE',l_c_igf_aw_cal_rel.sc_alternate_code);
304: fnd_file.put_line(fnd_file.log,fnd_message.get);
305: RAISE do_nothing;
306: END IF;
307:
308: SAVEPOINT sp_main;

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

345: WHEN do_nothing THEN
346: retcode :=2;
347: WHEN OTHERS THEN
348: retcode := 2;
349: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION');
350: igs_ge_msg_stack.conc_exception_hndl ;
351: END sponsor_rollover;
352:
353: FUNCTION lookup_desc( p_type IN VARCHAR2 ,

Line 399: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');

395: --Change History:
396: --Who When What
397: -------------------------------------------------------------------
398: BEGIN
399: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
400: fnd_message.set_token('PARAMETER_NAME',p_msg_name);
401: fnd_message.set_token('PARAMETER_VAL' ,p_msg_val) ;
402: fnd_file.put_line(fnd_file.log,fnd_message.get);
403: END log_messages;

Line 400: fnd_message.set_token('PARAMETER_NAME',p_msg_name);

396: --Who When What
397: -------------------------------------------------------------------
398: BEGIN
399: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
400: fnd_message.set_token('PARAMETER_NAME',p_msg_name);
401: fnd_message.set_token('PARAMETER_VAL' ,p_msg_val) ;
402: fnd_file.put_line(fnd_file.log,fnd_message.get);
403: END log_messages;
404:

Line 401: fnd_message.set_token('PARAMETER_VAL' ,p_msg_val) ;

397: -------------------------------------------------------------------
398: BEGIN
399: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
400: fnd_message.set_token('PARAMETER_NAME',p_msg_name);
401: fnd_message.set_token('PARAMETER_VAL' ,p_msg_val) ;
402: fnd_file.put_line(fnd_file.log,fnd_message.get);
403: END log_messages;
404:
405:

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

398: BEGIN
399: fnd_message.set_name('IGS','IGS_FI_CAL_BALANCES_LOG');
400: fnd_message.set_token('PARAMETER_NAME',p_msg_name);
401: fnd_message.set_token('PARAMETER_VAL' ,p_msg_val) ;
402: fnd_file.put_line(fnd_file.log,fnd_message.get);
403: END log_messages;
404:
405:
406: FUNCTION validate_fund(p_fund IN igf_aw_fund_mast.fund_id%TYPE ,

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

733: -- rollsback to the save point
734: ROLLBACK TO sp_fund;
735: -- log the error message returned by the tbh
736: fnd_file.put_line(fnd_file.log,' ');
737: fnd_file.put_line(fnd_file.log,fnd_message.get);
738: -- raises user defined exception so as to skip the record
739: -- the record will not be processed further
740: RAISE l_err_exception;
741: END;

Line 765: fnd_message.set_name('IGF','IGF_SP_NO_FUND_TERM_MAP');

761: CLOSE c_igf_aw_cal_rel;
762:
763: --Bug 5213852, Logged the new message 'IGF_SP_NO_FUND_TERM_MAP' and removed the code logic to
764: --log 'IGF_AW_FND_RLOVR_LD_NTFND' as the later message is obsoleted.
765: fnd_message.set_name('IGF','IGF_SP_NO_FUND_TERM_MAP');
766: fnd_message.set_token('TERM_ALT_CD ',l_c_igf_aw_fund_tp.tp_alternate_code);
767: fnd_message.set_token('AWD_ALT_CD',l_c_igf_aw_fund_tp.awd_alternate_code);
768: fnd_message.set_token('FUND_CODE',l_c_igf_aw_fund_tp.fund_code);
769:

Line 766: fnd_message.set_token('TERM_ALT_CD ',l_c_igf_aw_fund_tp.tp_alternate_code);

762:
763: --Bug 5213852, Logged the new message 'IGF_SP_NO_FUND_TERM_MAP' and removed the code logic to
764: --log 'IGF_AW_FND_RLOVR_LD_NTFND' as the later message is obsoleted.
765: fnd_message.set_name('IGF','IGF_SP_NO_FUND_TERM_MAP');
766: fnd_message.set_token('TERM_ALT_CD ',l_c_igf_aw_fund_tp.tp_alternate_code);
767: fnd_message.set_token('AWD_ALT_CD',l_c_igf_aw_fund_tp.awd_alternate_code);
768: fnd_message.set_token('FUND_CODE',l_c_igf_aw_fund_tp.fund_code);
769:
770: igs_ge_msg_stack.add;

Line 767: fnd_message.set_token('AWD_ALT_CD',l_c_igf_aw_fund_tp.awd_alternate_code);

763: --Bug 5213852, Logged the new message 'IGF_SP_NO_FUND_TERM_MAP' and removed the code logic to
764: --log 'IGF_AW_FND_RLOVR_LD_NTFND' as the later message is obsoleted.
765: fnd_message.set_name('IGF','IGF_SP_NO_FUND_TERM_MAP');
766: fnd_message.set_token('TERM_ALT_CD ',l_c_igf_aw_fund_tp.tp_alternate_code);
767: fnd_message.set_token('AWD_ALT_CD',l_c_igf_aw_fund_tp.awd_alternate_code);
768: fnd_message.set_token('FUND_CODE',l_c_igf_aw_fund_tp.fund_code);
769:
770: igs_ge_msg_stack.add;
771: -- log the error message

Line 768: fnd_message.set_token('FUND_CODE',l_c_igf_aw_fund_tp.fund_code);

764: --log 'IGF_AW_FND_RLOVR_LD_NTFND' as the later message is obsoleted.
765: fnd_message.set_name('IGF','IGF_SP_NO_FUND_TERM_MAP');
766: fnd_message.set_token('TERM_ALT_CD ',l_c_igf_aw_fund_tp.tp_alternate_code);
767: fnd_message.set_token('AWD_ALT_CD',l_c_igf_aw_fund_tp.awd_alternate_code);
768: fnd_message.set_token('FUND_CODE',l_c_igf_aw_fund_tp.fund_code);
769:
770: igs_ge_msg_stack.add;
771: -- log the error message
772: fnd_file.put_line(fnd_file.log,' ');

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

769:
770: igs_ge_msg_stack.add;
771: -- log the error message
772: fnd_file.put_line(fnd_file.log,' ');
773: fnd_file.put_line(fnd_file.log,fnd_message.get);
774: -- raises user defined exception so as to skip the record
775: RAISE l_err_exception;
776: END IF;
777: CLOSE c_igf_aw_cal_rel;

Line 798: fnd_message.set_name('IGF',fnd_message.get);

794: WHEN OTHERS THEN
795: -- rolls back to the save point
796: ROLLBACK TO sp_fund;
797: -- log the error message returned by the tbh
798: fnd_message.set_name('IGF',fnd_message.get);
799: igs_ge_msg_stack.add;
800: fnd_file.put_line(fnd_file.log,' ');
801: fnd_file.put_line(fnd_file.log,fnd_message.get);
802: -- raises user defined exception so as to skip the record

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

797: -- log the error message returned by the tbh
798: fnd_message.set_name('IGF',fnd_message.get);
799: igs_ge_msg_stack.add;
800: fnd_file.put_line(fnd_file.log,' ');
801: fnd_file.put_line(fnd_file.log,fnd_message.get);
802: -- raises user defined exception so as to skip the record
803: RAISE l_err_exception;
804: END;
805: END LOOP;

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

835: -- rolls back to the save point
836: ROLLBACK TO sp_fund;
837: -- log the error message returned by the tbh
838: fnd_file.put_line(fnd_file.log,' ');
839: fnd_file.put_line(fnd_file.log,fnd_message.get);
840: -- raises user defined exception so as to skip the record
841: RAISE l_err_exception;
842: END;
843: IF l_c_igf_sp_fc.fee_class = 'TUITION' THEN

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

877: -- rolls back to the save point
878: ROLLBACK TO sp_fund;
879: -- log the error message returned by the tbh
880: fnd_file.put_line(fnd_file.log,' ');
881: fnd_file.put_line(fnd_file.log,fnd_message.get);
882: -- raises user defined exception so as to skip the record
883: RAISE l_err_exception;
884: END ;
885: -- rollover pays only unit details.

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

914: -- rolls back to the save point
915: ROLLBACK TO sp_fund;
916: -- log the error message returned by the tbh
917: fnd_file.put_line(fnd_file.log,' ');
918: fnd_file.put_line(fnd_file.log,fnd_message.get);
919: -- raises user defined exception so as to skip the record
920: RAISE l_err_exception;
921: END;
922: END LOOP;

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

1060: IF c_fund_mast%NOTFOUND THEN
1061: -- rolls back to the save point
1062: ROLLBACK TO sp_student;
1063: CLOSE c_fund_mast;
1064: fnd_message.set_name('IGF','IGF_SP_NO_FUND_ROLL');
1065: igs_ge_msg_stack.add;
1066: fnd_file.put_line(fnd_file.log,' ');
1067: fnd_file.put_line(fnd_file.log,fnd_message.get);
1068: RAISE l_err_exception;

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

1063: CLOSE c_fund_mast;
1064: fnd_message.set_name('IGF','IGF_SP_NO_FUND_ROLL');
1065: igs_ge_msg_stack.add;
1066: fnd_file.put_line(fnd_file.log,' ');
1067: fnd_file.put_line(fnd_file.log,fnd_message.get);
1068: RAISE l_err_exception;
1069: END IF;
1070: CLOSE c_fund_mast;
1071:

Line 1087: fnd_message.set_name('IGF','IGF_SP_NO_TERM');

1083: IF c_igf_aw_fund_tp%NOTFOUND THEN
1084: -- rolls back to the save point
1085: ROLLBACK TO sp_student;
1086: CLOSE c_igf_aw_fund_tp;
1087: fnd_message.set_name('IGF','IGF_SP_NO_TERM');
1088: igs_ge_msg_stack.add;
1089:
1090: -- log the error message
1091: fnd_file.put_line(fnd_file.log,' ');

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

1088: igs_ge_msg_stack.add;
1089:
1090: -- log the error message
1091: fnd_file.put_line(fnd_file.log,' ');
1092: fnd_file.put_line(fnd_file.log,fnd_message.get);
1093: RAISE l_err_exception;
1094: END IF;
1095: CLOSE c_igf_aw_fund_tp;
1096:

Line 1127: fnd_message.set_name('IGF','IGF_SP_NO_FA_BASE_REC');

1123: CLOSE c_igf_ap_fa_base_rec;
1124:
1125: -- rolls back to the save point
1126: ROLLBACK TO sp_spnsr_student;
1127: fnd_message.set_name('IGF','IGF_SP_NO_FA_BASE_REC');
1128: igs_ge_msg_stack.add;
1129:
1130: -- log the error message
1131: fnd_file.put_line(fnd_file.log,' ');

Line 1132: fnd_file.put_line(fnd_file.log,l_c_igf_sp_stdnt_rel.person_number||' '||fnd_message.get);

1128: igs_ge_msg_stack.add;
1129:
1130: -- log the error message
1131: fnd_file.put_line(fnd_file.log,' ');
1132: fnd_file.put_line(fnd_file.log,l_c_igf_sp_stdnt_rel.person_number||' '||fnd_message.get);
1133:
1134: -- skips the current student
1135: RAISE l_stud_exception;
1136: END IF;

Line 1153: fnd_message.set_name('IGF','IGF_SP_NO_STDREL_TERM_MAP');

1149: CLOSE c_igf_aw_cal_rel;
1150:
1151: --Bug 5213852, Logged the new message 'IGF_SP_NO_STDREL_TERM_MAP' and removed the code logic to
1152: --log 'IGF_AW_FND_RLOVR_LD_NTFND' as the later message is obsoleted.
1153: fnd_message.set_name('IGF','IGF_SP_NO_STDREL_TERM_MAP');
1154: fnd_message.set_token('TERM_ALT_CD',l_c_igf_aw_fund_tp.tp_alternate_code);
1155: fnd_message.set_token('AWD_ALT_CD',l_c_igf_aw_fund_tp.awd_alternate_code);
1156: fnd_message.set_token('STUDENT_NUM',l_c_igf_sp_stdnt_rel.person_number);
1157: fnd_message.set_token('SPONSOR_CD',l_c_igf_aw_fund_tp.fund_code);

Line 1154: fnd_message.set_token('TERM_ALT_CD',l_c_igf_aw_fund_tp.tp_alternate_code);

1150:
1151: --Bug 5213852, Logged the new message 'IGF_SP_NO_STDREL_TERM_MAP' and removed the code logic to
1152: --log 'IGF_AW_FND_RLOVR_LD_NTFND' as the later message is obsoleted.
1153: fnd_message.set_name('IGF','IGF_SP_NO_STDREL_TERM_MAP');
1154: fnd_message.set_token('TERM_ALT_CD',l_c_igf_aw_fund_tp.tp_alternate_code);
1155: fnd_message.set_token('AWD_ALT_CD',l_c_igf_aw_fund_tp.awd_alternate_code);
1156: fnd_message.set_token('STUDENT_NUM',l_c_igf_sp_stdnt_rel.person_number);
1157: fnd_message.set_token('SPONSOR_CD',l_c_igf_aw_fund_tp.fund_code);
1158:

Line 1155: fnd_message.set_token('AWD_ALT_CD',l_c_igf_aw_fund_tp.awd_alternate_code);

1151: --Bug 5213852, Logged the new message 'IGF_SP_NO_STDREL_TERM_MAP' and removed the code logic to
1152: --log 'IGF_AW_FND_RLOVR_LD_NTFND' as the later message is obsoleted.
1153: fnd_message.set_name('IGF','IGF_SP_NO_STDREL_TERM_MAP');
1154: fnd_message.set_token('TERM_ALT_CD',l_c_igf_aw_fund_tp.tp_alternate_code);
1155: fnd_message.set_token('AWD_ALT_CD',l_c_igf_aw_fund_tp.awd_alternate_code);
1156: fnd_message.set_token('STUDENT_NUM',l_c_igf_sp_stdnt_rel.person_number);
1157: fnd_message.set_token('SPONSOR_CD',l_c_igf_aw_fund_tp.fund_code);
1158:
1159: igs_ge_msg_stack.add;

Line 1156: fnd_message.set_token('STUDENT_NUM',l_c_igf_sp_stdnt_rel.person_number);

1152: --log 'IGF_AW_FND_RLOVR_LD_NTFND' as the later message is obsoleted.
1153: fnd_message.set_name('IGF','IGF_SP_NO_STDREL_TERM_MAP');
1154: fnd_message.set_token('TERM_ALT_CD',l_c_igf_aw_fund_tp.tp_alternate_code);
1155: fnd_message.set_token('AWD_ALT_CD',l_c_igf_aw_fund_tp.awd_alternate_code);
1156: fnd_message.set_token('STUDENT_NUM',l_c_igf_sp_stdnt_rel.person_number);
1157: fnd_message.set_token('SPONSOR_CD',l_c_igf_aw_fund_tp.fund_code);
1158:
1159: igs_ge_msg_stack.add;
1160:

Line 1157: fnd_message.set_token('SPONSOR_CD',l_c_igf_aw_fund_tp.fund_code);

1153: fnd_message.set_name('IGF','IGF_SP_NO_STDREL_TERM_MAP');
1154: fnd_message.set_token('TERM_ALT_CD',l_c_igf_aw_fund_tp.tp_alternate_code);
1155: fnd_message.set_token('AWD_ALT_CD',l_c_igf_aw_fund_tp.awd_alternate_code);
1156: fnd_message.set_token('STUDENT_NUM',l_c_igf_sp_stdnt_rel.person_number);
1157: fnd_message.set_token('SPONSOR_CD',l_c_igf_aw_fund_tp.fund_code);
1158:
1159: igs_ge_msg_stack.add;
1160:
1161: -- log the error message

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

1159: igs_ge_msg_stack.add;
1160:
1161: -- log the error message
1162: fnd_file.put_line(fnd_file.log,' ');
1163: fnd_file.put_line(fnd_file.log,fnd_message.get);
1164: -- raises user defined exception so as to skip the student record
1165: RAISE l_stud_exception;
1166: END IF;
1167: CLOSE c_igf_aw_cal_rel;

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

1197: WHEN OTHERS THEN
1198: -- rolls back to the save point
1199: ROLLBACK TO sp_spnsr_student;
1200: -- log the error message returned by the tbh
1201: fnd_file.put_line(fnd_file.log,fnd_message.get);
1202: -- raises user defined exception so as to skip the record
1203: RAISE l_stud_exception;
1204: END ;
1205:

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

1235: WHEN OTHERS THEN
1236: -- rolls back to the save point
1237: ROLLBACK TO sp_student;
1238: -- log the error message returned by the tbh
1239: fnd_file.put_line(fnd_file.log,fnd_message.get);
1240: -- raises user defined exception so as to skip the record
1241: RAISE l_err_exception;
1242: END;
1243: IF l_c_igf_sp_std_fc.fee_class = 'TUITION' THEN

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

1276: WHEN OTHERS THEN
1277: -- rolls back to the save point
1278: ROLLBACK TO sp_student;
1279: -- log the error message returned by the tbh
1280: fnd_file.put_line(fnd_file.log,fnd_message.get);
1281: -- raises user defined exception so as to skip the record
1282: RAISE l_err_exception;
1283: END;
1284: fnd_file.put_line(fnd_file.log,' ');

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

1312: WHEN OTHERS THEN
1313: -- rolls back to the save point
1314: ROLLBACK TO sp_student;
1315: -- log the error message returned by the tbh
1316: fnd_file.put_line(fnd_file.log,fnd_message.get);
1317: -- raises user defined exception so as to skip the record
1318: RAISE l_err_exception;
1319: END;
1320: END LOOP;