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

Line 40: App_Exception.Raise_Exception;

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

Line 86: App_Exception.Raise_Exception;

82: column_name is null Then
83: IF ( new_references.cal_type <> UPPER(new_references.cal_type) ) Then
84: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
85: IGS_GE_MSG_STACK.ADD;
86: App_Exception.Raise_Exception;
87: END IF;
88: END IF;
89:
90: IF upper(column_name) = 'COURSE_CD' OR

Line 95: App_Exception.Raise_Exception;

91: column_name is null Then
92: IF ( new_references.course_cd <> UPPER(new_references.course_cd) ) Then
93: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
94: IGS_GE_MSG_STACK.ADD;
95: App_Exception.Raise_Exception;
96: END IF;
97: END IF;
98:
99: IF upper(column_name) = 'CRS_NOTE_TYPE' OR

Line 104: App_Exception.Raise_Exception;

100: column_name is null Then
101: IF ( new_references.crs_note_type <> UPPER(new_references.crs_note_type) ) 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 122: App_Exception.Raise_Exception;

118: new_references.crs_note_type
119: ) THEN
120: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
121: IGS_GE_MSG_STACK.ADD;
122: App_Exception.Raise_Exception;
123: END IF;
124: END IF;
125:
126: IF (((old_references.course_cd = new_references.course_cd) AND

Line 141: App_Exception.Raise_Exception;

137: new_references.cal_type
138: ) THEN
139: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
140: IGS_GE_MSG_STACK.ADD;
141: App_Exception.Raise_Exception;
142: END IF;
143: END IF;
144:
145: IF (((old_references.reference_number = new_references.reference_number)) OR

Line 154: App_Exception.Raise_Exception;

150: new_references.reference_number
151: ) THEN
152: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
153: IGS_GE_MSG_STACK.ADD;
154: App_Exception.Raise_Exception;
155: END IF;
156: END IF;
157:
158: END Check_Parent_Existance;

Line 212: App_Exception.Raise_Exception;

208: IF (cur_rowid%FOUND) THEN
209: Close cur_rowid;
210: Fnd_Message.Set_Name ('IGS', 'IGS_PS_CON_CNT_FK');
211: IGS_GE_MSG_STACK.ADD;
212: App_Exception.Raise_Exception;
213: Return;
214: END IF;
215: Close cur_rowid;
216:

Line 242: App_Exception.Raise_Exception;

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

Line 268: App_Exception.Raise_Exception;

264: IF (cur_rowid%FOUND) THEN
265: Close cur_rowid;
266: Fnd_Message.Set_Name ('IGS', 'IGS_PS_CON_NOTE_FK');
267: IGS_GE_MSG_STACK.ADD;
268: App_Exception.Raise_Exception;
269: Return;
270: END IF;
271: Close cur_rowid;
272:

Line 315: App_Exception.Raise_Exception;

311: new_references.cal_type,
312: new_references.reference_number ) THEN
313: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
314: IGS_GE_MSG_STACK.ADD;
315: App_Exception.Raise_Exception;
316: END IF;
317: Check_Constraints;
318: Check_Parent_Existance;
319: ELSIF (p_action = 'UPDATE') THEN

Line 335: App_Exception.Raise_Exception;

331: new_references.cal_type,
332: new_references.reference_number ) THEN
333: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
334: IGS_GE_MSG_STACK.ADD;
335: App_Exception.Raise_Exception;
336: END IF;
337: Check_Constraints;
338: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
339: Check_Constraints;

Line 389: app_exception.raise_exception;

385: end if;
386: else
387: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
388: IGS_GE_MSG_STACK.ADD;
389: app_exception.raise_exception;
390: end if;
391: Before_DML (
392: p_action => 'INSERT',
393: x_rowid => X_ROWID,

Line 465: app_exception.raise_exception;

461: if (c1%notfound) then
462: close c1;
463: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
464: IGS_GE_MSG_STACK.ADD;
465: app_exception.raise_exception;
466: return;
467: end if;
468: close c1;
469:

Line 476: app_exception.raise_exception;

472: null;
473: else
474: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
475: IGS_GE_MSG_STACK.ADD;
476: app_exception.raise_exception;
477: end if;
478: return;
479: end LOCK_ROW;
480:

Line 510: app_exception.raise_exception;

506: end if;
507: else
508: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
509: IGS_GE_MSG_STACK.ADD;
510: app_exception.raise_exception;
511: end if;
512: Before_DML (
513: p_action => 'UPDATE',
514: x_rowid => X_ROWID,