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.IGS_PE_GEN_003 dependencies on FND_MESSAGE

Line 38: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXCEPTION');

34: EXCEPTION
35: WHEN OTHERS THEN
36: l_label := 'igs.plsql.igs_pe_gen_003.process_res_dtls.exception';
37: IF fnd_log.test(fnd_log.level_exception,l_label) THEN
38: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXCEPTION');
39: l_debug_str := fnd_message.get || '. Residency Details Id : '||P_NEW_RECORD.RESIDENT_DETAILS_ID ||' '|| SQLERRM;
40: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
41: END IF;
42: END process_res_dtls;

Line 39: l_debug_str := fnd_message.get || '. Residency Details Id : '||P_NEW_RECORD.RESIDENT_DETAILS_ID ||' '|| SQLERRM;

35: WHEN OTHERS THEN
36: l_label := 'igs.plsql.igs_pe_gen_003.process_res_dtls.exception';
37: IF fnd_log.test(fnd_log.level_exception,l_label) THEN
38: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXCEPTION');
39: l_debug_str := fnd_message.get || '. Residency Details Id : '||P_NEW_RECORD.RESIDENT_DETAILS_ID ||' '|| SQLERRM;
40: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
41: END IF;
42: END process_res_dtls;
43:

Line 63: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXCEPTION');

59: EXCEPTION
60: WHEN OTHERS THEN
61: l_label := 'igs.plsql.igs_pe_gen_003.process_housing_dtls.exception';
62: IF fnd_log.test(fnd_log.level_exception,l_label) THEN
63: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXCEPTION');
64: l_debug_str := fnd_message.get || '. Teaching Period Id : '||P_NEW_RECORD.TEACHING_PERIOD_ID ||' '|| SQLERRM;
65: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
66: END IF;
67: END process_housing_dtls;

Line 64: l_debug_str := fnd_message.get || '. Teaching Period Id : '||P_NEW_RECORD.TEACHING_PERIOD_ID ||' '|| SQLERRM;

60: WHEN OTHERS THEN
61: l_label := 'igs.plsql.igs_pe_gen_003.process_housing_dtls.exception';
62: IF fnd_log.test(fnd_log.level_exception,l_label) THEN
63: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXCEPTION');
64: l_debug_str := fnd_message.get || '. Teaching Period Id : '||P_NEW_RECORD.TEACHING_PERIOD_ID ||' '|| SQLERRM;
65: fnd_log.string_with_context( fnd_log.level_exception,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
66: END IF;
67: END process_housing_dtls;
68:

Line 130: l_debug_str := fnd_message.get || ' Action : ' || p_action ||'/' ||' Person : ' ||p_person_id ||'/'||' S person type : '||l_system_type ||'/' || ' Sequence is : '||ln_seq_val ;

126:
127: -- fnd_logging before raising business event
128: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
129: l_label := 'igs.plsql.igs_pe_gen_003.raise_person_type_event.raise_event';
130: l_debug_str := fnd_message.get || ' Action : ' || p_action ||'/' ||' Person : ' ||p_person_id ||'/'||' S person type : '||l_system_type ||'/' || ' Sequence is : '||ln_seq_val ;
131: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
132: END IF;
133:
134: -- raise event

Line 151: l_debug_str := fnd_message.get || 'Person : ' ||p_person_id ||'/'||' S person type : '||l_system_type ||'/' || ' sequence is : '||ln_seq_val ||'/'|| SQLERRM ;

147: WHEN OTHERS THEN
148:
149: IF fnd_log.test(fnd_log.level_procedure,l_prog_label) THEN
150: l_label := 'igs.plsql.igs_pe_gen_003.raise_person_type_event.execption';
151: l_debug_str := fnd_message.get || 'Person : ' ||p_person_id ||'/'||' S person type : '||l_system_type ||'/' || ' sequence is : '||ln_seq_val ||'/'|| SQLERRM ;
152: fnd_log.string_with_context( fnd_log.level_procedure,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
153: END IF;
154:
155: END RAISE_PERSON_TYPE_EVENT;

Line 275: l_debug_str := fnd_message.get || 'System Person Type : '||l_system_person_type ||'/'|| ' User id : ' ||l_user_id || ' End Date ' ||'/' ||l_end_date;

271:
272: --fnd_logging
273: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
274: l_label := 'igs.plsql.igs_pe_gen_003.resp_assignment.'||l_action;
275: l_debug_str := fnd_message.get || 'System Person Type : '||l_system_person_type ||'/'|| ' User id : ' ||l_user_id || ' End Date ' ||'/' ||l_end_date;
276: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
277: END IF;
278:
279: IF l_action = 'INSERT' THEN

Line 330: l_debug_str := fnd_message.get || 'System Person Type : '||l_system_person_type ||'/'|| ' User id : ' ||l_user_id || ' End Date ' ||'/' ||l_end_date;

326: FOR resp_info_rec IN get_resp_info_cur(l_system_person_type, l_user_id) LOOP
327: --fnd_logging
328: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
329: l_label := 'igs.plsql.igs_pe_gen_003.resp_assignment.'||l_action;
330: l_debug_str := fnd_message.get || 'System Person Type : '||l_system_person_type ||'/'|| ' User id : ' ||l_user_id || ' End Date ' ||'/' ||l_end_date;
331: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
332: END IF;
333: Fnd_User_Resp_Groups_api.insert_assignment (
334: user_id => l_user_id,

Line 350: l_debug_str := fnd_message.get || 'System Person Type : '||l_system_person_type ||'/'|| ' User id : ' ||l_user_id || ' Resp ' ||resp_sys_rec.responsibility_id ;

346: FOR resp_sys_rec IN get_resp_sys_cur(l_user_id, l_system_person_type) LOOP
347: --fnd_logging
348: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
349: l_label := 'igs.plsql.igs_pe_gen_003.resp_assignment.delete';
350: l_debug_str := fnd_message.get || 'System Person Type : '||l_system_person_type ||'/'|| ' User id : ' ||l_user_id || ' Resp ' ||resp_sys_rec.responsibility_id ;
351: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
352: END IF;
353:
354: -- Delete event will only be called for Others person type. And will always be for sysdate.

Line 379: l_debug_str := fnd_message.get || 'System Person Type : '||l_system_person_type ||'/'|| ' User id : ' ||l_user_id || SQLERRM;

375:
376: --fnd_logging
377: IF fnd_log.test(fnd_log.level_statement,l_prog_label) THEN
378: l_label := 'igs.plsql.igs_pe_gen_003.resp_assignment.exception';
379: l_debug_str := fnd_message.get || 'System Person Type : '||l_system_person_type ||'/'|| ' User id : ' ||l_user_id || SQLERRM;
380: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
381: END IF;
382:
383: WF_CORE.CONTEXT('IGS_PE_ELEARNING_PKG','RESP_ASSIGNMENT',1, p_subscription_guid);