50: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
51: CLOSE cur_old_ref_values;
52: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
53: igs_ge_msg_stack.add;
54: app_exception.raise_exception;
55: RETURN;
56: END IF;
57: CLOSE cur_old_ref_values;
58:
106: )
107: ) THEN
108: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
109: igs_ge_msg_stack.add;
110: app_exception.raise_exception;
111: END IF;
112:
113: END check_uniqueness;
114:
139: x_fee_ci_sequence_number => new_references.fee_ci_sequence_number
140: ) THEN
141: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
142: igs_ge_msg_stack.add;
143: app_exception.raise_exception;
144: END IF;
145:
146: IF ((old_references.dt_alias = new_references.dt_alias) AND
147: (old_references.dai_sequence_number = new_references.dai_sequence_number) AND
160: x_cal_type => new_references.teach_cal_type,
161: x_ci_sequence_number => new_references.teach_ci_sequence_number) THEN
162: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
163: igs_ge_msg_stack.add;
164: app_exception.raise_exception;
165: END IF;
166:
167: END check_parent_existance;
168:
265: IF (p_inserting OR p_updating) THEN
266: IF (new_references.ret_percentage IS NULL AND new_references.ret_amount IS NULL) THEN
267: fnd_message.set_name('IGS','IGS_FI_RETAMT_OR_PER_MAND');
268: igs_ge_msg_stack.add;
269: App_Exception.Raise_Exception;
270: ELSIF (new_references.ret_percentage IS NOT NULL AND new_references.ret_amount IS NOT NULL) THEN
271: fnd_message.set_name('IGS','IGS_FI_ONE_RETAMT_OR_RETPREC');
272: igs_ge_msg_stack.add;
273: App_Exception.Raise_Exception;
269: App_Exception.Raise_Exception;
270: ELSIF (new_references.ret_percentage IS NOT NULL AND new_references.ret_amount IS NOT NULL) THEN
271: fnd_message.set_name('IGS','IGS_FI_ONE_RETAMT_OR_RETPREC');
272: igs_ge_msg_stack.add;
273: App_Exception.Raise_Exception;
274: END IF;
275: END IF;
276: END BeforeRowInsertUpdateDelete1;
277:
335: )
336: ) THEN
337: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
338: igs_ge_msg_stack.add;
339: app_exception.raise_exception;
340: END IF;
341: check_uniqueness;
342: Check_Constraints;
343: check_parent_existance;
354: )
355: ) THEN
356: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
357: igs_ge_msg_stack.add;
358: app_exception.raise_exception;
359: END IF;
360: check_uniqueness;
361: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
362: check_uniqueness;
427: ELSE
428: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
429: fnd_message.set_token ('ROUTINE', 'IGS_FI_TP_RET_SCHD_PKG.INSERT_ROW');
430: igs_ge_msg_stack.add;
431: app_exception.raise_exception;
432: END IF;
433:
434: x_ftci_teach_retention_id := NULL;
435:
544: IF (c1%notfound) THEN
545: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
546: igs_ge_msg_stack.add;
547: CLOSE c1;
548: app_exception.raise_exception;
549: RETURN;
550: END IF;
551: CLOSE c1;
552:
564: NULL;
565: ELSE
566: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
567: igs_ge_msg_stack.add;
568: app_exception.raise_exception;
569: END IF;
570:
571: RETURN;
572:
621: ELSE
622: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
623: fnd_message.set_token ('ROUTINE', 'IGS_FI_TP_RET_SCHD_PKG.UPDATE_ROW');
624: igs_ge_msg_stack.add;
625: app_exception.raise_exception;
626: END IF;
627:
628: before_dml(
629: p_action => 'UPDATE',
787: IF (cur_rowid%FOUND) THEN
788: CLOSE cur_rowid;
789: fnd_message.set_name ('IGS', 'IGS_FI_TPRS_DAI_FK');
790: igs_ge_msg_stack.add;
791: app_exception.raise_exception;
792: RETURN;
793: END IF;
794: CLOSE cur_rowid;
795: END get_fk_igs_ca_da_inst;
850: IF (Upper(Column_Name) = 'RET_PERCENTAGE' OR Column_Name IS NULL) THEN
851: IF (new_references.ret_percentage <= 0 OR new_references.ret_percentage > 100) THEN
852: fnd_message.set_name('IGS','IGS_FI_RET_PERCENT_GT_ZERO');
853: igs_ge_msg_stack.add;
854: App_Exception.Raise_Exception;
855: END IF;
856: END IF;
857:
858: IF (Upper(Column_Name) = 'RET_AMOUNT' OR Column_Name IS NULL) THEN
858: IF (Upper(Column_Name) = 'RET_AMOUNT' OR Column_Name IS NULL) THEN
859: IF (new_references.ret_amount <= 0) THEN
860: fnd_message.set_name('IGS','IGS_FI_RET_AMT_GT_ZERO');
861: igs_ge_msg_stack.add;
862: App_Exception.Raise_Exception;
863: END IF;
864: END IF;
865:
866: END Check_Constraints;