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_LI_IMP_PKG dependencies on IGF_AP_GEN

Line 174: l_error := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','ERROR');

170:
171: fnd_message.set_name('IGS','IGS_GE_ASK_DEL_REC');
172: l_delete_flag_prmpt := fnd_message.get ;
173:
174: l_error := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','ERROR');
175: l_person_number_prmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER');
176: l_batch_num_prmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','BATCH_ID');
177: l_award_year_pmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','AWARD_YEAR');
178: l_yes_no := igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_delete_flag);

Line 175: l_person_number_prmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER');

171: fnd_message.set_name('IGS','IGS_GE_ASK_DEL_REC');
172: l_delete_flag_prmpt := fnd_message.get ;
173:
174: l_error := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','ERROR');
175: l_person_number_prmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER');
176: l_batch_num_prmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','BATCH_ID');
177: l_award_year_pmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','AWARD_YEAR');
178: l_yes_no := igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_delete_flag);
179: l_params_pass_prmpt := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS');

Line 176: l_batch_num_prmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','BATCH_ID');

172: l_delete_flag_prmpt := fnd_message.get ;
173:
174: l_error := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','ERROR');
175: l_person_number_prmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER');
176: l_batch_num_prmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','BATCH_ID');
177: l_award_year_pmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','AWARD_YEAR');
178: l_yes_no := igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_delete_flag);
179: l_params_pass_prmpt := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS');
180:

Line 177: l_award_year_pmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','AWARD_YEAR');

173:
174: l_error := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','ERROR');
175: l_person_number_prmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER');
176: l_batch_num_prmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','BATCH_ID');
177: l_award_year_pmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','AWARD_YEAR');
178: l_yes_no := igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_delete_flag);
179: l_params_pass_prmpt := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS');
180:
181: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');

Line 178: l_yes_no := igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_delete_flag);

174: l_error := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','ERROR');
175: l_person_number_prmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER');
176: l_batch_num_prmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','BATCH_ID');
177: l_award_year_pmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','AWARD_YEAR');
178: l_yes_no := igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_delete_flag);
179: l_params_pass_prmpt := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS');
180:
181: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
182: FND_FILE.PUT_LINE( FND_FILE.LOG, '-------------------------------------------------------------');

Line 179: l_params_pass_prmpt := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS');

175: l_person_number_prmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER');
176: l_batch_num_prmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','BATCH_ID');
177: l_award_year_pmpt := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','AWARD_YEAR');
178: l_yes_no := igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_delete_flag);
179: l_params_pass_prmpt := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PARAMETER_PASS');
180:
181: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
182: FND_FILE.PUT_LINE( FND_FILE.LOG, '-------------------------------------------------------------');
183: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');

Line 215: l_error := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','ERROR');

211:
212: indx NUMBER;
213: l_error VARCHAR2(30);
214: BEGIN
215: l_error := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','ERROR');
216: IF p_igf_sl_message_table.COUNT<>0 THEN
217: FOR indx IN p_igf_sl_message_table.FIRST..p_igf_sl_message_table.LAST
218: LOOP
219: fnd_file.put_line(fnd_file.log,p_igf_sl_message_table(indx).msg_text);

Line 697: l_error := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','ERROR');

693:
694: l_gross_amt c_gross_amt%ROWTYPE;
695: BEGIN
696: l_valid := TRUE;
697: l_error := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','ERROR');
698: p_d_status := TRUE;
699:
700:
701: p_igf_sl_msg_table.DELETE;

Line 742: IF igf_ap_gen.get_lookup_meaning('IGF_DB_DL_ACTIVITY',p_disb_interface.DISBURSEMENT_ACTIVITY_CODE) IS NULL

738:
739: END IF;
740:
741:
742: IF igf_ap_gen.get_lookup_meaning('IGF_DB_DL_ACTIVITY',p_disb_interface.DISBURSEMENT_ACTIVITY_CODE) IS NULL
743: OR p_disb_interface.DISBURSEMENT_ACTIVITY_CODE IS NULL THEN
744: indx := indx + 1;
745: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || g_error_string|| ' ' || 'DISBURSEMENT_ACTIVITY_CODE';
746: p_d_status := FALSE;

Line 1107: l_error := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','ERROR');

1103:
1104: l_accepted_amt c_accepted_amt%ROWTYPE;
1105:
1106: BEGIN
1107: l_error := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','ERROR');
1108: l_valid := TRUE;
1109:
1110: -- intialize process status
1111: p_status := TRUE;

Line 1147: IF igf_ap_gen.get_lookup_meaning('IGF_SL_LOAN_STATUS', p_interface.loan_status_code) IS NULL

1143: p_status := FALSE;
1144: END IF;
1145:
1146: -- validate loan_status_code
1147: IF igf_ap_gen.get_lookup_meaning('IGF_SL_LOAN_STATUS', p_interface.loan_status_code) IS NULL
1148: OR p_interface.loan_status_code IN ('B','C','R','S','T')
1149: OR p_interface.loan_status_code IS NULL THEN
1150: indx := indx + 1;
1151: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || g_error_string|| ' ' || 'LOAN_STATUS_CODE';

Line 1157: IF igf_ap_gen.get_lookup_meaning('IGF_SL_LOAN_CHG_STATUS', p_interface.loan_chg_status) IS NULL

1153: END IF;
1154:
1155: --Validations for loan_chg_status
1156: IF p_interface.loan_chg_status IS NOT NULL THEN
1157: IF igf_ap_gen.get_lookup_meaning('IGF_SL_LOAN_CHG_STATUS', p_interface.loan_chg_status) IS NULL
1158: OR p_interface.loan_chg_status IN ('S','B') THEN
1159: indx := indx + 1;
1160: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || g_error_string|| ' ' || 'LOAN_CHG_STATUS';
1161: p_status := FALSE;

Line 1172: OR igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_interface.active_flag) IS NULL THEN

1168: END IF;
1169:
1170: --Validations for active_flag
1171: IF p_interface.active_flag IS NULL
1172: OR igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_interface.active_flag) IS NULL THEN
1173: indx := indx + 1;
1174: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || g_error_string|| ' ' || 'ACTIVE_FLAG';
1175: p_status := FALSE;
1176: END IF;

Line 1180: OR igf_ap_gen.get_lookup_meaning('IGF_AP_GRADE_LEVEL',p_interface.grade_level_code) IS NULL

1176: END IF;
1177:
1178: --Validations for grade_level_code
1179: IF p_interface.grade_level_code IS NULL
1180: OR igf_ap_gen.get_lookup_meaning('IGF_AP_GRADE_LEVEL',p_interface.grade_level_code) IS NULL
1181: OR p_interface.grade_level_code = '0/1' THEN
1182: indx := indx + 1;
1183: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || g_error_string|| ' ' || 'GRADE_LEVEL_CODE';
1184: p_status := FALSE;

Line 1221: IF igf_ap_gen.get_lookup_meaning('IGF_SL_DL_DEP_UNSUB_ELIG',p_interface.UNSUB_ELIG_FOR_DEPNT_CODE) IS NULL THEN

1217: END IF;
1218:
1219: -- validations for unsub_elig_for_depnt_code
1220: IF l_award_year_status <> 'O' AND p_interface.UNSUB_ELIG_FOR_DEPNT_CODE IS NOT NULL THEN
1221: IF igf_ap_gen.get_lookup_meaning('IGF_SL_DL_DEP_UNSUB_ELIG',p_interface.UNSUB_ELIG_FOR_DEPNT_CODE) IS NULL THEN
1222: indx := indx + 1;
1223: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || g_error_string|| ' ' || 'UNSUB_ELIG_FOR_DEPNT_CODE';
1224: p_status := FALSE;
1225: END IF;

Line 1235: ELSIF igf_ap_gen.get_lookup_meaning('IGF_SL_DL_DEP_UNSUB_ELIG',p_interface.UNSUB_ELIG_FOR_DEPNT_CODE) IS NULL THEN

