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_MATCHING_PKG dependencies on APP_EXCEPTION

Line 165: app_exception.raise_exception;

161: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
162: fnd_message.set_token('NAME','IGF_AP_PROFILE_MATCHING_PKG.update_person_info');
163: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
164: igs_ge_msg_stack.add;
165: app_exception.raise_exception;
166: END update_person_info;
167:
168: PROCEDURE create_email_address (p_person_id igf_ap_fa_base_rec.person_id%TYPE)
169: IS

Line 593: app_exception.raise_exception;

589: fnd_message.set_token('NAME','IGF_AP_PROFILE_MATCHING_PKG.calculate_match_score' );
590: igs_ge_msg_stack.add;
591: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
592: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.calculate_match_score' || SQLERRM);
593: app_exception.raise_exception;
594: END make_profile_inactive;
595:
596: FUNCTION remove_spl_chr(pv_ssn igf_ap_isir_ints_all.current_ssn_txt%TYPE)
597: RETURN VARCHAR2

Line 857: app_exception.raise_exception;

853: fnd_message.set_token('NAME','IGF_AP_PROFILE_MATCHING_PKG.calculate_match_score' );
854: igs_ge_msg_stack.add;
855: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
856: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.calculate_match_score 1' || SQLERRM);
857: app_exception.raise_exception;
858: END calculate_match_score;
859:
860: PROCEDURE create_ssn(cp_person_id igs_pe_alt_pers_id.pe_person_id%TYPE,
861: cp_original_ssn_txt VARCHAR2

Line 1115: app_exception.raise_exception;

1111: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_MATCHING_PROCESS_PKG.CREATE_FA_BASE_REC:');
1112: IGS_GE_MSG_STACK.ADD;
1113: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
1114: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.CREATE_FA_BASE_REC' || SQLERRM);
1115: app_exception.raise_exception;
1116: END create_fa_base_record;
1117:
1118:
1119: PROCEDURE create_fnar_data(pn_css_id igf_ap_css_interface_all.css_id%TYPE,

Line 1554: app_exception.raise_exception;

1550: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.create_fnar_data');
1551: IGS_GE_MSG_STACK.ADD;
1552: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
1553: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.create_fnar_data'||SQLERRM);
1554: app_exception.raise_exception;
1555: END create_fnar_data;
1556:
1557:
1558: PROCEDURE create_person_record(

Line 1608: app_exception.raise_exception;

1604: RETURN;
1605: ELSE
1606: fnd_file.put_line (FND_FILE.LOG, fnd_message.get);
1607: log_debug_message(fnd_message.get);
1608: app_exception.raise_exception;
1609: END IF;
1610: END IF;
1611:
1612: -- Create a new person by getting the details from css_interface table.

Line 1717: app_exception.raise_exception;

1713: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.create_person_record');
1714: IGS_GE_MSG_STACK.ADD;
1715: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
1716: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.create_person_record'||SQLERRM);
1717: app_exception.raise_exception;
1718:
1719: END create_person_record;
1720:
1721:

Line 1951: app_exception.raise_exception;

1947: fnd_message.set_name('IGS' , 'IGS_GE_UNHANDLED_EXCEPTION');
1948: igs_ge_msg_stack.add;
1949: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
1950: igs_ge_msg_stack.add;
1951: app_exception.raise_exception;
1952: END process_todo_items;
1953:
1954:
1955: PROCEDURE create_profile_matched(pn_css_id igf_ap_css_interface_all.css_id%TYPE,

Line 2331: app_exception.raise_exception;

2327: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.create_profile_matched:');
2328: IGS_GE_MSG_STACK.ADD;
2329: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
2330: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.create_profile_matched:'||SQLERRM);
2331: app_exception.raise_exception;
2332: END create_profile_matched;
2333:
2334:
2335: FUNCTION is_fa_base_record_present(pn_person_id igf_ap_match_details.person_id%TYPE,

Line 2381: app_exception.raise_exception;

2377: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.is_fa_base_record_present:');
2378: IGS_GE_MSG_STACK.ADD;
2379: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
2380: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.is_fa_base_record_present:'||SQLERRM);
2381: app_exception.raise_exception;
2382: END is_fa_base_record_present;
2383:
2384: PROCEDURE update_css_interface(pn_css_id igf_ap_css_interface_all.css_id%TYPE,
2385: pv_record_status igf_ap_css_interface_all.record_status%TYPE,

Line 3141: app_exception.raise_exception;

3137: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.update_css_interface:');
3138: IGS_GE_MSG_STACK.ADD;
3139: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
3140: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.update_css_interface:'||SQLERRM);
3141: app_exception.raise_exception;
3142: END update_css_interface;
3143:
3144: PROCEDURE create_admission_rec(
3145: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE,

Line 3402: app_exception.raise_exception;

3398: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.update_person_match:');
3399: IGS_GE_MSG_STACK.ADD;
3400: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
3401: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.update_person_match:'|| SQLERRM);
3402: app_exception.raise_exception;
3403: END update_person_match;
3404:
3405:
3406: PROCEDURE update_fa_base_rec(p_base_id igf_ap_fa_base_rec.base_id%TYPE) IS

Line 3562: app_exception.raise_exception;

3558: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.UPDATE_FA_BASE_REC:');
3559: IGS_GE_MSG_STACK.ADD;
3560: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
3561: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.UPDATE_FA_BASE_REC:'||SQLERRM );
3562: app_exception.raise_exception;
3563: END update_fa_base_rec ;
3564:
3565: PROCEDURE unmatched_rec(p_apm_id igf_ap_person_match_all.apm_id%TYPE) IS
3566: /*

Line 3731: app_exception.raise_exception;

3727: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.unmatched_rec');
3728: IGS_GE_MSG_STACK.ADD;
3729: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
3730: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.unmatched_rec'|| SQLERRM);
3731: app_exception.raise_exception;
3732: END unmatched_rec ;
3733:
3734: PROCEDURE rvw_fa_rec(p_apm_id igf_ap_person_match_all.apm_id%TYPE ) IS
3735: /*

Line 3793: app_exception.raise_exception;

3789: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.rvw_fa_rec');
3790: IGS_GE_MSG_STACK.ADD;
3791: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
3792: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.rvw_fa_rec'|| SQLERRM);
3793: app_exception.raise_exception;
3794: END rvw_fa_rec ;
3795:
3796: PROCEDURE auto_fa_rec(p_person_id igf_ap_match_details.person_id%TYPE ,
3797: p_apm_id igf_ap_person_match_all.apm_id%TYPE,

Line 3913: app_exception.raise_exception;

3909: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.auto_fa_rec');
3910: IGS_GE_MSG_STACK.ADD;
3911: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
3912: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.auto_fa_rec'|| SQLERRM);
3913: app_exception.raise_exception;
3914: END auto_fa_rec ;
3915:
3916: PROCEDURE perform_record_matching(p_out_apm_id OUT NOCOPY igf_ap_person_match_all.apm_id%TYPE)
3917: IS

Line 4166: app_exception.raise_exception;

4162: fnd_message.set_token('NAME','igf_ap_profile_matching_pkg.perform_record_matching');
4163: igs_ge_msg_stack.add;
4164: fnd_file.put_line(fnd_file.log, ' - '|| SQLERRM);
4165: log_debug_message('igf_ap_profile_matching_pkg.perform_record_matching'|| SQLERRM);
4166: app_exception.raise_exception;
4167: END perform_record_matching ;
4168:
4169: PROCEDURE process_unidentified_isir_rec IS
4170: /*

Line 4249: app_exception.raise_exception;

4245: fnd_message.set_token('NAME','igf_ap_profile_matching_pkg.process_unidentified_isir_rec');
4246: igs_ge_msg_stack.add;
4247: FND_FILE.PUT_LINE(fnd_file.log,fnd_message.get||' '||SQLERRM);
4248: log_debug_message('igf_ap_profile_matching_pkg.process_unidentified_isir_rec'|| SQLERRM);
4249: app_exception.raise_exception;
4250: END process_unidentified_isir_rec;
4251:
4252: PROCEDURE process_old_new_dup_records IS
4253:

Line 4382: app_exception.raise_exception;

4378: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.process_old_new_dup_records');
4379: IGS_GE_MSG_STACK.ADD;
4380: FND_FILE.PUT_LINE(fnd_file.log,fnd_message.get||' '||SQLERRM);
4381: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.process_old_new_dup_records'|| SQLERRM);
4382: app_exception.raise_exception;
4383: END process_old_new_dup_records ;
4384:
4385: PROCEDURE main(
4386: errbuf OUT NOCOPY VARCHAR2,

Line 4820: app_exception.raise_exception;

4816: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
4817: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.unmatched_rec.exception','The exception is : ' || SQLERRM );
4818: END IF;
4819: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.unmatched_rec'|| SQLERRM);
4820: app_exception.raise_exception;
4821: END ss_wrap_create_person_record;
4822:
4823:
4824: PROCEDURE ss_wrap_refresh_matches(

Line 4896: -- app_exception.raise_exception;

4892: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.ss_wrap_refresh_matches');
4893: IGS_GE_MSG_STACK.ADD;
4894: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
4895: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.ss_wrap_refresh_matches'||SQLERRM);
4896: -- app_exception.raise_exception;
4897: END ss_wrap_refresh_matches;
4898:
4899: PROCEDURE ss_wrap_create_base_record ( p_css_id IN NUMBER,
4900: p_person_id IN NUMBER,

Line 4994: app_exception.raise_exception;

4990: IF fnd_log.level_exception >= fnd_log.g_current_runtime_level THEN
4991: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.ss_wrap_create_base_record.exception','The exception is : ' || SQLERRM );
4992: END IF;
4993: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.ss_wrap_create_base_record'|| SQLERRM);
4994: app_exception.raise_exception;
4995: END ss_wrap_create_base_record;
4996:
4997: PROCEDURE ss_wrap_upload_Profile ( p_css_id IN NUMBER,
4998: x_msg_data OUT NOCOPY VARCHAR2,