[Home] [Help]
57: OPEN cur_old_ref_values;
58: FETCH cur_old_ref_values INTO old_references;
59: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
60: CLOSE cur_old_ref_values;
61: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
62: igs_ge_msg_stack.add;
63: app_exception.raise_exception;
64: RETURN;
65: END IF;
230: IF ( get_pk_for_validation(
231: new_references.cbth_id
232: )
233: ) THEN
234: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
235: igs_ge_msg_stack.add;
236: app_exception.raise_exception;
237: END IF;
238: ELSIF (p_action = 'DELETE') THEN
243: IF ( get_pk_for_validation (
244: new_references.cbth_id
245: )
246: ) THEN
247: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
248: igs_ge_msg_stack.add;
249: app_exception.raise_exception;
250: END IF;
251: ELSIF (p_action = 'VALIDATE_DELETE') THEN
328: ELSE
329: x_program_update_date := SYSDATE;
330: END IF;
331: ELSE
332: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
333: igs_ge_msg_stack.add;
334: app_exception.raise_exception;
335: END IF;
336:
493:
494: OPEN c1;
495: FETCH c1 INTO tlinfo;
496: IF (c1%notfound) THEN
497: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
498: igs_ge_msg_stack.add;
499: CLOSE c1;
500: app_exception.raise_exception;
501: RETURN;
514: AND ((tlinfo.send_resp = x_send_resp) OR ((tlinfo.send_resp IS NULL) AND (X_send_resp IS NULL)))
515: ) THEN
516: NULL;
517: ELSE
518: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
519: igs_ge_msg_stack.add;
520: app_exception.raise_exception;
521: END IF;
522:
580: IF (x_last_update_login IS NULL) THEN
581: x_last_update_login := -1;
582: END IF;
583: ELSE
584: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
585: igs_ge_msg_stack.add;
586: app_exception.raise_exception;
587: END IF;
588: