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;
174: IF ( get_pk_for_validation(
175: new_references.association_code
176: )
177: ) THEN
178: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
179: igs_ge_msg_stack.add;
180: app_exception.raise_exception;
181: END IF;
182: ELSIF (p_action = 'DELETE') THEN
187: IF ( get_pk_for_validation (
188: new_references.association_code
189: )
190: ) THEN
191: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
192: igs_ge_msg_stack.add;
193: app_exception.raise_exception;
194: END IF;
195: ELSIF (p_action = 'VALIDATE_DELETE') THEN
239: IF (x_last_update_login IS NULL) THEN
240: x_last_update_login := -1;
241: END IF;
242: ELSE
243: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
244: igs_ge_msg_stack.add;
245: app_exception.raise_exception;
246: END IF;
247:
318:
319: OPEN c1;
320: FETCH c1 INTO tlinfo;
321: IF (c1%notfound) THEN
322: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
323: igs_ge_msg_stack.add;
324: CLOSE c1;
325: app_exception.raise_exception;
326: RETURN;
332: AND (tlinfo.display_title = x_display_title)
333: ) THEN
334: NULL;
335: ELSE
336: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
337: igs_ge_msg_stack.add;
338: app_exception.raise_exception;
339: END IF;
340:
378: IF (x_last_update_login IS NULL) THEN
379: x_last_update_login := -1;
380: END IF;
381: ELSE
382: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
383: igs_ge_msg_stack.add;
384: app_exception.raise_exception;
385: END IF;
386: