46: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
47: CLOSE cur_old_ref_values;
48: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
49: igs_ge_msg_stack.add;
50: app_exception.raise_exception;
51: RETURN;
52: END IF;
53: CLOSE cur_old_ref_values;
54:
132: )
133: ) THEN
134: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
135: igs_ge_msg_stack.add;
136: app_exception.raise_exception;
137: END IF;
138:
139: END check_uniqueness;
140:
158: new_references.assessment_type
159: ) THEN
160: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
161: igs_ge_msg_stack.add;
162: app_exception.raise_exception;
163: END IF;
164:
165: IF (((old_references.load_cal_type = new_references.load_cal_type) AND
166: (old_references.load_ci_sequence_number = new_references.load_ci_sequence_number)) OR
172: new_references.load_ci_sequence_number
173: ) THEN
174: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
175: igs_ge_msg_stack.add;
176: app_exception.raise_exception;
177: END IF;
178:
179: END check_parent_existance;
180:
246: IF (cur_rowid%FOUND) THEN
247: CLOSE cur_rowid;
248: fnd_message.set_name ('IGS', 'IGS_AS_AASS_ATYP_FK');
249: igs_ge_msg_stack.add;
250: app_exception.raise_exception;
251: RETURN;
252: END IF;
253: CLOSE cur_rowid;
254:
283: IF (cur_rowid%FOUND) THEN
284: CLOSE cur_rowid;
285: fnd_message.set_name ('IGS', 'IGS_AS_AASS_CI_FK');
286: igs_ge_msg_stack.add;
287: app_exception.raise_exception;
288: RETURN;
289: END IF;
290: CLOSE cur_rowid;
291:
345: )
346: ) THEN
347: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
348: igs_ge_msg_stack.add;
349: app_exception.raise_exception;
350: END IF;
351: check_uniqueness;
352: check_parent_existance;
353: ELSIF (p_action = 'UPDATE') THEN
364: )
365: ) THEN
366: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
367: igs_ge_msg_stack.add;
368: app_exception.raise_exception;
369: END IF;
370: check_uniqueness;
371: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
372: check_uniqueness;
439: END IF;
440: ELSE
441: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
442: igs_ge_msg_stack.add;
443: app_exception.raise_exception;
444: END IF;
445:
446: before_dml(
447: p_action => 'INSERT',
539: IF (c1%notfound) THEN
540: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
541: igs_ge_msg_stack.add;
542: CLOSE c1;
543: app_exception.raise_exception;
544: RETURN;
545: END IF;
546: CLOSE c1;
547:
552: NULL;
553: ELSE
554: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
555: igs_ge_msg_stack.add;
556: app_exception.raise_exception;
557: END IF;
558:
559: RETURN;
560:
605: END IF;
606: ELSE
607: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
608: igs_ge_msg_stack.add;
609: app_exception.raise_exception;
610: END IF;
611:
612: before_dml(
613: p_action => 'UPDATE',