[Home] [Help]
134: (p_updating AND (NVL(new_references.crv_course_cd, 'NULL') <>
135: NVL(old_references.crv_course_cd,'NULL') OR
136: NVL(new_references.crv_version_number, 0) <>
137: NVL(old_references.crv_version_number,0))) THEN
138: IF IGS_PR_VAL_PRA.crsp_val_crv_active (
139: new_references.crv_course_cd,
140: new_references.crv_version_number,
141: v_message_name) = FALSE THEN
142: Fnd_Message.Set_Name('IGS',v_message_name);
160: END IF;
161: END IF;
162: -- Validate the progression IGS_RU_RULE category
163: IF p_inserting THEN
164: IF IGS_PR_VAL_PRA.prgp_val_prgc_closed (
165: new_references.progression_rule_cat,
166: v_message_name) = FALSE THEN
167: Fnd_Message.Set_Name('IGS',v_message_name);
168: IGS_GE_MSG_STACK.ADD;
172: -- Validate the progression IGS_RU_RULE
173: IF new_references.progression_rule_cd IS NOT NULL AND (p_inserting OR
174: (p_updating AND NVL(new_references.progression_rule_cd, 'NULL') <>
175: NVL(old_references.progression_rule_cd,'NULL'))) THEN
176: IF IGS_PR_VAL_PRA.prgp_val_prr_closed (
177: new_references.progression_rule_cd,
178: v_message_name) = FALSE THEN
179: Fnd_Message.Set_Name('IGS',v_message_name);
180: IGS_GE_MSG_STACK.ADD;
187: NVL(old_references.attendance_type, 'NULL'))) THEN
188: --
189: -- bug id : 1956374
190: -- sjadhav , 28-aug-2001
191: -- change igs_pr_val_pra.enrp_val_att_closed
192: -- to igs_en_val_pee.enrp_val_att_closed
193: --
194: IF IGS_EN_VAL_PEE.enrp_val_att_closed (
195: new_references.attendance_type,
200: END IF;
201: END IF;
202: -- Validate the record has the required details
203: IF p_inserting OR p_updating THEN
204: IF IGS_PR_VAL_PRA.prgp_val_pra_rqrd (
205: new_references.s_relation_type,
206: new_references.progression_rule_cd,
207: new_references.rul_sequence_number,
208: new_references.ou_org_unit_cd,