APPS.IGS_RE_THS_EXAM_TYPE_PKG dependencies on APP_EXCEPTION

Line 38: App_Exception.Raise_Exception;

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

Line 79: App_Exception.Raise_Exception ;

75: IF new_references.closed_ind <> upper(NEW_REFERENCES.closed_ind) OR
76: new_references.closed_ind NOT IN ('Y', 'N') then
77: Fnd_Message.Set_Name('IGS','IGS_GE_INVALID_VALUE');
78: IGS_GE_MSG_STACK.ADD;
79: App_Exception.Raise_Exception ;
80: END IF;
81: END IF;
82: IF upper(column_name) = 'THESIS_EXAM_TYPE' OR COLUMN_NAME IS NULL THEN
83: IF new_references.THESIS_EXAM_TYPE <> upper(NEW_REFERENCES.THESIS_EXAM_TYPE) then

Line 86: App_Exception.Raise_Exception ;

82: IF upper(column_name) = 'THESIS_EXAM_TYPE' OR COLUMN_NAME IS NULL THEN
83: IF new_references.THESIS_EXAM_TYPE <> upper(NEW_REFERENCES.THESIS_EXAM_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: END Check_Constraints ;
90:

Line 163: App_Exception.Raise_Exception;

159: new_references.thesis_exam_type
160: ) THEN
161: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
162: IGS_GE_MSG_STACK.ADD;
163: App_Exception.Raise_Exception;
164: END IF;
165: Check_Constraints;
166: ELSIF (p_action = 'UPDATE') THEN
167: -- Call all the procedures related to Before Update.

Line 178: App_Exception.Raise_Exception;

174: new_references.thesis_exam_type
175: ) THEN
176: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
177: IGS_GE_MSG_STACK.ADD;
178: App_Exception.Raise_Exception;
179: END IF;
180: Check_Constraints;
181: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
182: Check_Constraints;

Line 219: app_exception.raise_exception;

215: end if;
216: else
217: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
218: IGS_GE_MSG_STACK.ADD;
219: app_exception.raise_exception;
220: end if;
221:
222: Before_DML (
223: p_action => 'INSERT',

Line 285: app_exception.raise_exception;

281: fetch c1 into tlinfo;
282: if (c1%notfound) then
283: close c1;
284: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
285: app_exception.raise_exception;
286: return;
287: end if;
288: close c1;
289:

Line 296: app_exception.raise_exception;

292: ) then
293: null;
294: else
295: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
296: app_exception.raise_exception;
297: end if;
298: return;
299: end LOCK_ROW;
300:

Line 328: app_exception.raise_exception;

324: end if;
325: else
326: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
327: IGS_GE_MSG_STACK.ADD;
328: app_exception.raise_exception;
329: end if;
330:
331: Before_DML (
332: p_action => 'UPDATE',