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_AP_LG_COA_IMP dependencies on IGF_AP_LG_COA_IMP

Line 1: PACKAGE BODY igf_ap_lg_coa_imp AS

1: PACKAGE BODY igf_ap_lg_coa_imp AS
2: /* $Header: IGFAP40B.pls 120.2 2006/01/17 02:37:45 tsailaja noship $ */
3:
4: g_log_tab_index NUMBER := 0;
5:

Line 80: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_lg_coa_imp.log_input_params.exception','Unhandled exception in Procedure log_input_params '||SQLERRM);

76:
77: EXCEPTION
78: WHEN OTHERS THEN
79: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
80: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_lg_coa_imp.log_input_params.exception','Unhandled exception in Procedure log_input_params '||SQLERRM);
81: END IF;
82: END log_input_params ;
83:
84:

Line 114: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_lg_coa_imp.print_log_process.exception','Unhandled exception in Procedure print_log_process'||SQLERRM);

110:
111: EXCEPTION
112: WHEN OTHERS THEN
113: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
114: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_lg_coa_imp.print_log_process.exception','Unhandled exception in Procedure print_log_process'||SQLERRM);
115: END IF;
116: END print_log_process;
117:
118:

Line 173: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_lg_coa_imp.chk_per_rec_stat.exception','Unhandled exception in Procedure chk_per_rec_stat'||SQLERRM);

169:
170: EXCEPTION
171: WHEN OTHERS THEN
172: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
173: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_lg_coa_imp.chk_per_rec_stat.exception','Unhandled exception in Procedure chk_per_rec_stat'||SQLERRM);
174: END IF;
175: END chk_per_rec_stat;
176:
177:

Line 241: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_lg_coa_imp.check_person_terms.exception','Unhandled exception in Procedure check_person_terms'||SQLERRM);

237:
238: EXCEPTION
239: WHEN OTHERS THEN
240: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
241: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_lg_coa_imp.check_person_terms.exception','Unhandled exception in Procedure check_person_terms'||SQLERRM);
242: END IF;
243: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
244: fnd_message.set_token('NAME','IGF_AP_LG_COA_IMP.CHECK_PERSON_TERMS');
245: igs_ge_msg_stack.add;

Line 244: fnd_message.set_token('NAME','IGF_AP_LG_COA_IMP.CHECK_PERSON_TERMS');

240: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
241: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_lg_coa_imp.check_person_terms.exception','Unhandled exception in Procedure check_person_terms'||SQLERRM);
242: END IF;
243: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
244: fnd_message.set_token('NAME','IGF_AP_LG_COA_IMP.CHECK_PERSON_TERMS');
245: igs_ge_msg_stack.add;
246: app_exception.raise_exception;
247:
248: END check_person_terms ;

Line 285: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_lg_coa_imp.check_dup_coa.exception','Unhandled exception in Procedure check_dup_coa'||SQLERRM);

281:
282: EXCEPTION
283: WHEN OTHERS THEN
284: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
285: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_lg_coa_imp.check_dup_coa.exception','Unhandled exception in Procedure check_dup_coa'||SQLERRM);
286: END IF;
287: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
288: fnd_message.set_token('NAME','IGF_AP_LG_COA_IMP.CHECK_DUP_COA');
289: igs_ge_msg_stack.add;

Line 288: fnd_message.set_token('NAME','IGF_AP_LG_COA_IMP.CHECK_DUP_COA');

284: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
285: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_lg_coa_imp.check_dup_coa.exception','Unhandled exception in Procedure check_dup_coa'||SQLERRM);
286: END IF;
287: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
288: fnd_message.set_token('NAME','IGF_AP_LG_COA_IMP.CHECK_DUP_COA');
289: igs_ge_msg_stack.add;
290: app_exception.raise_exception;
291:
292: END check_dup_coa ;

Line 336: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_lg_coa_imp.check_dup_coa_term.exception','Unhandled exception in Procedure check_dup_coa_term'||SQLERRM);

332:
333: EXCEPTION
334: WHEN OTHERS THEN
335: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
336: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_lg_coa_imp.check_dup_coa_term.exception','Unhandled exception in Procedure check_dup_coa_term'||SQLERRM);
337: END IF;
338: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
339: fnd_message.set_token('NAME','IGF_AP_LG_COA_IMP.CHECK_DUP_COA_TERM');
340: igs_ge_msg_stack.add;

Line 339: fnd_message.set_token('NAME','IGF_AP_LG_COA_IMP.CHECK_DUP_COA_TERM');

335: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
336: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_lg_coa_imp.check_dup_coa_term.exception','Unhandled exception in Procedure check_dup_coa_term'||SQLERRM);
337: END IF;
338: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
339: fnd_message.set_token('NAME','IGF_AP_LG_COA_IMP.CHECK_DUP_COA_TERM');
340: igs_ge_msg_stack.add;
341: app_exception.raise_exception;
342:
343: END check_dup_coa_term ;

Line 372: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_lg_coa_imp.delete_coa_terms.exception','Unhandled exception in Procedure delete_coa_terms'||SQLERRM);

368:
369: EXCEPTION
370: WHEN OTHERS THEN
371: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
372: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_lg_coa_imp.delete_coa_terms.exception','Unhandled exception in Procedure delete_coa_terms'||SQLERRM);
373: END IF;
374: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
375: fnd_message.set_token('NAME','IGF_AP_LG_COA_IMP.DELETE_COA_TERMS');
376: igs_ge_msg_stack.add;

Line 375: fnd_message.set_token('NAME','IGF_AP_LG_COA_IMP.DELETE_COA_TERMS');

371: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
372: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_lg_coa_imp.delete_coa_terms.exception','Unhandled exception in Procedure delete_coa_terms'||SQLERRM);
373: END IF;
374: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
375: fnd_message.set_token('NAME','IGF_AP_LG_COA_IMP.DELETE_COA_TERMS');
376: igs_ge_msg_stack.add;
377: app_exception.raise_exception;
378:
379: END delete_coa_terms ;

Line 409: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_lg_coa_imp.delete_coa_items.exception','Unhandled exception in Procedure delete_coa_items'||SQLERRM);

405:
406: EXCEPTION
407: WHEN OTHERS THEN
408: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
409: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_lg_coa_imp.delete_coa_items.exception','Unhandled exception in Procedure delete_coa_items'||SQLERRM);
410: END IF;
411: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
412: fnd_message.set_token('NAME','IGF_AP_LG_COA_IMP.DELETE_COA_ITEMS');
413: igs_ge_msg_stack.add;

Line 412: fnd_message.set_token('NAME','IGF_AP_LG_COA_IMP.DELETE_COA_ITEMS');

408: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
409: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_lg_coa_imp.delete_coa_items.exception','Unhandled exception in Procedure delete_coa_items'||SQLERRM);
410: END IF;
411: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
412: fnd_message.set_token('NAME','IGF_AP_LG_COA_IMP.DELETE_COA_ITEMS');
413: igs_ge_msg_stack.add;
414: app_exception.raise_exception;
415:
416: END delete_coa_items ;

Line 570: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_lg_coa_imp.main.debug','Completed input parameters logging in Procedure main');

566:
567: -- Log input params
568: log_input_params( p_batch_num, l_alternate_code , p_delete_flag);
569: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
570: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_lg_coa_imp.main.debug','Completed input parameters logging in Procedure main');
571: END IF;
572:
573: -- Get Award Year Status
574: OPEN c_get_stat ;

Line 615: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_lg_coa_imp.main.debug','Completed batch validations in Procedure main');

611: g_terminate_process := TRUE ;
612: END IF;
613:
614: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
615: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_lg_coa_imp.main.debug','Completed batch validations in Procedure main');
616: END IF;
617:
618: /***********************************************************************
619: Person Level checks

Line 762: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_lg_coa_imp.main.debug','Completed person validations in Procedure main');

758:
759: END IF ; -- person already processed check
760:
761: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
762: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_lg_coa_imp.main.debug','Completed person validations in Procedure main');
763: END IF;
764: /* End Of Person level Check */
765: /**************************************************
766: COA Item Level checks

Line 921: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_lg_coa_imp.main.debug','Completed record validations in Procedure main');

917: END IF ; --
918: END IF ;
919:
920: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
921: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_lg_coa_imp.main.debug','Completed record validations in Procedure main');
922: END IF;
923:
924: -- all record validations done ...
925: -- now check for skip record flag

Line 1044: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_lg_coa_imp.main.debug','Inserted COA record in Procedure main');

1040: x_mode => 'R' );
1041:
1042:
1043: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
1044: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_lg_coa_imp.main.debug','Inserted COA record in Procedure main');
1045: END IF;
1046:
1047: -- now update the record status
1048: IF p_delete_flag = 'Y' THEN

Line 1179: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_lg_coa_imp.main.exception','Unhandled exception in Procedure main'||SQLERRM);

1175: EXCEPTION
1176: WHEN OTHERS THEN
1177: ROLLBACK;
1178: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
1179: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_lg_coa_imp.main.exception','Unhandled exception in Procedure main'||SQLERRM);
1180: END IF;
1181: RETCODE := 2 ;
1182: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP') ;
1183: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_LG_COA_IMP.MAIN') ;

Line 1183: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_LG_COA_IMP.MAIN') ;

1179: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_lg_coa_imp.main.exception','Unhandled exception in Procedure main'||SQLERRM);
1180: END IF;
1181: RETCODE := 2 ;
1182: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP') ;
1183: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_LG_COA_IMP.MAIN') ;
1184: errbuf := FND_MESSAGE.GET ;
1185: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL ;
1186:
1187: END main ;

Line 1189: END igf_ap_lg_coa_imp ;

1185: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL ;
1186:
1187: END main ;
1188:
1189: END igf_ap_lg_coa_imp ;