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_FILE

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 218: fnd_file.new_line(fnd_file.log);

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:
222: -- This Section confirms that all the mandatory parameters are passed to the process

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 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 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 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 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 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 333: fnd_file.put_line(fnd_file.log,' ');

329: sponsor_fund_rollover ( p_sc_cal_type => l_sc_cal_type,
330: p_sc_seq_num => l_sc_sequence_number,
331: p_fund => p_fund_id
332: ) ;
333: fnd_file.put_line(fnd_file.log,' ');
334: sponsor_student_rollover ( p_sc_cal_type => l_sc_cal_type,
335: p_sc_seq_num => l_sc_sequence_number,
336: p_fund => p_fund_id
337: ) ;

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 585: fnd_file.put_line(fnd_file.log,l_msg_str_0);

581: RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','MIN_CRD_POINTS'),19) ||
582: RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','MIN_ATD_TYPE'),32) ||
583: lookup_desc('IGF_AW_LOOKUPS_MSG','TOT_SPNSR_AMT');
584:
585: fnd_file.put_line(fnd_file.log,l_msg_str_0);
586: fnd_file.put_line(fnd_file.log,' ');
587: l_msg_str_1 := RPAD(l_c_igf_aw_fund_mast.fund_code,32)||
588: RPAD((p_sc_cal_type||' '||p_sc_seq_num),19) ||
589: NVL(RPAD(TO_CHAR(l_c_igf_aw_fund_mast.min_credit_points),19),' ') ||

Line 586: fnd_file.put_line(fnd_file.log,' ');

582: RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','MIN_ATD_TYPE'),32) ||
583: lookup_desc('IGF_AW_LOOKUPS_MSG','TOT_SPNSR_AMT');
584:
585: fnd_file.put_line(fnd_file.log,l_msg_str_0);
586: fnd_file.put_line(fnd_file.log,' ');
587: l_msg_str_1 := RPAD(l_c_igf_aw_fund_mast.fund_code,32)||
588: RPAD((p_sc_cal_type||' '||p_sc_seq_num),19) ||
589: NVL(RPAD(TO_CHAR(l_c_igf_aw_fund_mast.min_credit_points),19),' ') ||
590: NVL(RPAD(l_c_igf_aw_fund_mast.enrollment_status,32),' ' )||

Line 593: fnd_file.put_line(fnd_file.log,l_msg_str_1);

589: NVL(RPAD(TO_CHAR(l_c_igf_aw_fund_mast.min_credit_points),19),' ') ||
590: NVL(RPAD(l_c_igf_aw_fund_mast.enrollment_status,32),' ' )||
591: TO_CHAR(l_c_igf_aw_fund_mast.max_yearly_amt);
592:
593: fnd_file.put_line(fnd_file.log,l_msg_str_1);
594: fnd_file.put_line(fnd_file.log,' ');
595:
596: BEGIN
597: -- declare a save point

Line 594: fnd_file.put_line(fnd_file.log,' ');

590: NVL(RPAD(l_c_igf_aw_fund_mast.enrollment_status,32),' ' )||
591: TO_CHAR(l_c_igf_aw_fund_mast.max_yearly_amt);
592:
593: fnd_file.put_line(fnd_file.log,l_msg_str_1);
594: fnd_file.put_line(fnd_file.log,' ');
595:
596: BEGIN
597: -- declare a save point
598: SAVEPOINT sp_fund;

Line 736: fnd_file.put_line(fnd_file.log,' ');

732: WHEN OTHERS THEN
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;

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 748: fnd_file.put_line(fnd_file.log,l_msg_str_0);

744: -- log the relavant details
745: l_msg_str_0 := RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','TERM'),12) ||
746: RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','START_DT'),22) ||
747: lookup_desc('IGF_AW_LOOKUPS_MSG','END_DT');
748: fnd_file.put_line(fnd_file.log,l_msg_str_0);
749: fnd_file.put_line(fnd_file.log,' ');
750: FOR l_c_igf_aw_fund_tp IN c_igf_aw_fund_tp(cp_fund_id => l_c_igf_aw_fund_mast.fund_id)
751: LOOP
752: -- Check if succeeding terms are present for the current term passed as

Line 749: fnd_file.put_line(fnd_file.log,' ');

745: l_msg_str_0 := RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','TERM'),12) ||
746: RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','START_DT'),22) ||
747: lookup_desc('IGF_AW_LOOKUPS_MSG','END_DT');
748: fnd_file.put_line(fnd_file.log,l_msg_str_0);
749: fnd_file.put_line(fnd_file.log,' ');
750: FOR l_c_igf_aw_fund_tp IN c_igf_aw_fund_tp(cp_fund_id => l_c_igf_aw_fund_mast.fund_id)
751: LOOP
752: -- Check if succeeding terms are present for the current term passed as
753: -- parameter to the process

Line 772: fnd_file.put_line(fnd_file.log,' ');

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,' ');
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;

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 782: fnd_file.put_line(fnd_file.log,l_msg_str_1);

778: -- log relevant details
779: l_msg_str_1 := RPAD(l_c_igf_aw_cal_rel.sc_alternate_code,12) ||
780: RPAD(igs_ge_date.igschardt(l_c_igf_aw_cal_rel.sc_start_dt),22) ||
781: igs_ge_date.igschardt(l_c_igf_aw_cal_rel.sc_end_dt);
782: fnd_file.put_line(fnd_file.log,l_msg_str_1);
783: l_rowid := NULL;
784: BEGIN
785: igf_aw_fund_tp_pkg.insert_row (
786: x_mode => 'R',

Line 800: fnd_file.put_line(fnd_file.log,' ');

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
803: RAISE l_err_exception;
804: END;

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 806: fnd_file.put_line(fnd_file.log,' ');

802: -- raises user defined exception so as to skip the record
803: RAISE l_err_exception;
804: END;
805: END LOOP;
806: fnd_file.put_line(fnd_file.log,' ');
807: l_msg_str_0 := RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','FEE_CLASS'),32) ||
808: RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','PERCENT'),10) ||
809: lookup_desc('IGF_AW_LOOKUPS_MSG','MAX_AMOUNT');
810: fnd_file.put_line(fnd_file.log,l_msg_str_0);

Line 810: fnd_file.put_line(fnd_file.log,l_msg_str_0);

806: fnd_file.put_line(fnd_file.log,' ');
807: l_msg_str_0 := RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','FEE_CLASS'),32) ||
808: RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','PERCENT'),10) ||
809: lookup_desc('IGF_AW_LOOKUPS_MSG','MAX_AMOUNT');
810: fnd_file.put_line(fnd_file.log,l_msg_str_0);
811: fnd_file.put_line(fnd_file.log,' ');
812: -- rolling over pays only fee class details
813: FOR l_c_igf_sp_fc IN c_igf_sp_fc(cp_fund_id => l_c_igf_aw_fund_mast.fund_id)
814: LOOP

Line 811: fnd_file.put_line(fnd_file.log,' ');

807: l_msg_str_0 := RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','FEE_CLASS'),32) ||
808: RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','PERCENT'),10) ||
809: lookup_desc('IGF_AW_LOOKUPS_MSG','MAX_AMOUNT');
810: fnd_file.put_line(fnd_file.log,l_msg_str_0);
811: fnd_file.put_line(fnd_file.log,' ');
812: -- rolling over pays only fee class details
813: FOR l_c_igf_sp_fc IN c_igf_sp_fc(cp_fund_id => l_c_igf_aw_fund_mast.fund_id)
814: LOOP
815: -- log relevant details

Line 819: fnd_file.put_line(fnd_file.log,l_msg_str_1);

815: -- log relevant details
816: l_msg_str_1 := RPAD(l_c_igf_sp_fc.fee_class,32) ||
817: NVL(RPAD(TO_CHAR(l_c_igf_sp_fc.fee_percent),10),' ' )||
818: TO_CHAR(l_c_igf_sp_fc.max_amount);
819: fnd_file.put_line(fnd_file.log,l_msg_str_1);
820: l_rowid := NULL;
821: l_fee_cls_id := NULL;
822: BEGIN
823: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision

Line 838: fnd_file.put_line(fnd_file.log,' ');

834: WHEN OTHERS THEN
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;

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 845: fnd_file.put_line(fnd_file.log,' ');

841: RAISE l_err_exception;
842: END;
843: IF l_c_igf_sp_fc.fee_class = 'TUITION' THEN
844: -- rolling over pays program details
845: fnd_file.put_line(fnd_file.log,' ');
846: l_msg_str_0 := RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','COURSE_CD'),12) ||
847: RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','VERSION_NUMBER'),16) ||
848: RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','PERCENT'),10) ||
849: lookup_desc('IGF_AW_LOOKUPS_MSG','MAX_AMOUNT');

Line 850: fnd_file.put_line(fnd_file.log,l_msg_str_0);

846: l_msg_str_0 := RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','COURSE_CD'),12) ||
847: RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','VERSION_NUMBER'),16) ||
848: RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','PERCENT'),10) ||
849: lookup_desc('IGF_AW_LOOKUPS_MSG','MAX_AMOUNT');
850: fnd_file.put_line(fnd_file.log,l_msg_str_0);
851: fnd_file.put_line(fnd_file.log,' ');
852:
853: FOR l_c_igf_sp_prg IN c_igf_sp_prg(cp_fee_cls_id => l_c_igf_sp_fc.fee_cls_id)
854: LOOP

Line 851: fnd_file.put_line(fnd_file.log,' ');

847: RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','VERSION_NUMBER'),16) ||
848: RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','PERCENT'),10) ||
849: lookup_desc('IGF_AW_LOOKUPS_MSG','MAX_AMOUNT');
850: fnd_file.put_line(fnd_file.log,l_msg_str_0);
851: fnd_file.put_line(fnd_file.log,' ');
852:
853: FOR l_c_igf_sp_prg IN c_igf_sp_prg(cp_fee_cls_id => l_c_igf_sp_fc.fee_cls_id)
854: LOOP
855: -- log relevant details

Line 860: fnd_file.put_line(fnd_file.log,l_msg_str_1);

856: l_msg_str_1 := RPAD(l_c_igf_sp_prg.course_cd,12) ||
857: RPAD(l_c_igf_sp_prg.version_number,16) ||
858: NVL(RPAD(TO_CHAR(l_c_igf_sp_prg.fee_percent),10),' ') ||
859: TO_CHAR(l_c_igf_sp_prg.max_amount);
860: fnd_file.put_line(fnd_file.log,l_msg_str_1);
861: l_rowid := NULL;
862: l_fee_cls_prg_id := NULL;
863: BEGIN
864: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision

Line 880: fnd_file.put_line(fnd_file.log,' ');

876: WHEN OTHERS THEN
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 ;

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 886: fnd_file.put_line(fnd_file.log,' ');

882: -- raises user defined exception so as to skip the record
883: RAISE l_err_exception;
884: END ;
885: -- rollover pays only unit details.
886: fnd_file.put_line(fnd_file.log,' ');
887: l_msg_str_0 := RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','UNIT_CD'),12) ||
888: RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','VERSION_NUMBER'),16) ||
889: lookup_desc('IGF_AW_LOOKUPS_MSG','MAX_AMOUNT');
890: fnd_file.put_line(fnd_file.log,l_msg_str_0);

Line 890: fnd_file.put_line(fnd_file.log,l_msg_str_0);

886: fnd_file.put_line(fnd_file.log,' ');
887: l_msg_str_0 := RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','UNIT_CD'),12) ||
888: RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','VERSION_NUMBER'),16) ||
889: lookup_desc('IGF_AW_LOOKUPS_MSG','MAX_AMOUNT');
890: fnd_file.put_line(fnd_file.log,l_msg_str_0);
891: fnd_file.put_line(fnd_file.log,' ');
892: FOR l_c_igf_sp_unit IN c_igf_sp_unit(cp_fee_cls_prg_id => l_c_igf_sp_prg.fee_cls_prg_id)
893: LOOP
894: -- log relevant details

Line 891: fnd_file.put_line(fnd_file.log,' ');

887: l_msg_str_0 := RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','UNIT_CD'),12) ||
888: RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','VERSION_NUMBER'),16) ||
889: lookup_desc('IGF_AW_LOOKUPS_MSG','MAX_AMOUNT');
890: fnd_file.put_line(fnd_file.log,l_msg_str_0);
891: fnd_file.put_line(fnd_file.log,' ');
892: FOR l_c_igf_sp_unit IN c_igf_sp_unit(cp_fee_cls_prg_id => l_c_igf_sp_prg.fee_cls_prg_id)
893: LOOP
894: -- log relevant details
895: l_msg_str_1 := RPAD(l_c_igf_sp_unit.unit_cd,12) ||

Line 898: fnd_file.put_line(fnd_file.log,l_msg_str_1);

894: -- log relevant details
895: l_msg_str_1 := RPAD(l_c_igf_sp_unit.unit_cd,12) ||
896: RPAD(l_c_igf_sp_unit.version_number,16) ||
897: TO_CHAR(l_c_igf_sp_unit.max_amount);
898: fnd_file.put_line(fnd_file.log,l_msg_str_1);
899: l_rowid := NULL;
900: l_fee_cls_unit_id := NULL;
901: BEGIN
902: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision

Line 917: fnd_file.put_line(fnd_file.log,' ');

913: WHEN OTHERS THEN
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;

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 923: fnd_file.put_line(fnd_file.log,' ');

919: -- raises user defined exception so as to skip the record
920: RAISE l_err_exception;
921: END;
922: END LOOP;
923: fnd_file.put_line(fnd_file.log,' ');
924: END LOOP;
925: END IF;
926: END LOOP;
927: EXCEPTION

Line 1066: fnd_file.put_line(fnd_file.log,' ');

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;
1069: END IF;
1070: CLOSE c_fund_mast;

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 1075: fnd_file.put_line(fnd_file.log,l_msg_str_0);

1071:
1072: -- log the relavant details
1073: l_msg_str_0 := RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','FUND_CODE'),32) ||
1074: RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','AWARD_YEAR'),19) ;
1075: fnd_file.put_line(fnd_file.log,l_msg_str_0);
1076: fnd_file.put_line(fnd_file.log,' ');
1077: l_msg_str_1 := RPAD(l_c_igf_aw_fund_mast.fund_code,32)||
1078: RPAD((p_sc_cal_type||' '||p_sc_seq_num),19);
1079: fnd_file.put_line(fnd_file.log,l_msg_str_1);

Line 1076: fnd_file.put_line(fnd_file.log,' ');

1072: -- log the relavant details
1073: l_msg_str_0 := RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','FUND_CODE'),32) ||
1074: RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','AWARD_YEAR'),19) ;
1075: fnd_file.put_line(fnd_file.log,l_msg_str_0);
1076: fnd_file.put_line(fnd_file.log,' ');
1077: l_msg_str_1 := RPAD(l_c_igf_aw_fund_mast.fund_code,32)||
1078: RPAD((p_sc_cal_type||' '||p_sc_seq_num),19);
1079: fnd_file.put_line(fnd_file.log,l_msg_str_1);
1080: fnd_file.put_line(fnd_file.log,' ');

Line 1079: fnd_file.put_line(fnd_file.log,l_msg_str_1);

1075: fnd_file.put_line(fnd_file.log,l_msg_str_0);
1076: fnd_file.put_line(fnd_file.log,' ');
1077: l_msg_str_1 := RPAD(l_c_igf_aw_fund_mast.fund_code,32)||
1078: RPAD((p_sc_cal_type||' '||p_sc_seq_num),19);
1079: fnd_file.put_line(fnd_file.log,l_msg_str_1);
1080: fnd_file.put_line(fnd_file.log,' ');
1081: OPEN c_igf_aw_fund_tp(l_c_fund_mast.fund_id);
1082: FETCH c_igf_aw_fund_tp INTO l_c_igf_aw_fund_tp;
1083: IF c_igf_aw_fund_tp%NOTFOUND THEN

Line 1080: fnd_file.put_line(fnd_file.log,' ');

1076: fnd_file.put_line(fnd_file.log,' ');
1077: l_msg_str_1 := RPAD(l_c_igf_aw_fund_mast.fund_code,32)||
1078: RPAD((p_sc_cal_type||' '||p_sc_seq_num),19);
1079: fnd_file.put_line(fnd_file.log,l_msg_str_1);
1080: fnd_file.put_line(fnd_file.log,' ');
1081: OPEN c_igf_aw_fund_tp(l_c_fund_mast.fund_id);
1082: FETCH c_igf_aw_fund_tp INTO l_c_igf_aw_fund_tp;
1083: IF c_igf_aw_fund_tp%NOTFOUND THEN
1084: -- rolls back to the save point

Line 1091: fnd_file.put_line(fnd_file.log,' ');

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,' ');
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;

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 1105: fnd_file.put_line(fnd_file.log,l_msg_str_0);

