eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_IMP_012 dependencies on IGS_PE_PERS_IMP_001

Line 305: (igs_pe_pers_imp_001.validate_lookup_type_code('COMMUNICATION_TYPE',c_pc_rec.contact_point_type,222))

301: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
302: END IF;
303:
304: IF NOT
305: (igs_pe_pers_imp_001.validate_lookup_type_code('COMMUNICATION_TYPE',c_pc_rec.contact_point_type,222))
306: THEN
307: -- If the validation is not successful.
308:
309: IF l_enable_log = 'Y' THEN

Line 355: (igs_pe_pers_imp_001.validate_lookup_type_code('PHONE_LINE_TYPE',c_pc_rec.phone_line_type,222))

351: RETURN;
352: END IF;
353:
354: IF NOT
355: (igs_pe_pers_imp_001.validate_lookup_type_code('PHONE_LINE_TYPE',c_pc_rec.phone_line_type,222))
356: THEN
357: -- If the validation is not successful.
358:
359: IF l_enable_log = 'Y' THEN

Line 412: (igs_pe_pers_imp_001.validate_lookup_type_code('EMAIL_FORMAT',c_pc_rec.email_format,222))

408: RETURN;
409: END IF;
410:
411: IF NOT
412: (igs_pe_pers_imp_001.validate_lookup_type_code('EMAIL_FORMAT',c_pc_rec.email_format,222))
413: THEN
414:
415: IF l_enable_log = 'Y' THEN
416: igs_ad_imp_001.logerrormessage(c_pc_rec.interface_contacts_id,'E248');

Line 1004: IF p_person_language_rec.READS_LEVEL IS NOT NULL AND NOT (igs_pe_pers_imp_001.validate_lookup_type_code('HZ_LANGUAGE_PROFICIENCY',p_person_language_rec.READS_LEVEL,222)) THEN

1000: RAISE NO_DATA_FOUND;
1001: END IF;
1002: CLOSE lang_name_cur;
1003:
1004: IF p_person_language_rec.READS_LEVEL IS NOT NULL AND NOT (igs_pe_pers_imp_001.validate_lookup_type_code('HZ_LANGUAGE_PROFICIENCY',p_person_language_rec.READS_LEVEL,222)) THEN
1005: l_error_code := 'E750';
1006: RAISE NO_DATA_FOUND;
1007: END IF;
1008:

Line 1009: IF p_person_language_rec.SPEAKS_LEVEL IS NOT NULL AND NOT (igs_pe_pers_imp_001.validate_lookup_type_code('HZ_LANGUAGE_PROFICIENCY',p_person_language_rec.SPEAKS_LEVEL,222)) THEN

1005: l_error_code := 'E750';
1006: RAISE NO_DATA_FOUND;
1007: END IF;
1008:
1009: IF p_person_language_rec.SPEAKS_LEVEL IS NOT NULL AND NOT (igs_pe_pers_imp_001.validate_lookup_type_code('HZ_LANGUAGE_PROFICIENCY',p_person_language_rec.SPEAKS_LEVEL,222)) THEN
1010: l_error_code := 'E751';
1011: RAISE NO_DATA_FOUND;
1012: END IF;
1013:

Line 1014: IF p_person_language_rec.WRITES_LEVEL IS NOT NULL AND NOT (igs_pe_pers_imp_001.validate_lookup_type_code('HZ_LANGUAGE_PROFICIENCY',p_person_language_rec.WRITES_LEVEL,222)) THEN

1010: l_error_code := 'E751';
1011: RAISE NO_DATA_FOUND;
1012: END IF;
1013:
1014: IF p_person_language_rec.WRITES_LEVEL IS NOT NULL AND NOT (igs_pe_pers_imp_001.validate_lookup_type_code('HZ_LANGUAGE_PROFICIENCY',p_person_language_rec.WRITES_LEVEL,222)) THEN
1015: l_error_code := 'E752';
1016: RAISE NO_DATA_FOUND;
1017: END IF;
1018:

Line 1019: IF p_person_language_rec.UNDERSTANDS_LEVEL IS NOT NULL AND NOT (igs_pe_pers_imp_001.validate_lookup_type_code('HZ_LANGUAGE_PROFICIENCY',p_person_language_rec.UNDERSTANDS_LEVEL,222)) THEN

1015: l_error_code := 'E752';
1016: RAISE NO_DATA_FOUND;
1017: END IF;
1018:
1019: IF p_person_language_rec.UNDERSTANDS_LEVEL IS NOT NULL AND NOT (igs_pe_pers_imp_001.validate_lookup_type_code('HZ_LANGUAGE_PROFICIENCY',p_person_language_rec.UNDERSTANDS_LEVEL,222)) THEN
1020: l_error_code := 'E753';
1021: RAISE NO_DATA_FOUND;
1022: END IF;
1023:

Line 1745: (igs_pe_pers_imp_001.validate_lookup_type_code('PE_ATH_ELG_STATUS',p_ath_dtl_rec.eligibility_status_cd,8405))

1741: -- kumma, 2608360 replaced the igs_ad_code_classes with igs_lookup_values
1742:
1743: IF p_ath_dtl_rec.eligibility_status_cd IS NOT NULL THEN
1744: IF NOT
1745: (igs_pe_pers_imp_001.validate_lookup_type_code('PE_ATH_ELG_STATUS',p_ath_dtl_rec.eligibility_status_cd,8405))
1746: THEN
1747: l_error_code := 'E095'; -- Person Athletics Details Validation Failed - Eligibility Status
1748: RAISE no_data_found;
1749: END IF;

Line 1758: (igs_pe_pers_imp_001.validate_lookup_type_code('PE_TENTATIVE_ADM_TYPE',p_ath_dtl_rec.tentative_adm_code,8405))

1754: -- TENTATIVE_ADM_CD
1755:
1756: IF p_ath_dtl_rec.tentative_adm_code IS NOT NULL AND
1757: NOT
1758: (igs_pe_pers_imp_001.validate_lookup_type_code('PE_TENTATIVE_ADM_TYPE',p_ath_dtl_rec.tentative_adm_code,8405))
1759: THEN
1760: l_error_code := 'E096'; -- Person Athletics Details Validation Failed - Tentative Admission Code
1761: RAISE no_data_found;
1762: ELSE

Line 1770: (igs_pe_pers_imp_001.validate_lookup_type_code('PE_PRE_ELIG_TYPE',p_ath_dtl_rec.predict_elig_code,8405))

1766: -- PREDICT_ELIG_CODE
1767:
1768: IF p_ath_dtl_rec.predict_elig_code IS NOT NULL AND
1769: NOT
1770: (igs_pe_pers_imp_001.validate_lookup_type_code('PE_PRE_ELIG_TYPE',p_ath_dtl_rec.predict_elig_code,8405))
1771: THEN
1772: l_error_code := 'E097'; -- Person Athletics Details Validation Failed - Predicted Eligibility
1773: RAISE no_data_found;
1774: ELSE

Line 2285: (igs_pe_pers_imp_001.validate_lookup_type_code('PE_ATH_PRG_TYPE',p_ath_prg_rec.athletic_prg_code,8405)))

2281:
2282:
2283: IF (p_ath_prg_rec.athletic_prg_code IS NOT NULL AND
2284: NOT
2285: (igs_pe_pers_imp_001.validate_lookup_type_code('PE_ATH_PRG_TYPE',p_ath_prg_rec.athletic_prg_code,8405)))
2286: OR(p_ath_prg_rec.athletic_prg_code IS NULL) THEN
2287: l_error_code := 'E101'; -- Person Athletics Program Validation Failed - Athletic Program Code
2288: RAISE no_data_found;
2289: ELSE