APPS.IGS_GE_SPL_REQ_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 78: App_Exception.Raise_Exception;

74: IF new_references.closed_ind <> UPPER(new_references.closed_ind ) OR
75: new_references.closed_ind NOT IN ( 'Y' , 'N' ) then
76: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
77: IGS_GE_MSG_STACK.ADD;
78: App_Exception.Raise_Exception;
79: END IF;
80: END IF;
81: IF upper(Column_name) = 'SPECIAL_REQUIREMENT_CD' OR column_name is null then
82: IF new_references.special_requirement_cd <> UPPER(new_references.special_requirement_cd ) then

Line 85: App_Exception.Raise_Exception;

81: IF upper(Column_name) = 'SPECIAL_REQUIREMENT_CD' OR column_name is null then
82: IF new_references.special_requirement_cd <> UPPER(new_references.special_requirement_cd ) 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: END Check_Constraints;
89:

Line 161: App_Exception.Raise_Exception;

157: new_references.special_requirement_cd
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: -- Call all the procedures related to Before Update.

Line 176: App_Exception.Raise_Exception;

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

Line 238: app_exception.raise_exception;

234: end if;
235: else
236: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
237: IGS_GE_MSG_STACK.ADD;
238: app_exception.raise_exception;
239: end if;
240: Before_DML (
241: p_action => 'INSERT',
242: x_rowid => X_ROWID,

Line 312: app_exception.raise_exception;

308: if (c1%notfound) then
309: close c1;
310: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
311: IGS_GE_MSG_STACK.ADD;
312: app_exception.raise_exception;
313: return;
314: end if;
315: close c1;
316:

Line 327: app_exception.raise_exception;

323: null;
324: else
325: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
326: IGS_GE_MSG_STACK.ADD;
327: app_exception.raise_exception;
328: end if;
329: return;
330: end LOCK_ROW;
331:

Line 360: app_exception.raise_exception;

356: end if;
357: else
358: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
359: IGS_GE_MSG_STACK.ADD;
360: app_exception.raise_exception;
361: end if;
362: Before_DML (
363: p_action => 'UPDATE',
364: x_rowid => X_ROWID,