eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_SL_DL_LI_IMP_PKG dependencies on IGF_SL_DL_LI_IMP_PKG

Line 1: PACKAGE BODY IGF_SL_DL_LI_IMP_PKG AS

1: PACKAGE BODY IGF_SL_DL_LI_IMP_PKG AS
2: /* $Header: IGFSL20B.pls 120.6 2006/09/07 13:20:52 bvisvana ship $ */
3: CURSOR c_interface (cp_batch_id NUMBER,
4: cp_alternate_code VARCHAR2,
5: p_import_status_type_1 igf_sl_li_dlor_ints.import_status_type%TYPE,

Line 225: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_li_imp_pkg.print_message.exception','Exception :'||SQLERRM);

221: END IF;
222: EXCEPTION
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);

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 1064: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_li_imp_pkg.validate_loan_disb.exception','Exception: '||SQLERRM);

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

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 1650: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_li_imp_pkg.validate_loan_orig_int.exception','Exception: '||SQLERRM);

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

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 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 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 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 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 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 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 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 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 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 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 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 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 2990: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_sl_dl_li_imp_pkg.delete_context_records.exception','Exception:'||SQLERRM);

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

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 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 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 3449: IF fnd_log.TEST(FND_LOG.LEVEL_STATEMENT,'IGF_SL_DL_LI_IMP_PKG') THEN

3445:
3446:
3447:
3448: -- Initialize lb_write_log for writing into debug log table
3449: IF fnd_log.TEST(FND_LOG.LEVEL_STATEMENT,'IGF_SL_DL_LI_IMP_PKG') THEN
3450: lb_write_log := TRUE;
3451: END IF;
3452: fnd_file.put_line(fnd_file.log,l_processing ||' '||l_person_number||' '||l_interface.person_number);
3453: fnd_file.new_line(fnd_file.log,1);

Line 3898: fnd_log.string_with_context(FND_LOG.LEVEL_STATEMENT,'IGF_SL_DL_LI_IMP_PKG', l_debug_str,NULL,NULL,NULL,NULL,NULL,TO_CHAR(g_request_id));

3894: IF lb_write_log THEN
3895: IF g_request_id IS NULL THEN
3896: g_request_id := fnd_global.conc_request_id;
3897: END IF;
3898: fnd_log.string_with_context(FND_LOG.LEVEL_STATEMENT,'IGF_SL_DL_LI_IMP_PKG', l_debug_str,NULL,NULL,NULL,NULL,NULL,TO_CHAR(g_request_id));
3899: END IF;
3900:
3901: END; -- block for updating and deleting interface records
3902: END LOOP;

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

3918: EXCEPTION
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;

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 3931: END IGF_SL_DL_LI_IMP_PKG;

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;