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 APP_EXCEPTION

Line 77: App_Exception.Raise_Exception;

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;
80: Close cur_old_ref_values;
81:

Line 166: App_Exception.Raise_Exception;

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
169: IF IGS_GR_VAL_GR.grdp_val_gr_proxy(
170: new_references.person_id,

Line 177: App_Exception.Raise_Exception;

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;
180: IF p_inserting OR (p_updating AND
181: NVL(new_references.grd_cal_type, 'NULL') <> NVL(old_references.grd_cal_type, 'NULL') OR

Line 191: App_Exception.Raise_Exception;

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;
194: IF p_inserting OR (p_updating AND
195: new_references.graduand_status <> old_references.graduand_status) THEN

Line 202: App_Exception.Raise_Exception;

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
205: IF IGS_GR_VAL_GR.grdp_val_gr_gst(
206: new_references.person_id,

Line 219: App_Exception.Raise_Exception;

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;
222: IF p_inserting OR (p_updating AND
223: new_references.graduand_appr_status <> old_references.graduand_appr_status) THEN

Line 230: App_Exception.Raise_Exception;

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
233: IF IGS_GR_VAL_GR.grdp_val_gr_gas(
234: new_references.person_id,

Line 242: App_Exception.Raise_Exception;

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;
245: IF p_inserting OR (p_updating AND
246: NVL(new_references.course_cd,'NULL') <> NVL(old_references.course_cd,'NULL')) THEN

Line 255: App_Exception.Raise_Exception;

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;
258: END IF;
259: IF p_inserting OR (p_updating AND

Line 271: App_Exception.Raise_Exception;

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
274: IF IGS_GR_VAL_GR.grdp_val_gr_caw(
275: new_references.person_id,

Line 283: App_Exception.Raise_Exception;

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
286: -- HONORARY award
287: -- Validate the award type

Line 294: App_Exception.Raise_Exception;

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
297: IF igs_gr_val_awc.crsp_val_aw_closed(
298: new_references.award_cd,

Line 302: App_Exception.Raise_Exception;

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;
305: END IF;
306: IF p_inserting OR (p_updating AND

Line 319: App_Exception.Raise_Exception;

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;
322: IF p_inserting OR (p_updating AND
323: (new_references.person_id <> old_references.person_id OR

Line 340: App_Exception.Raise_Exception;

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;
343:
344:

Line 378: App_Exception.Raise_Exception;

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;
381: END IF;
382: END AfterRowInsertUpdate2;

Line 465: app_exception.raise_exception;

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;
468:
469: IF p_inserting OR ( p_updating AND new_references.sur_for_award_cd <> old_references.sur_for_award_cd ) THEN

Line 476: app_exception.raise_exception;

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;
479: END before_insert_update;
480:

Line 493: APP_EXCEPTION.RAISE_EXCEPTION;

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;
496:
497: IF (((old_references.award_course_cd = new_references.award_course_cd) AND

Line 512: APP_EXCEPTION.RAISE_EXCEPTION;

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;
515:
516: IF (((old_references.grd_cal_type = new_references.grd_cal_type) AND

Line 527: APP_EXCEPTION.RAISE_EXCEPTION;

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:
531: IF (((old_references.graduand_appr_status = new_references.graduand_appr_status)) OR

Line 540: APP_EXCEPTION.RAISE_EXCEPTION;

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;
543:
544: IF (((old_references.graduand_status = new_references.graduand_status)) OR

Line 553: APP_EXCEPTION.RAISE_EXCEPTION;

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;
556:
557:

Line 567: APP_EXCEPTION.RAISE_EXCEPTION;

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;
570:
571: IF (((old_references.proxy_award_person_id = new_references.proxy_award_person_id)) OR

Line 580: APP_EXCEPTION.RAISE_EXCEPTION;

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;
583:
584: IF (((old_references.person_id = new_references.person_id) AND

Line 596: APP_EXCEPTION.RAISE_EXCEPTION;

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;
599:
600: IF (((old_references.sur_for_course_cd = new_references.sur_for_course_cd) AND

Line 615: APP_EXCEPTION.RAISE_EXCEPTION;

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;
618:
619: END Check_Parent_Existance;

Line 631: APP_EXCEPTION.RAISE_EXCEPTION;

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;
634:
635: PROCEDURE CHECK_CONSTRAINTS(

Line 681: App_Exception.Raise_Exception ;

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:

Line 690: App_Exception.Raise_Exception ;

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:

Line 699: App_Exception.Raise_Exception ;

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 ;
702:
703: IF upper(Column_name) = 'S_GRADUAND_TYPE' OR COLUMN_NAME IS NULL THEN

Line 707: App_Exception.Raise_Exception ;

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 ;
710:
711: IF upper(Column_name) = 'AWARD_CD' OR COLUMN_NAME IS NULL THEN

Line 715: App_Exception.Raise_Exception ;

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:

Line 724: App_Exception.Raise_Exception ;

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:
727: END IF ;
728:

Line 734: App_Exception.Raise_Exception ;

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:

Line 743: App_Exception.Raise_Exception ;

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:

Line 752: App_Exception.Raise_Exception ;

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:

Line 761: App_Exception.Raise_Exception ;

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:

Line 770: App_Exception.Raise_Exception ;

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:
773: END IF ;
774: END CHECK_CONSTRAINTS;

Line 906: App_Exception.Raise_Exception;

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;
909: Close cur_rowid;
910:

Line 932: App_Exception.Raise_Exception;

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;
935: Close cur_rowid;
936:

Line 958: App_Exception.Raise_Exception;

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;
961: Close cur_rowid;
962:

Line 992: App_Exception.Raise_Exception;

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;
995: Close cur_rowid;
996:

Line 1020: App_Exception.Raise_Exception;

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;
1023: Close cur_rowid;
1024:

Line 1050: App_Exception.Raise_Exception;

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;
1053: Close cur_rowid;
1054:

Line 1176: App_Exception.Raise_Exception;

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;
1179: check_constraints;
1180: Check_Parent_Existance;

Line 1201: App_Exception.Raise_Exception;

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;
1204: check_constraints;
1205: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 1328: app_exception.raise_exception;

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:
1331: Before_DML (
1332: p_action => 'INSERT',

Line 1600: app_exception.raise_exception;

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;
1604:

Line 1708: app_exception.raise_exception;

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;
1712:

Line 1784: app_exception.raise_exception;

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:
1787: Before_DML (
1788: p_action => 'UPDATE',