DBA Data[Home] [Help]

APPS.IGS_FI_TP_RET_SCHD_PKG dependencies on APP_EXCEPTION

Line 54: app_exception.raise_exception;

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:

Line 110: app_exception.raise_exception;

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:

Line 143: app_exception.raise_exception;

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

Line 164: app_exception.raise_exception;

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:

Line 269: App_Exception.Raise_Exception;

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;

Line 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:

Line 339: app_exception.raise_exception;

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;

Line 358: app_exception.raise_exception;

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;

Line 431: app_exception.raise_exception;

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:

Line 548: app_exception.raise_exception;

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:

Line 568: app_exception.raise_exception;

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:

Line 625: app_exception.raise_exception;

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',

Line 791: app_exception.raise_exception;

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;

Line 854: App_Exception.Raise_Exception;

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

Line 862: App_Exception.Raise_Exception;

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;