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 FND_MESSAGE

Line 171: fnd_message.set_name('IGS','IGS_GE_ASK_DEL_REC');

167: OPEN c_batch_desc( p_batch_num) ;
168: FETCH c_batch_desc INTO l_batch_desc, l_batch_type ;
169: CLOSE c_batch_desc ;
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');

Line 172: l_delete_flag_prmpt := fnd_message.get ;

168: FETCH c_batch_desc INTO l_batch_desc, l_batch_type ;
169: CLOSE c_batch_desc ;
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');

Line 227: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

223: WHEN others THEN
224: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
225: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_li_imp_pkg.print_message.exception','Exception :'||SQLERRM);
226: END IF;
227: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
228: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.PRINT_MESSAGE');
229: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
230:
231: RAISE IMPORT_ERROR;

Line 228: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.PRINT_MESSAGE');

224: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
225: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_li_imp_pkg.print_message.exception','Exception :'||SQLERRM);
226: END IF;
227: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
228: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.PRINT_MESSAGE');
229: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
230:
231: RAISE IMPORT_ERROR;
232:

Line 229: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);

225: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_li_imp_pkg.print_message.exception','Exception :'||SQLERRM);
226: END IF;
227: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
228: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.PRINT_MESSAGE');
229: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
230:
231: RAISE IMPORT_ERROR;
232:
233: END print_message;

Line 1066: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

1062: WHEN others THEN
1063: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1064: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_li_imp_pkg.validate_loan_disb.exception','Exception: '||SQLERRM);
1065: END IF;
1066: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1067: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.VALIDATE_LOAN_DISB');
1068: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
1069:
1070: RAISE IMPORT_ERROR;

Line 1067: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.VALIDATE_LOAN_DISB');

1063: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1064: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_li_imp_pkg.validate_loan_disb.exception','Exception: '||SQLERRM);
1065: END IF;
1066: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1067: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.VALIDATE_LOAN_DISB');
1068: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
1069:
1070: RAISE IMPORT_ERROR;
1071:

Line 1068: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);

1064: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_li_imp_pkg.validate_loan_disb.exception','Exception: '||SQLERRM);
1065: END IF;
1066: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1067: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.VALIDATE_LOAN_DISB');
1068: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
1069:
1070: RAISE IMPORT_ERROR;
1071:
1072: END validate_loan_disb;

Line 1118: fnd_message.set_name('IGF','IGF_SL_INVAL_DL_ID');

1114: -- validate loan number
1115: l_valid := is_loan_number_valid(p_interface.loan_number_txt);
1116: IF (p_interface.loan_number_txt IS NULL) OR (l_valid = FALSE) THEN
1117: indx := indx + 1;
1118: fnd_message.set_name('IGF','IGF_SL_INVAL_DL_ID');
1119: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || fnd_message.get;
1120: p_status := FALSE;
1121: END IF;
1122:

Line 1119: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || fnd_message.get;

1115: l_valid := is_loan_number_valid(p_interface.loan_number_txt);
1116: IF (p_interface.loan_number_txt IS NULL) OR (l_valid = FALSE) THEN
1117: indx := indx + 1;
1118: fnd_message.set_name('IGF','IGF_SL_INVAL_DL_ID');
1119: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || fnd_message.get;
1120: p_status := FALSE;
1121: END IF;
1122:
1123: -- Validate loan_seq_num

Line 1164: fnd_message.set_name('IGF','IGF_SL_LI_INVALID_CHG_STAT');

1160: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || g_error_string|| ' ' || 'LOAN_CHG_STATUS';
1161: p_status := FALSE;
1162: ELSIF p_interface.loan_chg_status IN ('A','R') AND p_interface.loan_status_code <> 'A' THEN
1163: indx := indx + 1;
1164: fnd_message.set_name('IGF','IGF_SL_LI_INVALID_CHG_STAT');
1165: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || fnd_message.get;
1166: p_status := FALSE;
1167: END IF;
1168: END IF;

Line 1165: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || fnd_message.get;

1161: p_status := FALSE;
1162: ELSIF p_interface.loan_chg_status IN ('A','R') AND p_interface.loan_status_code <> 'A' THEN
1163: indx := indx + 1;
1164: fnd_message.set_name('IGF','IGF_SL_LI_INVALID_CHG_STAT');
1165: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || fnd_message.get;
1166: p_status := FALSE;
1167: END IF;
1168: END IF;
1169:

Line 1205: fnd_message.set_name('IGF','IGF_SL_INVALID_FLD');

1201: IF p_interface.loan_status_code IN ('A') THEN
1202: IF p_interface.orig_send_batch_id_txt IS NULL THEN
1203: -- error out displaying the appropriate message
1204: indx := indx + 1;
1205: fnd_message.set_name('IGF','IGF_SL_INVALID_FLD');
1206: fnd_message.set_token('FIELD','ORIG_SEND_BATCH_ID_TXT');
1207: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || fnd_message.get();
1208: p_status := FALSE;
1209: END IF;

Line 1206: fnd_message.set_token('FIELD','ORIG_SEND_BATCH_ID_TXT');

1202: IF p_interface.orig_send_batch_id_txt IS NULL THEN
1203: -- error out displaying the appropriate message
1204: indx := indx + 1;
1205: fnd_message.set_name('IGF','IGF_SL_INVALID_FLD');
1206: fnd_message.set_token('FIELD','ORIG_SEND_BATCH_ID_TXT');
1207: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || fnd_message.get();
1208: p_status := FALSE;
1209: END IF;
1210: ELSE

Line 1207: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || fnd_message.get();

1203: -- error out displaying the appropriate message
1204: indx := indx + 1;
1205: fnd_message.set_name('IGF','IGF_SL_INVALID_FLD');
1206: fnd_message.set_token('FIELD','ORIG_SEND_BATCH_ID_TXT');
1207: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || fnd_message.get();
1208: p_status := FALSE;
1209: END IF;
1210: ELSE
1211: l_valid := is_batch_id_valid(p_interface.orig_send_batch_id_txt);

Line 1232: fnd_message.set_name('IGF','IGF_SL_UNSUB_ELIG_REQ');

1228: IF l_award_year_status = 'O' THEN
1229: IF p_interface.LOAN_STATUS_CODE = 'A' AND lv_fed_fund_code = 'DLU' THEN
1230: IF 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;

Line 1233: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || fnd_message.get;

1229: IF p_interface.LOAN_STATUS_CODE = 'A' AND lv_fed_fund_code = 'DLU' THEN
1230: IF 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';

Line 1273: fnd_message.set_name('IGF','IGF_SL_DEF_STAT_REQ');

1269: IF l_award_year_status = 'O' THEN
1270: IF p_interface.LOAN_STATUS_CODE = 'A' AND lv_fed_fund_code = 'DLP' THEN
1271: IF p_interface.S_DEFAULT_STATUS_CODE IS NULL THEN
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

Line 1274: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || fnd_message.get;

1270: IF p_interface.LOAN_STATUS_CODE = 'A' AND lv_fed_fund_code = 'DLP' THEN
1271: IF p_interface.S_DEFAULT_STATUS_CODE IS NULL THEN
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;

Line 1300: fnd_message.set_name('IGF','IGF_SL_PNOTE_ACCEPT_AMT_REQ');

1296:
1297: IF p_interface.LOAN_STATUS_CODE = 'A' AND lv_fed_fund_code = 'DLP' THEN
1298: IF p_interface.PNOTE_ACCEPT_AMT IS NULL THEN
1299: indx := indx + 1;
1300: fnd_message.set_name('IGF','IGF_SL_PNOTE_ACCEPT_AMT_REQ');
1301: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || fnd_message.get;
1302: p_status := FALSE;
1303: ELSIF NVL(p_interface.PNOTE_ACCEPT_AMT,0) < 0 THEN
1304: indx := indx + 1;

Line 1301: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || fnd_message.get;

1297: IF p_interface.LOAN_STATUS_CODE = 'A' AND lv_fed_fund_code = 'DLP' THEN
1298: IF p_interface.PNOTE_ACCEPT_AMT IS NULL THEN
1299: indx := indx + 1;
1300: fnd_message.set_name('IGF','IGF_SL_PNOTE_ACCEPT_AMT_REQ');
1301: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || fnd_message.get;
1302: p_status := FALSE;
1303: ELSIF NVL(p_interface.PNOTE_ACCEPT_AMT,0) < 0 THEN
1304: indx := indx + 1;
1305: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || g_error_string|| ' ' || 'PNOTE_ACCEPT_AMT';

Line 1331: fnd_message.set_name('IGF','IGF_SL_UNSUB_ELG_HEAL_REQ');

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;
1334: END IF;
1335: ELSIF lv_fed_fund_code = 'DLU' AND p_interface.UNSUB_ELIG_FOR_HEAL_CODE IS NOT NULL THEN

Line 1332: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || fnd_message.get;

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

Line 1338: fnd_message.set_name('IGF','IGF_SL_UNSUB_ELG_HEAL_REQ');

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

Line 1339: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || fnd_message.get;

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;
1341: END IF;
1342: END IF;
1343:

Line 1377: fnd_message.set_name('IGF','IGF_SL_CREDIT_DECS_DATE_REQ');

1373: IF l_award_year_status = 'O' THEN
1374: IF lv_fed_fund_code = 'DLP' THEN
1375: IF p_interface.loan_status_code = 'A' AND p_interface.CREDIT_DECISION_DATE IS NULL THEN
1376: indx := indx + 1;
1377: fnd_message.set_name('IGF','IGF_SL_CREDIT_DECS_DATE_REQ');
1378: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || fnd_message.get;
1379: p_status := FALSE;
1380: ELSIF p_interface.CREDIT_DECISION_DATE IS NOT NULL THEN
1381: IF NOT Val_Date(TO_CHAR(p_interface.CREDIT_DECISION_DATE,'YYYYMMDD')) THEN

Line 1378: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || fnd_message.get;

1374: IF lv_fed_fund_code = 'DLP' THEN
1375: IF p_interface.loan_status_code = 'A' AND p_interface.CREDIT_DECISION_DATE IS NULL THEN
1376: indx := indx + 1;
1377: fnd_message.set_name('IGF','IGF_SL_CREDIT_DECS_DATE_REQ');
1378: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || fnd_message.get;
1379: p_status := FALSE;
1380: ELSIF p_interface.CREDIT_DECISION_DATE IS NOT NULL THEN
1381: IF NOT Val_Date(TO_CHAR(p_interface.CREDIT_DECISION_DATE,'YYYYMMDD')) THEN
1382: indx := indx + 1;

Line 1410: fnd_message.set_name('IGF','IGF_SL_CREDIT_OVERRIDE_REQ');

1406: IF l_award_year_status = 'O' THEN
1407: IF p_interface.LOAN_STATUS_CODE = 'A' AND lv_fed_fund_code = 'DLP' THEN
1408: IF p_interface.CREDIT_OVERRIDE_CODE IS NULL THEN
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

Line 1411: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || fnd_message.get;

1407: IF p_interface.LOAN_STATUS_CODE = 'A' AND lv_fed_fund_code = 'DLP' THEN
1408: IF p_interface.CREDIT_OVERRIDE_CODE IS NULL THEN
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;

Line 1622: fnd_message.set_name('IGF','IGF_SL_INVALID_FLD');

1618: -- has to be not null to be inserted in the igf_sl_dl_lor_resp ,igf_sl_dl_batch table
1619: IF p_interface.loan_status_code IN ('A') THEN
1620: IF p_interface.orig_acknowledgement_date IS NULL THEN
1621: indx := indx + 1;
1622: fnd_message.set_name('IGF','IGF_SL_INVALID_FLD');
1623: fnd_message.set_token('FIELD','ORIG_ACKNOWLEDGEMENT_DATE');
1624: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || fnd_message.get();
1625: p_status := FALSE;
1626: END IF;

Line 1623: fnd_message.set_token('FIELD','ORIG_ACKNOWLEDGEMENT_DATE');

1619: IF p_interface.loan_status_code IN ('A') THEN
1620: IF p_interface.orig_acknowledgement_date IS NULL THEN
1621: indx := indx + 1;
1622: fnd_message.set_name('IGF','IGF_SL_INVALID_FLD');
1623: fnd_message.set_token('FIELD','ORIG_ACKNOWLEDGEMENT_DATE');
1624: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || fnd_message.get();
1625: p_status := FALSE;
1626: END IF;
1627: END IF;

Line 1624: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || fnd_message.get();

1620: IF p_interface.orig_acknowledgement_date IS NULL THEN
1621: indx := indx + 1;
1622: fnd_message.set_name('IGF','IGF_SL_INVALID_FLD');
1623: fnd_message.set_token('FIELD','ORIG_ACKNOWLEDGEMENT_DATE');
1624: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || fnd_message.get();
1625: p_status := FALSE;
1626: END IF;
1627: END IF;
1628:

Line 1632: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');

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();
1635: p_status := FALSE;
1636: ELSE

Line 1633: fnd_message.set_token('FIELD','CREDIT_STATUS');

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();
1635: p_status := FALSE;
1636: ELSE
1637: IF p_interface.loan_status_code = 'A' AND p_interface.credit_status = 'D' THEN

Line 1634: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || fnd_message.get();

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();
1635: p_status := FALSE;
1636: ELSE
1637: IF p_interface.loan_status_code = 'A' AND p_interface.credit_status = 'D' THEN
1638: indx := indx + 1;

Line 1639: fnd_message.set_name('IGF','IGF_SL_DEC_LOAN_CRDT');

1635: p_status := FALSE;
1636: ELSE
1637: IF p_interface.loan_status_code = 'A' AND p_interface.credit_status = 'D' THEN
1638: indx := indx + 1;
1639: fnd_message.set_name('IGF','IGF_SL_DEC_LOAN_CRDT');
1640: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || fnd_message.get();
1641: p_status := FALSE;
1642: END IF;
1643: END IF;

Line 1640: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || fnd_message.get();

1636: ELSE
1637: IF p_interface.loan_status_code = 'A' AND p_interface.credit_status = 'D' THEN
1638: indx := indx + 1;
1639: fnd_message.set_name('IGF','IGF_SL_DEC_LOAN_CRDT');
1640: p_igf_sl_msg_table(indx).msg_text := RPAD(l_error,12) || fnd_message.get();
1641: p_status := FALSE;
1642: END IF;
1643: END IF;
1644: END IF;

Line 1652: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

1648: WHEN others THEN
1649: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1650: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_li_imp_pkg.validate_loan_orig_int.exception','Exception: '||SQLERRM);
1651: END IF;
1652: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1653: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.VALIDATE_LOAN_ORIG_INT');
1654: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
1655:
1656: RAISE IMPORT_ERROR;

Line 1653: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.VALIDATE_LOAN_ORIG_INT');

1649: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1650: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_li_imp_pkg.validate_loan_orig_int.exception','Exception: '||SQLERRM);
1651: END IF;
1652: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1653: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.VALIDATE_LOAN_ORIG_INT');
1654: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
1655:
1656: RAISE IMPORT_ERROR;
1657:

Line 1654: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);

1650: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_li_imp_pkg.validate_loan_orig_int.exception','Exception: '||SQLERRM);
1651: END IF;
1652: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1653: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.VALIDATE_LOAN_ORIG_INT');
1654: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
1655:
1656: RAISE IMPORT_ERROR;
1657:
1658: END validate_loan_orig_int;

Line 1698: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

1694: x_external_loan_id_txt => NULL
1695: );
1696: EXCEPTION
1697: WHEN OTHERS THEN
1698: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1699: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.LOANS_INSERT_ROW');
1700: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
1701:
1702: RAISE IMPORT_ERROR;

Line 1699: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.LOANS_INSERT_ROW');

1695: );
1696: EXCEPTION
1697: WHEN OTHERS THEN
1698: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1699: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.LOANS_INSERT_ROW');
1700: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
1701:
1702: RAISE IMPORT_ERROR;
1703: END loans_insert_row;

Line 1700: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);

1696: EXCEPTION
1697: WHEN OTHERS THEN
1698: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1699: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.LOANS_INSERT_ROW');
1700: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
1701:
1702: RAISE IMPORT_ERROR;
1703: END loans_insert_row;
1704:

Line 1870: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

1866: x_acad_end_date => NULL);
1867:
1868: EXCEPTION
1869: WHEN OTHERS THEN
1870: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1871: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.LOANS_ORIG_INSERT_ROW');
1872: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
1873:
1874: RAISE IMPORT_ERROR;

Line 1871: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.LOANS_ORIG_INSERT_ROW');

1867:
1868: EXCEPTION
1869: WHEN OTHERS THEN
1870: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1871: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.LOANS_ORIG_INSERT_ROW');
1872: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
1873:
1874: RAISE IMPORT_ERROR;
1875: END loans_orig_insert_row;

Line 1872: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);

