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');
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
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');
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.');
112: END IF;
113:
114: IGF_AP_PROFILE_MATCHING_PKG.ss_wrap_create_base_record(p_css_id,p_person_id,p_batch_year);
115: -- Fa Base Record got created successfully. Store success message.
116: fnd_message.set_name('IGF', 'IGF_AP_SUCCESS_FA_BASE');
117: x_msg_data := x_msg_data || ' ' || fnd_message.get;
118: x_return_status := 'S';
119:
120: EXCEPTION WHEN OTHERS THEN
113:
114: IGF_AP_PROFILE_MATCHING_PKG.ss_wrap_create_base_record(p_css_id,p_person_id,p_batch_year);
115: -- Fa Base Record got created successfully. Store success message.
116: fnd_message.set_name('IGF', 'IGF_AP_SUCCESS_FA_BASE');
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
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');
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;
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:
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:
131: fnd_message.set_name('IGF','IGF_AP_FAIL_FA_BASE');
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:
131: fnd_message.set_name('IGF','IGF_AP_FAIL_FA_BASE');
132: x_msg_data := fnd_message.get;
133: x_return_status := FND_API.G_RET_STS_ERROR;
134:
135: END create_base_record;
128: igs_ge_msg_stack.add;
129: x_return_status := FND_API.G_RET_STS_ERROR;
130:
131: fnd_message.set_name('IGF','IGF_AP_FAIL_FA_BASE');
132: x_msg_data := fnd_message.get;
133: x_return_status := FND_API.G_RET_STS_ERROR;
134:
135: END create_base_record;
136:
168:
169: SAVEPOINT SP_CREATE_PERSON;
170:
171: IGF_AP_PROFILE_MATCHING_PKG.ss_wrap_create_person_record (p_css_id);
172: fnd_message.set_name('IGF', 'IGF_AP_SUCCESS_CREATE_PERSON');
173: x_msg_data := x_msg_data || ' ' ||fnd_message.get;
174: x_return_status := 'S';
175:
176:
169: SAVEPOINT SP_CREATE_PERSON;
170:
171: IGF_AP_PROFILE_MATCHING_PKG.ss_wrap_create_person_record (p_css_id);
172: fnd_message.set_name('IGF', 'IGF_AP_SUCCESS_CREATE_PERSON');
173: x_msg_data := x_msg_data || ' ' ||fnd_message.get;
174: x_return_status := 'S';
175:
176:
177: EXCEPTION
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');
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;
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:
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:
189: END create_person_record;
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);
247: igs_ge_msg_stack.add;
248: END 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:
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:
250: PROCEDURE delete_interface_record ( p_css_id IN NUMBER,
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);
302: igs_ge_msg_stack.add;
303: x_return_status := 'E';
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;
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;
305:
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);
354: igs_ge_msg_stack.add;
355: END 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:
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:
357: PROCEDURE ss_upload_profile ( p_css_id IN NUMBER,
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);
392: igs_ge_msg_stack.add;
393: x_return_status := 'E';
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;
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;
395: