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_GR_REPACKAGE dependencies on FND_FILE

Line 113: fnd_file.new_line(fnd_file.log,2);

109: l_pers_id_grp_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PERSON_ID_GROUP');
110: l_test_run_log := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','TEST_MODE');
111: l_cancel_inv_awd_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','CANCEL_INVALID_AWD');
112:
113: fnd_file.new_line(fnd_file.log,2);
114: fnd_file.put_line(fnd_file.log,l_param_pass_log);
115:
116: OPEN c_alternate_code(p_cal_type,p_sequence_number);
117: FETCH c_alternate_code INTO l_alternate_code;

Line 114: fnd_file.put_line(fnd_file.log,l_param_pass_log);

110: l_test_run_log := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','TEST_MODE');
111: l_cancel_inv_awd_log := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','CANCEL_INVALID_AWD');
112:
113: fnd_file.new_line(fnd_file.log,2);
114: fnd_file.put_line(fnd_file.log,l_param_pass_log);
115:
116: OPEN c_alternate_code(p_cal_type,p_sequence_number);
117: FETCH c_alternate_code INTO l_alternate_code;
118: CLOSE c_alternate_code;

Line 120: fnd_file.put_line(fnd_file.log,RPAD(l_awd_yr_log,40) || ' : ' || l_alternate_code);

116: OPEN c_alternate_code(p_cal_type,p_sequence_number);
117: FETCH c_alternate_code INTO l_alternate_code;
118: CLOSE c_alternate_code;
119:
120: fnd_file.put_line(fnd_file.log,RPAD(l_awd_yr_log,40) || ' : ' || l_alternate_code);
121:
122: OPEN c_person_number(p_base_id);
123: FETCH c_person_number INTO l_person_number;
124: CLOSE c_person_number;

Line 130: fnd_file.put_line(fnd_file.log,RPAD(l_pers_number_log,40) || ' : ' || l_person_number);

126: OPEN c_person_group(p_persid_grp);
127: FETCH c_person_group INTO l_persid_grp_name;
128: CLOSE c_person_group;
129:
130: fnd_file.put_line(fnd_file.log,RPAD(l_pers_number_log,40) || ' : ' || l_person_number);
131: fnd_file.put_line(fnd_file.log,RPAD(l_pers_id_grp_log,40) || ' : ' || l_persid_grp_name.group_name);
132: fnd_file.put_line(fnd_file.log,RPAD(l_test_run_log,40) || ' : ' || p_test_run);
133: fnd_file.put_line(fnd_file.log,RPAD(l_cancel_inv_awd_log,40) || ' : ' || p_cancel_invalid_award);
134: fnd_file.put_line(fnd_file.log,RPAD('-',55,'-'));

Line 131: fnd_file.put_line(fnd_file.log,RPAD(l_pers_id_grp_log,40) || ' : ' || l_persid_grp_name.group_name);

127: FETCH c_person_group INTO l_persid_grp_name;
128: CLOSE c_person_group;
129:
130: fnd_file.put_line(fnd_file.log,RPAD(l_pers_number_log,40) || ' : ' || l_person_number);
131: fnd_file.put_line(fnd_file.log,RPAD(l_pers_id_grp_log,40) || ' : ' || l_persid_grp_name.group_name);
132: fnd_file.put_line(fnd_file.log,RPAD(l_test_run_log,40) || ' : ' || p_test_run);
133: fnd_file.put_line(fnd_file.log,RPAD(l_cancel_inv_awd_log,40) || ' : ' || p_cancel_invalid_award);
134: fnd_file.put_line(fnd_file.log,RPAD('-',55,'-'));
135: fnd_file.new_line(fnd_file.log,2);

Line 132: fnd_file.put_line(fnd_file.log,RPAD(l_test_run_log,40) || ' : ' || p_test_run);

128: CLOSE c_person_group;
129:
130: fnd_file.put_line(fnd_file.log,RPAD(l_pers_number_log,40) || ' : ' || l_person_number);
131: fnd_file.put_line(fnd_file.log,RPAD(l_pers_id_grp_log,40) || ' : ' || l_persid_grp_name.group_name);
132: fnd_file.put_line(fnd_file.log,RPAD(l_test_run_log,40) || ' : ' || p_test_run);
133: fnd_file.put_line(fnd_file.log,RPAD(l_cancel_inv_awd_log,40) || ' : ' || p_cancel_invalid_award);
134: fnd_file.put_line(fnd_file.log,RPAD('-',55,'-'));
135: fnd_file.new_line(fnd_file.log,2);
136:

Line 133: fnd_file.put_line(fnd_file.log,RPAD(l_cancel_inv_awd_log,40) || ' : ' || p_cancel_invalid_award);

129:
130: fnd_file.put_line(fnd_file.log,RPAD(l_pers_number_log,40) || ' : ' || l_person_number);
131: fnd_file.put_line(fnd_file.log,RPAD(l_pers_id_grp_log,40) || ' : ' || l_persid_grp_name.group_name);
132: fnd_file.put_line(fnd_file.log,RPAD(l_test_run_log,40) || ' : ' || p_test_run);
133: fnd_file.put_line(fnd_file.log,RPAD(l_cancel_inv_awd_log,40) || ' : ' || p_cancel_invalid_award);
134: fnd_file.put_line(fnd_file.log,RPAD('-',55,'-'));
135: fnd_file.new_line(fnd_file.log,2);
136:
137: EXCEPTION

Line 134: fnd_file.put_line(fnd_file.log,RPAD('-',55,'-'));

130: fnd_file.put_line(fnd_file.log,RPAD(l_pers_number_log,40) || ' : ' || l_person_number);
131: fnd_file.put_line(fnd_file.log,RPAD(l_pers_id_grp_log,40) || ' : ' || l_persid_grp_name.group_name);
132: fnd_file.put_line(fnd_file.log,RPAD(l_test_run_log,40) || ' : ' || p_test_run);
133: fnd_file.put_line(fnd_file.log,RPAD(l_cancel_inv_awd_log,40) || ' : ' || p_cancel_invalid_award);
134: fnd_file.put_line(fnd_file.log,RPAD('-',55,'-'));
135: fnd_file.new_line(fnd_file.log,2);
136:
137: EXCEPTION
138: WHEN OTHERS THEN

Line 135: fnd_file.new_line(fnd_file.log,2);

131: fnd_file.put_line(fnd_file.log,RPAD(l_pers_id_grp_log,40) || ' : ' || l_persid_grp_name.group_name);
132: fnd_file.put_line(fnd_file.log,RPAD(l_test_run_log,40) || ' : ' || p_test_run);
133: fnd_file.put_line(fnd_file.log,RPAD(l_cancel_inv_awd_log,40) || ' : ' || p_cancel_invalid_award);
134: fnd_file.put_line(fnd_file.log,RPAD('-',55,'-'));
135: fnd_file.new_line(fnd_file.log,2);
136:
137: EXCEPTION
138: WHEN OTHERS THEN
139: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

Line 526: fnd_file.new_line(fnd_file.log,1);

522: ln_msg_index NUMBER;
523:
524: BEGIN
525:
526: fnd_file.new_line(fnd_file.log,1);
527: fnd_message.set_name('IGF', 'IGF_AW_PROCESS_STUD');
528: OPEN c_person_number(p_base_id);
529: FETCH c_person_number INTO l_person_number;
530: fnd_message.set_token('STUD',l_person_number);

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

527: fnd_message.set_name('IGF', 'IGF_AW_PROCESS_STUD');
528: OPEN c_person_number(p_base_id);
529: FETCH c_person_number INTO l_person_number;
530: fnd_message.set_token('STUD',l_person_number);
531: fnd_file.put_line(fnd_file.log, fnd_message.get);
532:
533: OPEN c_stud_det(
534: p_base_id
535: );

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

537: IF c_stud_det%NOTFOUND THEN
538: CLOSE c_stud_det;
539:
540: fnd_message.set_name('IGF', 'IGF_AW_NO_PELL_STUDENT');
541: fnd_file.put_line(fnd_file.log, fnd_message.get);
542: RETURN;
543: END IF;
544:
545: --

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

576: END IF;
577:
578: IF lc_rfms_disb.disb_ack_act_status NOT IN ('R','N') THEN
579: fnd_message.set_name('IGF', 'IGF_GR_DISB_SENT_NO_RECALC');
580: fnd_file.put_line( fnd_file.log, fnd_message.get);
581:
582: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
583: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','pell orig sent...erroring out');
584: END IF;

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

601: FETCH c_award INTO lc_award;
602:
603: IF c_award%NOTFOUND THEN
604: fnd_message.set_name('IGF', 'IGF_AW_NO_AWARD_REC');
605: fnd_file.put_line( fnd_file.log, fnd_message.get);
606: CLOSE c_award;
607:
608: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
609: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','no PELL award for student');

Line 644: fnd_file.put_line(fnd_file.log, lv_message);

640: lv_message := lv_message ||
641: fnd_global.newline ||
642: lv_msg_text;
643: END LOOP;
644: fnd_file.put_line(fnd_file.log, lv_message);
645: END IF;
646:
647:
648: IF g_test_run = 'Y' THEN

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

652:
653: fnd_message.set_name('IGF','IGF_AW_AWARD_CANCELLED');
654: fnd_message.set_token('AWD',lc_stud_det.award_id);
655: fnd_message.set_token('FUND',lc_stud_det.fund_code);
656: fnd_file.put_line(fnd_file.log,fnd_message.get);
657:
658: ELSE -- Test run but not in Cancel Mode
659: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
660: fnd_file.put_line(fnd_file.log,fnd_message.get);

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

656: fnd_file.put_line(fnd_file.log,fnd_message.get);
657:
658: ELSE -- Test run but not in Cancel Mode
659: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
660: fnd_file.put_line(fnd_file.log,fnd_message.get);
661: fnd_file.new_line(fnd_file.log,1);
662:
663: END IF;
664:

Line 661: fnd_file.new_line(fnd_file.log,1);

657:
658: ELSE -- Test run but not in Cancel Mode
659: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
660: fnd_file.put_line(fnd_file.log,fnd_message.get);
661: fnd_file.new_line(fnd_file.log,1);
662:
663: END IF;
664:
665:

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

670:
671: fnd_message.set_name('IGF','IGF_AW_AWARD_CANCELLED');
672: fnd_message.set_token('AWD',lc_stud_det.award_id);
673: fnd_message.set_token('FUND',lc_stud_det.fund_code);
674: fnd_file.put_line(fnd_file.log,fnd_message.get);
675:
676: cancel_invalid_award(lc_stud_det.award_id);
677: COMMIT;
678: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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

681:
682: ELSE -- Actual Mode but Cancel Awards not set to Yes
683:
684: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
685: fnd_file.put_line(fnd_file.log,fnd_message.get);
686: fnd_file.new_line(fnd_file.log,1);
687:
688: END IF;
689:

Line 686: fnd_file.new_line(fnd_file.log,1);

682: ELSE -- Actual Mode but Cancel Awards not set to Yes
683:
684: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
685: fnd_file.put_line(fnd_file.log,fnd_message.get);
686: fnd_file.new_line(fnd_file.log,1);
687:
688: END IF;
689:
690: END IF;

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

704: IF NVL(l_payment_isir.isir_id, -1) <> NVL(l_active_isir.isir_id, -2) THEN
705:
706: --log messages
707: fnd_message.set_name('IGF','IGF_AP_PELL_ISIR_CHK');
708: fnd_file.put_line(fnd_file.log,fnd_message.get);
709: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
710: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_gr_repackage.repackage.debug','payment isir is not active isir..error');
711: END IF;
712:

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

712:
713: IF g_test_run <> 'Y' AND g_cancel_invalid_awds = 'Y' THEN
714: --cancel award and disbursements
715: fnd_message.set_name('IGF','IGF_AP_PELL_ISIR_CHK');
716: fnd_file.put_line(fnd_file.log,fnd_message.get);
717:
718: fnd_message.set_name('IGF','IGF_AW_AWARD_CANCELLED');
719: fnd_message.set_token('AWD',lc_stud_det.award_id);
720: fnd_message.set_token('FUND',lc_stud_det.fund_code);

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

717:
718: fnd_message.set_name('IGF','IGF_AW_AWARD_CANCELLED');
719: fnd_message.set_token('AWD',lc_stud_det.award_id);
720: fnd_message.set_token('FUND',lc_stud_det.fund_code);
721: fnd_file.put_line(fnd_file.log,fnd_message.get);
722:
723: cancel_invalid_award(lc_stud_det.award_id);
724: COMMIT;
725: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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

727: END IF;
728:
729: ELSE
730: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
731: fnd_file.put_line(fnd_file.log,fnd_message.get);
732: fnd_file.new_line(fnd_file.log,1);
733: END IF;
734:
735: RETURN ;

Line 732: fnd_file.new_line(fnd_file.log,1);

728:
729: ELSE
730: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
731: fnd_file.put_line(fnd_file.log,fnd_message.get);
732: fnd_file.new_line(fnd_file.log,1);
733: END IF;
734:
735: RETURN ;
736:

Line 777: fnd_file.put_line(fnd_file.log,lv_message);

773: -- ========== Now do Table Insert ===========---
774:
775: -- Check for Failure
776: IF lv_return_status <> 'S' THEN
777: fnd_file.put_line(fnd_file.log,lv_message);
778: RAISE e_next_record;
779: END IF;
780:
781: -- Check for new pall amount match in which case abort processing

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

780:
781: -- Check for new pall amount match in which case abort processing
782: IF l_offered_amt = lc_award.offered_amt THEN
783: fnd_message.set_name('IGF','IGF_GR_PELL_VALID_PELL_AWARD');
784: fnd_file.put_line(fnd_file.log,fnd_message.get);
785: RAISE e_next_record;
786: END IF;
787:
788: -- Check if Origination Exists

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

806: );
807:
808: -- Check for Failure
809: IF lv_return_status_ft <> 'S' THEN
810: fnd_file.put_line(fnd_file.log,lv_message_ft);
811: RAISE e_next_record;
812: END IF;
813:
814: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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

889: */
890: fnd_message.set_name('IGF','IGF_AW_ENTITLE_OVAWD');
891: fnd_message.set_token('FUND_CODE',lc_stud_det.fund_code);
892: fnd_message.set_token('AWD',TO_CHAR(l_offered_amt));
893: fnd_file.put_line(fnd_file.log,fnd_message.get);
894: END IF;
895:
896: -- Loop thru the disbursements and post data
897: fnd_file.put_line(fnd_file.log, RPAD('-',210,'-'));

Line 897: fnd_file.put_line(fnd_file.log, RPAD('-',210,'-'));

893: fnd_file.put_line(fnd_file.log,fnd_message.get);
894: END IF;
895:
896: -- Loop thru the disbursements and post data
897: fnd_file.put_line(fnd_file.log, RPAD('-',210,'-'));
898: -- fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','DISBURSEMENT_NUMBER'), 18, ' '));
899: fnd_file.put(fnd_file.log, RPAD('#', 3, ' '));
900: fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','DISBURSEMENT_DATE'), 30, ' '));
901: fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAD_CALENDAR'), 30, ' '));

Line 898: -- fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','DISBURSEMENT_NUMBER'), 18, ' '));

894: END IF;
895:
896: -- Loop thru the disbursements and post data
897: fnd_file.put_line(fnd_file.log, RPAD('-',210,'-'));
898: -- fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','DISBURSEMENT_NUMBER'), 18, ' '));
899: fnd_file.put(fnd_file.log, RPAD('#', 3, ' '));
900: fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','DISBURSEMENT_DATE'), 30, ' '));
901: fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAD_CALENDAR'), 30, ' '));
902: fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','TEACHING_CALENDAR'), 30, ' '));

Line 899: fnd_file.put(fnd_file.log, RPAD('#', 3, ' '));

895:
896: -- Loop thru the disbursements and post data
897: fnd_file.put_line(fnd_file.log, RPAD('-',210,'-'));
898: -- fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','DISBURSEMENT_NUMBER'), 18, ' '));
899: fnd_file.put(fnd_file.log, RPAD('#', 3, ' '));
900: fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','DISBURSEMENT_DATE'), 30, ' '));
901: fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAD_CALENDAR'), 30, ' '));
902: fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','TEACHING_CALENDAR'), 30, ' '));
903: fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','OFFERED_AMT'), 30, ' '));

Line 900: fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','DISBURSEMENT_DATE'), 30, ' '));

896: -- Loop thru the disbursements and post data
897: fnd_file.put_line(fnd_file.log, RPAD('-',210,'-'));
898: -- fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','DISBURSEMENT_NUMBER'), 18, ' '));
899: fnd_file.put(fnd_file.log, RPAD('#', 3, ' '));
900: fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','DISBURSEMENT_DATE'), 30, ' '));
901: fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAD_CALENDAR'), 30, ' '));
902: fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','TEACHING_CALENDAR'), 30, ' '));
903: fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','OFFERED_AMT'), 30, ' '));
904: fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','ACCEPTED_AMT'), 30, ' '));

