44: FETCH cur_old_ref_values INTO old_references;
45: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
46: CLOSE cur_old_ref_values;
47: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
48: igs_ge_msg_stack.add;
49: app_exception.raise_exception;
50: RETURN;
51: END IF;
52: CLOSE cur_old_ref_values;
97: IF (UPPER(column_name) = 'SEQUENCE_NUMBER' OR column_name IS NULL) THEN
98: IF NOT (new_references.sequence_number BETWEEN 1
99: AND 9999999999) THEN
100: fnd_message.set_name('IGS','IGS_GE_INVALID_VALUE');
101: igs_ge_msg_stack.add;
102: app_exception.raise_exception;
103: END IF;
104: END IF;
105:
226: new_references.sequence_number
227: )
228: ) THEN
229: fnd_message.set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
230: igs_ge_msg_stack.add;
231: app_exception.raise_exception;
232: END IF;
233: check_constraints;
234: ELSIF (p_action = 'UPDATE') THEN
246: new_references.sequence_number
247: )
248: ) THEN
249: fnd_message.set_name('IGS','IGS_GE_MULTI_ORG_DUP_REC');
250: igs_ge_msg_stack.add;
251: app_exception.raise_exception;
252: END IF;
253: check_constraints;
254: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
322: x_program_update_date := SYSDATE;
323: END IF;
324: ELSE
325: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
326: igs_ge_msg_stack.add;
327: app_exception.raise_exception;
328: END IF;
329:
330: before_dml(