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

Line 44: App_Exception.Raise_Exception;

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

Line 114: App_Exception.Raise_Exception;

110: v_version_number,
111: v_message_name) = FALSE THEN
112: Fnd_Message.Set_Name('IGS',v_message_name);
113: IGS_GE_MSG_STACK.ADD;
114: App_Exception.Raise_Exception;
115: END IF;
116:
117:
118: END BeforeRowInsertUpdateDelete1;

Line 148: App_Exception.Raise_Exception;

144: column_name is null Then
145: IF ( new_references.attendance_mode <> UPPER(new_references.attendance_mode) ) Then
146: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
147: IGS_GE_MSG_STACK.ADD;
148: App_Exception.Raise_Exception;
149: END IF;
150: END IF;
151:
152: IF upper(column_name) = 'ATTENDANCE_TYPE' OR

Line 157: App_Exception.Raise_Exception;

153: column_name is null Then
154: IF ( new_references.attendance_type <> UPPER(new_references.attendance_type) ) Then
155: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
156: IGS_GE_MSG_STACK.ADD;
157: App_Exception.Raise_Exception;
158: END IF;
159: END IF;
160:
161: IF upper(column_name) = 'CAL_TYPE' OR

Line 166: App_Exception.Raise_Exception;

162: column_name is null Then
163: IF ( new_references.cal_type <> UPPER(new_references.cal_type) ) Then
164: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
165: IGS_GE_MSG_STACK.ADD;
166: App_Exception.Raise_Exception;
167: END IF;
168: END IF;
169:
170: IF upper(column_name) = 'COURSE_CD' OR

Line 175: App_Exception.Raise_Exception;

171: column_name is null Then
172: IF ( new_references.course_cd <> UPPER(new_references.course_cd) ) Then
173: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
174: IGS_GE_MSG_STACK.ADD;
175: App_Exception.Raise_Exception;
176: END IF;
177: END IF;
178:
179: IF upper(column_name) = 'LOCATION_CD' OR

Line 184: App_Exception.Raise_Exception;

180: column_name is null Then
181: IF ( new_references.location_cd <> UPPER(new_references.location_cd) ) Then
182: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
183: IGS_GE_MSG_STACK.ADD;
184: App_Exception.Raise_Exception;
185: END IF;
186: END IF;
187:
188: IF upper(column_name) = 'CRS_NOTE_TYPE' OR

Line 193: App_Exception.Raise_Exception;

189: column_name is null Then
190: IF ( new_references.crs_note_type <> UPPER(new_references.crs_note_type) ) Then
191: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
192: IGS_GE_MSG_STACK.ADD;
193: App_Exception.Raise_Exception;
194: END IF;
195: END IF;
196:
197: END Check_Constraints;

Line 211: App_Exception.Raise_Exception;

207: new_references.crs_note_type
208: ) THEN
209: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
210: IGS_GE_MSG_STACK.ADD;
211: App_Exception.Raise_Exception;
212: END IF;
213: END IF;
214:
215: IF (((old_references.course_cd = new_references.course_cd) AND

Line 239: App_Exception.Raise_Exception;

235: new_references.attendance_type
236: ) THEN
237: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
238: IGS_GE_MSG_STACK.ADD;
239: App_Exception.Raise_Exception;
240: END IF;
241: END IF;
242:
243: IF (((old_references.coo_id = new_references.coo_id)) OR

Line 252: App_Exception.Raise_Exception;

248: new_references.coo_id
249: ) THEN
250: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
251: IGS_GE_MSG_STACK.ADD;
252: App_Exception.Raise_Exception;
253: END IF;
254: END IF;
255:
256: IF (((old_references.reference_number = new_references.reference_number)) OR

Line 265: App_Exception.Raise_Exception;

261: new_references.reference_number
262: ) THEN
263: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
264: IGS_GE_MSG_STACK.ADD;
265: App_Exception.Raise_Exception;
266: END IF;
267: END IF;
268:
269: END Check_Parent_Existance;

Line 329: App_Exception.Raise_Exception;

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

Line 365: App_Exception.Raise_Exception;

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

Line 391: App_Exception.Raise_Exception;

387: IF (cur_rowid%FOUND) THEN
388: Close cur_rowid;
389: Fnd_Message.Set_Name ('IGS', 'IGS_PS_COON_COO_FK');
390: IGS_GE_MSG_STACK.ADD;
391: App_Exception.Raise_Exception;
392: Return;
393: END IF;
394: Close cur_rowid;
395:

Line 417: App_Exception.Raise_Exception;

413: IF (cur_rowid%FOUND) THEN
414: Close cur_rowid;
415: Fnd_Message.Set_Name ('IGS', 'IGS_PS_COON_NOTE_FK');
416: IGS_GE_MSG_STACK.ADD;
417: App_Exception.Raise_Exception;
418: Return;
419: END IF;
420: Close cur_rowid;
421:

Line 476: App_Exception.Raise_Exception;

472: new_references.attendance_type,
473: new_references.reference_number ) THEN
474: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
475: IGS_GE_MSG_STACK.ADD;
476: App_Exception.Raise_Exception;
477: END IF;
478: Check_Constraints;
479: Check_Parent_Existance;
480: ELSIF (p_action = 'UPDATE') THEN

Line 499: App_Exception.Raise_Exception;

495: new_references.attendance_type,
496: new_references.reference_number ) THEN
497: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
498: IGS_GE_MSG_STACK.ADD;
499: App_Exception.Raise_Exception;
500: END IF;
501: Check_Constraints;
502: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
503: Check_Constraints;

Line 559: app_exception.raise_exception;

555: end if;
556: else
557: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
558: IGS_GE_MSG_STACK.ADD;
559: app_exception.raise_exception;
560: end if;
561: Before_DML (
562: p_action => 'INSERT',
563: x_rowid => X_ROWID,

Line 652: app_exception.raise_exception;

648: if (c1%notfound) then
649: close c1;
650: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
651: IGS_GE_MSG_STACK.ADD;
652: app_exception.raise_exception;
653: return;
654: end if;
655: close c1;
656:

Line 664: app_exception.raise_exception;

660: null;
661: else
662: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
663: IGS_GE_MSG_STACK.ADD;
664: app_exception.raise_exception;
665: end if;
666: return;
667: end LOCK_ROW;
668:

Line 702: app_exception.raise_exception;

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