1868: EXCEPTION
1869: WHEN OTHERS THEN
1870: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1871: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.LOANS_ORIG_INSERT_ROW');
1872: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
1873:
1874: RAISE IMPORT_ERROR;
1875: END loans_orig_insert_row;
1876:

Line 2211: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

2207:
2208:
2209: EXCEPTION
2210: WHEN OTHERS THEN
2211: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2212: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.LOANS_ORIG_LOC_INSERT_ROW');
2213: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
2214:
2215: RAISE IMPORT_ERROR;

Line 2212: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.LOANS_ORIG_LOC_INSERT_ROW');

2208:
2209: EXCEPTION
2210: WHEN OTHERS THEN
2211: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2212: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.LOANS_ORIG_LOC_INSERT_ROW');
2213: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
2214:
2215: RAISE IMPORT_ERROR;
2216:

Line 2213: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);

2209: EXCEPTION
2210: WHEN OTHERS THEN
2211: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2212: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.LOANS_ORIG_LOC_INSERT_ROW');
2213: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
2214:
2215: RAISE IMPORT_ERROR;
2216:
2217: END loans_orig_loc_insert_row;

Line 2253: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

2249: x_elec_mpn_ind => p_interface.pnote_status_type
2250: );
2251: EXCEPTION
2252: WHEN OTHERS THEN
2253: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2254: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.LOR_RESP_INSERT_ROW');
2255: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
2256:
2257: RAISE IMPORT_ERROR;

Line 2254: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.LOR_RESP_INSERT_ROW');

2250: );
2251: EXCEPTION
2252: WHEN OTHERS THEN
2253: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2254: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.LOR_RESP_INSERT_ROW');
2255: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
2256:
2257: RAISE IMPORT_ERROR;
2258:

Line 2255: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);

2251: EXCEPTION
2252: WHEN OTHERS THEN
2253: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2254: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.LOR_RESP_INSERT_ROW');
2255: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
2256:
2257: RAISE IMPORT_ERROR;
2258:
2259: END lor_resp_insert_row;

Line 2293: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

2289: x_mpn_indicator => p_interface.pnote_indicator_code
2290: );
2291: EXCEPTION
2292: WHEN OTHERS THEN
2293: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2294: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.LOR_CRRESP_INSERT_ROW');
2295: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
2296:
2297: RAISE IMPORT_ERROR;

Line 2294: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.LOR_CRRESP_INSERT_ROW');

2290: );
2291: EXCEPTION
2292: WHEN OTHERS THEN
2293: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2294: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.LOR_CRRESP_INSERT_ROW');
2295: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
2296:
2297: RAISE IMPORT_ERROR;
2298:

Line 2295: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);

2291: EXCEPTION
2292: WHEN OTHERS THEN
2293: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2294: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.LOR_CRRESP_INSERT_ROW');
2295: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
2296:
2297: RAISE IMPORT_ERROR;
2298:
2299: END lor_crresp_insert_row;

Line 2332: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

2328: x_mode => 'R',
2329: x_elec_mpn_ind => p_interface.pnote_status_type);
2330: EXCEPTION
2331: WHEN OTHERS THEN
2332: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2333: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.PNOTE_RESP_INSERT_ROW');
2334: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
2335:
2336: RAISE IMPORT_ERROR;

Line 2333: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.PNOTE_RESP_INSERT_ROW');

2329: x_elec_mpn_ind => p_interface.pnote_status_type);
2330: EXCEPTION
2331: WHEN OTHERS THEN
2332: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2333: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.PNOTE_RESP_INSERT_ROW');
2334: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
2335:
2336: RAISE IMPORT_ERROR;
2337:

Line 2334: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);

2330: EXCEPTION
2331: WHEN OTHERS THEN
2332: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2333: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.PNOTE_RESP_INSERT_ROW');
2334: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
2335:
2336: RAISE IMPORT_ERROR;
2337:
2338: END pnote_resp_insert_row;

Line 2503: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

2499: x_status => 'Y'
2500: );
2501: EXCEPTION
2502: WHEN OTHERS THEN
2503: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2504: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.PNOTE_INSERT_ROW');
2505: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
2506:
2507: RAISE IMPORT_ERROR;

Line 2504: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.PNOTE_INSERT_ROW');

2500: );
2501: EXCEPTION
2502: WHEN OTHERS THEN
2503: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2504: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.PNOTE_INSERT_ROW');
2505: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
2506:
2507: RAISE IMPORT_ERROR;
2508:

Line 2505: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);

2501: EXCEPTION
2502: WHEN OTHERS THEN
2503: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2504: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.PNOTE_INSERT_ROW');
2505: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
2506:
2507: RAISE IMPORT_ERROR;
2508:
2509: END pnote_insert_row;

Line 2565: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

2561: x_status => 'N'
2562: );
2563: EXCEPTION
2564: WHEN OTHERS THEN
2565: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2566: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.DISB_RESP_INSERT_ROW');
2567: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
2568:
2569: RAISE IMPORT_ERROR;

Line 2566: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.DISB_RESP_INSERT_ROW');

2562: );
2563: EXCEPTION
2564: WHEN OTHERS THEN
2565: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2566: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.DISB_RESP_INSERT_ROW');
2567: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
2568:
2569: RAISE IMPORT_ERROR;
2570:

Line 2567: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);

2563: EXCEPTION
2564: WHEN OTHERS THEN
2565: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2566: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.DISB_RESP_INSERT_ROW');
2567: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
2568:
2569: RAISE IMPORT_ERROR;
2570:
2571: END disb_resp_insert_row;

Line 2648: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

2644: x_ld_sequence_number => l_rec_disb_dtl.ld_sequence_number
2645: );
2646: EXCEPTION
2647: WHEN OTHERS THEN
2648: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2649: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.DB_AWD_DISB_UPDATE_ROW');
2650: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
2651:
2652: RAISE IMPORT_ERROR;

Line 2649: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.DB_AWD_DISB_UPDATE_ROW');

2645: );
2646: EXCEPTION
2647: WHEN OTHERS THEN
2648: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2649: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.DB_AWD_DISB_UPDATE_ROW');
2650: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
2651:
2652: RAISE IMPORT_ERROR;
2653:

Line 2650: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);

2646: EXCEPTION
2647: WHEN OTHERS THEN
2648: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2649: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.DB_AWD_DISB_UPDATE_ROW');
2650: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
2651:
2652: RAISE IMPORT_ERROR;
2653:
2654: END db_awd_disb_update_row;

Line 2685: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

2681: );
2682:
2683: EXCEPTION
2684: WHEN OTHERS THEN
2685: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2686: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.DL_CHG_SEND_INSERT_ROW');
2687: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
2688:
2689: RAISE IMPORT_ERROR;

Line 2686: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.DL_CHG_SEND_INSERT_ROW');

2682:
2683: EXCEPTION
2684: WHEN OTHERS THEN
2685: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2686: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.DL_CHG_SEND_INSERT_ROW');
2687: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
2688:
2689: RAISE IMPORT_ERROR;
2690:

Line 2687: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);

2683: EXCEPTION
2684: WHEN OTHERS THEN
2685: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2686: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.DL_CHG_SEND_INSERT_ROW');
2687: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
2688:
2689: RAISE IMPORT_ERROR;
2690:
2691: END dl_chg_send_insert_row;

Line 2725: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

2721: X_status => 'N'
2722: );
2723: EXCEPTION
2724: WHEN OTHERS THEN
2725: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2726: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.DL_CHG_RESP_INSERT_ROW');
2727: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
2728:
2729: RAISE IMPORT_ERROR;

Line 2726: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.DL_CHG_RESP_INSERT_ROW');

2722: );
2723: EXCEPTION
2724: WHEN OTHERS THEN
2725: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2726: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.DL_CHG_RESP_INSERT_ROW');
2727: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
2728:
2729: RAISE IMPORT_ERROR;
2730:

Line 2727: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);

2723: EXCEPTION
2724: WHEN OTHERS THEN
2725: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2726: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.DL_CHG_RESP_INSERT_ROW');
2727: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
2728:
2729: RAISE IMPORT_ERROR;
2730:
2731: END dl_chg_resp_insert_row;

Line 2812: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

2808: x_status => 'N');
2809:
2810: EXCEPTION
2811: WHEN OTHERS THEN
2812: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2813: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.DL_BATCH_INSERT_ROW');
2814: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
2815:
2816: RAISE IMPORT_ERROR;

Line 2813: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.DL_BATCH_INSERT_ROW');

