[Home] [Help]
45: Open cur_old_ref_values;
46: Fetch cur_old_ref_values INTO old_references;
47: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
48: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
49: Igs_Ge_Msg_Stack.Add;
50: Close cur_old_ref_values;
51: App_Exception.Raise_Exception;
52: Return;
53: END IF;
167:
168: IF Get_PK_For_Validation (
169: new_references.at_id ) THEN
170: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
171: Igs_Ge_Msg_Stack.Add;
172: App_Exception.Raise_Exception;
173: END IF;
174: NULL;
175: ELSIF (p_action = 'UPDATE') THEN
182: ELSIF (p_action = 'VALIDATE_INSERT') THEN
183: IF Get_PK_For_Validation (
184: new_references.at_id ) THEN
185: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
186: Igs_Ge_Msg_Stack.Add;
187: App_Exception.Raise_Exception;
188: END IF;
189: NULL;
190: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
255: end if;
256:
257: else
258: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
259: Igs_Ge_Msg_Stack.Add;
260: app_exception.raise_exception;
261: end if;
262:
263: select IGS_AS_ASSR1020_TMP_AT_ID_S.nextval
403: open c1;
404: fetch c1 into tlinfo;
405: if (c1%notfound) then
406: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
407: Igs_Ge_Msg_Stack.Add;
408: close c1;
409: app_exception.raise_exception;
410: return;
411: end if;
444: ) then
445: null;
446: else
447: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
448: Igs_Ge_Msg_Stack.Add;
449: app_exception.raise_exception;
450: end if;
451: return;
452: end LOCK_ROW;
494: X_LAST_UPDATE_LOGIN := -1;
495: end if;
496: else
497: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
498: Igs_Ge_Msg_Stack.Add;
499: app_exception.raise_exception;
500: end if;
501: Before_DML(
502: p_action=>'UPDATE',