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 FND_LOG

Line 91: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

87: SAVEPOINT SP_PROFILE;
88: x_msg_data := '';
89:
90: fnd_profile.get('IGF_AP_SSN_REQ_FOR_BASE_REC',lv_profile_value);
91: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
92: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.wrpr_auto_fa_rec.debug','lv_profile_value:'||NVL(lv_profile_value,'N'));
93: END IF;
94: IF NVL(lv_profile_value,'N') = 'Y' THEN
95: OPEN c_ssn(p_person_id);

Line 92: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.wrpr_auto_fa_rec.debug','lv_profile_value:'||NVL(lv_profile_value,'N'));

88: x_msg_data := '';
89:
90: fnd_profile.get('IGF_AP_SSN_REQ_FOR_BASE_REC',lv_profile_value);
91: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
92: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.wrpr_auto_fa_rec.debug','lv_profile_value:'||NVL(lv_profile_value,'N'));
93: END IF;
94: IF NVL(lv_profile_value,'N') = 'Y' THEN
95: OPEN c_ssn(p_person_id);
96: FETCH c_ssn INTO l_ssn;

Line 98: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

94: IF NVL(lv_profile_value,'N') = 'Y' THEN
95: OPEN c_ssn(p_person_id);
96: FETCH c_ssn INTO l_ssn;
97: IF c_ssn%NOTFOUND THEN
98: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
99: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.wrpr_auto_fa_rec.debug','c_ssn%NOTFOUND. raising error');
100: END IF;
101: CLOSE c_ssn;
102: x_return_status := fnd_api.g_ret_sts_error;

Line 99: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.wrpr_auto_fa_rec.debug','c_ssn%NOTFOUND. raising error');

95: OPEN c_ssn(p_person_id);
96: FETCH c_ssn INTO l_ssn;
97: IF c_ssn%NOTFOUND THEN
98: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
99: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.wrpr_auto_fa_rec.debug','c_ssn%NOTFOUND. raising error');
100: END IF;
101: CLOSE c_ssn;
102: x_return_status := fnd_api.g_ret_sts_error;
103: fnd_message.set_name('IGF','IGF_AP_SSN_FOR_BASEREC');

Line 107: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN

103: fnd_message.set_name('IGF','IGF_AP_SSN_FOR_BASEREC');
104: x_msg_data := x_msg_data || ' ' || fnd_message.get;
105: RETURN;
106: ELSE
107: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
108: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.wrpr_auto_fa_rec.debug','c_ssn%FOUND.');
109: END IF;
110: CLOSE c_ssn;
111: END IF;

Line 108: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.wrpr_auto_fa_rec.debug','c_ssn%FOUND.');

104: x_msg_data := x_msg_data || ' ' || fnd_message.get;
105: RETURN;
106: ELSE
107: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
108: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_ap_matching_process_pkg.wrpr_auto_fa_rec.debug','c_ssn%FOUND.');
109: END IF;
110: CLOSE c_ssn;
111: END IF;
112: END IF;

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

117: x_msg_data := x_msg_data || ' ' || fnd_message.get;
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');

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

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

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

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

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

292: x_return_status := 'S';
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');

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

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

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

382: x_msg_data => x_msg_data,
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');

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