76: BEGIN
77: -- Validate if result_obtained_yr is specified then score and
78: -- IGS_AS_ASSESSMNT_TYP must be specified.
79: IF p_inserting OR p_updating THEN
80: IF IGS_AD_VAL_ASE.admp_val_ase_scoreat(
81: new_references.result_obtained_yr,
82: new_references.score,
83: new_references.aus_scndry_edu_ass_type,
84: v_message_name) = FALSE THEN
99: OR (old_references.state_cd <> new_references.state_cd)
100: OR (old_references.aus_scndry_edu_ass_type <> new_references.aus_scndry_edu_ass_type)
101: OR (old_references.aus_scndry_edu_ass_type IS NULL AND
102: new_references.aus_scndry_edu_ass_type IS NOT NULL) THEN
103: IF IGS_AD_VAL_ASE.admp_val_ase_atstate(
104: new_references.state_cd,
105: new_references.aus_scndry_edu_ass_type,
106: v_message_name) = FALSE THEN
107: Fnd_Message.Set_Name('IGS',v_message_name);
115: OR (old_references.state_cd <> new_references.state_cd)
116: OR (old_references.secondary_school_cd <> new_references.secondary_school_cd)
117: OR (old_references.secondary_school_cd IS NULL AND
118: new_references.secondary_school_cd IS NOT NULL) THEN
119: IF IGS_AD_VAL_ASE.admp_val_ase_scstate(
120: new_references.state_cd,
121: new_references.secondary_school_cd,
122: v_message_name) = FALSE THEN
123: Fnd_Message.Set_Name('IGS',v_message_name);
140: IF p_inserting
141: OR (old_references.aus_scndry_edu_ass_type <> new_references.aus_scndry_edu_ass_type)
142: OR (old_references.aus_scndry_edu_ass_type IS NULL AND
143: new_references.aus_scndry_edu_ass_type IS NOT NULL) THEN
144: IF IGS_AD_VAL_ASE.admp_val_aseatclosed(
145: new_references.aus_scndry_edu_ass_type,
146: v_message_name) = FALSE THEN
147: Fnd_Message.Set_Name('IGS',v_message_name);
148: IGS_GE_MSG_STACK.ADD;