DBA Data[Home] [Help]

APPS.IGS_PE_PERSON_ALIAS_PKG dependencies on IGS_EN_VAL_PAL

Line 8: --smadathi 24-AUG-2001 Bug No. 1956374. The call to igs_en_val_pal.genp_val_sdtt_sess

4: --Change History:
5: --Who When What
6: --smadathi 28-AUG-2001 Bug No. 1956374. The Call to igs_as_val_pal.genp_val_strt_end_dt
7: -- is replaced by igs_ad_val_edtl.genp_val_strt_end_dt
8: --smadathi 24-AUG-2001 Bug No. 1956374. The call to igs_en_val_pal.genp_val_sdtt_sess
9: -- is changed to igs_as_val_suaap.genp_val_sdtt_sess
10: --skpandey 01-JUL-2005 Bug No. 4327807
11: -- Added an additional condition in "BeforeRowInsertUpdate1" prodecure
12: -- to check that the Effective start date must not be earlier than the person's year of birth.

Line 113: IF IGS_EN_VAL_PAL.enrp_val_api_end_dt (

109: IF (new_references.end_dt IS NOT NULL) AND
110: ((p_inserting OR p_updating) OR
111: (NVL(old_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <> new_references.end_dt))
112: THEN
113: IF IGS_EN_VAL_PAL.enrp_val_api_end_dt (
114: new_references.start_dt,
115: new_references.end_dt,
116: v_message_name) = FALSE THEN
117: Fnd_Message.Set_Name('IGS', v_message_name);

Line 143: IF IGS_EN_VAL_PAL.enrp_val_pal_names (

139: App_Exception.Raise_Exception;
140: END IF;
141: -- Validate Surname and Given Names.
142: IF (p_inserting OR p_updating) THEN
143: IF IGS_EN_VAL_PAL.enrp_val_pal_names (
144: new_references.surname,
145: new_references.given_names,
146: v_message_name) = FALSE THEN
147: Fnd_Message.Set_Name('IGS', v_message_name);

Line 166: IF IGS_EN_VAL_PAL.enrp_val_pal_alias (

162: END IF;
163:
164: -- This following IF block is removed as a fix for bug number 2045753
165: /* IF (p_inserting OR p_updating) THEN
166: IF IGS_EN_VAL_PAL.enrp_val_pal_alias (
167: new_references.person_id,
168: new_references.surname,
169: new_references.given_names,
170: new_references.title,