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_PROFILE_GEN_PKG dependencies on IGF_AP_PROFILE_GEN_PKG

Line 1: PACKAGE BODY igf_ap_profile_gen_pkg AS

1: PACKAGE BODY igf_ap_profile_gen_pkg AS
2: /* $Header: IGFAP48B.pls 120.4 2006/02/14 23:05:30 ridas noship $ */
3: ------------------------------------------------------------------
4: --Created by : ugummall, Oracle India
5: --Date created: 04-AUG-2004

Line 122: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_gen_pkg.create_base_record.exception','The exception is : ' || SQLERRM );

118: x_return_status := 'S';
119:
120: EXCEPTION WHEN OTHERS THEN
121: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
122: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_gen_pkg.create_base_record.exception','The exception is : ' || SQLERRM );
123: END IF;
124: ROLLBACK TO SP_PROFILE;
125: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
126: fnd_message.set_token('NAME','igf_ap_profile_gen_pkg.create_base_record');

Line 126: fnd_message.set_token('NAME','igf_ap_profile_gen_pkg.create_base_record');

122: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_gen_pkg.create_base_record.exception','The exception is : ' || SQLERRM );
123: END IF;
124: ROLLBACK TO SP_PROFILE;
125: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
126: fnd_message.set_token('NAME','igf_ap_profile_gen_pkg.create_base_record');
127: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
128: igs_ge_msg_stack.add;
129: x_return_status := FND_API.G_RET_STS_ERROR;
130:

Line 180: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_gen_pkg.create_person_record.exception','The exception is : ' || SQLERRM );

176:
177: EXCEPTION
178: WHEN OTHERS THEN
179: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
180: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_gen_pkg.create_person_record.exception','The exception is : ' || SQLERRM );
181: END IF;
182: ROLLBACK TO SP_CREATE_PERSON;
183: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
184: fnd_message.set_token('NAME','igf_ap_profile_gen_pkg.create_person_record');

Line 184: fnd_message.set_token('NAME','igf_ap_profile_gen_pkg.create_person_record');

180: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_gen_pkg.create_person_record.exception','The exception is : ' || SQLERRM );
181: END IF;
182: ROLLBACK TO SP_CREATE_PERSON;
183: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
184: fnd_message.set_token('NAME','igf_ap_profile_gen_pkg.create_person_record');
185: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
186: igs_ge_msg_stack.add;
187: x_return_status := FND_API.G_RET_STS_ERROR;
188:

Line 242: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_gen_pkg.delete_person_match.exception','The exception is : ' || SQLERRM );

238:
239: EXCEPTION
240: WHEN OTHERS THEN
241: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
242: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_gen_pkg.delete_person_match.exception','The exception is : ' || SQLERRM );
243: END IF;
244: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
245: fnd_message.set_token('NAME','igf_ap_profile_gen_pkg.delete_person_match');
246: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 245: fnd_message.set_token('NAME','igf_ap_profile_gen_pkg.delete_person_match');

241: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
242: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_gen_pkg.delete_person_match.exception','The exception is : ' || SQLERRM );
243: END IF;
244: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
245: fnd_message.set_token('NAME','igf_ap_profile_gen_pkg.delete_person_match');
246: fnd_file.put_line(fnd_file.log,fnd_message.get);
247: igs_ge_msg_stack.add;
248: END delete_person_match;
249:

Line 297: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_gen_pkg.delete_interface_record.exception','The exception is : ' || SQLERRM );

293:
294: EXCEPTION
295: WHEN OTHERS THEN
296: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
297: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_gen_pkg.delete_interface_record.exception','The exception is : ' || SQLERRM );
298: END IF;
299: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
300: fnd_message.set_token('NAME','igf_ap_profile_gen_pkg.delete_interface_record');
301: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 300: fnd_message.set_token('NAME','igf_ap_profile_gen_pkg.delete_interface_record');

296: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
297: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_gen_pkg.delete_interface_record.exception','The exception is : ' || SQLERRM );
298: END IF;
299: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
300: fnd_message.set_token('NAME','igf_ap_profile_gen_pkg.delete_interface_record');
301: fnd_file.put_line(fnd_file.log,fnd_message.get);
302: igs_ge_msg_stack.add;
303: x_return_status := 'E';
304: END delete_interface_record;

Line 349: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_gen_pkg.delete_int_records.exception','The exception is : ' || SQLERRM );

345:
346: EXCEPTION
347: WHEN OTHERS THEN
348: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
349: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_gen_pkg.delete_int_records.exception','The exception is : ' || SQLERRM );
350: END IF;
351: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
352: fnd_message.set_token('NAME','igf_ap_profile_gen_pkg.delete_int_records');
353: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 352: fnd_message.set_token('NAME','igf_ap_profile_gen_pkg.delete_int_records');

348: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
349: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_gen_pkg.delete_int_records.exception','The exception is : ' || SQLERRM );
350: END IF;
351: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
352: fnd_message.set_token('NAME','igf_ap_profile_gen_pkg.delete_int_records');
353: fnd_file.put_line(fnd_file.log,fnd_message.get);
354: igs_ge_msg_stack.add;
355: END delete_int_records;
356:

Line 387: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_gen_pkg.ss_upload_profile.exception','The exception is : ' || SQLERRM );

383: x_return_status => x_return_status
384: );
385: EXCEPTION WHEN OTHERS THEN
386: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
387: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_gen_pkg.ss_upload_profile.exception','The exception is : ' || SQLERRM );
388: END IF;
389: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
390: fnd_message.set_token('NAME','igf_ap_profile_gen_pkg.ss_upload_profile');
391: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 390: fnd_message.set_token('NAME','igf_ap_profile_gen_pkg.ss_upload_profile');

386: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
387: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_gen_pkg.ss_upload_profile.exception','The exception is : ' || SQLERRM );
388: END IF;
389: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
390: fnd_message.set_token('NAME','igf_ap_profile_gen_pkg.ss_upload_profile');
391: fnd_file.put_line(fnd_file.log,fnd_message.get);
392: igs_ge_msg_stack.add;
393: x_return_status := 'E';
394: END ss_upload_profile;

Line 396: END igf_ap_profile_gen_pkg;

392: igs_ge_msg_stack.add;
393: x_return_status := 'E';
394: END ss_upload_profile;
395:
396: END igf_ap_profile_gen_pkg;