[Home] [Help]
145: FOR irec in cur_reqd LOOP
146: IF irec.status = 'R' THEN
147: -- If the Data is required.
148: lv_complete := FALSE;
149: igf_sl_edit.insert_edit(p_loan_number, 'V', lv_err_type, lv_data_reqd, p_field_name, p_field_value);
150: log_to_fnd('check_for_reqd','debug','irec.status:R');
151: ELSIF irec.status = 'S' THEN
152: -- If the Data is strongly recommended.
153: igf_sl_edit.insert_edit(p_loan_number, 'V', lv_err_type, lv_data_recomm, p_field_name, p_field_value);
149: igf_sl_edit.insert_edit(p_loan_number, 'V', lv_err_type, lv_data_reqd, p_field_name, p_field_value);
150: log_to_fnd('check_for_reqd','debug','irec.status:R');
151: ELSIF irec.status = 'S' THEN
152: -- If the Data is strongly recommended.
153: igf_sl_edit.insert_edit(p_loan_number, 'V', lv_err_type, lv_data_recomm, p_field_name, p_field_value);
154: log_to_fnd('check_for_reqd','debug','irec.status:S');
155: END IF;
156: END LOOP;
157: END IF;
755:
756:
757: -- Deletes the Record from the Edit Table with this Loan Number and Status as Valid
758:
759: igf_sl_edit.delete_edit(lor_rec.loan_number,'V');
760:
761: -- For School Certification Requests, use External Loan Number field. If the External
762: -- Loan Number is not available, error out and do not process the loan record
763: IF lor_rec.prc_type_code = 'CR' THEN
762: -- Loan Number is not available, error out and do not process the loan record
763: IF lor_rec.prc_type_code = 'CR' THEN
764: IF lor_rec.external_loan_id_txt IS NULL THEN
765: set_complete_status(FALSE);
766: igf_sl_edit.insert_edit(lor_rec.loan_number,'V','IGF_SL_ERR_CODES','EXT_LOAN_NUM_CHK',NULL,NULL);
767: END IF;
768: END IF;
769:
770: --Irrespective of Loan Type School Certification date cannot be after the Loan Period End Date
772: --Bug 2477912 CL Formatting Errors.
773: IF lor_rec.sch_cert_date IS NOT NULL AND lor_rec.prc_type_code IN ('GP','GO') THEN
774: IF lor_rec.sch_cert_date > lor_rec.loan_per_end_date THEN
775: set_complete_status(FALSE);
776: igf_sl_edit.insert_edit(lor_rec.loan_number, 'V', 'IGF_SL_CL_ERROR', '078', 'SCH_CERT_DATE',
777: lor_rec.sch_cert_date);
778: END IF;
779:
780: END IF;
786: --4089250 Error code 046 should be used. Not 457 -ugummall
787: IF p_call_mode ='JOB' AND lor_rec.prc_type_code IN ('GO','GP') THEN
788: IF TRUNC(SYSDATE) > lor_rec.loan_per_end_date THEN
789: set_complete_status(FALSE);
790: igf_sl_edit.insert_edit(lor_rec.loan_number, 'V', 'IGF_SL_CL_ERROR', '046', 'FILE_TRANS_DATE', NULL);
791: END IF;
792:
793: END IF;
794:
798:
799: IF lor_rec.anticip_compl_date IS NOT NULL AND lor_rec.prc_type_code IN ('GP','GO') THEN
800: IF lor_rec.anticip_compl_date < lor_rec.loan_per_end_date THEN
801: set_complete_status(FALSE);
802: igf_sl_edit.insert_edit(lor_rec.loan_number, 'V', 'IGF_SL_CL_ERROR', '053', 'ANTICIP_COMPL_DATE',
803: lor_rec.anticip_compl_date);
804: END IF;
805:
806: END IF;
897: -- rajagupt - FA 161 - Bug # 5006583
898: -- Check for Valid Federal application form code i.e Stafford = 'M'
899: IF NVL(lor_rec.loan_app_form_code,'*') <> 'M' THEN
900: set_complete_status(FALSE);
901: igf_sl_edit.insert_edit(lor_rec.loan_number, 'V', 'IGF_SL_CL_ERROR', '405', 'FED_APPL_FORM_CODE', NULL);
902: END IF;
903: -- Deferement Request not required for 'M' appl form code
904: IF NVL(lor_rec.loan_app_form_code,'*') = 'M' AND lor_rec.deferment_request_code IS NOT NULL THEN
905: set_complete_status(FALSE);
902: END IF;
903: -- Deferement Request not required for 'M' appl form code
904: IF NVL(lor_rec.loan_app_form_code,'*') = 'M' AND lor_rec.deferment_request_code IS NOT NULL THEN
905: set_complete_status(FALSE);
906: igf_sl_edit.insert_edit(lor_rec.loan_number, 'V', 'IGF_SL_CL_ERROR', '502', 'DEFER_REQ_CODE', NULL);
907: g_update_mode_required := TRUE;
908: END IF;
909:
910: --Added this Code as CL Ref doc this is Strongly Recommended for all types of Loans.Bug 2400487
913:
914: -- For CL Stafford If the Student is in Default, then do not originate
915: IF lor_rec.s_default_status = 'Y' AND (lor_rec.prc_type_code IN ('GP','GO')) THEN
916: set_complete_status(FALSE);
917: igf_sl_edit.insert_edit(lor_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', 'IS_DEFAULTER', 'S_DEFAULT_STATUS', NULL);
918: END IF;
919:
920: --
921: -- Check for Student SSN
925: SUBSTR(student_dtl_rec.p_ssn,1,1) = '9' OR
926: SUBSTR(student_dtl_rec.p_ssn,1,3) = '000'
927: THEN
928: set_complete_status(FALSE);
929: igf_sl_edit.insert_edit(lor_rec.loan_number, 'V', 'IGF_SL_CL_ERROR', '034', 'S_SSN', NULL);
930: END IF;
931: END IF;
932:
933:
1006: -- Check for Valid Federal application form code i.e PLUS = 'Q'
1007: IF(NVL(lor_rec.loan_app_form_code,'*') <> 'Q'AND p_loan_catg IN ('CL_PLUS')) OR
1008: (NVL(lor_rec.loan_app_form_code,'*') <> 'G' AND p_loan_catg IN ('CL_GPLUSFL')) THEN
1009: set_complete_status(FALSE);
1010: igf_sl_edit.insert_edit(lor_rec.loan_number, 'V', 'IGF_SL_CL_ERROR', '405', 'FED_APPL_FORM_CODE', NULL);
1011: END IF;
1012: -- Not required fields
1013: IF NVL(lor_rec.loan_app_form_code,'*') = 'Q' OR NVL(lor_rec.loan_app_form_code,'*') = 'G' THEN
1014: IF lor_rec.deferment_request_code IS NOT NULL THEN
1012: -- Not required fields
1013: IF NVL(lor_rec.loan_app_form_code,'*') = 'Q' OR NVL(lor_rec.loan_app_form_code,'*') = 'G' THEN
1014: IF lor_rec.deferment_request_code IS NOT NULL THEN
1015: set_complete_status(FALSE);
1016: igf_sl_edit.insert_edit(lor_rec.loan_number, 'V', 'IGF_SL_CL_ERROR', '502', 'DEFER_REQ_CODE', NULL);
1017: g_update_mode_required := TRUE;
1018: END IF;
1019: IF lor_rec.borw_interest_ind IS NOT NULL AND (lor_rec.borw_interest_ind = 'Y' OR lor_rec.borw_interest_ind = 'YES') THEN
1020: set_complete_status(FALSE);
1017: g_update_mode_required := TRUE;
1018: END IF;
1019: IF lor_rec.borw_interest_ind IS NOT NULL AND (lor_rec.borw_interest_ind = 'Y' OR lor_rec.borw_interest_ind = 'YES') THEN
1020: set_complete_status(FALSE);
1021: igf_sl_edit.insert_edit(lor_rec.loan_number, 'V', 'IGF_SL_CL_ERROR', '502', 'BORW_INTEREST_IND', NULL);
1022: g_update_mode_required := TRUE;
1023: END IF;
1024: IF lor_rec.p_default_status IS NOT NULL THEN
1025: set_complete_status(FALSE);
1022: g_update_mode_required := TRUE;
1023: END IF;
1024: IF lor_rec.p_default_status IS NOT NULL THEN
1025: set_complete_status(FALSE);
1026: igf_sl_edit.insert_edit(lor_rec.loan_number, 'V', 'IGF_SL_CL_ERROR', '502', 'P_DEFAULT_STATUS', NULL);
1027: g_update_mode_required := TRUE;
1028: END IF;
1029: IF lor_rec.s_default_status IS NOT NULL THEN
1030: set_complete_status(FALSE);
1027: g_update_mode_required := TRUE;
1028: END IF;
1029: IF lor_rec.s_default_status IS NOT NULL THEN
1030: set_complete_status(FALSE);
1031: igf_sl_edit.insert_edit(lor_rec.loan_number, 'V', 'IGF_SL_CL_ERROR', '502', 'S_DEFAULT_STATUS', NULL);
1032: g_update_mode_required := TRUE;
1033: END IF;
1034: IF lor_rec.borw_outstd_loan_code IS NOT NULL THEN
1035: set_complete_status(FALSE);
1032: g_update_mode_required := TRUE;
1033: END IF;
1034: IF lor_rec.borw_outstd_loan_code IS NOT NULL THEN
1035: set_complete_status(FALSE);
1036: igf_sl_edit.insert_edit(lor_rec.loan_number, 'V', 'IGF_SL_CL_ERROR', '502', 'BORW_OUTSTD_LOAN_CODE', NULL);
1037: g_update_mode_required := TRUE;
1038: END IF;
1039: IF lor_rec.s_signature_code IS NOT NULL THEN
1040: set_complete_status(FALSE);
1037: g_update_mode_required := TRUE;
1038: END IF;
1039: IF lor_rec.s_signature_code IS NOT NULL THEN
1040: set_complete_status(FALSE);
1041: igf_sl_edit.insert_edit(lor_rec.loan_number, 'V', 'IGF_SL_CL_ERROR', '502', 'S_SIGNATURE_CODE', NULL);
1042: g_update_mode_required := TRUE;
1043: END IF;
1044: IF lor_rec.stud_sign_ind IS NOT NULL AND (lor_rec.stud_sign_ind = 'Y' OR lor_rec.stud_sign_ind = 'YES') THEN
1045: set_complete_status(FALSE);
1042: g_update_mode_required := TRUE;
1043: END IF;
1044: IF lor_rec.stud_sign_ind IS NOT NULL AND (lor_rec.stud_sign_ind = 'Y' OR lor_rec.stud_sign_ind = 'YES') THEN
1045: set_complete_status(FALSE);
1046: igf_sl_edit.insert_edit(lor_rec.loan_number, 'V', 'IGF_SL_CL_ERROR', '502', 'S_ESIGN_IND_CODE', NULL);
1047: g_update_mode_required := TRUE;
1048: END IF;
1049: END IF;
1050: -- FA 161 - Bug 5006583 - Citizenship mapping code does not exists
1056: FETCH cur_fa_mapping INTO cur_fa_mapping_rec;
1057: IF cur_fa_mapping%NOTFOUND THEN
1058: log_to_fnd('cl_lar_validate','debug','----S_CITIZENSHIP_STATUS----');
1059: set_complete_status(FALSE);
1060: igf_sl_edit.insert_edit(lor_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', 'NO_FA_CITI_MAP_CD', 'S_CITIZENSHIP_STATUS', NULL);
1061: END IF;
1062: CLOSE cur_fa_mapping;
1063: END IF;
1064: -- Parent
1070: log_to_fnd('cl_lar_validate','debug','cur_fa_mapping_rec.fa_citi_stat_code ='||cur_fa_mapping_rec.fa_citi_stat_code||'=');
1071: log_to_fnd('cl_lar_validate','debug','lor_rec.b_alien_reg_num_txt ='||lor_rec.b_alien_reg_num_txt||'=');
1072: IF cur_fa_mapping%NOTFOUND THEN
1073: set_complete_status(FALSE);
1074: igf_sl_edit.insert_edit(lor_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', 'NO_FA_CITI_MAP_CD', 'P_CITIZENSHIP_STATUS', NULL);
1075: -- Borw Alien registration Number is Strongly Recommended if FA Citizenship code maps to 2
1076: ELSIF (cur_fa_mapping_rec.fa_citi_stat_code = '2' AND lor_rec.b_alien_reg_num_txt IS NULL) THEN
1077: log_to_fnd('cl_lar_validate','debug','p_loan_catg ' || p_loan_catg);
1078: log_to_fnd('cl_lar_validate','debug','lor_rec.b_alien_reg_num_txt '||lor_rec.b_alien_reg_num_txt);
1093: SUBSTR(student_dtl_rec.p_ssn,1,1) = '9' OR
1094: SUBSTR(student_dtl_rec.p_ssn,1,3) = '000'
1095: THEN
1096: set_complete_status(FALSE);
1097: igf_sl_edit.insert_edit(lor_rec.loan_number, 'V', 'IGF_SL_CL_ERROR', '034', 'S_SSN', NULL);
1098: END IF;
1099:
1100: IF SUBSTR(parent_dtl_rec.p_ssn,1,1) = '8' OR
1101: SUBSTR(parent_dtl_rec.p_ssn,1,1) = '9' OR
1101: SUBSTR(parent_dtl_rec.p_ssn,1,1) = '9' OR
1102: SUBSTR(parent_dtl_rec.p_ssn,1,3) = '000'
1103: THEN
1104: set_complete_status(FALSE);
1105: igf_sl_edit.insert_edit(lor_rec.loan_number, 'V', 'IGF_SL_CL_ERROR', '001', 'P_SSN', NULL);
1106: END IF;
1107: END IF;
1108: ELSIF p_loan_catg = 'CL_ALT' THEN
1109: l_phone := igf_sl_gen.get_person_phone( lor_rec.p_person_id );
1227: cp_sequence_number => p_ci_sequence_number);
1228: FETCH cur_fa_mapping INTO cur_fa_mapping_rec;
1229: IF cur_fa_mapping%NOTFOUND THEN
1230: set_complete_status(FALSE);
1231: igf_sl_edit.insert_edit(lor_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', 'NO_FA_CITI_MAP_CD', 'S_CITIZENSHIP_STATUS', NULL);
1232: ELSIF NOT (cur_fa_mapping_rec.fa_citi_stat_code IN ('1','2') AND (lor_rec.prc_type_code IN ('GP','GO'))) THEN
1233: set_complete_status(FALSE);
1234: igf_sl_edit.insert_edit(lor_rec.loan_number, 'V', 'IGF_SL_CL_ERROR', '016', 'P_CITIZENSHIP_STATUS', NULL);
1235:
1230: set_complete_status(FALSE);
1231: igf_sl_edit.insert_edit(lor_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', 'NO_FA_CITI_MAP_CD', 'S_CITIZENSHIP_STATUS', NULL);
1232: ELSIF NOT (cur_fa_mapping_rec.fa_citi_stat_code IN ('1','2') AND (lor_rec.prc_type_code IN ('GP','GO'))) THEN
1233: set_complete_status(FALSE);
1234: igf_sl_edit.insert_edit(lor_rec.loan_number, 'V', 'IGF_SL_CL_ERROR', '016', 'P_CITIZENSHIP_STATUS', NULL);
1235:
1236: log_to_fnd('cl_lar_validate','debug','--------------------');
1237: log_to_fnd('cl_lar_validate','debug','P_CITIZENSHIP_STATUS');
1238: ELSIF cur_fa_mapping_rec.fa_citi_stat_code = '2' AND lor_rec.b_alien_reg_num_txt IS NULL THEN
1254: FETCH cur_fa_mapping INTO cur_fa_mapping_rec;
1255: IF cur_fa_mapping%NOTFOUND THEN
1256: log_to_fnd('cl_lar_validate','debug','----P_CITIZENSHIP_STATUS----');
1257: set_complete_status(FALSE);
1258: igf_sl_edit.insert_edit(lor_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', 'NO_FA_CITI_MAP_CD', 'P_CITIZENSHIP_STATUS', NULL);
1259: ELSIF NOT (cur_fa_mapping_rec.fa_citi_stat_code IN ('1','2') AND (lor_rec.prc_type_code IN ('GP','GO'))) THEN
1260: set_complete_status(FALSE);
1261: igf_sl_edit.insert_edit(lor_rec.loan_number, 'V', 'IGF_SL_CL_ERROR', '016', 'P_CITIZENSHIP_STATUS', NULL);
1262:
1257: set_complete_status(FALSE);
1258: igf_sl_edit.insert_edit(lor_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', 'NO_FA_CITI_MAP_CD', 'P_CITIZENSHIP_STATUS', NULL);
1259: ELSIF NOT (cur_fa_mapping_rec.fa_citi_stat_code IN ('1','2') AND (lor_rec.prc_type_code IN ('GP','GO'))) THEN
1260: set_complete_status(FALSE);
1261: igf_sl_edit.insert_edit(lor_rec.loan_number, 'V', 'IGF_SL_CL_ERROR', '016', 'P_CITIZENSHIP_STATUS', NULL);
1262:
1263: log_to_fnd('cl_lar_validate','debug','--------------------');
1264: log_to_fnd('cl_lar_validate','debug','P_CITIZENSHIP_STATUS');
1265:
1281:
1282: -- rajagupt - FA 161 - Bug # 5006583 -- Check for Valid Federal application form code i.e for ALT = null
1283: IF lor_rec.loan_app_form_code IS NOT NULL THEN
1284: set_complete_status(FALSE);
1285: igf_sl_edit.insert_edit(lor_rec.loan_number, 'V', 'IGF_SL_CL_ERROR', '405', 'FED_APPL_FORM_CODE', NULL);
1286: END IF;
1287:
1288: --FA 157 - FFELP ALT Loan Validation - Includes Borrower and Cosigner details
1289: cl_alt_borr_cosig_validation(lor_rec.loan_number,p_loan_catg,lor_rec.prc_type_code);
1302: SUBSTR(student_dtl_rec.p_ssn,1,1) = '9' OR
1303: SUBSTR(student_dtl_rec.p_ssn,1,3) = '000'
1304: THEN
1305: set_complete_status(FALSE);
1306: igf_sl_edit.insert_edit(lor_rec.loan_number, 'V', 'IGF_SL_CL_ERROR', '034', 'S_SSN', NULL);
1307: log_to_fnd('cl_lar_validate','debug','----S_SSN----');
1308: END IF;
1309: END IF;
1310: /* If student is not the borrower */
1319: SUBSTR(parent_dtl_rec.p_ssn,1,1) = '9' OR
1320: SUBSTR(parent_dtl_rec.p_ssn,1,3) = '000'
1321: THEN
1322: set_complete_status(FALSE);
1323: igf_sl_edit.insert_edit(lor_rec.loan_number, 'V', 'IGF_SL_CL_ERROR', '001', 'P_SSN', NULL);
1324: log_to_fnd('cl_lar_validate','debug','----P_SSN----');
1325: END IF;
1326: END IF;
1327: END IF;
1337: FETCH c_nof_awd_disb INTO l_n_disb_cnt;
1338: IF c_nof_awd_disb%FOUND THEN
1339: log_to_fnd('cl_lar_validate','debug','The no. of disbursements='||l_n_disb_cnt);
1340: set_complete_status(FALSE);
1341: igf_sl_edit.insert_edit(lor_rec.loan_number,'V','IGF_SL_ERR_CODES','FOUR_DISB_CHK',NULL,NULL);
1342: END IF;
1343: CLOSE c_nof_awd_disb;
1344: END IF;
1345:
1351: ) THEN
1352:
1353: IF (NVL(unmetneed(lor_rec.base_id),0) < 0) THEN
1354: set_complete_status(FALSE);
1355: igf_sl_edit.insert_edit(lor_rec.loan_number,'V','IGF_SL_ERR_CODES','COA_EFC_CHK',NULL,NULL);
1356: log_to_fnd('cl_lar_validate','debug','loan_amt_accepted:'||lor_rec.loan_amt_accepted);
1357: END IF;
1358: END IF;
1359:
1360: -- For Both Loan Types check the Dependency status for the Borrower
1361:
1362: IF NVL(lv_dependency_status,'*') NOT IN ('I','D') AND (lor_rec.prc_type_code IN ('GP','GO')) THEN
1363: set_complete_status(FALSE);
1364: igf_sl_edit.insert_edit(lor_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', 'DEPNCY_NO_EFC_CALC', 'S_DEPNCY_STATUS', NULL);
1365: log_to_fnd('cl_lar_validate','debug','-----S_DEPNCY_STATUS-----');
1366: END IF;
1367:
1368: -- Loan Amount should be greater than zero for any Type of Loan. Else need to update the EditReport Table.
1367:
1368: -- Loan Amount should be greater than zero for any Type of Loan. Else need to update the EditReport Table.
1369: IF NVL(lor_rec.loan_amt_accepted,0)<= 0 AND (lor_rec.prc_type_code IN ('GP','GO')) AND lor_rec.rec_type_ind <> 'T' THEN
1370: set_complete_status(FALSE);
1371: igf_sl_edit.insert_edit(lor_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', 'LESS_THAN_ZERO', 'LOAN_AMT_ACCEPTED', NULL);
1372: log_to_fnd('cl_lar_validate','debug','-----LOAN_AMT_ACCEPTED-----');
1373: END IF;
1374:
1375: -- For Both Stafford and PLUS Loans all Disbursement Amounts should be Greater than Zero.Even if One
1382: OPEN cur_count_disb_amount;
1383: FETCH cur_count_disb_amount INTO ln_disb_amt_count;
1384: IF ln_disb_amt_count <> 0 THEN
1385: set_complete_status(FALSE);
1386: igf_sl_edit.insert_edit(lor_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', 'DISB_MORE_THAN_ZERO', NULL, NULL);
1387: log_to_fnd('cl_lar_validate','debug','-----DISB_MORE_THAN_ZERO-----');
1388: END IF;
1389: CLOSE cur_count_disb_amount;
1390: END IF;
1396: OPEN cur_count_disb_ind;
1397: FETCH cur_count_disb_ind INTO ln_disb_ind_count;
1398: IF ln_disb_ind_count <> 0 THEN
1399: set_complete_status(FALSE);
1400: igf_sl_edit.insert_edit(lor_rec.loan_number,'V','IGF_SL_ERR_CODES','HOLD_REL_NOT_NULL',NULL,NULL);
1401: log_to_fnd('cl_lar_validate','debug','-----HOLD_REL_NOT_NULL-----');
1402: END IF;
1403: CLOSE cur_count_disb_ind;
1404:
1409: OPEN cur_count_disb_dates;
1410: FETCH cur_count_disb_dates INTO ln_disb_dates_count;
1411: IF ln_disb_dates_count <> 0 THEN
1412: set_complete_status(FALSE);
1413: igf_sl_edit.insert_edit(lor_rec.loan_number,'V','IGF_SL_ERR_CODES','DISB_DATE_NOT_NULL',NULL,NULL);
1414: log_to_fnd('cl_lar_validate','debug','-----DISB_DATE_NOT_NULL-----');
1415: END IF;
1416: CLOSE cur_count_disb_dates;
1417: END IF;
1425: -- bvisvana - Bug # 4575843 - Check for requested loan amount. It should be in whole number.
1426: IF (lor_rec.requested_loan_amt < lor_rec.loan_amt_accepted) OR
1427: ((lor_rec.requested_loan_amt - TRUNC(lor_rec.requested_loan_amt)) <> 0) THEN
1428: set_complete_status(FALSE);
1429: igf_sl_edit.insert_edit(lor_rec.loan_number, 'V', 'IGF_SL_CL_ERROR', '014', 'REQUESTED_LOAN_AMT', NULL);
1430: log_to_fnd('cl_lar_validate','debug','-----REQUESTED_LOAN_AMT-----');
1431: END IF;
1432:
1433: -- museshad (Bug 4116399) Stafford loan limit validation
1457: set_complete_status(FALSE); -- For Bug # 5091652
1458: lv_lookup_code := 'LOAN_LMT_SETUP_CHK';
1459: END IF;
1460:
1461: igf_sl_edit.insert_edit(lor_rec.loan_number, 'V', 'IGF_SL_ERR_CODES', lv_lookup_code, NULL, NULL);
1462:
1463: -- Log
1464: log_to_fnd('cl_lar_validate','debug','Stafford loan limit validation failed with message: ' ||lv_msg_name);
1465:
1528: -- Display reject details on the Concurrent Manager Log File.
1529: DECLARE
1530: lv_log_mesg VARCHAR2(1000);
1531: CURSOR c_reject IS
1532: SELECT RPAD(field_desc,70)||sl_error_desc reject_desc FROM igf_sl_edit_report_v
1533: WHERE loan_number = lor_rec.loan_number
1534: AND orig_chg_code = 'V';
1535: BEGIN
1536: fnd_file.put_line(fnd_file.log, '');