APPS.IGS_AD_IMP_026 dependencies on IGS_PE_PERS_IMP_001

Line 135: IF NOT igs_pe_pers_imp_001.validate_lookup_type_code('PE_US_VISA_ISSUE_LOC',visa_rec.visa_issuing_post,8405) THEN

131: l_prog_label := 'igs.plsql.igs_ad_imp_026.prc_pe_visa';
132:
133: IF visa_rec.visa_issuing_post IS NOT NULL THEN
134:
135: IF NOT igs_pe_pers_imp_001.validate_lookup_type_code('PE_US_VISA_ISSUE_LOC',visa_rec.visa_issuing_post,8405) THEN
136: l_error := 'E190';
137: RAISE NO_DATA_FOUND;
138: END IF;
139: END IF;

Line 143: IF NOT igs_pe_pers_imp_001.validate_lookup_type_code('PER_US_VISA_TYPES',visa_rec.visa_type,3) THEN

139: END IF;
140:
141: -- VALIDATE VISA TYPE
142:
143: IF NOT igs_pe_pers_imp_001.validate_lookup_type_code('PER_US_VISA_TYPES',visa_rec.visa_type,3) THEN
144: l_error := 'E191';
145: RAISE no_data_found;
146: END IF;
147:

Line 203: IF NOT (igs_pe_pers_imp_001.validate_country_code(visa_rec.visa_issuing_country)) -- change for country code inconsistency bug 3738488

199: END IF;
200:
201: IF visa_rec.visa_issuing_country IS NOT NULL THEN
202: IF visa_rec.visa_issuing_country <> 'US' THEN
203: IF NOT (igs_pe_pers_imp_001.validate_country_code(visa_rec.visa_issuing_country)) -- change for country code inconsistency bug 3738488
204: THEN
205: l_error := 'E554';
206: RAISE NO_DATA_FOUND;
207: END IF;

Line 940: --IF NOT igs_pe_pers_imp_001.validate_lookup_type_code('PER_US_COUNTRY_CODE',pass_rec.passport_cntry_code,3) THEN

936: l_enable_log := igs_ad_imp_001.g_enable_log;
937:
938: p_err_code := NULL;
939:
940: --IF NOT igs_pe_pers_imp_001.validate_lookup_type_code('PER_US_COUNTRY_CODE',pass_rec.passport_cntry_code,3) THEN
941: IF NOT (igs_pe_pers_imp_001.validate_country_code(pass_rec.passport_cntry_code)) -- change for country code inconsistency bug 3738488
942: THEN
943: p_err_code := 'E553';
944: RAISE no_data_found;

Line 941: IF NOT (igs_pe_pers_imp_001.validate_country_code(pass_rec.passport_cntry_code)) -- change for country code inconsistency bug 3738488

937:
938: p_err_code := NULL;
939:
940: --IF NOT igs_pe_pers_imp_001.validate_lookup_type_code('PER_US_COUNTRY_CODE',pass_rec.passport_cntry_code,3) THEN
941: IF NOT (igs_pe_pers_imp_001.validate_country_code(pass_rec.passport_cntry_code)) -- change for country code inconsistency bug 3738488
942: THEN
943: p_err_code := 'E553';
944: RAISE no_data_found;
945: END IF;

Line 1593: IF NOT igs_pe_pers_imp_001.validate_lookup_type_code('PE_US_PORT_OF_ENTRY',visit_rec.port_of_entry,8405) THEN

1589: l_prog_label := 'igs.plsql.igs_ad_imp_026.prc_pe_visit_histry';
1590: l_label := 'igs.plsql.igs_ad_imp_026.prc_pe_visit_histry.';
1591: l_enable_log := igs_ad_imp_001.g_enable_log;
1592:
1593: IF NOT igs_pe_pers_imp_001.validate_lookup_type_code('PE_US_PORT_OF_ENTRY',visit_rec.port_of_entry,8405) THEN
1594: p_err_code := 'E557';
1595: RAISE no_data_found;
1596: END IF;
1597:

Line 2375: (igs_pe_pers_imp_001.validate_country_code(eit_rec.pei_information1)) -- change for country code inconsistency bug 3738488

2371: l_error := NULL;
2372:
2373: IF eit_rec.pei_information1 IS NOT NULL THEN
2374: IF NOT
2375: (igs_pe_pers_imp_001.validate_country_code(eit_rec.pei_information1)) -- change for country code inconsistency bug 3738488
2376: THEN
2377: l_error := 'E566';
2378: RAISE no_data_found;
2379: END IF;