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;
53:
91: )
92: ) THEN
93: fnd_message.set_name ('IGS', 'IGS_UC_OUTSTAT');
94: igs_ge_msg_stack.add;
95: app_exception.raise_exception;
96: END IF;
97:
98: END check_uniqueness;
99:
120: new_references.decision_code
121: ) THEN
122: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
123: igs_ge_msg_stack.add;
124: app_exception.raise_exception;
125: END IF;
126:
127: IF (((old_references.adm_outcome_status = new_references.adm_outcome_status)) OR
128: ((new_references.adm_outcome_status IS NULL))) THEN
132: 'N'
133: ) THEN
134: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
135: igs_ge_msg_stack.add;
136: app_exception.raise_exception;
137: END IF;
138:
139: END check_parent_existance;
140:
244: IF (cur_rowid%FOUND) THEN
245: CLOSE cur_rowid;
246: fnd_message.set_name ('IGS', 'IGS_UC_UCSD_UMO_FK');
247: igs_ge_msg_stack.add;
248: app_exception.raise_exception;
249: RETURN;
250: END IF;
251: CLOSE cur_rowid;
252:
279: IF (cur_rowid%FOUND) THEN
280: CLOSE cur_rowid;
281: fnd_message.set_name ('IGS', 'IGS_AD_AOS_UMOU_FK');
282: igs_ge_msg_stack.add;
283: app_exception.raise_exception;
284: RETURN;
285: END IF;
286: CLOSE cur_rowid;
287:
339: )
340: ) THEN
341: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
342: igs_ge_msg_stack.add;
343: app_exception.raise_exception;
344: END IF;
345: check_parent_existance;
346: ELSIF (p_action = 'UPDATE') THEN
347: -- Call all the procedures related to Before Update.
355: )
356: ) THEN
357: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
358: igs_ge_msg_stack.add;
359: app_exception.raise_exception;
360: END IF;
361: END IF;
362:
363: END before_dml;
420: END IF;
421: ELSE
422: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
423: igs_ge_msg_stack.add;
424: app_exception.raise_exception;
425: END IF;
426:
427: before_dml(
428: p_action => 'INSERT',
505: IF (c1%notfound) THEN
506: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
507: igs_ge_msg_stack.add;
508: CLOSE c1;
509: app_exception.raise_exception;
510: RETURN;
511: END IF;
512: CLOSE c1;
513:
515: NULL;
516: ELSE
517: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
518: igs_ge_msg_stack.add;
519: app_exception.raise_exception;
520: END IF;
521:
522: RETURN;
523:
563: END IF;
564: ELSE
565: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
566: igs_ge_msg_stack.add;
567: app_exception.raise_exception;
568: END IF;
569:
570: before_dml(
571: p_action => 'UPDATE',