DBA Data[Home] [Help]

APPS.IGF_AP_PROFILE_MATCHING_PKG dependencies on IGS_GE_MSG_STACK

Line 164: igs_ge_msg_stack.add;

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

Line 224: igs_ge_msg_stack.add;

220: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_matching_process_pkg.create_email_address.exception','The exception is : ' || SQLERRM );
221: END IF;
222: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
223: fnd_message.set_token('NAME','IGF_AP_PROFILE_MATCHING_PKG.create_email_address');
224: igs_ge_msg_stack.add;
225: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
226: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.create_email_address' || SQLERRM);
227: END create_email_address;
228:

Line 590: igs_ge_msg_stack.add;

586: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.make_profile_inactive.exception','The exception is : ' || SQLERRM );
587: END IF;
588: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
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;

Line 854: igs_ge_msg_stack.add;

850: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.calculate_match_score.exception','The exception is : ' || SQLERRM );
851: END IF;
852: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
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;

Line 1112: IGS_GE_MSG_STACK.ADD;

1108: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.create_fa_base_record.exception','The exception is : ' || SQLERRM );
1109: END IF;
1110: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
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;

Line 1551: IGS_GE_MSG_STACK.ADD;

1547: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.create_fnar_data.exception','The exception is : ' || SQLERRM );
1548: END IF;
1549: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
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;

Line 1714: IGS_GE_MSG_STACK.ADD;

1710: pv_mesg_data := SQLERRM;
1711: END IF ;
1712: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
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:

Line 1813: IGS_GE_MSG_STACK.ADD;

1809: END IF;
1810: -- FND_FILE.PUT_LINE(FND_FILE.LOG ,lv_msg_data||fnd_global.newline ||'Status:'||lv_return_status);
1811: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1812: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.create_person_addr_record');
1813: IGS_GE_MSG_STACK.ADD;
1814: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
1815: log_debug_message('IGF_AP_PROFILE_MATCHING_PKG.create_person_addr_record'|| SQLERRM);
1816: END create_person_addr_record;
1817:

Line 1948: igs_ge_msg_stack.add;

1944: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.process_todo_items.exception','The exception is : ' || SQLERRM );
1945: END IF;
1946:
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;

Line 1950: igs_ge_msg_stack.add;

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

Line 2328: IGS_GE_MSG_STACK.ADD;

2324: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.create_profile_matched.exception','The exception is : ' || SQLERRM );
2325: END IF;
2326: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
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;

Line 2378: IGS_GE_MSG_STACK.ADD;

2374: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.is_fa_base_record_present.exception','The exception is : ' || SQLERRM );
2375: END IF;
2376: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
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;

Line 3138: IGS_GE_MSG_STACK.ADD;

3134: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.update_css_interface.exception','The exception is : ' || SQLERRM );
3135: END IF;
3136: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
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;

Line 3342: igs_ge_msg_stack.add;

3338: CLOSE cur_person_type;
3339: END IF;
3340: FND_MESSAGE.SET_NAME('IGF','IGF_GE_UNHANDLED_EXP');
3341: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_MATCH_PROFILE_PK.create_admission_rec');
3342: igs_ge_msg_stack.add;
3343: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| SQLERRM);
3344: log_debug_message('IGF_AP_MATCH_PROFILE_PK.create_admission_rec'|| SQLERRM);
3345: END create_admission_rec;
3346:

Line 3399: IGS_GE_MSG_STACK.ADD;

3395: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.update_person_match.exception','The exception is : ' || SQLERRM );
3396: END IF;
3397: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
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;

Line 3559: IGS_GE_MSG_STACK.ADD;

3555: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.update_fa_base_rec.exception','The exception is : ' || SQLERRM );
3556: END IF;
3557: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
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 ;

Line 3728: IGS_GE_MSG_STACK.ADD;

3724: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.unmatched_rec.exception','The exception is : ' || SQLERRM );
3725: END IF;
3726: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
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 ;

Line 3790: IGS_GE_MSG_STACK.ADD;

3786: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.rvw_fa_rec.exception','The exception is : ' || SQLERRM );
3787: END IF;
3788: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
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 ;

Line 3910: IGS_GE_MSG_STACK.ADD;

3906: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.auto_fa_rec.exception','The exception is : ' || SQLERRM );
3907: END IF;
3908: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
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 ;

Line 4163: igs_ge_msg_stack.add;

4159: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.perform_record_matching.exception','The exception is : ' || SQLERRM );
4160: END IF;
4161: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
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 ;

Line 4246: igs_ge_msg_stack.add;

4242: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.process_unidentified_isir_rec.exception','The exception is : ' || SQLERRM );
4243: END IF;
4244: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
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;

Line 4379: IGS_GE_MSG_STACK.ADD;

4375: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.process_old_new_dup_records.exception','The exception is : ' || SQLERRM );
4376: END IF;
4377: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
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 ;

Line 4522: igs_ge_msg_stack.add;

4518: IF cur_school_cd%NOTFOUND THEN
4519: CLOSE cur_school_cd;
4520: fnd_message.set_name('IGF','IGF_AP_INVALID_PARAMETER');
4521: fnd_message.set_token('PARAM_TYPE', 'SCHOOL CODE');
4522: igs_ge_msg_stack.add;
4523: RAISE INVALID_PARAMETER;
4524: END IF ;
4525: CLOSE cur_school_cd;
4526: END IF;

Line 4546: IGS_GE_MSG_STACK.ADD;

4542: FETCH cur_batch_aw_map INTO g_ci_cal_type,g_ci_sequence_number ;
4543: IF cur_batch_aw_map%NOTFOUND THEN
4544: CLOSE cur_batch_aw_map ;
4545: FND_MESSAGE.SET_NAME('IGF','IGF_AP_BATCH_YEAR_NOT_FOUND');
4546: IGS_GE_MSG_STACK.ADD;
4547: RAISE INVALID_PARAMETER;
4548: END IF ;
4549:
4550: -- Copying the parameter values to the gobal variable.

Line 4741: IGS_GE_MSG_STACK.ADD;

4737: END IF;
4738:
4739: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
4740: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_PROFILE_MATCHING_PKG.main');
4741: IGS_GE_MSG_STACK.ADD;
4742: retcode := 2;
4743: errbuf:= FND_MESSAGE.GET;
4744: rollback;
4745: FND_FILE.PUT_LINE(fnd_file.log,errbuf);

Line 4746: igs_ge_msg_stack.conc_exception_hndl;

4742: retcode := 2;
4743: errbuf:= FND_MESSAGE.GET;
4744: rollback;
4745: FND_FILE.PUT_LINE(fnd_file.log,errbuf);
4746: igs_ge_msg_stack.conc_exception_hndl;
4747:
4748: END main;
4749:
4750: PROCEDURE ss_wrap_create_person_record (p_css_id IN NUMBER)

Line 4893: IGS_GE_MSG_STACK.ADD;

4889: fnd_log.string(fnd_log.level_exception,'igf.plsql.igf_ap_profile_matching_pkg.ss_wrap_refresh_matches.exception','The exception is : ' || SQLERRM );
4890: END IF;
4891: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
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;

Line 5119: igs_ge_msg_stack.add;

5115: END IF;
5116: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');
5117: fnd_message.set_token('NAME','igf_ap_profile_gen_pkg.ss_upload_profile');
5118: fnd_file.put_line(fnd_file.log,fnd_message.get);
5119: igs_ge_msg_stack.add;
5120: x_return_status := 'E';
5121: END ss_wrap_upload_Profile;
5122:
5123: