APPS.IGS_AD_IMP_028 dependencies on IGS_AD_GEN_016

Line 80: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;

76: l_msg_at_index NUMBER := 0;
77: l_return_status VARCHAR2(1);
78: l_msg_count NUMBER ;
79: l_msg_data VARCHAR2(2000);
80: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
81:
82: BEGIN
83: l_prog_label := 'igs.plsql.igs_ad_imp_028.prc_pe_qual_details';
84:

Line 98: ,error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E683', 8405)

94: -- Error out all the interface records, if the corrospending person already having qualification details
95: --- in ths OSS transaction table.
96: UPDATE IGS_UC_QUAL_INTS qints
97: SET error_code = 'E683'
98: ,error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E683', 8405)
99: , status ='3'
100: WHERE STATUS = '2'
101: AND interface_run_id = p_interface_run_id
102: AND EXISTS ( SELECT 1 FROM IGS_UC_QUAL_DETS

Line 109: ,error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E684', 8405)

105: COMMIT;
106: -- Check for duplicates among interface records. If exists error out all the such records.
107: UPDATE IGS_UC_QUAL_INTS qints
108: SET error_code = 'E684'
109: ,error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E684', 8405)
110: , status ='3'
111: WHERE STATUS = '2'
112: AND interface_run_id = p_interface_run_id
113: AND EXISTS (SELECT 1 FROM IGS_UC_QUAL_INTS qints2

Line 128: ,error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E684', 8405)

124: COMMIT;
125: -- Error out all interface records if the any interface record with same person_id is errored out.
126: UPDATE IGS_UC_QUAL_INTS qints
127: SET error_code = 'E684'
128: ,error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E684', 8405)
129: , status ='3'
130: WHERE STATUS = '2'
131: AND interface_run_id = p_interface_run_id
132: AND EXISTS (SELECT 1 FROM IGS_UC_QUAL_INTS qints2

Line 192: error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405)

188: l_person_id_errored := uc_qual_rec.person_id ;
189: UPDATE igs_uc_qual_ints
190: SET status = cst_s_val_3,
191: error_code = l_error_code,
192: error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405)
193: WHERE interface_qual_id = uc_qual_rec.interface_qual_id;
194:
195: IF p_enable_log = 'Y' THEN
196: igs_ad_imp_001.logerrormessage(uc_qual_rec.interface_qual_id,l_error_code,'IGS_UC_QUAL_INTS');

Line 202: , error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405)

198: l_error_code := 'E685';
199: UPDATE igs_uc_qual_ints
200: SET status = cst_s_val_3
201: , error_code = l_error_code
202: , error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405)
203: WHERE person_id = uc_qual_rec.person_id
204: AND status = cst_s_val_2
205: AND interface_qual_id <> uc_qual_rec.interface_qual_id;
206:

Line 210: igs_ad_gen_016.extract_msg_from_stack (

206:
207:
208: WHEN OTHERS THEN
209: ROLLBACK;
210: igs_ad_gen_016.extract_msg_from_stack (
211: p_msg_at_index => l_msg_at_index,
212: p_return_status => l_return_status,
213: p_msg_count => l_msg_count,
214: p_msg_data => l_msg_data,

Line 224: l_error_text := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E518', 8405);

220: IF p_enable_log = 'Y' THEN
221: igs_ad_imp_001.logerrormessage(uc_qual_rec.interface_qual_id,l_msg_data,'IGS_UC_QUAL_INTS');
222: END IF;
223: ELSE
224: l_error_text := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E518', 8405);
225: l_error_Code := 'E518';
226: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
227:
228: l_label := 'igs.plsql.igs_ad_imp_028.prc_uc_qual_dtls.exception '||l_msg_data;

Line 254: error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405)

250: l_error_code := 'E685';
251: UPDATE igs_uc_qual_ints
252: SET status = cst_s_val_3,
253: error_code = l_error_code,
254: error_text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405)
255: WHERE person_id = uc_qual_rec.person_id
256: AND status =cst_s_val_2
257: AND interface_qual_id <> uc_qual_rec.interface_qual_id;
258: