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 APP_EXCEPTION

Line 53: App_Exception.Raise_Exception;

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

Line 124: app_exception.raise_exception;

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:
128: PROCEDURE Check_Parent_Existance AS

Line 164: App_Exception.Raise_Exception;

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
168: ((new_references.institution_code IS NULL))) THEN

Line 176: App_Exception.Raise_Exception;

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

Line 294: App_Exception.Raise_Exception;

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

Line 331: App_Exception.Raise_Exception;

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

Line 398: App_Exception.Raise_Exception;

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;
402: Check_Parent_Existance;

Line 418: App_Exception.Raise_Exception;

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

Line 527: app_exception.raise_exception;

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;
531: Before_DML(

Line 607: app_exception.raise_exception;

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;
611: END INSERT_ROW;

Line 649: app_exception.raise_exception;

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;
652: close c1;
653: if ((tlinfo.PERSON_ID = X_PERSON_ID)

Line 661: app_exception.raise_exception;

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;
665: Procedure UPDATE_ROW (

Line 713: app_exception.raise_exception;

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',
717: x_rowid=>X_ROWID,

Line 763: app_exception.raise_exception;

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
766: igs_sc_gen_001.unset_ctx('R');
767: END IF;

Line 788: app_exception.raise_exception;

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;
792: END UPDATE_ROW;

Line 872: app_exception.raise_exception;

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
875: igs_sc_gen_001.unset_ctx('R');
876: END IF;

Line 896: app_exception.raise_exception;

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;
900: end DELETE_ROW;