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 IGF_SL_REL_DISB

Line 1: PACKAGE BODY igf_sl_rel_disb AS

1: PACKAGE BODY igf_sl_rel_disb AS
2: /* $Header: IGFSL27B.pls 120.8 2006/08/10 16:32:01 museshad noship $ */
3:
4: /*
5: || Created By : pssahni

Line 67: fnd_message.set_token('NAME', 'IGF_SL_REL_DISB.GET_FUND_DESC ' || SQLERRM);

63: EXCEPTION
64: WHEN OTHERS
65: THEN
66: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
67: fnd_message.set_token('NAME', 'IGF_SL_REL_DISB.GET_FUND_DESC ' || SQLERRM);
68: fnd_file.put_line(fnd_file.log, SQLERRM);
69: igs_ge_msg_stack.ADD;
70: app_exception.raise_exception;
71: END get_fund_desc;

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 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 163: 'NAME', 'igf_sl_rel_disb.chk_attendance' || SQLERRM

159: WHEN OTHERS
160: THEN
161: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
162: fnd_message.set_token(
163: 'NAME', 'igf_sl_rel_disb.chk_attendance' || SQLERRM
164: );
165: fnd_file.put_line(fnd_file.log, SQLERRM);
166: igs_ge_msg_stack.ADD;
167: app_exception.raise_exception;

Line 229: 'NAME', 'IGF_SL_REL_DISB.CHK_FED_ELIG ' || SQLERRM

225: WHEN OTHERS
226: THEN
227: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
228: fnd_message.set_token(
229: 'NAME', 'IGF_SL_REL_DISB.CHK_FED_ELIG ' || SQLERRM
230: );
231: fnd_file.put_line(fnd_file.log, SQLERRM);
232: igs_ge_msg_stack.ADD;
233: app_exception.raise_exception;

Line 271: 'NAME', 'IGF_SL_REL_DISB.CHK_FED_ELIG ' || SQLERRM

267: WHEN OTHERS
268: THEN
269: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
270: fnd_message.set_token(
271: 'NAME', 'IGF_SL_REL_DISB.CHK_FED_ELIG ' || SQLERRM
272: );
273: fnd_file.put_line(fnd_file.log, SQLERRM);
274: igs_ge_msg_stack.ADD;
275: app_exception.raise_exception;

Line 330: fnd_message.set_token('NAME', 'IGF_SL_REL_DISB.PER_IN_FA ' || SQLERRM);

326: EXCEPTION
327: WHEN OTHERS
328: THEN
329: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
330: fnd_message.set_token('NAME', 'IGF_SL_REL_DISB.PER_IN_FA ' || SQLERRM);
331: fnd_file.put_line(fnd_file.log, SQLERRM);
332: igs_ge_msg_stack.ADD;
333: app_exception.raise_exception;
334: END per_in_fa;

Line 510: fnd_message.set_token('NAME', 'IGF_SL_REL_DISB.LOG_PARAMETERS');

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');
511: igs_ge_msg_stack.ADD;
512: END log_parameters;
513:
514: FUNCTION chk_fund_meth_dl(

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 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 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 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 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 819: 'NAME', 'IGF_SL_REL_DISB.CHK_CREDIT_STATUS ' || SQLERRM

815: WHEN OTHERS
816: THEN
817: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
818: fnd_message.set_token(
819: 'NAME', 'IGF_SL_REL_DISB.CHK_CREDIT_STATUS ' || SQLERRM
820: );
821: fnd_file.put_line(fnd_file.log, SQLERRM);
822: igs_ge_msg_stack.ADD;
823: app_exception.raise_exception;

Line 995: 'NAME', 'IGF_SL_REL_DISB.CHK_TODO_RESULT ' || SQLERRM

991: WHEN OTHERS
992: THEN
993: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
994: fnd_message.set_token(
995: 'NAME', 'IGF_SL_REL_DISB.CHK_TODO_RESULT ' || SQLERRM
996: );
997: fnd_file.put_line(fnd_file.log, SQLERRM);
998: igs_ge_msg_stack.ADD;
999: app_exception.raise_exception;

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 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 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 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 1123: 'NAME', 'IGF_SL_REL_DISB.INSERT_PAYS_PRG_UTS ' || SQLERRM

1119: WHEN OTHERS
1120: THEN
1121: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
1122: fnd_message.set_token(
1123: 'NAME', 'IGF_SL_REL_DISB.INSERT_PAYS_PRG_UTS ' || SQLERRM
1124: );
1125: fnd_file.put_line(fnd_file.log, SQLERRM);
1126: igs_ge_msg_stack.ADD;
1127: app_exception.raise_exception;

Line 1444: 'NAME', 'IGF_SL_REL_DISB.DELETE_PAYS ' || SQLERRM

1440: WHEN OTHERS
1441: THEN
1442: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
1443: fnd_message.set_token(
1444: 'NAME', 'IGF_SL_REL_DISB.DELETE_PAYS ' || SQLERRM
1445: );
1446: fnd_file.put_line(fnd_file.log, SQLERRM);
1447: igs_ge_msg_stack.ADD;
1448: app_exception.raise_exception;

Line 1489: 'NAME', 'IGF_SL_REL_DISB.DELETE_PAYS ' || SQLERRM

1485: WHEN OTHERS
1486: THEN
1487: fnd_message.set_name('IGF', 'IGF_GE_UNHANDLED_EXP');
1488: fnd_message.set_token(
1489: 'NAME', 'IGF_SL_REL_DISB.DELETE_PAYS ' || SQLERRM
1490: );
1491: fnd_file.put_line(fnd_file.log, SQLERRM);
1492: igs_ge_msg_stack.ADD;
1493: app_exception.raise_exception;

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 2281: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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

Line 2308: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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;
2312: ELSIF cur_get_loans%FOUND

Line 2333: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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: );
2337: 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 2374: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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: );
2378: END IF;

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 2406: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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
2410: fnd_log.string(

Line 2412: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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;
2416: END IF;

Line 2443: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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;
2447: ELSE

Line 2453: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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;
2457: END IF;

Line 2483: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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: );
2487: END IF;

Line 2507: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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: );
2511: END IF;

Line 2544: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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(
2548: fnd_log.level_statement,

Line 2549: '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(
2553: fnd_log.level_statement,

Line 2554: '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(
2558: fnd_log.level_statement,

Line 2559: '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: );
2563: END IF;

Line 2610: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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
2614: fnd_log.string(

Line 2616: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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

Line 2625: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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
2629: fnd_log.string(

Line 2631: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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;
2635: END IF;

Line 2656: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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: );
2660: END IF;

Line 2676: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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

Line 2696: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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;
2700: ELSE

Line 2706: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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;
2710: END IF;

Line 2717: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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;
2721: END IF; -- (IF awd_disb_rec.min_credit_pts IS NOT NULL )

Line 2762: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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

Line 2778: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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;
2782: ELSE

Line 2788: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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;
2792: END IF;

Line 2813: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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

Line 2828: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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;
2832: ELSIF NOT l_fund_meth_result

Line 2847: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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;
2851: ELSE

Line 2857: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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;
2861: END IF;

Line 2889: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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;
2893: ELSE

Line 2909: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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;
2913: END IF;

Line 2929: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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;
2933: ELSE

Line 2939: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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;
2943: END IF;

Line 2954: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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(
2958: fnd_log.level_statement,

Line 2959: '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:
2963: IF NOT l_pays_prg

Line 2967: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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

Line 2976: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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

Line 2985: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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

Line 2994: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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

Line 3003: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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

Line 3012: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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

Line 3021: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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

Line 3030: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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

Line 3039: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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

Line 3048: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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;
3052: END IF;

Line 3072: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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: );
3076: END IF;

Line 3096: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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: );
3100: END IF;

Line 3119: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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: );
3123: END IF;

Line 3137: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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;
3141: ELSIF l_fund_type = 'F' AND p_trans_type IS NOT NULL

Line 3151: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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;
3155: ELSIF l_fund_type = 'F' AND p_trans_type IS NULL

Line 3165: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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;
3169: ELSE

Line 3175: 'igf.plsql.igf_sl_rel_disb.process_student.debug',

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

Line 3407: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',

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(
3411: fnd_log.level_statement,

Line 3412: 'igf.plsql.igf_sl_rel_disb.rel_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(
3416: fnd_log.level_statement,

Line 3417: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug', 'p_fund_id:'

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(
3421: fnd_log.level_statement,

Line 3422: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug', 'p_base_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(
3426: fnd_log.level_statement,

Line 3427: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug', 'p_loan_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(
3431: fnd_log.level_statement,

Line 3432: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',

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(
3436: fnd_log.level_statement,

Line 3437: '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;
3441:

Line 3484: fnd_message.set_name('IGF', 'IGF_SL_REL_DISB_PARAM_EX');

3480:
3481: IF l_ci_cal_type IS NULL OR l_ci_sequence_number IS NULL
3482: OR p_fund_id IS NULL
3483: THEN
3484: fnd_message.set_name('IGF', 'IGF_SL_REL_DISB_PARAM_EX');
3485: fnd_file.new_line(fnd_file.log, 2);
3486: fnd_file.put_line(fnd_file.log, fnd_message.get);
3487: fnd_file.new_line(fnd_file.log, 2);
3488: RAISE param_exception;

Line 3498: fnd_message.set_name('IGF', 'IGF_SL_REL_DISB_PARAM_EX');

3494: THEN
3495: -- If Person ID Group is specified then cannot specify values for Person Number or Loan number
3496: IF p_base_id IS NOT NULL OR p_loan_id IS NOT NULL
3497: THEN
3498: fnd_message.set_name('IGF', 'IGF_SL_REL_DISB_PARAM_EX');
3499: fnd_file.new_line(fnd_file.log, 2);
3500: fnd_file.put_line(fnd_file.log, fnd_message.get);
3501: fnd_file.new_line(fnd_file.log, 2);
3502: RAISE param_exception;

Line 3512: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',

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

Line 3543: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',

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;
3547: ELSE

Line 3563: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',

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

Line 3593: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',

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

Line 3617: 'igf.plsql.igf_sl_rel_disb.disb_process.debug',

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;
3621: ELSE

Line 3627: 'igf.plsql.igf_sl_rel_disb.disb_process.debug',

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: );
3631: END IF;

Line 3654: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',

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;
3658: ELSE -- l_base_id IS NULL THEN

Line 3675: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',

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: );
3679: END IF;

Line 3711: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',

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

Line 3731: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',

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;
3735: ELSE

Line 3741: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',

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: );
3745: END IF;

Line 3757: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',

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: );
3761: END IF;

Line 3772: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',

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

Line 3788: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',

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

Line 3813: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',

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;
3817: ELSE

Line 3825: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',

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'
3829: );

Line 3850: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',

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
3854: );

Line 3880: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',

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

Line 3901: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',

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: );
3905: END IF;

Line 3910: fnd_message.set_name('IGF', 'IGF_SL_REL_DISB_PARAM_EX');

3906: END IF; -- (IF award_std_rec.fed_fund_code NOT IN ('FWS','SPNSR','PRK'))
3907: END IF; -- (IF cur_award_std%NOTFOUND)
3908: ELSE
3909: -- Fund Id is NULL so raise error
3910: fnd_message.set_name('IGF', 'IGF_SL_REL_DISB_PARAM_EX');
3911: fnd_file.new_line(fnd_file.log, 2);
3912: fnd_file.put_line(fnd_file.log, fnd_message.get);
3913: fnd_file.new_line(fnd_file.log, 2);
3914: RAISE param_exception;

Line 3928: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',

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

Line 3950: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',

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;
3954: ELSE

Line 3969: 'igf.plsql.igf_sl_rel_disb.disb_process.debug',

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: );
3973: END IF;

Line 3985: 'igf.plsql.igf_sl_rel_disb.disb_process.debug',

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: );
3989: END IF;

Line 4011: 'igf.plsql.igf_sl_rel_disb.rel_disb_process.debug',

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;
4015: END IF; -- (IF p_base_id IS NULL)

Line 4027: fnd_message.set_name('IGF', 'IGF_SL_REL_DISB_PARAM_EX');

4023: WHEN param_exception
4024: THEN
4025: ROLLBACK;
4026: p_retcode := 2;
4027: fnd_message.set_name('IGF', 'IGF_SL_REL_DISB_PARAM_EX');
4028: igs_ge_msg_stack.ADD;
4029: igs_ge_msg_stack.conc_exception_hndl;
4030: WHEN app_exception.record_lock_exception
4031: THEN

Line 4046: END igf_sl_rel_disb;

4042: fnd_file.put_line(fnd_file.log, SQLERRM);
4043: igs_ge_msg_stack.ADD;
4044: p_errbuf := fnd_message.get;
4045: END rel_disb_process;
4046: END igf_sl_rel_disb;