2809:
2810: EXCEPTION
2811: WHEN OTHERS THEN
2812: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2813: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.DL_BATCH_INSERT_ROW');
2814: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
2815:
2816: RAISE IMPORT_ERROR;
2817:

Line 2814: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);

2810: EXCEPTION
2811: WHEN OTHERS THEN
2812: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2813: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.DL_BATCH_INSERT_ROW');
2814: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
2815:
2816: RAISE IMPORT_ERROR;
2817:
2818: END dl_batch_insert_row;

Line 2992: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

2988: WHEN others THEN
2989: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2990: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_li_imp_pkg.delete_context_records.exception','Exception:'||SQLERRM);
2991: END IF;
2992: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2993: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.DELETE_CONTEXT_RECORDS');
2994: fnd_file.put_line(fnd_file.log,fnd_message.get || sqlerrm);
2995:
2996: RAISE IMPORT_ERROR;

Line 2993: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.DELETE_CONTEXT_RECORDS');

2989: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2990: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_li_imp_pkg.delete_context_records.exception','Exception:'||SQLERRM);
2991: END IF;
2992: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2993: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.DELETE_CONTEXT_RECORDS');
2994: fnd_file.put_line(fnd_file.log,fnd_message.get || sqlerrm);
2995:
2996: RAISE IMPORT_ERROR;
2997:

Line 2994: fnd_file.put_line(fnd_file.log,fnd_message.get || sqlerrm);

2990: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_li_imp_pkg.delete_context_records.exception','Exception:'||SQLERRM);
2991: END IF;
2992: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2993: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.DELETE_CONTEXT_RECORDS');
2994: fnd_file.put_line(fnd_file.log,fnd_message.get || sqlerrm);
2995:
2996: RAISE IMPORT_ERROR;
2997:
2998: END delete_context_records;

Line 3063: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

3059: END IF;
3060:
3061: EXCEPTION
3062: WHEN OTHERS THEN
3063: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3064: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.INSERT_CONTEXT_RECORDS');
3065: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
3066: RAISE IMPORT_ERROR;
3067:

Line 3064: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.INSERT_CONTEXT_RECORDS');

3060:
3061: EXCEPTION
3062: WHEN OTHERS THEN
3063: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3064: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.INSERT_CONTEXT_RECORDS');
3065: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
3066: RAISE IMPORT_ERROR;
3067:
3068: END insert_context_records;

Line 3065: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);

3061: EXCEPTION
3062: WHEN OTHERS THEN
3063: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3064: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.INSERT_CONTEXT_RECORDS');
3065: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
3066: RAISE IMPORT_ERROR;
3067:
3068: END insert_context_records;
3069:

Line 3092: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

3088: -- update disbursement table
3089: db_awd_disb_update_row(p_disb_interface ,p_award_id);
3090: EXCEPTION
3091: WHEN OTHERS THEN
3092: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3093: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.INSERT_CONTEXT_DISB_RECORDS');
3094: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
3095:
3096: RAISE IMPORT_ERROR;

Line 3093: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.INSERT_CONTEXT_DISB_RECORDS');

3089: db_awd_disb_update_row(p_disb_interface ,p_award_id);
3090: EXCEPTION
3091: WHEN OTHERS THEN
3092: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3093: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.INSERT_CONTEXT_DISB_RECORDS');
3094: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
3095:
3096: RAISE IMPORT_ERROR;
3097:

Line 3094: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);

3090: EXCEPTION
3091: WHEN OTHERS THEN
3092: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3093: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.INSERT_CONTEXT_DISB_RECORDS');
3094: fnd_file.put_line(fnd_file.log,fnd_message.get || SQLERRM);
3095:
3096: RAISE IMPORT_ERROR;
3097:
3098: END insert_context_disb_records;

Line 3382: fnd_message.set_name('IGF','IGF_AP_LGCY_PROC_NOT_RUN');

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);
3384: RETURN;
3385: END IF;
3386:

Line 3383: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

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);
3384: RETURN;
3385: END IF;
3386:
3387: -- Check If the Batch Entered is Valid or Not. If not Valid then error out

Line 3391: fnd_message.set_name('IGF','IGF_SL_GR_BATCH_DOES_NO_EXIST');

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);
3393: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3394: RETURN;
3395: END IF;

Line 3392: fnd_message.set_token('BATCH_ID',p_batch_id);

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);
3393: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3394: RETURN;
3395: END IF;
3396:

Line 3393: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

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);
3393: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3394: RETURN;
3395: END IF;
3396:
3397: -- Check If the Award Year Entered is Valid or Not. If not Valid then error out

Line 3401: fnd_message.set_name('IGF','IGF_AP_AWD_YR_NOT_FOUND');

3397: -- Check If the Award Year Entered is Valid or Not. If not Valid then error out
3398: OPEN c_award_det(l_cal_type,l_seq_number);
3399: FETCH c_award_det INTO l_award_det;
3400: IF c_award_det%NOTFOUND THEN
3401: fnd_message.set_name('IGF','IGF_AP_AWD_YR_NOT_FOUND');
3402: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3403: CLOSE c_award_det;
3404: RETURN;
3405: ELSIF l_award_det.status NOT IN ('LD','O') THEN

Line 3402: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

3398: OPEN c_award_det(l_cal_type,l_seq_number);
3399: FETCH c_award_det INTO l_award_det;
3400: IF c_award_det%NOTFOUND THEN
3401: fnd_message.set_name('IGF','IGF_AP_AWD_YR_NOT_FOUND');
3402: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3403: CLOSE c_award_det;
3404: RETURN;
3405: ELSIF l_award_det.status NOT IN ('LD','O') THEN
3406: fnd_message.set_name('IGF','IGF_AP_LG_INVALID_STAT');

Line 3406: fnd_message.set_name('IGF','IGF_AP_LG_INVALID_STAT');

3402: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3403: CLOSE c_award_det;
3404: RETURN;
3405: ELSIF l_award_det.status NOT IN ('LD','O') THEN
3406: fnd_message.set_name('IGF','IGF_AP_LG_INVALID_STAT');
3407: fnd_message.set_token('AWARD_STATUS',l_award_det.status);
3408: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3409: CLOSE c_award_det;
3410: RETURN;

Line 3407: fnd_message.set_token('AWARD_STATUS',l_award_det.status);

3403: CLOSE c_award_det;
3404: RETURN;
3405: ELSIF l_award_det.status NOT IN ('LD','O') THEN
3406: fnd_message.set_name('IGF','IGF_AP_LG_INVALID_STAT');
3407: fnd_message.set_token('AWARD_STATUS',l_award_det.status);
3408: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3409: CLOSE c_award_det;
3410: RETURN;
3411: ELSE

Line 3408: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

3404: RETURN;
3405: ELSIF l_award_det.status NOT IN ('LD','O') THEN
3406: fnd_message.set_name('IGF','IGF_AP_LG_INVALID_STAT');
3407: fnd_message.set_token('AWARD_STATUS',l_award_det.status);
3408: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3409: CLOSE c_award_det;
3410: RETURN;
3411: ELSE
3412: CLOSE c_award_det;

Line 3458: fnd_message.set_name('IGF','IGF_AP_PE_NOT_EXIST');

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);
3460: l_valid_for_dml := 'N' ;
3461: l_error_flag := TRUE;
3462: END IF;

Line 3459: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

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);
3460: l_valid_for_dml := 'N' ;
3461: l_error_flag := TRUE;
3462: END IF;
3463: l_debug_str := l_debug_str || 'check if person exists in oss- completed';

Line 3467: fnd_message.set_name('IGF','IGF_AP_FABASE_NOT_FOUND');

3463: l_debug_str := l_debug_str || 'check if person exists in oss- completed';
3464: -- check if Base record exists in oss
3465:
3466: IF lv_base_id IS NULL THEN
3467: fnd_message.set_name('IGF','IGF_AP_FABASE_NOT_FOUND');
3468: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3469: l_valid_for_dml := 'N' ;
3470: l_error_flag := TRUE;
3471: END IF;

Line 3468: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

3464: -- check if Base record exists in oss
3465:
3466: IF lv_base_id IS NULL THEN
3467: fnd_message.set_name('IGF','IGF_AP_FABASE_NOT_FOUND');
3468: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3469: l_valid_for_dml := 'N' ;
3470: l_error_flag := TRUE;
3471: END IF;
3472:

Line 3483: fnd_message.set_name('IGF','IGF_SL_STATUS_NOT_RDY');

3479: -- Check if the award year is COD-XML or not
3480: IF (igf_sl_dl_validation.check_full_participant(l_cal_type,l_seq_number,'DL')) THEN
3481: -- Incase of COD-XML award year support loans with ready to send status
3482: IF l_interface.loan_status_code <> 'G' THEN
3483: fnd_message.set_name('IGF','IGF_SL_STATUS_NOT_RDY');
3484: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3485: l_valid_for_dml := 'N' ;
3486: l_error_flag := TRUE;
3487: END IF;

Line 3484: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

3480: IF (igf_sl_dl_validation.check_full_participant(l_cal_type,l_seq_number,'DL')) THEN
3481: -- Incase of COD-XML award year support loans with ready to send status
3482: IF l_interface.loan_status_code <> 'G' THEN
3483: fnd_message.set_name('IGF','IGF_SL_STATUS_NOT_RDY');
3484: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3485: l_valid_for_dml := 'N' ;
3486: l_error_flag := TRUE;
3487: END IF;
3488:

Line 3492: fnd_message.set_name('IGF','IGF_SL_ATD_REP_PELL_NOT_CORR');

3488:
3489: -- Attending and Reporting Pell entity ids must not be null and their combination should be valid
3490:
3491: IF (l_interface.atd_entity_id_txt IS NULL) OR (l_interface.rep_entity_id_txt IS NULL ) THEN
3492: fnd_message.set_name('IGF','IGF_SL_ATD_REP_PELL_NOT_CORR');
3493: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3494: l_valid_for_dml := 'N' ;
3495: l_error_flag := TRUE;
3496:

Line 3493: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

3489: -- Attending and Reporting Pell entity ids must not be null and their combination should be valid
3490:
3491: IF (l_interface.atd_entity_id_txt IS NULL) OR (l_interface.rep_entity_id_txt IS NULL ) THEN
3492: fnd_message.set_name('IGF','IGF_SL_ATD_REP_PELL_NOT_CORR');
3493: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3494: l_valid_for_dml := 'N' ;
3495: l_error_flag := TRUE;
3496:
3497: ELSE

Line 3503: fnd_message.set_name('IGF','IGF_SL_ATD_REP_PELL_NOT_CORR');

3499: OPEN c_atd_rep_comb(l_interface.atd_entity_id_txt, l_interface.rep_entity_id_txt);
3500: FETCH c_atd_rep_comb INTO atd_rep_comb_rec;
3501:
3502: IF c_atd_rep_comb%NOTFOUND THEN
3503: fnd_message.set_name('IGF','IGF_SL_ATD_REP_PELL_NOT_CORR');
3504: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3505: l_valid_for_dml := 'N' ;
3506: l_error_flag := TRUE;
3507: END IF;

Line 3504: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

3500: FETCH c_atd_rep_comb INTO atd_rep_comb_rec;
3501:
3502: IF c_atd_rep_comb%NOTFOUND THEN
3503: fnd_message.set_name('IGF','IGF_SL_ATD_REP_PELL_NOT_CORR');
3504: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3505: l_valid_for_dml := 'N' ;
3506: l_error_flag := TRUE;
3507: END IF;
3508: CLOSE c_atd_rep_comb;

Line 3513: fnd_message.set_name('IGF','IGF_AP_TRANS_NUM_INVLD');

3509: END IF;
3510:
3511: -- Transaction number must have a not null value between 1 and 99
3512: IF (l_interface.transaction_num IS NULL) OR (l_interface.transaction_num < 1 ) OR (l_interface.transaction_num > 99) THEN
3513: fnd_message.set_name('IGF','IGF_AP_TRANS_NUM_INVLD');
3514: fnd_message.set_token('TRNM',l_interface.transaction_num);
3515: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3516: l_valid_for_dml := 'N' ;
3517: l_error_flag := TRUE;

Line 3514: fnd_message.set_token('TRNM',l_interface.transaction_num);

3510:
3511: -- Transaction number must have a not null value between 1 and 99
3512: IF (l_interface.transaction_num IS NULL) OR (l_interface.transaction_num < 1 ) OR (l_interface.transaction_num > 99) THEN
3513: fnd_message.set_name('IGF','IGF_AP_TRANS_NUM_INVLD');
3514: fnd_message.set_token('TRNM',l_interface.transaction_num);
3515: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3516: l_valid_for_dml := 'N' ;
3517: l_error_flag := TRUE;
3518: ELSE

Line 3515: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

3511: -- Transaction number must have a not null value between 1 and 99
3512: IF (l_interface.transaction_num IS NULL) OR (l_interface.transaction_num < 1 ) OR (l_interface.transaction_num > 99) THEN
3513: fnd_message.set_name('IGF','IGF_AP_TRANS_NUM_INVLD');
3514: fnd_message.set_token('TRNM',l_interface.transaction_num);
3515: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3516: l_valid_for_dml := 'N' ;
3517: l_error_flag := TRUE;
3518: ELSE
3519: -- Person should have an ISIR with the said transaction number

Line 3524: fnd_message.set_name('IGF','IGF_AP_ISIR_DTLS_NOT_FOUND');

3520: OPEN c_chk_isir_dtls(lv_base_id, l_interface.transaction_num);
3521: FETCH c_chk_isir_dtls INTO chk_isir_dtls_rec ;
3522:
3523: IF c_chk_isir_dtls%NOTFOUND THEN
3524: fnd_message.set_name('IGF','IGF_AP_ISIR_DTLS_NOT_FOUND');
3525: fnd_message.set_token('STUD',l_interface.person_number);
3526: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3527: l_valid_for_dml := 'N' ;
3528: l_error_flag := TRUE;

Line 3525: fnd_message.set_token('STUD',l_interface.person_number);

3521: FETCH c_chk_isir_dtls INTO chk_isir_dtls_rec ;
3522:
3523: IF c_chk_isir_dtls%NOTFOUND THEN
3524: fnd_message.set_name('IGF','IGF_AP_ISIR_DTLS_NOT_FOUND');
3525: fnd_message.set_token('STUD',l_interface.person_number);
3526: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3527: l_valid_for_dml := 'N' ;
3528: l_error_flag := TRUE;
3529: END IF;

Line 3526: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

3522:
3523: IF c_chk_isir_dtls%NOTFOUND THEN
3524: fnd_message.set_name('IGF','IGF_AP_ISIR_DTLS_NOT_FOUND');
3525: fnd_message.set_token('STUD',l_interface.person_number);
3526: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3527: l_valid_for_dml := 'N' ;
3528: l_error_flag := TRUE;
3529: END IF;
3530:

Line 3543: fnd_message.set_name('IGF','IGF_SL_CL_LI_NO_AW_REF');

3539: OPEN c_award_ref(lv_base_id,l_interface.award_number_txt);
3540: FETCH c_award_ref INTO l_award_ref;
3541: IF (c_award_ref%NOTFOUND) THEN
3542: CLOSE c_award_ref;
3543: fnd_message.set_name('IGF','IGF_SL_CL_LI_NO_AW_REF');
3544: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3545: l_valid_for_dml := 'N' ;
3546: l_error_flag := TRUE;
3547: ELSE

Line 3544: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

3540: FETCH c_award_ref INTO l_award_ref;
3541: IF (c_award_ref%NOTFOUND) THEN
3542: CLOSE c_award_ref;
3543: fnd_message.set_name('IGF','IGF_SL_CL_LI_NO_AW_REF');
3544: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3545: l_valid_for_dml := 'N' ;
3546: l_error_flag := TRUE;
3547: ELSE
3548: CLOSE c_award_ref;

Line 3551: fnd_message.set_name('IGF','IGF_SL_TERMINATED_LOAN');

3547: ELSE
3548: CLOSE c_award_ref;
3549: l_award_id := l_award_ref.award_id;
3550: IF l_award_ref.award_status = 'CANCELLED' THEN
3551: fnd_message.set_name('IGF','IGF_SL_TERMINATED_LOAN');
3552: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3553: l_valid_for_dml := 'N' ;
3554: l_error_flag := TRUE;
3555: l_award_id := l_award_ref.award_id;

Line 3552: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

3548: CLOSE c_award_ref;
3549: l_award_id := l_award_ref.award_id;
3550: IF l_award_ref.award_status = 'CANCELLED' THEN
3551: fnd_message.set_name('IGF','IGF_SL_TERMINATED_LOAN');
3552: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3553: l_valid_for_dml := 'N' ;
3554: l_error_flag := TRUE;
3555: l_award_id := l_award_ref.award_id;
3556: ELSE

Line 3570: fnd_message.set_name('IGF','IGF_AP_PAY_ISIR_EXCEED_ONE');