1101: RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','END_DT'),22)||
1102: RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','MIN_CRD_POINTS'),19) ||
1103: RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','MIN_ATD_TYPE'),32) ||
1104: lookup_desc('IGF_AW_LOOKUPS_MSG','TOT_SPNSR_AMT');
1105: fnd_file.put_line(fnd_file.log,l_msg_str_0);
1106: fnd_file.put_line(fnd_file.log,' ');
1107:
1108: -- rolling over sponsor student relation for fund and term calendar for the succeeding award year
1109: FOR l_c_igf_sp_stdnt_rel IN c_igf_sp_stdnt_rel(cp_fund_id => l_c_igf_aw_fund_mast.fund_id)

Line 1106: fnd_file.put_line(fnd_file.log,' ');

1102: RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','MIN_CRD_POINTS'),19) ||
1103: RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','MIN_ATD_TYPE'),32) ||
1104: lookup_desc('IGF_AW_LOOKUPS_MSG','TOT_SPNSR_AMT');
1105: fnd_file.put_line(fnd_file.log,l_msg_str_0);
1106: fnd_file.put_line(fnd_file.log,' ');
1107:
1108: -- rolling over sponsor student relation for fund and term calendar for the succeeding award year
1109: FOR l_c_igf_sp_stdnt_rel IN c_igf_sp_stdnt_rel(cp_fund_id => l_c_igf_aw_fund_mast.fund_id)
1110: LOOP

Line 1131: fnd_file.put_line(fnd_file.log,' ');

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,' ');
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;

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 1162: fnd_file.put_line(fnd_file.log,' ');

1158:
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;

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 1178: fnd_file.put_line(fnd_file.log,l_msg_str_1);

1174: NVL(RPAD(TO_CHAR(l_c_igf_sp_stdnt_rel.min_credit_points),19),' ') ||
1175: NVL(RPAD(l_c_igf_sp_stdnt_rel.min_attendance_type,32),' ' )||
1176: TO_CHAR(l_c_igf_sp_stdnt_rel.tot_spnsr_amount);
1177:
1178: fnd_file.put_line(fnd_file.log,l_msg_str_1);
1179: l_spnsr_stdnt_id := NULL;
1180: l_rowid := NULL;
1181: BEGIN
1182: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision

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 1207: fnd_file.put_line(fnd_file.log,' ');

1203: RAISE l_stud_exception;
1204: END ;
1205:
1206: -- log relevant details
1207: fnd_file.put_line(fnd_file.log,' ');
1208: l_msg_str_0 := RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','FEE_CLASS'),32) ||
1209: RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','PERCENT'),10) ||
1210: lookup_desc('IGF_AW_LOOKUPS_MSG','MAX_AMOUNT');
1211: fnd_file.put_line(fnd_file.log,l_msg_str_0);

Line 1211: fnd_file.put_line(fnd_file.log,l_msg_str_0);

1207: fnd_file.put_line(fnd_file.log,' ');
1208: l_msg_str_0 := RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','FEE_CLASS'),32) ||
1209: RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','PERCENT'),10) ||
1210: lookup_desc('IGF_AW_LOOKUPS_MSG','MAX_AMOUNT');
1211: fnd_file.put_line(fnd_file.log,l_msg_str_0);
1212: fnd_file.put_line(fnd_file.log,' ');
1213: -- rolling over fee class details
1214: FOR l_c_igf_sp_std_fc IN c_igf_sp_std_fc(cp_spnsr_stdnt_id => l_c_igf_sp_stdnt_rel.spnsr_stdnt_id)
1215: LOOP

Line 1212: fnd_file.put_line(fnd_file.log,' ');

1208: l_msg_str_0 := RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','FEE_CLASS'),32) ||
1209: RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','PERCENT'),10) ||
1210: lookup_desc('IGF_AW_LOOKUPS_MSG','MAX_AMOUNT');
1211: fnd_file.put_line(fnd_file.log,l_msg_str_0);
1212: fnd_file.put_line(fnd_file.log,' ');
1213: -- rolling over fee class details
1214: FOR l_c_igf_sp_std_fc IN c_igf_sp_std_fc(cp_spnsr_stdnt_id => l_c_igf_sp_stdnt_rel.spnsr_stdnt_id)
1215: LOOP
1216: -- log relevant details

Line 1220: fnd_file.put_line(fnd_file.log,l_msg_str_1);

1216: -- log relevant details
1217: l_msg_str_1 := RPAD(l_c_igf_sp_std_fc.fee_class,32) ||
1218: NVL(RPAD(TO_CHAR(l_c_igf_sp_std_fc.fee_percent),10),' ' )||
1219: TO_CHAR(l_c_igf_sp_std_fc.max_amount);
1220: fnd_file.put_line(fnd_file.log,l_msg_str_1);
1221: l_rowid := NULL;
1222: l_fee_cls_id := NULL;
1223: BEGIN
1224: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision

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 1245: fnd_file.put_line(fnd_file.log,' ');

1241: RAISE l_err_exception;
1242: END;
1243: IF l_c_igf_sp_std_fc.fee_class = 'TUITION' THEN
1244: -- log relevant details
1245: fnd_file.put_line(fnd_file.log,' ');
1246: l_msg_str_0 := RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','COURSE_CD'),12) ||
1247: RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','VERSION_NUMBER'),16) ||
1248: RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','PERCENT'),10) ||
1249: lookup_desc('IGF_AW_LOOKUPS_MSG','MAX_AMOUNT');

Line 1250: fnd_file.put_line(fnd_file.log,l_msg_str_0);

1246: l_msg_str_0 := RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','COURSE_CD'),12) ||
1247: RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','VERSION_NUMBER'),16) ||
1248: RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','PERCENT'),10) ||
1249: lookup_desc('IGF_AW_LOOKUPS_MSG','MAX_AMOUNT');
1250: fnd_file.put_line(fnd_file.log,l_msg_str_0);
1251: fnd_file.put_line(fnd_file.log,' ');
1252: -- rolling over program details
1253: FOR l_c_igf_sp_std_prg IN c_igf_sp_std_prg(cp_fee_cls_id => l_c_igf_sp_std_fc.fee_cls_id)
1254: LOOP

Line 1251: fnd_file.put_line(fnd_file.log,' ');

