75: -- Validate that inserts
76: IF p_inserting THEN
77: --
78: -- Can only create superior against ACTIVE or PLANNED IGS_PS_UNIT sets
79: IF IGS_PS_VAL_COusr.crsp_val_iud_us_dtl (
80: new_references.sup_unit_set_cd,
81: new_references.sup_us_version_number,
82: v_message_name) = FALSE THEN
83: FND_MESSAGE.SET_NAME('IGS',v_message_name);
85: APP_EXCEPTION.RAISE_EXCEPTION;
86: END IF;
87: --
88: -- Can only create subordinate against ACTIVE or PLANNED IGS_PS_UNIT sets
89: IF IGS_PS_VAL_COusr.crsp_val_iud_us_dtl (
90: new_references.sub_unit_set_cd,
91: new_references.sub_us_version_number,
92: v_message_name) = FALSE THEN
93: FND_MESSAGE.SET_NAME('IGS',v_message_name);
96: END IF;
97: --
98: -- Can only create as superior if 'only as subordinate' indicator is
99: -- set appropriately
100: IF IGS_PS_VAL_COusr.crsp_val_cousr_sub (
101: new_references.course_cd,
102: new_references.crv_version_number,
103: new_references.cal_type,
104: new_references.sup_unit_set_cd,
110: END IF;
111: --
112: -- Can only create as subordinate if IGS_PS_UNIT set has not been used to
113: -- restrict and admission category (ie; cacus record exists)
114: IF IGS_PS_VAL_COusr.crsp_val_cousr_cacus (
115: new_references.course_cd,
116: new_references.crv_version_number,
117: new_references.cal_type,
118: new_references.sub_unit_set_cd,
133: ) AS
134: v_message_name VARCHAR2(30);
135: BEGIN
136: -- Validate attendance type load range.
137: IF IGS_PS_VAL_COusr.crsp_val_cousr_tree (
138: new_references.course_cd,
139: new_references.crv_version_number,
140: new_references.cal_type,
141: new_references.sup_unit_set_cd,