APPS.IGS_AD_IMP_013 dependencies on IGS_AD_GEN_016

Line 1268: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;

1264: l_msg_at_index NUMBER := 0;
1265: l_return_status VARCHAR2(1);
1266: l_msg_count NUMBER ;
1267: l_msg_data VARCHAR2(2000);
1268: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
1269: l_error_text VARCHAR2(2000);
1270: l_education_id NUMBER;
1271: l_status VARCHAR2(10);
1272: l_object_version_number hz_education.object_version_number%TYPE := NULL;

Line 1346: igs_ad_gen_016.extract_msg_from_stack (

1342: x_mode => 'R');
1343: EXCEPTION
1344: WHEN OTHERS THEN
1345: ROLLBACK TO before_create_hist;
1346: igs_ad_gen_016.extract_msg_from_stack (
1347: p_msg_at_index => l_msg_at_index,
1348: p_return_status => l_return_status,
1349: p_msg_count => l_msg_count,
1350: p_msg_data => l_msg_data,

Line 1420: error_Text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405),

1416: END IF;
1417: ELSE -- validation fails
1418: UPDATE IGS_AD_ACADHIS_INT_ALL
1419: SET error_code = l_error_code,
1420: error_Text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405),
1421: status = l_status,
1422: match_ind = DECODE (
1423: person_history_rec.match_ind,
1424: NULL, cst_mi_val_11,

Line 1442: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;

1438: l_msg_at_index NUMBER := 0;
1439: l_return_status VARCHAR2(1);
1440: l_msg_count NUMBER ;
1441: l_msg_data VARCHAR2(2000);
1442: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
1443: l_error_text VARCHAR2(2000);
1444: l_education_id NUMBER;
1445: l_status VARCHAR2(10);
1446: l_object_version_number hz_education.object_version_number%TYPE;

Line 1517: igs_ad_gen_016.extract_msg_from_stack (

1513: x_mode => 'R');
1514: EXCEPTION
1515: WHEN OTHERS THEN
1516: ROLLBACK TO before_update_hist;
1517: igs_ad_gen_016.extract_msg_from_stack (
1518: p_msg_at_index => l_msg_at_index,
1519: p_return_status => l_return_status,
1520: p_msg_count => l_msg_count,
1521: p_msg_data => l_msg_data,

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

1527: IF p_enable_log = 'Y' THEN
1528: igs_ad_imp_001.logerrormessage(person_history_rec.interface_acadhis_id,l_msg_data,'IGS_AD_ACAD_HIS_INT');
1529: END IF;
1530: ELSE
1531: l_error_text := igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E518', 8405);
1532: l_error_Code := 'E518';
1533: IF fnd_log.test(fnd_log.level_exception,l_prog_label) THEN
1534:
1535: l_label := 'igs.plsql.igs_ad_imp_028.crc_pe_acad_hist.exception '||l_msg_data;

Line 1597: error_Text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405),

1593: ELSE
1594: UPDATE IGS_AD_ACADHIS_INT_ALL
1595: SET status = cst_s_val_3,
1596: error_code = l_error_code,
1597: error_Text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', l_error_code, 8405),
1598: match_ind = DECODE (
1599: person_history_rec.match_ind,
1600: NULL, cst_mi_val_12,
1601: match_ind),

Line 1622: error_Text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E711', 8405)

1618: --If given invalid update education ID then error out.
1619: UPDATE IGS_AD_ACADHIS_INT_ALL acad
1620: SET
1621: status = '3', error_code = 'E711',
1622: error_Text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E711', 8405)
1623: WHERE update_education_id IS NOT NULL
1624: AND NOT EXISTS ( SELECT 1 FROM HZ_EDUCATION
1625: WHERE party_id = acad.person_id
1626: AND education_id = NVL(acad.update_education_id ,education_id)

Line 1635: ,error_Text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E700', 8405)

1631: UPDATE IGS_AD_ACADHIS_INT_ALL
1632: SET
1633: status = '3'
1634: , error_code = 'E700'
1635: ,error_Text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E700', 8405)
1636: WHERE interface_run_id = p_interface_run_id
1637: AND status = '2'
1638: AND NVL (match_ind, '15') <> '15';
1639: END IF;

Line 1722: ,error_Text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E708', 8405)

1718: SET
1719: status = '3'
1720: , match_ind = '19'
1721: ,error_code = 'E708'
1722: ,error_Text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E708', 8405)
1723: WHERE interface_run_id = p_interface_run_id
1724: AND status = '2'
1725: AND 1 < (SELECT count(*) FROM hz_Education h1, hz_parties h2
1726: WHERE h1.party_id = a.person_id

Line 2038: ,error_Text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E700', 8405)

2034: UPDATE IGS_AD_ACADHIS_INT_ALL acad
2035: SET
2036: status = '3'
2037: , error_code = 'E700'
2038: ,error_Text = igs_ad_gen_016.get_lkup_meaning ('IMPORT_ERROR_CODE', 'E700', 8405)
2039: WHERE interface_run_id = p_interface_run_id
2040: AND status = '2'
2041: AND match_ind IS NOT NULL;
2042: END IF;

Line 2124: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;

2120: l_msg_at_index NUMBER := 0;
2121: l_return_status VARCHAR2(1);
2122: l_msg_count NUMBER ;
2123: l_msg_data VARCHAR2(2000);
2124: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
2125:
2126:
2127: /*************************************************
2128: Local Procedures

Line 2289: igs_ad_gen_016.extract_msg_from_stack (

2285: l_status := '3';
2286: l_error_code := 'E014';
2287:
2288: l_msg_at_index := igs_ge_msg_stack.count_msg;
2289: igs_ad_gen_016.extract_msg_from_stack (
2290: p_msg_at_index => l_msg_at_index,
2291: p_return_status => l_return_status,
2292: p_msg_count => l_msg_count,
2293: p_msg_data => l_msg_data,

Line 2426: igs_ad_gen_016.extract_msg_from_stack (

2422: WHEN OTHERS THEN
2423: l_status := '3';
2424: l_error_code := 'E322';
2425: l_msg_at_index := igs_ge_msg_stack.count_msg;
2426: igs_ad_gen_016.extract_msg_from_stack (
2427: p_msg_at_index => l_msg_at_index,
2428: p_return_status => l_return_status,
2429: p_msg_count => l_msg_count,
2430: p_msg_data => l_msg_data,