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 IGF_SL_CL_LI_IMP_PKG

Line 1: PACKAGE BODY IGF_SL_CL_LI_IMP_PKG AS

1: PACKAGE BODY IGF_SL_CL_LI_IMP_PKG AS
2: /* $Header: IGFSL19B.pls 120.11 2006/08/07 13:22:03 azmohamm ship $ */
3:
4: /*
5: --=========================================================================

Line 11: -- PL/SQL Body for package: IGF_SL_CL_LI_IMP_PKG

7: -- All rights reserved.
8: -- ========================================================================
9: --
10: -- DESCRIPTION
11: -- PL/SQL Body for package: IGF_SL_CL_LI_IMP_PKG
12: --
13: -- NOTES
14: --
15: -- This package is used to import the legacy FFELP Loan and Disbursement

Line 501: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_li_imp_pkg.log_parameters.exception','LOG_PARAMETERS :: ' || SQLERRM);

497:
498: EXCEPTION
499: WHEN OTHERS THEN
500: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
501: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_li_imp_pkg.log_parameters.exception','LOG_PARAMETERS :: ' || SQLERRM);
502: END IF;
503: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
504: fnd_message.set_token('NAME','IGF_SL_CL_LI_IMP_PKG.LOG_PARAMETERS');
505: igs_ge_msg_stack.add;

Line 504: fnd_message.set_token('NAME','IGF_SL_CL_LI_IMP_PKG.LOG_PARAMETERS');

500: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
501: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_li_imp_pkg.log_parameters.exception','LOG_PARAMETERS :: ' || SQLERRM);
502: END IF;
503: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
504: fnd_message.set_token('NAME','IGF_SL_CL_LI_IMP_PKG.LOG_PARAMETERS');
505: igs_ge_msg_stack.add;
506:
507: END log_parameters;
508:

Line 567: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_li_imp_pkg.is_valid.debug','IS_VALID: l_part_1 ' || l_part_1);

563:
564: l_part_1 := SUBSTR(p_loan_number,1,8);
565:
566: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
567: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_li_imp_pkg.is_valid.debug','IS_VALID: l_part_1 ' || l_part_1);
568: END IF;
569:
570: OPEN c_source_or_branch_id(l_part_1, 'OPE_ID_NUM');
571: FETCH c_source_or_branch_id INTO l_source_or_branch_id;

Line 574: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_li_imp_pkg.is_valid.debug','IS_VALID: l_part_1 not valid for school id' || l_part_1);

570: OPEN c_source_or_branch_id(l_part_1, 'OPE_ID_NUM');
571: FETCH c_source_or_branch_id INTO l_source_or_branch_id;
572: IF (c_source_or_branch_id%NOTFOUND) THEN
573: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
574: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_li_imp_pkg.is_valid.debug','IS_VALID: l_part_1 not valid for school id' || l_part_1);
575: END IF;
576: CLOSE c_source_or_branch_id;
577: RETURN FALSE;
578: ELSE

Line 589: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_li_imp_pkg.is_valid.debug','IS_VALID: l_part_2 not valid for school non ed branch id' || l_part_2);

585: OPEN c_source_or_branch_id(l_part_2, 'SCH_NON_ED_BRC_ID');
586: FETCH c_source_or_branch_id INTO l_source_or_branch_id;
587: IF (c_source_or_branch_id%NOTFOUND) THEN
588: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
589: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_li_imp_pkg.is_valid.debug','IS_VALID: l_part_2 not valid for school non ed branch id' || l_part_2);
590: END IF;
591: CLOSE c_source_or_branch_id;
592: RETURN FALSE;
593: ELSE

Line 599: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_li_imp_pkg.is_valid.debug','IS_VALID: l_part_2 ' || l_part_2);

595: END IF;
596: END IF;
597:
598: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
599: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_li_imp_pkg.is_valid.debug','IS_VALID: l_part_2 ' || l_part_2);
600: END IF;
601:
602: l_part_3 := SUBSTR(p_loan_number,12,3);
603: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 604: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_li_imp_pkg.is_valid.debug','IS_VALID: l_part_3 ' || l_part_3);

600: END IF;
601:
602: l_part_3 := SUBSTR(p_loan_number,12,3);
603: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
604: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_li_imp_pkg.is_valid.debug','IS_VALID: l_part_3 ' || l_part_3);
605: END IF;
606: l_part3_1 := SUBSTR(l_part_3,1,1);
607: l_part3_2 := SUBSTR(l_part_3,2,1);
608: l_part3_3 := SUBSTR(l_part_3,3,1);

Line 612: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_li_imp_pkg.is_valid.debug','IS_VALID: l_part3_1 ' || l_part3_1);

608: l_part3_3 := SUBSTR(l_part_3,3,1);
609:
610: IF l_part3_1 NOT IN ('0','1','2','3','4','5','6','7','8','9','A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P','Q','R','S') THEN
611: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
612: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_li_imp_pkg.is_valid.debug','IS_VALID: l_part3_1 ' || l_part3_1);
613: END IF;
614: RETURN FALSE;
615: ELSIF (l_part3_1 = 'S') THEN
616: IF l_part3_2 NOT IN ('0','1','2','3','4','5','6','7','8','9','A','B') THEN

Line 618: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_li_imp_pkg.is_valid.debug','is_valid: l_part3_2 ' || l_part3_2);

614: RETURN FALSE;
615: ELSIF (l_part3_1 = 'S') THEN
616: IF l_part3_2 NOT IN ('0','1','2','3','4','5','6','7','8','9','A','B') THEN
617: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
618: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_li_imp_pkg.is_valid.debug','is_valid: l_part3_2 ' || l_part3_2);
619: END IF;
620: RETURN FALSE;
621: END IF;
622: ELSIF (l_part3_1 <> 'S') THEN

Line 1190: fnd_message.set_token('NAME','IGF_SL_CL_LI_IMP_PKG.VALIDATE_RELEASE');

1186: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1187: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_imp_pkg.validate_release.exception','Exception ' || SQLERRM);
1188: END IF;
1189: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
1190: fnd_message.set_token('NAME','IGF_SL_CL_LI_IMP_PKG.VALIDATE_RELEASE');
1191:
1192: RAISE IMPORT_ERROR;
1193: END;
1194:

Line 2919: fnd_message.set_token('NAME','IGF_SL_CL_LI_IMP_PKG.VALIDATE_LOAN_ORIG_INT');

2915: EXCEPTION
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);

Line 3251: fnd_message.set_token('NAME','IGF_SL_CL_LI_IMP_PKG.VALIDATE_LOAN_DISB');

3247: EXCEPTION
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);

Line 3294: fnd_message.set_token('NAME','IGF_SL_CL_LI_IMP_PKG.WRITE_LOGFILE');

3290: EXCEPTION
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);

Line 3451: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_li_imp_pkg.delete_records.debug','l_alt_borw ROWID '|| l_alt_borw.rowid);

3447: FETCH c_alt_borw INTO l_alt_borw;
3448: IF (c_alt_borw%FOUND) THEN
3449: CLOSE c_alt_borw;
3450: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3451: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_li_imp_pkg.delete_records.debug','l_alt_borw ROWID '|| l_alt_borw.rowid);
3452: END IF;
3453: igf_sl_alt_borw_pkg.delete_row(x_ROWID => l_alt_borw.rowid);
3454: ELSE
3455: CLOSE c_alt_borw;

Line 3460: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_li_imp_pkg.delete_records.debug','l_disb_loc ROWID ' || l_disb_loc.rowid);

3456: END IF;
3457:
3458: FOR l_disb_loc IN c_disb_loc(l_award_id) LOOP
3459: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
3460: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_li_imp_pkg.delete_records.debug','l_disb_loc ROWID ' || l_disb_loc.rowid);
3461: END IF;
3462: igf_sl_awd_disb_loc_pkg.delete_row(x_ROWID => l_disb_loc.rowid);
3463: END LOOP;
3464:

Line 3526: fnd_message.set_token('NAME','IGF_SL_CL_LI_IMP_PKG.DELETE_RECORDS');

3522: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
3523: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_imp_pkg.delete_records.exception','Exception ' || SQLERRM);
3524: END IF;
3525: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
3526: fnd_message.set_token('NAME','IGF_SL_CL_LI_IMP_PKG.DELETE_RECORDS');
3527:
3528: RAISE IMPORT_ERROR;
3529:
3530:

Line 5037: fnd_message.set_token('NAME','IGF_SL_CL_LI_IMP_PKG.INSERT_RECORDS');

5033: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
5034: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_cl_imp_pkg.insert_records.exception','Exception ' || SQLERRM);
5035: END IF;
5036: fnd_message.set_name('IGF','IGF_GE_UNHANDLED_EXP');
5037: fnd_message.set_token('NAME','IGF_SL_CL_LI_IMP_PKG.INSERT_RECORDS');
5038:
5039: RAISE IMPORT_ERROR;
5040:
5041: END insert_records;

Line 5732: fnd_message.set_token('NAME','IGF_SL_CL_LI_IMP_PKG.RUN');

5728: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
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;

Line 5739: END IGF_SL_CL_LI_IMP_PKG;

5735: errbuf := fnd_message.get;
5736: igs_ge_msg_stack.conc_exception_hndl;
5737: END run;
5738:
5739: END IGF_SL_CL_LI_IMP_PKG;