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

Line 44: App_Exception.Raise_Exception;

40: Fetch cur_old_ref_values INTO old_references;
41: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
42: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
43: IGS_GE_MSG_STACK.ADD;
44: App_Exception.Raise_Exception;
45: Close cur_old_ref_values;
46: Return;
47: END IF;
48: Close cur_old_ref_values;

Line 104: App_Exception.Raise_Exception;

100: IF upper(Column_Name) = 'SUBJECT_CD' OR Column_Name IS NULL THEN
101: IF new_references.subject_cd <> UPPER(new_references.subject_cd) 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: IF upper(Column_Name) = 'SUBJECT_DESC' OR Column_Name IS NULL THEN
108: IF new_references.subject_desc <> UPPER(new_references.subject_desc) THEN

Line 111: App_Exception.Raise_Exception;

107: IF upper(Column_Name) = 'SUBJECT_DESC' OR Column_Name IS NULL THEN
108: IF new_references.subject_desc <> UPPER(new_references.subject_desc) THEN
109: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
110: IGS_GE_MSG_STACK.ADD;
111: App_Exception.Raise_Exception;
112: END IF;
113: END IF;
114: IF upper(Column_Name) = 'SUBJECT_MARK' OR Column_Name IS NULL THEN
115: IF new_references.subject_mark <> UPPER(new_references.subject_mark) THEN

Line 118: App_Exception.Raise_Exception;

114: IF upper(Column_Name) = 'SUBJECT_MARK' OR Column_Name IS NULL THEN
115: IF new_references.subject_mark <> UPPER(new_references.subject_mark) THEN
116: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
117: IGS_GE_MSG_STACK.ADD;
118: App_Exception.Raise_Exception;
119: END IF;
120: END IF;
121: IF upper(Column_Name) = 'SUBJECT_MARK_LEVEL' OR Column_Name IS NULL THEN
122: IF new_references.subject_mark_level <> UPPER(new_references.subject_mark_level) THEN

Line 125: App_Exception.Raise_Exception;

121: IF upper(Column_Name) = 'SUBJECT_MARK_LEVEL' OR Column_Name IS NULL THEN
122: IF new_references.subject_mark_level <> UPPER(new_references.subject_mark_level) THEN
123: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
124: IGS_GE_MSG_STACK.ADD;
125: App_Exception.Raise_Exception;
126: END IF;
127: END IF;
128: IF upper(Column_Name) = 'SUBJECT_ASS_TYPE' OR Column_Name IS NULL THEN
129: IF new_references.subject_ass_type <> UPPER(new_references.subject_ass_type) THEN

Line 132: App_Exception.Raise_Exception;

128: IF upper(Column_Name) = 'SUBJECT_ASS_TYPE' OR Column_Name IS NULL THEN
129: IF new_references.subject_ass_type <> UPPER(new_references.subject_ass_type) THEN
130: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
131: IGS_GE_MSG_STACK.ADD;
132: App_Exception.Raise_Exception;
133: END IF;
134: END IF;
135: IF upper(Column_Name) = 'SUBJECT_WEIGHTING' OR Column_Name IS NULL THEN
136: IF new_references.subject_weighting <> UPPER(new_references.subject_weighting) THEN

Line 139: App_Exception.Raise_Exception;

135: IF upper(Column_Name) = 'SUBJECT_WEIGHTING' OR Column_Name IS NULL THEN
136: IF new_references.subject_weighting <> UPPER(new_references.subject_weighting) THEN
137: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
138: IGS_GE_MSG_STACK.ADD;
139: App_Exception.Raise_Exception;
140: END IF;
141: END IF;
142: IF upper(Column_Name) = 'SUBJECT_RESULT_YR' OR Column_Name IS NULL THEN
143: IF new_references.subject_result_yr < 1900 OR new_references.subject_result_yr > 2050 THEN

Line 146: App_Exception.Raise_Exception;

142: IF upper(Column_Name) = 'SUBJECT_RESULT_YR' OR Column_Name IS NULL THEN
143: IF new_references.subject_result_yr < 1900 OR new_references.subject_result_yr > 2050 THEN
144: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
145: IGS_GE_MSG_STACK.ADD;
146: App_Exception.Raise_Exception;
147: END IF;
148: END IF;
149: IF ((UPPER (column_name) = 'ASE_SEQUENCE_NUMBER') OR (column_name IS NULL)) THEN
150: IF ((new_references.ase_sequence_number < 1) OR (new_references.ase_sequence_number > 9999999999)) THEN

Line 153: App_Exception.Raise_Exception;

149: IF ((UPPER (column_name) = 'ASE_SEQUENCE_NUMBER') OR (column_name IS NULL)) THEN
150: IF ((new_references.ase_sequence_number < 1) OR (new_references.ase_sequence_number > 9999999999)) THEN
151: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
152: IGS_GE_MSG_STACK.ADD;
153: App_Exception.Raise_Exception;
154: END IF;
155: END IF;
156: END Check_Constraints;
157:

Line 171: App_Exception.Raise_Exception;

167: 'N'
168: ) THEN
169: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
170: IGS_GE_MSG_STACK.ADD;
171: App_Exception.Raise_Exception;
172: END IF;
173: END IF;
174:
175: IF (((old_references.person_id = new_references.person_id) AND

Line 187: App_Exception.Raise_Exception;

183: new_references.ase_sequence_number
184: ) THEN
185: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
186: IGS_GE_MSG_STACK.ADD;
187: App_Exception.Raise_Exception;
188: END IF;
189: END IF;
190:
191: END Check_Parent_Existance;

Line 244: App_Exception.Raise_Exception;

240: IF (cur_rowid%FOUND) THEN
241: Close cur_rowid;
242: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AUSES_ASEAT_FK');
243: IGS_GE_MSG_STACK.ADD;
244: App_Exception.Raise_Exception;
245: Return;
246: END IF;
247: Close cur_rowid;
248:

Line 272: App_Exception.Raise_Exception;

268: IF (cur_rowid%FOUND) THEN
269: Close cur_rowid;
270: Fnd_Message.Set_Name ('IGS', 'IGS_AD_AUSES_ASE_FK');
271: IGS_GE_MSG_STACK.ADD;
272: App_Exception.Raise_Exception;
273: Return;
274: END IF;
275: Close cur_rowid;
276:

Line 329: App_Exception.Raise_Exception;

325: new_references.subject_cd
326: ) THEN
327: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
328: IGS_GE_MSG_STACK.ADD;
329: App_Exception.Raise_Exception;
330: END IF;
331: Check_Constraints;
332: Check_Parent_Existance;
333: ELSIF (p_action = 'UPDATE') THEN

Line 345: App_Exception.Raise_Exception;

341: new_references.subject_cd
342: ) THEN
343: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
344: IGS_GE_MSG_STACK.ADD;
345: App_Exception.Raise_Exception;
346: END IF;
347: Check_Constraints;
348: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
349: Check_Constraints;

Line 418: app_exception.raise_exception;

414: end if;
415: else
416: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
417: IGS_GE_MSG_STACK.ADD;
418: app_exception.raise_exception;
419: end if;
420:
421: Before_DML(
422: p_action=>'INSERT',

Line 527: app_exception.raise_exception;

523: fetch c1 into tlinfo;
524: if (c1%notfound) then
525: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
526: IGS_GE_MSG_STACK.ADD;
527: app_exception.raise_exception;
528: close c1;
529: return;
530: end if;
531: close c1;

Line 556: app_exception.raise_exception;

552: null;
553: else
554: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
555: IGS_GE_MSG_STACK.ADD;
556: app_exception.raise_exception;
557: end if;
558: return;
559: end LOCK_ROW;
560:

Line 599: app_exception.raise_exception;

595: end if;
596: else
597: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
598: IGS_GE_MSG_STACK.ADD;
599: app_exception.raise_exception;
600: end if;
601:
602: Before_DML(
603: p_action=>'UPDATE',