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

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

101: lv_data_reqd := 'DATA_REQD';
102: lv_data_recomm := 'DATA_RECOMM';
103:
104: IF p_field_name LIKE '%ADDR%' THEN
105: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
106: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.check_for_reqd.debug','p_field_name = ' ||p_field_name);
107: END IF;
108: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
109: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.check_for_reqd.debug','p_field_value = ' ||p_field_value);

Line 106: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.check_for_reqd.debug','p_field_name = ' ||p_field_name);

102: lv_data_recomm := 'DATA_RECOMM';
103:
104: IF p_field_name LIKE '%ADDR%' THEN
105: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
106: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.check_for_reqd.debug','p_field_name = ' ||p_field_name);
107: END IF;
108: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
109: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.check_for_reqd.debug','p_field_value = ' ||p_field_value);
110: END IF;

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

104: IF p_field_name LIKE '%ADDR%' THEN
105: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
106: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.check_for_reqd.debug','p_field_name = ' ||p_field_name);
107: END IF;
108: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
109: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.check_for_reqd.debug','p_field_value = ' ||p_field_value);
110: END IF;
111: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
112: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.check_for_reqd.debug','p_dl_version = ' ||p_dl_version);

Line 109: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.check_for_reqd.debug','p_field_value = ' ||p_field_value);

105: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
106: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.check_for_reqd.debug','p_field_name = ' ||p_field_name);
107: END IF;
108: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
109: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.check_for_reqd.debug','p_field_value = ' ||p_field_value);
110: END IF;
111: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
112: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.check_for_reqd.debug','p_dl_version = ' ||p_dl_version);
113: END IF;

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

107: END IF;
108: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
109: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.check_for_reqd.debug','p_field_value = ' ||p_field_value);
110: END IF;
111: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
112: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.check_for_reqd.debug','p_dl_version = ' ||p_dl_version);
113: END IF;
114: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
115: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.check_for_reqd.debug','p_loan_catg = ' ||p_loan_catg);

Line 112: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.check_for_reqd.debug','p_dl_version = ' ||p_dl_version);

108: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
109: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.check_for_reqd.debug','p_field_value = ' ||p_field_value);
110: END IF;
111: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
112: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.check_for_reqd.debug','p_dl_version = ' ||p_dl_version);
113: END IF;
114: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
115: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.check_for_reqd.debug','p_loan_catg = ' ||p_loan_catg);
116: END IF;

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

110: END IF;
111: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
112: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.check_for_reqd.debug','p_dl_version = ' ||p_dl_version);
113: END IF;
114: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
115: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.check_for_reqd.debug','p_loan_catg = ' ||p_loan_catg);
116: END IF;
117: END IF;
118:

Line 115: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.check_for_reqd.debug','p_loan_catg = ' ||p_loan_catg);

111: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
112: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.check_for_reqd.debug','p_dl_version = ' ||p_dl_version);
113: END IF;
114: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
115: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.check_for_reqd.debug','p_loan_catg = ' ||p_loan_catg);
116: END IF;
117: END IF;
118:
119: IF TRIM(p_field_value) IS NULL THEN

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

222: l_course_type,
223: l_dl_std_code,
224: l_cl_std_code);
225:
226: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
227: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.get_system_grade_level.debug','System Grade Level is : ' || l_dl_std_code || ' - ' || igf_aw_gen.lookup_desc('IGF_AP_GRADE_LEVEL',l_dl_std_code ));
228: END IF;
229:
230: RETURN l_dl_std_code;

Line 227: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.get_system_grade_level.debug','System Grade Level is : ' || l_dl_std_code || ' - ' || igf_aw_gen.lookup_desc('IGF_AP_GRADE_LEVEL',l_dl_std_code ));

223: l_dl_std_code,
224: l_cl_std_code);
225:
226: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
227: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.get_system_grade_level.debug','System Grade Level is : ' || l_dl_std_code || ' - ' || igf_aw_gen.lookup_desc('IGF_AP_GRADE_LEVEL',l_dl_std_code ));
228: END IF;
229:
230: RETURN l_dl_std_code;
231:

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

257: l_dist_plan_rec c_get_dist_plan%ROWTYPE;
258:
259: BEGIN
260: -- Log IN parameters
261: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
262: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.loan_limit_validation.debug','IN Param p_base_id= ' ||p_base_id);
263: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.loan_limit_validation.debug','IN Param p_fund_type= ' ||p_fund_type);
264: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.loan_limit_validation.debug','IN Param p_award_id= ' ||p_award_id);
265: END IF;

Line 262: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.loan_limit_validation.debug','IN Param p_base_id= ' ||p_base_id);

258:
259: BEGIN
260: -- Log IN parameters
261: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
262: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.loan_limit_validation.debug','IN Param p_base_id= ' ||p_base_id);
263: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.loan_limit_validation.debug','IN Param p_fund_type= ' ||p_fund_type);
264: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.loan_limit_validation.debug','IN Param p_award_id= ' ||p_award_id);
265: END IF;
266:

Line 263: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.loan_limit_validation.debug','IN Param p_fund_type= ' ||p_fund_type);

259: BEGIN
260: -- Log IN parameters
261: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
262: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.loan_limit_validation.debug','IN Param p_base_id= ' ||p_base_id);
263: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.loan_limit_validation.debug','IN Param p_fund_type= ' ||p_fund_type);
264: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.loan_limit_validation.debug','IN Param p_award_id= ' ||p_award_id);
265: END IF;
266:
267: l_aid := 0;

Line 264: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.loan_limit_validation.debug','IN Param p_award_id= ' ||p_award_id);

260: -- Log IN parameters
261: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
262: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.loan_limit_validation.debug','IN Param p_base_id= ' ||p_base_id);
263: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.loan_limit_validation.debug','IN Param p_fund_type= ' ||p_fund_type);
264: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.loan_limit_validation.debug','IN Param p_award_id= ' ||p_award_id);
265: END IF;
266:
267: l_aid := 0;
268: p_msg_name := NULL;

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

270: OPEN c_get_dist_plan(p_award_id);
271: FETCH c_get_dist_plan INTO l_dist_plan_rec;
272: CLOSE c_get_dist_plan;
273:
274: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
275: fnd_log.string(fnd_log.level_statement,
276: 'igf.plsql.igf_sl_dl_validation.loan_limit_validation.debug',
277: 'Calling check_loan_limits() with parameters l_base_id/fund_type/l_award_id/l_adplans_id/ ' ||p_base_id|| '/' ||p_fund_type|| '/' ||p_award_id|| '/' ||l_dist_plan_rec.adplans_id);
278: END IF;

Line 275: fnd_log.string(fnd_log.level_statement,

271: FETCH c_get_dist_plan INTO l_dist_plan_rec;
272: CLOSE c_get_dist_plan;
273:
274: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
275: fnd_log.string(fnd_log.level_statement,
276: 'igf.plsql.igf_sl_dl_validation.loan_limit_validation.debug',
277: 'Calling check_loan_limits() with parameters l_base_id/fund_type/l_award_id/l_adplans_id/ ' ||p_base_id|| '/' ||p_fund_type|| '/' ||p_award_id|| '/' ||l_dist_plan_rec.adplans_id);
278: END IF;
279:

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

288: l_awd_period => NULL,
289: l_called_from => 'NON-PACKAGING'
290: );
291:
292: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
293: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.loan_limit_validation.debug','check_loan_limits() returned with message ' ||p_msg_name);
294: END IF;
295: END loan_limit_validation;
296:

Line 293: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.loan_limit_validation.debug','check_loan_limits() returned with message ' ||p_msg_name);

289: l_called_from => 'NON-PACKAGING'
290: );
291:
292: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
293: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.loan_limit_validation.debug','check_loan_limits() returned with message ' ||p_msg_name);
294: END IF;
295: END loan_limit_validation;
296:
297: /* MAIN PROCEDURE */

Line 519: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

515: CLOSE parent_dtl_cur;
516:
517: -- PUT THE DEBUGGING LOG MESSAGES
518:
519: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
520: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_validation.dl_lar_validate.debug','loan_number passed to igf_sl_dl_record.get_acad_cal_dtls:'|| orec.loan_number);
521: END IF;
522:
523: -- Get the Academic Year Start and End Dates for this Award Year

Line 520: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_validation.dl_lar_validate.debug','loan_number passed to igf_sl_dl_record.get_acad_cal_dtls:'|| orec.loan_number);

516:
517: -- PUT THE DEBUGGING LOG MESSAGES
518:
519: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
520: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_validation.dl_lar_validate.debug','loan_number passed to igf_sl_dl_record.get_acad_cal_dtls:'|| orec.loan_number);
521: END IF;
522:
523: -- Get the Academic Year Start and End Dates for this Award Year
524: -- masehgal # 2593215 removed begin/end dates fetching functions

Line 538: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

534: -- If lv_message is null then it implies that acad year was found ....
535: -- We will log that as an error code in processing below where we chk if acad_dates are null and
536: -- report appropriate error code.
537:
538: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
539: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_validation.dl_lar_validate.debug','lv_message got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_message);
540: END IF;
541: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
542: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_validation.dl_lar_validate.debug','lv_acad_begin_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_acad_begin_date);

Line 539: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_validation.dl_lar_validate.debug','lv_message got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_message);

535: -- We will log that as an error code in processing below where we chk if acad_dates are null and
536: -- report appropriate error code.
537:
538: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
539: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_validation.dl_lar_validate.debug','lv_message got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_message);
540: END IF;
541: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
542: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_validation.dl_lar_validate.debug','lv_acad_begin_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_acad_begin_date);
543: END IF;

Line 541: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

537:
538: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
539: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_validation.dl_lar_validate.debug','lv_message got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_message);
540: END IF;
541: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
542: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_validation.dl_lar_validate.debug','lv_acad_begin_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_acad_begin_date);
543: END IF;
544: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
545: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_validation.dl_lar_validate.debug','lv_acad_end_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_acad_end_date);

Line 542: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_validation.dl_lar_validate.debug','lv_acad_begin_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_acad_begin_date);

538: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
539: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_validation.dl_lar_validate.debug','lv_message got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_message);
540: END IF;
541: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
542: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_validation.dl_lar_validate.debug','lv_acad_begin_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_acad_begin_date);
543: END IF;
544: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
545: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_validation.dl_lar_validate.debug','lv_acad_end_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_acad_end_date);
546: END IF;

Line 544: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

540: END IF;
541: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
542: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_validation.dl_lar_validate.debug','lv_acad_begin_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_acad_begin_date);
543: END IF;
544: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
545: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_validation.dl_lar_validate.debug','lv_acad_end_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_acad_end_date);
546: END IF;
547: lv_complete := TRUE;
548:

Line 545: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_validation.dl_lar_validate.debug','lv_acad_end_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_acad_end_date);

541: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
542: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_validation.dl_lar_validate.debug','lv_acad_begin_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_acad_begin_date);
543: END IF;
544: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
545: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'igf.plsql.igf_sl_dl_validation.dl_lar_validate.debug','lv_acad_end_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_acad_end_date);
546: END IF;
547: lv_complete := TRUE;
548:
549: -- Delete records from Edit Report table, with type="V" (VALIDATION) for this Loan#

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