3566: OPEN c_act_isir(lv_base_id,'Y');
3567: FETCH c_act_isir INTO l_act_isir;
3568: IF (c_act_isir%NOTFOUND) THEN
3569: CLOSE c_act_isir;
3570: fnd_message.set_name('IGF','IGF_AP_PAY_ISIR_EXCEED_ONE');
3571: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3572: l_valid_for_dml := 'N' ;
3573: l_error_flag := TRUE;
3574: ELSE

Line 3571: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

3567: FETCH c_act_isir INTO l_act_isir;
3568: IF (c_act_isir%NOTFOUND) THEN
3569: CLOSE c_act_isir;
3570: fnd_message.set_name('IGF','IGF_AP_PAY_ISIR_EXCEED_ONE');
3571: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3572: l_valid_for_dml := 'N' ;
3573: l_error_flag := TRUE;
3574: ELSE
3575: CLOSE c_act_isir;

Line 3586: fnd_message.set_name('IGF','IGF_SL_CL_INV_FED_FND_CD');

3582: OPEN c_fed_fund_code(l_award_id);
3583: FETCH c_fed_fund_code INTO l_fed_fund_code;
3584: CLOSE c_fed_fund_code;
3585: IF l_fed_fund_code.fed_fund_code IS NULL OR l_fed_fund_code.fed_fund_code NOT IN ('DLP','DLU','DLS') THEN
3586: fnd_message.set_name('IGF','IGF_SL_CL_INV_FED_FND_CD');
3587: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3588: l_valid_for_dml := 'N' ;
3589: l_error_flag := TRUE;
3590: ELSE

Line 3587: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

3583: FETCH c_fed_fund_code INTO l_fed_fund_code;
3584: CLOSE c_fed_fund_code;
3585: IF l_fed_fund_code.fed_fund_code IS NULL OR l_fed_fund_code.fed_fund_code NOT IN ('DLP','DLU','DLS') THEN
3586: fnd_message.set_name('IGF','IGF_SL_CL_INV_FED_FND_CD');
3587: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3588: l_valid_for_dml := 'N' ;
3589: l_error_flag := TRUE;
3590: ELSE
3591: lv_fed_fund_code := l_fed_fund_code.fed_fund_code ;

Line 3599: fnd_message.set_name('IGF','IGF_SL_CL_BOR_NUM_REQD');

3595: -- check if FED_FUND_CODE is 'DLP' AND the BORR_PERSON_NUMBER is NULL then error out
3596:
3597: IF l_fed_fund_code.fed_fund_code = 'DLP' THEN
3598: IF l_interface.borr_person_number IS NULL THEN
3599: fnd_message.set_name('IGF','IGF_SL_CL_BOR_NUM_REQD');
3600: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3601: l_valid_for_dml := 'N' ;
3602: l_error_flag := TRUE;
3603: ELSE

Line 3600: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

3596:
3597: IF l_fed_fund_code.fed_fund_code = 'DLP' THEN
3598: IF l_interface.borr_person_number IS NULL THEN
3599: fnd_message.set_name('IGF','IGF_SL_CL_BOR_NUM_REQD');
3600: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3601: l_valid_for_dml := 'N' ;
3602: l_error_flag := TRUE;
3603: ELSE
3604: OPEN c_relationship(l_interface.person_number,l_interface.borr_person_number);

Line 3608: fnd_message.set_name('IGF','IGF_SL_CL_INV_BOR_REL');

3604: OPEN c_relationship(l_interface.person_number,l_interface.borr_person_number);
3605: FETCH c_relationship INTO l_relationship;
3606:
3607: IF (c_relationship%NOTFOUND) THEN
3608: fnd_message.set_name('IGF','IGF_SL_CL_INV_BOR_REL');
3609: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3610: l_valid_for_dml := 'N' ;
3611: l_error_flag := TRUE;
3612:

Line 3609: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

3605: FETCH c_relationship INTO l_relationship;
3606:
3607: IF (c_relationship%NOTFOUND) THEN
3608: fnd_message.set_name('IGF','IGF_SL_CL_INV_BOR_REL');
3609: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3610: l_valid_for_dml := 'N' ;
3611: l_error_flag := TRUE;
3612:
3613: -- Fetch the Borrow person ID to check if party exists

Line 3618: fnd_message.set_name('IGF','IGF_AP_PE_NOT_EXIST');

3614: OPEN c_person_id(l_interface.borr_person_number,'PERSON');
3615: FETCH c_person_id INTO l_b_person_id;
3616: CLOSE c_person_id;
3617: IF l_b_person_id IS NULL THEN
3618: fnd_message.set_name('IGF','IGF_AP_PE_NOT_EXIST');
3619: fnd_file.put_line(fnd_file.log, RPAD(l_error,12) || g_error_string|| ' ' || 'BORR_PERSON_NUMBER' ||' ' ||fnd_message.get);
3620: END IF;
3621:
3622: CLOSE c_relationship;

Line 3619: fnd_file.put_line(fnd_file.log, RPAD(l_error,12) || g_error_string|| ' ' || 'BORR_PERSON_NUMBER' ||' ' ||fnd_message.get);

3615: FETCH c_person_id INTO l_b_person_id;
3616: CLOSE c_person_id;
3617: IF l_b_person_id IS NULL THEN
3618: fnd_message.set_name('IGF','IGF_AP_PE_NOT_EXIST');
3619: fnd_file.put_line(fnd_file.log, RPAD(l_error,12) || g_error_string|| ' ' || 'BORR_PERSON_NUMBER' ||' ' ||fnd_message.get);
3620: END IF;
3621:
3622: CLOSE c_relationship;
3623: ELSE

Line 3634: fnd_message.set_name('IGF','IGF_SL_CL_BORW_NOT_REQD');

3630: END IF;
3631: END IF;
3632: ELSE
3633: IF l_interface.borr_person_number IS NOT NULL THEN
3634: fnd_message.set_name('IGF','IGF_SL_CL_BORW_NOT_REQD');
3635: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3636: l_valid_for_dml := 'N' ;
3637: l_error_flag := TRUE;
3638: END IF;

Line 3635: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

3631: END IF;
3632: ELSE
3633: IF l_interface.borr_person_number IS NOT NULL THEN
3634: fnd_message.set_name('IGF','IGF_SL_CL_BORW_NOT_REQD');
3635: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3636: l_valid_for_dml := 'N' ;
3637: l_error_flag := TRUE;
3638: END IF;
3639: END IF;

Line 3684: fnd_message.set_name('IGF','IGF_SL_DISB_SEQ_NO_EXIST');

3680: IF (c_disb_det%NOTFOUND) THEN
3681: CLOSE c_disb_det;
3682: l_valid_for_dml := 'N' ;
3683: l_error_flag := TRUE;
3684: fnd_message.set_name('IGF','IGF_SL_DISB_SEQ_NO_EXIST');
3685: fnd_message.set_token('DISB_NUM',l_disb_interface.disbursement_num);
3686: fnd_message.set_token('SEQ_NUM',l_disb_interface.disbursement_seq_num);
3687: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3688: p_d_status := FALSE;

Line 3685: fnd_message.set_token('DISB_NUM',l_disb_interface.disbursement_num);

3681: CLOSE c_disb_det;
3682: l_valid_for_dml := 'N' ;
3683: l_error_flag := TRUE;
3684: fnd_message.set_name('IGF','IGF_SL_DISB_SEQ_NO_EXIST');
3685: fnd_message.set_token('DISB_NUM',l_disb_interface.disbursement_num);
3686: fnd_message.set_token('SEQ_NUM',l_disb_interface.disbursement_seq_num);
3687: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3688: p_d_status := FALSE;
3689: p_d_status2 := FALSE;

Line 3686: fnd_message.set_token('SEQ_NUM',l_disb_interface.disbursement_seq_num);

3682: l_valid_for_dml := 'N' ;
3683: l_error_flag := TRUE;
3684: fnd_message.set_name('IGF','IGF_SL_DISB_SEQ_NO_EXIST');
3685: fnd_message.set_token('DISB_NUM',l_disb_interface.disbursement_num);
3686: fnd_message.set_token('SEQ_NUM',l_disb_interface.disbursement_seq_num);
3687: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3688: p_d_status := FALSE;
3689: p_d_status2 := FALSE;
3690: ELSE

Line 3687: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

