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_CL_LI_IMP_PKG dependencies on FND_FILE

Line 485: fnd_file.new_line(fnd_file.log,1);

481:
482: END LOOP;
483: CLOSE c_get_parameters;
484:
485: fnd_file.new_line(fnd_file.log,1);
486: fnd_file.put_line(fnd_file.log, g_para_pass); --------------Parameters Passed--------------
487: fnd_file.new_line(fnd_file.log,1);
488:
489: fnd_file.put_line(fnd_file.log, RPAD(g_award_year,40) || ' : '|| p_alternate_code);

Line 486: fnd_file.put_line(fnd_file.log, g_para_pass); --------------Parameters Passed--------------

482: END LOOP;
483: CLOSE c_get_parameters;
484:
485: fnd_file.new_line(fnd_file.log,1);
486: fnd_file.put_line(fnd_file.log, g_para_pass); --------------Parameters Passed--------------
487: fnd_file.new_line(fnd_file.log,1);
488:
489: fnd_file.put_line(fnd_file.log, RPAD(g_award_year,40) || ' : '|| p_alternate_code);
490: fnd_file.put_line(fnd_file.log, RPAD(g_batch_num,40) || ' : '|| p_batch_number);

Line 487: fnd_file.new_line(fnd_file.log,1);

483: CLOSE c_get_parameters;
484:
485: fnd_file.new_line(fnd_file.log,1);
486: fnd_file.put_line(fnd_file.log, g_para_pass); --------------Parameters Passed--------------
487: fnd_file.new_line(fnd_file.log,1);
488:
489: fnd_file.put_line(fnd_file.log, RPAD(g_award_year,40) || ' : '|| p_alternate_code);
490: fnd_file.put_line(fnd_file.log, RPAD(g_batch_num,40) || ' : '|| p_batch_number);
491: fnd_file.put_line(fnd_file.log, RPAD(g_del_flag,40) || ' : '|| p_del_ind);

Line 489: fnd_file.put_line(fnd_file.log, RPAD(g_award_year,40) || ' : '|| p_alternate_code);

485: fnd_file.new_line(fnd_file.log,1);
486: fnd_file.put_line(fnd_file.log, g_para_pass); --------------Parameters Passed--------------
487: fnd_file.new_line(fnd_file.log,1);
488:
489: fnd_file.put_line(fnd_file.log, RPAD(g_award_year,40) || ' : '|| p_alternate_code);
490: fnd_file.put_line(fnd_file.log, RPAD(g_batch_num,40) || ' : '|| p_batch_number);
491: fnd_file.put_line(fnd_file.log, RPAD(g_del_flag,40) || ' : '|| p_del_ind);
492:
493: fnd_file.new_line(fnd_file.log,1);

Line 490: fnd_file.put_line(fnd_file.log, RPAD(g_batch_num,40) || ' : '|| p_batch_number);

486: fnd_file.put_line(fnd_file.log, g_para_pass); --------------Parameters Passed--------------
487: fnd_file.new_line(fnd_file.log,1);
488:
489: fnd_file.put_line(fnd_file.log, RPAD(g_award_year,40) || ' : '|| p_alternate_code);
490: fnd_file.put_line(fnd_file.log, RPAD(g_batch_num,40) || ' : '|| p_batch_number);
491: fnd_file.put_line(fnd_file.log, RPAD(g_del_flag,40) || ' : '|| p_del_ind);
492:
493: fnd_file.new_line(fnd_file.log,1);
494: fnd_file.put_line(fnd_file.log, '--------------------------------------------------------');

Line 491: fnd_file.put_line(fnd_file.log, RPAD(g_del_flag,40) || ' : '|| p_del_ind);

487: fnd_file.new_line(fnd_file.log,1);
488:
489: fnd_file.put_line(fnd_file.log, RPAD(g_award_year,40) || ' : '|| p_alternate_code);
490: fnd_file.put_line(fnd_file.log, RPAD(g_batch_num,40) || ' : '|| p_batch_number);
491: fnd_file.put_line(fnd_file.log, RPAD(g_del_flag,40) || ' : '|| p_del_ind);
492:
493: fnd_file.new_line(fnd_file.log,1);
494: fnd_file.put_line(fnd_file.log, '--------------------------------------------------------');
495: fnd_file.new_line(fnd_file.log,1);

Line 493: fnd_file.new_line(fnd_file.log,1);

489: fnd_file.put_line(fnd_file.log, RPAD(g_award_year,40) || ' : '|| p_alternate_code);
490: fnd_file.put_line(fnd_file.log, RPAD(g_batch_num,40) || ' : '|| p_batch_number);
491: fnd_file.put_line(fnd_file.log, RPAD(g_del_flag,40) || ' : '|| p_del_ind);
492:
493: fnd_file.new_line(fnd_file.log,1);
494: fnd_file.put_line(fnd_file.log, '--------------------------------------------------------');
495: fnd_file.new_line(fnd_file.log,1);
496:
497:

Line 494: fnd_file.put_line(fnd_file.log, '--------------------------------------------------------');

490: fnd_file.put_line(fnd_file.log, RPAD(g_batch_num,40) || ' : '|| p_batch_number);
491: fnd_file.put_line(fnd_file.log, RPAD(g_del_flag,40) || ' : '|| p_del_ind);
492:
493: fnd_file.new_line(fnd_file.log,1);
494: fnd_file.put_line(fnd_file.log, '--------------------------------------------------------');
495: fnd_file.new_line(fnd_file.log,1);
496:
497:
498: EXCEPTION

Line 495: fnd_file.new_line(fnd_file.log,1);

491: fnd_file.put_line(fnd_file.log, RPAD(g_del_flag,40) || ' : '|| p_del_ind);
492:
493: fnd_file.new_line(fnd_file.log,1);
494: fnd_file.put_line(fnd_file.log, '--------------------------------------------------------');
495: fnd_file.new_line(fnd_file.log,1);
496:
497:
498: EXCEPTION
499: WHEN OTHERS THEN

Line 1611: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);

1607: OR (p_interface.credit_status_code NOT IN ('01','05','10','15','20','25','30','35') ) )
1608: THEN
1609:
1610: fnd_message.set_name('IGF','IGF_SL_CL_LOAN_STATUS_ERR');
1611: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);
1612: p_status := FALSE;
1613:
1614: END IF;
1615: END IF;

Line 1622: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);

1618: IF ( p_fed_fund_cd NOT IN('ALT','FLP','GPLUSFL') ) AND (p_interface.borr_person_number IS NOT NULL)
1619: THEN
1620:
1621: fnd_message.set_name('IGF','IGF_SL_CL_BORW_NOT_REQD');
1622: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);
1623: p_status := FALSE;
1624:
1625: END IF;
1626:

Line 1631: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);

1627: IF (p_fed_fund_cd IN ('ALT','FLP','GPLUSFL')) AND (p_interface.borr_person_number IS NULL )
1628: THEN
1629:
1630: fnd_message.set_name('IGF','IGF_SL_CL_BOR_NUM_REQD');
1631: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);
1632: p_status := FALSE;
1633:
1634: END IF;
1635:

Line 1666: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);

1662: AND p_interface.borr_person_number <> p_interface.person_number
1663: THEN
1664:
1665: fnd_message.set_name('IGF','IGF_SL_CL_S_BOR_NOT_SAME');
1666: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);
1667: p_status := FALSE;
1668:
1669: END IF;
1670:

Line 1675: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);

1671: --FA 163 : For Federal Graduate plus loans, borrower and student should be same
1672: IF p_fed_fund_cd IN ('GPLUSFL') THEN
1673: IF p_interface.borr_person_number <> p_interface.person_number THEN
1674: fnd_message.set_name('IGF','IGF_SL_CL_STU_BOR_DIFFER');
1675: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);
1676: p_status := FALSE;
1677: ELSE
1678: igf_ap_gen.check_person(p_interface.borr_person_number,NULL,NULL,lv_person_id,lv_base_id);
1679: IF lv_person_id IS NULL THEN

Line 1682: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);

1678: igf_ap_gen.check_person(p_interface.borr_person_number,NULL,NULL,lv_person_id,lv_base_id);
1679: IF lv_person_id IS NULL THEN
1680: fnd_message.set_name('IGF','IGF_SL_LI_INVALID_BORR');
1681: fnd_message.set_token('PERS_NUM', p_interface.borr_person_number);
1682: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);
1683: p_status := FALSE;
1684: ELSE
1685: g_p_person_id := lv_person_id;
1686: END IF;

Line 1701: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);

1697:
1698: IF lv_person_id IS NULL THEN
1699: fnd_message.set_name('IGF','IGF_SL_LI_INVALID_BORR');
1700: fnd_message.set_token('PERS_NUM', p_interface.borr_person_number);
1701: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);
1702: p_status := FALSE;
1703: ELSE
1704:
1705: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 1715: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);

1711: FETCH c_relationship INTO l_relationship;
1712: IF (c_relationship%NOTFOUND) THEN
1713: CLOSE c_relationship;
1714: fnd_message.set_name('IGF','IGF_SL_CL_INV_BOR_REL');
1715: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);
1716: p_status := FALSE;
1717: ELSE
1718: CLOSE c_relationship;
1719: END IF;

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

2916: WHEN OTHERS THEN
2917:
2918: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
2919: fnd_message.set_token('NAME','IGF_SL_CL_LI_IMP_PKG.VALIDATE_LOAN_ORIG_INT');
2920: fnd_file.put_line(fnd_file.log,fnd_message.get);
2921:
2922: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
2923: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_imp_pkg.validate_loan_orig_int.exception','VALIDATE_LOAN_ORIG_INT ' || SQLERRM);
2924: END IF;

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

3248: WHEN OTHERS THEN
3249:
3250: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3251: fnd_message.set_token('NAME','IGF_SL_CL_LI_IMP_PKG.VALIDATE_LOAN_DISB');
3252: fnd_file.put_line(fnd_file.log,fnd_message.get);
3253:
3254: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3255: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_imp_pkg.validate_loan_disb.exception','Unhandled exception : '||SQLERRM);
3256: END IF;

Line 3281: fnd_file.put_line(fnd_file.log,LPAD(' ',11) || g_igf_sl_msg_table(indx).msg_text);

3277: IF g_igf_sl_msg_table.COUNT <> 0 THEN
3278: FOR indx IN g_igf_sl_msg_table.FIRST..g_igf_sl_msg_table.LAST
3279: LOOP
3280: IF p_log = 'D' THEN
3281: fnd_file.put_line(fnd_file.log,LPAD(' ',11) || g_igf_sl_msg_table(indx).msg_text);
3282: ELSE
3283: fnd_file.put_line(fnd_file.log,g_igf_sl_msg_table(indx).msg_text);
3284: END IF;
3285: END LOOP;

Line 3283: fnd_file.put_line(fnd_file.log,g_igf_sl_msg_table(indx).msg_text);

3279: LOOP
3280: IF p_log = 'D' THEN
3281: fnd_file.put_line(fnd_file.log,LPAD(' ',11) || g_igf_sl_msg_table(indx).msg_text);
3282: ELSE
3283: fnd_file.put_line(fnd_file.log,g_igf_sl_msg_table(indx).msg_text);
3284: END IF;
3285: END LOOP;
3286: END IF;
3287:

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

3291: WHEN OTHERS THEN
3292:
3293: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3294: fnd_message.set_token('NAME','IGF_SL_CL_LI_IMP_PKG.WRITE_LOGFILE');
3295: fnd_file.put_line(fnd_file.log,fnd_message.get);
3296:
3297: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3298: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_imp_pkg.write_logfile.exception','unhandled exception : '||SQLERRM);
3299: END IF;

Line 5219: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);

5215:
5216:
5217: IF l_chk_profile = 'N' THEN
5218: fnd_message.set_name('IGF','IGF_AP_LGCY_PROC_NOT_RUN');
5219: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);
5220: RETURN;
5221: END IF;
5222:
5223: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 5229: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);

5225: END IF;
5226:
5227: IF (l_get_alternate_code.alternate_code IS NULL) THEN
5228: fnd_message.set_name('IGF','IGF_SL_NO_CALENDAR');
5229: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);
5230: RETURN;
5231: END IF;
5232:
5233: l_chk_batch := igf_ap_gen.check_batch(p_batch_id,'LOANS');

Line 5242: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);

5238: IF l_chk_batch = 'N' THEN
5239: -- Bug # 4008991
5240: fnd_message.set_name('IGF','IGF_SL_GR_BATCH_DOES_NO_EXIST');
5241: fnd_message.set_token('BATCH_ID',p_batch_id);
5242: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);
5243: RETURN;
5244: END IF;
5245:
5246:

Line 5251: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);

5247: OPEN c_award_det(l_cal_type,l_seq_number);
5248: FETCH c_award_det INTO l_award_det;
5249: IF c_award_det%NOTFOUND THEN
5250: fnd_message.set_name('IGF','IGF_AP_AWD_YR_NOT_FOUND');
5251: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);
5252: fnd_file.new_line(fnd_file.log,1);
5253: CLOSE c_award_det;
5254: RETURN;
5255: ELSE

Line 5252: fnd_file.new_line(fnd_file.log,1);

5248: FETCH c_award_det INTO l_award_det;
5249: IF c_award_det%NOTFOUND THEN
5250: fnd_message.set_name('IGF','IGF_AP_AWD_YR_NOT_FOUND');
5251: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);
5252: fnd_file.new_line(fnd_file.log,1);
5253: CLOSE c_award_det;
5254: RETURN;
5255: ELSE
5256: CLOSE c_award_det;

Line 5262: fnd_file.put_line(fnd_file.log,RPAD(g_award_year_status_desc,40)|| ' : '

5258:
5259: l_award_year_status := l_award_det.award_year_status_code;
5260: g_sys_award_year := l_award_det.sys_award_year;
5261:
5262: fnd_file.put_line(fnd_file.log,RPAD(g_award_year_status_desc,40)|| ' : '
5263: || igf_aw_gen.lookup_desc('IGF_AWARD_YEAR_STATUS',l_award_year_status));
5264: fnd_file.new_line(fnd_file.log,1);
5265: fnd_file.put_line(fnd_file.log, '--------------------------------------------------------');
5266:

Line 5264: fnd_file.new_line(fnd_file.log,1);

5260: g_sys_award_year := l_award_det.sys_award_year;
5261:
5262: fnd_file.put_line(fnd_file.log,RPAD(g_award_year_status_desc,40)|| ' : '
5263: || igf_aw_gen.lookup_desc('IGF_AWARD_YEAR_STATUS',l_award_year_status));
5264: fnd_file.new_line(fnd_file.log,1);
5265: fnd_file.put_line(fnd_file.log, '--------------------------------------------------------');
5266:
5267: IF l_award_det.award_year_status_code NOT IN ('LD','O') THEN
5268: fnd_message.set_name('IGF','IGF_AP_LG_INVALID_STAT');

Line 5265: fnd_file.put_line(fnd_file.log, '--------------------------------------------------------');

5261:
5262: fnd_file.put_line(fnd_file.log,RPAD(g_award_year_status_desc,40)|| ' : '
5263: || igf_aw_gen.lookup_desc('IGF_AWARD_YEAR_STATUS',l_award_year_status));
5264: fnd_file.new_line(fnd_file.log,1);
5265: fnd_file.put_line(fnd_file.log, '--------------------------------------------------------');
5266:
5267: IF l_award_det.award_year_status_code NOT IN ('LD','O') THEN
5268: fnd_message.set_name('IGF','IGF_AP_LG_INVALID_STAT');
5269: fnd_message.set_token('AWARD_STATUS',igf_aw_gen.lookup_desc('IGF_AWARD_YEAR_STATUS',l_award_year_status));

Line 5270: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);

5266:
5267: IF l_award_det.award_year_status_code NOT IN ('LD','O') THEN
5268: fnd_message.set_name('IGF','IGF_AP_LG_INVALID_STAT');
5269: fnd_message.set_token('AWARD_STATUS',igf_aw_gen.lookup_desc('IGF_AWARD_YEAR_STATUS',l_award_year_status));
5270: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);
5271: fnd_file.new_line(fnd_file.log,1);
5272: RETURN;
5273: END IF;
5274:

Line 5271: fnd_file.new_line(fnd_file.log,1);

5267: IF l_award_det.award_year_status_code NOT IN ('LD','O') THEN
5268: fnd_message.set_name('IGF','IGF_AP_LG_INVALID_STAT');
5269: fnd_message.set_token('AWARD_STATUS',igf_aw_gen.lookup_desc('IGF_AWARD_YEAR_STATUS',l_award_year_status));
5270: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);
5271: fnd_file.new_line(fnd_file.log,1);
5272: RETURN;
5273: END IF;
5274:
5275: IF (l_award_year_status = 'O') THEN

Line 5293: fnd_file.new_line(fnd_file.log,1);

5289: BEGIN
5290:
5291: SAVEPOINT sp1;
5292:
5293: fnd_file.new_line(fnd_file.log,1);
5294: fnd_file.put_line(fnd_file.log,g_processing ||
5295: ' ' ||
5296: g_person_number ||
5297: ' ' ||

Line 5294: fnd_file.put_line(fnd_file.log,g_processing ||

5290:
5291: SAVEPOINT sp1;
5292:
5293: fnd_file.new_line(fnd_file.log,1);
5294: fnd_file.put_line(fnd_file.log,g_processing ||
5295: ' ' ||
5296: g_person_number ||
5297: ' ' ||
5298: l_interface.person_number);

Line 5310: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);

5306: END IF;
5307:
5308: IF lv_person_id IS NULL THEN
5309: fnd_message.set_name('IGF','IGF_SL_LI_PERSON_NOT_FND');
5310: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);
5311: fnd_file.new_line(fnd_file.log,1);
5312: g_error_flag := TRUE;
5313: ELSE
5314: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 5311: fnd_file.new_line(fnd_file.log,1);

5307:
5308: IF lv_person_id IS NULL THEN
5309: fnd_message.set_name('IGF','IGF_SL_LI_PERSON_NOT_FND');
5310: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);
5311: fnd_file.new_line(fnd_file.log,1);
5312: g_error_flag := TRUE;
5313: ELSE
5314: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5315: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Pesron Number check passed');

Line 5322: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);

5318: -- Check if base record present
5319: --
5320: IF lv_base_id IS NULL THEN
5321: fnd_message.set_name('IGF','IGF_AP_FABASE_NOT_FOUND');
5322: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);
5323: fnd_file.new_line(fnd_file.log,1);
5324: g_error_flag := TRUE;
5325:
5326: ELSE

Line 5323: fnd_file.new_line(fnd_file.log,1);

5319: --
5320: IF lv_base_id IS NULL THEN
5321: fnd_message.set_name('IGF','IGF_AP_FABASE_NOT_FOUND');
5322: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);
5323: fnd_file.new_line(fnd_file.log,1);
5324: g_error_flag := TRUE;
5325:
5326: ELSE
5327: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 5333: fnd_file.put_line(fnd_file.log, g_processing ||

5329: END IF;
5330: --
5331: -- Check if corresponding award is present in the awards table
5332: --
5333: fnd_file.put_line(fnd_file.log, g_processing ||
5334: ' ' ||
5335: g_loan_record||
5336: ' ' ||
5337: l_interface.loan_number_txt);

Line 5344: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);

5340: FETCH c_get_award INTO l_get_award;
5341: IF (c_get_award%NOTFOUND) THEN
5342: CLOSE c_get_award;
5343: fnd_message.set_name('IGF','IGF_SL_CL_LI_NO_AW_REF');
5344: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);
5345: g_error_flag := TRUE;
5346: ELSE
5347: CLOSE c_get_award;
5348:

Line 5368: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);

5364:
5365: IF (c_act_isir%NOTFOUND) THEN
5366: CLOSE c_act_isir;
5367: fnd_message.set_name('IGF','IGF_AP_NO_ACTIVE_ISIR');
5368: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);
5369: lb_isir_flag := FALSE;
5370: g_error_flag := TRUE;
5371: ELSE
5372: CLOSE c_act_isir;

Line 5395: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);

5391:
5392: IF (l_fed_fund_cd IS NULL) OR (l_fed_fund_cd NOT IN ('FLP','FLS','FLU','ALT','GPLUSFL'))
5393: THEN
5394: fnd_message.set_name('IGF','IGF_SL_CL_INV_FED_FND_CD');
5395: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);
5396: g_error_flag := TRUE;
5397: ELSE
5398: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5399: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Person Borrower relationship check passed');

Line 5432: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);

5428: CLOSE c_disb_interface;
5429: p_d_status := FALSE;
5430: g_error_flag := TRUE;
5431: fnd_message.set_name('IGF','IGF_SL_CL_NO_DIS_REC');
5432: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);
5433: ELSE
5434: CLOSE c_disb_interface;
5435: l_disb_interface := NULL;
5436: p_d_status := TRUE;

Line 5446: fnd_file.put_line(fnd_file.log,LPAD(' ',11)

5442: l_interface.award_number_txt,
5443: l_interface.loan_number_txt)
5444: LOOP
5445:
5446: fnd_file.put_line(fnd_file.log,LPAD(' ',11)
5447: ||g_processing
5448: ||' '
5449: ||g_loan_disb
5450: ||' '

Line 5461: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);

