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_PS_FACLTY_DEGRS_PKG dependencies on APP_EXCEPTION

Line 51: App_Exception.Raise_Exception;

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

Line 104: APP_EXCEPTION.RAISE_EXCEPTION;

100: IF UPPER(column_name) = 'PROGRAM' OR column_name IS NULL THEN
101: IF new_references.program <> UPPER(new_references.program) THEN
102: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
103: IGS_GE_MSG_STACK.ADD;
104: APP_EXCEPTION.RAISE_EXCEPTION;
105: END IF;
106: END IF;
107:
108: END Check_Constraints;

Line 130: app_exception.raise_exception;

126: ,new_references.program
127: ) THEN
128: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
129: IGS_GE_MSG_STACK.ADD;
130: app_exception.raise_exception;
131: END IF;
132: END Check_Uniqueness ;
133: PROCEDURE Check_Parent_Existance AS
134: /*************************************************************

Line 155: App_Exception.Raise_Exception;

151: new_references.degree_cd
152: ) THEN
153: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
154: IGS_GE_MSG_STACK.ADD;
155: App_Exception.Raise_Exception;
156: END IF;
157:
158: IF (((old_references.institution_cd = new_references.institution_cd)) OR
159: ((new_references.institution_cd IS NULL))) THEN

Line 166: App_Exception.Raise_Exception;

162: new_references.institution_cd
163: ) THEN
164: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
165: IGS_GE_MSG_STACK.ADD;
166: App_Exception.Raise_Exception;
167: END IF;
168:
169: IF (((old_references.person_id = new_references.person_id)) OR
170: ((new_references.person_id IS NULL))) THEN

Line 177: App_Exception.Raise_Exception;

173: new_references.person_id
174: ) THEN
175: Fnd_Message.Set_Name ('FND','FORM_RECORD_DELETED');
176: IGS_GE_MSG_STACK.ADD;
177: App_Exception.Raise_Exception;
178: END IF;
179:
180: END Check_Parent_Existance;
181:

Line 289: App_Exception.Raise_Exception;

285: IF (cur_rowid%FOUND) THEN
286: Close cur_rowid;
287: Fnd_Message.Set_Name ('IGS', 'IGS_PS_FD_DEG_FK');
288: IGS_GE_MSG_STACK.ADD;
289: App_Exception.Raise_Exception;
290: Return;
291: END IF;
292: Close cur_rowid;
293:

Line 326: App_Exception.Raise_Exception;

322: IF (cur_rowid%FOUND) THEN
323: Close cur_rowid;
324: Fnd_Message.Set_Name ('IGS', 'IGS_PS_FD_INS_FK');
325: IGS_GE_MSG_STACK.ADD;
326: App_Exception.Raise_Exception;
327: Return;
328: END IF;
329: Close cur_rowid;
330:

Line 363: App_Exception.Raise_Exception;

359: IF (cur_rowid%FOUND) THEN
360: Close cur_rowid;
361: Fnd_Message.Set_Name ('IGS', 'IGS_PS_FD_PE_FK');
362: IGS_GE_MSG_STACK.ADD;
363: App_Exception.Raise_Exception;
364: Return;
365: END IF;
366: Close cur_rowid;
367:

Line 421: App_Exception.Raise_Exception;

417: IF Get_Pk_For_Validation(
418: new_references.faclty_degrd_id) THEN
419: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
420: IGS_GE_MSG_STACK.ADD;
421: App_Exception.Raise_Exception;
422: END IF;
423: Check_Uniqueness;
424: Check_Constraints;
425: Check_Parent_Existance;

Line 441: App_Exception.Raise_Exception;

437: IF Get_PK_For_Validation (
438: new_references.faclty_degrd_id) THEN
439: Fnd_Message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
440: IGS_GE_MSG_STACK.ADD;
441: App_Exception.Raise_Exception;
442: END IF;
443: Check_Uniqueness;
444: Check_Constraints;
445: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 531: app_exception.raise_exception;

527: end if;
528: else
529: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
530: IGS_GE_MSG_STACK.ADD;
531: app_exception.raise_exception;
532: end if;
533: SELECT IGS_PS_FACLTY_DEGRD_ID_S.nextval INTO x_FACLTY_DEGRD_ID FROM dual;
534: Before_DML(
535: p_action=>'INSERT',

Line 597: app_exception.raise_exception;

593: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
594: fnd_message.set_token ('ERR_CD', SQLCODE);
595: igs_ge_msg_stack.add;
596: igs_sc_gen_001.unset_ctx('R');
597: app_exception.raise_exception;
598: ELSE
599: igs_sc_gen_001.unset_ctx('R');
600: RAISE;
601: END IF;

Line 640: app_exception.raise_exception;

636: if (c1%notfound) then
637: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
638: IGS_GE_MSG_STACK.ADD;
639: close c1;
640: app_exception.raise_exception;
641: return;
642: end if;
643: close c1;
644: if ( ( tlinfo.PERSON_ID = X_PERSON_ID)

Line 654: app_exception.raise_exception;

650: null;
651: else
652: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
653: IGS_GE_MSG_STACK.ADD;
654: app_exception.raise_exception;
655: end if;
656: return;
657: end LOCK_ROW;
658: Procedure UPDATE_ROW (

Line 699: app_exception.raise_exception;

695: end if;
696: else
697: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
698: IGS_GE_MSG_STACK.ADD;
699: app_exception.raise_exception;
700: end if;
701: Before_DML(
702: p_action=>'UPDATE',
703: x_rowid=>X_ROWID,

Line 732: app_exception.raise_exception;

728: if (sql%notfound) then
729: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
730: igs_ge_msg_stack.add;
731: igs_sc_gen_001.unset_ctx('R');
732: app_exception.raise_exception;
733: end if;
734: IF (x_mode = 'S') THEN
735: igs_sc_gen_001.unset_ctx('R');
736: END IF;

Line 750: app_exception.raise_exception;

746: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
747: fnd_message.set_token ('ERR_CD', SQLCODE);
748: igs_ge_msg_stack.add;
749: igs_sc_gen_001.unset_ctx('R');
750: app_exception.raise_exception;
751: ELSE
752: igs_sc_gen_001.unset_ctx('R');
753: RAISE;
754: END IF;

Line 837: app_exception.raise_exception;

833: if (sql%notfound) then
834: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
835: igs_ge_msg_stack.add;
836: igs_sc_gen_001.unset_ctx('R');
837: app_exception.raise_exception;
838: end if;
839: IF (x_mode = 'S') THEN
840: igs_sc_gen_001.unset_ctx('R');
841: END IF;