DBA Data[Home] [Help]

APPS.IGS_FI_TP_RET_SCHD_PKG dependencies on FND_MESSAGE

Line 52: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');

48: OPEN cur_old_ref_values;
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;

Line 108: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');

104: new_references.dt_alias,
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:

Line 141: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');

137: x_fee_type => new_references.fee_type,
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:

Line 162: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');

158: x_dt_alias => new_references.dt_alias,
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:

Line 267: fnd_message.set_name('IGS','IGS_FI_RETAMT_OR_PER_MAND');

263: */
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');

Line 271: fnd_message.set_name('IGS','IGS_FI_ONE_RETAMT_OR_RETPREC');

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

Line 337: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

333: IF ( get_pk_for_validation(
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;

Line 356: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');

352: IF ( get_pk_for_validation (
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;

Line 428: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');

424: ELSE
425: x_program_update_date := SYSDATE;
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;

Line 429: fnd_message.set_token ('ROUTINE', 'IGS_FI_TP_RET_SCHD_PKG.INSERT_ROW');

425: x_program_update_date := SYSDATE;
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:

Line 545: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

541:
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;

Line 566: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

562: AND ((tlinfo.ret_amount = x_ret_amount) OR ((tlinfo.ret_amount IS NULL) AND (X_ret_amount IS NULL)))
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:

Line 622: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');

618: IF (x_last_update_login IS NULL) THEN
619: x_last_update_login := -1;
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;

Line 623: fnd_message.set_token ('ROUTINE', 'IGS_FI_TP_RET_SCHD_PKG.UPDATE_ROW');

619: x_last_update_login := -1;
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:

Line 789: fnd_message.set_name ('IGS', 'IGS_FI_TPRS_DAI_FK');

785: OPEN cur_rowid;
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;

Line 852: fnd_message.set_name('IGS','IGS_FI_RET_PERCENT_GT_ZERO');

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

Line 860: fnd_message.set_name('IGS','IGS_FI_RET_AMT_GT_ZERO');

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