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 IGS_PE_GEN_003

Line 1: PACKAGE BODY igs_pe_gen_003 AS

1: PACKAGE BODY igs_pe_gen_003 AS
2: /* $Header: IGSPE18B.pls 120.9 2006/01/23 06:33:29 gmaheswa noship $ */
3: /*
4: || Created By : gmaheswa
5: || Created On : 2-NOV-2004

Line 25: fnd_log.string(fnd_log.level_statement,'igs.plsql.igs_pe_gen_003.process_res_dtls.debug','l_residency_class:'||l_residency_class);

21: l_residency_class igs_pe_res_dtls.residency_class_cd%TYPE;
22: BEGIN
23: fnd_profile.get('IGS_FI_RES_CLASS_ID',l_residency_class);
24: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
25: fnd_log.string(fnd_log.level_statement,'igs.plsql.igs_pe_gen_003.process_res_dtls.debug','l_residency_class:'||l_residency_class);
26: END IF;
27: IF (p_action = 'I' AND NVL(l_residency_class,'*') = p_new_record.residency_class_cd)
28: OR (p_action = 'U' AND NVL(l_residency_class,'*') = p_new_record.residency_class_cd AND NVL(p_old_record.residency_status_cd,'*') <> NVL(p_new_record.residency_status_cd,'*')) THEN
29: igf_aw_coa_gen.ins_coa_todo(

Line 36: l_label := 'igs.plsql.igs_pe_gen_003.process_res_dtls.exception';

32: );
33: END IF;
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);

Line 61: l_label := 'igs.plsql.igs_pe_gen_003.process_housing_dtls.exception';

57: );
58: END IF;
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);

Line 102: l_prog_label CONSTANT VARCHAR2(100) := 'igs.plsql.igs_pe_gen_003.raise_person_type_event';

98: l_system_type IGS_PE_PERSON_TYPES.system_type%TYPE;
99: ln_seq_val NUMBER;
100: l_event_t wf_event_t;
101: l_parameter_list_t wf_parameter_list_t := wf_parameter_list_t();
102: l_prog_label CONSTANT VARCHAR2(100) := 'igs.plsql.igs_pe_gen_003.raise_person_type_event';
103: l_label VARCHAR2(500);
104: l_debug_str VARCHAR2(3200);
105:
106: BEGIN

Line 129: l_label := 'igs.plsql.igs_pe_gen_003.raise_person_type_event.raise_event';

125: CLOSE c_seq_num ;
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:

Line 150: l_label := 'igs.plsql.igs_pe_gen_003.raise_person_type_event.execption';

146: EXCEPTION
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:

Line 245: l_prog_label CONSTANT VARCHAR2(100) := 'igs.plsql.igs_pe_gen_003.resp_assignment';

241: l_system_person_type VARCHAR2(30);
242: l_action VARCHAR2(10);
243: l_user_id fnd_user.user_id%type;
244: l_result VARCHAR2(100);
245: l_prog_label CONSTANT VARCHAR2(100) := 'igs.plsql.igs_pe_gen_003.resp_assignment';
246: l_label VARCHAR2(500);
247: l_debug_str VARCHAR2(3200);
248: l_end_date DATE;
249:

Line 274: l_label := 'igs.plsql.igs_pe_gen_003.resp_assignment.'||l_action;

270: FOR inactive_resp_rec IN get_inactive_resp_cur(l_user_id, l_system_person_type) LOOP
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:

Line 329: l_label := 'igs.plsql.igs_pe_gen_003.resp_assignment.'||l_action;

325:
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 (

Line 349: l_label := 'igs.plsql.igs_pe_gen_003.resp_assignment.delete';

345:
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:

Line 378: l_label := 'igs.plsql.igs_pe_gen_003.resp_assignment.exception';

374: WHEN OTHERS THEN
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:

Line 416: END igs_pe_gen_003;

412: END IF;
413: END TURNOFF_TCA_BE;
414:
415:
416: END igs_pe_gen_003;