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_AD_OTHER_INST_PKG dependencies on IGS_GE_MSG_STACK

Line 52: IGS_GE_MSG_STACK.ADD;

48: Fetch cur_old_ref_values INTO old_references;
49: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
50: Close cur_old_ref_values;
51: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
52: IGS_GE_MSG_STACK.ADD;
53: App_Exception.Raise_Exception;
54: Return;
55: END IF;
56: Close cur_old_ref_values;

Line 123: IGS_GE_MSG_STACK.ADD;

119: ,new_references.person_id
120: ,new_references.new_institution
121: ) THEN
122: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
123: IGS_GE_MSG_STACK.ADD;
124: app_exception.raise_exception;
125: END IF;
126: END Check_Uniqueness ;
127:

Line 163: IGS_GE_MSG_STACK.ADD;

159: new_references.admission_appl_number
160: ) THEN
161: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
162: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_AD_APPL'));
163: IGS_GE_MSG_STACK.ADD;
164: App_Exception.Raise_Exception;
165: END IF;
166:
167: IF (((old_references.institution_code = new_references.institution_code)) OR

Line 175: IGS_GE_MSG_STACK.ADD;

171: new_references.institution_code
172: ) THEN
173: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');
174: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',FND_MESSAGE.GET_STRING('IGS','IGS_GE_INSTITUTION'));
175: IGS_GE_MSG_STACK.ADD;
176: App_Exception.Raise_Exception;
177: END IF;
178:
179: END Check_Parent_Existance;

Line 293: IGS_GE_MSG_STACK.ADD;

289: Fetch cur_rowid INTO lv_rowid;
290: IF (cur_rowid%FOUND) THEN
291: Close cur_rowid;
292: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AOI_ACAI_FK');
293: IGS_GE_MSG_STACK.ADD;
294: App_Exception.Raise_Exception;
295: Return;
296: END IF;
297: Close cur_rowid;

Line 330: IGS_GE_MSG_STACK.ADD;

326: Fetch cur_rowid INTO lv_rowid;
327: IF (cur_rowid%FOUND) THEN
328: Close cur_rowid;
329: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AOI_INST_FK');
330: IGS_GE_MSG_STACK.ADD;
331: App_Exception.Raise_Exception;
332: Return;
333: END IF;
334: Close cur_rowid;

Line 397: IGS_GE_MSG_STACK.ADD;

393: Null;
394: IF Get_Pk_For_Validation(
395: new_references.other_inst_id) THEN
396: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
397: IGS_GE_MSG_STACK.ADD;
398: App_Exception.Raise_Exception;
399: END IF;
400: Check_Uniqueness;
401: Check_Constraints;

Line 417: IGS_GE_MSG_STACK.ADD;

413: -- Call all the procedures related to Before Insert.
414: IF Get_PK_For_Validation (
415: new_references.other_inst_id) THEN
416: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
417: IGS_GE_MSG_STACK.ADD;
418: App_Exception.Raise_Exception;
419: END IF;
420: Check_Uniqueness;
421: Check_Constraints;

Line 526: IGS_GE_MSG_STACK.ADD;

522: X_PROGRAM_UPDATE_DATE := SYSDATE;
523: end if;
524: else
525: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
526: IGS_GE_MSG_STACK.ADD;
527: app_exception.raise_exception;
528: end if;
529:
530: X_OTHER_INST_ID := -1;

Line 606: IGS_GE_MSG_STACK.ADD;

602: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
603: -- that the ownerof policy function does not have privilege to access.
604: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
605: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
606: IGS_GE_MSG_STACK.ADD;
607: app_exception.raise_exception;
608: ELSE
609: RAISE;
610: END IF;

Line 647: IGS_GE_MSG_STACK.ADD;

643: open c1;
644: fetch c1 into tlinfo;
645: if (c1%notfound) then
646: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
647: IGS_GE_MSG_STACK.ADD;
648: close c1;
649: app_exception.raise_exception;
650: return;
651: end if;

Line 660: IGS_GE_MSG_STACK.ADD;

656: ) then
657: null;
658: else
659: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
660: IGS_GE_MSG_STACK.ADD;
661: app_exception.raise_exception;
662: end if;
663: return;
664: end LOCK_ROW;

Line 712: IGS_GE_MSG_STACK.ADD;

708: X_LAST_UPDATE_LOGIN := -1;
709: end if;
710: else
711: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
712: IGS_GE_MSG_STACK.ADD;
713: app_exception.raise_exception;
714: end if;
715: Before_DML(
716: p_action=>'UPDATE',

Line 761: igs_ge_msg_stack.add;

757: NEW_INSTITUTION = X_NEW_INSTITUTION
758: where ROWID = X_ROWID;
759: IF (sql%notfound) THEN
760: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
761: igs_ge_msg_stack.add;
762: igs_sc_gen_001.unset_ctx('R');
763: app_exception.raise_exception;
764: END IF;
765: IF (x_mode = 'S') THEN

Line 787: IGS_GE_MSG_STACK.ADD;

783: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
784: -- that the ownerof policy function does not have privilege to access.
785: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
786: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
787: IGS_GE_MSG_STACK.ADD;
788: app_exception.raise_exception;
789: ELSE
790: RAISE;
791: END IF;

Line 870: igs_ge_msg_stack.add;

866: delete from IGS_AD_OTHER_INST
867: where ROWID = X_ROWID;
868: if (sql%notfound) then
869: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
870: igs_ge_msg_stack.add;
871: igs_sc_gen_001.unset_ctx('R');
872: app_exception.raise_exception;
873: end if;
874: IF (x_mode = 'S') THEN

Line 895: IGS_GE_MSG_STACK.ADD;

891: -- 3) ORA-28111 (insufficient privilege to evaluate policy predicate) which is raised when Predicate has a subquery which contains objects
892: -- that the ownerof policy function does not have privilege to access.
893: FND_MESSAGE.SET_NAME ('IGS', 'IGS_SC_POLICY_EXCEPTION');
894: FND_MESSAGE.SET_TOKEN('ERR_CD',SQLCODE);
895: IGS_GE_MSG_STACK.ADD;
896: app_exception.raise_exception;
897: ELSE
898: RAISE;
899: END IF;