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

Line 34: APP_EXCEPTION.RAISE_EXCEPTION;

30: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
31: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
32: IGS_GE_MSG_STACK.ADD;
33: Close cur_old_ref_values;
34: APP_EXCEPTION.RAISE_EXCEPTION;
35:
36: Return;
37: END IF;
38: Close cur_old_ref_values;

Line 77: APP_EXCEPTION.RAISE_EXCEPTION;

73: IF ((UPPER (column_name) = 'COURSE_CD') OR (column_name IS NULL)) THEN
74: IF (new_references.course_cd <> UPPER (new_references.course_cd)) THEN
75: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
76: IGS_GE_MSG_STACK.ADD;
77: APP_EXCEPTION.RAISE_EXCEPTION;
78: END IF;
79: END IF;
80:
81: IF ((UPPER (column_name) = 'ENR_NOTE_TYPE') OR (column_name IS NULL)) THEN

Line 85: APP_EXCEPTION.RAISE_EXCEPTION;

81: IF ((UPPER (column_name) = 'ENR_NOTE_TYPE') OR (column_name IS NULL)) THEN
82: IF (new_references.enr_note_type <> UPPER (new_references.enr_note_type)) THEN
83: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
84: IGS_GE_MSG_STACK.ADD;
85: APP_EXCEPTION.RAISE_EXCEPTION;
86: END IF;
87: END IF;
88:
89: END Check_Constraints ;

Line 103: APP_EXCEPTION.RAISE_EXCEPTION;

99: ) THEN
100:
101: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
102: IGS_GE_MSG_STACK.ADD;
103: APP_EXCEPTION.RAISE_EXCEPTION;
104:
105: END IF;
106: END IF;
107: IF (((old_references.reference_number = new_references.reference_number)) OR

Line 116: APP_EXCEPTION.RAISE_EXCEPTION;

112: new_references.reference_number
113: ) THEN
114: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
115: IGS_GE_MSG_STACK.ADD;
116: APP_EXCEPTION.RAISE_EXCEPTION;
117:
118: END IF;
119: END IF;
120: IF (((old_references.person_id = new_references.person_id) AND

Line 132: APP_EXCEPTION.RAISE_EXCEPTION;

128: new_references.course_cd
129: )THEN
130: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
131: IGS_GE_MSG_STACK.ADD;
132: APP_EXCEPTION.RAISE_EXCEPTION;
133:
134: END IF;
135: END IF;
136: END Check_Parent_Existance;

Line 179: APP_EXCEPTION.RAISE_EXCEPTION;

175: IF (cur_rowid%FOUND) THEN
176: Fnd_Message.Set_Name ('IGS', 'IGS_AS_SCAN_ENT_FK');
177: IGS_GE_MSG_STACK.ADD;
178: Close cur_rowid;
179: APP_EXCEPTION.RAISE_EXCEPTION;
180:
181: Return;
182: END IF;
183: Close cur_rowid;

Line 200: APP_EXCEPTION.RAISE_EXCEPTION;

196: IF (cur_rowid%FOUND) THEN
197: Fnd_Message.Set_Name ('IGS', 'IGS_AS_SCAN_NOTE_FK');
198: IGS_GE_MSG_STACK.ADD;
199: Close cur_rowid;
200: APP_EXCEPTION.RAISE_EXCEPTION;
201:
202: Return;
203: END IF;
204: Close cur_rowid;

Line 223: APP_EXCEPTION.RAISE_EXCEPTION;

219: IF (cur_rowid%FOUND) THEN
220: Fnd_Message.Set_Name ('IGS', 'IGS_AS_SCAN_SCA_FK');
221: IGS_GE_MSG_STACK.ADD;
222: Close cur_rowid;
223: APP_EXCEPTION.RAISE_EXCEPTION;
224:
225: Return;
226: END IF;
227: Close cur_rowid;

Line 266: APP_EXCEPTION.RAISE_EXCEPTION;

262: ) THEN
263:
264: Fnd_message.Set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
265: IGS_GE_MSG_STACK.ADD;
266: APP_EXCEPTION.RAISE_EXCEPTION;
267:
268: END IF;
269:
270: Check_Constraints;

Line 285: APP_EXCEPTION.RAISE_EXCEPTION;

281: new_references.reference_number
282: ) THEN
283: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
284: IGS_GE_MSG_STACK.ADD;
285: APP_EXCEPTION.RAISE_EXCEPTION;
286: END IF;
287: Check_Constraints;
288: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
289: Check_Constraints;

Line 326: APP_EXCEPTION.RAISE_EXCEPTION;

322: end if;
323: else
324: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
325: IGS_GE_MSG_STACK.ADD;
326: APP_EXCEPTION.RAISE_EXCEPTION;
327: end if;
328: Before_DML(
329: p_action=>'INSERT',
330: x_rowid=>X_ROWID,

Line 384: app_exception.raise_exception;

380: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
381: fnd_message.set_token ('ERR_CD', SQLCODE);
382: igs_ge_msg_stack.add;
383: igs_sc_gen_001.unset_ctx('R');
384: app_exception.raise_exception;
385: ELSE
386: igs_sc_gen_001.unset_ctx('R');
387: RAISE;
388: END IF;

Line 409: APP_EXCEPTION.RAISE_EXCEPTION;

405: fetch c1 into tlinfo;
406: if (c1%notfound) then
407: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
408: IGS_GE_MSG_STACK.ADD;
409: APP_EXCEPTION.RAISE_EXCEPTION;
410: close c1;
411: return;
412: end if;
413: close c1;

Line 420: APP_EXCEPTION.RAISE_EXCEPTION;

416: null;
417: else
418: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
419: IGS_GE_MSG_STACK.ADD;
420: APP_EXCEPTION.RAISE_EXCEPTION;
421: end if;
422: return;
423: end LOCK_ROW;
424: procedure UPDATE_ROW (

Line 452: APP_EXCEPTION.RAISE_EXCEPTION;

448: end if;
449: else
450: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
451: IGS_GE_MSG_STACK.ADD;
452: APP_EXCEPTION.RAISE_EXCEPTION;
453: end if;
454: Before_DML(
455: p_action=>'UPDATE',
456: x_rowid=>X_ROWID,

Line 480: app_exception.raise_exception;

476: if (sql%notfound) then
477: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
478: igs_ge_msg_stack.add;
479: igs_sc_gen_001.unset_ctx('R');
480: app_exception.raise_exception;
481: end if;
482: IF (x_mode = 'S') THEN
483: igs_sc_gen_001.unset_ctx('R');
484: END IF;

Line 494: app_exception.raise_exception;

490: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
491: fnd_message.set_token ('ERR_CD', SQLCODE);
492: igs_ge_msg_stack.add;
493: igs_sc_gen_001.unset_ctx('R');
494: app_exception.raise_exception;
495: ELSE
496: igs_sc_gen_001.unset_ctx('R');
497: RAISE;
498: END IF;

Line 554: app_exception.raise_exception;

550: if (sql%notfound) then
551: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
552: igs_ge_msg_stack.add;
553: igs_sc_gen_001.unset_ctx('R');
554: app_exception.raise_exception;
555: end if;
556: IF (x_mode = 'S') THEN
557: igs_sc_gen_001.unset_ctx('R');
558: END IF;