APPS.IGS_PS_GOVT_ATD_TYPE_PKG dependencies on APP_EXCEPTION

Line 37: App_Exception.Raise_Exception;

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

Line 76: App_Exception.Raise_Exception;

72: new_references.closed_ind,
73: v_message_name) = FALSE THEN
74: Fnd_Message.Set_Name('IGS', v_message_name);
75: IGS_GE_MSG_STACK.ADD;
76: App_Exception.Raise_Exception;
77: END IF;
78: END IF;
79:
80:

Line 102: App_Exception.Raise_Exception;

98: column_name is null Then
99: IF new_references.closed_ind NOT IN ('Y','N') THEN
100: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
101: IGS_GE_MSG_STACK.ADD;
102: App_Exception.Raise_Exception;
103: END IF;
104: END IF;
105:
106: IF upper(column_name) = 'GOVT_ATTENDANCE_TYPE' OR

Line 111: App_Exception.Raise_Exception;

107: column_name is null Then
108: IF new_references.govt_attendance_type <> UPPER(new_references.govt_attendance_type) Then
109: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
110: IGS_GE_MSG_STACK.ADD;
111: App_Exception.Raise_Exception;
112: END IF;
113: END IF;
114: END check_constraints;
115:

Line 185: App_Exception.Raise_Exception;

181: new_references.govt_attendance_type
182: ) THEN
183: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
184: IGS_GE_MSG_STACK.ADD;
185: App_Exception.Raise_Exception;
186: END IF;
187: Check_Constraints;
188: ELSIF (p_action = 'UPDATE') THEN
189: -- Call all the procedures related to Before Update.

Line 202: App_Exception.Raise_Exception;

198: new_references.govt_attendance_type
199: ) THEN
200: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
201: IGS_GE_MSG_STACK.ADD;
202: App_Exception.Raise_Exception;
203: END IF;
204: Check_Constraints;
205: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
206: Check_Constraints;

Line 251: app_exception.raise_exception;

247: end if;
248: else
249: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
250: IGS_GE_MSG_STACK.ADD;
251: app_exception.raise_exception;
252: end if;
253: Before_DML( p_action => 'INSERT',
254: x_rowid => X_ROWID,
255: x_govt_attendance_type => X_GOVT_ATTENDANCE_TYPE,

Line 317: app_exception.raise_exception;

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

Line 329: app_exception.raise_exception;

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

Line 361: app_exception.raise_exception;

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