48: OPEN cur_old_ref_values;
49: FETCH cur_old_ref_values INTO old_references;
50: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
51: CLOSE cur_old_ref_values;
52: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
53: igs_ge_msg_stack.add;
54: app_exception.raise_exception;
55: RETURN;
56: END IF;
193: IF ( get_pk_for_validation(
194: new_references.submission_name
195: )
196: ) THEN
197: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
198: igs_ge_msg_stack.add;
199: app_exception.raise_exception;
200: END IF;
201: ELSIF (p_action = 'DELETE') THEN
206: IF ( get_pk_for_validation (
207: new_references.submission_name
208: )
209: ) THEN
210: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
211: igs_ge_msg_stack.add;
212: app_exception.raise_exception;
213: END IF;
214: ELSIF (p_action = 'VALIDATE_DELETE') THEN
265: IF (x_last_update_login IS NULL) THEN
266: x_last_update_login := -1;
267: END IF;
268: ELSE
269: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
270: igs_ge_msg_stack.add;
271: app_exception.raise_exception;
272: END IF;
273:
383:
384: OPEN c1;
385: FETCH c1 INTO tlinfo;
386: IF (c1%notfound) THEN
387: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
388: igs_ge_msg_stack.add;
389: CLOSE c1;
390: app_exception.raise_exception;
391: RETURN;
404: AND (tlinfo.complete_flag = x_complete_flag)
405: ) THEN
406: NULL;
407: ELSE
408: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
409: igs_ge_msg_stack.add;
410: app_exception.raise_exception;
411: END IF;
412:
457: IF (x_last_update_login IS NULL) THEN
458: x_last_update_login := -1;
459: END IF;
460: ELSE
461: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
462: igs_ge_msg_stack.add;
463: app_exception.raise_exception;
464: END IF;
465: