[Home] [Help]
30: Open cur_old_ref_values;
31: Fetch cur_old_ref_values INTO old_references;
32: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT')) THEN
33: Close cur_old_ref_values;
34: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
35: IGS_GE_MSG_STACK.ADD;
36: App_Exception.Raise_Exception;
37: Return;
38: END IF;
67: End if;
68:
69: If upper(Column_name)= 'CURRENT_USER' Or column_name is null then
70: If UPPER(new_references.current_user) <> new_references.current_user Then
71: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
72: IGS_GE_MSG_STACK.ADD;
73: App_Exception.Raise_Exception;
74: End if;
75: End if;
133: if get_pk_for_validation(
134: x_dt_of_month,
135: x_current_user
136: ) Then
137: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
138: IGS_GE_MSG_STACK.ADD;
139: app_exception.raise_exception;
140: end if;
141: check_constraints;
152: if get_pk_for_validation(
153: x_dt_of_month ,
154: x_current_user
155: ) Then
156: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
157: IGS_GE_MSG_STACK.ADD;
158: app_exception.raise_exception;
159: end if;
160: check_constraints;
192: if X_LAST_UPDATE_LOGIN is NULL then
193: X_LAST_UPDATE_LOGIN := -1;
194: end if;
195: else
196: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
197: IGS_GE_MSG_STACK.ADD;
198: app_exception.raise_exception;
199: end if;
200: Before_DML (
249: open c1;
250: fetch c1 into tlinfo;
251: if (c1%notfound) then
252: close c1;
253: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
254: IGS_GE_MSG_STACK.ADD;
255: app_exception.raise_exception;
256: return;
257: end if;