[Home] [Help]
71: Open cur_old_ref_values;
72: Fetch cur_old_ref_values INTO old_references;
73: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
74: Close cur_old_ref_values;
75: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED1');
76: IGS_GE_MSG_STACK.ADD;
77: App_Exception.Raise_Exception;
78: Return;
79: END IF;
160: p_sur_for_course_cd => new_references.sur_for_course_cd,
161: p_sur_for_crs_version_number => new_references.sur_for_crs_version_number,
162: p_sur_for_award_cd => new_references.sur_for_award_cd,
163: p_message_name => v_message_name) = FALSE THEN
164: Fnd_Message.Set_Name('IGS', v_message_name);
165: IGS_GE_MSG_STACK.ADD;
166: App_Exception.Raise_Exception;
167: END IF;
168: -- Validate proxy award details
171: new_references.s_graduand_type,
172: new_references.proxy_award_ind,
173: new_references.proxy_award_person_id,
174: v_message_name) = FALSE THEN
175: Fnd_Message.Set_Name('IGS', v_message_name);
176: IGS_GE_MSG_STACK.ADD;
177: App_Exception.Raise_Exception;
178: END IF;
179: END IF;
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);
190: IGS_GE_MSG_STACK.ADD;
191: App_Exception.Raise_Exception;
192: END IF;
193: END IF;
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;
202: App_Exception.Raise_Exception;
203: END IF;
204: -- Validate the graduand status
213: new_references.award_cd,
214: new_references.graduand_status,
215: old_references.graduand_status,
216: v_message_name) = FALSE THEN
217: Fnd_Message.Set_Name('IGS', v_message_name);
218: IGS_GE_MSG_STACK.ADD;
219: App_Exception.Raise_Exception;
220: END IF;
221: END IF;
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;
230: App_Exception.Raise_Exception;
231: END IF;
232: -- Validate the graduand approval status
236: new_references.graduand_status,
237: new_references.graduand_appr_status,
238: old_references.graduand_appr_status,
239: v_message_name) = FALSE THEN
240: Fnd_Message.Set_Name('IGS', v_message_name);
241: IGS_GE_MSG_STACK.ADD;
242: App_Exception.Raise_Exception;
243: END IF;
244: END IF;
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);
254: IGS_GE_MSG_STACK.ADD;
255: App_Exception.Raise_Exception;
256: END IF;
257: END IF;
265: IF IGS_GR_VAL_AWC.GRDP_VAL_AWARD_TYPE(
266: new_references.award_cd,
267: 'COURSE',
268: v_message_name) = FALSE THEN
269: Fnd_Message.Set_Name('IGS', v_message_name);
270: IGS_GE_MSG_STACK.ADD;
271: App_Exception.Raise_Exception;
272: END IF;
273: -- Validate the graduand course award
277: new_references.award_course_cd,
278: new_references.award_crs_version_number,
279: new_references.award_cd,
280: v_message_name) = FALSE THEN
281: Fnd_Message.Set_Name('IGS', v_message_name);
282: IGS_GE_MSG_STACK.ADD;
283: App_Exception.Raise_Exception;
284: END IF;
285: ELSE
288: IF IGS_GR_VAL_AWC.GRDP_VAL_AWARD_TYPE(
289: new_references.award_cd,
290: 'HONORARY',
291: v_message_name) = FALSE THEN
292: Fnd_Message.Set_Name('IGS', v_message_name);
293: IGS_GE_MSG_STACK.ADD;
294: App_Exception.Raise_Exception;
295: END IF;
296: -- Validate award is not closed
296: -- Validate award is not closed
297: IF igs_gr_val_awc.crsp_val_aw_closed(
298: new_references.award_cd,
299: v_message_name) = FALSE THEN
300: Fnd_Message.Set_Name('IGS', v_message_name);
301: IGS_GE_MSG_STACK.ADD;
302: App_Exception.Raise_Exception;
303: END IF;
304: END IF;
313: new_references.graduand_status,
314: new_references.s_graduand_type,
315: old_references.s_graduand_type,
316: v_message_name) = FALSE THEN
317: Fnd_Message.Set_Name('IGS', v_message_name);
318: IGS_GE_MSG_STACK.ADD;
319: App_Exception.Raise_Exception;
320: END IF;
321: END IF;
334: new_references.sur_for_course_cd,
335: new_references.sur_for_crs_version_number,
336: new_references.sur_for_award_cd,
337: v_message_name) = FALSE THEN
338: Fnd_Message.Set_Name('IGS', v_message_name);
339: IGS_GE_MSG_STACK.ADD;
340: App_Exception.Raise_Exception;
341: END IF;
342: END IF;
372: new_references.award_course_cd,
373: new_references.award_crs_version_number,
374: new_references.award_cd,
375: v_message_name) = FALSE THEN
376: Fnd_Message.Set_Name('IGS', v_message_name);
377: IGS_GE_MSG_STACK.ADD;
378: App_Exception.Raise_Exception;
379: END IF;
380: v_rowid_saved := TRUE;
459: OPEN c_closed_ind(new_references.award_cd,new_references.award_course_cd, new_references.award_crs_version_number);
460: FETCH c_closed_ind INTO l_c_closed_ind;
461: CLOSE c_closed_ind;
462: IF l_c_closed_ind = 'Y' THEN
463: fnd_message.set_name('IGS','IGS_PS_AWD_CD_CLOSED');
464: igs_ge_msg_stack.add;
465: app_exception.raise_exception;
466: END IF;
467: END IF;
470: OPEN c_closed_ind(new_references.sur_for_award_cd, new_references.sur_for_course_cd, new_references.sur_for_crs_version_number);
471: FETCH c_closed_ind INTO l_c_closed_ind;
472: CLOSE c_closed_ind;
473: IF l_c_closed_ind = 'Y' THEN
474: fnd_message.set_name('IGS','IGS_PS_AWD_CD_CLOSED');
475: igs_ge_msg_stack.add;
476: app_exception.raise_exception;
477: END IF;
478: END IF;
487: ELSE
488: IF NOT IGS_PS_AWD_PKG.Get_PK_For_Validation (
489: new_references.award_cd
490: ) THEN
491: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED2');
492: IGS_GE_MSG_STACK.ADD;
493: APP_EXCEPTION.RAISE_EXCEPTION;
494: END IF;
495: END IF;
506: new_references.award_course_cd,
507: new_references.award_crs_version_number,
508: new_references.award_cd
509: ) THEN
510: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED3');
511: IGS_GE_MSG_STACK.ADD;
512: APP_EXCEPTION.RAISE_EXCEPTION;
513: END IF;
514: END IF;
522: IF NOT IGS_GR_CRMN_ROUND_PKG.Get_PK_For_Validation (
523: new_references.grd_cal_type,
524: new_references.grd_ci_sequence_number
525: ) THEN
526: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED4');
527: APP_EXCEPTION.RAISE_EXCEPTION;
528: END IF;
529: END IF;
530:
534: ELSE
535: IF NOT IGS_GR_APRV_STAT_PKG.Get_PK_For_Validation (
536: new_references.graduand_appr_status
537: ) THEN
538: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED5');
539: IGS_GE_MSG_STACK.ADD;
540: APP_EXCEPTION.RAISE_EXCEPTION;
541: END IF;
542: END IF;
547: ELSE
548: IF NOT IGS_GR_STAT_PKG.Get_PK_For_Validation (
549: new_references.graduand_status
550: ) THEN
551: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED6');
552: IGS_GE_MSG_STACK.ADD;
553: APP_EXCEPTION.RAISE_EXCEPTION;
554: END IF;
555: END IF;
561: ELSE
562: IF NOT IGS_PE_PERSON_PKG.Get_PK_For_Validation (
563: new_references.person_id
564: ) THEN
565: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED7');
566: IGS_GE_MSG_STACK.ADD;
567: APP_EXCEPTION.RAISE_EXCEPTION;
568: END IF;
569: END IF;
574: ELSE
575: IF NOT IGS_PE_PERSON_PKG.Get_PK_For_Validation (
576: new_references.proxy_award_person_id
577: ) THEN
578: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED8');
579: IGS_GE_MSG_STACK.ADD;
580: APP_EXCEPTION.RAISE_EXCEPTION;
581: END IF;
582: END IF;
590: IF NOT IGS_EN_STDNT_PS_ATT_PKG.Get_PK_For_Validation (
591: new_references.person_id,
592: new_references.course_cd
593: ) THEN
594: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED9');
595: IGS_GE_MSG_STACK.ADD;
596: APP_EXCEPTION.RAISE_EXCEPTION;
597: END IF;
598: END IF;
609: new_references.sur_for_course_cd,
610: new_references.sur_for_crs_version_number,
611: new_references.sur_for_award_cd
612: ) THEN
613: FND_MESSAGE.SET_NAME ('FND', 'FORM_RECORD_DELETED0');
614: IGS_GE_MSG_STACK.ADD;
615: APP_EXCEPTION.RAISE_EXCEPTION;
616: END IF;
617: END IF;
625: NEW_REFERENCES.create_dt,
626: NEW_REFERENCES.award_course_cd,
627: NEW_REFERENCES.award_crs_version_number,
628: NEW_REFERENCES.award_cd) THEN
629: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_MULTI_ORG_DUP_REC');
630: IGS_GE_MSG_STACK.ADD;
631: APP_EXCEPTION.RAISE_EXCEPTION;
632: END IF;
633: END Check_Uniqueness;
675: END IF ;
676:
677: IF upper(Column_name) = 'GRD_CI_SEQUENCE_NUMBER' OR COLUMN_NAME IS NULL THEN
678: IF new_references.GRD_CI_SEQUENCE_NUMBER < 1 OR new_references.GRD_CI_SEQUENCE_NUMBER > 999999 then
679: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
680: IGS_GE_MSG_STACK.ADD;
681: App_Exception.Raise_Exception ;
682: END IF;
683:
684: END IF ;
685:
686: IF upper(Column_name) = 'PROXY_AWARD_IND' OR COLUMN_NAME IS NULL THEN
687: IF new_references.PROXY_AWARD_IND not in ('Y','N') then
688: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
689: IGS_GE_MSG_STACK.ADD;
690: App_Exception.Raise_Exception ;
691: END IF;
692:
693: END IF ;
694:
695: IF upper(Column_name) = 'CONVOCATION_MEMBERSHIP_IND' OR COLUMN_NAME IS NULL THEN
696: IF new_references.CONVOCATION_MEMBERSHIP_IND not in ('Y','N') then
697: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
698: IGS_GE_MSG_STACK.ADD;
699: App_Exception.Raise_Exception ;
700: END IF;
701: END IF ;
701: END IF ;
702:
703: IF upper(Column_name) = 'S_GRADUAND_TYPE' OR COLUMN_NAME IS NULL THEN
704: IF new_references.S_GRADUAND_TYPE not in ( 'ATTENDING' , 'INABSENTIA' , 'ARTICULATE' , 'DEFERRED' , 'UNKNOWN' , 'DECLINED' ) then
705: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
706: IGS_GE_MSG_STACK.ADD;
707: App_Exception.Raise_Exception ;
708: END IF;
709: END IF ;
709: END IF ;
710:
711: IF upper(Column_name) = 'AWARD_CD' OR COLUMN_NAME IS NULL THEN
712: IF new_references.AWARD_CD<> upper(new_references.AWARD_CD) then
713: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
714: IGS_GE_MSG_STACK.ADD;
715: App_Exception.Raise_Exception ;
716: END IF;
717:
718: END IF ;
719:
720: IF upper(Column_name) = 'AWARD_COURSE_CD' OR COLUMN_NAME IS NULL THEN
721: IF new_references.AWARD_COURSE_CD<> upper(new_references.AWARD_COURSE_CD) then
722: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
723: IGS_GE_MSG_STACK.ADD;
724: App_Exception.Raise_Exception ;
725: END IF;
726:
728:
729:
730: IF upper(Column_name) = 'COURSE_CD' OR COLUMN_NAME IS NULL THEN
731: IF new_references.COURSE_CD<> upper(new_references.COURSE_CD) then
732: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
733: IGS_GE_MSG_STACK.ADD;
734: App_Exception.Raise_Exception ;
735: END IF;
736:
737: END IF ;
738:
739: IF upper(Column_name) = 'PROXY_AWARD_IND' OR COLUMN_NAME IS NULL THEN
740: IF new_references.PROXY_AWARD_IND<> upper(new_references.PROXY_AWARD_IND) then
741: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
742: IGS_GE_MSG_STACK.ADD;
743: App_Exception.Raise_Exception ;
744: END IF;
745:
746: END IF ;
747:
748: IF upper(Column_name) = 'SUR_FOR_AWARD_CD' OR COLUMN_NAME IS NULL THEN
749: IF new_references.SUR_FOR_AWARD_CD<> upper(new_references.SUR_FOR_AWARD_CD) then
750: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
751: IGS_GE_MSG_STACK.ADD;
752: App_Exception.Raise_Exception ;
753: END IF;
754:
755: END IF ;
756:
757: IF upper(Column_name) = 'SUR_FOR_COURSE_CD' OR COLUMN_NAME IS NULL THEN
758: IF new_references.SUR_FOR_COURSE_CD<> upper(new_references.SUR_FOR_COURSE_CD) then
759: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
760: IGS_GE_MSG_STACK.ADD;
761: App_Exception.Raise_Exception ;
762: END IF;
763:
764: END IF ;
765:
766: IF upper(Column_name) = 'S_GRADUAND_TYPE' OR COLUMN_NAME IS NULL THEN
767: IF new_references.S_GRADUAND_TYPE<> upper(new_references.S_GRADUAND_TYPE) then
768: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
769: IGS_GE_MSG_STACK.ADD;
770: App_Exception.Raise_Exception ;
771: END IF;
772:
900: Open cur_rowid;
901: Fetch cur_rowid INTO lv_rowid;
902: IF (cur_rowid%FOUND) THEN
903: Close cur_rowid;
904: Fnd_Message.Set_Name ('IGS', 'IGS_GR_GR_CRD_FK');
905: IGS_GE_MSG_STACK.ADD;
906: App_Exception.Raise_Exception;
907: Return;
908: END IF;
926: Open cur_rowid;
927: Fetch cur_rowid INTO lv_rowid;
928: IF (cur_rowid%FOUND) THEN
929: Close cur_rowid;
930: Fnd_Message.Set_Name ('IGS', 'IGS_GR_GR_GAS_FK');
931: IGS_GE_MSG_STACK.ADD;
932: App_Exception.Raise_Exception;
933: Return;
934: END IF;
952: Open cur_rowid;
953: Fetch cur_rowid INTO lv_rowid;
954: IF (cur_rowid%FOUND) THEN
955: Close cur_rowid;
956: Fnd_Message.Set_Name ('IGS', 'IGS_GR_GR_GST_FK');
957: IGS_GE_MSG_STACK.ADD;
958: App_Exception.Raise_Exception;
959: Return;
960: END IF;
986: Open cur_rowid;
987: Fetch cur_rowid INTO lv_rowid;
988: IF (cur_rowid%FOUND) THEN
989: Close cur_rowid;
990: Fnd_Message.Set_Name ('IGS', 'IGS_GR_GR_PE_FK');
991: IGS_GE_MSG_STACK.ADD;
992: App_Exception.Raise_Exception;
993: Return;
994: END IF;
1014: Open cur_rowid;
1015: Fetch cur_rowid INTO lv_rowid;
1016: IF (cur_rowid%FOUND) THEN
1017: Close cur_rowid;
1018: Fnd_Message.Set_Name ('IGS', 'IGS_GR_GR_SCA_FK');
1019: IGS_GE_MSG_STACK.ADD;
1020: App_Exception.Raise_Exception;
1021: Return;
1022: END IF;
1044: Open cur_rowid;
1045: Fetch cur_rowid INTO lv_rowid;
1046: IF (cur_rowid%FOUND) THEN
1047: Close cur_rowid;
1048: Fnd_Message.Set_Name ('IGS', 'IGS_GR_SPAA_AW_CCD_FK');
1049: IGS_GE_MSG_STACK.ADD;
1050: App_Exception.Raise_Exception;
1051: Return;
1052: END IF;
1170: IF GET_PK_FOR_VALIDATION(
1171: NEW_REFERENCES.person_id,
1172: NEW_REFERENCES.create_dt
1173: ) THEN
1174: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
1175: IGS_GE_MSG_STACK.ADD;
1176: App_Exception.Raise_Exception;
1177: END IF;
1178: check_uniqueness;
1195: IF GET_PK_FOR_VALIDATION(
1196: NEW_REFERENCES.person_id,
1197: NEW_REFERENCES.create_dt
1198: ) THEN
1199: Fnd_Message.Set_Name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
1200: IGS_GE_MSG_STACK.ADD;
1201: App_Exception.Raise_Exception;
1202: END IF;
1203: check_uniqueness;
1322: else
1323: X_PROGRAM_UPDATE_DATE := SYSDATE;
1324: end if;
1325: else
1326: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
1327: IGS_GE_MSG_STACK.ADD;
1328: app_exception.raise_exception;
1329: end if;
1330:
1595: open c1;
1596: fetch c1 into tlinfo;
1597: if (c1%notfound) then
1598: close c1;
1599: fnd_message.set_name('FND', 'FORM_RECORD_DELETED11');
1600: app_exception.raise_exception;
1601: return;
1602: end if;
1603: close c1;
1703: AND (X_ATTRIBUTE20 IS NULL)))
1704: ) then
1705: null;
1706: else
1707: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1708: app_exception.raise_exception;
1709: end if;
1710: return;
1711: end LOCK_ROW;
1778: if X_LAST_UPDATE_LOGIN is NULL then
1779: X_LAST_UPDATE_LOGIN := -1;
1780: end if;
1781: else
1782: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
1783: IGS_GE_MSG_STACK.ADD;
1784: app_exception.raise_exception;
1785: end if;
1786: