[Home] [Help]
33: Fetch cur_old_ref_values INTO old_references;
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;
96: IF upper(column_name) = 'CLOSED_IND' OR
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
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;
179: IF Get_PK_For_Validation (
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
196: IF Get_PK_For_Validation (
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
312: fetch c1 into tlinfo;
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;
324: ) then
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;