APPS.IGS_PS_GOVT_ATD_MODE_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 75: APP_EXCEPTION.RAISE_EXCEPTION;

71: new_references.govt_attendance_mode,
72: new_references.closed_ind,
73: v_message_name) = FALSE THEN
74: FND_MESSAGE.SET_NAME('IGS',v_message_name);
75: APP_EXCEPTION.RAISE_EXCEPTION;
76: END IF;
77: END IF;
78:
79:

Line 101: App_Exception.Raise_Exception;

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

Line 110: App_Exception.Raise_Exception;

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

Line 184: App_Exception.Raise_Exception;

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

Line 201: App_Exception.Raise_Exception;

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

Line 250: app_exception.raise_exception;

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

Line 317: app_exception.raise_exception;

313: if (c1%notfound) then
314: close c1;
315: fnd_message.set_name('FND', 'FORM_RECORD_DELETEED');
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 360: app_exception.raise_exception;

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