5457: CLOSE c_disb_det;
5458: g_error_flag := TRUE;
5459: fnd_message.set_name('IGF','IGF_SL_CL_DISB_REC_NO_EXIST');
5460: fnd_message.set_token('DISB_NUM',l_disb_interface.disbursement_num);
5461: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);
5462: p_d_status := FALSE;
5463: ELSE
5464: CLOSE c_disb_det;
5465: --

Line 5508: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);

5504: CLOSE c_chk_loan_exist;
5505:
5506: IF (NVL(l_interface.import_record_type,'X') = 'U' ) THEN
5507: fnd_message.set_name('IGF','IGF_AP_ORIG_REC_NOT_FOUND');
5508: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);
5509: g_error_flag := TRUE;
5510: END IF;
5511:
5512: ELSIF (c_chk_loan_exist%FOUND) THEN

Line 5518: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);

5514: CLOSE c_chk_loan_exist;
5515:
5516: IF (NVL(l_interface.import_record_type,'X') <> 'U' ) THEN
5517: fnd_message.set_name('IGF','IGF_SL_CL_RECORD_EXIST');
5518: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);
5519: g_error_flag := TRUE;
5520: END IF;
5521:
5522: IF (NVL(l_chk_loan_exist.legacy_record_flag,'N') = 'N') THEN

Line 5524: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);

5520: END IF;
5521:
5522: IF (NVL(l_chk_loan_exist.legacy_record_flag,'N') = 'N') THEN
5523: fnd_message.set_name('IGF','IGF_SL_CL_UPD_OPEN');
5524: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);
5525: g_error_flag := TRUE;
5526: END IF;
5527:
5528: IF (NVL(l_interface.import_record_type,'X') = 'U' ) THEN

Line 5534: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);

5530: fnd_message.set_name('IGF','IGF_SL_LI_LOAN_NUM_MISMTCH');
5531: fnd_message.set_token('SYS_LOAN_NUM',l_chk_loan_exist.loan_number);
5532: fnd_message.set_token('INT_LOAN_NUM',l_interface.loan_number_txt);
5533: fnd_message.set_token('AWARD_ID',l_award_id);
5534: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);
5535: g_error_flag := TRUE;
5536: END IF;
5537: END IF;
5538:

Line 5547: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);

5543: CLOSE c_chk_loan_number;
5544:
5545: IF NVL(l_chk_loan_number.award_id,l_award_id) <> l_award_id THEN
5546: fnd_message.set_name('IGF','IGF_SL_DUP_LOAN');
5547: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);
5548: g_error_flag := TRUE;
5549: END IF;
5550:
5551: IF NOT g_error_flag AND l_chk_loan_exist.loan_id IS NOT NULL THEN

Line 5584: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);

5580:
5581: WHEN IMPORT_ERROR THEN
5582: g_error_flag := TRUE;
5583: fnd_message.set_name('IGF','IGF_SL_CL_LI_UPD_FLD');
5584: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);
5585: fnd_file.new_line(fnd_file.log,1);
5586: ROLLBACK TO sp1;
5587:
5588: WHEN OTHERS THEN

Line 5585: fnd_file.new_line(fnd_file.log,1);

5581: WHEN IMPORT_ERROR THEN
5582: g_error_flag := TRUE;
5583: fnd_message.set_name('IGF','IGF_SL_CL_LI_UPD_FLD');
5584: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);
5585: fnd_file.new_line(fnd_file.log,1);
5586: ROLLBACK TO sp1;
5587:
5588: WHEN OTHERS THEN
5589: RAISE;

Line 5623: fnd_file.new_line(fnd_file.log,1);

5619: g_error_record_cnt := g_error_record_cnt + 1;
5620: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5621: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','After update of interface table : status E');
5622: END IF;
5623: fnd_file.new_line(fnd_file.log,1);
5624: fnd_message.set_name('IGF','IGF_SL_LI_SKIPPING_AWD');
5625: fnd_file.put_line(fnd_file.log,fnd_message.get);
5626: fnd_file.new_line(fnd_file.log,1);
5627: ELSE

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

5621: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','After update of interface table : status E');
5622: END IF;
5623: fnd_file.new_line(fnd_file.log,1);
5624: fnd_message.set_name('IGF','IGF_SL_LI_SKIPPING_AWD');
5625: fnd_file.put_line(fnd_file.log,fnd_message.get);
5626: fnd_file.new_line(fnd_file.log,1);
5627: ELSE
5628:
5629: IF p_delete_flag = 'Y' THEN

