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_SL_REL_DISB dependencies on FND_LOG

Line 118: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

114: l_min_range := get_range_rec.upper_enr_load_range;
115: CLOSE cur_get_range;
116: END IF;
117:
118: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
119: THEN
120: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.chk_attendance.debug', 'l_min_range='|| l_min_range);
121: END IF;
122:

Line 120: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.chk_attendance.debug', 'l_min_range='|| l_min_range);

116: END IF;
117:
118: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
119: THEN
120: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.chk_attendance.debug', 'l_min_range='|| l_min_range);
121: END IF;
122:
123: BEGIN
124: igs_en_prc_load.enrp_get_inst_latt(

Line 147: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

143: l_key_range := get_range_rec.upper_enr_load_range;
144: CLOSE cur_get_range;
145: END IF;
146:
147: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
148: THEN
149: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.chk_attendance.debug', 'l_key_range='|| l_key_range);
150: END IF;
151:

Line 149: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.chk_attendance.debug', 'l_key_range='|| l_key_range);

145: END IF;
146:
147: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
148: THEN
149: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.chk_attendance.debug', 'l_key_range='|| l_key_range);
150: END IF;
151:
152: IF l_key_range >= l_min_range
153: THEN

Line 504: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level

500: fnd_file.new_line(fnd_file.log, 1);
501: EXCEPTION
502: WHEN OTHERS
503: THEN
504: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level
505: THEN
506: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_rel_dis.log_parameters.exception','Exception:' || SQLERRM);
507: END IF;
508:

Line 506: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_rel_dis.log_parameters.exception','Exception:' || SQLERRM);

502: WHEN OTHERS
503: THEN
504: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level
505: THEN
506: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_rel_dis.log_parameters.exception','Exception:' || SQLERRM);
507: END IF;
508:
509: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
510: fnd_message.set_token('NAME', 'IGF_SL_REL_DISB.LOG_PARAMETERS');

Line 565: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

561: IF cur_get_fund_meth%NOTFOUND
562: THEN
563: CLOSE cur_get_fund_meth;
564:
565: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
566: THEN
567: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.chk_fund_meth_dl.debug','cur_get_fund_meth%NOTFOUND');
568: END IF;
569:

Line 567: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.chk_fund_meth_dl.debug','cur_get_fund_meth%NOTFOUND');

563: CLOSE cur_get_fund_meth;
564:
565: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
566: THEN
567: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.chk_fund_meth_dl.debug','cur_get_fund_meth%NOTFOUND');
568: END IF;
569:
570: RETURN NULL;
571: ELSE

Line 574: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

570: RETURN NULL;
571: ELSE
572: CLOSE cur_get_fund_meth;
573:
574: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
575: THEN
576: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.chk_fund_meth_dl.debug','cur_get_fund_meth%FOUND');
577: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.chk_fund_meth_dl.debug','funding method code = ' || get_fund_meth_rec.funding_method);
578: END IF;

Line 576: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.chk_fund_meth_dl.debug','cur_get_fund_meth%FOUND');

572: CLOSE cur_get_fund_meth;
573:
574: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
575: THEN
576: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.chk_fund_meth_dl.debug','cur_get_fund_meth%FOUND');
577: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.chk_fund_meth_dl.debug','funding method code = ' || get_fund_meth_rec.funding_method);
578: END IF;
579:
580: OPEN cur_get_disb_date(p_award_id, p_disb_num);

Line 577: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.chk_fund_meth_dl.debug','funding method code = ' || get_fund_meth_rec.funding_method);

573:
574: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
575: THEN
576: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.chk_fund_meth_dl.debug','cur_get_fund_meth%FOUND');
577: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.chk_fund_meth_dl.debug','funding method code = ' || get_fund_meth_rec.funding_method);
578: END IF;
579:
580: OPEN cur_get_disb_date(p_award_id, p_disb_num);
581: FETCH cur_get_disb_date INTO get_disb_date_rec;

Line 587: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

583: IF cur_get_disb_date%NOTFOUND
584: THEN
585: CLOSE cur_get_disb_date;
586:
587: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
588: THEN
589: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.chk_fund_meth_dl.debug','cur_get_disb_date%NOTFOUND');
590: END IF;
591:

Line 589: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.chk_fund_meth_dl.debug','cur_get_disb_date%NOTFOUND');

585: CLOSE cur_get_disb_date;
586:
587: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
588: THEN
589: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.chk_fund_meth_dl.debug','cur_get_disb_date%NOTFOUND');
590: END IF;
591:
592: RETURN NULL;
593: ELSE

Line 596: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

592: RETURN NULL;
593: ELSE
594: CLOSE cur_get_disb_date;
595:
596: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
597: THEN
598: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.chk_fund_meth_dl.debug','cur_get_disb_date%FOUND');
599: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.chk_fund_meth_dl.debug','disbursment date =' || get_disb_date_rec.disb_date);
600: END IF;

Line 598: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.chk_fund_meth_dl.debug','cur_get_disb_date%FOUND');

594: CLOSE cur_get_disb_date;
595:
596: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
597: THEN
598: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.chk_fund_meth_dl.debug','cur_get_disb_date%FOUND');
599: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.chk_fund_meth_dl.debug','disbursment date =' || get_disb_date_rec.disb_date);
600: END IF;
601:
602: IF get_fund_meth_rec.funding_method IN ('A', 'P', 'CM1')

Line 599: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.chk_fund_meth_dl.debug','disbursment date =' || get_disb_date_rec.disb_date);

595:
596: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
597: THEN
598: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.chk_fund_meth_dl.debug','cur_get_disb_date%FOUND');
599: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.chk_fund_meth_dl.debug','disbursment date =' || get_disb_date_rec.disb_date);
600: END IF;
601:
602: IF get_fund_meth_rec.funding_method IN ('A', 'P', 'CM1')
603: THEN

Line 685: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

681: cp_base_id => p_base_id, cp_course_cd => l_program_cd,
682: cp_version_number => l_program_version
683: );
684:
685: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
686: THEN
687: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.chk_fund_meth_pell.debug','Key Program > Course cd>' || l_program_cd || ' Version >'|| TO_CHAR(l_program_version));
688: END IF;
689:

Line 687: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.chk_fund_meth_pell.debug','Key Program > Course cd>' || l_program_cd || ' Version >'|| TO_CHAR(l_program_version));

683: );
684:
685: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
686: THEN
687: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.chk_fund_meth_pell.debug','Key Program > Course cd>' || l_program_cd || ' Version >'|| TO_CHAR(l_program_version));
688: END IF;
689:
690: -- Get the Pell Setup
691: igf_gr_pell_calc.get_pell_setup(

Line 1064: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

1060: l_acad_alt_code igs_ca_inst_all.alternate_code%TYPE;
1061: dbpays_rec igf_db_pays_prg_t%ROWTYPE;
1062: l_rowid ROWID;
1063: BEGIN
1064: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1065: THEN
1066: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','p_acad_cal_type:' || p_acad_cal_type);
1067: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','p_acad_ci_seq_num:' || p_acad_ci_seq_num);
1068: END IF;

Line 1066: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','p_acad_cal_type:' || p_acad_cal_type);

1062: l_rowid ROWID;
1063: BEGIN
1064: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1065: THEN
1066: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','p_acad_cal_type:' || p_acad_cal_type);
1067: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','p_acad_ci_seq_num:' || p_acad_ci_seq_num);
1068: END IF;
1069:
1070: FOR get_acad_tp_rec IN cur_get_acad_tp(

Line 1067: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','p_acad_ci_seq_num:' || p_acad_ci_seq_num);

1063: BEGIN
1064: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1065: THEN
1066: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','p_acad_cal_type:' || p_acad_cal_type);
1067: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','p_acad_ci_seq_num:' || p_acad_ci_seq_num);
1068: END IF;
1069:
1070: FOR get_acad_tp_rec IN cur_get_acad_tp(
1071: p_acad_cal_type, p_acad_ci_seq_num

Line 1074: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

1070: FOR get_acad_tp_rec IN cur_get_acad_tp(
1071: p_acad_cal_type, p_acad_ci_seq_num
1072: )
1073: LOOP
1074: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1075: THEN
1076: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','igf_gr_gen.get_person_id(' || p_base_id || '):'|| igf_gr_gen.get_person_id(p_base_id));
1077: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','get_acad_tp_rec.tp_cal_type:' || get_acad_tp_rec.tp_cal_type);
1078: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','get_acad_tp_rec.tp_sequence_number:'|| get_acad_tp_rec.tp_sequence_number);

Line 1076: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','igf_gr_gen.get_person_id(' || p_base_id || '):'|| igf_gr_gen.get_person_id(p_base_id));

1072: )
1073: LOOP
1074: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1075: THEN
1076: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','igf_gr_gen.get_person_id(' || p_base_id || '):'|| igf_gr_gen.get_person_id(p_base_id));
1077: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','get_acad_tp_rec.tp_cal_type:' || get_acad_tp_rec.tp_cal_type);
1078: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','get_acad_tp_rec.tp_sequence_number:'|| get_acad_tp_rec.tp_sequence_number);
1079: END IF;
1080:

Line 1077: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','get_acad_tp_rec.tp_cal_type:' || get_acad_tp_rec.tp_cal_type);

1073: LOOP
1074: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1075: THEN
1076: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','igf_gr_gen.get_person_id(' || p_base_id || '):'|| igf_gr_gen.get_person_id(p_base_id));
1077: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','get_acad_tp_rec.tp_cal_type:' || get_acad_tp_rec.tp_cal_type);
1078: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','get_acad_tp_rec.tp_sequence_number:'|| get_acad_tp_rec.tp_sequence_number);
1079: END IF;
1080:
1081: FOR get_att_rec IN cur_get_att(

Line 1078: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','get_acad_tp_rec.tp_sequence_number:'|| get_acad_tp_rec.tp_sequence_number);

1074: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1075: THEN
1076: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','igf_gr_gen.get_person_id(' || p_base_id || '):'|| igf_gr_gen.get_person_id(p_base_id));
1077: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','get_acad_tp_rec.tp_cal_type:' || get_acad_tp_rec.tp_cal_type);
1078: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','get_acad_tp_rec.tp_sequence_number:'|| get_acad_tp_rec.tp_sequence_number);
1079: END IF;
1080:
1081: FOR get_att_rec IN cur_get_att(
1082: igf_gr_gen.get_person_id(p_base_id),

Line 1093: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

1089: dbpays_rec.prg_ver_num := get_att_rec.prg_ver_num;
1090: dbpays_rec.unit_cd := get_att_rec.unit_course_cd;
1091: dbpays_rec.unit_ver_num := get_att_rec.unit_ver_num;
1092:
1093: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1094: THEN
1095: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','dbpays_rec.program_cd:' || dbpays_rec.program_cd);
1096: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','dbpays_rec.prg_ver_num:' || dbpays_rec.prg_ver_num);
1097: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','dbpays_rec.unit_cd:' || dbpays_rec.unit_cd);

Line 1095: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','dbpays_rec.program_cd:' || dbpays_rec.program_cd);

1091: dbpays_rec.unit_ver_num := get_att_rec.unit_ver_num;
1092:
1093: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1094: THEN
1095: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','dbpays_rec.program_cd:' || dbpays_rec.program_cd);
1096: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','dbpays_rec.prg_ver_num:' || dbpays_rec.prg_ver_num);
1097: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','dbpays_rec.unit_cd:' || dbpays_rec.unit_cd);
1098: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','dbpays_rec.unit_ver_num:' || dbpays_rec.unit_ver_num);
1099: END IF;

Line 1096: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','dbpays_rec.prg_ver_num:' || dbpays_rec.prg_ver_num);

1092:
1093: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1094: THEN
1095: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','dbpays_rec.program_cd:' || dbpays_rec.program_cd);
1096: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','dbpays_rec.prg_ver_num:' || dbpays_rec.prg_ver_num);
1097: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','dbpays_rec.unit_cd:' || dbpays_rec.unit_cd);
1098: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','dbpays_rec.unit_ver_num:' || dbpays_rec.unit_ver_num);
1099: END IF;
1100:

Line 1097: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','dbpays_rec.unit_cd:' || dbpays_rec.unit_cd);

1093: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1094: THEN
1095: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','dbpays_rec.program_cd:' || dbpays_rec.program_cd);
1096: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','dbpays_rec.prg_ver_num:' || dbpays_rec.prg_ver_num);
1097: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','dbpays_rec.unit_cd:' || dbpays_rec.unit_cd);
1098: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','dbpays_rec.unit_ver_num:' || dbpays_rec.unit_ver_num);
1099: END IF;
1100:
1101: l_rowid := NULL;

Line 1098: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','dbpays_rec.unit_ver_num:' || dbpays_rec.unit_ver_num);

1094: THEN
1095: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','dbpays_rec.program_cd:' || dbpays_rec.program_cd);
1096: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','dbpays_rec.prg_ver_num:' || dbpays_rec.prg_ver_num);
1097: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','dbpays_rec.unit_cd:' || dbpays_rec.unit_cd);
1098: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','dbpays_rec.unit_ver_num:' || dbpays_rec.unit_ver_num);
1099: END IF;
1100:
1101: l_rowid := NULL;
1102:

Line 1103: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

1099: END IF;
1100:
1101: l_rowid := NULL;
1102:
1103: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1104: THEN
1105: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','inserting to igf_db_pays_prg_t');
1106: END IF;
1107:

Line 1105: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','inserting to igf_db_pays_prg_t');

1101: l_rowid := NULL;
1102:
1103: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1104: THEN
1105: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.insert_pays_prg_uts.debug','inserting to igf_db_pays_prg_t');
1106: END IF;
1107:
1108: igf_db_pays_prg_t_pkg.insert_row(
1109: x_rowid => l_rowid, x_dbpays_id => dbpays_rec.dbpays_id,

Line 1432: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

1428: FETCH cur_pays_prg INTO pays_prg_rec;
1429: EXIT WHEN cur_pays_prg%NOTFOUND;
1430: igf_db_pays_prg_t_pkg.delete_row(pays_prg_rec.row_id);
1431:
1432: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1433: THEN
1434: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.delete_pays.debug','deleted from igf_db_pays_prg_t');
1435: END IF;
1436: END LOOP;

Line 1434: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.delete_pays.debug','deleted from igf_db_pays_prg_t');

1430: igf_db_pays_prg_t_pkg.delete_row(pays_prg_rec.row_id);
1431:
1432: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1433: THEN
1434: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.delete_pays.debug','deleted from igf_db_pays_prg_t');
1435: END IF;
1436: END LOOP;
1437:
1438: CLOSE cur_pays_prg;

Line 1632: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

1628: get_adisb_rec.hold_rel_ind := 'R';
1629: lv_called_from := 'IGFSL27B';
1630: END IF;
1631:
1632: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1633: THEN
1634: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.set_dri_true .debug','set Disbursment Release Indicator to True');
1635: END IF;
1636:

Line 1634: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.set_dri_true .debug','set Disbursment Release Indicator to True');

1630: END IF;
1631:
1632: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1633: THEN
1634: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.set_dri_true .debug','set Disbursment Release Indicator to True');
1635: END IF;
1636:
1637: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1638: THEN

Line 1637: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

1633: THEN
1634: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.set_dri_true .debug','set Disbursment Release Indicator to True');
1635: END IF;
1636:
1637: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1638: THEN
1639: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.create_actual.debug','updating igf_aw_awd_disb for award ' || get_adisb_rec.award_id);
1640: END IF;
1641:

Line 1639: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.create_actual.debug','updating igf_aw_awd_disb for award ' || get_adisb_rec.award_id);

1635: END IF;
1636:
1637: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1638: THEN
1639: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_db_disb.create_actual.debug','updating igf_aw_awd_disb for award ' || get_adisb_rec.award_id);
1640: END IF;
1641:
1642: igf_aw_awd_disb_pkg.update_row(
1643: x_rowid => get_adisb_rec.row_id,

Line 1935: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

1931: ELSE
1932: l_fund_type := 'X'; -- These fund types are not supported
1933: END IF;
1934:
1935: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1936: THEN
1937: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug', 'fund code ='|| l_fund_type);
1938: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','trans type =' || p_trans_type);
1939: END IF;

Line 1937: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug', 'fund code ='|| l_fund_type);

1933: END IF;
1934:
1935: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1936: THEN
1937: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug', 'fund code ='|| l_fund_type);
1938: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','trans type =' || p_trans_type);
1939: END IF;
1940:
1941: -- Open the cursor according to the fund code and transaction type specified

Line 1938: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','trans type =' || p_trans_type);

1934:
1935: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1936: THEN
1937: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug', 'fund code ='|| l_fund_type);
1938: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','trans type =' || p_trans_type);
1939: END IF;
1940:
1941: -- Open the cursor according to the fund code and transaction type specified
1942: IF l_fund_type IN ('D', 'P')

Line 1986: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

1982: END IF;
1983:
1984: IF NOT (l_record_found)
1985: THEN
1986: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1987: THEN
1988: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','no records found');
1989: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','p_base_id =' || p_base_id);
1990: END IF;

Line 1988: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','no records found');

1984: IF NOT (l_record_found)
1985: THEN
1986: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1987: THEN
1988: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','no records found');
1989: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','p_base_id =' || p_base_id);
1990: END IF;
1991:
1992:

Line 1989: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','p_base_id =' || p_base_id);

1985: THEN
1986: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1987: THEN
1988: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','no records found');
1989: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','p_base_id =' || p_base_id);
1990: END IF;
1991:
1992:
1993: -- No Disbursements found for Student and Fund )

Line 1998: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

1994: fnd_message.set_name('IGF', 'IGF_SL_NO_DISB_TO_REL');
1995: fnd_message.set_token('PER_NUM', igf_gr_gen.get_per_num(p_base_id));
1996: fnd_message.set_token('FDESC', get_fund_desc(p_fund_id));
1997:
1998: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1999: THEN
2000: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','no disbursments availaible for release'|| igf_gr_gen.get_per_num(p_base_id));
2001: END IF;
2002:

Line 2000: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','no disbursments availaible for release'|| igf_gr_gen.get_per_num(p_base_id));

1996: fnd_message.set_token('FDESC', get_fund_desc(p_fund_id));
1997:
1998: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1999: THEN
2000: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','no disbursments availaible for release'|| igf_gr_gen.get_per_num(p_base_id));
2001: END IF;
2002:
2003: p_result := fnd_message.get;
2004: fnd_file.put_line(fnd_file.log, RPAD(' ', 10) || p_result);

Line 2006: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

2002:
2003: p_result := fnd_message.get;
2004: fnd_file.put_line(fnd_file.log, RPAD(' ', 10) || p_result);
2005: ELSE -- record found then
2006: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2007: THEN
2008: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','cur_awd_disb%FOUND');
2009: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','calling delete_pays');
2010: END IF;

Line 2008: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','cur_awd_disb%FOUND');

2004: fnd_file.put_line(fnd_file.log, RPAD(' ', 10) || p_result);
2005: ELSE -- record found then
2006: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2007: THEN
2008: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','cur_awd_disb%FOUND');
2009: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','calling delete_pays');
2010: END IF;
2011:
2012: -- truncate previous records that were used in determining eligibility of the student in the previous run

Line 2009: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','calling delete_pays');

2005: ELSE -- record found then
2006: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2007: THEN
2008: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','cur_awd_disb%FOUND');
2009: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','calling delete_pays');
2010: END IF;
2011:
2012: -- truncate previous records that were used in determining eligibility of the student in the previous run
2013: delete_pays();

Line 2015: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

2011:
2012: -- truncate previous records that were used in determining eligibility of the student in the previous run
2013: delete_pays();
2014:
2015: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2016: THEN
2017: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','called delete_pays');
2018: END IF;
2019:

Line 2017: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','called delete_pays');

2013: delete_pays();
2014:
2015: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2016: THEN
2017: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','called delete_pays');
2018: END IF;
2019:
2020: l_old_fund := -1;
2021: l_new_fund := 0;

Line 2029: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

2025: l_old_ld_seq := -1;
2026: l_new_ld_cal := '0';
2027: l_new_ld_seq := 0;
2028:
2029: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2030: THEN
2031: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','calling get_acad_cal_from_awd with the following info');
2032: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','awd_disb_rec.ci_cal_type:' || awd_disb_rec.ci_cal_type);
2033: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','awd_disb_rec.ci_sequence_number:'|| awd_disb_rec.ci_sequence_number);

Line 2031: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','calling get_acad_cal_from_awd with the following info');

2027: l_new_ld_seq := 0;
2028:
2029: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2030: THEN
2031: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','calling get_acad_cal_from_awd with the following info');
2032: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','awd_disb_rec.ci_cal_type:' || awd_disb_rec.ci_cal_type);
2033: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','awd_disb_rec.ci_sequence_number:'|| awd_disb_rec.ci_sequence_number);
2034: END IF;
2035:

Line 2032: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','awd_disb_rec.ci_cal_type:' || awd_disb_rec.ci_cal_type);

2028:
2029: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2030: THEN
2031: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','calling get_acad_cal_from_awd with the following info');
2032: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','awd_disb_rec.ci_cal_type:' || awd_disb_rec.ci_cal_type);
2033: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','awd_disb_rec.ci_sequence_number:'|| awd_disb_rec.ci_sequence_number);
2034: END IF;
2035:
2036: -- Get Academic Calendar Information

Line 2033: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','awd_disb_rec.ci_sequence_number:'|| awd_disb_rec.ci_sequence_number);

2029: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2030: THEN
2031: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','calling get_acad_cal_from_awd with the following info');
2032: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','awd_disb_rec.ci_cal_type:' || awd_disb_rec.ci_cal_type);
2033: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','awd_disb_rec.ci_sequence_number:'|| awd_disb_rec.ci_sequence_number);
2034: END IF;
2035:
2036: -- Get Academic Calendar Information
2037: igf_ap_oss_integr.get_acad_cal_from_awd(

Line 2042: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

2038: awd_disb_rec.ci_cal_type, awd_disb_rec.ci_sequence_number,
2039: l_acad_cal_type, l_acad_seq_num, l_acad_alt_code
2040: );
2041:
2042: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2043: THEN
2044: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','get_acad_cal_from_awd returned the following info');
2045: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','l_acad_cal_type:'||l_acad_cal_type);
2046: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','l_acad_seq_num:'||l_acad_seq_num);

Line 2044: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','get_acad_cal_from_awd returned the following info');

2040: );
2041:
2042: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2043: THEN
2044: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','get_acad_cal_from_awd returned the following info');
2045: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','l_acad_cal_type:'||l_acad_cal_type);
2046: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','l_acad_seq_num:'||l_acad_seq_num);
2047: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','l_acad_alt_code:'||l_acad_alt_code);
2048: END IF;

Line 2045: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','l_acad_cal_type:'||l_acad_cal_type);

2041:
2042: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2043: THEN
2044: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','get_acad_cal_from_awd returned the following info');
2045: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','l_acad_cal_type:'||l_acad_cal_type);
2046: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','l_acad_seq_num:'||l_acad_seq_num);
2047: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','l_acad_alt_code:'||l_acad_alt_code);
2048: END IF;
2049:

Line 2046: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','l_acad_seq_num:'||l_acad_seq_num);

2042: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2043: THEN
2044: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','get_acad_cal_from_awd returned the following info');
2045: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','l_acad_cal_type:'||l_acad_cal_type);
2046: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','l_acad_seq_num:'||l_acad_seq_num);
2047: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','l_acad_alt_code:'||l_acad_alt_code);
2048: END IF;
2049:
2050:

Line 2047: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','l_acad_alt_code:'||l_acad_alt_code);

2043: THEN
2044: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','get_acad_cal_from_awd returned the following info');
2045: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','l_acad_cal_type:'||l_acad_cal_type);
2046: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','l_acad_seq_num:'||l_acad_seq_num);
2047: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','l_acad_alt_code:'||l_acad_alt_code);
2048: END IF;
2049:
2050:
2051: --

Line 2058: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

2054: -- It may very well happen that there are no Pays only units or programs defined in fund setup
2055: -- Still we need to have the the enrolled programs, unit sets for the student into IGF_DB_PAYS_PRG_T
2056: --
2057:
2058: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2059: THEN
2060: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','calling insert_pays_prg_uts');
2061: END IF;
2062:

Line 2060: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','calling insert_pays_prg_uts');

2056: --
2057:
2058: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2059: THEN
2060: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','calling insert_pays_prg_uts');
2061: END IF;
2062:
2063: insert_pays_prg_uts(awd_disb_rec.base_id, l_acad_cal_type, l_acad_seq_num);
2064:

Line 2065: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

2061: END IF;
2062:
2063: insert_pays_prg_uts(awd_disb_rec.base_id, l_acad_cal_type, l_acad_seq_num);
2064:
2065: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2066: THEN
2067: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','called insert_pays_prg_uts');
2068: END IF;
2069:

Line 2067: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','called insert_pays_prg_uts');

2063: insert_pays_prg_uts(awd_disb_rec.base_id, l_acad_cal_type, l_acad_seq_num);
2064:
2065: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2066: THEN
2067: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','called insert_pays_prg_uts');
2068: END IF;
2069:
2070: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2071: THEN

Line 2070: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

2066: THEN
2067: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','called insert_pays_prg_uts');
2068: END IF;
2069:
2070: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2071: THEN
2072: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','starting processing for ' || igf_gr_gen.get_per_num(p_base_id)|| ' ' || get_fund_desc(awd_disb_rec.fund_id));
2073: END IF;
2074:

Line 2072: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','starting processing for ' || igf_gr_gen.get_per_num(p_base_id)|| ' ' || get_fund_desc(awd_disb_rec.fund_id));

2068: END IF;
2069:
2070: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2071: THEN
2072: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','starting processing for ' || igf_gr_gen.get_per_num(p_base_id)|| ' ' || get_fund_desc(awd_disb_rec.fund_id));
2073: END IF;
2074:
2075: -- FOR all the records IN CUR_AWD_DISB
2076: LOOP

Line 2081: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

2077: BEGIN
2078: -- clear message stack
2079: fnd_message.CLEAR;
2080:
2081: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2082: THEN
2083: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','l_fund_type:' || l_fund_type);
2084: END IF;
2085:

Line 2083: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','l_fund_type:' || l_fund_type);

2079: fnd_message.CLEAR;
2080:
2081: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2082: THEN
2083: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','l_fund_type:' || l_fund_type);
2084: END IF;
2085:
2086: l_old_fund := l_new_fund;
2087: l_new_fund := awd_disb_rec.fund_id;

Line 2109: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

2105: fnd_message.set_token('DISB_NUM', TO_CHAR(awd_disb_rec.disb_num));
2106: fnd_file.put_line(fnd_file.log, RPAD(' ', 15) || fnd_message.get);
2107: fnd_file.new_line(fnd_file.log, 1);
2108:
2109: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2110: THEN
2111: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','awd_disb_rec.award_id:' || awd_disb_rec.award_id);
2112: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','awd_disb_rec.disb_num:' || awd_disb_rec.disb_num);
2113: END IF;

Line 2111: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','awd_disb_rec.award_id:' || awd_disb_rec.award_id);

2107: fnd_file.new_line(fnd_file.log, 1);
2108:
2109: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2110: THEN
2111: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','awd_disb_rec.award_id:' || awd_disb_rec.award_id);
2112: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','awd_disb_rec.disb_num:' || awd_disb_rec.disb_num);
2113: END IF;
2114:
2115: -- Validations

Line 2112: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','awd_disb_rec.disb_num:' || awd_disb_rec.disb_num);

2108:
2109: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2110: THEN
2111: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','awd_disb_rec.award_id:' || awd_disb_rec.award_id);
2112: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','awd_disb_rec.disb_num:' || awd_disb_rec.disb_num);
2113: END IF;
2114:
2115: -- Validations
2116: --

Line 2126: IF fnd_log.level_statement >=fnd_log.g_current_runtime_level

2122: -- 5. Eligibility check for getting PELL Grant (PELL_ELIGIBLE)
2123: --
2124: IF l_old_fund <> l_new_fund
2125: THEN
2126: IF fnd_log.level_statement >=fnd_log.g_current_runtime_level
2127: THEN
2128: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','processing in award year context '|| igf_gr_gen.get_per_num(p_base_id) || ' '|| get_fund_desc(awd_disb_rec.fund_id));
2129: END IF;
2130:

Line 2128: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','processing in award year context '|| igf_gr_gen.get_per_num(p_base_id) || ' '|| get_fund_desc(awd_disb_rec.fund_id));

2124: IF l_old_fund <> l_new_fund
2125: THEN
2126: IF fnd_log.level_statement >=fnd_log.g_current_runtime_level
2127: THEN
2128: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','processing in award year context '|| igf_gr_gen.get_per_num(p_base_id) || ' '|| get_fund_desc(awd_disb_rec.fund_id));
2129: END IF;
2130:
2131: -- For each new fund that is visible within this scope,
2132: -- the result variables are initialized

Line 2219: IF fnd_log.level_statement >=fnd_log.g_current_runtime_level

2215: p_result := fnd_message.get;
2216: fnd_file.put_line(fnd_file.log, RPAD(' ', 17) || p_result);
2217: END IF;
2218:
2219: IF fnd_log.level_statement >=fnd_log.g_current_runtime_level
2220: THEN
2221: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','fund level validation results');
2222: IF NOT l_ac_hold_result THEN
2223: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','disbursment hold exist');

Line 2221: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','fund level validation results');

2217: END IF;
2218:
2219: IF fnd_log.level_statement >=fnd_log.g_current_runtime_level
2220: THEN
2221: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','fund level validation results');
2222: IF NOT l_ac_hold_result THEN
2223: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','disbursment hold exist');
2224: ELSE
2225: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','disbursment hold do not exist');

Line 2223: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','disbursment hold exist');

2219: IF fnd_log.level_statement >=fnd_log.g_current_runtime_level
2220: THEN
2221: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','fund level validation results');
2222: IF NOT l_ac_hold_result THEN
2223: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','disbursment hold exist');
2224: ELSE
2225: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','disbursment hold do not exist');
2226: END IF;
2227:

Line 2225: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','disbursment hold do not exist');

2221: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','fund level validation results');
2222: IF NOT l_ac_hold_result THEN
2223: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','disbursment hold exist');
2224: ELSE
2225: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','disbursment hold do not exist');
2226: END IF;
2227:
2228: IF NOT l_todo_result THEN
2229: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','failed to do items check');

Line 2229: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','failed to do items check');

2225: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','disbursment hold do not exist');
2226: END IF;
2227:
2228: IF NOT l_todo_result THEN
2229: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','failed to do items check');
2230: ELSE
2231: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','passed to do items check');
2232: END IF;
2233:

Line 2231: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','passed to do items check');

2227:
2228: IF NOT l_todo_result THEN
2229: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','failed to do items check');
2230: ELSE
2231: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','passed to do items check');
2232: END IF;
2233:
2234: IF NOT l_pays_prg THEN
2235: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','failed pays only prog check');

Line 2235: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','failed pays only prog check');

2231: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','passed to do items check');
2232: END IF;
2233:
2234: IF NOT l_pays_prg THEN
2235: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','failed pays only prog check');
2236: ELSE
2237: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','passed pays only prog check');
2238: END IF;
2239:

Line 2237: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','passed pays only prog check');

2233:
2234: IF NOT l_pays_prg THEN
2235: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','failed pays only prog check');
2236: ELSE
2237: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','passed pays only prog check');
2238: END IF;
2239:
2240: IF NOT l_pays_uts THEN
2241: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','failed pays only units check');

Line 2241: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','failed pays only units check');

2237: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','passed pays only prog check');
2238: END IF;
2239:
2240: IF NOT l_pays_uts THEN
2241: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','failed pays only units check');
2242: ELSE
2243: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','passed pays only units check');
2244: END IF;
2245:

Line 2243: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','passed pays only units check');

2239:
2240: IF NOT l_pays_uts THEN
2241: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','failed pays only units check');
2242: ELSE
2243: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','passed pays only units check');
2244: END IF;
2245:
2246: IF NOT l_elig_result THEN
2247:

Line 2249: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','failed pell eligibilty check');

2245:
2246: IF NOT l_elig_result THEN
2247:
2248: IF l_fund_type = 'P' THEN
2249: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','failed pell eligibilty check');
2250: ELSE
2251: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student..debug','passed pell eligibilty check');
2252: END IF;
2253:

Line 2251: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student..debug','passed pell eligibilty check');

2247:
2248: IF l_fund_type = 'P' THEN
2249: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','failed pell eligibilty check');
2250: ELSE
2251: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student..debug','passed pell eligibilty check');
2252: END IF;
2253:
2254: IF l_fund_type ='D' THEN
2255: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','failed NSLDS eligibilty check');

Line 2255: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','failed NSLDS eligibilty check');

2251: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student..debug','passed pell eligibilty check');
2252: END IF;
2253:
2254: IF l_fund_type ='D' THEN
2255: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','failed NSLDS eligibilty check');
2256: ELSE
2257: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','passed NSLDS eligibilty check');
2258: END IF;
2259: END IF; -- Pell Elig

Line 2257: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','passed NSLDS eligibilty check');

2253:
2254: IF l_fund_type ='D' THEN
2255: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','failed NSLDS eligibilty check');
2256: ELSE
2257: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','passed NSLDS eligibilty check');
2258: END IF;
2259: END IF; -- Pell Elig
2260: END IF; -- FND Log End If
2261: END IF; -- old fund id not new fund

Line 2260: END IF; -- FND Log End If

2256: ELSE
2257: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','passed NSLDS eligibilty check');
2258: END IF;
2259: END IF; -- Pell Elig
2260: END IF; -- FND Log End If
2261: END IF; -- old fund id not new fund
2262: --
2263: -- Validations
2264: -- Checks that should be done at Award Level

Line 2276: IF fnd_log.level_statement >=

2272: -- For each new fund that is visible within this scope,
2273: -- the result variables are initialized
2274: l_active_result := TRUE;
2275:
2276: IF fnd_log.level_statement >=
2277: fnd_log.g_current_runtime_level
2278: THEN
2279: fnd_log.string(
2280: fnd_log.level_statement,

Line 2277: fnd_log.g_current_runtime_level

2273: -- the result variables are initialized
2274: l_active_result := TRUE;
2275:
2276: IF fnd_log.level_statement >=
2277: fnd_log.g_current_runtime_level
2278: THEN
2279: fnd_log.string(
2280: fnd_log.level_statement,
2281: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

Line 2279: fnd_log.string(

2275:
2276: IF fnd_log.level_statement >=
2277: fnd_log.g_current_runtime_level
2278: THEN
2279: fnd_log.string(
2280: fnd_log.level_statement,
2281: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2282: 'performing awd level validations'
2283: );

Line 2280: fnd_log.level_statement,

2276: IF fnd_log.level_statement >=
2277: fnd_log.g_current_runtime_level
2278: THEN
2279: fnd_log.string(
2280: fnd_log.level_statement,
2281: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2282: 'performing awd level validations'
2283: );
2284: END IF;

Line 2303: IF fnd_log.level_statement >=

2299: fnd_file.log, RPAD(' ', 17) || p_result
2300: );
2301:
2302: -- message ' Loan Not created for this award '
2303: IF fnd_log.level_statement >=
2304: fnd_log.g_current_runtime_level
2305: THEN
2306: fnd_log.string(
2307: fnd_log.level_statement,

Line 2304: fnd_log.g_current_runtime_level

2300: );
2301:
2302: -- message ' Loan Not created for this award '
2303: IF fnd_log.level_statement >=
2304: fnd_log.g_current_runtime_level
2305: THEN
2306: fnd_log.string(
2307: fnd_log.level_statement,
2308: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

Line 2306: fnd_log.string(

2302: -- message ' Loan Not created for this award '
2303: IF fnd_log.level_statement >=
2304: fnd_log.g_current_runtime_level
2305: THEN
2306: fnd_log.string(
2307: fnd_log.level_statement,
2308: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2309: 'cur_get_loans%NOTFOUND'
2310: );

Line 2307: fnd_log.level_statement,

2303: IF fnd_log.level_statement >=
2304: fnd_log.g_current_runtime_level
2305: THEN
2306: fnd_log.string(
2307: fnd_log.level_statement,
2308: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2309: 'cur_get_loans%NOTFOUND'
2310: );
2311: END IF;

Line 2328: IF fnd_log.level_statement >=

2324: fnd_file.log, RPAD(' ', 17) || p_result
2325: );
2326: l_active_result := FALSE;
2327:
2328: IF fnd_log.level_statement >=
2329: fnd_log.g_current_runtime_level
2330: THEN
2331: fnd_log.string(
2332: fnd_log.level_statement,

Line 2329: fnd_log.g_current_runtime_level

2325: );
2326: l_active_result := FALSE;
2327:
2328: IF fnd_log.level_statement >=
2329: fnd_log.g_current_runtime_level
2330: THEN
2331: fnd_log.string(
2332: fnd_log.level_statement,
2333: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

Line 2331: fnd_log.string(

2327:
2328: IF fnd_log.level_statement >=
2329: fnd_log.g_current_runtime_level
2330: THEN
2331: fnd_log.string(
2332: fnd_log.level_statement,
2333: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2334: 'loan ' || get_loans_rec.loan_number
2335: || ' is inactive'

Line 2332: fnd_log.level_statement,

2328: IF fnd_log.level_statement >=
2329: fnd_log.g_current_runtime_level
2330: THEN
2331: fnd_log.string(
2332: fnd_log.level_statement,
2333: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2334: 'loan ' || get_loans_rec.loan_number
2335: || ' is inactive'
2336: );

Line 2349: IF fnd_log.level_statement >=fnd_log.g_current_runtime_level THEN

2345: p_result := fnd_message.get;
2346: fnd_file.put_line(fnd_file.log, RPAD(' ', 17) || p_result);
2347: l_active_result := FALSE;
2348:
2349: IF fnd_log.level_statement >=fnd_log.g_current_runtime_level THEN
2350: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','loan ' || get_loans_rec.loan_number
2351: || ' is sent'
2352: );
2353: END IF;

Line 2350: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','loan ' || get_loans_rec.loan_number

2346: fnd_file.put_line(fnd_file.log, RPAD(' ', 17) || p_result);
2347: l_active_result := FALSE;
2348:
2349: IF fnd_log.level_statement >=fnd_log.g_current_runtime_level THEN
2350: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug','loan ' || get_loans_rec.loan_number
2351: || ' is sent'
2352: );
2353: END IF;
2354: END IF;

Line 2369: IF fnd_log.level_statement >=

2365: fnd_file.log, RPAD(' ', 17) || p_result
2366: );
2367: l_active_result := FALSE;
2368:
2369: IF fnd_log.level_statement >=
2370: fnd_log.g_current_runtime_level
2371: THEN
2372: fnd_log.string(
2373: fnd_log.level_statement,

Line 2370: fnd_log.g_current_runtime_level

2366: );
2367: l_active_result := FALSE;
2368:
2369: IF fnd_log.level_statement >=
2370: fnd_log.g_current_runtime_level
2371: THEN
2372: fnd_log.string(
2373: fnd_log.level_statement,
2374: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

Line 2372: fnd_log.string(

2368:
2369: IF fnd_log.level_statement >=
2370: fnd_log.g_current_runtime_level
2371: THEN
2372: fnd_log.string(
2373: fnd_log.level_statement,
2374: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2375: 'loan ' || get_loans_rec.loan_number
2376: || ' is rejected'

Line 2373: fnd_log.level_statement,

2369: IF fnd_log.level_statement >=
2370: fnd_log.g_current_runtime_level
2371: THEN
2372: fnd_log.string(
2373: fnd_log.level_statement,
2374: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2375: 'loan ' || get_loans_rec.loan_number
2376: || ' is rejected'
2377: );

Line 2389: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

2385: fnd_message.set_token('LOAN_NUMBER', get_loans_rec.loan_number);
2386: p_result := fnd_message.get;
2387: fnd_file.put_line(fnd_file.log, RPAD(' ', 17) || p_result);
2388: l_active_result := FALSE;
2389: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2390: THEN fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug',
2391: 'loan ' || get_loans_rec.loan_number || ' is not release-4');
2392: END IF;
2393: END IF; -- release 4

Line 2390: THEN fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug',

2386: p_result := fnd_message.get;
2387: fnd_file.put_line(fnd_file.log, RPAD(' ', 17) || p_result);
2388: l_active_result := FALSE;
2389: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2390: THEN fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_rel_disb.process_student.debug',
2391: 'loan ' || get_loans_rec.loan_number || ' is not release-4');
2392: END IF;
2393: END IF; -- release 4
2394: END IF; -- loan status 'A'

Line 2399: IF fnd_log.level_statement >=

2395: END IF; --fund type 'F'
2396: END IF; -- ( cur_get_loans%NOTFOUND)
2397: END IF; -- fund = 'D', 'F'
2398:
2399: IF fnd_log.level_statement >=
2400: fnd_log.g_current_runtime_level
2401: THEN
2402: IF NOT l_active_result
2403: THEN

Line 2400: fnd_log.g_current_runtime_level

2396: END IF; -- ( cur_get_loans%NOTFOUND)
2397: END IF; -- fund = 'D', 'F'
2398:
2399: IF fnd_log.level_statement >=
2400: fnd_log.g_current_runtime_level
2401: THEN
2402: IF NOT l_active_result
2403: THEN
2404: fnd_log.string(

Line 2404: fnd_log.string(

2400: fnd_log.g_current_runtime_level
2401: THEN
2402: IF NOT l_active_result
2403: THEN
2404: fnd_log.string(
2405: fnd_log.level_statement,
2406: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2407: 'loan not active'
2408: );

Line 2405: fnd_log.level_statement,

2401: THEN
2402: IF NOT l_active_result
2403: THEN
2404: fnd_log.string(
2405: fnd_log.level_statement,
2406: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2407: 'loan not active'
2408: );
2409: ELSE

Line 2410: fnd_log.string(

2406: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2407: 'loan not active'
2408: );
2409: ELSE
2410: fnd_log.string(
2411: fnd_log.level_statement,
2412: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2413: 'loan active'
2414: );

Line 2411: fnd_log.level_statement,

2407: 'loan not active'
2408: );
2409: ELSE
2410: fnd_log.string(
2411: fnd_log.level_statement,
2412: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2413: 'loan active'
2414: );
2415: END IF;

Line 2438: IF fnd_log.level_statement >=

2434: fnd_file.put_line(
2435: fnd_file.log, RPAD(' ', 17) || p_result
2436: );
2437:
2438: IF fnd_log.level_statement >=
2439: fnd_log.g_current_runtime_level
2440: THEN
2441: fnd_log.string(
2442: fnd_log.level_statement,

Line 2439: fnd_log.g_current_runtime_level

2435: fnd_file.log, RPAD(' ', 17) || p_result
2436: );
2437:
2438: IF fnd_log.level_statement >=
2439: fnd_log.g_current_runtime_level
2440: THEN
2441: fnd_log.string(
2442: fnd_log.level_statement,
2443: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

Line 2441: fnd_log.string(

2437:
2438: IF fnd_log.level_statement >=
2439: fnd_log.g_current_runtime_level
2440: THEN
2441: fnd_log.string(
2442: fnd_log.level_statement,
2443: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2444: 'credit status check failed'
2445: );

Line 2442: fnd_log.level_statement,

2438: IF fnd_log.level_statement >=
2439: fnd_log.g_current_runtime_level
2440: THEN
2441: fnd_log.string(
2442: fnd_log.level_statement,
2443: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2444: 'credit status check failed'
2445: );
2446: END IF;

Line 2448: IF fnd_log.level_statement >=

2444: 'credit status check failed'
2445: );
2446: END IF;
2447: ELSE
2448: IF fnd_log.level_statement >=
2449: fnd_log.g_current_runtime_level
2450: THEN
2451: fnd_log.string(
2452: fnd_log.level_statement,

Line 2449: fnd_log.g_current_runtime_level

2445: );
2446: END IF;
2447: ELSE
2448: IF fnd_log.level_statement >=
2449: fnd_log.g_current_runtime_level
2450: THEN
2451: fnd_log.string(
2452: fnd_log.level_statement,
2453: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

Line 2451: fnd_log.string(

2447: ELSE
2448: IF fnd_log.level_statement >=
2449: fnd_log.g_current_runtime_level
2450: THEN
2451: fnd_log.string(
2452: fnd_log.level_statement,
2453: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2454: 'credit status check passed'
2455: );

Line 2452: fnd_log.level_statement,

2448: IF fnd_log.level_statement >=
2449: fnd_log.g_current_runtime_level
2450: THEN
2451: fnd_log.string(
2452: fnd_log.level_statement,
2453: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2454: 'credit status check passed'
2455: );
2456: END IF;

Line 2478: IF fnd_log.level_statement >=

2474: fnd_file.log, RPAD(' ', 17) || p_result
2475: );
2476: l_active_result := FALSE;
2477:
2478: IF fnd_log.level_statement >=
2479: fnd_log.g_current_runtime_level
2480: THEN
2481: fnd_log.string(
2482: fnd_log.level_statement,

Line 2479: fnd_log.g_current_runtime_level

2475: );
2476: l_active_result := FALSE;
2477:
2478: IF fnd_log.level_statement >=
2479: fnd_log.g_current_runtime_level
2480: THEN
2481: fnd_log.string(
2482: fnd_log.level_statement,
2483: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

Line 2481: fnd_log.string(

2477:
2478: IF fnd_log.level_statement >=
2479: fnd_log.g_current_runtime_level
2480: THEN
2481: fnd_log.string(
2482: fnd_log.level_statement,
2483: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2484: 'pell ' || get_pell_rec.origination_id
2485: || ' is in sent'

Line 2482: fnd_log.level_statement,

2478: IF fnd_log.level_statement >=
2479: fnd_log.g_current_runtime_level
2480: THEN
2481: fnd_log.string(
2482: fnd_log.level_statement,
2483: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2484: 'pell ' || get_pell_rec.origination_id
2485: || ' is in sent'
2486: );

Line 2502: IF fnd_log.level_statement >=

2498: fnd_file.log, RPAD(' ', 17) || p_result
2499: );
2500: l_active_result := FALSE;
2501:
2502: IF fnd_log.level_statement >=
2503: fnd_log.g_current_runtime_level
2504: THEN
2505: fnd_log.string(
2506: fnd_log.level_statement,

Line 2503: fnd_log.g_current_runtime_level

2499: );
2500: l_active_result := FALSE;
2501:
2502: IF fnd_log.level_statement >=
2503: fnd_log.g_current_runtime_level
2504: THEN
2505: fnd_log.string(
2506: fnd_log.level_statement,
2507: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

Line 2505: fnd_log.string(

2501:
2502: IF fnd_log.level_statement >=
2503: fnd_log.g_current_runtime_level
2504: THEN
2505: fnd_log.string(
2506: fnd_log.level_statement,
2507: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2508: 'pell ' || get_pell_rec.origination_id
2509: || ' is in Rejected'

Line 2506: fnd_log.level_statement,

2502: IF fnd_log.level_statement >=
2503: fnd_log.g_current_runtime_level
2504: THEN
2505: fnd_log.string(
2506: fnd_log.level_statement,
2507: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2508: 'pell ' || get_pell_rec.origination_id
2509: || ' is in Rejected'
2510: );

Line 2539: IF fnd_log.level_statement >=

2535: THEN
2536: l_fclass_result := TRUE;
2537: l_sys_hold_result := TRUE;
2538:
2539: IF fnd_log.level_statement >=
2540: fnd_log.g_current_runtime_level
2541: THEN
2542: fnd_log.string(
2543: fnd_log.level_statement,

Line 2540: fnd_log.g_current_runtime_level

2536: l_fclass_result := TRUE;
2537: l_sys_hold_result := TRUE;
2538:
2539: IF fnd_log.level_statement >=
2540: fnd_log.g_current_runtime_level
2541: THEN
2542: fnd_log.string(
2543: fnd_log.level_statement,
2544: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

Line 2542: fnd_log.string(

2538:
2539: IF fnd_log.level_statement >=
2540: fnd_log.g_current_runtime_level
2541: THEN
2542: fnd_log.string(
2543: fnd_log.level_statement,
2544: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2545: 'pays only fee class check'
2546: );

Line 2543: fnd_log.level_statement,

2539: IF fnd_log.level_statement >=
2540: fnd_log.g_current_runtime_level
2541: THEN
2542: fnd_log.string(
2543: fnd_log.level_statement,
2544: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2545: 'pays only fee class check'
2546: );
2547: fnd_log.string(

Line 2547: fnd_log.string(

2543: fnd_log.level_statement,
2544: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2545: 'pays only fee class check'
2546: );
2547: fnd_log.string(
2548: fnd_log.level_statement,
2549: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2550: 'fund_id' || awd_disb_rec.fund_id
2551: );

Line 2548: fnd_log.level_statement,

2544: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2545: 'pays only fee class check'
2546: );
2547: fnd_log.string(
2548: fnd_log.level_statement,
2549: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2550: 'fund_id' || awd_disb_rec.fund_id
2551: );
2552: fnd_log.string(

Line 2552: fnd_log.string(

2548: fnd_log.level_statement,
2549: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2550: 'fund_id' || awd_disb_rec.fund_id
2551: );
2552: fnd_log.string(
2553: fnd_log.level_statement,
2554: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2555: 'ld_cal_type' || awd_disb_rec.ld_cal_type
2556: );

Line 2553: fnd_log.level_statement,

2549: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2550: 'fund_id' || awd_disb_rec.fund_id
2551: );
2552: fnd_log.string(
2553: fnd_log.level_statement,
2554: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2555: 'ld_cal_type' || awd_disb_rec.ld_cal_type
2556: );
2557: fnd_log.string(

Line 2557: fnd_log.string(

2553: fnd_log.level_statement,
2554: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2555: 'ld_cal_type' || awd_disb_rec.ld_cal_type
2556: );
2557: fnd_log.string(
2558: fnd_log.level_statement,
2559: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2560: 'ld_sequence_number'
2561: || awd_disb_rec.ld_sequence_number

Line 2558: fnd_log.level_statement,

2554: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2555: 'ld_cal_type' || awd_disb_rec.ld_cal_type
2556: );
2557: fnd_log.string(
2558: fnd_log.level_statement,
2559: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2560: 'ld_sequence_number'
2561: || awd_disb_rec.ld_sequence_number
2562: );

Line 2603: IF fnd_log.level_statement >=

2599: fnd_file.log, RPAD(' ', 17) || p_result
2600: );
2601: END IF;
2602:
2603: IF fnd_log.level_statement >=
2604: fnd_log.g_current_runtime_level
2605: THEN
2606: IF NOT l_fclass_result
2607: THEN

Line 2604: fnd_log.g_current_runtime_level

2600: );
2601: END IF;
2602:
2603: IF fnd_log.level_statement >=
2604: fnd_log.g_current_runtime_level
2605: THEN
2606: IF NOT l_fclass_result
2607: THEN
2608: fnd_log.string(

Line 2608: fnd_log.string(

2604: fnd_log.g_current_runtime_level
2605: THEN
2606: IF NOT l_fclass_result
2607: THEN
2608: fnd_log.string(
2609: fnd_log.level_statement,
2610: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2611: 'failed pays only fees class check'
2612: );

Line 2609: fnd_log.level_statement,

2605: THEN
2606: IF NOT l_fclass_result
2607: THEN
2608: fnd_log.string(
2609: fnd_log.level_statement,
2610: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2611: 'failed pays only fees class check'
2612: );
2613: ELSE

Line 2614: fnd_log.string(

2610: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2611: 'failed pays only fees class check'
2612: );
2613: ELSE
2614: fnd_log.string(
2615: fnd_log.level_statement,
2616: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2617: 'passed pays only fees class check'
2618: );

Line 2615: fnd_log.level_statement,

2611: 'failed pays only fees class check'
2612: );
2613: ELSE
2614: fnd_log.string(
2615: fnd_log.level_statement,
2616: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2617: 'passed pays only fees class check'
2618: );
2619: END IF;

Line 2623: fnd_log.string(

2619: END IF;
2620:
2621: IF NOT l_sys_hold_result
2622: THEN
2623: fnd_log.string(
2624: fnd_log.level_statement,
2625: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2626: 'system hold exsist on the disbursment'
2627: );

Line 2624: fnd_log.level_statement,

2620:
2621: IF NOT l_sys_hold_result
2622: THEN
2623: fnd_log.string(
2624: fnd_log.level_statement,
2625: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2626: 'system hold exsist on the disbursment'
2627: );
2628: ELSE

Line 2629: fnd_log.string(

2625: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2626: 'system hold exsist on the disbursment'
2627: );
2628: ELSE
2629: fnd_log.string(
2630: fnd_log.level_statement,
2631: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2632: 'system hold do not exsist on the disbursment'
2633: );

Line 2630: fnd_log.level_statement,

2626: 'system hold exsist on the disbursment'
2627: );
2628: ELSE
2629: fnd_log.string(
2630: fnd_log.level_statement,
2631: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2632: 'system hold do not exsist on the disbursment'
2633: );
2634: END IF;

Line 2651: IF fnd_log.level_statement >=

2647: l_crdt_pt_result := TRUE;
2648:
2649: IF awd_disb_rec.min_credit_pts IS NOT NULL
2650: THEN
2651: IF fnd_log.level_statement >=
2652: fnd_log.g_current_runtime_level
2653: THEN
2654: fnd_log.string(
2655: fnd_log.level_statement,

Line 2652: fnd_log.g_current_runtime_level

2648:
2649: IF awd_disb_rec.min_credit_pts IS NOT NULL
2650: THEN
2651: IF fnd_log.level_statement >=
2652: fnd_log.g_current_runtime_level
2653: THEN
2654: fnd_log.string(
2655: fnd_log.level_statement,
2656: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

Line 2654: fnd_log.string(

2650: THEN
2651: IF fnd_log.level_statement >=
2652: fnd_log.g_current_runtime_level
2653: THEN
2654: fnd_log.string(
2655: fnd_log.level_statement,
2656: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2657: 'awd_disb_rec.min_credit_pts:'
2658: || awd_disb_rec.min_credit_pts

Line 2655: fnd_log.level_statement,

2651: IF fnd_log.level_statement >=
2652: fnd_log.g_current_runtime_level
2653: THEN
2654: fnd_log.string(
2655: fnd_log.level_statement,
2656: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2657: 'awd_disb_rec.min_credit_pts:'
2658: || awd_disb_rec.min_credit_pts
2659: );

Line 2671: IF fnd_log.level_statement >=

2667: awd_disb_rec.disb_date
2668: ), l_credit_pts
2669: );
2670:
2671: IF fnd_log.level_statement >=
2672: fnd_log.g_current_runtime_level
2673: THEN
2674: fnd_log.string(
2675: fnd_log.level_statement,

Line 2672: fnd_log.g_current_runtime_level

2668: ), l_credit_pts
2669: );
2670:
2671: IF fnd_log.level_statement >=
2672: fnd_log.g_current_runtime_level
2673: THEN
2674: fnd_log.string(
2675: fnd_log.level_statement,
2676: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

Line 2674: fnd_log.string(

2670:
2671: IF fnd_log.level_statement >=
2672: fnd_log.g_current_runtime_level
2673: THEN
2674: fnd_log.string(
2675: fnd_log.level_statement,
2676: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2677: 'l_credit_pts:' || l_credit_pts
2678: );

Line 2675: fnd_log.level_statement,

2671: IF fnd_log.level_statement >=
2672: fnd_log.g_current_runtime_level
2673: THEN
2674: fnd_log.string(
2675: fnd_log.level_statement,
2676: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2677: 'l_credit_pts:' || l_credit_pts
2678: );
2679: END IF;

Line 2691: IF fnd_log.level_statement >=

2687: fnd_file.put_line(
2688: fnd_file.log, RPAD(' ', 17) || p_result
2689: );
2690:
2691: IF fnd_log.level_statement >=
2692: fnd_log.g_current_runtime_level
2693: THEN
2694: fnd_log.string(
2695: fnd_log.level_statement,

Line 2692: fnd_log.g_current_runtime_level

2688: fnd_file.log, RPAD(' ', 17) || p_result
2689: );
2690:
2691: IF fnd_log.level_statement >=
2692: fnd_log.g_current_runtime_level
2693: THEN
2694: fnd_log.string(
2695: fnd_log.level_statement,
2696: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

Line 2694: fnd_log.string(

2690:
2691: IF fnd_log.level_statement >=
2692: fnd_log.g_current_runtime_level
2693: THEN
2694: fnd_log.string(
2695: fnd_log.level_statement,
2696: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2697: 'min credit check failed'
2698: );

Line 2695: fnd_log.level_statement,

2691: IF fnd_log.level_statement >=
2692: fnd_log.g_current_runtime_level
2693: THEN
2694: fnd_log.string(
2695: fnd_log.level_statement,
2696: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2697: 'min credit check failed'
2698: );
2699: END IF;

Line 2701: IF fnd_log.level_statement >=

2697: 'min credit check failed'
2698: );
2699: END IF;
2700: ELSE
2701: IF fnd_log.level_statement >=
2702: fnd_log.g_current_runtime_level
2703: THEN
2704: fnd_log.string(
2705: fnd_log.level_statement,

Line 2702: fnd_log.g_current_runtime_level

2698: );
2699: END IF;
2700: ELSE
2701: IF fnd_log.level_statement >=
2702: fnd_log.g_current_runtime_level
2703: THEN
2704: fnd_log.string(
2705: fnd_log.level_statement,
2706: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

Line 2704: fnd_log.string(

2700: ELSE
2701: IF fnd_log.level_statement >=
2702: fnd_log.g_current_runtime_level
2703: THEN
2704: fnd_log.string(
2705: fnd_log.level_statement,
2706: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2707: 'min credit check passed'
2708: );

Line 2705: fnd_log.level_statement,

2701: IF fnd_log.level_statement >=
2702: fnd_log.g_current_runtime_level
2703: THEN
2704: fnd_log.string(
2705: fnd_log.level_statement,
2706: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2707: 'min credit check passed'
2708: );
2709: END IF;

Line 2712: IF fnd_log.level_statement >=

2708: );
2709: END IF;
2710: END IF;
2711: ELSE -- (awd_disb_rec.min_credit_pts IS NOT NULL)
2712: IF fnd_log.level_statement >=
2713: fnd_log.g_current_runtime_level
2714: THEN
2715: fnd_log.string(
2716: fnd_log.level_statement,

Line 2713: fnd_log.g_current_runtime_level

2709: END IF;
2710: END IF;
2711: ELSE -- (awd_disb_rec.min_credit_pts IS NOT NULL)
2712: IF fnd_log.level_statement >=
2713: fnd_log.g_current_runtime_level
2714: THEN
2715: fnd_log.string(
2716: fnd_log.level_statement,
2717: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

Line 2715: fnd_log.string(

2711: ELSE -- (awd_disb_rec.min_credit_pts IS NOT NULL)
2712: IF fnd_log.level_statement >=
2713: fnd_log.g_current_runtime_level
2714: THEN
2715: fnd_log.string(
2716: fnd_log.level_statement,
2717: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2718: 'awd_disb_rec.min_credit_pts is NULL'
2719: );

Line 2716: fnd_log.level_statement,

2712: IF fnd_log.level_statement >=
2713: fnd_log.g_current_runtime_level
2714: THEN
2715: fnd_log.string(
2716: fnd_log.level_statement,
2717: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2718: 'awd_disb_rec.min_credit_pts is NULL'
2719: );
2720: END IF;

Line 2728: IF fnd_log.level_statement >=

2724: l_att_result := TRUE;
2725:
2726: IF awd_disb_rec.attendance_type_code IS NOT NULL
2727: THEN
2728: IF fnd_log.level_statement >=
2729: fnd_log.g_current_runtime_level
2730: THEN
2731: fnd_log.string(
2732: fnd_log.level_statement,

Line 2729: fnd_log.g_current_runtime_level

2725:
2726: IF awd_disb_rec.attendance_type_code IS NOT NULL
2727: THEN
2728: IF fnd_log.level_statement >=
2729: fnd_log.g_current_runtime_level
2730: THEN
2731: fnd_log.string(
2732: fnd_log.level_statement,
2733: 'igf.plsql.igf_db_disb.process_student.debug',

Line 2731: fnd_log.string(

2727: THEN
2728: IF fnd_log.level_statement >=
2729: fnd_log.g_current_runtime_level
2730: THEN
2731: fnd_log.string(
2732: fnd_log.level_statement,
2733: 'igf.plsql.igf_db_disb.process_student.debug',
2734: 'awd_disb_rec.attendance_type_code:'
2735: || awd_disb_rec.attendance_type_code

Line 2732: fnd_log.level_statement,

2728: IF fnd_log.level_statement >=
2729: fnd_log.g_current_runtime_level
2730: THEN
2731: fnd_log.string(
2732: fnd_log.level_statement,
2733: 'igf.plsql.igf_db_disb.process_student.debug',
2734: 'awd_disb_rec.attendance_type_code:'
2735: || awd_disb_rec.attendance_type_code
2736: );

Line 2757: IF fnd_log.level_statement >=

2753: p_result := fnd_message.get;
2754:
2755: IF p_message IS NOT NULL
2756: THEN
2757: IF fnd_log.level_statement >=
2758: fnd_log.g_current_runtime_level
2759: THEN
2760: fnd_log.string(
2761: fnd_log.level_statement,

Line 2758: fnd_log.g_current_runtime_level

2754:
2755: IF p_message IS NOT NULL
2756: THEN
2757: IF fnd_log.level_statement >=
2758: fnd_log.g_current_runtime_level
2759: THEN
2760: fnd_log.string(
2761: fnd_log.level_statement,
2762: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

Line 2760: fnd_log.string(

2756: THEN
2757: IF fnd_log.level_statement >=
2758: fnd_log.g_current_runtime_level
2759: THEN
2760: fnd_log.string(
2761: fnd_log.level_statement,
2762: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2763: 'message = ' || p_message
2764: );

Line 2761: fnd_log.level_statement,

2757: IF fnd_log.level_statement >=
2758: fnd_log.g_current_runtime_level
2759: THEN
2760: fnd_log.string(
2761: fnd_log.level_statement,
2762: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2763: 'message = ' || p_message
2764: );
2765: END IF;

Line 2773: IF fnd_log.level_statement >=

2769: END IF;
2770:
2771: fnd_file.put_line(fnd_file.log, RPAD(' ', 17) || p_result);
2772:
2773: IF fnd_log.level_statement >=
2774: fnd_log.g_current_runtime_level
2775: THEN
2776: fnd_log.string(
2777: fnd_log.level_statement,

Line 2774: fnd_log.g_current_runtime_level

2770:
2771: fnd_file.put_line(fnd_file.log, RPAD(' ', 17) || p_result);
2772:
2773: IF fnd_log.level_statement >=
2774: fnd_log.g_current_runtime_level
2775: THEN
2776: fnd_log.string(
2777: fnd_log.level_statement,
2778: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

Line 2776: fnd_log.string(

2772:
2773: IF fnd_log.level_statement >=
2774: fnd_log.g_current_runtime_level
2775: THEN
2776: fnd_log.string(
2777: fnd_log.level_statement,
2778: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2779: 'min attendance type check failed'
2780: );

Line 2777: fnd_log.level_statement,

2773: IF fnd_log.level_statement >=
2774: fnd_log.g_current_runtime_level
2775: THEN
2776: fnd_log.string(
2777: fnd_log.level_statement,
2778: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2779: 'min attendance type check failed'
2780: );
2781: END IF;

Line 2783: IF fnd_log.level_statement >=

2779: 'min attendance type check failed'
2780: );
2781: END IF;
2782: ELSE
2783: IF fnd_log.level_statement >=
2784: fnd_log.g_current_runtime_level
2785: THEN
2786: fnd_log.string(
2787: fnd_log.level_statement,

Line 2784: fnd_log.g_current_runtime_level

2780: );
2781: END IF;
2782: ELSE
2783: IF fnd_log.level_statement >=
2784: fnd_log.g_current_runtime_level
2785: THEN
2786: fnd_log.string(
2787: fnd_log.level_statement,
2788: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

Line 2786: fnd_log.string(

2782: ELSE
2783: IF fnd_log.level_statement >=
2784: fnd_log.g_current_runtime_level
2785: THEN
2786: fnd_log.string(
2787: fnd_log.level_statement,
2788: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2789: 'min attendance type check passed'
2790: );

Line 2787: fnd_log.level_statement,

2783: IF fnd_log.level_statement >=
2784: fnd_log.g_current_runtime_level
2785: THEN
2786: fnd_log.string(
2787: fnd_log.level_statement,
2788: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2789: 'min attendance type check passed'
2790: );
2791: END IF;

Line 2808: IF fnd_log.level_statement >=

2804:
2805: IF l_fund_meth_result IS NULL
2806: THEN
2807: -- null is returned if the funding type is incorrect
2808: IF fnd_log.level_statement >=
2809: fnd_log.g_current_runtime_level
2810: THEN
2811: fnd_log.string(
2812: fnd_log.level_statement,

Line 2809: fnd_log.g_current_runtime_level

2805: IF l_fund_meth_result IS NULL
2806: THEN
2807: -- null is returned if the funding type is incorrect
2808: IF fnd_log.level_statement >=
2809: fnd_log.g_current_runtime_level
2810: THEN
2811: fnd_log.string(
2812: fnd_log.level_statement,
2813: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

Line 2811: fnd_log.string(

2807: -- null is returned if the funding type is incorrect
2808: IF fnd_log.level_statement >=
2809: fnd_log.g_current_runtime_level
2810: THEN
2811: fnd_log.string(
2812: fnd_log.level_statement,
2813: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2814: 'result of funding method check is NULL'
2815: );

Line 2812: fnd_log.level_statement,

2808: IF fnd_log.level_statement >=
2809: fnd_log.g_current_runtime_level
2810: THEN
2811: fnd_log.string(
2812: fnd_log.level_statement,
2813: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2814: 'result of funding method check is NULL'
2815: );
2816: END IF;

Line 2823: IF fnd_log.level_statement >=

2819: p_result := fnd_message.get;
2820: fnd_file.put_line(fnd_file.log, RPAD(' ', 17) || p_result);
2821: RAISE skip_record;
2822:
2823: IF fnd_log.level_statement >=
2824: fnd_log.g_current_runtime_level
2825: THEN
2826: fnd_log.string(
2827: fnd_log.level_statement,

Line 2824: fnd_log.g_current_runtime_level

2820: fnd_file.put_line(fnd_file.log, RPAD(' ', 17) || p_result);
2821: RAISE skip_record;
2822:
2823: IF fnd_log.level_statement >=
2824: fnd_log.g_current_runtime_level
2825: THEN
2826: fnd_log.string(
2827: fnd_log.level_statement,
2828: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

Line 2826: fnd_log.string(

2822:
2823: IF fnd_log.level_statement >=
2824: fnd_log.g_current_runtime_level
2825: THEN
2826: fnd_log.string(
2827: fnd_log.level_statement,
2828: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2829: 'error in funding method'
2830: );

Line 2827: fnd_log.level_statement,

2823: IF fnd_log.level_statement >=
2824: fnd_log.g_current_runtime_level
2825: THEN
2826: fnd_log.string(
2827: fnd_log.level_statement,
2828: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2829: 'error in funding method'
2830: );
2831: END IF;

Line 2842: IF fnd_log.level_statement >=

2838: fnd_file.put_line(
2839: fnd_file.log, RPAD(' ', 17) || p_result
2840: );
2841:
2842: IF fnd_log.level_statement >=
2843: fnd_log.g_current_runtime_level
2844: THEN
2845: fnd_log.string(
2846: fnd_log.level_statement,

Line 2843: fnd_log.g_current_runtime_level

2839: fnd_file.log, RPAD(' ', 17) || p_result
2840: );
2841:
2842: IF fnd_log.level_statement >=
2843: fnd_log.g_current_runtime_level
2844: THEN
2845: fnd_log.string(
2846: fnd_log.level_statement,
2847: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

Line 2845: fnd_log.string(

2841:
2842: IF fnd_log.level_statement >=
2843: fnd_log.g_current_runtime_level
2844: THEN
2845: fnd_log.string(
2846: fnd_log.level_statement,
2847: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2848: 'funding method check failed'
2849: );

Line 2846: fnd_log.level_statement,

2842: IF fnd_log.level_statement >=
2843: fnd_log.g_current_runtime_level
2844: THEN
2845: fnd_log.string(
2846: fnd_log.level_statement,
2847: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2848: 'funding method check failed'
2849: );
2850: END IF;

Line 2852: IF fnd_log.level_statement >=

2848: 'funding method check failed'
2849: );
2850: END IF;
2851: ELSE
2852: IF fnd_log.level_statement >=
2853: fnd_log.g_current_runtime_level
2854: THEN
2855: fnd_log.string(
2856: fnd_log.level_statement,

Line 2853: fnd_log.g_current_runtime_level

2849: );
2850: END IF;
2851: ELSE
2852: IF fnd_log.level_statement >=
2853: fnd_log.g_current_runtime_level
2854: THEN
2855: fnd_log.string(
2856: fnd_log.level_statement,
2857: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

Line 2855: fnd_log.string(

2851: ELSE
2852: IF fnd_log.level_statement >=
2853: fnd_log.g_current_runtime_level
2854: THEN
2855: fnd_log.string(
2856: fnd_log.level_statement,
2857: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2858: 'funding method check passed'
2859: );

Line 2856: fnd_log.level_statement,

2852: IF fnd_log.level_statement >=
2853: fnd_log.g_current_runtime_level
2854: THEN
2855: fnd_log.string(
2856: fnd_log.level_statement,
2857: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2858: 'funding method check passed'
2859: );
2860: END IF;

Line 2884: IF fnd_log.level_statement >=

2880: fnd_file.log, RPAD(' ', 17) || p_result
2881: );
2882: RAISE skip_record;
2883:
2884: IF fnd_log.level_statement >=
2885: fnd_log.g_current_runtime_level
2886: THEN
2887: fnd_log.string(
2888: fnd_log.level_statement,

Line 2885: fnd_log.g_current_runtime_level

2881: );
2882: RAISE skip_record;
2883:
2884: IF fnd_log.level_statement >=
2885: fnd_log.g_current_runtime_level
2886: THEN
2887: fnd_log.string(
2888: fnd_log.level_statement,
2889: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

Line 2887: fnd_log.string(

2883:
2884: IF fnd_log.level_statement >=
2885: fnd_log.g_current_runtime_level
2886: THEN
2887: fnd_log.string(
2888: fnd_log.level_statement,
2889: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2890: 'error returned by function chk_fund_meth_pell'
2891: );

Line 2888: fnd_log.level_statement,

2884: IF fnd_log.level_statement >=
2885: fnd_log.g_current_runtime_level
2886: THEN
2887: fnd_log.string(
2888: fnd_log.level_statement,
2889: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2890: 'error returned by function chk_fund_meth_pell'
2891: );
2892: END IF;

Line 2904: IF fnd_log.level_statement >=

2900: fnd_file.log, RPAD(' ', 17) || p_result
2901: );
2902: RAISE skip_record;
2903:
2904: IF fnd_log.level_statement >=
2905: fnd_log.g_current_runtime_level
2906: THEN
2907: fnd_log.string(
2908: fnd_log.level_statement,

Line 2905: fnd_log.g_current_runtime_level

2901: );
2902: RAISE skip_record;
2903:
2904: IF fnd_log.level_statement >=
2905: fnd_log.g_current_runtime_level
2906: THEN
2907: fnd_log.string(
2908: fnd_log.level_statement,
2909: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

Line 2907: fnd_log.string(

2903:
2904: IF fnd_log.level_statement >=
2905: fnd_log.g_current_runtime_level
2906: THEN
2907: fnd_log.string(
2908: fnd_log.level_statement,
2909: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2910: 'error in funding method'
2911: );

Line 2908: fnd_log.level_statement,

2904: IF fnd_log.level_statement >=
2905: fnd_log.g_current_runtime_level
2906: THEN
2907: fnd_log.string(
2908: fnd_log.level_statement,
2909: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2910: 'error in funding method'
2911: );
2912: END IF;

Line 2924: IF fnd_log.level_statement >=

2920: fnd_file.put_line(
2921: fnd_file.log, RPAD(' ', 17) || p_result
2922: );
2923:
2924: IF fnd_log.level_statement >=
2925: fnd_log.g_current_runtime_level
2926: THEN
2927: fnd_log.string(
2928: fnd_log.level_statement,

Line 2925: fnd_log.g_current_runtime_level

2921: fnd_file.log, RPAD(' ', 17) || p_result
2922: );
2923:
2924: IF fnd_log.level_statement >=
2925: fnd_log.g_current_runtime_level
2926: THEN
2927: fnd_log.string(
2928: fnd_log.level_statement,
2929: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

Line 2927: fnd_log.string(

2923:
2924: IF fnd_log.level_statement >=
2925: fnd_log.g_current_runtime_level
2926: THEN
2927: fnd_log.string(
2928: fnd_log.level_statement,
2929: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2930: 'funding method check failed'
2931: );

Line 2928: fnd_log.level_statement,

2924: IF fnd_log.level_statement >=
2925: fnd_log.g_current_runtime_level
2926: THEN
2927: fnd_log.string(
2928: fnd_log.level_statement,
2929: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2930: 'funding method check failed'
2931: );
2932: END IF;

Line 2934: IF fnd_log.level_statement >=

2930: 'funding method check failed'
2931: );
2932: END IF;
2933: ELSE
2934: IF fnd_log.level_statement >=
2935: fnd_log.g_current_runtime_level
2936: THEN
2937: fnd_log.string(
2938: fnd_log.level_statement,

Line 2935: fnd_log.g_current_runtime_level

2931: );
2932: END IF;
2933: ELSE
2934: IF fnd_log.level_statement >=
2935: fnd_log.g_current_runtime_level
2936: THEN
2937: fnd_log.string(
2938: fnd_log.level_statement,
2939: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

Line 2937: fnd_log.string(

2933: ELSE
2934: IF fnd_log.level_statement >=
2935: fnd_log.g_current_runtime_level
2936: THEN
2937: fnd_log.string(
2938: fnd_log.level_statement,
2939: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2940: 'funding method check passed'
2941: );

Line 2938: fnd_log.level_statement,

2934: IF fnd_log.level_statement >=
2935: fnd_log.g_current_runtime_level
2936: THEN
2937: fnd_log.string(
2938: fnd_log.level_statement,
2939: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2940: 'funding method check passed'
2941: );
2942: END IF;

Line 2950: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

2946:
2947: --
2948: -- Based on these results, set DRI to true
2949: --
2950: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2951: THEN
2952: fnd_log.string(
2953: fnd_log.level_statement,
2954: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

Line 2952: fnd_log.string(

2948: -- Based on these results, set DRI to true
2949: --
2950: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2951: THEN
2952: fnd_log.string(
2953: fnd_log.level_statement,
2954: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2955: 'checking the result of all eligibilty checks'
2956: );

Line 2953: fnd_log.level_statement,

2949: --
2950: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2951: THEN
2952: fnd_log.string(
2953: fnd_log.level_statement,
2954: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2955: 'checking the result of all eligibilty checks'
2956: );
2957: fnd_log.string(

Line 2957: fnd_log.string(

2953: fnd_log.level_statement,
2954: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2955: 'checking the result of all eligibilty checks'
2956: );
2957: fnd_log.string(
2958: fnd_log.level_statement,
2959: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2960: 'fed_fund_code' || awd_disb_rec.fed_fund_code
2961: );

Line 2958: fnd_log.level_statement,

2954: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2955: 'checking the result of all eligibilty checks'
2956: );
2957: fnd_log.string(
2958: fnd_log.level_statement,
2959: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2960: 'fed_fund_code' || awd_disb_rec.fed_fund_code
2961: );
2962:

Line 2965: fnd_log.string(

2961: );
2962:
2963: IF NOT l_pays_prg
2964: THEN
2965: fnd_log.string(
2966: fnd_log.level_statement,
2967: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2968: 'l_pays_prg passed'
2969: );

Line 2966: fnd_log.level_statement,

2962:
2963: IF NOT l_pays_prg
2964: THEN
2965: fnd_log.string(
2966: fnd_log.level_statement,
2967: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2968: 'l_pays_prg passed'
2969: );
2970: END IF;

Line 2974: fnd_log.string(

2970: END IF;
2971:
2972: IF NOT l_fclass_result
2973: THEN
2974: fnd_log.string(
2975: fnd_log.level_statement,
2976: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2977: 'l_fclass_result'
2978: );

Line 2975: fnd_log.level_statement,

2971:
2972: IF NOT l_fclass_result
2973: THEN
2974: fnd_log.string(
2975: fnd_log.level_statement,
2976: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2977: 'l_fclass_result'
2978: );
2979: END IF;

Line 2983: fnd_log.string(

2979: END IF;
2980:
2981: IF NOT l_pays_uts
2982: THEN
2983: fnd_log.string(
2984: fnd_log.level_statement,
2985: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2986: 'l_pays_uts'
2987: );

Line 2984: fnd_log.level_statement,

2980:
2981: IF NOT l_pays_uts
2982: THEN
2983: fnd_log.string(
2984: fnd_log.level_statement,
2985: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2986: 'l_pays_uts'
2987: );
2988: END IF;

Line 2992: fnd_log.string(

2988: END IF;
2989:
2990: IF NOT l_att_result
2991: THEN
2992: fnd_log.string(
2993: fnd_log.level_statement,
2994: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2995: 'l_att_result'
2996: );

Line 2993: fnd_log.level_statement,

2989:
2990: IF NOT l_att_result
2991: THEN
2992: fnd_log.string(
2993: fnd_log.level_statement,
2994: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
2995: 'l_att_result'
2996: );
2997: END IF;

Line 3001: fnd_log.string(

2997: END IF;
2998:
2999: IF NOT l_active_result
3000: THEN
3001: fnd_log.string(
3002: fnd_log.level_statement,
3003: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
3004: 'l_active_result'
3005: );

Line 3002: fnd_log.level_statement,

2998:
2999: IF NOT l_active_result
3000: THEN
3001: fnd_log.string(
3002: fnd_log.level_statement,
3003: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
3004: 'l_active_result'
3005: );
3006: END IF;

Line 3010: fnd_log.string(

3006: END IF;
3007:
3008: IF NOT l_sys_hold_result
3009: THEN
3010: fnd_log.string(
3011: fnd_log.level_statement,
3012: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
3013: 'l_sys_hold_result'
3014: );

Line 3011: fnd_log.level_statement,

3007:
3008: IF NOT l_sys_hold_result
3009: THEN
3010: fnd_log.string(
3011: fnd_log.level_statement,
3012: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
3013: 'l_sys_hold_result'
3014: );
3015: END IF;

Line 3019: fnd_log.string(

3015: END IF;
3016:
3017: IF NOT l_ac_hold_result
3018: THEN
3019: fnd_log.string(
3020: fnd_log.level_statement,
3021: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
3022: 'l_ac_hold_result'
3023: );

Line 3020: fnd_log.level_statement,

3016:
3017: IF NOT l_ac_hold_result
3018: THEN
3019: fnd_log.string(
3020: fnd_log.level_statement,
3021: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
3022: 'l_ac_hold_result'
3023: );
3024: END IF;

Line 3028: fnd_log.string(

3024: END IF;
3025:
3026: IF NOT l_todo_result
3027: THEN
3028: fnd_log.string(
3029: fnd_log.level_statement,
3030: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
3031: 'l_elig_result'
3032: );

Line 3029: fnd_log.level_statement,

3025:
3026: IF NOT l_todo_result
3027: THEN
3028: fnd_log.string(
3029: fnd_log.level_statement,
3030: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
3031: 'l_elig_result'
3032: );
3033: END IF;

Line 3037: fnd_log.string(

3033: END IF;
3034:
3035: IF NOT l_fund_meth_result
3036: THEN
3037: fnd_log.string(
3038: fnd_log.level_statement,
3039: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
3040: 'l_fund_meth_result'
3041: );

Line 3038: fnd_log.level_statement,

3034:
3035: IF NOT l_fund_meth_result
3036: THEN
3037: fnd_log.string(
3038: fnd_log.level_statement,
3039: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
3040: 'l_fund_meth_result'
3041: );
3042: END IF;

Line 3046: fnd_log.string(

3042: END IF;
3043:
3044: IF NOT l_crdt_st_check_plus
3045: THEN
3046: fnd_log.string(
3047: fnd_log.level_statement,
3048: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
3049: 'l_crdt_st_check_PLUS '
3050: );

Line 3047: fnd_log.level_statement,

3043:
3044: IF NOT l_crdt_st_check_plus
3045: THEN
3046: fnd_log.string(
3047: fnd_log.level_statement,
3048: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
3049: 'l_crdt_st_check_PLUS '
3050: );
3051: END IF;

Line 3067: IF fnd_log.level_statement >=

3063: awd_disb_rec.award_id, awd_disb_rec.disb_num,
3064: awd_disb_rec.fund_id, l_fund_type
3065: );
3066:
3067: IF fnd_log.level_statement >=
3068: fnd_log.g_current_runtime_level
3069: THEN
3070: fnd_log.string(
3071: fnd_log.level_statement,

Line 3068: fnd_log.g_current_runtime_level

3064: awd_disb_rec.fund_id, l_fund_type
3065: );
3066:
3067: IF fnd_log.level_statement >=
3068: fnd_log.g_current_runtime_level
3069: THEN
3070: fnd_log.string(
3071: fnd_log.level_statement,
3072: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

Line 3070: fnd_log.string(

3066:
3067: IF fnd_log.level_statement >=
3068: fnd_log.g_current_runtime_level
3069: THEN
3070: fnd_log.string(
3071: fnd_log.level_statement,
3072: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
3073: 'called set_dri_true with fund_id '
3074: || awd_disb_rec.fund_id

Line 3071: fnd_log.level_statement,

3067: IF fnd_log.level_statement >=
3068: fnd_log.g_current_runtime_level
3069: THEN
3070: fnd_log.string(
3071: fnd_log.level_statement,
3072: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
3073: 'called set_dri_true with fund_id '
3074: || awd_disb_rec.fund_id
3075: );

Line 3091: IF fnd_log.level_statement >=

3087: awd_disb_rec.award_id, awd_disb_rec.disb_num,
3088: awd_disb_rec.fund_id, l_fund_type
3089: );
3090:
3091: IF fnd_log.level_statement >=
3092: fnd_log.g_current_runtime_level
3093: THEN
3094: fnd_log.string(
3095: fnd_log.level_statement,

Line 3092: fnd_log.g_current_runtime_level

3088: awd_disb_rec.fund_id, l_fund_type
3089: );
3090:
3091: IF fnd_log.level_statement >=
3092: fnd_log.g_current_runtime_level
3093: THEN
3094: fnd_log.string(
3095: fnd_log.level_statement,
3096: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

Line 3094: fnd_log.string(

3090:
3091: IF fnd_log.level_statement >=
3092: fnd_log.g_current_runtime_level
3093: THEN
3094: fnd_log.string(
3095: fnd_log.level_statement,
3096: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
3097: 'called set_dri_true with fund_id '
3098: || awd_disb_rec.fund_id

Line 3095: fnd_log.level_statement,

3091: IF fnd_log.level_statement >=
3092: fnd_log.g_current_runtime_level
3093: THEN
3094: fnd_log.string(
3095: fnd_log.level_statement,
3096: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
3097: 'called set_dri_true with fund_id '
3098: || awd_disb_rec.fund_id
3099: );

Line 3114: IF fnd_log.level_statement >=

3110: awd_disb_rec.award_id, awd_disb_rec.disb_num,
3111: awd_disb_rec.fund_id, l_fund_type
3112: );
3113:
3114: IF fnd_log.level_statement >=
3115: fnd_log.g_current_runtime_level
3116: THEN
3117: fnd_log.string(
3118: fnd_log.level_statement,

Line 3115: fnd_log.g_current_runtime_level

3111: awd_disb_rec.fund_id, l_fund_type
3112: );
3113:
3114: IF fnd_log.level_statement >=
3115: fnd_log.g_current_runtime_level
3116: THEN
3117: fnd_log.string(
3118: fnd_log.level_statement,
3119: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

Line 3117: fnd_log.string(

3113:
3114: IF fnd_log.level_statement >=
3115: fnd_log.g_current_runtime_level
3116: THEN
3117: fnd_log.string(
3118: fnd_log.level_statement,
3119: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
3120: 'called set_dri_true with fund_id '
3121: || awd_disb_rec.fund_id

Line 3118: fnd_log.level_statement,

3114: IF fnd_log.level_statement >=
3115: fnd_log.g_current_runtime_level
3116: THEN
3117: fnd_log.string(
3118: fnd_log.level_statement,
3119: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
3120: 'called set_dri_true with fund_id '
3121: || awd_disb_rec.fund_id
3122: );

Line 3132: IF fnd_log.level_statement >=

3128: THEN
3129: FETCH cur_awd_disb_dl INTO awd_disb_rec;
3130: EXIT WHEN cur_awd_disb_dl%NOTFOUND;
3131:
3132: IF fnd_log.level_statement >=
3133: fnd_log.g_current_runtime_level
3134: THEN
3135: fnd_log.string(
3136: fnd_log.level_statement,

Line 3133: fnd_log.g_current_runtime_level

3129: FETCH cur_awd_disb_dl INTO awd_disb_rec;
3130: EXIT WHEN cur_awd_disb_dl%NOTFOUND;
3131:
3132: IF fnd_log.level_statement >=
3133: fnd_log.g_current_runtime_level
3134: THEN
3135: fnd_log.string(
3136: fnd_log.level_statement,
3137: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

Line 3135: fnd_log.string(

3131:
3132: IF fnd_log.level_statement >=
3133: fnd_log.g_current_runtime_level
3134: THEN
3135: fnd_log.string(
3136: fnd_log.level_statement,
3137: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
3138: 'exiting with fund type' || l_fund_type
3139: );

Line 3136: fnd_log.level_statement,

3132: IF fnd_log.level_statement >=
3133: fnd_log.g_current_runtime_level
3134: THEN
3135: fnd_log.string(
3136: fnd_log.level_statement,
3137: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
3138: 'exiting with fund type' || l_fund_type
3139: );
3140: END IF;

Line 3146: IF fnd_log.level_statement >=

3142: THEN
3143: FETCH cur_awd_disb_fed INTO awd_disb_rec;
3144: EXIT WHEN cur_awd_disb_fed%NOTFOUND;
3145:
3146: IF fnd_log.level_statement >=
3147: fnd_log.g_current_runtime_level
3148: THEN
3149: fnd_log.string(
3150: fnd_log.level_statement,

Line 3147: fnd_log.g_current_runtime_level

3143: FETCH cur_awd_disb_fed INTO awd_disb_rec;
3144: EXIT WHEN cur_awd_disb_fed%NOTFOUND;
3145:
3146: IF fnd_log.level_statement >=
3147: fnd_log.g_current_runtime_level
3148: THEN
3149: fnd_log.string(
3150: fnd_log.level_statement,
3151: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

Line 3149: fnd_log.string(

3145:
3146: IF fnd_log.level_statement >=
3147: fnd_log.g_current_runtime_level
3148: THEN
3149: fnd_log.string(
3150: fnd_log.level_statement,
3151: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
3152: 'exiting with fund type' || l_fund_type
3153: );

Line 3150: fnd_log.level_statement,

3146: IF fnd_log.level_statement >=
3147: fnd_log.g_current_runtime_level
3148: THEN
3149: fnd_log.string(
3150: fnd_log.level_statement,
3151: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
3152: 'exiting with fund type' || l_fund_type
3153: );
3154: END IF;

Line 3160: IF fnd_log.level_statement >=

3156: THEN
3157: FETCH cur_awd_disb_fed_no_trans INTO awd_disb_rec;
3158: EXIT WHEN cur_awd_disb_fed_no_trans%NOTFOUND;
3159:
3160: IF fnd_log.level_statement >=
3161: fnd_log.g_current_runtime_level
3162: THEN
3163: fnd_log.string(
3164: fnd_log.level_statement,

Line 3161: fnd_log.g_current_runtime_level

3157: FETCH cur_awd_disb_fed_no_trans INTO awd_disb_rec;
3158: EXIT WHEN cur_awd_disb_fed_no_trans%NOTFOUND;
3159:
3160: IF fnd_log.level_statement >=
3161: fnd_log.g_current_runtime_level
3162: THEN
3163: fnd_log.string(
3164: fnd_log.level_statement,
3165: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

Line 3163: fnd_log.string(

3159:
3160: IF fnd_log.level_statement >=
3161: fnd_log.g_current_runtime_level
3162: THEN
3163: fnd_log.string(
3164: fnd_log.level_statement,
3165: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
3166: 'exiting with fund type' || l_fund_type
3167: );

Line 3164: fnd_log.level_statement,

3160: IF fnd_log.level_statement >=
3161: fnd_log.g_current_runtime_level
3162: THEN
3163: fnd_log.string(
3164: fnd_log.level_statement,
3165: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
3166: 'exiting with fund type' || l_fund_type
3167: );
3168: END IF;

Line 3170: IF fnd_log.level_statement >=

3166: 'exiting with fund type' || l_fund_type
3167: );
3168: END IF;
3169: ELSE
3170: IF fnd_log.level_statement >=
3171: fnd_log.g_current_runtime_level
3172: THEN
3173: fnd_log.string(
3174: fnd_log.level_statement,

Line 3171: fnd_log.g_current_runtime_level

3167: );
3168: END IF;
3169: ELSE
3170: IF fnd_log.level_statement >=
3171: fnd_log.g_current_runtime_level
3172: THEN
3173: fnd_log.string(
3174: fnd_log.level_statement,
3175: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

Line 3173: fnd_log.string(

3169: ELSE
3170: IF fnd_log.level_statement >=
3171: fnd_log.g_current_runtime_level
3172: THEN
3173: fnd_log.string(
3174: fnd_log.level_statement,
3175: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
3176: 'exiting with fund type' || l_fund_type
3177: );

Line 3174: fnd_log.level_statement,

3170: IF fnd_log.level_statement >=
3171: fnd_log.g_current_runtime_level
3172: THEN
3173: fnd_log.string(
3174: fnd_log.level_statement,
3175: 'igf.plsql.igf_sl_rel_disb.process_student.debug',
3176: 'exiting with fund type' || l_fund_type
3177: );
3178: END IF;

Line 3403: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

3399: p_retcode := 0;
3400: l_ci_cal_type := RTRIM(SUBSTR(p_award_year, 1, 10));
3401: l_ci_sequence_number := RTRIM(SUBSTR(p_award_year, 11));
3402:
3403: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3404: THEN
3405: fnd_log.string(
3406: fnd_log.level_statement,
3407: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',

Line 3405: fnd_log.string(

3401: l_ci_sequence_number := RTRIM(SUBSTR(p_award_year, 11));
3402:
3403: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3404: THEN
3405: fnd_log.string(
3406: fnd_log.level_statement,
3407: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3408: 'l_ci_cal_type:' || l_ci_cal_type
3409: );

Line 3406: fnd_log.level_statement,

3402:
3403: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3404: THEN
3405: fnd_log.string(
3406: fnd_log.level_statement,
3407: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3408: 'l_ci_cal_type:' || l_ci_cal_type
3409: );
3410: fnd_log.string(

Line 3410: fnd_log.string(

3406: fnd_log.level_statement,
3407: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3408: 'l_ci_cal_type:' || l_ci_cal_type
3409: );
3410: fnd_log.string(
3411: fnd_log.level_statement,
3412: 'igf.plsql.igf_sl_rel_disb.rel_rel_disb_process.debug',
3413: 'l_ci_sequence_number:' || l_ci_sequence_number
3414: );

Line 3411: fnd_log.level_statement,

3407: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3408: 'l_ci_cal_type:' || l_ci_cal_type
3409: );
3410: fnd_log.string(
3411: fnd_log.level_statement,
3412: 'igf.plsql.igf_sl_rel_disb.rel_rel_disb_process.debug',
3413: 'l_ci_sequence_number:' || l_ci_sequence_number
3414: );
3415: fnd_log.string(

Line 3415: fnd_log.string(

3411: fnd_log.level_statement,
3412: 'igf.plsql.igf_sl_rel_disb.rel_rel_disb_process.debug',
3413: 'l_ci_sequence_number:' || l_ci_sequence_number
3414: );
3415: fnd_log.string(
3416: fnd_log.level_statement,
3417: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug', 'p_fund_id:'
3418: || p_fund_id
3419: );

Line 3416: fnd_log.level_statement,

3412: 'igf.plsql.igf_sl_rel_disb.rel_rel_disb_process.debug',
3413: 'l_ci_sequence_number:' || l_ci_sequence_number
3414: );
3415: fnd_log.string(
3416: fnd_log.level_statement,
3417: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug', 'p_fund_id:'
3418: || p_fund_id
3419: );
3420: fnd_log.string(

Line 3420: fnd_log.string(

3416: fnd_log.level_statement,
3417: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug', 'p_fund_id:'
3418: || p_fund_id
3419: );
3420: fnd_log.string(
3421: fnd_log.level_statement,
3422: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug', 'p_base_id:'
3423: || p_base_id
3424: );

Line 3421: fnd_log.level_statement,

3417: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug', 'p_fund_id:'
3418: || p_fund_id
3419: );
3420: fnd_log.string(
3421: fnd_log.level_statement,
3422: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug', 'p_base_id:'
3423: || p_base_id
3424: );
3425: fnd_log.string(

Line 3425: fnd_log.string(

3421: fnd_log.level_statement,
3422: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug', 'p_base_id:'
3423: || p_base_id
3424: );
3425: fnd_log.string(
3426: fnd_log.level_statement,
3427: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug', 'p_loan_id:'
3428: || p_loan_id
3429: );

Line 3426: fnd_log.level_statement,

3422: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug', 'p_base_id:'
3423: || p_base_id
3424: );
3425: fnd_log.string(
3426: fnd_log.level_statement,
3427: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug', 'p_loan_id:'
3428: || p_loan_id
3429: );
3430: fnd_log.string(

Line 3430: fnd_log.string(

3426: fnd_log.level_statement,
3427: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug', 'p_loan_id:'
3428: || p_loan_id
3429: );
3430: fnd_log.string(
3431: fnd_log.level_statement,
3432: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3433: 'p_trans_type:' || p_trans_type
3434: );

Line 3431: fnd_log.level_statement,

3427: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug', 'p_loan_id:'
3428: || p_loan_id
3429: );
3430: fnd_log.string(
3431: fnd_log.level_statement,
3432: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3433: 'p_trans_type:' || p_trans_type
3434: );
3435: fnd_log.string(

Line 3435: fnd_log.string(

3431: fnd_log.level_statement,
3432: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3433: 'p_trans_type:' || p_trans_type
3434: );
3435: fnd_log.string(
3436: fnd_log.level_statement,
3437: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3438: 'p_per_grp_id:' || p_per_grp_id
3439: );

Line 3436: fnd_log.level_statement,

3432: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3433: 'p_trans_type:' || p_trans_type
3434: );
3435: fnd_log.string(
3436: fnd_log.level_statement,
3437: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3438: 'p_per_grp_id:' || p_per_grp_id
3439: );
3440: END IF;

Line 3508: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

3504: END IF;
3505:
3506: IF p_per_grp_id IS NOT NULL
3507: THEN
3508: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3509: THEN
3510: fnd_log.string(
3511: fnd_log.level_statement,
3512: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',

Line 3510: fnd_log.string(

3506: IF p_per_grp_id IS NOT NULL
3507: THEN
3508: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3509: THEN
3510: fnd_log.string(
3511: fnd_log.level_statement,
3512: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3513: 'Starting to process person group ' || p_per_grp_id
3514: );

Line 3511: fnd_log.level_statement,

3507: THEN
3508: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3509: THEN
3510: fnd_log.string(
3511: fnd_log.level_statement,
3512: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3513: 'Starting to process person group ' || p_per_grp_id
3514: );
3515: END IF;

Line 3539: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

3535: CLOSE cur_per_grp;
3536: fnd_message.set_name('IGF', 'IGF_DB_NO_PER_GRP');
3537: fnd_file.put_line(fnd_file.log, RPAD(' ', 5) || fnd_message.get);
3538:
3539: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3540: THEN
3541: fnd_log.string(
3542: fnd_log.level_statement,
3543: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',

Line 3541: fnd_log.string(

3537: fnd_file.put_line(fnd_file.log, RPAD(' ', 5) || fnd_message.get);
3538:
3539: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3540: THEN
3541: fnd_log.string(
3542: fnd_log.level_statement,
3543: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3544: 'No persons in group ' || p_per_grp_id
3545: );

Line 3542: fnd_log.level_statement,

3538:
3539: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3540: THEN
3541: fnd_log.string(
3542: fnd_log.level_statement,
3543: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3544: 'No persons in group ' || p_per_grp_id
3545: );
3546: END IF;

Line 3559: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

3555: fnd_file.log, RPAD(' ', 5) || fnd_message.get || ' '
3556: || per_grp_rec.group_cd
3557: );
3558:
3559: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3560: THEN
3561: fnd_log.string(
3562: fnd_log.level_statement,
3563: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',

Line 3561: fnd_log.string(

3557: );
3558:
3559: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3560: THEN
3561: fnd_log.string(
3562: fnd_log.level_statement,
3563: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3564: 'Processing for ' || p_per_grp_id
3565: );

Line 3562: fnd_log.level_statement,

3558:
3559: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3560: THEN
3561: fnd_log.string(
3562: fnd_log.level_statement,
3563: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3564: 'Processing for ' || p_per_grp_id
3565: );
3566: END IF;

Line 3588: IF fnd_log.level_statement >=

3584: fnd_file.put_line(
3585: fnd_file.log, RPAD(' ', 10) || fnd_message.get
3586: );
3587:
3588: IF fnd_log.level_statement >=
3589: fnd_log.g_current_runtime_level
3590: THEN
3591: fnd_log.string(
3592: fnd_log.level_statement,

Line 3589: fnd_log.g_current_runtime_level

3585: fnd_file.log, RPAD(' ', 10) || fnd_message.get
3586: );
3587:
3588: IF fnd_log.level_statement >=
3589: fnd_log.g_current_runtime_level
3590: THEN
3591: fnd_log.string(
3592: fnd_log.level_statement,
3593: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',

Line 3591: fnd_log.string(

3587:
3588: IF fnd_log.level_statement >=
3589: fnd_log.g_current_runtime_level
3590: THEN
3591: fnd_log.string(
3592: fnd_log.level_statement,
3593: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3594: 'Processing student ' || l_person_number
3595: );

Line 3592: fnd_log.level_statement,

3588: IF fnd_log.level_statement >=
3589: fnd_log.g_current_runtime_level
3590: THEN
3591: fnd_log.string(
3592: fnd_log.level_statement,
3593: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3594: 'Processing student ' || l_person_number
3595: );
3596: END IF;

Line 3612: IF fnd_log.level_statement >=

3608: fnd_file.put_line(
3609: fnd_file.log, RPAD(' ', 10) || fnd_message.get
3610: );
3611:
3612: IF fnd_log.level_statement >=
3613: fnd_log.g_current_runtime_level
3614: THEN
3615: fnd_log.string(
3616: fnd_log.level_statement,

Line 3613: fnd_log.g_current_runtime_level

3609: fnd_file.log, RPAD(' ', 10) || fnd_message.get
3610: );
3611:
3612: IF fnd_log.level_statement >=
3613: fnd_log.g_current_runtime_level
3614: THEN
3615: fnd_log.string(
3616: fnd_log.level_statement,
3617: 'igf.plsql.igf_sl_rel_disb.disb_process.debug',

Line 3615: fnd_log.string(

3611:
3612: IF fnd_log.level_statement >=
3613: fnd_log.g_current_runtime_level
3614: THEN
3615: fnd_log.string(
3616: fnd_log.level_statement,
3617: 'igf.plsql.igf_sl_rel_disb.disb_process.debug',
3618: 'get_stud_hold_effect returned F'
3619: );

Line 3616: fnd_log.level_statement,

3612: IF fnd_log.level_statement >=
3613: fnd_log.g_current_runtime_level
3614: THEN
3615: fnd_log.string(
3616: fnd_log.level_statement,
3617: 'igf.plsql.igf_sl_rel_disb.disb_process.debug',
3618: 'get_stud_hold_effect returned F'
3619: );
3620: END IF;

Line 3622: IF fnd_log.level_statement >=

3618: 'get_stud_hold_effect returned F'
3619: );
3620: END IF;
3621: ELSE
3622: IF fnd_log.level_statement >=
3623: fnd_log.g_current_runtime_level
3624: THEN
3625: fnd_log.string(
3626: fnd_log.level_statement,

Line 3623: fnd_log.g_current_runtime_level

3619: );
3620: END IF;
3621: ELSE
3622: IF fnd_log.level_statement >=
3623: fnd_log.g_current_runtime_level
3624: THEN
3625: fnd_log.string(
3626: fnd_log.level_statement,
3627: 'igf.plsql.igf_sl_rel_disb.disb_process.debug',

Line 3625: fnd_log.string(

3621: ELSE
3622: IF fnd_log.level_statement >=
3623: fnd_log.g_current_runtime_level
3624: THEN
3625: fnd_log.string(
3626: fnd_log.level_statement,
3627: 'igf.plsql.igf_sl_rel_disb.disb_process.debug',
3628: 'calling process_student for base_id 1'
3629: || l_base_id

Line 3626: fnd_log.level_statement,

3622: IF fnd_log.level_statement >=
3623: fnd_log.g_current_runtime_level
3624: THEN
3625: fnd_log.string(
3626: fnd_log.level_statement,
3627: 'igf.plsql.igf_sl_rel_disb.disb_process.debug',
3628: 'calling process_student for base_id 1'
3629: || l_base_id
3630: );

Line 3649: IF fnd_log.level_statement >=

3645: fnd_file.log, RPAD(' ', 10) || fnd_message.get
3646: );
3647: fnd_file.new_line(fnd_file.log, 1);
3648:
3649: IF fnd_log.level_statement >=
3650: fnd_log.g_current_runtime_level
3651: THEN
3652: fnd_log.string(
3653: fnd_log.level_statement,

Line 3650: fnd_log.g_current_runtime_level

3646: );
3647: fnd_file.new_line(fnd_file.log, 1);
3648:
3649: IF fnd_log.level_statement >=
3650: fnd_log.g_current_runtime_level
3651: THEN
3652: fnd_log.string(
3653: fnd_log.level_statement,
3654: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',

Line 3652: fnd_log.string(

3648:
3649: IF fnd_log.level_statement >=
3650: fnd_log.g_current_runtime_level
3651: THEN
3652: fnd_log.string(
3653: fnd_log.level_statement,
3654: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3655: 'end processing ' || l_person_number
3656: );

Line 3653: fnd_log.level_statement,

3649: IF fnd_log.level_statement >=
3650: fnd_log.g_current_runtime_level
3651: THEN
3652: fnd_log.string(
3653: fnd_log.level_statement,
3654: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3655: 'end processing ' || l_person_number
3656: );
3657: END IF;

Line 3670: IF fnd_log.level_statement >=

3666: fnd_file.put_line(
3667: fnd_file.log, RPAD(' ', 10) || fnd_message.get
3668: );
3669:
3670: IF fnd_log.level_statement >=
3671: fnd_log.g_current_runtime_level
3672: THEN
3673: fnd_log.string(
3674: fnd_log.level_statement,

Line 3671: fnd_log.g_current_runtime_level

3667: fnd_file.log, RPAD(' ', 10) || fnd_message.get
3668: );
3669:
3670: IF fnd_log.level_statement >=
3671: fnd_log.g_current_runtime_level
3672: THEN
3673: fnd_log.string(
3674: fnd_log.level_statement,
3675: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',

Line 3673: fnd_log.string(

3669:
3670: IF fnd_log.level_statement >=
3671: fnd_log.g_current_runtime_level
3672: THEN
3673: fnd_log.string(
3674: fnd_log.level_statement,
3675: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3676: igf_gr_gen.get_per_num_oss(l_person_id)
3677: || ' not in FA'

Line 3674: fnd_log.level_statement,

3670: IF fnd_log.level_statement >=
3671: fnd_log.g_current_runtime_level
3672: THEN
3673: fnd_log.string(
3674: fnd_log.level_statement,
3675: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3676: igf_gr_gen.get_per_num_oss(l_person_id)
3677: || ' not in FA'
3678: );

Line 3707: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

3703: -- Get all the Students for which the Award is given
3704: OPEN cur_award_std(p_fund_id);
3705: FETCH cur_award_std INTO award_std_rec;
3706:
3707: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3708: THEN
3709: fnd_log.string(
3710: fnd_log.level_statement,
3711: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',

Line 3709: fnd_log.string(

3705: FETCH cur_award_std INTO award_std_rec;
3706:
3707: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3708: THEN
3709: fnd_log.string(
3710: fnd_log.level_statement,
3711: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3712: 'starting processing for fund_id ' || p_fund_id
3713: );

Line 3710: fnd_log.level_statement,

3706:
3707: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3708: THEN
3709: fnd_log.string(
3710: fnd_log.level_statement,
3711: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3712: 'starting processing for fund_id ' || p_fund_id
3713: );
3714: END IF;

Line 3726: IF fnd_log.level_statement >=

3722: fnd_file.put_line(
3723: fnd_file.log, RPAD(' ', 5) || fnd_message.get
3724: );
3725:
3726: IF fnd_log.level_statement >=
3727: fnd_log.g_current_runtime_level
3728: THEN
3729: fnd_log.string(
3730: fnd_log.level_statement,

Line 3727: fnd_log.g_current_runtime_level

3723: fnd_file.log, RPAD(' ', 5) || fnd_message.get
3724: );
3725:
3726: IF fnd_log.level_statement >=
3727: fnd_log.g_current_runtime_level
3728: THEN
3729: fnd_log.string(
3730: fnd_log.level_statement,
3731: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',

Line 3729: fnd_log.string(

3725:
3726: IF fnd_log.level_statement >=
3727: fnd_log.g_current_runtime_level
3728: THEN
3729: fnd_log.string(
3730: fnd_log.level_statement,
3731: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3732: 'No award for fund ' || get_fund_desc(p_fund_id)
3733: );

Line 3730: fnd_log.level_statement,

3726: IF fnd_log.level_statement >=
3727: fnd_log.g_current_runtime_level
3728: THEN
3729: fnd_log.string(
3730: fnd_log.level_statement,
3731: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3732: 'No award for fund ' || get_fund_desc(p_fund_id)
3733: );
3734: END IF;

Line 3736: IF fnd_log.level_statement >=

3732: 'No award for fund ' || get_fund_desc(p_fund_id)
3733: );
3734: END IF;
3735: ELSE
3736: IF fnd_log.level_statement >=
3737: fnd_log.g_current_runtime_level
3738: THEN
3739: fnd_log.string(
3740: fnd_log.level_statement,

Line 3737: fnd_log.g_current_runtime_level

3733: );
3734: END IF;
3735: ELSE
3736: IF fnd_log.level_statement >=
3737: fnd_log.g_current_runtime_level
3738: THEN
3739: fnd_log.string(
3740: fnd_log.level_statement,
3741: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',

Line 3739: fnd_log.string(

3735: ELSE
3736: IF fnd_log.level_statement >=
3737: fnd_log.g_current_runtime_level
3738: THEN
3739: fnd_log.string(
3740: fnd_log.level_statement,
3741: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3742: 'award_std_rec.fed_fund_code:'
3743: || award_std_rec.fed_fund_code

Line 3740: fnd_log.level_statement,

3736: IF fnd_log.level_statement >=
3737: fnd_log.g_current_runtime_level
3738: THEN
3739: fnd_log.string(
3740: fnd_log.level_statement,
3741: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3742: 'award_std_rec.fed_fund_code:'
3743: || award_std_rec.fed_fund_code
3744: );

Line 3752: IF fnd_log.level_statement >=

3748: ('FWS', 'SPNSR', 'PRK')
3749: THEN
3750: -- process only for PELL and Direct Loans.
3751: LOOP
3752: IF fnd_log.level_statement >=
3753: fnd_log.g_current_runtime_level
3754: THEN
3755: fnd_log.string(
3756: fnd_log.level_statement,

Line 3753: fnd_log.g_current_runtime_level

3749: THEN
3750: -- process only for PELL and Direct Loans.
3751: LOOP
3752: IF fnd_log.level_statement >=
3753: fnd_log.g_current_runtime_level
3754: THEN
3755: fnd_log.string(
3756: fnd_log.level_statement,
3757: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',

Line 3755: fnd_log.string(

3751: LOOP
3752: IF fnd_log.level_statement >=
3753: fnd_log.g_current_runtime_level
3754: THEN
3755: fnd_log.string(
3756: fnd_log.level_statement,
3757: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3758: 'award_std_rec.base_id: '
3759: || award_std_rec.base_id

Line 3756: fnd_log.level_statement,

3752: IF fnd_log.level_statement >=
3753: fnd_log.g_current_runtime_level
3754: THEN
3755: fnd_log.string(
3756: fnd_log.level_statement,
3757: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3758: 'award_std_rec.base_id: '
3759: || award_std_rec.base_id
3760: );

Line 3767: IF fnd_log.level_statement >=

3763: l_person_number := igf_gr_gen.get_per_num(
3764: award_std_rec.base_id
3765: );
3766:
3767: IF fnd_log.level_statement >=
3768: fnd_log.g_current_runtime_level
3769: THEN
3770: fnd_log.string(
3771: fnd_log.level_statement,

Line 3768: fnd_log.g_current_runtime_level

3764: award_std_rec.base_id
3765: );
3766:
3767: IF fnd_log.level_statement >=
3768: fnd_log.g_current_runtime_level
3769: THEN
3770: fnd_log.string(
3771: fnd_log.level_statement,
3772: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',

Line 3770: fnd_log.string(

3766:
3767: IF fnd_log.level_statement >=
3768: fnd_log.g_current_runtime_level
3769: THEN
3770: fnd_log.string(
3771: fnd_log.level_statement,
3772: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3773: 'l_person_number:' || l_person_number
3774: );

Line 3771: fnd_log.level_statement,

3767: IF fnd_log.level_statement >=
3768: fnd_log.g_current_runtime_level
3769: THEN
3770: fnd_log.string(
3771: fnd_log.level_statement,
3772: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3773: 'l_person_number:' || l_person_number
3774: );
3775: END IF;

Line 3783: IF fnd_log.level_statement >=

3779: fnd_file.put_line(
3780: fnd_file.log, RPAD(' ', 10) || fnd_message.get
3781: );
3782:
3783: IF fnd_log.level_statement >=
3784: fnd_log.g_current_runtime_level
3785: THEN
3786: fnd_log.string(
3787: fnd_log.level_statement,

Line 3784: fnd_log.g_current_runtime_level

3780: fnd_file.log, RPAD(' ', 10) || fnd_message.get
3781: );
3782:
3783: IF fnd_log.level_statement >=
3784: fnd_log.g_current_runtime_level
3785: THEN
3786: fnd_log.string(
3787: fnd_log.level_statement,
3788: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',

Line 3786: fnd_log.string(

3782:
3783: IF fnd_log.level_statement >=
3784: fnd_log.g_current_runtime_level
3785: THEN
3786: fnd_log.string(
3787: fnd_log.level_statement,
3788: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3789: 'starting processing ' || l_person_number
3790: );

Line 3787: fnd_log.level_statement,

3783: IF fnd_log.level_statement >=
3784: fnd_log.g_current_runtime_level
3785: THEN
3786: fnd_log.string(
3787: fnd_log.level_statement,
3788: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3789: 'starting processing ' || l_person_number
3790: );
3791: END IF;

Line 3808: IF fnd_log.level_statement >=

3804: fnd_file.put_line(
3805: fnd_file.log, RPAD(' ', 10) || fnd_message.get
3806: );
3807:
3808: IF fnd_log.level_statement >=
3809: fnd_log.g_current_runtime_level
3810: THEN
3811: fnd_log.string(
3812: fnd_log.level_statement,

Line 3809: fnd_log.g_current_runtime_level

3805: fnd_file.log, RPAD(' ', 10) || fnd_message.get
3806: );
3807:
3808: IF fnd_log.level_statement >=
3809: fnd_log.g_current_runtime_level
3810: THEN
3811: fnd_log.string(
3812: fnd_log.level_statement,
3813: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',

Line 3811: fnd_log.string(

3807:
3808: IF fnd_log.level_statement >=
3809: fnd_log.g_current_runtime_level
3810: THEN
3811: fnd_log.string(
3812: fnd_log.level_statement,
3813: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3814: 'get_stud_hold_effect returned F'
3815: );

Line 3812: fnd_log.level_statement,

3808: IF fnd_log.level_statement >=
3809: fnd_log.g_current_runtime_level
3810: THEN
3811: fnd_log.string(
3812: fnd_log.level_statement,
3813: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3814: 'get_stud_hold_effect returned F'
3815: );
3816: END IF;

Line 3820: IF fnd_log.level_statement >=

3816: END IF;
3817: ELSE
3818: IF p_loan_id IS NULL
3819: THEN
3820: IF fnd_log.level_statement >=
3821: fnd_log.g_current_runtime_level
3822: THEN
3823: fnd_log.string(
3824: fnd_log.level_statement,

Line 3821: fnd_log.g_current_runtime_level

3817: ELSE
3818: IF p_loan_id IS NULL
3819: THEN
3820: IF fnd_log.level_statement >=
3821: fnd_log.g_current_runtime_level
3822: THEN
3823: fnd_log.string(
3824: fnd_log.level_statement,
3825: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',

Line 3823: fnd_log.string(

3819: THEN
3820: IF fnd_log.level_statement >=
3821: fnd_log.g_current_runtime_level
3822: THEN
3823: fnd_log.string(
3824: fnd_log.level_statement,
3825: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3826: 'calling process_student for base_id 2'
3827: || award_std_rec.base_id

Line 3824: fnd_log.level_statement,

3820: IF fnd_log.level_statement >=
3821: fnd_log.g_current_runtime_level
3822: THEN
3823: fnd_log.string(
3824: fnd_log.level_statement,
3825: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3826: 'calling process_student for base_id 2'
3827: || award_std_rec.base_id
3828: || 'wihtout loan_id'

Line 3845: IF fnd_log.level_statement >=

3841: OPEN cur_get_awd_id(p_loan_id);
3842: FETCH cur_get_awd_id INTO get_awd_id_rec;
3843: CLOSE cur_get_awd_id;
3844:
3845: IF fnd_log.level_statement >=
3846: fnd_log.g_current_runtime_level
3847: THEN
3848: fnd_log.string(
3849: fnd_log.level_statement,

Line 3846: fnd_log.g_current_runtime_level

3842: FETCH cur_get_awd_id INTO get_awd_id_rec;
3843: CLOSE cur_get_awd_id;
3844:
3845: IF fnd_log.level_statement >=
3846: fnd_log.g_current_runtime_level
3847: THEN
3848: fnd_log.string(
3849: fnd_log.level_statement,
3850: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',

Line 3848: fnd_log.string(

3844:
3845: IF fnd_log.level_statement >=
3846: fnd_log.g_current_runtime_level
3847: THEN
3848: fnd_log.string(
3849: fnd_log.level_statement,
3850: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3851: 'calling process_student for base_id 3'
3852: || award_std_rec.base_id || 'wiht loan_id'

Line 3849: fnd_log.level_statement,

3845: IF fnd_log.level_statement >=
3846: fnd_log.g_current_runtime_level
3847: THEN
3848: fnd_log.string(
3849: fnd_log.level_statement,
3850: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3851: 'calling process_student for base_id 3'
3852: || award_std_rec.base_id || 'wiht loan_id'
3853: || p_loan_id

Line 3875: IF fnd_log.level_statement >=

3871: fnd_file.log, RPAD(' ', 10) || fnd_message.get
3872: );
3873: fnd_file.new_line(fnd_file.log, 1);
3874:
3875: IF fnd_log.level_statement >=
3876: fnd_log.g_current_runtime_level
3877: THEN
3878: fnd_log.string(
3879: fnd_log.level_statement,

Line 3876: fnd_log.g_current_runtime_level

3872: );
3873: fnd_file.new_line(fnd_file.log, 1);
3874:
3875: IF fnd_log.level_statement >=
3876: fnd_log.g_current_runtime_level
3877: THEN
3878: fnd_log.string(
3879: fnd_log.level_statement,
3880: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',

Line 3878: fnd_log.string(

3874:
3875: IF fnd_log.level_statement >=
3876: fnd_log.g_current_runtime_level
3877: THEN
3878: fnd_log.string(
3879: fnd_log.level_statement,
3880: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3881: 'end processing ' || l_person_number
3882: );

Line 3879: fnd_log.level_statement,

3875: IF fnd_log.level_statement >=
3876: fnd_log.g_current_runtime_level
3877: THEN
3878: fnd_log.string(
3879: fnd_log.level_statement,
3880: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3881: 'end processing ' || l_person_number
3882: );
3883: END IF;

Line 3896: IF fnd_log.level_statement >=

3892: fnd_file.put_line(
3893: fnd_file.log, RPAD(' ', 10) || fnd_message.get
3894: );
3895:
3896: IF fnd_log.level_statement >=
3897: fnd_log.g_current_runtime_level
3898: THEN
3899: fnd_log.string(
3900: fnd_log.level_statement,

Line 3897: fnd_log.g_current_runtime_level

3893: fnd_file.log, RPAD(' ', 10) || fnd_message.get
3894: );
3895:
3896: IF fnd_log.level_statement >=
3897: fnd_log.g_current_runtime_level
3898: THEN
3899: fnd_log.string(
3900: fnd_log.level_statement,
3901: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',

Line 3899: fnd_log.string(

3895:
3896: IF fnd_log.level_statement >=
3897: fnd_log.g_current_runtime_level
3898: THEN
3899: fnd_log.string(
3900: fnd_log.level_statement,
3901: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3902: 'unsupported fund type '
3903: || award_std_rec.fed_fund_code

Line 3900: fnd_log.level_statement,

3896: IF fnd_log.level_statement >=
3897: fnd_log.g_current_runtime_level
3898: THEN
3899: fnd_log.string(
3900: fnd_log.level_statement,
3901: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3902: 'unsupported fund type '
3903: || award_std_rec.fed_fund_code
3904: );

Line 3924: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

3920: fnd_message.set_name('IGF', 'IGF_AW_PROC_STUD');
3921: fnd_message.set_token('STDNT', l_person_number);
3922: fnd_file.put_line(fnd_file.log, RPAD(' ', 10) || fnd_message.get);
3923:
3924: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3925: THEN
3926: fnd_log.string(
3927: fnd_log.level_statement,
3928: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',

Line 3926: fnd_log.string(

3922: fnd_file.put_line(fnd_file.log, RPAD(' ', 10) || fnd_message.get);
3923:
3924: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3925: THEN
3926: fnd_log.string(
3927: fnd_log.level_statement,
3928: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3929: 'Starting processing single student ' || l_person_number
3930: );

Line 3927: fnd_log.level_statement,

3923:
3924: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3925: THEN
3926: fnd_log.string(
3927: fnd_log.level_statement,
3928: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3929: 'Starting processing single student ' || l_person_number
3930: );
3931: END IF;

Line 3946: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

3942: fnd_file.put_line(
3943: fnd_file.log, RPAD(' ', 10) || fnd_message.get
3944: );
3945:
3946: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3947: THEN
3948: fnd_log.string(
3949: fnd_log.level_statement,
3950: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',

Line 3948: fnd_log.string(

3944: );
3945:
3946: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3947: THEN
3948: fnd_log.string(
3949: fnd_log.level_statement,
3950: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3951: 'get_stud_hold_effect returned F'
3952: );

Line 3949: fnd_log.level_statement,

3945:
3946: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3947: THEN
3948: fnd_log.string(
3949: fnd_log.level_statement,
3950: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
3951: 'get_stud_hold_effect returned F'
3952: );
3953: END IF;

Line 3964: IF fnd_log.level_statement >=

3960: p_loan_id => NULL, p_disb_num => NULL,
3961: p_trans_type => p_trans_type
3962: );
3963:
3964: IF fnd_log.level_statement >=
3965: fnd_log.g_current_runtime_level
3966: THEN
3967: fnd_log.string(
3968: fnd_log.level_statement,

Line 3965: fnd_log.g_current_runtime_level

3961: p_trans_type => p_trans_type
3962: );
3963:
3964: IF fnd_log.level_statement >=
3965: fnd_log.g_current_runtime_level
3966: THEN
3967: fnd_log.string(
3968: fnd_log.level_statement,
3969: 'igf.plsql.igf_sl_rel_disb.disb_process.debug',

Line 3967: fnd_log.string(

3963:
3964: IF fnd_log.level_statement >=
3965: fnd_log.g_current_runtime_level
3966: THEN
3967: fnd_log.string(
3968: fnd_log.level_statement,
3969: 'igf.plsql.igf_sl_rel_disb.disb_process.debug',
3970: 'calling process_student for base_id 4' || p_base_id
3971: || 'without loan_id'

Line 3968: fnd_log.level_statement,

3964: IF fnd_log.level_statement >=
3965: fnd_log.g_current_runtime_level
3966: THEN
3967: fnd_log.string(
3968: fnd_log.level_statement,
3969: 'igf.plsql.igf_sl_rel_disb.disb_process.debug',
3970: 'calling process_student for base_id 4' || p_base_id
3971: || 'without loan_id'
3972: );

Line 3980: IF fnd_log.level_statement >=

3976: OPEN cur_get_awd_id(p_loan_id);
3977: FETCH cur_get_awd_id INTO get_awd_id_rec;
3978: CLOSE cur_get_awd_id;
3979:
3980: IF fnd_log.level_statement >=
3981: fnd_log.g_current_runtime_level
3982: THEN
3983: fnd_log.string(
3984: fnd_log.level_statement,

Line 3981: fnd_log.g_current_runtime_level

3977: FETCH cur_get_awd_id INTO get_awd_id_rec;
3978: CLOSE cur_get_awd_id;
3979:
3980: IF fnd_log.level_statement >=
3981: fnd_log.g_current_runtime_level
3982: THEN
3983: fnd_log.string(
3984: fnd_log.level_statement,
3985: 'igf.plsql.igf_sl_rel_disb.disb_process.debug',

Line 3983: fnd_log.string(

3979:
3980: IF fnd_log.level_statement >=
3981: fnd_log.g_current_runtime_level
3982: THEN
3983: fnd_log.string(
3984: fnd_log.level_statement,
3985: 'igf.plsql.igf_sl_rel_disb.disb_process.debug',
3986: 'calling process_student for base_id 5' || p_base_id
3987: || 'with loan_id' || p_loan_id

Line 3984: fnd_log.level_statement,

3980: IF fnd_log.level_statement >=
3981: fnd_log.g_current_runtime_level
3982: THEN
3983: fnd_log.string(
3984: fnd_log.level_statement,
3985: 'igf.plsql.igf_sl_rel_disb.disb_process.debug',
3986: 'calling process_student for base_id 5' || p_base_id
3987: || 'with loan_id' || p_loan_id
3988: );

Line 4007: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level

4003: fnd_message.set_token('PER_NUM', l_person_number);
4004: fnd_file.put_line(fnd_file.log, RPAD(' ', 10) || fnd_message.get);
4005: fnd_file.new_line(fnd_file.log, 1);
4006:
4007: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
4008: THEN
4009: fnd_log.string(
4010: fnd_log.level_statement,
4011: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',

Line 4009: fnd_log.string(

4005: fnd_file.new_line(fnd_file.log, 1);
4006:
4007: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
4008: THEN
4009: fnd_log.string(
4010: fnd_log.level_statement,
4011: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
4012: 'end processing ' || l_person_number
4013: );

Line 4010: fnd_log.level_statement,

4006:
4007: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
4008: THEN
4009: fnd_log.string(
4010: fnd_log.level_statement,
4011: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',
4012: 'end processing ' || l_person_number
4013: );
4014: END IF;