3683: l_error_flag := TRUE;
3684: fnd_message.set_name('IGF','IGF_SL_DISB_SEQ_NO_EXIST');
3685: fnd_message.set_token('DISB_NUM',l_disb_interface.disbursement_num);
3686: fnd_message.set_token('SEQ_NUM',l_disb_interface.disbursement_seq_num);
3687: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3688: p_d_status := FALSE;
3689: p_d_status2 := FALSE;
3690: ELSE
3691: -- Validate Disbursement record

Line 3696: fnd_message.set_name('IGF','IGF_SL_VAL_DB_SEQ_NUM');

3692: CLOSE c_disb_det;
3693: l_debug_str := l_debug_str || ' validating disbursement records with Disbursement Number : ' ||
3694: TO_CHAR(l_disb_interface.disbursement_num) || ' And disbursement Sequence Number : ' || TO_CHAR(l_disb_interface.disbursement_seq_num) ;
3695:
3696: fnd_message.set_name('IGF','IGF_SL_VAL_DB_SEQ_NUM');
3697: fnd_message.set_token('DISB_NUM',l_disb_interface.disbursement_num);
3698: fnd_message.set_token('SEQ_NUM',l_disb_interface.disbursement_seq_num);
3699: fnd_file.put_line(fnd_file.log, fnd_message.get);
3700: fnd_file.new_line(fnd_file.log,1);

Line 3697: fnd_message.set_token('DISB_NUM',l_disb_interface.disbursement_num);

3693: l_debug_str := l_debug_str || ' validating disbursement records with Disbursement Number : ' ||
3694: TO_CHAR(l_disb_interface.disbursement_num) || ' And disbursement Sequence Number : ' || TO_CHAR(l_disb_interface.disbursement_seq_num) ;
3695:
3696: fnd_message.set_name('IGF','IGF_SL_VAL_DB_SEQ_NUM');
3697: fnd_message.set_token('DISB_NUM',l_disb_interface.disbursement_num);
3698: fnd_message.set_token('SEQ_NUM',l_disb_interface.disbursement_seq_num);
3699: fnd_file.put_line(fnd_file.log, fnd_message.get);
3700: fnd_file.new_line(fnd_file.log,1);
3701: validate_loan_disb( l_disb_interface,l_award_id, p_d_status,g_igf_sl_message_table);

Line 3698: fnd_message.set_token('SEQ_NUM',l_disb_interface.disbursement_seq_num);

3694: TO_CHAR(l_disb_interface.disbursement_num) || ' And disbursement Sequence Number : ' || TO_CHAR(l_disb_interface.disbursement_seq_num) ;
3695:
3696: fnd_message.set_name('IGF','IGF_SL_VAL_DB_SEQ_NUM');
3697: fnd_message.set_token('DISB_NUM',l_disb_interface.disbursement_num);
3698: fnd_message.set_token('SEQ_NUM',l_disb_interface.disbursement_seq_num);
3699: fnd_file.put_line(fnd_file.log, fnd_message.get);
3700: fnd_file.new_line(fnd_file.log,1);
3701: validate_loan_disb( l_disb_interface,l_award_id, p_d_status,g_igf_sl_message_table);
3702:

Line 3699: fnd_file.put_line(fnd_file.log, fnd_message.get);

3695:
3696: fnd_message.set_name('IGF','IGF_SL_VAL_DB_SEQ_NUM');
3697: fnd_message.set_token('DISB_NUM',l_disb_interface.disbursement_num);
3698: fnd_message.set_token('SEQ_NUM',l_disb_interface.disbursement_seq_num);
3699: fnd_file.put_line(fnd_file.log, fnd_message.get);
3700: fnd_file.new_line(fnd_file.log,1);
3701: validate_loan_disb( l_disb_interface,l_award_id, p_d_status,g_igf_sl_message_table);
3702:
3703: IF p_d_status = FALSE THEN

Line 3731: fnd_message.set_name('IGF','IGF_SL_AC_DISB_SEQ_NO_EXIST');

3727: IF c_int_disb_rec%FOUND THEN
3728: CLOSE c_int_disb_rec;
3729: l_valid_for_dml := 'N' ;
3730: l_error_flag := TRUE;
3731: fnd_message.set_name('IGF','IGF_SL_AC_DISB_SEQ_NO_EXIST');
3732: fnd_message.set_token('DISB_NUM',l_int_disb_rec.disb_num);
3733: fnd_message.set_token('SEQ_NUM',l_int_disb_rec.disb_seq_num);
3734: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3735: ELSE

Line 3732: fnd_message.set_token('DISB_NUM',l_int_disb_rec.disb_num);

3728: CLOSE c_int_disb_rec;
3729: l_valid_for_dml := 'N' ;
3730: l_error_flag := TRUE;
3731: fnd_message.set_name('IGF','IGF_SL_AC_DISB_SEQ_NO_EXIST');
3732: fnd_message.set_token('DISB_NUM',l_int_disb_rec.disb_num);
3733: fnd_message.set_token('SEQ_NUM',l_int_disb_rec.disb_seq_num);
3734: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3735: ELSE
3736: CLOSE c_int_disb_rec;

Line 3733: fnd_message.set_token('SEQ_NUM',l_int_disb_rec.disb_seq_num);

3729: l_valid_for_dml := 'N' ;
3730: l_error_flag := TRUE;
3731: fnd_message.set_name('IGF','IGF_SL_AC_DISB_SEQ_NO_EXIST');
3732: fnd_message.set_token('DISB_NUM',l_int_disb_rec.disb_num);
3733: fnd_message.set_token('SEQ_NUM',l_int_disb_rec.disb_seq_num);
3734: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3735: ELSE
3736: CLOSE c_int_disb_rec;
3737: END IF;

Line 3734: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

3730: l_error_flag := TRUE;
3731: fnd_message.set_name('IGF','IGF_SL_AC_DISB_SEQ_NO_EXIST');
3732: fnd_message.set_token('DISB_NUM',l_int_disb_rec.disb_num);
3733: fnd_message.set_token('SEQ_NUM',l_int_disb_rec.disb_seq_num);
3734: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3735: ELSE
3736: CLOSE c_int_disb_rec;
3737: END IF;
3738: END IF;

Line 3750: fnd_message.set_name('IGF','IGF_SL_DUP_LOAN');

3746: OPEN c_chk_loan(l_interface.loan_number_txt);
3747: FETCH c_chk_loan INTO l_chk_loan;
3748: CLOSE c_chk_loan;
3749: IF l_chk_loan.award_id <> l_award_id THEN
3750: fnd_message.set_name('IGF','IGF_SL_DUP_LOAN');
3751: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3752: l_error_flag := TRUE;
3753: END IF;
3754:

Line 3751: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

3747: FETCH c_chk_loan INTO l_chk_loan;
3748: CLOSE c_chk_loan;
3749: IF l_chk_loan.award_id <> l_award_id THEN
3750: fnd_message.set_name('IGF','IGF_SL_DUP_LOAN');
3751: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3752: l_error_flag := TRUE;
3753: END IF;
3754:
3755: IF NOT l_error_flag THEN

Line 3763: fnd_message.set_name('IGF','IGF_AP_ORIG_REC_NOT_FOUND');

3759: FETCH c_chk_loan_exist INTO l_chk_loan_exist;
3760: -- check loan exists
3761: IF (c_chk_loan_exist%NOTFOUND) THEN
3762: CLOSE c_chk_loan_exist;
3763: fnd_message.set_name('IGF','IGF_AP_ORIG_REC_NOT_FOUND');
3764: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3765: l_error_flag := TRUE;
3766: ELSE
3767: CLOSE c_chk_loan_exist;

Line 3764: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

3760: -- check loan exists
3761: IF (c_chk_loan_exist%NOTFOUND) THEN
3762: CLOSE c_chk_loan_exist;
3763: fnd_message.set_name('IGF','IGF_AP_ORIG_REC_NOT_FOUND');
3764: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3765: l_error_flag := TRUE;
3766: ELSE
3767: CLOSE c_chk_loan_exist;
3768: lv_loan_id := l_chk_loan_exist.loan_id;

Line 3774: fnd_message.set_name('IGF','IGF_SL_CL_UPD_OPEN');

3770: lv_loan_num := l_chk_loan_exist.loan_number;
3771: l_legacy_flag := l_chk_loan_exist.legacy_record_flag;
3772: -- if record exists and legacy flag is not set then error out
3773: IF (lv_flag_lo = TRUE) AND (NVL(l_legacy_flag,'N') = 'N') THEN
3774: fnd_message.set_name('IGF','IGF_SL_CL_UPD_OPEN');
3775: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3776: l_error_flag := TRUE;
3777: ELSE
3778:

Line 3775: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