Line 901: fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAD_CALENDAR'), 30, ' '));

897: fnd_file.put_line(fnd_file.log, RPAD('-',210,'-'));
898: -- fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','DISBURSEMENT_NUMBER'), 18, ' '));
899: fnd_file.put(fnd_file.log, RPAD('#', 3, ' '));
900: fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','DISBURSEMENT_DATE'), 30, ' '));
901: fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAD_CALENDAR'), 30, ' '));
902: fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','TEACHING_CALENDAR'), 30, ' '));
903: fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','OFFERED_AMT'), 30, ' '));
904: fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','ACCEPTED_AMT'), 30, ' '));
905: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','BASE_ATTEND_TYPE'), 30, ' '));

Line 902: fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','TEACHING_CALENDAR'), 30, ' '));

898: -- fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','DISBURSEMENT_NUMBER'), 18, ' '));
899: fnd_file.put(fnd_file.log, RPAD('#', 3, ' '));
900: fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','DISBURSEMENT_DATE'), 30, ' '));
901: fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAD_CALENDAR'), 30, ' '));
902: fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','TEACHING_CALENDAR'), 30, ' '));
903: fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','OFFERED_AMT'), 30, ' '));
904: fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','ACCEPTED_AMT'), 30, ' '));
905: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','BASE_ATTEND_TYPE'), 30, ' '));
906: fnd_file.put_line(fnd_file.log, RPAD('-',210,'-'));

Line 903: fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','OFFERED_AMT'), 30, ' '));

899: fnd_file.put(fnd_file.log, RPAD('#', 3, ' '));
900: fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','DISBURSEMENT_DATE'), 30, ' '));
901: fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAD_CALENDAR'), 30, ' '));
902: fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','TEACHING_CALENDAR'), 30, ' '));
903: fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','OFFERED_AMT'), 30, ' '));
904: fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','ACCEPTED_AMT'), 30, ' '));
905: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','BASE_ATTEND_TYPE'), 30, ' '));
906: fnd_file.put_line(fnd_file.log, RPAD('-',210,'-'));
907:

Line 904: fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','ACCEPTED_AMT'), 30, ' '));

900: fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','DISBURSEMENT_DATE'), 30, ' '));
901: fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAD_CALENDAR'), 30, ' '));
902: fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','TEACHING_CALENDAR'), 30, ' '));
903: fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','OFFERED_AMT'), 30, ' '));
904: fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','ACCEPTED_AMT'), 30, ' '));
905: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','BASE_ATTEND_TYPE'), 30, ' '));
906: fnd_file.put_line(fnd_file.log, RPAD('-',210,'-'));
907:
908: FOR i IN 1..l_pell_tab.COUNT

Line 905: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','BASE_ATTEND_TYPE'), 30, ' '));

901: fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','LOAD_CALENDAR'), 30, ' '));
902: fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','TEACHING_CALENDAR'), 30, ' '));
903: fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','OFFERED_AMT'), 30, ' '));
904: fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','ACCEPTED_AMT'), 30, ' '));
905: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','BASE_ATTEND_TYPE'), 30, ' '));
906: fnd_file.put_line(fnd_file.log, RPAD('-',210,'-'));
907:
908: FOR i IN 1..l_pell_tab.COUNT
909: LOOP

Line 906: fnd_file.put_line(fnd_file.log, RPAD('-',210,'-'));

902: fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','TEACHING_CALENDAR'), 30, ' '));
903: fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','OFFERED_AMT'), 30, ' '));
904: fnd_file.put(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_AW_LOOKUPS_MSG','ACCEPTED_AMT'), 30, ' '));
905: fnd_file.put_line(fnd_file.log, RPAD(igf_aw_gen.lookup_desc('IGF_GE_PARAMETERS','BASE_ATTEND_TYPE'), 30, ' '));
906: fnd_file.put_line(fnd_file.log, RPAD('-',210,'-'));
907:
908: FOR i IN 1..l_pell_tab.COUNT
909: LOOP
910: l_log_message := RPAD(TO_CHAR(l_pell_tab(i).sl_number) ,3,' ');

Line 928: fnd_file.put_line(fnd_file.log, l_log_message);

924: l_log_message := l_log_message || RPAD(TO_CHAR(l_pell_tab(i).offered_amt) ,30,' ');
925: l_log_message := l_log_message || RPAD(TO_CHAR(l_pell_tab(i).accepted_amt) ,30,' ');
926: l_log_message := l_log_message || RPAD(igf_aw_gen.lookup_desc('IGF_GR_RFMS_ENROL_STAT',l_pell_tab(i).base_attendance_type_code) ,30,' ');
927:
928: fnd_file.put_line(fnd_file.log, l_log_message);
929: --update the disbursement here, if it exists
930: --else insert the disbursement
931:
932: -- Update only if run in the the Non Test Mode

Line 1288: fnd_file.put_line(fnd_file.log, RPAD('-',210,'-'));

1284: );
1285: END IF;
1286: END IF;
1287:
1288: fnd_file.put_line(fnd_file.log, RPAD('-',210,'-'));
1289:
1290:
1291: --issue a commit
1292: COMMIT;

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

1292: COMMIT;
1293:
1294:
1295: fnd_message.set_name('IGF','IGF_AW_PROCESS_COMPLETE');
1296: fnd_file.put_line( fnd_file.log, fnd_message.get);
1297: fnd_file.new_line(fnd_file.log,2);
1298:
1299: EXCEPTION
1300:

Line 1297: fnd_file.new_line(fnd_file.log,2);

1293:
1294:
1295: fnd_message.set_name('IGF','IGF_AW_PROCESS_COMPLETE');
1296: fnd_file.put_line( fnd_file.log, fnd_message.get);
1297: fnd_file.new_line(fnd_file.log,2);
1298:
1299: EXCEPTION
1300:
1301: WHEN e_next_record THEN

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

1300:
1301: WHEN e_next_record THEN
1302: ROLLBACK to sv_student;
1303: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
1304: fnd_file.put_line(fnd_file.log,fnd_message.get);
1305: fnd_file.new_line(fnd_file.log,1);
1306:
1307: WHEN others THEN
1308: ROLLBACK to sv_student;

Line 1305: fnd_file.new_line(fnd_file.log,1);

1301: WHEN e_next_record THEN
1302: ROLLBACK to sv_student;
1303: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
1304: fnd_file.put_line(fnd_file.log,fnd_message.get);
1305: fnd_file.new_line(fnd_file.log,1);
1306:
1307: WHEN others THEN
1308: ROLLBACK to sv_student;
1309: fnd_file.put_line(fnd_file.log,SQLERRM);

Line 1309: fnd_file.put_line(fnd_file.log,SQLERRM);

1305: fnd_file.new_line(fnd_file.log,1);
1306:
1307: WHEN others THEN
1308: ROLLBACK to sv_student;
1309: fnd_file.put_line(fnd_file.log,SQLERRM);
1310: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
1311: fnd_file.new_line(fnd_file.log,1);
1312:
1313: END repackage;

Line 1311: fnd_file.new_line(fnd_file.log,1);

1307: WHEN others THEN
1308: ROLLBACK to sv_student;
1309: fnd_file.put_line(fnd_file.log,SQLERRM);
1310: fnd_message.set_name('IGF','IGF_SL_SKIPPING');
1311: fnd_file.new_line(fnd_file.log,1);
1312:
1313: END repackage;
1314:
1315:

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

1378:
1379:
1380: IF p_award_year IS NULL THEN
1381: fnd_message.set_name('IGS','IGS_GE_INSUFFICIENT_PARAMETER');
1382: fnd_file.put_line(fnd_file.log,fnd_message.get);
1383: RETURN;
1384: END IF;
1385:
1386: -- Process only the given fund in the given Award Year.

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

1405:
1406: IF p_base_id IS NOT NULL AND p_persid_grp IS NOT NULL THEN
1407: --Cannot pass both base_id and person_id group.
1408: fnd_message.set_name('IGF', 'IGF_AW_COA_PARAM_EX');
1409: fnd_file.put_line( fnd_file.log, fnd_message.get);
1410: RETURN;
1411: END IF;
1412:
1413: --

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

1441: FETCH cur_base_id INTO l_base_id;
1442: END LOOP;
1443: ELSE
1444: fnd_message.set_name('IGF','IGF_DB_NO_PER_GRP');
1445: fnd_file.put_line(fnd_file.log,fnd_message.get);
1446: END IF;
1447:
1448: ELSIF p_base_id IS NOT NULL THEN
1449: --call the routine for the single base_id