APPS.IGS_PS_STAT_PKG dependencies on APP_EXCEPTION

Line 39: App_Exception.Raise_Exception;

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

Line 84: App_Exception.Raise_Exception;

80: IF new_references.course_status <> UPPER(new_references.course_status)
81: THEN
82: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
83: IGS_GE_MSG_STACK.ADD;
84: App_Exception.Raise_Exception;
85: END IF;
86: END IF;
87:
88: IF upper(column_name)= 'CLOSED_IND' OR

Line 94: App_Exception.Raise_Exception;

90: IF new_references.closed_ind NOT IN ( 'Y' , 'N' )
91: THEN
92: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
93: IGS_GE_MSG_STACK.ADD;
94: App_Exception.Raise_Exception;
95: END IF;
96: END IF;
97:
98: IF upper(column_name)= 'S_COURSE_STATUS' OR

Line 104: App_Exception.Raise_Exception;

100: IF new_references.s_course_status NOT IN ( 'ACTIVE' , 'INACTIVE','PLANNED' )
101: 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: END Check_Constraints;
108:

Line 180: App_Exception.Raise_Exception;

176: new_references.course_status
177: ) THEN
178: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
179: IGS_GE_MSG_STACK.ADD;
180: App_Exception.Raise_Exception;
181: END IF;
182: Check_Constraints;
183: ELSIF (p_action = 'UPDATE') THEN
184: -- Call all the procedures related to Before Update.

Line 196: App_Exception.Raise_Exception;

192: new_references.course_status
193: ) THEN
194: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
195: IGS_GE_MSG_STACK.ADD;
196: App_Exception.Raise_Exception;
197: END IF;
198: Check_Constraints;
199: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
200: Check_Constraints;

Line 247: app_exception.raise_exception;

243: end if;
244: else
245: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
246: IGS_GE_MSG_STACK.ADD;
247: app_exception.raise_exception;
248: end if;
249: Before_DML( p_action => 'INSERT',
250: x_rowid => X_ROWID,
251: x_course_status => X_COURSE_STATUS,

Line 318: app_exception.raise_exception;

314: if (c1%notfound) then
315: close c1;
316: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
317: IGS_GE_MSG_STACK.ADD;
318: app_exception.raise_exception;
319: return;
320: end if;
321: close c1;
322:

Line 331: app_exception.raise_exception;

327: null;
328: else
329: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
330: IGS_GE_MSG_STACK.ADD;
331: app_exception.raise_exception;
332: end if;
333: return;
334: end LOCK_ROW;
335:

Line 364: app_exception.raise_exception;

360: end if;
361: else
362: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
363: IGS_GE_MSG_STACK.ADD;
364: app_exception.raise_exception;
365: end if;
366: Before_DML( p_action => 'UPDATE',
367: x_rowid => X_ROWID,
368: x_course_status => X_COURSE_STATUS,