DBA Data[Home] [Help]

APPS.CSI_TRANSACTIONS_PVT dependencies on FND_MESSAGE

Line 722: fnd_message.set_name('CSI', 'CSI_INVALID_PARAMETERS');

718: AND ((p_txnfind_rec.transaction_end_date IS NULL) OR (p_txnfind_rec.transaction_end_date = fnd_api.g_miss_date))
719: AND ((p_txnfind_rec.transaction_status_code IS NULL) OR (p_txnfind_rec.transaction_status_code = fnd_api.g_miss_char))
720:
721: ) THEN
722: fnd_message.set_name('CSI', 'CSI_INVALID_PARAMETERS');
723: fnd_msg_pub.add;
724: x_return_status := fnd_api.g_ret_sts_error;
725: RAISE fnd_api.g_exc_error;
726: END IF;

Line 1104: fnd_message.set_name('CSI', 'CSI_TXN_ID_ALREADY_EXISTS');

1100: WHERE transaction_id=p_transaction_rec.transaction_id
1101: AND rownum=1;
1102:
1103: IF SQL%FOUND THEN
1104: fnd_message.set_name('CSI', 'CSI_TXN_ID_ALREADY_EXISTS');
1105: fnd_message.set_token('transaction_id',p_transaction_rec.transaction_id);
1106: fnd_msg_pub.add;
1107: x_return_status := fnd_api.g_ret_sts_error;
1108: END IF;

Line 1105: fnd_message.set_token('transaction_id',p_transaction_rec.transaction_id);

1101: AND rownum=1;
1102:
1103: IF SQL%FOUND THEN
1104: fnd_message.set_name('CSI', 'CSI_TXN_ID_ALREADY_EXISTS');
1105: fnd_message.set_token('transaction_id',p_transaction_rec.transaction_id);
1106: fnd_msg_pub.add;
1107: x_return_status := fnd_api.g_ret_sts_error;
1108: END IF;
1109:

Line 1159: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_GL_STATUS');

1155: p_transaction_rec.gl_interface_status_code :=1;
1156: ELSE
1157: IF p_transaction_rec.gl_interface_status_code NOT IN (1,2,3)
1158: THEN
1159: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_GL_STATUS');
1160: FND_MESSAGE.SET_TOKEN('STATUS_CODE',p_transaction_rec.gl_interface_status_code);
1161: FND_MSG_PUB.Add;
1162: RAISE fnd_api.g_exc_error;
1163: END IF;

Line 1160: FND_MESSAGE.SET_TOKEN('STATUS_CODE',p_transaction_rec.gl_interface_status_code);

1156: ELSE
1157: IF p_transaction_rec.gl_interface_status_code NOT IN (1,2,3)
1158: THEN
1159: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_GL_STATUS');
1160: FND_MESSAGE.SET_TOKEN('STATUS_CODE',p_transaction_rec.gl_interface_status_code);
1161: FND_MSG_PUB.Add;
1162: RAISE fnd_api.g_exc_error;
1163: END IF;
1164: END IF;

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

1363: OPEN lock_csr (p_transaction_rec);
1364: FETCH lock_csr INTO l_object_version_number;
1365: IF ( (l_object_version_number<>p_transaction_rec.object_version_number)
1366: AND (p_transaction_rec.object_version_number <> fnd_api.g_miss_num) ) THEN
1367: fnd_message.set_name('CSI', 'CSI_RECORD_CHANGED');
1368: fnd_msg_pub.add;
1369: RAISE fnd_api.g_exc_error;
1370: END IF;
1371:

Line 1373: fnd_message.set_name('CSI', 'CSI_RECORD_LOCKED');

1369: RAISE fnd_api.g_exc_error;
1370: END IF;
1371:
1372: IF lock_csr%NOTFOUND THEN
1373: fnd_message.set_name('CSI', 'CSI_RECORD_LOCKED');
1374: fnd_msg_pub.add;
1375: RAISE fnd_api.g_exc_error;
1376: END IF;
1377:

Line 1408: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_GL_STATUS');

1404: IF p_transaction_rec.gl_interface_status_code IS NOT NULL AND
1405: p_transaction_rec.gl_interface_status_code <> FND_API.G_MISS_NUM AND
1406: p_transaction_rec.gl_interface_status_code NOT IN (1,2,3)
1407: THEN
1408: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_GL_STATUS');
1409: FND_MESSAGE.SET_TOKEN('STATUS_CODE',p_transaction_rec.gl_interface_status_code);
1410: FND_MSG_PUB.Add;
1411: RAISE fnd_api.g_exc_error;
1412: END IF;

Line 1409: FND_MESSAGE.SET_TOKEN('STATUS_CODE',p_transaction_rec.gl_interface_status_code);

1405: p_transaction_rec.gl_interface_status_code <> FND_API.G_MISS_NUM AND
1406: p_transaction_rec.gl_interface_status_code NOT IN (1,2,3)
1407: THEN
1408: FND_MESSAGE.SET_NAME('CSI','CSI_INVALID_GL_STATUS');
1409: FND_MESSAGE.SET_TOKEN('STATUS_CODE',p_transaction_rec.gl_interface_status_code);
1410: FND_MSG_PUB.Add;
1411: RAISE fnd_api.g_exc_error;
1412: END IF;
1413:

Line 1698: fnd_message.set_name('CSI', 'CSI_TXN_ID_NOT_PASSED');

1694: IF(p_validation_mode ='CREATE') THEN
1695: x_return_status := fnd_api.g_ret_sts_success;
1696: ELSIF(p_validation_mode = 'UPDATE') THEN
1697: IF ( (p_transaction_id IS NULL) OR (p_transaction_id = fnd_api.g_miss_num) ) THEN
1698: fnd_message.set_name('CSI', 'CSI_TXN_ID_NOT_PASSED');
1699: fnd_msg_pub.add;
1700: x_return_status := fnd_api.g_ret_sts_error;
1701: ELSE
1702: BEGIN

Line 1709: fnd_message.set_name('CSI', 'CSI_INVALID_TXN_ID');

1705: FROM csi_transactions
1706: WHERE transaction_id=p_transaction_id;
1707: EXCEPTION
1708: WHEN no_data_found THEN
1709: fnd_message.set_name('CSI', 'CSI_INVALID_TXN_ID');
1710: fnd_message.set_token('transaction_id',p_transaction_id);
1711: fnd_msg_pub.add;
1712: x_return_status := fnd_api.g_ret_sts_error;
1713: END;

Line 1710: fnd_message.set_token('transaction_id',p_transaction_id);

1706: WHERE transaction_id=p_transaction_id;
1707: EXCEPTION
1708: WHEN no_data_found THEN
1709: fnd_message.set_name('CSI', 'CSI_INVALID_TXN_ID');
1710: fnd_message.set_token('transaction_id',p_transaction_id);
1711: fnd_msg_pub.add;
1712: x_return_status := fnd_api.g_ret_sts_error;
1713: END;
1714: END IF;

Line 1752: fnd_message.set_name('CSI', 'CSI_NO_TXN_DATE');

1748: x_return_status := fnd_api.g_ret_sts_success;
1749:
1750: -- validate not null column
1751: IF ( (p_source_transaction_date IS NULL) OR (p_source_transaction_date = fnd_api.g_miss_date) ) THEN
1752: fnd_message.set_name('CSI', 'CSI_NO_TXN_DATE');
1753: fnd_msg_pub.add;
1754: x_return_status := fnd_api.g_ret_sts_error;
1755: END IF;
1756:

Line 1795: fnd_message.set_name('CSI', 'CSI_NO_TXN_TYPE_ID');

1791:
1792: -- validate not null column
1793:
1794: IF ( (p_transaction_type_id IS NULL) OR (p_transaction_type_id = fnd_api.g_miss_num) ) THEN
1795: fnd_message.set_name('CSI', 'CSI_NO_TXN_TYPE_ID');
1796: fnd_msg_pub.add;
1797: x_return_status := fnd_api.g_ret_sts_error;
1798: ELSE
1799: BEGIN

Line 1807: fnd_message.set_name('CSI', 'CSI_INVALID_TXN_TYPE_ID');

1803: WHERE transaction_type_id=p_transaction_type_id;
1804:
1805: EXCEPTION
1806: WHEN no_data_found THEN
1807: fnd_message.set_name('CSI', 'CSI_INVALID_TXN_TYPE_ID');
1808: fnd_msg_pub.add;
1809: x_return_status := fnd_api.g_ret_sts_error;
1810: END;
1811: END IF;

Line 1889: fnd_message.set_name ('CSI', 'CSI_INVALID_OBJECT_CODE');

1885: l_where_clause;
1886:
1887: IF c_ref_csr%notfound
1888: THEN
1889: fnd_message.set_name ('CSI', 'CSI_INVALID_OBJECT_CODE');
1890: fnd_msg_pub.add;
1891: x_return_status := fnd_api.g_ret_sts_error;
1892: END IF;
1893:

Line 1921: fnd_message.set_name('CSI', 'CSI_REF_NOT_FOUND');

1917:
1918: END IF;
1919: EXCEPTION
1920: WHEN no_data_found THEN
1921: fnd_message.set_name('CSI', 'CSI_REF_NOT_FOUND');
1922: fnd_msg_pub.add;
1923: x_return_status := fnd_api.g_ret_sts_error;
1924:
1925: END;

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

1963: x_return_status := fnd_api.g_ret_sts_success;
1964:
1965: IF(p_validation_mode = 'UPDATE') THEN
1966: IF ( (p_object_version_number IS NULL) OR (p_object_version_number = fnd_api.g_miss_num) ) THEN
1967: fnd_message.set_name('CSI', 'CSI_MISSING_OBJ_VER_NUM');
1968: fnd_msg_pub.add;
1969: x_return_status := fnd_api.g_ret_sts_error;
1970: END IF;
1971: END IF;

Line 2017: fnd_message.set_name('CSI', 'CSI_INVALID_REASON_CODE');

2013: WHERE lookup_type='CSI_SPLIT_REASON_CODE'
2014: AND lookup_code=p_split_reason_code;
2015: EXCEPTION
2016: WHEN no_data_found THEN
2017: fnd_message.set_name('CSI', 'CSI_INVALID_REASON_CODE');
2018: fnd_msg_pub.add;
2019: x_return_status := fnd_api.g_ret_sts_error;
2020: END;
2021: END IF;