103: FETCH cur_old_ref_values INTO old_references;
104: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
105: CLOSE cur_old_ref_values;
106: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
107: igs_ge_msg_stack.add;
108: app_exception.raise_exception;
109: RETURN;
110: END IF;
111: CLOSE cur_old_ref_values;
183:
184: IF (UPPER(column_name) = 'FLAG' OR column_name IS NULL) THEN
185: IF NOT (new_references.flag IN ('A','I')) THEN
186: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
187: igs_ge_msg_stack.add;
188: app_exception.raise_exception;
189: END IF;
190: END IF;
191:
332: new_references.sequence_no
333: )
334: ) THEN
335: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
336: igs_ge_msg_stack.add;
337: app_exception.raise_exception;
338: END IF;
339: -- check_uniqueness;
340: check_constraints;
348: new_references.sequence_no
349: )
350: ) THEN
351: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
352: igs_ge_msg_stack.add;
353: app_exception.raise_exception;
354: END IF;
355: -- check_uniqueness;
356: check_constraints;
449: x_program_update_date := SYSDATE;
450: END IF;
451: ELSE
452: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
453: igs_ge_msg_stack.add;
454: app_exception.raise_exception;
455: END IF;
456:
457: SELECT igf_se_auth_s.NEXTVAL
690: OPEN c1;
691: FETCH c1 INTO tlinfo;
692: IF (c1%notfound) THEN
693: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
694: igs_ge_msg_stack.add;
695: CLOSE c1;
696: app_exception.raise_exception;
697: RETURN;
698: END IF;
734: ) THEN
735: NULL;
736: ELSE
737: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
738: igs_ge_msg_stack.add;
739: app_exception.raise_exception;
740: END IF;
741:
742: RETURN;
814: x_last_update_login := -1;
815: END IF;
816: ELSE
817: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
818: igs_ge_msg_stack.add;
819: app_exception.raise_exception;
820: END IF;
821:
822: before_dml(