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_AW_LOCK_ASSGN_PKG dependencies on FND_MESSAGE

Line 149: fnd_message.set_name('IGF','IGF_AW_COA_PARAM_EX_P');

145:
146: --If person selection is for all persons in the Person ID Group and
147: --Person ID Group is NULL then log error with exception
148: ELSIF p_run_type = 'P' AND p_pid_group IS NULL THEN
149: fnd_message.set_name('IGF','IGF_AW_COA_PARAM_EX_P');
150: fnd_file.put_line(fnd_file.log,fnd_message.get);
151: RAISE param_exception;
152:
153: --If person selection is for a single person and

Line 150: fnd_file.put_line(fnd_file.log,fnd_message.get);

146: --If person selection is for all persons in the Person ID Group and
147: --Person ID Group is NULL then log error with exception
148: ELSIF p_run_type = 'P' AND p_pid_group IS NULL THEN
149: fnd_message.set_name('IGF','IGF_AW_COA_PARAM_EX_P');
150: fnd_file.put_line(fnd_file.log,fnd_message.get);
151: RAISE param_exception;
152:
153: --If person selection is for a single person and
154: --Base ID is NULL then log error with exception

Line 156: fnd_message.set_name('IGF','IGF_AW_COA_PARAM_EX_S');

152:
153: --If person selection is for a single person and
154: --Base ID is NULL then log error with exception
155: ELSIF p_run_type = 'S' AND p_base_id IS NULL THEN
156: fnd_message.set_name('IGF','IGF_AW_COA_PARAM_EX_S');
157: fnd_file.put_line(fnd_file.log,fnd_message.get);
158: RAISE param_exception;
159:
160: END IF;

Line 157: fnd_file.put_line(fnd_file.log,fnd_message.get);

153: --If person selection is for a single person and
154: --Base ID is NULL then log error with exception
155: ELSIF p_run_type = 'S' AND p_base_id IS NULL THEN
156: fnd_message.set_name('IGF','IGF_AW_COA_PARAM_EX_S');
157: fnd_file.put_line(fnd_file.log,fnd_message.get);
158: RAISE param_exception;
159:
160: END IF;
161:

Line 169: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');

165: --COMPUTATION ONLY IF PERSON NUMBER IS PRESENT
166: IF p_run_type = 'S' AND (p_pid_group IS NULL) AND (p_base_id IS NOT NULL) THEN
167:
168: fnd_file.new_line(fnd_file.log,1);
169: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
170: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(p_base_id));
171: fnd_file.put_line(fnd_file.log,fnd_message.get);
172:
173: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 170: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(p_base_id));

166: IF p_run_type = 'S' AND (p_pid_group IS NULL) AND (p_base_id IS NOT NULL) THEN
167:
168: fnd_file.new_line(fnd_file.log,1);
169: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
170: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(p_base_id));
171: fnd_file.put_line(fnd_file.log,fnd_message.get);
172:
173: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
174: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_lock_assgn_pkg.main.debug','Starting Run_Type=S with base_id:'||p_base_id);

Line 171: fnd_file.put_line(fnd_file.log,fnd_message.get);

167:
168: fnd_file.new_line(fnd_file.log,1);
169: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
170: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(p_base_id));
171: fnd_file.put_line(fnd_file.log,fnd_message.get);
172:
173: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
174: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_lock_assgn_pkg.main.debug','Starting Run_Type=S with base_id:'||p_base_id);
175: END IF;

Line 192: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');

188: ELSIF p_run_type = 'Y' AND (p_pid_group IS NULL) AND (p_base_id IS NULL) THEN
189: FOR l_per_awd_rec IN c_per_awd_yr(lv_ci_cal_type,ln_ci_sequence_number)
190: LOOP
191: fnd_file.new_line(fnd_file.log,1);
192: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
193: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(l_per_awd_rec.base_id));
194: fnd_file.put_line(fnd_file.log,fnd_message.get);
195:
196: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 193: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(l_per_awd_rec.base_id));

189: FOR l_per_awd_rec IN c_per_awd_yr(lv_ci_cal_type,ln_ci_sequence_number)
190: LOOP
191: fnd_file.new_line(fnd_file.log,1);
192: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
193: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(l_per_awd_rec.base_id));
194: fnd_file.put_line(fnd_file.log,fnd_message.get);
195:
196: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
197: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_lock_assgn_pkg.main.debug','Starting Run_Type=Y with base_id:'||l_per_awd_rec.base_id);

Line 194: fnd_file.put_line(fnd_file.log,fnd_message.get);

190: LOOP
191: fnd_file.new_line(fnd_file.log,1);
192: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
193: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(l_per_awd_rec.base_id));
194: fnd_file.put_line(fnd_file.log,fnd_message.get);
195:
196: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
197: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_lock_assgn_pkg.main.debug','Starting Run_Type=Y with base_id:'||l_per_awd_rec.base_id);
198: END IF;

Line 235: fnd_message.set_name('IGF','IGF_DB_NO_PER_GRP');

231:
232: FETCH cur_per_grp INTO per_grp_rec;
233:
234: IF (cur_per_grp%NOTFOUND) THEN
235: fnd_message.set_name('IGF','IGF_DB_NO_PER_GRP');
236: fnd_file.put_line(fnd_file.log,fnd_message.get);
237: ELSE
238: LOOP
239: -- check if person has a fa base record

Line 236: fnd_file.put_line(fnd_file.log,fnd_message.get);

232: FETCH cur_per_grp INTO per_grp_rec;
233:
234: IF (cur_per_grp%NOTFOUND) THEN
235: fnd_message.set_name('IGF','IGF_DB_NO_PER_GRP');
236: fnd_file.put_line(fnd_file.log,fnd_message.get);
237: ELSE
238: LOOP
239: -- check if person has a fa base record
240: ln_base_id := NULL;

Line 253: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');

249: );
250:
251: IF lv_err_msg = 'NULL' THEN
252: fnd_file.new_line(fnd_file.log,1);
253: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
254: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(ln_base_id));
255: fnd_file.put_line(fnd_file.log,fnd_message.get);
256:
257: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

Line 254: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(ln_base_id));

250:
251: IF lv_err_msg = 'NULL' THEN
252: fnd_file.new_line(fnd_file.log,1);
253: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
254: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(ln_base_id));
255: fnd_file.put_line(fnd_file.log,fnd_message.get);
256:
257: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
258: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_lock_assgn_pkg.main.debug','Starting Run_Type=P with base_id:'||ln_base_id);

Line 255: fnd_file.put_line(fnd_file.log,fnd_message.get);

251: IF lv_err_msg = 'NULL' THEN
252: fnd_file.new_line(fnd_file.log,1);
253: fnd_message.set_name('IGF','IGF_AW_PROC_STUD');
254: fnd_message.set_token('STDNT',igf_gr_gen.get_per_num(ln_base_id));
255: fnd_file.put_line(fnd_file.log,fnd_message.get);
256:
257: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
258: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_aw_lock_assgn_pkg.main.debug','Starting Run_Type=P with base_id:'||ln_base_id);
259: END IF;

Line 276: fnd_message.set_name('IGF','IGF_AP_NO_BASEREC');

272: OPEN c_person_no(per_grp_rec.person_id);
273: FETCH c_person_no INTO l_person_no;
274: CLOSE c_person_no;
275:
276: fnd_message.set_name('IGF','IGF_AP_NO_BASEREC');
277: fnd_message.set_token('STUD',l_person_no.party_number);
278: fnd_file.new_line(fnd_file.log,1);
279: fnd_file.put_line(fnd_file.log,fnd_message.get);
280: END IF;

Line 277: fnd_message.set_token('STUD',l_person_no.party_number);

273: FETCH c_person_no INTO l_person_no;
274: CLOSE c_person_no;
275:
276: fnd_message.set_name('IGF','IGF_AP_NO_BASEREC');
277: fnd_message.set_token('STUD',l_person_no.party_number);
278: fnd_file.new_line(fnd_file.log,1);
279: fnd_file.put_line(fnd_file.log,fnd_message.get);
280: END IF;
281:

Line 279: fnd_file.put_line(fnd_file.log,fnd_message.get);

275:
276: fnd_message.set_name('IGF','IGF_AP_NO_BASEREC');
277: fnd_message.set_token('STUD',l_person_no.party_number);
278: fnd_file.new_line(fnd_file.log,1);
279: fnd_file.put_line(fnd_file.log,fnd_message.get);
280: END IF;
281:
282: FETCH cur_per_grp INTO per_grp_rec;
283: EXIT WHEN cur_per_grp%NOTFOUND;

Line 300: fnd_message.set_name('IGF','IGF_AW_PARAM_ERR');

296:
297: EXCEPTION
298: WHEN param_exception THEN
299: retcode:=2;
300: fnd_message.set_name('IGF','IGF_AW_PARAM_ERR');
301: igs_ge_msg_stack.add;
302: errbuf := fnd_message.get;
303:
304: WHEN app_exception.record_lock_exception THEN

Line 302: errbuf := fnd_message.get;

298: WHEN param_exception THEN
299: retcode:=2;
300: fnd_message.set_name('IGF','IGF_AW_PARAM_ERR');
301: igs_ge_msg_stack.add;
302: errbuf := fnd_message.get;
303:
304: WHEN app_exception.record_lock_exception THEN
305: ROLLBACK;
306: retcode:=2;

Line 307: fnd_message.set_name('IGF','IGF_GE_LOCK_ERROR');

303:
304: WHEN app_exception.record_lock_exception THEN
305: ROLLBACK;
306: retcode:=2;
307: fnd_message.set_name('IGF','IGF_GE_LOCK_ERROR');
308: igs_ge_msg_stack.add;
309: errbuf := fnd_message.get;
310:
311: WHEN OTHERS THEN

Line 309: errbuf := fnd_message.get;

305: ROLLBACK;
306: retcode:=2;
307: fnd_message.set_name('IGF','IGF_GE_LOCK_ERROR');
308: igs_ge_msg_stack.add;
309: errbuf := fnd_message.get;
310:
311: WHEN OTHERS THEN
312: ROLLBACK;
313: retcode:=2;

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

310:
311: WHEN OTHERS THEN
312: ROLLBACK;
313: retcode:=2;
314: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXCEPTION');
315: igs_ge_msg_stack.add;
316: errbuf := fnd_message.get || SQLERRM;
317: END main;
318:

Line 316: errbuf := fnd_message.get || SQLERRM;

312: ROLLBACK;
313: retcode:=2;
314: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXCEPTION');
315: igs_ge_msg_stack.add;
316: errbuf := fnd_message.get || SQLERRM;
317: END main;
318:
319: END igf_aw_lock_assgn_pkg;