[Home] [Help]
212: p_error_code igs_ad_military_int_all.ERROR_CODE%TYPE := NULL;
213:
214: BEGIN
215: IF NOT
216: (igs_pe_pers_imp_001.validate_lookup_type_code('PE_MIL_SEV_TYPE',military_rec.military_type_cd,8405))
217: THEN
218: p_error_code := 'E278';
219: l_check := 'TRUE';
220: RAISE NO_DATA_FOUND;
221: END IF;
222:
223: IF military_rec.ASSISTANCE_TYPE_CD IS NOT NULL THEN
224: IF NOT
225: (igs_pe_pers_imp_001.validate_lookup_type_code('PE_MIL_ASS_TYPE',military_rec.assistance_type_cd,8405))
226: THEN
227: p_error_code := 'E279';
228: l_check := 'TRUE';
229: RAISE NO_DATA_FOUND;
231: END IF;
232:
233: IF military_rec.ASSISTANCE_STATUS_CD IS NOT NULL THEN
234: IF NOT
235: (igs_pe_pers_imp_001.validate_lookup_type_code('PE_MIL_ASS_STATUS',military_rec.assistance_status_cd,8405))
236: THEN
237: p_error_code := 'E280';
238: l_check := 'TRUE';
239: RAISE NO_DATA_FOUND;
260: END IF;
261:
262: IF military_rec.separation_type_cd IS NOT NULL THEN
263: IF NOT
264: (igs_pe_pers_imp_001.validate_lookup_type_code('PE_MIL_SEP_TYPE',military_rec.separation_type_cd,8405))
265: THEN
266: p_error_code := 'E286';
267: l_check := 'TRUE';
268: RAISE NO_DATA_FOUND;
718: -- subsequent validations. The error_code field is updated with the corresponding error code.
719: --Immunization code
720: -- modified to new lookup igs_lookup_values by gmuralid
721: IF NOT
722: (igs_pe_pers_imp_001.validate_lookup_type_code('PE_IMM_TYPE',p_health_insur_rec.immunization_code,8405))
723: THEN
724: p_error_code := 'E156';
725: RAISE no_data_found;
726: ELSE
729: --Status code
730: --Cursor modified by gmuralid by migrating to new look up igs_lookups_view
731:
732: IF
733: (igs_pe_pers_imp_001.validate_lookup_type_code('PE_IMM_STATUS',p_health_insur_rec.status_code,8405))
734: THEN
735: p_error_code := NULL;
736: ELSE
737: p_error_code := 'E157'; -- Status code Validation Failed
1450:
1451: BEGIN
1452:
1453: IF NOT
1454: (igs_pe_pers_imp_001.validate_lookup_type_code('PE_INS_TYPE',hlth_ins_rec.insurance_cd,8405))
1455: THEN
1456: p_error_code := 'E552';
1457: RAISE NO_DATA_FOUND;
1458: END IF;
2347: check_dur_rec.person_id_type := NULL;
2348:
2349: IF ((l_call_ucas_user_hook) AND (api_rec.person_id_type IN ('UCASID','NMASID','SWASID','GTTRID','UCASREGNO'))) THEN
2350:
2351: igs_pe_pers_imp_001.validate_ucas_id(api_rec.alternate_id,api_rec.person_id,api_rec.person_id_type,l_ucas_action,l_ucas_error_code);
2352:
2353: /* S - Skip the record.
2354: P - Proceed with the record.
2355: E - Error out the record.
2715: l_error := null;
2716: END IF;
2717: IF pcz_rec.document_type IS NOT NULL THEN
2718: IF NOT
2719: (igs_pe_pers_imp_001.validate_lookup_type_code('CITIZENSHIP_DOC_TYPE',pcz_rec.document_type,8405))
2720: THEN
2721: l_error := 'E126';
2722: RAISE no_data_found;
2723: ELSE
2964:
2965:
2966: IF pcz_rec.document_type IS NOT NULL THEN
2967: IF NOT
2968: (igs_pe_pers_imp_001.validate_lookup_type_code('CITIZENSHIP_DOC_TYPE',pcz_rec.document_type,8405))
2969: THEN
2970: l_error := 'E126';
2971: RAISE no_data_found;
2972: ELSE
3395:
3396: -- Start Validations
3397:
3398: IF NOT
3399: (igs_pe_pers_imp_001.validate_lookup_type_code('PE_FUND_TYPE',pfs_rec.fund_source_code,8405))
3400: THEN
3401: l_error := 'E124';
3402: RAISE no_data_found;
3403: ELSE
3405: END IF;
3406:
3407: IF pfs_rec.relationship_code IS NOT NULL THEN
3408: IF NOT
3409: (igs_pe_pers_imp_001.validate_lookup_type_code('PARTY_RELATIONS_TYPE',pfs_rec.relationship_code,222))
3410: THEN
3411: l_error := 'E135';
3412: RAISE no_data_found;
3413: ELSE