APPS.IGS_PS_STDNT_SPL_REQ_PKG dependencies on IGS_EN_VAL_SCSR

Line 77: IF IGS_EN_VAL_SCSR.enrp_val_scsr_scas(

73: BEGIN
74: -- Validate Student IGS_PS_COURSE Special Requirement
75: -- Validate the Student IGS_PS_COURSE Attempt is active
76: IF p_inserting OR p_updating THEN
77: IF IGS_EN_VAL_SCSR.enrp_val_scsr_scas(
78: new_references.person_id,
79: new_references.course_cd,
80: v_message_name) = FALSE THEN
81: Fnd_Message.Set_Name('IGS', v_message_name);

Line 87: IF IGS_EN_VAL_SCSR.enrp_val_scsr_scas(

83: App_Exception.Raise_Exception;
84: END IF;
85: END IF;
86: IF p_deleting THEN
87: IF IGS_EN_VAL_SCSR.enrp_val_scsr_scas(
88: old_references.person_id,
89: old_references.course_cd,
90: v_message_name) = FALSE THEN
91: Fnd_Message.Set_Name('IGS', v_message_name);

Line 98: IF IGS_EN_VAL_SCSR.enrp_val_scsr_cmp_dt(

94: END IF;
95: END IF;
96: -- Validate the completed date
97: IF p_inserting THEN
98: IF IGS_EN_VAL_SCSR.enrp_val_scsr_cmp_dt(
99: new_references.completed_dt,
100: v_message_name) = FALSE THEN
101: Fnd_Message.Set_Name('IGS', v_message_name);
102: IGS_GE_MSG_STACK.ADD;

Line 109: IF IGS_EN_VAL_SCSR.enrp_val_scsr_exp_dt(

105: END IF;
106: -- Validate the expiry date
107: IF p_inserting OR p_updating THEN
108: IF new_references.expiry_dt IS NOT NULL THEN
109: IF IGS_EN_VAL_SCSR.enrp_val_scsr_exp_dt(
110: new_references.completed_dt,
111: new_references.expiry_dt,
112: v_message_name) = FALSE THEN
113: Fnd_Message.Set_Name('IGS', v_message_name);

Line 121: IF IGS_EN_VAL_SCSR.enrp_val_srq_closed(

117: END IF;
118: END IF;
119: -- Validate the special requirement code is not closed
120: IF p_inserting THEN
121: IF IGS_EN_VAL_SCSR.enrp_val_srq_closed(
122: new_references.special_requirement_cd,
123: v_message_name) = FALSE THEN
124: Fnd_Message.Set_Name('IGS', v_message_name);
125: IGS_GE_MSG_STACK.ADD;

Line 143: IF IGS_EN_VAL_SCSR.enrp_val_scsr_dates(

139: BEGIN
140: -- Validate the student IGS_PS_COURSE special requirement dates
141: IF p_inserting OR p_updating THEN
142: -- Validate the Student course Special Requirement dates
143: IF IGS_EN_VAL_SCSR.enrp_val_scsr_dates(
144: new_references.person_id,
145: new_references.course_cd,
146: new_references.special_requirement_cd,
147: new_references.completed_dt,