Line 5626: fnd_file.new_line(fnd_file.log,1);

5622: END IF;
5623: fnd_file.new_line(fnd_file.log,1);
5624: fnd_message.set_name('IGF','IGF_SL_LI_SKIPPING_AWD');
5625: fnd_file.put_line(fnd_file.log,fnd_message.get);
5626: fnd_file.new_line(fnd_file.log,1);
5627: ELSE
5628:
5629: IF p_delete_flag = 'Y' THEN
5630:

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

5683: END IF;
5684:
5685: l_success_record_cnt := l_success_record_cnt + 1;
5686: fnd_message.set_name('IGF','IGF_SL_LI_IMP_SUCCES');
5687: fnd_file.put_line(fnd_file.log, fnd_message.get);
5688: fnd_file.new_line(fnd_file.log,1);
5689:
5690: END IF;
5691:

Line 5688: fnd_file.new_line(fnd_file.log,1);

5684:
5685: l_success_record_cnt := l_success_record_cnt + 1;
5686: fnd_message.set_name('IGF','IGF_SL_LI_IMP_SUCCES');
5687: fnd_file.put_line(fnd_file.log, fnd_message.get);
5688: fnd_file.new_line(fnd_file.log,1);
5689:
5690: END IF;
5691:
5692: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 5697: fnd_file.new_line(fnd_file.log,1);

5693: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','Before COMMIT');
5694: END IF;
5695:
5696: COMMIT;
5697: fnd_file.new_line(fnd_file.log,1);
5698: END;
5699:
5700:
5701: END LOOP;

Line 5707: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);

5703: IF l_success_record_cnt = 0 AND g_error_record_cnt = 0 THEN
5704: fnd_message.set_name('IGF','IGF_SL_CL_LI_NO_RECORDS');
5705: fnd_message.set_token('AID_YR', l_get_alternate_code.alternate_code);
5706: fnd_message.set_token('BATCH_ID',p_batch_id);
5707: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);
5708: RETURN;
5709: END IF;
5710:
5711: l_total_record_cnt := l_success_record_cnt + g_error_record_cnt;

Line 5712: fnd_file.put_line(fnd_file.output,' ' );

5708: RETURN;
5709: END IF;
5710:
5711: l_total_record_cnt := l_success_record_cnt + g_error_record_cnt;
5712: fnd_file.put_line(fnd_file.output,' ' );
5713: fnd_file.put_line(fnd_file.output, RPAD('-',50,'-'));
5714: fnd_file.put_line(fnd_file.output,' ' );
5715: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_PROCESSED'), 40) || ' : ' || l_total_record_cnt);
5716: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_SUCCESSFUL'), 40) || ' : ' || l_success_record_cnt);

Line 5713: fnd_file.put_line(fnd_file.output, RPAD('-',50,'-'));

5709: END IF;
5710:
5711: l_total_record_cnt := l_success_record_cnt + g_error_record_cnt;
5712: fnd_file.put_line(fnd_file.output,' ' );
5713: fnd_file.put_line(fnd_file.output, RPAD('-',50,'-'));
5714: fnd_file.put_line(fnd_file.output,' ' );
5715: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_PROCESSED'), 40) || ' : ' || l_total_record_cnt);
5716: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_SUCCESSFUL'), 40) || ' : ' || l_success_record_cnt);
5717: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_REJECTED'), 40) || ' : ' || g_error_record_cnt);

Line 5714: fnd_file.put_line(fnd_file.output,' ' );

5710:
5711: l_total_record_cnt := l_success_record_cnt + g_error_record_cnt;
5712: fnd_file.put_line(fnd_file.output,' ' );
5713: fnd_file.put_line(fnd_file.output, RPAD('-',50,'-'));
5714: fnd_file.put_line(fnd_file.output,' ' );
5715: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_PROCESSED'), 40) || ' : ' || l_total_record_cnt);
5716: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_SUCCESSFUL'), 40) || ' : ' || l_success_record_cnt);
5717: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_REJECTED'), 40) || ' : ' || g_error_record_cnt);
5718: fnd_file.put_line(fnd_file.output,' ' );

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