1247: RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','VERSION_NUMBER'),16) ||
1248: RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','PERCENT'),10) ||
1249: lookup_desc('IGF_AW_LOOKUPS_MSG','MAX_AMOUNT');
1250: fnd_file.put_line(fnd_file.log,l_msg_str_0);
1251: fnd_file.put_line(fnd_file.log,' ');
1252: -- rolling over program details
1253: FOR l_c_igf_sp_std_prg IN c_igf_sp_std_prg(cp_fee_cls_id => l_c_igf_sp_std_fc.fee_cls_id)
1254: LOOP
1255: -- log relevant details

Line 1260: fnd_file.put_line(fnd_file.log,l_msg_str_1);

1256: l_msg_str_1 := RPAD(l_c_igf_sp_std_prg.course_cd,12) ||
1257: RPAD(l_c_igf_sp_std_prg.version_number,16) ||
1258: NVL(RPAD(TO_CHAR(l_c_igf_sp_std_prg.fee_percent),10),' ') ||
1259: TO_CHAR(l_c_igf_sp_std_prg.max_amount);
1260: fnd_file.put_line(fnd_file.log,l_msg_str_1);
1261: l_fee_cls_prg_id := NULL;
1262: l_rowid := NULL;
1263: BEGIN
1264: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision

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 1284: fnd_file.put_line(fnd_file.log,' ');

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,' ');
1285: l_msg_str_0 := RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','UNIT_CD'),12) ||
1286: RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','VERSION_NUMBER'),16) ||
1287: lookup_desc('IGF_AW_LOOKUPS_MSG','MAX_AMOUNT');
1288: fnd_file.put_line(fnd_file.log,l_msg_str_0);

Line 1288: fnd_file.put_line(fnd_file.log,l_msg_str_0);

1284: fnd_file.put_line(fnd_file.log,' ');
1285: l_msg_str_0 := RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','UNIT_CD'),12) ||
1286: RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','VERSION_NUMBER'),16) ||
1287: lookup_desc('IGF_AW_LOOKUPS_MSG','MAX_AMOUNT');
1288: fnd_file.put_line(fnd_file.log,l_msg_str_0);
1289: fnd_file.put_line(fnd_file.log,' ');
1290: -- rolling over unit details
1291: FOR l_c_igf_sp_std_unit IN c_igf_sp_std_unit(cp_fee_cls_prg_id => l_c_igf_sp_std_prg.fee_cls_prg_id)
1292: LOOP

Line 1289: fnd_file.put_line(fnd_file.log,' ');

1285: l_msg_str_0 := RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','UNIT_CD'),12) ||
1286: RPAD(lookup_desc('IGF_AW_LOOKUPS_MSG','VERSION_NUMBER'),16) ||
1287: lookup_desc('IGF_AW_LOOKUPS_MSG','MAX_AMOUNT');
1288: fnd_file.put_line(fnd_file.log,l_msg_str_0);
1289: fnd_file.put_line(fnd_file.log,' ');
1290: -- rolling over unit details
1291: FOR l_c_igf_sp_std_unit IN c_igf_sp_std_unit(cp_fee_cls_prg_id => l_c_igf_sp_std_prg.fee_cls_prg_id)
1292: LOOP
1293: -- log relevant details

Line 1297: fnd_file.put_line(fnd_file.log,l_msg_str_1);

1293: -- log relevant details
1294: l_msg_str_1 := RPAD(l_c_igf_sp_std_unit.unit_cd,12) ||
1295: RPAD(l_c_igf_sp_std_unit.version_number,16) ||
1296: TO_CHAR(l_c_igf_sp_std_unit.max_amount);
1297: fnd_file.put_line(fnd_file.log,l_msg_str_1);
1298: l_fee_cls_unit_id := NULL;
1299: l_rowid := NULL;
1300: BEGIN
1301: -- Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision

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;

Line 1321: fnd_file.put_line(fnd_file.log,' ');

1317: -- raises user defined exception so as to skip the record
1318: RAISE l_err_exception;
1319: END;
1320: END LOOP;
1321: fnd_file.put_line(fnd_file.log,' ');
1322: END LOOP;
1323: END IF;
1324: END LOOP;
1325: EXCEPTION