3771: l_legacy_flag := l_chk_loan_exist.legacy_record_flag;
3772: -- if record exists and legacy flag is not set then error out
3773: IF (lv_flag_lo = TRUE) AND (NVL(l_legacy_flag,'N') = 'N') THEN
3774: fnd_message.set_name('IGF','IGF_SL_CL_UPD_OPEN');
3775: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3776: l_error_flag := TRUE;
3777: ELSE
3778:
3779: delete_context_records(lv_loan_id,lv_loan_num,lv_rowid);

Line 3798: fnd_message.set_name('IGF','IGF_SL_CL_RECORD_EXIST');

3794: OPEN c_chk_loan_exist(l_award_id);
3795: FETCH c_chk_loan_exist INTO l_chk_loan_exist;
3796: IF (c_chk_loan_exist%FOUND) THEN
3797: CLOSE c_chk_loan_exist;
3798: fnd_message.set_name('IGF','IGF_SL_CL_RECORD_EXIST');
3799: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3800: l_error_flag := TRUE;
3801: ELSE
3802: CLOSE c_chk_loan_exist;

Line 3799: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);

3795: FETCH c_chk_loan_exist INTO l_chk_loan_exist;
3796: IF (c_chk_loan_exist%FOUND) THEN
3797: CLOSE c_chk_loan_exist;
3798: fnd_message.set_name('IGF','IGF_SL_CL_RECORD_EXIST');
3799: fnd_file.put_line(fnd_file.log,RPAD(l_error,12) || fnd_message.get);
3800: l_error_flag := TRUE;
3801: ELSE
3802: CLOSE c_chk_loan_exist;
3803: lv_loan_id := l_chk_loan_exist.loan_id;

Line 3822: fnd_message.set_name('IGF','IGF_SL_CL_LI_UPD_FLD');

3818:
3819: EXCEPTION
3820: WHEN IMPORT_ERROR THEN
3821: l_error_flag := TRUE;
3822: fnd_message.set_name('IGF','IGF_SL_CL_LI_UPD_FLD');
3823: fnd_file.put_line(fnd_file.log,RPAD(l_error,11) || fnd_message.get);
3824: fnd_file.new_line(fnd_file.log,1);
3825: ROLLBACK TO sp1;
3826:

Line 3823: fnd_file.put_line(fnd_file.log,RPAD(l_error,11) || fnd_message.get);

3819: EXCEPTION
3820: WHEN IMPORT_ERROR THEN
3821: l_error_flag := TRUE;
3822: fnd_message.set_name('IGF','IGF_SL_CL_LI_UPD_FLD');
3823: fnd_file.put_line(fnd_file.log,RPAD(l_error,11) || fnd_message.get);
3824: fnd_file.new_line(fnd_file.log,1);
3825: ROLLBACK TO sp1;
3826:
3827: WHEN OTHERS THEN

Line 3888: fnd_message.set_name('IGF','IGF_SL_LI_IMP_SUCCES');

3884:
3885: l_debug_str := l_debug_str || ' After update of interface table : status I ';
3886: END IF;
3887: l_success_record_cnt := l_success_record_cnt + 1;
3888: fnd_message.set_name('IGF','IGF_SL_LI_IMP_SUCCES');
3889: fnd_file.put_line(fnd_file.log, fnd_message.get);
3890:
3891: END IF;
3892: fnd_file.new_line(fnd_file.log,1);

Line 3889: fnd_file.put_line(fnd_file.log, fnd_message.get);

3885: l_debug_str := l_debug_str || ' After update of interface table : status I ';
3886: END IF;
3887: l_success_record_cnt := l_success_record_cnt + 1;
3888: fnd_message.set_name('IGF','IGF_SL_LI_IMP_SUCCES');
3889: fnd_file.put_line(fnd_file.log, fnd_message.get);
3890:
3891: END IF;
3892: fnd_file.new_line(fnd_file.log,1);
3893: -- Write debug messages

Line 3905: fnd_message.set_name('IGF','IGF_SL_DL_LI_NO_RECORDS');

3901: END; -- block for updating and deleting interface records
3902: END LOOP;
3903:
3904: IF l_total_record_cnt = 0 THEN
3905: fnd_message.set_name('IGF','IGF_SL_DL_LI_NO_RECORDS');
3906: fnd_message.set_token('AID_YR', l_alternate_code);
3907: fnd_message.set_token('BATCH_ID',p_batch_id);
3908: fnd_file.put_line(fnd_file.log,RPAD(l_error,11) || fnd_message.get);
3909: RETURN;

Line 3906: fnd_message.set_token('AID_YR', l_alternate_code);

3902: END LOOP;
3903:
3904: IF l_total_record_cnt = 0 THEN
3905: fnd_message.set_name('IGF','IGF_SL_DL_LI_NO_RECORDS');
3906: fnd_message.set_token('AID_YR', l_alternate_code);
3907: fnd_message.set_token('BATCH_ID',p_batch_id);
3908: fnd_file.put_line(fnd_file.log,RPAD(l_error,11) || fnd_message.get);
3909: RETURN;
3910: END IF;

Line 3907: fnd_message.set_token('BATCH_ID',p_batch_id);

3903:
3904: IF l_total_record_cnt = 0 THEN
3905: fnd_message.set_name('IGF','IGF_SL_DL_LI_NO_RECORDS');
3906: fnd_message.set_token('AID_YR', l_alternate_code);
3907: fnd_message.set_token('BATCH_ID',p_batch_id);
3908: fnd_file.put_line(fnd_file.log,RPAD(l_error,11) || fnd_message.get);
3909: RETURN;
3910: END IF;
3911: -- Print in the out put file the total number of records successfully imported.

Line 3908: fnd_file.put_line(fnd_file.log,RPAD(l_error,11) || fnd_message.get);

3904: IF l_total_record_cnt = 0 THEN
3905: fnd_message.set_name('IGF','IGF_SL_DL_LI_NO_RECORDS');
3906: fnd_message.set_token('AID_YR', l_alternate_code);
3907: fnd_message.set_token('BATCH_ID',p_batch_id);
3908: fnd_file.put_line(fnd_file.log,RPAD(l_error,11) || fnd_message.get);
3909: RETURN;
3910: END IF;
3911: -- Print in the out put file the total number of records successfully imported.
3912:

Line 3923: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');

3919:
3920: WHEN others THEN
3921: ROLLBACK;
3922: fnd_log.string_with_context(FND_LOG.LEVEL_STATEMENT,'IGF_SL_DL_LI_IMP_PKG', l_debug_str || SQLERRM,NULL,NULL,NULL,NULL,NULL,TO_CHAR(g_request_id));
3923: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3924: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.RUN');
3925: fnd_file.put_line(fnd_file.log,fnd_message.get || sqlerrm);
3926: retcode := 2;
3927: errbuf := fnd_message.get;

Line 3924: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.RUN');

3920: WHEN others THEN
3921: ROLLBACK;
3922: fnd_log.string_with_context(FND_LOG.LEVEL_STATEMENT,'IGF_SL_DL_LI_IMP_PKG', l_debug_str || SQLERRM,NULL,NULL,NULL,NULL,NULL,TO_CHAR(g_request_id));
3923: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3924: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.RUN');
3925: fnd_file.put_line(fnd_file.log,fnd_message.get || sqlerrm);
3926: retcode := 2;
3927: errbuf := fnd_message.get;
3928: igs_ge_msg_stack.conc_exception_hndl;

Line 3925: fnd_file.put_line(fnd_file.log,fnd_message.get || sqlerrm);

3921: ROLLBACK;
3922: fnd_log.string_with_context(FND_LOG.LEVEL_STATEMENT,'IGF_SL_DL_LI_IMP_PKG', l_debug_str || SQLERRM,NULL,NULL,NULL,NULL,NULL,TO_CHAR(g_request_id));
3923: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3924: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.RUN');
3925: fnd_file.put_line(fnd_file.log,fnd_message.get || sqlerrm);
3926: retcode := 2;
3927: errbuf := fnd_message.get;
3928: igs_ge_msg_stack.conc_exception_hndl;
3929: END run;

Line 3927: errbuf := fnd_message.get;

3923: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3924: fnd_message.set_token('NAME','IGF_SL_DL_LI_IMP_PKG.RUN');
3925: fnd_file.put_line(fnd_file.log,fnd_message.get || sqlerrm);
3926: retcode := 2;
3927: errbuf := fnd_message.get;
3928: igs_ge_msg_stack.conc_exception_hndl;
3929: END run;
3930:
3931: END IGF_SL_DL_LI_IMP_PKG;