DBA Data[Home] [Help]

APPS.IGS_AD_TER_EDU_PKG dependencies on IGS_AD_VAL_TE

Line 113: IF IGS_AD_VAL_TE.admp_val_telocclosed(

109: --
110: IF p_inserting
111: OR (old_references.tertiary_edu_lvl_comp <> new_references.tertiary_edu_lvl_comp) THEN
112: -- Validate tertiary education level of completion
113: IF IGS_AD_VAL_TE.admp_val_telocclosed(
114: new_references.tertiary_edu_lvl_comp,
115: v_message_name) = FALSE THEN
116: Fnd_Message.Set_Name('IGS', v_message_name);
117: IGS_GE_MSG_STACK.ADD;

Line 126: IF IGS_AD_VAL_TE.admp_val_teloqclosed(

122: OR (old_references.tertiary_edu_lvl_qual <> new_references.tertiary_edu_lvl_qual)
123: OR (old_references.tertiary_edu_lvl_qual IS NULL
124: AND new_references.tertiary_edu_lvl_qual IS NOT NULL) THEN
125: -- Validate tertiary education level of qualification
126: IF IGS_AD_VAL_TE.admp_val_teloqclosed(
127: new_references.tertiary_edu_lvl_qual,
128: v_message_name) = FALSE THEN
129: Fnd_Message.Set_Name('IGS', v_message_name);
130: IGS_GE_MSG_STACK.ADD;

Line 144: IF IGS_AD_VAL_TE.admp_val_te_enr_yr(

140: AND new_references.enrolment_latest_yr IS NOT NULL))
141: AND (new_references.enrolment_first_yr IS NOT NULL
142: AND new_references.enrolment_latest_yr IS NOT NULL) THEN
143: -- Validate enrolment years
144: IF IGS_AD_VAL_TE.admp_val_te_enr_yr(
145: new_references.enrolment_first_yr,
146: new_references.enrolment_latest_yr,
147: v_message_name) = FALSE THEN
148: Fnd_Message.Set_Name('IGS', v_message_name);

Line 160: IF IGS_AD_VAL_TE.admp_val_te_inst(

156: OR (old_references.institution_name <> new_references.institution_name)
157: OR (old_references.institution_name IS NULL AND new_references.institution_name IS NOT NULL)
158: THEN
159: -- Validate the institution code and name
160: IF IGS_AD_VAL_TE.admp_val_te_inst(
161: new_references.institution_cd,
162: new_references.institution_name,
163: v_message_name) = FALSE THEN
164: Fnd_Message.Set_Name('IGS', v_message_name);