DBA Data[Home] [Help]

APPS.IGS_FI_TP_RET_SCHD_PKG dependencies on IGS_GE_MSG_STACK

Line 53: igs_ge_msg_stack.add;

49: FETCH cur_old_ref_values INTO old_references;
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;

Line 109: igs_ge_msg_stack.add;

105: new_references.dai_sequence_number
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;

Line 142: igs_ge_msg_stack.add;

138: x_fee_cal_type => new_references.fee_cal_type,
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

Line 163: igs_ge_msg_stack.add;

159: x_sequence_number => new_references.dai_sequence_number,
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;

Line 268: igs_ge_msg_stack.add;

264: BEGIN
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;

Line 272: igs_ge_msg_stack.add;

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;
274: END IF;
275: END IF;
276: END BeforeRowInsertUpdateDelete1;

Line 338: igs_ge_msg_stack.add;

334: new_references.ftci_teach_retention_id
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;

Line 357: igs_ge_msg_stack.add;

353: new_references.ftci_teach_retention_id
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

Line 430: igs_ge_msg_stack.add;

426: END IF;
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;

Line 546: igs_ge_msg_stack.add;

542: OPEN c1;
543: FETCH c1 INTO tlinfo;
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;

Line 567: igs_ge_msg_stack.add;

563: ) THEN
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;

Line 624: igs_ge_msg_stack.add;

620: END IF;
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(

Line 790: igs_ge_msg_stack.add;

786: FETCH cur_rowid INTO lv_rowid;
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;

Line 853: igs_ge_msg_stack.add;

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

Line 861: igs_ge_msg_stack.add;

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