DBA Data[Home] [Help]

APPS.IGF_AP_PROFILE_GEN_PKG dependencies on FND_MESSAGE

Line 103: fnd_message.set_name('IGF','IGF_AP_SSN_FOR_BASEREC');

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

Line 104: x_msg_data := x_msg_data || ' ' || fnd_message.get;

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

Line 116: fnd_message.set_name('IGF', 'IGF_AP_SUCCESS_FA_BASE');

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

Line 117: x_msg_data := x_msg_data || ' ' || fnd_message.get;

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

Line 125: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

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;

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 127: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| 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:
131: fnd_message.set_name('IGF','IGF_AP_FAIL_FA_BASE');

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

Line 132: x_msg_data := fnd_message.get;

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:

Line 172: fnd_message.set_name('IGF', 'IGF_AP_SUCCESS_CREATE_PERSON');

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:

Line 173: x_msg_data := x_msg_data || ' ' ||fnd_message.get;

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

Line 183: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

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;

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 185: fnd_file.put_line(fnd_file.log,fnd_message.get || ' - '|| 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:
189: END create_person_record;

Line 244: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

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;

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 246: fnd_file.put_line(fnd_file.log,fnd_message.get);

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,

Line 299: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

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

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 301: fnd_file.put_line(fnd_file.log,fnd_message.get);

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:

Line 351: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

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;

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 353: fnd_file.put_line(fnd_file.log,fnd_message.get);

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,

Line 389: fnd_message.set_name('IGS','IGS_GE_UNHANDLED_EXP');

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

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 391: fnd_file.put_line(fnd_file.log,fnd_message.get);

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: