APPS.IGF_SL_DL_GEN_XML dependencies on IGF_GR_GEN

Line 870: igf_sl_gen.get_person_details(igf_gr_gen.get_person_id(p_loan_rec.base_id),student_dtl_cur);

866: END IF ;
867: END IF;
868: END IF;
869:
870: igf_sl_gen.get_person_details(igf_gr_gen.get_person_id(p_loan_rec.base_id),student_dtl_cur);
871: FETCH student_dtl_cur INTO student_dtl_rec;
872: CLOSE student_dtl_cur;
873:
874: IF p_loan_rec.fed_fund_code = 'DLP' THEN

Line 1288: fnd_file.put_line(fnd_file.log, RPAD(lv_award_year,40) || ' : '|| igf_gr_gen.get_alt_code(p_cal_type,p_seq_number));

1284: fnd_file.new_line(fnd_file.log,1);
1285: fnd_file.put_line(fnd_file.log, lv_parameter_pass); --------------Parameters Passed--------------
1286: fnd_file.new_line(fnd_file.log,1);
1287:
1288: fnd_file.put_line(fnd_file.log, RPAD(lv_award_year,40) || ' : '|| igf_gr_gen.get_alt_code(p_cal_type,p_seq_number));
1289: fnd_file.put_line(fnd_file.log, RPAD(lv_source_entity_id,40) || ' : '|| p_source_id);
1290: fnd_file.put_line(fnd_file.log, RPAD(lv_report_entity_id,40) || ' : '|| p_report_id);
1291: fnd_file.put_line(fnd_file.log, RPAD(lv_attend_entity_id,40) || ' : '|| p_attend_id);
1292: fnd_file.put_line(fnd_file.log, RPAD(lv_loan_type,40) || ' : '|| get_fund_desc(p_fund_id));

Line 1293: fnd_file.put_line(fnd_file.log, RPAD(lv_person_number,40) || ' : '|| igf_gr_gen.get_per_num(p_base_id));

1289: fnd_file.put_line(fnd_file.log, RPAD(lv_source_entity_id,40) || ' : '|| p_source_id);
1290: fnd_file.put_line(fnd_file.log, RPAD(lv_report_entity_id,40) || ' : '|| p_report_id);
1291: fnd_file.put_line(fnd_file.log, RPAD(lv_attend_entity_id,40) || ' : '|| p_attend_id);
1292: fnd_file.put_line(fnd_file.log, RPAD(lv_loan_type,40) || ' : '|| get_fund_desc(p_fund_id));
1293: fnd_file.put_line(fnd_file.log, RPAD(lv_person_number,40) || ' : '|| igf_gr_gen.get_per_num(p_base_id));
1294: fnd_file.put_line(fnd_file.log, RPAD(lv_loan_number,40) || ' : '|| get_loan_number(p_loan_id));
1295: fnd_file.put_line(fnd_file.log, RPAD(lv_person_id_group,40) || ' : '|| get_grp_name(p_pgroup_id));
1296:
1297: fnd_file.new_line(fnd_file.log,1);

Line 1670: ( igf_gr_gen.get_per_num(p_base_id) IS NULL OR

1666:
1667: END IF;
1668:
1669: IF p_base_id IS NOT NULL AND
1670: ( igf_gr_gen.get_per_num(p_base_id) IS NULL OR
1671: NOT check_fa_rec(p_base_id, lv_cal_type, ln_seq_number))
1672: THEN
1673: fnd_message.set_name('IGF','IGF_SP_NO_FA_BASE_REC');
1674: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 1685: fnd_message.set_token('PERSON_NUMBER', igf_gr_gen.get_per_num(p_base_id));

1681: FETCH cur_chk_loan INTO chk_loan_rec;
1682: CLOSE cur_chk_loan;
1683: IF chk_loan_rec.loan_id IS NULL THEN
1684: fnd_message.set_name('IGF','IGF_SL_COD_NO_ORIG_REC');
1685: fnd_message.set_token('PERSON_NUMBER', igf_gr_gen.get_per_num(p_base_id));
1686: fnd_file.put_line(fnd_file.log, fnd_message.get);
1687: fnd_file.new_line(fnd_file.log, 1);
1688: RETURN;
1689: END IF;

Line 1718: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(p_base_id));

1714: lb_record_exist := FALSE;
1715:
1716: IF p_base_id IS NOT NULL THEN
1717: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
1718: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(p_base_id));
1719: fnd_file.put_line(fnd_file.log, fnd_message.get);
1720: FOR rec IN cur_pick_loans (lv_cal_type,ln_seq_number,
1721: p_base_id,p_report_id,p_attend_id,
1722: p_fund_id,p_loan_id)

Line 1801: fnd_message.set_token('AWD_YR',igf_gr_gen.get_alt_code(lv_cal_type,ln_seq_number));

1797: END LOOP;
1798: ELSE -- log a message and skip this person, base id not found
1799: fnd_message.set_name('IGF','IGF_GR_LI_PER_INVALID');
1800: fnd_message.set_token('PERSON_NUMBER',lv_person_number);
1801: fnd_message.set_token('AWD_YR',igf_gr_gen.get_alt_code(lv_cal_type,ln_seq_number));
1802: fnd_file.put_line(fnd_file.log,fnd_message.get);
1803: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1804: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug',igf_gr_gen.get_per_num_oss(l_person_id) || ' not in FA');
1805: END IF;

Line 1804: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug',igf_gr_gen.get_per_num_oss(l_person_id) || ' not in FA');

1800: fnd_message.set_token('PERSON_NUMBER',lv_person_number);
1801: fnd_message.set_token('AWD_YR',igf_gr_gen.get_alt_code(lv_cal_type,ln_seq_number));
1802: fnd_file.put_line(fnd_file.log,fnd_message.get);
1803: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1804: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_gen_xml.main.debug',igf_gr_gen.get_per_num_oss(l_person_id) || ' not in FA');
1805: END IF;
1806: END IF; -- base id not found
1807: ELSE
1808: fnd_message.set_name('IGF','IGF_AP_PE_NOT_EXIST');