[Home] [Help]
150: -- Validate that inserts are allowed
151: IF p_inserting THEN
152: --
153: -- Validate assessment type closed indicator
154: IF IGS_AS_VAL_AI.assp_val_atyp_closed(new_references.assessment_type,
155: v_message_name) = FALSE THEN
156: Fnd_Message.Set_Name('IGS', v_message_name);
157: IGS_GE_MSG_STACK.ADD;
158: App_Exception.Raise_Exception;
162: IF p_inserting OR p_updating THEN
163: --
164: -- Validate the approp. ass item details set and are not set for the
165: -- respective assessment type examinable indicator setting
166: IF IGS_AS_VAL_AI.assp_val_ai_details(new_references.assessment_type,
167: new_references.exam_scheduled_ind,
168: new_references.exam_working_time,
169: new_references.exam_announcements,
170: new_references.exam_short_paper_name,
182: App_Exception.Raise_Exception;
183: END IF;
184: --
185: -- Validate exam times
186: IF IGS_AS_VAL_AI.assp_val_ai_ex_times(new_references.assessment_type,
187: new_references.exam_working_time,
188: new_references.exam_perusal_time,
189: v_message_name) = FALSE THEN
190: Fnd_Message.Set_Name('IGS', v_message_name);
214: (new_references.ASSESSMENT_TYPE <> old_references.ASSESSMENT_TYPE) THEN
215: -- Validate that p_updating the assessment type will not cause non-unique
216: -- IGS_AS_UNITASS_ITEM.reference within a IGS_PS_UNIT offering pattern.
217: -- Save row id as validation causes a mutating trigger.
218: IF IGS_AS_VAL_AI.assp_val_ai_type(
219: new_references.ass_id,
220: new_references.assessment_type,
221: new_references.assessment_type,
222: v_message_name) = FALSE THEN