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_GE_MSG_STACK

Line 76: IGS_GE_MSG_STACK.ADD;

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

Line 165: IGS_GE_MSG_STACK.ADD;

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
169: IF IGS_GR_VAL_GR.grdp_val_gr_proxy(

Line 176: IGS_GE_MSG_STACK.ADD;

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

Line 190: IGS_GE_MSG_STACK.ADD;

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

Line 201: IGS_GE_MSG_STACK.ADD;

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
205: IF IGS_GR_VAL_GR.grdp_val_gr_gst(

Line 218: IGS_GE_MSG_STACK.ADD;

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

Line 229: IGS_GE_MSG_STACK.ADD;

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
233: IF IGS_GR_VAL_GR.grdp_val_gr_gas(

Line 241: IGS_GE_MSG_STACK.ADD;

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

Line 254: IGS_GE_MSG_STACK.ADD;

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

Line 270: IGS_GE_MSG_STACK.ADD;

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
274: IF IGS_GR_VAL_GR.grdp_val_gr_caw(

Line 282: IGS_GE_MSG_STACK.ADD;

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
286: -- HONORARY award

Line 293: IGS_GE_MSG_STACK.ADD;

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
297: IF igs_gr_val_awc.crsp_val_aw_closed(

Line 301: IGS_GE_MSG_STACK.ADD;

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

Line 318: IGS_GE_MSG_STACK.ADD;

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

Line 339: IGS_GE_MSG_STACK.ADD;

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

Line 377: IGS_GE_MSG_STACK.ADD;

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

Line 464: igs_ge_msg_stack.add;

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

Line 475: igs_ge_msg_stack.add;

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

Line 492: IGS_GE_MSG_STACK.ADD;

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

Line 511: IGS_GE_MSG_STACK.ADD;

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

Line 539: IGS_GE_MSG_STACK.ADD;

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

Line 552: IGS_GE_MSG_STACK.ADD;

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

Line 566: IGS_GE_MSG_STACK.ADD;

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

Line 579: IGS_GE_MSG_STACK.ADD;

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

Line 595: IGS_GE_MSG_STACK.ADD;

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

Line 614: IGS_GE_MSG_STACK.ADD;

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

Line 630: IGS_GE_MSG_STACK.ADD;

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

Line 680: IGS_GE_MSG_STACK.ADD;

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 ;

Line 689: IGS_GE_MSG_STACK.ADD;

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 ;

Line 698: IGS_GE_MSG_STACK.ADD;

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

Line 706: IGS_GE_MSG_STACK.ADD;

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

Line 714: IGS_GE_MSG_STACK.ADD;

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 ;

Line 723: IGS_GE_MSG_STACK.ADD;

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

Line 733: IGS_GE_MSG_STACK.ADD;

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 ;

Line 742: IGS_GE_MSG_STACK.ADD;

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 ;

Line 751: IGS_GE_MSG_STACK.ADD;

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 ;

Line 760: IGS_GE_MSG_STACK.ADD;

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 ;

Line 769: IGS_GE_MSG_STACK.ADD;

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

Line 905: IGS_GE_MSG_STACK.ADD;

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

Line 931: IGS_GE_MSG_STACK.ADD;

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

Line 957: IGS_GE_MSG_STACK.ADD;

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

Line 991: IGS_GE_MSG_STACK.ADD;

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

Line 1019: IGS_GE_MSG_STACK.ADD;

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

Line 1049: IGS_GE_MSG_STACK.ADD;

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

Line 1175: IGS_GE_MSG_STACK.ADD;

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

Line 1200: IGS_GE_MSG_STACK.ADD;

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;
1204: check_constraints;

Line 1327: IGS_GE_MSG_STACK.ADD;

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:
1331: Before_DML (

Line 1783: IGS_GE_MSG_STACK.ADD;

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:
1787: Before_DML (