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 FND_LOG

Line 79: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN

75: FND_FILE.PUT_LINE( FND_FILE.LOG, ' ');
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:

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

109: END LOOP;
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:

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

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

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

236: END LOOP ;
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');

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

280: CLOSE chk_dup_coa ;
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');

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

331: CLOSE chk_dup_term ;
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');

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

367: END LOOP;
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');

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

404: END LOOP;
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');

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 569: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

565: CLOSE c_alternate_code ;
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

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 614: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

610: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
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: /***********************************************************************

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 761: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

757:
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: /**************************************************

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 920: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

916:
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 ...

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 1043: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

1039: x_lock_flag => 'N',
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

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

1174:
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') ;

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