622: /*
623: -- Validate grade level (bug 4346421)
624: -- get System Grade Level, compare with NVL(override_grade_level_code, grade_level_code). If not matching, then log mesg.
625: l_dl_std_code := get_system_grade_level(orec.base_id, orec.loan_per_begin_date, orec.loan_per_end_date);
626: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
627: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.dl_lar_validate.debug','l_dl_std_code got from get_system_grade_level function :'|| l_dl_std_code);
628: END IF;
629:
630: IF (orec.override_grade_level_code IS NOT NULL) THEN

Line 627: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.dl_lar_validate.debug','l_dl_std_code got from get_system_grade_level function :'|| l_dl_std_code);

623: -- Validate grade level (bug 4346421)
624: -- get System Grade Level, compare with NVL(override_grade_level_code, grade_level_code). If not matching, then log mesg.
625: l_dl_std_code := get_system_grade_level(orec.base_id, orec.loan_per_begin_date, orec.loan_per_end_date);
626: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
627: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.dl_lar_validate.debug','l_dl_std_code got from get_system_grade_level function :'|| l_dl_std_code);
628: END IF;
629:
630: IF (orec.override_grade_level_code IS NOT NULL) THEN
631: IF (orec.override_grade_level_code <> l_dl_std_code) THEN

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

754:
755: igf_sl_edit.insert_edit(orec.loan_number, 'V', 'IGF_SL_ERR_CODES', lv_lookup_code, NULL, NULL);
756:
757: -- Log
758: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
759: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.dl_lar_validate.debug','Stafford loan limit validation for award_id ' ||orec.award_id|| ' FAILED with message: ' ||lv_msg_name);
760: END IF;
761: ELSE
762: -- Stafford loan limit validation PASSED

Line 759: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.dl_lar_validate.debug','Stafford loan limit validation for award_id ' ||orec.award_id|| ' FAILED with message: ' ||lv_msg_name);

755: igf_sl_edit.insert_edit(orec.loan_number, 'V', 'IGF_SL_ERR_CODES', lv_lookup_code, NULL, NULL);
756:
757: -- Log
758: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
759: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.dl_lar_validate.debug','Stafford loan limit validation for award_id ' ||orec.award_id|| ' FAILED with message: ' ||lv_msg_name);
760: END IF;
761: ELSE
762: -- Stafford loan limit validation PASSED
763: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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

759: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.dl_lar_validate.debug','Stafford loan limit validation for award_id ' ||orec.award_id|| ' FAILED with message: ' ||lv_msg_name);
760: END IF;
761: ELSE
762: -- Stafford loan limit validation PASSED
763: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
764: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.dl_lar_validate.debug','Stafford loan limit validation PASSED for award_id ' ||orec.award_id);
765: END IF;
766: END IF;
767: END IF;

Line 764: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.dl_lar_validate.debug','Stafford loan limit validation PASSED for award_id ' ||orec.award_id);

760: END IF;
761: ELSE
762: -- Stafford loan limit validation PASSED
763: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
764: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.dl_lar_validate.debug','Stafford loan limit validation PASSED for award_id ' ||orec.award_id);
765: END IF;
766: END IF;
767: END IF;
768: -- museshad (Bug 4116399)

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

944: BEGIN
945:
946: BEGIN
947: p_dl_version := igf_sl_gen.get_dl_version(p_loan_rec.ci_cal_type, p_loan_rec.ci_sequence_number);
948: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
949: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','p_dl_version '|| p_dl_version );
950: END IF;
951: EXCEPTION
952: WHEN NO_DATA_FOUND THEN

Line 949: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','p_dl_version '|| p_dl_version );

945:
946: BEGIN
947: p_dl_version := igf_sl_gen.get_dl_version(p_loan_rec.ci_cal_type, p_loan_rec.ci_sequence_number);
948: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
949: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','p_dl_version '|| p_dl_version );
950: END IF;
951: EXCEPTION
952: WHEN NO_DATA_FOUND THEN
953: fnd_message.set_name('IGF','IGF_SL_NO_DL_SETUP');

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

951: EXCEPTION
952: WHEN NO_DATA_FOUND THEN
953: fnd_message.set_name('IGF','IGF_SL_NO_DL_SETUP');
954: fnd_file.put_line(fnd_file.log,fnd_message.get);
955: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
956: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','Setup gone ' );
957: END IF;
958: RAISE NO_DATA_FOUND;
959: END;

Line 956: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','Setup gone ' );

952: WHEN NO_DATA_FOUND THEN
953: fnd_message.set_name('IGF','IGF_SL_NO_DL_SETUP');
954: fnd_file.put_line(fnd_file.log,fnd_message.get);
955: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
956: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','Setup gone ' );
957: END IF;
958: RAISE NO_DATA_FOUND;
959: END;
960:

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

985: lv_acad_end_date,
986: lv_message );
987: END IF;
988:
989: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
990: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','lv_message got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_message);
991: END IF;
992: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
993: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','lv_acad_begin_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_acad_begin_date);

Line 990: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','lv_message got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_message);

986: lv_message );
987: END IF;
988:
989: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
990: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','lv_message got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_message);
991: END IF;
992: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
993: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','lv_acad_begin_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_acad_begin_date);
994: END IF;

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

988:
989: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
990: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','lv_message got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_message);
991: END IF;
992: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
993: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','lv_acad_begin_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_acad_begin_date);
994: END IF;
995: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
996: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','lv_acad_end_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_acad_end_date);

Line 993: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','lv_acad_begin_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_acad_begin_date);

989: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
990: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','lv_message got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_message);
991: END IF;
992: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
993: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','lv_acad_begin_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_acad_begin_date);
994: END IF;
995: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
996: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','lv_acad_end_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_acad_end_date);
997: END IF;

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

991: END IF;
992: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
993: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','lv_acad_begin_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_acad_begin_date);
994: END IF;
995: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
996: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','lv_acad_end_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_acad_end_date);
997: END IF;
998:
999: igf_sl_gen.get_person_details(igf_gr_gen.get_person_id(p_loan_rec.base_id),student_dtl_cur);

Line 996: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','lv_acad_end_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_acad_end_date);

992: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
993: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','lv_acad_begin_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_acad_begin_date);
994: END IF;
995: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
996: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','lv_acad_end_date got from igf_sl_dl_record.get_acad_cal_dtls:'|| lv_acad_end_date);
997: END IF;
998:
999: igf_sl_gen.get_person_details(igf_gr_gen.get_person_id(p_loan_rec.base_id),student_dtl_cur);
1000: FETCH student_dtl_cur INTO student_dtl_rec;

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

1008: lv_s_depncy_status := NULL;
1009: lv_s_citizenship_status := NULL;
1010: lv_s_depncy_status := isir_info_rec.dependency_status;
1011: lv_s_citizenship_status := student_dtl_rec.p_citizenship_status;
1012: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1013: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','lv_s_citizenship_status '|| lv_s_citizenship_status);
1014: END IF;
1015:
1016: p_isir_ssn := isir_info_rec.current_ssn;

Line 1013: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','lv_s_citizenship_status '|| lv_s_citizenship_status);

1009: lv_s_citizenship_status := NULL;
1010: lv_s_depncy_status := isir_info_rec.dependency_status;
1011: lv_s_citizenship_status := student_dtl_rec.p_citizenship_status;
1012: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1013: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','lv_s_citizenship_status '|| lv_s_citizenship_status);
1014: END IF;
1015:
1016: p_isir_ssn := isir_info_rec.current_ssn;
1017: p_isir_dob := isir_info_rec.date_of_birth;

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

1025: set_complete_status(check_for_reqd(p_loan_rec.loan_number,'DL_STAFFORD','S_SSN', student_dtl_rec.p_ssn));
1026: set_complete_status(check_for_reqd(p_loan_rec.loan_number,'DL_STAFFORD','S_FIRST_NAME', student_dtl_rec.p_first_name));
1027: set_complete_status(check_for_reqd(p_loan_rec.loan_number,'DL_STAFFORD','S_LAST_NAME', student_dtl_rec.p_last_name));
1028: set_complete_status(check_for_reqd(p_loan_rec.loan_number,'DL_STAFFORD','S_PERMT_ADDR1', student_dtl_rec.p_permt_addr1));
1029: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1030: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','S_PERMT_ADDR1 = ' ||student_dtl_rec.p_permt_addr1);
1031: END IF;
1032: set_complete_status(check_for_reqd(p_loan_rec.loan_number,'DL_STAFFORD','S_PERMT_CITY', student_dtl_rec.p_permt_city));
1033: set_complete_status(check_for_reqd(p_loan_rec.loan_number,'DL_STAFFORD','S_PERMT_STATE', student_dtl_rec.p_permt_state));

Line 1030: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','S_PERMT_ADDR1 = ' ||student_dtl_rec.p_permt_addr1);

1026: set_complete_status(check_for_reqd(p_loan_rec.loan_number,'DL_STAFFORD','S_FIRST_NAME', student_dtl_rec.p_first_name));
1027: set_complete_status(check_for_reqd(p_loan_rec.loan_number,'DL_STAFFORD','S_LAST_NAME', student_dtl_rec.p_last_name));
1028: set_complete_status(check_for_reqd(p_loan_rec.loan_number,'DL_STAFFORD','S_PERMT_ADDR1', student_dtl_rec.p_permt_addr1));
1029: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1030: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','S_PERMT_ADDR1 = ' ||student_dtl_rec.p_permt_addr1);
1031: END IF;
1032: set_complete_status(check_for_reqd(p_loan_rec.loan_number,'DL_STAFFORD','S_PERMT_CITY', student_dtl_rec.p_permt_city));
1033: set_complete_status(check_for_reqd(p_loan_rec.loan_number,'DL_STAFFORD','S_PERMT_STATE', student_dtl_rec.p_permt_state));
1034: set_complete_status(check_for_reqd(p_loan_rec.loan_number,'DL_STAFFORD','S_PERMT_ZIP', student_dtl_rec.p_permt_zip));

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

1058: set_complete_status(check_for_reqd(p_loan_rec.loan_number,'DL_PLUS','P_SSN' , parent_dtl_rec.p_ssn));
1059: set_complete_status(check_for_reqd(p_loan_rec.loan_number,'DL_PLUS','P_FIRST_NAME' , parent_dtl_rec.p_first_name));
1060: set_complete_status(check_for_reqd(p_loan_rec.loan_number,'DL_PLUS','P_LAST_NAME' , parent_dtl_rec.p_last_name));
1061: set_complete_status(check_for_reqd(p_loan_rec.loan_number,'DL_PLUS','P_PERMT_ADDR1', parent_dtl_rec.p_permt_addr1));
1062: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1063: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','P_PERMT_ADDR1 = ' ||parent_dtl_rec.p_permt_addr1);
1064: END IF;
1065: set_complete_status(check_for_reqd(p_loan_rec.loan_number,'DL_PLUS','P_PERMT_CITY', parent_dtl_rec.p_permt_city));
1066: set_complete_status(check_for_reqd(p_loan_rec.loan_number,'DL_PLUS','P_PERMT_STATE', parent_dtl_rec.p_permt_state));

Line 1063: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','P_PERMT_ADDR1 = ' ||parent_dtl_rec.p_permt_addr1);

1059: set_complete_status(check_for_reqd(p_loan_rec.loan_number,'DL_PLUS','P_FIRST_NAME' , parent_dtl_rec.p_first_name));
1060: set_complete_status(check_for_reqd(p_loan_rec.loan_number,'DL_PLUS','P_LAST_NAME' , parent_dtl_rec.p_last_name));
1061: set_complete_status(check_for_reqd(p_loan_rec.loan_number,'DL_PLUS','P_PERMT_ADDR1', parent_dtl_rec.p_permt_addr1));
1062: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1063: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','P_PERMT_ADDR1 = ' ||parent_dtl_rec.p_permt_addr1);
1064: END IF;
1065: set_complete_status(check_for_reqd(p_loan_rec.loan_number,'DL_PLUS','P_PERMT_CITY', parent_dtl_rec.p_permt_city));
1066: set_complete_status(check_for_reqd(p_loan_rec.loan_number,'DL_PLUS','P_PERMT_STATE', parent_dtl_rec.p_permt_state));
1067: set_complete_status(check_for_reqd(p_loan_rec.loan_number,'DL_PLUS','P_PERMT_ZIP', parent_dtl_rec.p_permt_zip));

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

1072: set_complete_status(check_for_reqd(p_loan_rec.loan_number,'DL_PLUS','S_SSN', student_dtl_rec.p_ssn));
1073: set_complete_status(check_for_reqd(p_loan_rec.loan_number,'DL_PLUS','S_FIRST_NAME', student_dtl_rec.p_first_name));
1074: set_complete_status(check_for_reqd(p_loan_rec.loan_number,'DL_PLUS','S_LAST_NAME', student_dtl_rec.p_last_name));
1075: set_complete_status(check_for_reqd(p_loan_rec.loan_number,'DL_PLUS','S_PERMT_ADDR1', student_dtl_rec.p_permt_addr1));
1076: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1077: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','S_PERMT_ADDR1 = ' ||student_dtl_rec.p_permt_addr1);
1078: END IF;
1079: set_complete_status(check_for_reqd(p_loan_rec.loan_number,'DL_PLUS','S_PERMT_CITY', student_dtl_rec.p_permt_city));
1080: set_complete_status(check_for_reqd(p_loan_rec.loan_number,'DL_PLUS','S_PERMT_STATE', student_dtl_rec.p_permt_state));

Line 1077: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','S_PERMT_ADDR1 = ' ||student_dtl_rec.p_permt_addr1);

1073: set_complete_status(check_for_reqd(p_loan_rec.loan_number,'DL_PLUS','S_FIRST_NAME', student_dtl_rec.p_first_name));
1074: set_complete_status(check_for_reqd(p_loan_rec.loan_number,'DL_PLUS','S_LAST_NAME', student_dtl_rec.p_last_name));
1075: set_complete_status(check_for_reqd(p_loan_rec.loan_number,'DL_PLUS','S_PERMT_ADDR1', student_dtl_rec.p_permt_addr1));
1076: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1077: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','S_PERMT_ADDR1 = ' ||student_dtl_rec.p_permt_addr1);
1078: END IF;
1079: set_complete_status(check_for_reqd(p_loan_rec.loan_number,'DL_PLUS','S_PERMT_CITY', student_dtl_rec.p_permt_city));
1080: set_complete_status(check_for_reqd(p_loan_rec.loan_number,'DL_PLUS','S_PERMT_STATE', student_dtl_rec.p_permt_state));
1081: set_complete_status(check_for_reqd(p_loan_rec.loan_number,'DL_PLUS','S_PERMT_ZIP', student_dtl_rec.p_permt_zip));

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

1197: /*
1198: -- Validate grade level (bug 4346421)
1199: -- get System Grade Level, compare with NVL(override_grade_level_code, grade_level_code). If not matching, then log mesg.
1200: l_dl_std_code := get_system_grade_level(p_loan_rec.base_id, p_loan_rec.loan_per_begin_date, p_loan_rec.loan_per_end_date);
1201: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1202: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','l_dl_std_code got from get_system_grade_level function :'|| l_dl_std_code);
1203: END IF;
1204:
1205: IF (p_loan_rec.override_grade_level_code IS NOT NULL) THEN

Line 1202: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','l_dl_std_code got from get_system_grade_level function :'|| l_dl_std_code);

1198: -- Validate grade level (bug 4346421)
1199: -- get System Grade Level, compare with NVL(override_grade_level_code, grade_level_code). If not matching, then log mesg.
1200: l_dl_std_code := get_system_grade_level(p_loan_rec.base_id, p_loan_rec.loan_per_begin_date, p_loan_rec.loan_per_end_date);
1201: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1202: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','l_dl_std_code got from get_system_grade_level function :'|| l_dl_std_code);
1203: END IF;
1204:
1205: IF (p_loan_rec.override_grade_level_code IS NOT NULL) THEN
1206: IF (p_loan_rec.override_grade_level_code <> l_dl_std_code) THEN

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

1333: igf_sl_edit.insert_edit(p_loan_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', 'S_INV_PHONE_NUM', 'S_PERMT_PHONE', l_s_phone);
1334: END IF;
1335: END IF;
1336:
1337: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1338: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','l_s_phone '|| l_s_phone);
1339: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','p_s_phone '|| p_s_phone);
1340: END IF;
1341:

Line 1338: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','l_s_phone '|| l_s_phone);

1334: END IF;
1335: END IF;
1336:
1337: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1338: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','l_s_phone '|| l_s_phone);
1339: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','p_s_phone '|| p_s_phone);
1340: END IF;
1341:
1342: -- validating student's Zip Code

Line 1339: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','p_s_phone '|| p_s_phone);

1335: END IF;
1336:
1337: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1338: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','l_s_phone '|| l_s_phone);
1339: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','p_s_phone '|| p_s_phone);
1340: END IF;
1341:
1342: -- validating student's Zip Code
1343: IF ( (LENGTH(student_dtl_rec.p_permt_zip) < 5) OR (LENGTH(student_dtl_rec.p_permt_zip) > 13) ) THEN

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

1378: lv_complete := FALSE;
1379: igf_sl_edit.insert_edit(p_loan_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', 'INVALID_TRANS_NUM', 'CPS_TRANS_NUM', p_loan_rec.cps_trans_num);
1380: END IF;
1381:
1382: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1383: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','CPS Tran Number Check');
1384: END IF;
1385:
1386: -- validating loan_per_begin_date

Line 1383: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','CPS Tran Number Check');

1379: igf_sl_edit.insert_edit(p_loan_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', 'INVALID_TRANS_NUM', 'CPS_TRANS_NUM', p_loan_rec.cps_trans_num);
1380: END IF;
1381:
1382: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1383: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','CPS Tran Number Check');
1384: END IF;
1385:
1386: -- validating loan_per_begin_date
1387: IF p_dl_version = '2004-2005' THEN

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

1431: igf_sl_edit.insert_edit(p_loan_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', 'INV_LOAN_PER_ENDDT0607', 'LOAN_PER_END_DATE', p_loan_rec.loan_per_end_date);
1432: END IF;
1433: END IF;
1434:
1435: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1436: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','Loan Per Dates Check over');
1437: END IF;
1438:
1439: -- validating academic begin and end dates

Line 1436: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','Loan Per Dates Check over');

1432: END IF;
1433: END IF;
1434:
1435: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1436: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','Loan Per Dates Check over');
1437: END IF;
1438:
1439: -- validating academic begin and end dates
1440: IF (lv_message IS NULL) THEN

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

1444: lv_acad_begin_date < TO_DATE('02072003', 'DDMMYYYY') OR
1445: lv_acad_begin_date > TO_DATE('30062005', 'DDMMYYYY') THEN
1446: lv_complete := FALSE;
1447: igf_sl_edit.insert_edit(p_loan_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', 'INV_ACAD_PER_STARTDT0405', 'ACAD_PER_BEGIN_DATE', lv_acad_begin_date);
1448: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1449: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','lv_acad_begin_date '|| lv_acad_begin_date);
1450: END IF;
1451:
1452: END IF;

Line 1449: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','lv_acad_begin_date '|| lv_acad_begin_date);

1445: lv_acad_begin_date > TO_DATE('30062005', 'DDMMYYYY') THEN
1446: lv_complete := FALSE;
1447: igf_sl_edit.insert_edit(p_loan_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', 'INV_ACAD_PER_STARTDT0405', 'ACAD_PER_BEGIN_DATE', lv_acad_begin_date);
1448: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1449: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','lv_acad_begin_date '|| lv_acad_begin_date);
1450: END IF;
1451:
1452: END IF;
1453: -- validating academic end date

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

1455: lv_acad_end_date < TO_DATE('01072004', 'DDMMYYYY') OR
1456: lv_acad_end_date > TO_DATE('29062006', 'DDMMYYYY') THEN
1457: lv_complete := FALSE;
1458: igf_sl_edit.insert_edit(p_loan_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', 'INV_ACAD_PER_ENDDT0405', 'ACAD_PER_END_DATE', lv_acad_end_date);
1459: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1460: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','lv_acad_end_date '|| lv_acad_end_date);
1461: END IF;
1462:
1463: END IF;

Line 1460: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','lv_acad_end_date '|| lv_acad_end_date);

1456: lv_acad_end_date > TO_DATE('29062006', 'DDMMYYYY') THEN
1457: lv_complete := FALSE;
1458: igf_sl_edit.insert_edit(p_loan_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', 'INV_ACAD_PER_ENDDT0405', 'ACAD_PER_END_DATE', lv_acad_end_date);
1459: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1460: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','lv_acad_end_date '|| lv_acad_end_date);
1461: END IF;
1462:
1463: END IF;
1464: END IF;

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

1498: lv_complete := FALSE;
1499: igf_sl_edit.insert_edit(p_loan_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', 'INV_NOTE_MSG', 'NOTE_MESSAGE', p_loan_rec.note_message);
1500: END IF;
1501:
1502: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1503: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','Note Message Check Over');
1504: END IF;
1505:
1506: -- validating orig_fee_perct

Line 1503: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','Note Message Check Over');

1499: igf_sl_edit.insert_edit(p_loan_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', 'INV_NOTE_MSG', 'NOTE_MESSAGE', p_loan_rec.note_message);
1500: END IF;
1501:
1502: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1503: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','Note Message Check Over');
1504: END IF;
1505:
1506: -- validating orig_fee_perct
1507: IF ( p_loan_rec.orig_fee_perct >= 100) THEN

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

1507: IF ( p_loan_rec.orig_fee_perct >= 100) THEN
1508: lv_complete := FALSE;
1509: igf_sl_edit.insert_edit(p_loan_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', 'INV_ORIG_FEE_PCT', 'ORIG_FEE_PCT_NUM', p_loan_rec.orig_fee_perct);
1510: END IF;
1511: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1512: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug',' ORIG_FEE_PCT_NUM Check Over');
1513: END IF;
1514:
1515: -- validating int_reb_pct

Line 1512: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug',' ORIG_FEE_PCT_NUM Check Over');

1508: lv_complete := FALSE;
1509: igf_sl_edit.insert_edit(p_loan_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', 'INV_ORIG_FEE_PCT', 'ORIG_FEE_PCT_NUM', p_loan_rec.orig_fee_perct);
1510: END IF;
1511: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1512: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug',' ORIG_FEE_PCT_NUM Check Over');
1513: END IF;
1514:
1515: -- validating int_reb_pct
1516: IF p_loan_rec.interest_rebate_percent_num >= 100 OR p_loan_rec.interest_rebate_percent_num < 0 THEN

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

1517: lv_complete := FALSE;
1518: igf_sl_edit.insert_edit(p_loan_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', 'INV_INT_REB_PCT', 'INT_REB_PCT_NUM', p_loan_rec.interest_rebate_percent_num);
1519: END IF;
1520:
1521: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1522: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug',' INT_REB_PCT_NUM Check Over');
1523: END IF;
1524:
1525: IF p_loan_rec.accepted_amt >= 999999999.99 OR p_loan_rec.accepted_amt < 0 THEN

Line 1522: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug',' INT_REB_PCT_NUM Check Over');

1518: igf_sl_edit.insert_edit(p_loan_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', 'INV_INT_REB_PCT', 'INT_REB_PCT_NUM', p_loan_rec.interest_rebate_percent_num);
1519: END IF;
1520:
1521: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1522: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug',' INT_REB_PCT_NUM Check Over');
1523: END IF;
1524:
1525: IF p_loan_rec.accepted_amt >= 999999999.99 OR p_loan_rec.accepted_amt < 0 THEN
1526: lv_complete := FALSE;

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

1525: IF p_loan_rec.accepted_amt >= 999999999.99 OR p_loan_rec.accepted_amt < 0 THEN
1526: lv_complete := FALSE;
1527: igf_sl_edit.insert_edit(p_loan_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', 'INV_AWD_AMT', 'LOAN_AMT_ACCEPTED', p_loan_rec.accepted_amt);
1528: END IF;
1529: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1530: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug',' LOAN_AMT_ACCEPTED Check Over');
1531: END IF;
1532:
1533: -- validating disbursement data from the IGF_AW_DB_CHG_DTLS table

Line 1530: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug',' LOAN_AMT_ACCEPTED Check Over');

1526: lv_complete := FALSE;
1527: igf_sl_edit.insert_edit(p_loan_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', 'INV_AWD_AMT', 'LOAN_AMT_ACCEPTED', p_loan_rec.accepted_amt);
1528: END IF;
1529: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1530: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug',' LOAN_AMT_ACCEPTED Check Over');
1531: END IF;
1532:
1533: -- validating disbursement data from the IGF_AW_DB_CHG_DTLS table
1534: FOR rec_disb_chg_dtls IN cur_disb_chg_dtls(p_loan_rec.award_id) LOOP

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

1582: igf_sl_edit.insert_edit(p_loan_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', 'INV_DISB_DATE0607', 'DISB_DATE', rec_disb_chg_dtls.disb_date);
1583: END IF;
1584: END IF;
1585: END LOOP;
1586: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1587: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug',' Disb Check Over');
1588: END IF;
1589: --
1590: -- entity id validations

Line 1587: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug',' Disb Check Over');

1583: END IF;
1584: END IF;
1585: END LOOP;
1586: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1587: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug',' Disb Check Over');
1588: END IF;
1589: --
1590: -- entity id validations
1591: --

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

1593: lv_complete := FALSE;
1594: igf_sl_edit.insert_edit(p_loan_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', 'ATD_SCHL_ID_NUM', 'ATD_ENTITY_ID_TXT', p_loan_rec.atd_entity_id_txt);
1595: ELSE
1596: IF p_loan_rec.atd_entity_id_txt > 99999999 THEN
1597: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1598: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug',' p_loan_rec.atd_entity_id_txt ' ||p_loan_rec.atd_entity_id_txt );
1599: END IF;
1600: lv_complete := FALSE;
1601: igf_sl_edit.insert_edit(p_loan_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', 'ATD_SCHL_ID_MAX', 'ATD_ENTITY_ID_TXT', p_loan_rec.atd_entity_id_txt);

Line 1598: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug',' p_loan_rec.atd_entity_id_txt ' ||p_loan_rec.atd_entity_id_txt );

1594: igf_sl_edit.insert_edit(p_loan_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', 'ATD_SCHL_ID_NUM', 'ATD_ENTITY_ID_TXT', p_loan_rec.atd_entity_id_txt);
1595: ELSE
1596: IF p_loan_rec.atd_entity_id_txt > 99999999 THEN
1597: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1598: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug',' p_loan_rec.atd_entity_id_txt ' ||p_loan_rec.atd_entity_id_txt );
1599: END IF;
1600: lv_complete := FALSE;
1601: igf_sl_edit.insert_edit(p_loan_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', 'ATD_SCHL_ID_MAX', 'ATD_ENTITY_ID_TXT', p_loan_rec.atd_entity_id_txt);
1602: END IF;

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

1610: lv_complete := FALSE;
1611: igf_sl_edit.insert_edit(p_loan_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', 'REP_SCHL_ID_MAX', 'REP_ENTITY_ID_TXT', p_loan_rec.rep_entity_id_txt);
1612: END IF;
1613: END IF;
1614: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1615: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug',' Entity ID Check Over');
1616: END IF;
1617:
1618: IF p_loan_rec.fed_fund_code = 'DLP' THEN

Line 1615: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug',' Entity ID Check Over');

1611: igf_sl_edit.insert_edit(p_loan_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', 'REP_SCHL_ID_MAX', 'REP_ENTITY_ID_TXT', p_loan_rec.rep_entity_id_txt);
1612: END IF;
1613: END IF;
1614: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1615: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug',' Entity ID Check Over');
1616: END IF;
1617:
1618: IF p_loan_rec.fed_fund_code = 'DLP' THEN
1619:

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

1699: lv_complete := FALSE;
1700: igf_sl_edit.insert_edit(p_loan_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', 'P_INV_PHONE_NUM', 'P_PERMT_PHONE', l_p_phone);
1701: END IF;
1702: END IF;
1703: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1704: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','l_p_phone '|| l_p_phone);
1705: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','p_p_phone '|| p_p_phone);
1706: END IF;
1707:

Line 1704: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','l_p_phone '|| l_p_phone);

1700: igf_sl_edit.insert_edit(p_loan_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', 'P_INV_PHONE_NUM', 'P_PERMT_PHONE', l_p_phone);
1701: END IF;
1702: END IF;
1703: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1704: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','l_p_phone '|| l_p_phone);
1705: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','p_p_phone '|| p_p_phone);
1706: END IF;
1707:
1708: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 1705: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','p_p_phone '|| p_p_phone);

1701: END IF;
1702: END IF;
1703: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1704: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','l_p_phone '|| l_p_phone);
1705: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','p_p_phone '|| p_p_phone);
1706: END IF;
1707:
1708: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1709: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','Before zip vali');

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

1704: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','l_p_phone '|| l_p_phone);
1705: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','p_p_phone '|| p_p_phone);
1706: END IF;
1707:
1708: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1709: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','Before zip vali');
1710: END IF;
1711:
1712: -- validating borrower's Zip Code

Line 1709: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','Before zip vali');

1705: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','p_p_phone '|| p_p_phone);
1706: END IF;
1707:
1708: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1709: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','Before zip vali');
1710: END IF;
1711:
1712: -- validating borrower's Zip Code
1713: IF ( (LENGTH(parent_dtl_rec.p_permt_zip) < 5) OR (LENGTH(parent_dtl_rec.p_permt_zip) > 13) ) THEN

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

1714: lv_complete := FALSE;
1715: igf_sl_edit.insert_edit(p_loan_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', 'P_INV_ZIP_CODE', 'P_PERMT_ZIP', parent_dtl_rec.p_permt_zip);
1716: END IF;
1717:
1718: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1719: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','parent_dtl_rec.p_permt_zip '|| parent_dtl_rec.p_permt_zip);
1720: END IF;
1721:
1722: -- validating borrower's State Code

Line 1719: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','parent_dtl_rec.p_permt_zip '|| parent_dtl_rec.p_permt_zip);

1715: igf_sl_edit.insert_edit(p_loan_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', 'P_INV_ZIP_CODE', 'P_PERMT_ZIP', parent_dtl_rec.p_permt_zip);
1716: END IF;
1717:
1718: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1719: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','parent_dtl_rec.p_permt_zip '|| parent_dtl_rec.p_permt_zip);
1720: END IF;
1721:
1722: -- validating borrower's State Code
1723: IF ( (LENGTH(parent_dtl_rec.p_permt_state) < 2) OR (LENGTH(parent_dtl_rec.p_permt_state) > 3) ) THEN

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

1724: lv_complete := FALSE;
1725: igf_sl_edit.insert_edit(p_loan_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', 'P_INV_STATE_CODE', 'P_PERMT_STATE', parent_dtl_rec.p_permt_state);
1726: END IF;
1727:
1728: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1729: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','parent_dtl_rec.p_permt_state '|| parent_dtl_rec.p_permt_state);
1730: END IF;
1731:
1732: -- validating borrower's driver licencse number

Line 1729: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','parent_dtl_rec.p_permt_state '|| parent_dtl_rec.p_permt_state);

1725: igf_sl_edit.insert_edit(p_loan_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', 'P_INV_STATE_CODE', 'P_PERMT_STATE', parent_dtl_rec.p_permt_state);
1726: END IF;
1727:
1728: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1729: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','parent_dtl_rec.p_permt_state '|| parent_dtl_rec.p_permt_state);
1730: END IF;
1731:
1732: -- validating borrower's driver licencse number
1733: IF ( LENGTH(parent_dtl_rec.p_license_num) > 20) THEN

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

1734: lv_complete := FALSE;
1735: igf_sl_edit.insert_edit(p_loan_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', 'P_INV_DRIV_LIC_NUM', 'P_LICENSE_NUM', parent_dtl_rec.p_license_num);
1736: END IF;
1737:
1738: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1739: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','parent_dtl_rec.p_license_num '|| parent_dtl_rec.p_license_num);
1740: END IF;
1741:
1742: IF parent_dtl_rec.p_license_num IS NOT NULL AND parent_dtl_rec.p_license_state IS NULL THEN

Line 1739: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','parent_dtl_rec.p_license_num '|| parent_dtl_rec.p_license_num);

1735: igf_sl_edit.insert_edit(p_loan_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', 'P_INV_DRIV_LIC_NUM', 'P_LICENSE_NUM', parent_dtl_rec.p_license_num);
1736: END IF;
1737:
1738: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1739: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','parent_dtl_rec.p_license_num '|| parent_dtl_rec.p_license_num);
1740: END IF;
1741:
1742: IF parent_dtl_rec.p_license_num IS NOT NULL AND parent_dtl_rec.p_license_state IS NULL THEN
1743: lv_complete := FALSE;

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

1743: lv_complete := FALSE;
1744: igf_sl_edit.insert_edit(p_loan_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', 'P_DRIV_LIC_NUM_STATE', 'P_LICENSE_NUM', NULL);
1745: END IF;
1746:
1747: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1748: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','parent_dtl_rec.p_license_state '|| parent_dtl_rec.p_license_state);
1749: END IF;
1750:
1751: IF parent_dtl_rec.p_license_state IS NOT NULL AND parent_dtl_rec.p_license_num IS NULL THEN

Line 1748: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','parent_dtl_rec.p_license_state '|| parent_dtl_rec.p_license_state);

1744: igf_sl_edit.insert_edit(p_loan_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', 'P_DRIV_LIC_NUM_STATE', 'P_LICENSE_NUM', NULL);
1745: END IF;
1746:
1747: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1748: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','parent_dtl_rec.p_license_state '|| parent_dtl_rec.p_license_state);
1749: END IF;
1750:
1751: IF parent_dtl_rec.p_license_state IS NOT NULL AND parent_dtl_rec.p_license_num IS NULL THEN
1752: lv_complete := FALSE;

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

1752: lv_complete := FALSE;
1753: igf_sl_edit.insert_edit(p_loan_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', 'P_DRIV_LIC_STATE_NUM', 'P_LICENSE_ST', NULL);
1754: END IF;
1755:
1756: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1757: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','parent_dtl_rec.p_license_num '|| parent_dtl_rec.p_license_num);
1758: END IF;
1759:
1760: -- validating borrower's citizenship status code

Line 1757: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','parent_dtl_rec.p_license_num '|| parent_dtl_rec.p_license_num);

1753: igf_sl_edit.insert_edit(p_loan_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', 'P_DRIV_LIC_STATE_NUM', 'P_LICENSE_ST', NULL);
1754: END IF;
1755:
1756: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1757: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','parent_dtl_rec.p_license_num '|| parent_dtl_rec.p_license_num);
1758: END IF;
1759:
1760: -- validating borrower's citizenship status code
1761: IF ( LENGTH(parent_dtl_rec.p_citizenship_status) > 1) THEN

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

1762: lv_complete := FALSE;
1763: igf_sl_edit.insert_edit(p_loan_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', 'P_INV_CIT_STATUS', 'P_CITIZENSHIP_STATUS', parent_dtl_rec.p_citizenship_status);
1764: END IF;
1765:
1766: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1767: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','parent_dtl_rec.p_citizenship_status '|| parent_dtl_rec.p_citizenship_status);
1768: END IF;
1769:
1770: END IF;

Line 1767: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','parent_dtl_rec.p_citizenship_status '|| parent_dtl_rec.p_citizenship_status);

1763: igf_sl_edit.insert_edit(p_loan_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', 'P_INV_CIT_STATUS', 'P_CITIZENSHIP_STATUS', parent_dtl_rec.p_citizenship_status);
1764: END IF;
1765:
1766: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1767: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','parent_dtl_rec.p_citizenship_status '|| parent_dtl_rec.p_citizenship_status);
1768: END IF;
1769:
1770: END IF;
1771:

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

1799:
1800: igf_sl_edit.insert_edit(p_loan_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', lv_lookup_code, NULL, NULL);
1801:
1802: -- Log
1803: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1804: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','Stafford loan limit validation for award_id ' ||p_loan_rec.award_id|| ' FAILED with message: ' ||lv_message);
1805: END IF;
1806: ELSE
1807: -- Stafforf loan limit validation PASSED

Line 1804: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','Stafford loan limit validation for award_id ' ||p_loan_rec.award_id|| ' FAILED with message: ' ||lv_message);

1800: igf_sl_edit.insert_edit(p_loan_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', lv_lookup_code, NULL, NULL);
1801:
1802: -- Log
1803: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1804: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','Stafford loan limit validation for award_id ' ||p_loan_rec.award_id|| ' FAILED with message: ' ||lv_message);
1805: END IF;
1806: ELSE
1807: -- Stafforf loan limit validation PASSED
1808: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

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

1804: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','Stafford loan limit validation for award_id ' ||p_loan_rec.award_id|| ' FAILED with message: ' ||lv_message);
1805: END IF;
1806: ELSE
1807: -- Stafforf loan limit validation PASSED
1808: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1809: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','Stafford loan limit validation PASSED for award_id ' ||p_loan_rec.award_id);
1810: END IF;
1811: END IF;
1812: END IF;

Line 1809: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','Stafford loan limit validation PASSED for award_id ' ||p_loan_rec.award_id);

1805: END IF;
1806: ELSE
1807: -- Stafforf loan limit validation PASSED
1808: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1809: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.debug','Stafford loan limit validation PASSED for award_id ' ||p_loan_rec.award_id);
1810: END IF;
1811: END IF;
1812: END IF;
1813: -- museshad (Bug 4116399)

Line 1843: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

1839: RETURN lv_complete;
1840:
1841: EXCEPTION
1842: WHEN OTHERS THEN
1843: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1844: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.exception','Exception:'||SQLERRM);
1845: END IF;
1846: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1847: fnd_message.set_token('NAME','IGF_SL_DL_VALIDATION.COD_LOAN_VALIDATIONS');

Line 1844: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.exception','Exception:'||SQLERRM);

1840:
1841: EXCEPTION
1842: WHEN OTHERS THEN
1843: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1844: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_validation.cod_loan_validations.exception','Exception:'||SQLERRM);
1845: END IF;
1846: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1847: fnd_message.set_token('NAME','IGF_SL_DL_VALIDATION.COD_LOAN_VALIDATIONS');
1848: igs_ge_msg_stack.add;

Line 1974: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

1970: END IF;
1971:
1972: EXCEPTION
1973: WHEN OTHERS THEN
1974: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1975: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_validation.validate_id.exception','Exception:'||SQLERRM);
1976: END IF;
1977: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1978: fnd_message.set_token('NAME','IGF_SL_DL_VALIDATION.VALIDATE_ID');

Line 1975: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_validation.validate_id.exception','Exception:'||SQLERRM);

1971:
1972: EXCEPTION
1973: WHEN OTHERS THEN
1974: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1975: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_validation.validate_id.exception','Exception:'||SQLERRM);
1976: END IF;
1977: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1978: fnd_message.set_token('NAME','IGF_SL_DL_VALIDATION.VALIDATE_ID');
1979: igs_ge_msg_stack.add;