APPS.IGS_AD_IMP_014 dependencies on IGS_AD_GEN_016

Line 44: cst_et_val_E700 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E700', 8405);

40: cst_insert CONSTANT VARCHAR2(6) := 'INSERT';
41: cst_update CONSTANT VARCHAR2(6) := 'UPDATE';
42: cst_unique_record CONSTANT NUMBER := 1;
43:
44: cst_et_val_E700 VARCHAR2(100) := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E700', 8405);
45:
46: cst_ec_val_E700 VARCHAR2(4) := 'E700';
47:
48: /***************************Status,Discrepancy Rule, Match Indicators, Error Codes********************/

Line 124: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;

120: l_msg_at_index NUMBER := 0;
121: l_return_status VARCHAR2(1);
122: l_msg_count NUMBER ;
123: l_msg_data VARCHAR2(2000);
124: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
125:
126: l_records_processed NUMBER;
127: l_recruitments_ID igs_ad_recruitments.recruitment_id%TYPE;
128: l_rowid VARCHAR2(30);

Line 243: igs_ad_gen_016.extract_msg_from_stack (

239: ELSIF recruit_rec.dmlmode = cst_update THEN
240: l_error_code := 'E014'; -- Could not update Person Recruitment
241: END IF;
242:
243: igs_ad_gen_016.extract_msg_from_stack (
244: p_msg_at_index => l_msg_at_index,
245: p_return_status => l_return_status,
246: p_msg_count => l_msg_count,
247: p_msg_data => l_msg_data,

Line 250: l_error_text := NVL(l_msg_data,igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405));

246: p_msg_count => l_msg_count,
247: p_msg_data => l_msg_data,
248: p_hash_msg_name_text_type_tab => l_hash_msg_name_text_type_tab);
249:
250: l_error_text := NVL(l_msg_data,igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405));
251:
252: IF l_hash_msg_name_text_type_tab(l_msg_count-1).name <> 'ORA' THEN
253: IF p_enable_log = 'Y' THEN
254: igs_ad_imp_001.logerrormessage(recruit_rec.interface_recruitment_id,l_msg_data,'IGS_AD_RECRUIT_INT');