APPS.IGS_AD_TAC_AUSCED_AS_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 upper(Column_Name) = 'CLOSED_IND' OR Column_Name IS NULL THEN
76: IF 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) = 'TAC_AUS_SCNDRY_EDU_ASS_TYPE' OR Column_Name IS NULL THEN
83: IF new_references.tac_aus_scndry_edu_ass_type <> UPPER(new_references.tac_aus_scndry_edu_ass_type) THEN

Line 86: App_Exception.Raise_Exception;

82: IF upper(Column_Name) = 'TAC_AUS_SCNDRY_EDU_ASS_TYPE' OR Column_Name IS NULL THEN
83: IF new_references.tac_aus_scndry_edu_ass_type <> UPPER(new_references.tac_aus_scndry_edu_ass_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 161: App_Exception.Raise_Exception;

157: new_references.tac_aus_scndry_edu_ass_type
158: ) THEN
159: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
160: IGS_GE_MSG_STACK.ADD;
161: App_Exception.Raise_Exception;
162: END IF;
163: Check_Constraints;
164: ELSIF (p_action = 'UPDATE') THEN
165: Check_Constraints;

Line 175: App_Exception.Raise_Exception;

171: new_references.tac_aus_scndry_edu_ass_type
172: ) THEN
173: Fnd_Message.Set_Name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
174: IGS_GE_MSG_STACK.ADD;
175: App_Exception.Raise_Exception;
176: END IF;
177: Check_Constraints;
178: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
179: Check_Constraints;

Line 223: app_exception.raise_exception;

219: end if;
220: else
221: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
222: IGS_GE_MSG_STACK.ADD;
223: app_exception.raise_exception;
224: end if;
225: Before_DML (
226: p_action => 'INSERT',
227: x_rowid => X_ROWID,

Line 291: app_exception.raise_exception;

287: if (c1%notfound) then
288: close c1;
289: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
290: IGS_GE_MSG_STACK.ADD;
291: app_exception.raise_exception;
292: return;
293: end if;
294: close c1;
295:

Line 304: app_exception.raise_exception;

300: null;
301: else
302: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
303: IGS_GE_MSG_STACK.ADD;
304: app_exception.raise_exception;
305: end if;
306: return;
307: end LOCK_ROW;
308:

Line 336: app_exception.raise_exception;

332: end if;
333: else
334: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
335: IGS_GE_MSG_STACK.ADD;
336: app_exception.raise_exception;
337: end if;
338: Before_DML (
339: p_action => 'UPDATE',
340: x_rowid => X_ROWID,