[Home] [Help]
218:
219: l_count:= 0;
220: -- Validate Oth_Relationship_Type
221: IF P_Relations_Rec.Oth_Relationship_Type IS NOT NULL THEN
222: IF NOT(igs_pe_pers_imp_001.validate_lookup_type_code('PARTY_RELATIONS_TYPE',P_Relations_Rec.oth_relationship_type,222)) THEN
223: IF l_enable_log = 'Y' THEN
224: igs_ad_imp_001.logerrormessage(P_Relations_Rec.Interface_Relations_Id,'E240','IGS_AD_RELATIONS_INT_ALL');
225: END IF;
226: UPDATE igs_ad_relations_int_all
258: END IF;
259:
260: -- Validate the title
261: IF P_Relations_Rec.pre_name_adjunct IS NOT NULL THEN
262: IF NOT (igs_pe_pers_imp_001.validate_lookup_type_code('CONTACT_TITLE',P_Relations_Rec.pre_name_adjunct,222)) THEN
263: IF l_enable_log = 'Y' THEN
264: igs_ad_imp_001.logerrormessage(P_Relations_Rec.Interface_Relations_Id,'E201','IGS_AD_RELATIONS_INT_ALL');
265: END IF;
266: UPDATE igs_ad_relations_int_all
271: END IF;
272: END IF;
273: -- Validate Sex.
274: IF P_Relations_Rec.sex IS NOT NULL THEN
275: IF NOT (igs_pe_pers_imp_001.validate_lookup_type_code('HZ_GENDER',P_Relations_Rec.sex,222)) THEN
276: IF l_enable_log = 'Y' THEN
277: igs_ad_imp_001.logerrormessage(P_Relations_Rec.Interface_Relations_Id,'E202','IGS_AD_RELATIONS_INT_ALL');
278: END IF;
279: UPDATE igs_ad_relations_int_all
1058: l_birth_date DATE;
1059: BEGIN
1060: l_Status := '3';
1061: IF (reladdr_rec.site_use_code_1 IS NOT NULL) THEN
1062: IF NOT (igs_pe_pers_imp_001.validate_lookup_type_code('PARTY_SITE_USE_CODE',reladdr_rec.site_use_code_1,222)) THEN
1063: IF l_enable_log = 'Y' THEN
1064: igs_ad_imp_001.logerrormessage(reladdr_rec.interface_reladdr_id,'E211','IGS_AD_RELADDR_INT_ALL');
1065: END IF;
1066:
1073: END IF;
1074: END IF;
1075:
1076: IF (reladdr_rec.site_use_code_2 IS NOT NULL) THEN
1077: IF NOT (igs_pe_pers_imp_001.validate_lookup_type_code('PARTY_SITE_USE_CODE',reladdr_rec.site_use_code_2,222)) THEN
1078: IF l_enable_log = 'Y' THEN
1079: igs_ad_imp_001.logerrormessage(reladdr_rec.interface_reladdr_id,'E211','IGS_AD_RELADDR_INT_ALL');
1080: END IF;
1081: UPDATE igs_ad_reladdr_int_all
1788: BEGIN
1789:
1790: -- Validate contact point type
1791: IF NOT
1792: (igs_pe_pers_imp_001.validate_lookup_type_code('COMMUNICATION_TYPE',relcon_rec.contact_point_type,222))
1793: THEN
1794: -- If the validation is not successful.
1795:
1796: IF l_enable_log = 'Y' THEN
1838: END IF;
1839:
1840: -- Validate the PHONE_LINE_TYPE
1841: IF NOT
1842: (igs_pe_pers_imp_001.validate_lookup_type_code('PHONE_LINE_TYPE',relcon_rec.phone_line_type,222))
1843: THEN
1844: -- If the validation is not successful.
1845:
1846:
1896: RETURN;
1897: END IF;
1898:
1899: IF NOT
1900: (igs_pe_pers_imp_001.validate_lookup_type_code('EMAIL_FORMAT',relcon_rec.email_format,222))
1901: THEN
1902:
1903: IF l_enable_log = 'Y' THEN
1904: igs_ad_imp_001.logerrormessage(relcon_rec.interface_rel_con_id,'E248','IGS_AD_REL_CON_INT_ALL');
3456: END IF;
3457: END IF;
3458:
3459: IF P_RELEMP_REC.TYPE_OF_EMPLOYMENT IS NOT NULL THEN
3460: IF NOT (igs_pe_pers_imp_001.validate_lookup_type_code('HZ_EMPLOYMENT_TYPE',P_RELEMP_REC.TYPE_OF_EMPLOYMENT,222)) THEN
3461: p_error_code :='E224';
3462: IF l_enable_log = 'Y' THEN
3463: igs_ad_imp_001.logerrormessage(p_relemp_rec.interface_relemp_id,'E224','IGS_AD_RELEMP_INT_ALL');
3464: END IF;
3474: RETURN;
3475: END IF;
3476:
3477: IF P_RELEMP_REC.TENURE_OF_EMPLOYMENT IS NOT NULL THEN
3478: IF NOT (igs_pe_pers_imp_001.validate_lookup_type_code('HZ_TENURE_CODE',P_RELEMP_REC.TENURE_OF_EMPLOYMENT,222))THEN
3479: p_error_code :='E226';
3480: IF l_enable_log = 'Y' THEN
3481: igs_ad_imp_001.logerrormessage(p_relemp_rec.interface_relemp_id,p_error_code,'IGS_AD_RELEMP_INT_ALL');
3482: END IF;
3980: IF p_per_stat.RELIGION_CD IS NOT NULL THEN
3981: -- kumma, added the condition in where clause that the code should not be marked as closed.
3982: -- bug 2421786
3983: IF NOT
3984: (igs_pe_pers_imp_001.validate_lookup_type_code('PE_RELIGION',p_per_stat.religion_cd,8405))
3985: THEN
3986: p_success := 'N';
3987: p_error_code := 'E205';
3988:
3999: END IF;
4000:
4001: IF p_per_stat.MARITAL_STATUS IS NOT NULL THEN
4002: IF NOT
4003: (igs_pe_pers_imp_001.validate_lookup_type_code('MARITAL_STATUS',p_per_stat.marital_status,222))
4004: THEN
4005: --Bug Id : 2138382
4006: p_success := 'N';
4007: p_error_code := 'E206';
4077: -- ssawhney Person Interface DLD. 2103692
4078:
4079: IF p_per_stat.ETHNIC_ORIGIN IS NOT NULL THEN
4080: IF NOT
4081: (igs_pe_pers_imp_001.validate_lookup_type_code('IGS_ETHNIC_ORIGIN',p_per_stat.ETHNIC_ORIGIN,8405))
4082: THEN
4083: p_success := 'N';
4084: p_error_code := 'E207';
4085:
5345: -- validate for citizenship status
5346: ELSIF p_biodemo_rec.information_type = 'PE_STAT_RES_STATUS' THEN
5347: -- validate code if passed
5348: IF NOT
5349: (igs_pe_pers_imp_001.validate_lookup_type_code('PE_CITI_STATUS',NVL(p_biodemo_rec.pei_information1,'0'),8405))
5350: THEN
5351: l_error := 'E107';
5352: RAISE no_data_found;
5353: ELSE