DBA Data[Home] [Help]

APPS.IGS_GR_AWD_CRMN_PKG dependencies on IGS_GR_VAL_GAC

Line 115: IF IGS_GR_VAL_GAC.grdp_val_gac_insert(

111: v_message_name VARCHAR2(30);
112:
113: BEGIN
114: IF p_inserting THEN
115: IF IGS_GR_VAL_GAC.grdp_val_gac_insert(
116: new_references.person_id,
117: new_references.create_dt,
118: v_message_name) = FALSE THEN
119: Fnd_Message.Set_Name('IGS', v_message_name);

Line 127: IF IGS_GR_VAL_GAC.grdp_val_gac_iu(

123: END IF;
124:
125: IF p_inserting OR p_updating THEN
126: -- Validate the graduand award ceremony record may be inserted or updated
127: IF IGS_GR_VAL_GAC.grdp_val_gac_iu(
128: new_references.grd_cal_type,
129: new_references.grd_ci_sequence_number,
130: new_references.ceremony_number,
131: v_message_name) = FALSE THEN

Line 137: IF IGS_GR_VAL_GAC.grdp_val_gac_rqrd(

133: IGS_GE_MSG_STACK.ADD;
134: App_Exception.Raise_Exception;
135: END IF;
136: -- validate required details have been specified
137: IF IGS_GR_VAL_GAC.grdp_val_gac_rqrd(
138: new_references.award_course_cd,
139: new_references.award_crs_version_number,
140: new_references.award_cd,
141: new_references.us_group_number,

Line 154: IF IGS_GR_VAL_GAC.grdp_val_gac_susa(

150: -- validate unit set group
151: IF (NVL(new_references.us_group_number, 0) <>
152: NVL(old_references.us_group_number, 0)) THEN
153: IF (new_references.us_group_number IS NOT NULL) THEN
154: IF IGS_GR_VAL_GAC.grdp_val_gac_susa(
155: new_references.person_id,
156: new_references.create_dt,
157: new_references.grd_cal_type,
158: new_references.grd_ci_sequence_number,

Line 177: IF IGS_GR_VAL_GAC.grdp_val_msr_closed(

173: -- validate measurement codes
174: IF (NVL(new_references.academic_gown_size, 'NULL') <>
175: NVL(old_references.academic_gown_size, 'NULL')) THEN
176: IF (new_references.academic_gown_size IS NOT NULL) THEN
177: IF IGS_GR_VAL_GAC.grdp_val_msr_closed(
178: new_references.academic_gown_size,
179: v_message_name) = FALSE THEN
180: Fnd_Message.Set_Name('IGS', v_message_name);
181: IGS_GE_MSG_STACK.ADD;

Line 189: IF IGS_GR_VAL_GAC.grdp_val_msr_closed(

185: END IF;
186: IF (NVL(new_references.academic_hat_size, 'NULL') <>
187: NVL(old_references.academic_hat_size, 'NULL')) THEN
188: IF (new_references.academic_hat_size IS NOT NULL) THEN
189: IF IGS_GR_VAL_GAC.grdp_val_msr_closed(
190: new_references.academic_hat_size,
191: v_message_name) = FALSE THEN
192: Fnd_Message.Set_Name('IGS', v_message_name);
193: IGS_GE_MSG_STACK.ADD;

Line 204: IF IGS_GR_VAL_GAC.grdp_val_gac_grd_ci(

200: IF p_inserting OR (p_updating AND
201: new_references.grd_cal_type <> old_references.grd_cal_type OR
202: new_references.grd_ci_sequence_number <> old_references.grd_ci_sequence_number) THEN
203: -- validate the graduation calendar instance
204: IF IGS_GR_VAL_GAC.grdp_val_gac_grd_ci(
205: new_references.grd_cal_type,
206: new_references.grd_ci_sequence_number,
207: v_message_name) = FALSE THEN
208: Fnd_Message.Set_Name('IGS', v_message_name);

Line 317: IF IGS_GR_VAL_GAC.grdp_val_gac_seat(

313: NVL(old_references.graduand_seat_number, 'NULL')) THEN
314: IF (new_references.graduand_seat_number IS NOT NULL) THEN
315: -- validate graduand seat number
316: IF (NEW_REFERENCES.graduand_seat_number IS NOT NULL) THEN
317: IF IGS_GR_VAL_GAC.grdp_val_gac_seat(
318: NEW_REFERENCES.person_id,
319: NEW_REFERENCES.grd_cal_type,
320: NEW_REFERENCES.grd_ci_sequence_number,
321: NEW_REFERENCES.ceremony_number,

Line 331: IF IGS_GR_VAL_GAC.grdp_val_gac_order(

327: END IF;
328: END IF;
329: -- validate order in presentation
330: IF (NEW_REFERENCES.order_in_presentation IS NOT NULL) THEN
331: IF IGS_GR_VAL_GAC.grdp_val_gac_order(
332: NEW_REFERENCES.person_id,
333: NEW_REFERENCES.grd_cal_type,
334: NEW_REFERENCES.grd_ci_sequence_number,
335: NEW_REFERENCES.ceremony_number,

Line 357: IF IGS_GR_VAL_GAC.grdp_val_gac_seat(

353: IF v_rowid_saved = FALSE THEN
354:
355: -- validate graduand seat number
356: IF (NEW_REFERENCES.graduand_seat_number IS NOT NULL) THEN
357: IF IGS_GR_VAL_GAC.grdp_val_gac_seat(
358: NEW_REFERENCES.person_id,
359: NEW_REFERENCES.grd_cal_type,
360: NEW_REFERENCES.grd_ci_sequence_number,
361: NEW_REFERENCES.ceremony_number,