266: IF (((old_references.military_type_cd = new_references.military_type_cd)) OR
267: ((new_references.military_type_cd IS NULL))) THEN
268: NULL;
269:
270: ELSIF NOT Igs_Lookups_view_pkg.Get_PK_For_Validation (
271: 'PE_MIL_SEV_TYPE',new_references.military_type_cd
272: ) THEN
273: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
274: IGS_GE_MSG_STACK.ADD;
288:
289: IF (((old_references.separation_type_cd = new_references.separation_type_cd)) OR
290: ((new_references.separation_type_cd IS NULL))) THEN
291: NULL;
292: ELSIF NOT Igs_Lookups_view_pkg.Get_PK_For_Validation (
293: 'PE_MIL_SEP_TYPE',new_references.separation_type_cd
294:
295: ) THEN
296: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
300:
301: IF (((old_references.assistance_status_cd = new_references.assistance_status_cd)) OR
302: ((new_references.assistance_status_cd IS NULL))) THEN
303: NULL;
304: ELSIF NOT Igs_Lookups_view_pkg.Get_PK_For_Validation (
305: 'PE_MIL_ASS_STATUS',new_references.assistance_status_cd
306: ) THEN
307: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
308: IGS_GE_MSG_STACK.ADD;
311:
312: IF (((old_references.assistance_type_cd = new_references.assistance_type_cd)) OR
313: ((new_references.assistance_type_cd IS NULL))) THEN
314: NULL;
315: ELSIF NOT Igs_Lookups_view_pkg.Get_PK_For_Validation (
316: 'PE_MIL_ASS_TYPE',new_references.assistance_type_cd
317:
318: ) THEN
319: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');