54: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
55: CLOSE cur_old_ref_values;
56: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
57: igs_ge_msg_stack.add;
58: app_exception.raise_exception;
59: RETURN;
60: END IF;
61: CLOSE cur_old_ref_values;
62:
111: )
112: ) THEN
113: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
114: igs_ge_msg_stack.add;
115: app_exception.raise_exception;
116: END IF;
117:
118: END check_uniqueness;
119:
149: ELSE
150: CLOSE cur_rowid;
151: fnd_message.set_name ('FND','FORM_RECORD_DELETED');
152: igs_ge_msg_stack.add;
153: app_exception.raise_exception;
154: END IF;
155: END IF;
156:
157: END check_parent_existance;
295: IF (cur_rowid%FOUND) THEN
296: CLOSE cur_rowid;
297: fnd_message.set_name ('IGS', 'IGS_FI_BILL_HZPART_FK');
298: igs_ge_msg_stack.add;
299: app_exception.raise_exception;
300: RETURN;
301: END IF;
302: CLOSE cur_rowid;
303:
368: )
369: ) THEN
370: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
371: igs_ge_msg_stack.add;
372: app_exception.raise_exception;
373: END IF;
374: check_uniqueness;
375: check_parent_existance;
376: ELSIF (p_action = 'UPDATE') THEN
387: )
388: ) THEN
389: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
390: igs_ge_msg_stack.add;
391: app_exception.raise_exception;
392: END IF;
393: check_uniqueness;
394: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
395: check_uniqueness;
469: END IF;
470: ELSE
471: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
472: igs_ge_msg_stack.add;
473: app_exception.raise_exception;
474: END IF;
475:
476: SELECT igs_fi_bill_s.NEXTVAL
477: INTO x_bill_id
611: IF (c1%notfound) THEN
612: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
613: igs_ge_msg_stack.add;
614: CLOSE c1;
615: app_exception.raise_exception;
616: RETURN;
617: END IF;
618: CLOSE c1;
619:
633: NULL;
634: ELSE
635: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
636: igs_ge_msg_stack.add;
637: app_exception.raise_exception;
638: END IF;
639:
640: RETURN;
641:
694: END IF;
695: ELSE
696: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
697: igs_ge_msg_stack.add;
698: app_exception.raise_exception;
699: END IF;
700:
701: before_dml(
702: p_action => 'UPDATE',