342: IF (new_references.pfe_start_dt IS NOT NULL) AND
343: (p_inserting OR (p_updating AND
344: (old_references.pfe_start_dt <> new_references.pfe_start_dt)))
345: THEN
346: IF igs_en_val_pce.enrp_val_encmb_dt (
347: new_references.pfe_start_dt,
348: l_message_name) = FALSE THEN
349: FND_MESSAGE.SET_NAME('IGS', l_message_name);
350: IGS_GE_MSG_STACK.ADD;
354:
355: -- Validate that start date is not less than the parent IGS_PE_PERSON
356: -- Encumbrance Effect start date.
357: IF p_inserting THEN
358: IF igs_en_val_pce.enrp_val_encmb_dts (
359: new_references.pee_start_dt,
360: new_references.pfe_start_dt,
361: l_message_name) = FALSE THEN
362: FND_MESSAGE.SET_NAME('IGS', l_message_name);
371: (p_inserting OR (p_updating AND
372: (NVL(old_references.expiry_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))
373: <> new_references.expiry_dt)))
374: THEN
375: IF igs_en_val_pce.enrp_val_strt_exp_dt (
376: new_references.pfe_start_dt,
377: new_references.expiry_dt,
378: l_message_name) = FALSE THEN
379: FND_MESSAGE.SET_NAME('IGS', l_message_name);
380: IGS_GE_MSG_STACK.ADD;
381: APP_EXCEPTION.RAISE_EXCEPTION;
382: END IF;
383:
384: IF igs_en_val_pce.enrp_val_encmb_dt (
385: new_references.expiry_dt,
386: l_message_name) = FALSE THEN
387: FND_MESSAGE.SET_NAME('IGS', l_message_name);
388: IGS_GE_MSG_STACK.ADD;