1231: indx := indx + 1;
1232: fnd_message.set_name('IGF','IGF_SL_UNSUB_ELIG_REQ');
1233: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || fnd_message.get;
1234: p_status := FALSE;
1235: ELSIF igf_ap_gen.get_lookup_meaning('IGF_SL_DL_DEP_UNSUB_ELIG',p_interface.UNSUB_ELIG_FOR_DEPNT_CODE) IS NULL THEN
1236: indx := indx + 1;
1237: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || g_error_string|| ' ' || 'UNSUB_ELIG_FOR_DEPNT_CODE';
1238: p_status := FALSE;
1239: END IF;

Line 1260: IF igf_ap_gen.get_lookup_meaning('IGF_SL_S_DEFAULT_STATUS',p_interface.S_DEFAULT_STATUS_CODE) IS NULL

1256: END IF;
1257:
1258: -- validations for s_default_status_code
1259: IF l_award_year_status <> 'O' AND p_interface.S_DEFAULT_STATUS_CODE IS NOT NULL THEN
1260: IF igf_ap_gen.get_lookup_meaning('IGF_SL_S_DEFAULT_STATUS',p_interface.S_DEFAULT_STATUS_CODE) IS NULL
1261: OR p_interface.S_DEFAULT_STATUS_CODE = 'Y' THEN
1262: indx := indx + 1;
1263: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || g_error_string|| ' ' || 'S_DEFAULT_STATUS_CODE';
1264: p_status := FALSE;

Line 1276: ELSIF igf_ap_gen.get_lookup_meaning('IGF_SL_S_DEFAULT_STATUS',p_interface.S_DEFAULT_STATUS_CODE) IS NULL

1272: indx := indx + 1;
1273: fnd_message.set_name('IGF','IGF_SL_DEF_STAT_REQ');
1274: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || fnd_message.get;
1275: p_status := FALSE;
1276: ELSIF igf_ap_gen.get_lookup_meaning('IGF_SL_S_DEFAULT_STATUS',p_interface.S_DEFAULT_STATUS_CODE) IS NULL
1277: OR p_interface.S_DEFAULT_STATUS_CODE = 'Y' THEN
1278: indx := indx + 1;
1279: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || g_error_string|| ' ' || 'S_DEFAULT_STATUS_CODE';
1280: p_status := FALSE;

Line 1321: IF igf_ap_gen.get_lookup_meaning('IGF_SL_DL_HP_UNSUB_ELIG',p_interface.UNSUB_ELIG_FOR_HEAL_CODE) IS NULL THEN

1317: END IF;
1318:
1319: -- Validations for unsub_elig_for_heal_code
1320: IF l_award_year_status <> 'O' AND p_interface.UNSUB_ELIG_FOR_HEAL_CODE IS NOT NULL THEN
1321: IF igf_ap_gen.get_lookup_meaning('IGF_SL_DL_HP_UNSUB_ELIG',p_interface.UNSUB_ELIG_FOR_HEAL_CODE) IS NULL THEN
1322: indx := indx + 1;
1323: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || g_error_string|| ' ' || 'UNSUB_ELIG_FOR_HEAL_CODE';
1324: p_status := FALSE;
1325: END IF;

Line 1329: IF igf_ap_gen.get_lookup_meaning('IGF_SL_DL_HP_UNSUB_ELIG',p_interface.UNSUB_ELIG_FOR_HEAL_CODE) IS NULL THEN

1325: END IF;
1326: END IF;
1327: IF l_award_year_status = 'O' THEN
1328: IF p_interface.LOAN_STATUS_CODE = 'A' AND lv_fed_fund_code = 'DLU' THEN
1329: IF igf_ap_gen.get_lookup_meaning('IGF_SL_DL_HP_UNSUB_ELIG',p_interface.UNSUB_ELIG_FOR_HEAL_CODE) IS NULL THEN
1330: indx := indx + 1;
1331: fnd_message.set_name('IGF','IGF_SL_UNSUB_ELG_HEAL_REQ');
1332: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || fnd_message.get;
1333: p_status := FALSE;

