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

Line 45: App_Exception.Raise_Exception;

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

Line 117: App_Exception.Raise_Exception;

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

Line 150: App_Exception.Raise_Exception;

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

Line 159: App_Exception.Raise_Exception;

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

Line 168: App_Exception.Raise_Exception;

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

Line 177: App_Exception.Raise_Exception;

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

Line 186: App_Exception.Raise_Exception;

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

Line 195: App_Exception.Raise_Exception;

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

Line 213: App_Exception.Raise_Exception;

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

Line 244: App_Exception.Raise_Exception;

240: new_references.attendance_type
241: ) THEN
242: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
243: IGS_GE_MSG_STACK.ADD;
244: App_Exception.Raise_Exception;
245: END IF;
246: END IF;
247:
248: IF (((old_references.cop_id = new_references.cop_id)) OR

Line 257: App_Exception.Raise_Exception;

253: new_references.cop_id
254: ) THEN
255: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
256: IGS_GE_MSG_STACK.ADD;
257: App_Exception.Raise_Exception;
258: END IF;
259: END IF;
260:
261: IF (((old_references.reference_number = new_references.reference_number)) OR

Line 270: App_Exception.Raise_Exception;

266: new_references.reference_number
267: ) THEN
268: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
269: IGS_GE_MSG_STACK.ADD;
270: App_Exception.Raise_Exception;
271: END IF;
272: END IF;
273:
274: END Check_Parent_Existance;

Line 336: App_Exception.Raise_Exception;

332: IF (cur_rowid%FOUND) THEN
333: Close cur_rowid;
334: Fnd_Message.Set_Name ('IGS', 'IGS_PS_COPN_CNT_FK');
335: IGS_GE_MSG_STACK.ADD;
336: App_Exception.Raise_Exception;
337: Return;
338: END IF;
339: Close cur_rowid;
340:

Line 374: App_Exception.Raise_Exception;

370: IF (cur_rowid%FOUND) THEN
371: Close cur_rowid;
372: Fnd_Message.Set_Name ('IGS', 'IGS_PS_COPN_COP_FK');
373: IGS_GE_MSG_STACK.ADD;
374: App_Exception.Raise_Exception;
375: Return;
376: END IF;
377: Close cur_rowid;
378:

Line 400: App_Exception.Raise_Exception;

396: IF (cur_rowid%FOUND) THEN
397: Close cur_rowid;
398: Fnd_Message.Set_Name ('IGS', 'IGS_PS_COPN_COP_FK');
399: IGS_GE_MSG_STACK.ADD;
400: App_Exception.Raise_Exception;
401: Return;
402: END IF;
403: Close cur_rowid;
404:

Line 426: App_Exception.Raise_Exception;

422: IF (cur_rowid%FOUND) THEN
423: Close cur_rowid;
424: Fnd_Message.Set_Name ('IGS', 'IGS_PS_COPN_NOTE_FK');
425: IGS_GE_MSG_STACK.ADD;
426: App_Exception.Raise_Exception;
427: Return;
428: END IF;
429: Close cur_rowid;
430:

Line 488: App_Exception.Raise_Exception;

484: new_references.attendance_type,
485: new_references.reference_number ) THEN
486: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
487: IGS_GE_MSG_STACK.ADD;
488: App_Exception.Raise_Exception;
489: END IF;
490: Check_Constraints;
491: Check_Parent_Existance;
492: ELSIF (p_action = 'UPDATE') THEN

Line 512: App_Exception.Raise_Exception;

508: new_references.attendance_type,
509: new_references.reference_number ) THEN
510: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
511: IGS_GE_MSG_STACK.ADD;
512: App_Exception.Raise_Exception;
513: END IF;
514: Check_Constraints;
515: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
516: Check_Constraints;

Line 575: app_exception.raise_exception;

571: end if;
572: else
573: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
574: IGS_GE_MSG_STACK.ADD;
575: app_exception.raise_exception;
576: end if;
577: Before_DML (
578: p_action => 'INSERT',
579: x_rowid => X_ROWID,

Line 672: app_exception.raise_exception;

668: if (c1%notfound) then
669: close c1;
670: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
671: IGS_GE_MSG_STACK.ADD;
672: app_exception.raise_exception;
673: return;
674: end if;
675: close c1;
676:

Line 684: app_exception.raise_exception;

680: null;
681: else
682: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
683: IGS_GE_MSG_STACK.ADD;
684: app_exception.raise_exception;
685: end if;
686: return;
687: end LOCK_ROW;
688:

Line 723: app_exception.raise_exception;

719: end if;
720: else
721: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
722: IGS_GE_MSG_STACK.ADD;
723: app_exception.raise_exception;
724: end if;
725: Before_DML (
726: p_action => 'UPDATE',
727: x_rowid => X_ROWID,