41: OPEN cur_old_ref_values;
42: FETCH cur_old_ref_values INTO old_references;
43: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
44: CLOSE cur_old_ref_values;
45: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
46: igs_ge_msg_stack.add;
47: app_exception.raise_exception;
48: RETURN;
49: END IF;
163: IF ( get_pk_for_validation(
164: new_references.system_return_class_type
165: )
166: ) THEN
167: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
168: igs_ge_msg_stack.add;
169: app_exception.raise_exception;
170: END IF;
171: ELSIF (p_action = 'DELETE') THEN
176: IF ( get_pk_for_validation (
177: new_references.system_return_class_type
178: )
179: ) THEN
180: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
181: igs_ge_msg_stack.add;
182: app_exception.raise_exception;
183: END IF;
184: ELSIF (p_action = 'VALIDATE_DELETE') THEN
228: IF (x_last_update_login IS NULL) THEN
229: x_last_update_login := -1;
230: END IF;
231: ELSE
232: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
233: igs_ge_msg_stack.add;
234: app_exception.raise_exception;
235: END IF;
236:
307:
308: OPEN c1;
309: FETCH c1 INTO tlinfo;
310: IF (c1%notfound) THEN
311: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
312: igs_ge_msg_stack.add;
313: CLOSE c1;
314: app_exception.raise_exception;
315: RETURN;
321: AND (tlinfo.description = x_description)
322: ) THEN
323: NULL;
324: ELSE
325: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
326: igs_ge_msg_stack.add;
327: app_exception.raise_exception;
328: END IF;
329:
367: IF (x_last_update_login IS NULL) THEN
368: x_last_update_login := -1;
369: END IF;
370: ELSE
371: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
372: igs_ge_msg_stack.add;
373: app_exception.raise_exception;
374: END IF;
375: