DBA Data[Home] [Help]

APPS.CSI_T_TXN_SYSTEMS_PVT dependencies on FND_MESSAGE

Line 82: FND_MESSAGE.SET_NAME('CSI', 'CSI_TXN_SYSTEM_DUP_NAME');

78: Exception
79: when no_data_found then
80: null; -- valid system
81: when others then
82: FND_MESSAGE.SET_NAME('CSI', 'CSI_TXN_SYSTEM_DUP_NAME');
83: FND_MSG_PUB.add;
84: x_return_status := fnd_api.g_ret_sts_error;
85: End;
86:

Line 92: FND_MESSAGE.SET_NAME('CSI', 'CSI_TXN_SYSTEM_DUP_NAME');

88: l_dummy:=NULL;
89: OPEN dup_cur;
90: FETCH dup_cur INTO l_dummy;
91: IF (dup_cur%FOUND) THEN
92: FND_MESSAGE.SET_NAME('CSI', 'CSI_TXN_SYSTEM_DUP_NAME');
93: fnd_msg_pub.add;
94: x_return_status := fnd_api.g_ret_sts_error;
95: END IF;
96:

Line 103: FND_MESSAGE.SET_NAME('CSI', 'CSI_TXN_SYSTEM_DUP_NAME');

99: l_dummy:=NULL;
100: OPEN dup_cur1;
101: FETCH dup_cur1 INTO l_dummy;
102: IF (dup_cur1%FOUND) THEN
103: FND_MESSAGE.SET_NAME('CSI', 'CSI_TXN_SYSTEM_DUP_NAME');
104: fnd_msg_pub.add;
105: x_return_status := fnd_api.g_ret_sts_error;
106: END IF;
107:

Line 134: FND_MESSAGE.SET_NAME('CSI', 'CSI_TXN_SYSTEM_DUP_NAME');

130: Exception
131: when no_data_found then
132: null; -- valid system
133: when others then
134: FND_MESSAGE.SET_NAME('CSI', 'CSI_TXN_SYSTEM_DUP_NAME');
135: FND_MSG_PUB.add;
136: x_return_status := fnd_api.g_ret_sts_error;
137: End;
138:

Line 447: fnd_message.set_name('CSI', 'CSI_RECORD_CHANGED');

443: OPEN txn_sys_csr (p_txn_system_rec.transaction_system_id);
444: FETCH txn_sys_csr INTO l_sys_csr;
445: IF ( (l_sys_csr.object_version_number<>p_txn_system_rec.object_version_number)
446: AND (p_txn_system_rec.object_version_number <> fnd_api.g_miss_num) ) THEN
447: fnd_message.set_name('CSI', 'CSI_RECORD_CHANGED');
448: fnd_msg_pub.add;
449: RAISE fnd_api.g_exc_error;
450: END IF;
451: CLOSE txn_sys_csr;

Line 456: fnd_message.set_name('CSI', 'CSI_UPD_NOT_ALLOWED');

452:
453: -- validation for Active Start Date
454: IF p_txn_system_rec.start_date_active <> fnd_api.g_miss_date THEN
455: IF p_txn_system_rec.start_date_active <> l_sys_csr.start_date_active THEN
456: fnd_message.set_name('CSI', 'CSI_UPD_NOT_ALLOWED');
457: fnd_message.set_token('start_date_active',p_txn_system_rec.start_date_active);
458: fnd_msg_pub.add;
459: RAISE fnd_api.g_exc_error;
460: END IF;

Line 457: fnd_message.set_token('start_date_active',p_txn_system_rec.start_date_active);

453: -- validation for Active Start Date
454: IF p_txn_system_rec.start_date_active <> fnd_api.g_miss_date THEN
455: IF p_txn_system_rec.start_date_active <> l_sys_csr.start_date_active THEN
456: fnd_message.set_name('CSI', 'CSI_UPD_NOT_ALLOWED');
457: fnd_message.set_token('start_date_active',p_txn_system_rec.start_date_active);
458: fnd_msg_pub.add;
459: RAISE fnd_api.g_exc_error;
460: END IF;
461: END IF;

Line 467: fnd_message.set_name('CSI', 'CSI_CANT_UPDATE_EXPIRED_SYS');

463: -- validating the effective active end date
464: IF l_sys_csr.end_date_active <= SYSDATE THEN
465: IF (p_txn_system_rec.end_date_active = fnd_api.g_miss_date) OR
466: (p_txn_system_rec.end_date_active <= SYSDATE) THEN
467: fnd_message.set_name('CSI', 'CSI_CANT_UPDATE_EXPIRED_SYS');
468: fnd_message.set_token('start_date_active',p_txn_system_rec.end_date_active);
469: fnd_msg_pub.add;
470: RAISE fnd_api.g_exc_error;
471: END IF;

Line 468: fnd_message.set_token('start_date_active',p_txn_system_rec.end_date_active);

464: IF l_sys_csr.end_date_active <= SYSDATE THEN
465: IF (p_txn_system_rec.end_date_active = fnd_api.g_miss_date) OR
466: (p_txn_system_rec.end_date_active <= SYSDATE) THEN
467: fnd_message.set_name('CSI', 'CSI_CANT_UPDATE_EXPIRED_SYS');
468: fnd_message.set_token('start_date_active',p_txn_system_rec.end_date_active);
469: fnd_msg_pub.add;
470: RAISE fnd_api.g_exc_error;
471: END IF;
472: END IF;

Line 766: fnd_message.set_name('CSI', 'CSI_INVALID_TXN_SYSTEM_ID');

762: FROM csi_t_txn_systems
763: WHERE transaction_system_id=p_txn_system_id;
764: EXCEPTION
765: WHEN no_data_found THEN
766: fnd_message.set_name('CSI', 'CSI_INVALID_TXN_SYSTEM_ID');
767: fnd_message.set_token('transaction_system_id',p_txn_system_id);
768: fnd_msg_pub.add;
769: x_return_status := fnd_api.g_ret_sts_error;
770: END;

Line 767: fnd_message.set_token('transaction_system_id',p_txn_system_id);

763: WHERE transaction_system_id=p_txn_system_id;
764: EXCEPTION
765: WHEN no_data_found THEN
766: fnd_message.set_name('CSI', 'CSI_INVALID_TXN_SYSTEM_ID');
767: fnd_message.set_token('transaction_system_id',p_txn_system_id);
768: fnd_msg_pub.add;
769: x_return_status := fnd_api.g_ret_sts_error;
770: END;
771: END IF;

Line 782: fnd_message.set_name('CSI', 'CSI_INVALID_TXN_SYSTEM_ID');

778: FROM csi_t_txn_systems
779: WHERE transaction_system_id=p_txn_system_id;
780: EXCEPTION
781: WHEN no_data_found THEN
782: fnd_message.set_name('CSI', 'CSI_INVALID_TXN_SYSTEM_ID');
783: fnd_message.set_token('transaction_system_id',p_txn_system_id);
784: fnd_msg_pub.add;
785: x_return_status := fnd_api.g_ret_sts_error;
786: END;

Line 783: fnd_message.set_token('transaction_system_id',p_txn_system_id);

779: WHERE transaction_system_id=p_txn_system_id;
780: EXCEPTION
781: WHEN no_data_found THEN
782: fnd_message.set_name('CSI', 'CSI_INVALID_TXN_SYSTEM_ID');
783: fnd_message.set_token('transaction_system_id',p_txn_system_id);
784: fnd_msg_pub.add;
785: x_return_status := fnd_api.g_ret_sts_error;
786: END;
787: ELSE

Line 788: fnd_message.set_name('CSI', 'CSI_NO_TXN_SYSTEM_ID');

784: fnd_msg_pub.add;
785: x_return_status := fnd_api.g_ret_sts_error;
786: END;
787: ELSE
788: fnd_message.set_name('CSI', 'CSI_NO_TXN_SYSTEM_ID');
789: fnd_msg_pub.add;
790: x_return_status := fnd_api.g_ret_sts_error;
791: END IF;
792:

Line 821: fnd_message.set_name('CSI', 'CSI_MISSING_OBJ_VER_NUM');

817: x_return_status := fnd_api.g_ret_sts_success;
818:
819: IF(p_validation_mode = 'UPDATE') THEN
820: IF ( (p_object_version_number IS NULL) OR (p_object_version_number = fnd_api.g_miss_num) ) THEN
821: fnd_message.set_name('CSI', 'CSI_MISSING_OBJ_VER_NUM');
822: fnd_msg_pub.add;
823: x_return_status := fnd_api.g_ret_sts_error;
824: END IF;
825: END IF;

Line 866: fnd_message.set_name('CSI','CSI_API_INVALID_START_DATE');

862: END IF;
863:
864: IF (l_end_date IS NOT NULL) THEN
865: IF (l_start_date > l_end_date) THEN
866: fnd_message.set_name('CSI','CSI_API_INVALID_START_DATE');
867: fnd_message.set_token('START_DATE_ACTIVE',l_start_date);
868: fnd_msg_pub.Add;
869: x_return_status := fnd_api.g_ret_sts_error;
870: END IF;

Line 867: fnd_message.set_token('START_DATE_ACTIVE',l_start_date);

863:
864: IF (l_end_date IS NOT NULL) THEN
865: IF (l_start_date > l_end_date) THEN
866: fnd_message.set_name('CSI','CSI_API_INVALID_START_DATE');
867: fnd_message.set_token('START_DATE_ACTIVE',l_start_date);
868: fnd_msg_pub.Add;
869: x_return_status := fnd_api.g_ret_sts_error;
870: END IF;
871: END IF;

Line 907: fnd_message.set_name('CSI','CSI_API_INVALID_END_DATE');

903: END IF;
904:
905: IF (l_end_date IS NOT NULL) THEN
906: IF l_end_date < SYSDATE THEN
907: fnd_message.set_name('CSI','CSI_API_INVALID_END_DATE');
908: fnd_message.set_token('END_DATE_ACTIVE',l_end_date);
909: fnd_msg_pub.Add;
910: x_return_status := fnd_api.g_ret_sts_error;
911: END IF;

Line 908: fnd_message.set_token('END_DATE_ACTIVE',l_end_date);

904:
905: IF (l_end_date IS NOT NULL) THEN
906: IF l_end_date < SYSDATE THEN
907: fnd_message.set_name('CSI','CSI_API_INVALID_END_DATE');
908: fnd_message.set_token('END_DATE_ACTIVE',l_end_date);
909: fnd_msg_pub.Add;
910: x_return_status := fnd_api.g_ret_sts_error;
911: END IF;
912: END IF;