Line 1336: IF igf_ap_gen.get_lookup_meaning('IGF_SL_DL_HP_UNSUB_ELIG',p_interface.UNSUB_ELIG_FOR_HEAL_CODE) IS NULL THEN

1332: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || fnd_message.get;
1333: p_status := FALSE;
1334: END IF;
1335: ELSIF lv_fed_fund_code = 'DLU' AND p_interface.UNSUB_ELIG_FOR_HEAL_CODE IS NOT NULL THEN
1336: IF igf_ap_gen.get_lookup_meaning('IGF_SL_DL_HP_UNSUB_ELIG',p_interface.UNSUB_ELIG_FOR_HEAL_CODE) IS NULL THEN
1337: indx := indx + 1;
1338: fnd_message.set_name('IGF','IGF_SL_UNSUB_ELG_HEAL_REQ');
1339: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || fnd_message.get;
1340: p_status := FALSE;

Line 1356: IF igf_ap_gen.get_lookup_meaning('IGF_SL_DISCLOSURE_PRINT_IND',p_interface.DISCLOSURE_PRINT_IND_CODE) IS NULL

1352: END IF;
1353:
1354: -- Validations for disclosure_print_ind_code
1355: IF p_interface.DISCLOSURE_PRINT_IND_CODE IS NOT NULL THEN
1356: IF igf_ap_gen.get_lookup_meaning('IGF_SL_DISCLOSURE_PRINT_IND',p_interface.DISCLOSURE_PRINT_IND_CODE) IS NULL
1357: OR p_interface.DISCLOSURE_PRINT_IND_CODE IN ('N','Z') THEN
1358: indx := indx + 1;
1359: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || g_error_string|| ' ' || 'DISCLOSURE_PRINT_IND_CODE';
1360: p_status := FALSE;

Line 1399: IF igf_ap_gen.get_lookup_meaning('IGF_SL_CREDIT_OVERRIDE',p_interface.CREDIT_OVERRIDE_CODE) IS NULL

1395: END IF;
1396:
1397: -- -- Validations for credit_override_code
1398: IF l_award_year_status <> 'O' AND p_interface.CREDIT_OVERRIDE_CODE IS NOT NULL THEN
1399: IF igf_ap_gen.get_lookup_meaning('IGF_SL_CREDIT_OVERRIDE',p_interface.CREDIT_OVERRIDE_CODE) IS NULL
1400: OR p_interface.CREDIT_OVERRIDE_CODE IN ('01','05','10','15','20','25','30','35') THEN
1401: indx := indx + 1;
1402: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || g_error_string|| ' ' || 'CREDIT_OVERRIDE_CODE';
1403: p_status := FALSE;

Line 1413: ELSIF igf_ap_gen.get_lookup_meaning('IGF_SL_CREDIT_OVERRIDE',p_interface.CREDIT_OVERRIDE_CODE) IS NULL

1409: indx := indx + 1;
1410: fnd_message.set_name('IGF','IGF_SL_CREDIT_OVERRIDE_REQ');
1411: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || fnd_message.get;
1412: p_status := FALSE;
1413: ELSIF igf_ap_gen.get_lookup_meaning('IGF_SL_CREDIT_OVERRIDE',p_interface.CREDIT_OVERRIDE_CODE) IS NULL
1414: OR p_interface.CREDIT_OVERRIDE_CODE IN ('01','05','10','15','20','25','30','35') THEN
1415: indx := indx + 1;
1416: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || g_error_string|| ' ' || 'CREDIT_OVERRIDE_CODE';
1417: p_status := FALSE;

Line 1485: IF igf_ap_gen.get_lookup_meaning('IGF_SL_DL_PNOTE_STATUS',p_interface.PNOTE_STATUS_CODE) IS NULL

1481: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || g_error_string|| ' ' || 'PNOTE_STATUS_CODE';
1482: p_status := FALSE;
1483: END IF;
1484: ELSIF p_interface.LOAN_STATUS_CODE = 'G' THEN
1485: IF igf_ap_gen.get_lookup_meaning('IGF_SL_DL_PNOTE_STATUS',p_interface.PNOTE_STATUS_CODE) IS NULL
1486: OR p_interface.PNOTE_STATUS_CODE IN ('A','C','F','I','R','X') THEN
1487: indx := indx + 1;
1488: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || g_error_string|| ' ' || 'PNOTE_STATUS_CODE';
1489: p_status := FALSE;

Line 1492: IF igf_ap_gen.get_lookup_meaning('IGF_SL_DL_PNOTE_STATUS',p_interface.PNOTE_STATUS_CODE) IS NULL THEN

1488: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || g_error_string|| ' ' || 'PNOTE_STATUS_CODE';
1489: p_status := FALSE;
1490: END IF;
1491: ELSIF p_interface.LOAN_STATUS_CODE = 'A' THEN
1492: IF igf_ap_gen.get_lookup_meaning('IGF_SL_DL_PNOTE_STATUS',p_interface.PNOTE_STATUS_CODE) IS NULL THEN
1493: indx := indx + 1;
1494: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || g_error_string|| ' ' || 'PNOTE_STATUS_CODE';
1495: p_status := FALSE;
1496: END IF;

Line 1507: IF igf_ap_gen.get_lookup_meaning('IGF_SL_PNOTE_TYPE',p_interface.PNOTE_STATUS_TYPE) IS NULL THEN

1503: indx := indx + 1;
1504: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || g_error_string|| ' ' || 'PNOTE_STATUS_TYPE';
1505: p_status := FALSE;
1506: ELSIF p_interface.PNOTE_STATUS_TYPE IS NOT NULL THEN
1507: IF igf_ap_gen.get_lookup_meaning('IGF_SL_PNOTE_TYPE',p_interface.PNOTE_STATUS_TYPE) IS NULL THEN
1508: indx := indx + 1;
1509: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || g_error_string|| ' ' || 'PNOTE_STATUS_TYPE';
1510: p_status := FALSE;
1511: END IF;

Line 1533: IF igf_ap_gen.get_lookup_meaning('IGF_SL_PNOTE_PRINT_IND',p_interface.PNOTE_PRINT_IND_CODE) IS NULL

1529: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || g_error_string|| ' ' || 'PNOTE_PRINT_IND_CODE';
1530: p_status := FALSE;
1531: ELSIF p_interface.PNOTE_PRINT_IND_CODE IS NOT NULL THEN
1532: IF g_award_year = '3' THEN
1533: IF igf_ap_gen.get_lookup_meaning('IGF_SL_PNOTE_PRINT_IND',p_interface.PNOTE_PRINT_IND_CODE) IS NULL
1534: OR p_interface.PNOTE_PRINT_IND_CODE = 'V' THEN
1535: indx := indx + 1;
1536: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || g_error_string|| ' ' || 'PNOTE_PRINT_IND_CODE';
1537: p_status := FALSE;

Line 1540: IF igf_ap_gen.get_lookup_meaning('IGF_SL_PNOTE_PRINT_IND',p_interface.PNOTE_PRINT_IND_CODE) IS NULL THEN

1536: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || g_error_string|| ' ' || 'PNOTE_PRINT_IND_CODE';
1537: p_status := FALSE;
1538: END IF;
1539: ELSIF g_award_year IN ('4','5') THEN
1540: IF igf_ap_gen.get_lookup_meaning('IGF_SL_PNOTE_PRINT_IND',p_interface.PNOTE_PRINT_IND_CODE) IS NULL THEN
1541: indx := indx + 1;
1542: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || g_error_string|| ' ' || 'PNOTE_PRINT_IND_CODE';
1543: p_status := FALSE;
1544: END IF;

Line 1601: IF igf_ap_gen.get_lookup_meaning('IGF_SL_S_DEFAULT_STATUS',p_interface.S_DEFAULT_STATUS_CODE) IS NULL THEN

1597: END IF;
1598:
1599: -- Validations for s_default_status_code
1600: IF p_interface.S_DEFAULT_STATUS_CODE IS NOT NULL THEN
1601: IF igf_ap_gen.get_lookup_meaning('IGF_SL_S_DEFAULT_STATUS',p_interface.S_DEFAULT_STATUS_CODE) IS NULL THEN
1602: indx := indx + 1;
1603: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || g_error_string|| ' ' || 'S_DEFAULT_STATUS_CODE';
1604: p_status := FALSE;
1605: END IF;

Line 1610: IF igf_ap_gen.get_lookup_meaning('IGF_SL_P_DEFAULT_STATUS',p_interface.P_DEFAULT_STATUS_CODE) IS NULL THEN

1606: END IF;
1607:
1608: -- Validations for p_default_status_code
1609: IF p_interface.P_DEFAULT_STATUS_CODE IS NOT NULL THEN
1610: IF igf_ap_gen.get_lookup_meaning('IGF_SL_P_DEFAULT_STATUS',p_interface.P_DEFAULT_STATUS_CODE) IS NULL THEN
1611: indx := indx + 1;
1612: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || g_error_string|| ' ' || 'P_DEFAULT_STATUS_CODE';
1613: p_status := FALSE;
1614: END IF;

Line 1630: IF igf_ap_gen.get_lookup_meaning('IGF_SL_CREDIT_STATUS',p_interface.credit_status) IS NULL THEN

1626: END IF;
1627: END IF;
1628:
1629: IF p_interface.credit_status IS NOT NULL THEN
1630: IF igf_ap_gen.get_lookup_meaning('IGF_SL_CREDIT_STATUS',p_interface.credit_status) IS NULL THEN
1631: indx := indx + 1;
1632: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
1633: fnd_message.set_token('FIELD','CREDIT_STATUS');
1634: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || fnd_message.get();

Line 3351: l_error := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','ERROR');

3347: retcode := 0;
3348: l_cal_type := LTRIM(RTRIM(SUBSTR(p_awd_yr,1,10)));
3349: l_seq_number := TO_NUMBER(SUBSTR(p_awd_yr,11));
3350:
3351: l_error := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','ERROR');
3352: l_processing := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PROCESSING');
3353: l_person_number := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER');
3354: l_loan_disb := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','LOAN_DISB');
3355: l_loan_id_msg := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','LOAN_ID');

Line 3352: l_processing := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PROCESSING');

3348: l_cal_type := LTRIM(RTRIM(SUBSTR(p_awd_yr,1,10)));
3349: l_seq_number := TO_NUMBER(SUBSTR(p_awd_yr,11));
3350:
3351: l_error := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','ERROR');
3352: l_processing := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PROCESSING');
3353: l_person_number := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER');
3354: l_loan_disb := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','LOAN_DISB');
3355: l_loan_id_msg := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','LOAN_ID');
3356:

Line 3353: l_person_number := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER');

3349: l_seq_number := TO_NUMBER(SUBSTR(p_awd_yr,11));
3350:
3351: l_error := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','ERROR');
3352: l_processing := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PROCESSING');
3353: l_person_number := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER');
3354: l_loan_disb := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','LOAN_DISB');
3355: l_loan_id_msg := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','LOAN_ID');
3356:
3357:

Line 3354: l_loan_disb := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','LOAN_DISB');

3350:
3351: l_error := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','ERROR');
3352: l_processing := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PROCESSING');
3353: l_person_number := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER');
3354: l_loan_disb := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','LOAN_DISB');
3355: l_loan_id_msg := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','LOAN_ID');
3356:
3357:
3358: g_error_string := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG', 'ENTITY_NAME') ;

Line 3355: l_loan_id_msg := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','LOAN_ID');

3351: l_error := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','ERROR');
3352: l_processing := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','PROCESSING');
3353: l_person_number := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG','PERSON_NUMBER');
3354: l_loan_disb := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','LOAN_DISB');
3355: l_loan_id_msg := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','LOAN_ID');
3356:
3357:
3358: g_error_string := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG', 'ENTITY_NAME') ;
3359:

Line 3358: g_error_string := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG', 'ENTITY_NAME') ;

3354: l_loan_disb := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','LOAN_DISB');
3355: l_loan_id_msg := igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','LOAN_ID');
3356:
3357:
3358: g_error_string := igf_ap_gen.get_lookup_meaning('IGF_AW_LOOKUPS_MSG', 'ENTITY_NAME') ;
3359:
3360: -- Get the Award Year Alternate Code
3361: OPEN c_alternate_code( l_cal_type, l_seq_number ) ;
3362: FETCH c_alternate_code INTO l_alternate_code ;

Line 3379: l_chk_profile := igf_ap_gen.check_profile;

3375:
3376: -- Check if the profiles are set
3377: -- if country code is not'US' AND does not participate in financial aidprogram THEN
3378: -- write into the log file and exit process
3379: l_chk_profile := igf_ap_gen.check_profile;
3380:
3381: IF l_chk_profile = 'N' THEN
3382: fnd_message.set_name('IGF','IGF_AP_LGCY_PROC_NOT_RUN');
3383: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

Line 3388: l_batch_valid := igf_ap_gen.check_batch ( p_batch_id, 'LOANS') ;

3384: RETURN;
3385: END IF;
3386:
3387: -- Check If the Batch Entered is Valid or Not. If not Valid then error out
3388: l_batch_valid := igf_ap_gen.check_batch ( p_batch_id, 'LOANS') ;
3389: IF NVL(l_batch_valid,'N') <> 'Y' THEN
3390: -- Bug # 4008991
3391: fnd_message.set_name('IGF','IGF_SL_GR_BATCH_DOES_NO_EXIST');
3392: fnd_message.set_token('BATCH_ID',p_batch_id);

Line 3455: igf_ap_gen.check_person(l_interface.person_number,l_cal_type,l_seq_number,lv_person_id,lv_base_id);

3451: END IF;
3452: fnd_file.put_line(fnd_file.log,l_processing ||' '||l_person_number||' '||l_interface.person_number);
3453: fnd_file.new_line(fnd_file.log,1);
3454: -- check if person exists in oss
3455: igf_ap_gen.check_person(l_interface.person_number,l_cal_type,l_seq_number,lv_person_id,lv_base_id);
3456: l_debug_str := l_debug_str ||' Processing for person number ' || l_interface.person_number;
3457: IF lv_person_id IS NULL THEN
3458: fnd_message.set_name('IGF','IGF_AP_PE_NOT_EXIST');
3459: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

Line 3913: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_PROCESSED'), 40) || ' : ' || TO_CHAR(l_total_record_cnt));

3909: RETURN;
3910: END IF;
3911: -- Print in the out put file the total number of records successfully imported.
3912:
3913: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_PROCESSED'), 40) || ' : ' || TO_CHAR(l_total_record_cnt));
3914: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_SUCCESSFUL'), 40) || ' : ' || TO_CHAR(l_success_record_cnt));
3915: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_REJECTED'), 40) || ' : ' || TO_CHAR(l_total_record_cnt - l_success_record_cnt));
3916:
3917:

Line 3914: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_SUCCESSFUL'), 40) || ' : ' || TO_CHAR(l_success_record_cnt));

3910: END IF;
3911: -- Print in the out put file the total number of records successfully imported.
3912:
3913: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_PROCESSED'), 40) || ' : ' || TO_CHAR(l_total_record_cnt));
3914: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_SUCCESSFUL'), 40) || ' : ' || TO_CHAR(l_success_record_cnt));
3915: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_REJECTED'), 40) || ' : ' || TO_CHAR(l_total_record_cnt - l_success_record_cnt));
3916:
3917:
3918: EXCEPTION

Line 3915: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_REJECTED'), 40) || ' : ' || TO_CHAR(l_total_record_cnt - l_success_record_cnt));

3911: -- Print in the out put file the total number of records successfully imported.
3912:
3913: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_PROCESSED'), 40) || ' : ' || TO_CHAR(l_total_record_cnt));
3914: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_SUCCESSFUL'), 40) || ' : ' || TO_CHAR(l_success_record_cnt));
3915: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_REJECTED'), 40) || ' : ' || TO_CHAR(l_total_record_cnt - l_success_record_cnt));
3916:
3917:
3918: EXCEPTION
3919: