[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: CLOSE cur_old_ref_values;
49: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
50: igs_ge_msg_stack.add;
51: app_exception.raise_exception;
52: RETURN;
53: END IF;
162: IF ( get_pk_for_validation(
163: new_references.edtr_id
164: )
165: ) THEN
166: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
167: igs_ge_msg_stack.add;
168: app_exception.raise_exception;
169: END IF;
170: ELSIF (p_action = 'VALIDATE_INSERT') THEN
172: IF ( get_pk_for_validation (
173: new_references.edtr_id
174: )
175: ) THEN
176: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
177: igs_ge_msg_stack.add;
178: app_exception.raise_exception;
179: END IF;
180: END IF;
243: ELSE
244: x_program_update_date := SYSDATE;
245: END IF;
246: ELSE
247: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
248: igs_ge_msg_stack.add;
249: app_exception.raise_exception;
250: END IF;
251:
357:
358: OPEN c1;
359: FETCH c1 INTO tlinfo;
360: IF (c1%notfound) THEN
361: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
362: igs_ge_msg_stack.add;
363: CLOSE c1;
364: app_exception.raise_exception;
365: RETURN;
375: AND ((tlinfo.field_value = x_field_value) OR ((tlinfo.field_value IS NULL) AND (X_field_value IS NULL)))
376: ) THEN
377: NULL;
378: ELSE
379: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
380: igs_ge_msg_stack.add;
381: app_exception.raise_exception;
382: END IF;
383:
429: IF (x_last_update_login IS NULL) THEN
430: x_last_update_login := -1;
431: END IF;
432: ELSE
433: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
434: igs_ge_msg_stack.add;
435: app_exception.raise_exception;
436: END IF;
437: