APPS.IGS_GR_AWD_CEREMONY_PKG dependencies on IGS_GR_VAL_AWC

Line 100: IF IGS_GR_VAL_AWC.crsp_val_aw_closed(

96: END IF;
97: END IF;
98: -- Validate the award is not closed
99: IF p_inserting OR (p_updating AND new_references.award_cd <> old_references.award_cd) THEN
100: IF IGS_GR_VAL_AWC.crsp_val_aw_closed(
101: new_references.award_cd,
102: v_message_name) = FALSE THEN
103: Fnd_Message.Set_Name('IGS', v_message_name);
104: IGS_GE_MSG_STACK.ADD;

Line 111: IF IGS_GR_VAL_AWC.grdp_val_award_type(

107: END IF;
108: -- Validate award is of the correct system award type
109: IF p_inserting OR p_updating THEN
110: IF new_references.award_course_cd IS NOT NULL THEN
111: IF IGS_GR_VAL_AWC.grdp_val_award_type(
112: new_references.award_cd,
113: 'COURSE',
114: v_message_name) = FALSE THEN
115: Fnd_Message.Set_Name('IGS', v_message_name);

Line 120: IF IGS_GR_VAL_AWC.grdp_val_award_type(

116: IGS_GE_MSG_STACK.ADD;
117: App_Exception.Raise_Exception;
118: END IF;
119: ELSE
120: IF IGS_GR_VAL_AWC.grdp_val_award_type(
121: new_references.award_cd,
122: 'HONORARY',
123: v_message_name) = FALSE THEN
124: Fnd_Message.Set_Name('IGS', v_message_name);

Line 165: IF IGS_GR_VAL_AWC.grdp_val_awc_order(

161: (new_references.order_in_ceremony <> old_references.order_in_ceremony OR
162: (new_references.closed_ind <> old_references.closed_ind AND new_references.closed_ind = 'N'))) THEN
163:
164: -- validate award ceremony order in ceremony
165: IF IGS_GR_VAL_AWC.grdp_val_awc_order(
166: NEW_REFERENCES.grd_cal_type,
167: NEW_REFERENCES.grd_ci_sequence_number,
168: NEW_REFERENCES.ceremony_number,
169: NEW_REFERENCES.award_course_cd,