5711: l_total_record_cnt := l_success_record_cnt + g_error_record_cnt;
5712: fnd_file.put_line(fnd_file.output,' ' );
5713: fnd_file.put_line(fnd_file.output, RPAD('-',50,'-'));
5714: fnd_file.put_line(fnd_file.output,' ' );
5715: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_PROCESSED'), 40) || ' : ' || l_total_record_cnt);
5716: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_SUCCESSFUL'), 40) || ' : ' || l_success_record_cnt);
5717: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_REJECTED'), 40) || ' : ' || g_error_record_cnt);
5718: fnd_file.put_line(fnd_file.output,' ' );
5719: fnd_file.put_line(fnd_file.output, RPAD('-',50,'-'));

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

5712: fnd_file.put_line(fnd_file.output,' ' );
5713: fnd_file.put_line(fnd_file.output, RPAD('-',50,'-'));
5714: fnd_file.put_line(fnd_file.output,' ' );
5715: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_PROCESSED'), 40) || ' : ' || l_total_record_cnt);
5716: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_SUCCESSFUL'), 40) || ' : ' || l_success_record_cnt);
5717: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_REJECTED'), 40) || ' : ' || g_error_record_cnt);
5718: fnd_file.put_line(fnd_file.output,' ' );
5719: fnd_file.put_line(fnd_file.output, RPAD('-',50,'-'));
5720: fnd_file.put_line(fnd_file.output,' ' );

Line 5717: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_REJECTED'), 40) || ' : ' || g_error_record_cnt);

5713: fnd_file.put_line(fnd_file.output, RPAD('-',50,'-'));
5714: fnd_file.put_line(fnd_file.output,' ' );
5715: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_PROCESSED'), 40) || ' : ' || l_total_record_cnt);
5716: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_SUCCESSFUL'), 40) || ' : ' || l_success_record_cnt);
5717: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_REJECTED'), 40) || ' : ' || g_error_record_cnt);
5718: fnd_file.put_line(fnd_file.output,' ' );
5719: fnd_file.put_line(fnd_file.output, RPAD('-',50,'-'));
5720: fnd_file.put_line(fnd_file.output,' ' );
5721:

Line 5718: fnd_file.put_line(fnd_file.output,' ' );

5714: fnd_file.put_line(fnd_file.output,' ' );
5715: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_PROCESSED'), 40) || ' : ' || l_total_record_cnt);
5716: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_SUCCESSFUL'), 40) || ' : ' || l_success_record_cnt);
5717: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_REJECTED'), 40) || ' : ' || g_error_record_cnt);
5718: fnd_file.put_line(fnd_file.output,' ' );
5719: fnd_file.put_line(fnd_file.output, RPAD('-',50,'-'));
5720: fnd_file.put_line(fnd_file.output,' ' );
5721:
5722:

Line 5719: fnd_file.put_line(fnd_file.output, RPAD('-',50,'-'));

5715: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_PROCESSED'), 40) || ' : ' || l_total_record_cnt);
5716: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_SUCCESSFUL'), 40) || ' : ' || l_success_record_cnt);
5717: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_REJECTED'), 40) || ' : ' || g_error_record_cnt);
5718: fnd_file.put_line(fnd_file.output,' ' );
5719: fnd_file.put_line(fnd_file.output, RPAD('-',50,'-'));
5720: fnd_file.put_line(fnd_file.output,' ' );
5721:
5722:
5723: EXCEPTION

Line 5720: fnd_file.put_line(fnd_file.output,' ' );

5716: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_SUCCESSFUL'), 40) || ' : ' || l_success_record_cnt);
5717: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_REJECTED'), 40) || ' : ' || g_error_record_cnt);
5718: fnd_file.put_line(fnd_file.output,' ' );
5719: fnd_file.put_line(fnd_file.output, RPAD('-',50,'-'));
5720: fnd_file.put_line(fnd_file.output,' ' );
5721:
5722:
5723: EXCEPTION
5724:

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

5729: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_imp_pkg.run.exception','Exception'|| SQLERRM);
5730: END IF;
5731: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
5732: fnd_message.set_token('NAME','IGF_SL_CL_LI_IMP_PKG.RUN');
5733: fnd_file.put_line(fnd_file.log,fnd_message.get);
5734: retcode := 2;
5735: errbuf := fnd_message.get;
5736: igs_ge_msg_stack.conc_exception_hndl;
5737: END run;