APPS.IGS_AS_GRD_SCH_GRADE_PKG dependencies on IGS_AS_VAL_GSG

Line 173: IF IGS_AS_VAL_GSG.assp_val_gs_cur_fut (

169: -- Validate that inserts/updates are allowed
170: IF p_inserting OR p_updating THEN
171: -- Validate if grade's grading schema is current or future
172: IF p_inserting OR p_updating THEN
173: IF IGS_AS_VAL_GSG.assp_val_gs_cur_fut (
174: new_references.grading_schema_cd,
175: new_references.version_number,
176: v_message_name) = FALSE THEN
177: FND_MESSAGE.SET_NAME('IGS',v_message_name);

Line 184: IF IGS_AS_VAL_GSG.assp_val_gsg_mrk_rng (

180: END IF;
181: END IF;
182: -- Validate upper mark range >= lower mark range and both set if one is set
183: IF p_inserting OR p_updating THEN
184: IF IGS_AS_VAL_GSG.assp_val_gsg_mrk_rng (
185: new_references.lower_mark_range,
186: new_references.upper_mark_range,
187: v_message_name) = FALSE THEN
188: FND_MESSAGE.SET_NAME('IGS',v_message_name);

Line 195: IF IGS_AS_VAL_GSG.assp_val_gsg_min_max (

191: END IF;
192: END IF;
193: -- Validate max percentage >= min percentage
194: IF p_inserting OR p_updating THEN
195: IF IGS_AS_VAL_GSG.assp_val_gsg_min_max (
196: new_references.min_percentage,
197: new_references.max_percentage,
198: v_message_name) = FALSE THEN
199: FND_MESSAGE.SET_NAME('IGS',v_message_name);

Line 217: IF IGS_AS_VAL_GSG.assp_val_gsg_gsgt (

213: IF (p_inserting OR p_updating) AND
214: new_references.s_result_type <> old_references.s_result_type
215: THEN
216:
217: IF IGS_AS_VAL_GSG.assp_val_gsg_gsgt (
218: new_references.grading_schema_cd,
219: new_references.version_number,
220: new_references.grade,
221: v_message_name) = FALSE THEN

Line 230: IF IGS_AS_VAL_GSG.assp_val_gsg_ssgt (

226: END IF;
227:
228: -- Validate if s_special_grade_type is 'CONCEDED-PASS' then
229: -- s_result_type must be 'PASS'
230: IF IGS_AS_VAL_GSG.assp_val_gsg_ssgt (
231: new_references.s_special_grade_type,
232: new_references.s_result_type,
233: v_message_name) = FALSE THEN
234: FND_MESSAGE.SET_NAME('IGS',v_message_name);

Line 248: IF IGS_AS_VAL_GSG.assp_val_gsg_m_ovrlp (

244: ) AS
245: v_message_name VARCHAR2(30);
246: BEGIN
247: IF p_inserting OR p_updating THEN
248: IF IGS_AS_VAL_GSG.assp_val_gsg_m_ovrlp (
249: new_references.grading_schema_cd,
250: new_references.version_number,
251: new_references.grade,
252: new_references.lower_mark_range,

Line 261: IF IGS_AS_VAL_GSG.assp_val_gsg_dflt (

257: APP_EXCEPTION.RAISE_EXCEPTION;
258: END IF;
259: -- Validate dflt outstanding indicator only set for 1 grade
260: IF new_references.dflt_outstanding_ind = 'Y' THEN
261: IF IGS_AS_VAL_GSG.assp_val_gsg_dflt (
262: new_references.grading_schema_cd,
263: new_references.version_number,
264: new_references.grade,
265: v_message_name) = FALSE THEN