eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_GR_GRADUAND_PKG dependencies on IGS_GR_VAL_GR

Line 153: IF IGS_GR_VAL_GR.grdp_val_gr_rqrd(

149: v_message_name VARCHAR2(30);
150: BEGIN
151: IF p_inserting OR p_updating THEN
152: -- Validate the graduand record has the required details
153: IF IGS_GR_VAL_GR.grdp_val_gr_rqrd(
154: p_course_cd => new_references.course_cd,
155: p_graduand_status => new_references.graduand_status,
156: p_s_graduand_type => new_references.s_graduand_type,
157: p_award_course_cd => new_references.award_course_cd,

Line 169: IF IGS_GR_VAL_GR.grdp_val_gr_proxy(

165: IGS_GE_MSG_STACK.ADD;
166: App_Exception.Raise_Exception;
167: END IF;
168: -- Validate proxy award details
169: IF IGS_GR_VAL_GR.grdp_val_gr_proxy(
170: new_references.person_id,
171: new_references.s_graduand_type,
172: new_references.proxy_award_ind,
173: new_references.proxy_award_person_id,

Line 185: IF IGS_GR_VAL_GR.grdp_val_gr_crd_ci(

181: NVL(new_references.grd_cal_type, 'NULL') <> NVL(old_references.grd_cal_type, 'NULL') OR
182: NVL(new_references.grd_ci_sequence_number, 0) <>
183: NVL(old_references.grd_ci_sequence_number, 0)) THEN
184: -- validate the ceremony round calendar instance
185: IF IGS_GR_VAL_GR.grdp_val_gr_crd_ci(
186: new_references.grd_cal_type,
187: new_references.grd_ci_sequence_number,
188: v_message_name) = FALSE THEN
189: Fnd_Message.Set_Name('IGS', v_message_name);

Line 197: IF IGS_GR_VAL_GR.grdp_val_gst_closed(

193: END IF;
194: IF p_inserting OR (p_updating AND
195: new_references.graduand_status <> old_references.graduand_status) THEN
196: -- Validate graduand status is not closed
197: IF IGS_GR_VAL_GR.grdp_val_gst_closed(
198: new_references.graduand_status,
199: v_message_name) = FALSE THEN
200: Fnd_Message.Set_Name('IGS', v_message_name);
201: IGS_GE_MSG_STACK.ADD;

Line 205: IF IGS_GR_VAL_GR.grdp_val_gr_gst(

201: IGS_GE_MSG_STACK.ADD;
202: App_Exception.Raise_Exception;
203: END IF;
204: -- Validate the graduand status
205: IF IGS_GR_VAL_GR.grdp_val_gr_gst(
206: new_references.person_id,
207: new_references.create_dt,
208: new_references.course_cd,
209: new_references.graduand_appr_status,

Line 225: IF IGS_GR_VAL_GR.grdp_val_gas_closed(

221: END IF;
222: IF p_inserting OR (p_updating AND
223: new_references.graduand_appr_status <> old_references.graduand_appr_status) THEN
224: -- Validate graduand approval status is not closed
225: IF IGS_GR_VAL_GR.grdp_val_gas_closed(
226: new_references.graduand_appr_status,
227: v_message_name) = FALSE THEN
228: Fnd_Message.Set_Name('IGS', v_message_name);
229: IGS_GE_MSG_STACK.ADD;

Line 233: IF IGS_GR_VAL_GR.grdp_val_gr_gas(

229: IGS_GE_MSG_STACK.ADD;
230: App_Exception.Raise_Exception;
231: END IF;
232: -- Validate the graduand approval status
233: IF IGS_GR_VAL_GR.grdp_val_gr_gas(
234: new_references.person_id,
235: new_references.course_cd,
236: new_references.graduand_status,
237: new_references.graduand_appr_status,

Line 249: IF IGS_GR_VAL_GR.grdp_val_gr_sca(

245: IF p_inserting OR (p_updating AND
246: NVL(new_references.course_cd,'NULL') <> NVL(old_references.course_cd,'NULL')) THEN
247: IF new_references.course_cd IS NOT NULL THEN
248: -- Validate the student course attempt course version graduates students
249: IF IGS_GR_VAL_GR.grdp_val_gr_sca(
250: new_references.person_id,
251: new_references.course_cd,
252: v_message_name) = FALSE THEN
253: Fnd_Message.Set_Name('IGS', v_message_name);

Line 274: IF IGS_GR_VAL_GR.grdp_val_gr_caw(

270: IGS_GE_MSG_STACK.ADD;
271: App_Exception.Raise_Exception;
272: END IF;
273: -- Validate the graduand course award
274: IF IGS_GR_VAL_GR.grdp_val_gr_caw(
275: new_references.person_id,
276: new_references.course_cd,
277: new_references.award_course_cd,
278: new_references.award_crs_version_number,

Line 309: IF IGS_GR_VAL_GR.grdp_val_gr_type(

305: END IF;
306: IF p_inserting OR (p_updating AND
307: new_references.s_graduand_type <> old_references.s_graduand_type) THEN
308: -- Validate the system graduand type
309: IF IGS_GR_VAL_GR.grdp_val_gr_type(
310: new_references.person_id,
311: new_references.create_dt,
312: new_references.course_cd,
313: new_references.graduand_status,

Line 330: IF IGS_GR_VAL_GR.grdp_val_gr_sur_caw(

326: NVL(new_references.sur_for_crs_version_number,0) <>
327: NVL(old_references.sur_for_crs_version_number,0) OR
328: NVL(new_references.sur_for_award_cd,'NULL') <> NVL(old_references.sur_for_award_cd,'NULL'))) THEN
329: -- Validate the surrender for details
330: IF IGS_GR_VAL_GR.grdp_val_gr_sur_caw(
331: new_references.person_id,
332: new_references.course_cd,
333: new_references.graduand_status,
334: new_references.sur_for_course_cd,

Line 367: IF IGS_GR_VAL_GR.grdp_val_gr_unique(

363: -- Save the rowid of the current row.
364: -- Cannot call grdp_val_gr_unique because trigger
365: -- will be mutating.
366: -- validate graduand award uniqueness
367: IF IGS_GR_VAL_GR.grdp_val_gr_unique(
368: new_references.person_id,
369: new_references.create_dt,
370: new_references.grd_cal_type,
371: new_references.grd_ci_sequence_number,