DBA Data[Home] [Help]

APPS.CSI_ASSET_PVT dependencies on FND_MESSAGE

Line 217: FND_MESSAGE.SET_NAME('CSI','CSI_FA_HR_LOCATION_MAP');

213: into l_cii_location
214: from HR_LOCATIONS_ALL
215: where location_id = l_cii_location_id;
216: --
217: FND_MESSAGE.SET_NAME('CSI','CSI_FA_HR_LOCATION_MAP');
218: FND_MESSAGE.SET_TOKEN('FA_LOCATION',l_fa_location);
219: FND_MESSAGE.SET_TOKEN('HR_LOCATION',l_cii_location);
220: FND_MSG_PUB.Add;
221: Exception

Line 218: FND_MESSAGE.SET_TOKEN('FA_LOCATION',l_fa_location);

214: from HR_LOCATIONS_ALL
215: where location_id = l_cii_location_id;
216: --
217: FND_MESSAGE.SET_NAME('CSI','CSI_FA_HR_LOCATION_MAP');
218: FND_MESSAGE.SET_TOKEN('FA_LOCATION',l_fa_location);
219: FND_MESSAGE.SET_TOKEN('HR_LOCATION',l_cii_location);
220: FND_MSG_PUB.Add;
221: Exception
222: when no_data_found then

Line 219: FND_MESSAGE.SET_TOKEN('HR_LOCATION',l_cii_location);

215: where location_id = l_cii_location_id;
216: --
217: FND_MESSAGE.SET_NAME('CSI','CSI_FA_HR_LOCATION_MAP');
218: FND_MESSAGE.SET_TOKEN('FA_LOCATION',l_fa_location);
219: FND_MESSAGE.SET_TOKEN('HR_LOCATION',l_cii_location);
220: FND_MSG_PUB.Add;
221: Exception
222: when no_data_found then
223: Begin

Line 229: FND_MESSAGE.SET_NAME('CSI','CSI_FA_HZ_LOCATION_MAP');

225: into l_cii_location
226: from HZ_LOCATIONS
227: where location_id = l_cii_location_id;
228: --
229: FND_MESSAGE.SET_NAME('CSI','CSI_FA_HZ_LOCATION_MAP');
230: FND_MESSAGE.SET_TOKEN('FA_LOCATION',l_fa_location);
231: FND_MESSAGE.SET_TOKEN('HZ_LOCATION',l_cii_location);
232: FND_MSG_PUB.Add;
233: Exception

Line 230: FND_MESSAGE.SET_TOKEN('FA_LOCATION',l_fa_location);

226: from HZ_LOCATIONS
227: where location_id = l_cii_location_id;
228: --
229: FND_MESSAGE.SET_NAME('CSI','CSI_FA_HZ_LOCATION_MAP');
230: FND_MESSAGE.SET_TOKEN('FA_LOCATION',l_fa_location);
231: FND_MESSAGE.SET_TOKEN('HZ_LOCATION',l_cii_location);
232: FND_MSG_PUB.Add;
233: Exception
234: when no_data_found then

Line 231: FND_MESSAGE.SET_TOKEN('HZ_LOCATION',l_cii_location);

227: where location_id = l_cii_location_id;
228: --
229: FND_MESSAGE.SET_NAME('CSI','CSI_FA_HZ_LOCATION_MAP');
230: FND_MESSAGE.SET_TOKEN('FA_LOCATION',l_fa_location);
231: FND_MESSAGE.SET_TOKEN('HZ_LOCATION',l_cii_location);
232: FND_MSG_PUB.Add;
233: Exception
234: when no_data_found then
235: null;

Line 254: FND_MESSAGE.SET_NAME('CSI','CSI_FA_CIA_UNITS_MISMATCH');

250: THEN
251: px_instance_asset_rec.fa_sync_flag := 'Y' ;
252: ELSE
253: px_instance_asset_rec.fa_sync_flag := 'N' ;
254: FND_MESSAGE.SET_NAME('CSI','CSI_FA_CIA_UNITS_MISMATCH');
255: FND_MSG_PUB.Add;
256: END IF ;
257: END IF ; --px_instance_asset_rec.fa_location_id <> l_mapped_fa_location_id ;
258: END IF;

Line 344: -- FND_MESSAGE.SET_NAME('CSI','CSI_H_DATE_BEFORE_CRE_DATE');

340: -- If the user chooses a date before the creation date of the instance
341: -- then raise an error
342: IF p_time_stamp < l_time_stamp THEN
343: -- Messages Commented for bug 2423342. Records that do not qualify should get deleted.
344: -- FND_MESSAGE.SET_NAME('CSI','CSI_H_DATE_BEFORE_CRE_DATE');
345: -- FND_MESSAGE.SET_TOKEN('CREATION_DATE',to_char(l_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
346: -- FND_MESSAGE.SET_TOKEN('USER_DATE',to_char(p_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
347: -- FND_MSG_PUB.Add;
348: l_instance_asset_tbl.DELETE(i);

Line 345: -- FND_MESSAGE.SET_TOKEN('CREATION_DATE',to_char(l_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));

341: -- then raise an error
342: IF p_time_stamp < l_time_stamp THEN
343: -- Messages Commented for bug 2423342. Records that do not qualify should get deleted.
344: -- FND_MESSAGE.SET_NAME('CSI','CSI_H_DATE_BEFORE_CRE_DATE');
345: -- FND_MESSAGE.SET_TOKEN('CREATION_DATE',to_char(l_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
346: -- FND_MESSAGE.SET_TOKEN('USER_DATE',to_char(p_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
347: -- FND_MSG_PUB.Add;
348: l_instance_asset_tbl.DELETE(i);
349: RAISE Process_next;

Line 346: -- FND_MESSAGE.SET_TOKEN('USER_DATE',to_char(p_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));

342: IF p_time_stamp < l_time_stamp THEN
343: -- Messages Commented for bug 2423342. Records that do not qualify should get deleted.
344: -- FND_MESSAGE.SET_NAME('CSI','CSI_H_DATE_BEFORE_CRE_DATE');
345: -- FND_MESSAGE.SET_TOKEN('CREATION_DATE',to_char(l_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
346: -- FND_MESSAGE.SET_TOKEN('USER_DATE',to_char(p_time_stamp, 'DD-MON-YYYY HH24:MI:SS'));
347: -- FND_MSG_PUB.Add;
348: l_instance_asset_tbl.DELETE(i);
349: RAISE Process_next;
350: END IF;

Line 856: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_PARAMETERS');

852: AND (p_instance_asset_query_rec.fa_book_type_code = FND_API.G_MISS_CHAR)
853: AND (p_instance_asset_query_rec.fa_location_id = FND_API.G_MISS_NUM)
854: AND (p_instance_asset_query_rec.update_status = FND_API.G_MISS_CHAR) THEN
855:
856: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_PARAMETERS');
857: FND_MSG_PUB.ADD;
858: RAISE FND_API.G_EXC_ERROR;
859: END IF;
860:

Line 898: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_HIST_PARAMS');

894: IF (p_time_stamp IS NOT NULL) AND (p_time_stamp <> FND_API.G_MISS_DATE) THEN
895: IF p_time_stamp <= sysdate THEN
896: Construct_asset_from_hist(x_instance_asset_tbl, p_time_stamp);
897: ELSE
898: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_HIST_PARAMS');
899: FND_MSG_PUB.ADD;
900: RAISE FND_API.G_EXC_ERROR;
901: END IF;
902: END IF;

Line 1215: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_UPDATE_STATUS');

1211: END IF;
1212: END LOOP;
1213: --
1214: IF l_valid_flag <> 'Y' then
1215: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_UPDATE_STATUS');
1216: FND_MESSAGE.SET_TOKEN('UPDATE_STATUS',p_instance_asset_rec.update_status);
1217: FND_MSG_PUB.Add;
1218: RAISE fnd_api.g_exc_error;
1219: END IF;

Line 1216: FND_MESSAGE.SET_TOKEN('UPDATE_STATUS',p_instance_asset_rec.update_status);

1212: END LOOP;
1213: --
1214: IF l_valid_flag <> 'Y' then
1215: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_UPDATE_STATUS');
1216: FND_MESSAGE.SET_TOKEN('UPDATE_STATUS',p_instance_asset_rec.update_status);
1217: FND_MSG_PUB.Add;
1218: RAISE fnd_api.g_exc_error;
1219: END IF;
1220: END IF;

Line 1263: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ASSET_COMB');

1259: END IF;
1260: END LOOP;
1261: --
1262: IF l_valid_flag <> 'Y' THEN
1263: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ASSET_COMB');
1264: FND_MESSAGE.SET_TOKEN('ASSET_COMBINATION',
1265: p_instance_asset_rec.fa_asset_id||'-'||p_instance_asset_rec.fa_book_type_code);
1266: FND_MSG_PUB.Add;
1267: RAISE fnd_api.g_exc_error;

Line 1264: FND_MESSAGE.SET_TOKEN('ASSET_COMBINATION',

1260: END LOOP;
1261: --
1262: IF l_valid_flag <> 'Y' THEN
1263: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ASSET_COMB');
1264: FND_MESSAGE.SET_TOKEN('ASSET_COMBINATION',
1265: p_instance_asset_rec.fa_asset_id||'-'||p_instance_asset_rec.fa_book_type_code);
1266: FND_MSG_PUB.Add;
1267: RAISE fnd_api.g_exc_error;
1268: END IF;

Line 1370: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ASSET_LOCATION');

1366: END IF;
1367: END LOOP;
1368: --
1369: IF l_valid_flag <> 'Y' THEN
1370: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ASSET_LOCATION');
1371: FND_MESSAGE.SET_TOKEN('ASSET_LOCATION_ID',p_instance_asset_rec.fa_location_id);
1372: FND_MSG_PUB.Add;
1373: RAISE fnd_api.g_exc_error;
1374: END IF;

Line 1371: FND_MESSAGE.SET_TOKEN('ASSET_LOCATION_ID',p_instance_asset_rec.fa_location_id);

1367: END LOOP;
1368: --
1369: IF l_valid_flag <> 'Y' THEN
1370: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ASSET_LOCATION');
1371: FND_MESSAGE.SET_TOKEN('ASSET_LOCATION_ID',p_instance_asset_rec.fa_location_id);
1372: FND_MSG_PUB.Add;
1373: RAISE fnd_api.g_exc_error;
1374: END IF;
1375: END IF;

Line 1428: FND_MESSAGE.SET_NAME('CSI','CSI_FAILED_TO_VALIDATE_TXN');

1424: x_msg_count => x_msg_count,
1425: x_msg_data => x_msg_data);
1426:
1427: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1428: FND_MESSAGE.SET_NAME('CSI','CSI_FAILED_TO_VALIDATE_TXN');
1429: FND_MESSAGE.SET_TOKEN('API_NAME',l_api_name);
1430: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',p_txn_rec.transaction_id );
1431: FND_MSG_PUB.Add;
1432: RAISE fnd_api.g_exc_error;

Line 1429: FND_MESSAGE.SET_TOKEN('API_NAME',l_api_name);

1425: x_msg_data => x_msg_data);
1426:
1427: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1428: FND_MESSAGE.SET_NAME('CSI','CSI_FAILED_TO_VALIDATE_TXN');
1429: FND_MESSAGE.SET_TOKEN('API_NAME',l_api_name);
1430: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',p_txn_rec.transaction_id );
1431: FND_MSG_PUB.Add;
1432: RAISE fnd_api.g_exc_error;
1433: END IF;

Line 1430: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',p_txn_rec.transaction_id );

1426:
1427: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1428: FND_MESSAGE.SET_NAME('CSI','CSI_FAILED_TO_VALIDATE_TXN');
1429: FND_MESSAGE.SET_TOKEN('API_NAME',l_api_name);
1430: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',p_txn_rec.transaction_id );
1431: FND_MSG_PUB.Add;
1432: RAISE fnd_api.g_exc_error;
1433: END IF;
1434: END IF;

Line 1661: FND_MESSAGE.Set_Name('CSI', 'CSI_API_OBJ_VER_MISMATCH');

1657: -- in the database else raise error
1658: OPEN get_curr_asset_rec(p_instance_asset_rec.INSTANCE_ASSET_ID);
1659: FETCH get_curr_asset_rec INTO l_curr_asset_rec;
1660: IF (l_curr_asset_rec.object_version_number <> p_instance_asset_rec.OBJECT_VERSION_NUMBER) THEN
1661: FND_MESSAGE.Set_Name('CSI', 'CSI_API_OBJ_VER_MISMATCH');
1662: FND_MSG_PUB.ADD;
1663: RAISE FND_API.G_EXC_ERROR;
1664: END IF;
1665:

Line 1667: FND_MESSAGE.Set_Name('CSI', 'CSI_API_RECORD_LOCKED');

1663: RAISE FND_API.G_EXC_ERROR;
1664: END IF;
1665:
1666: IF get_curr_asset_rec%NOTFOUND THEN
1667: FND_MESSAGE.Set_Name('CSI', 'CSI_API_RECORD_LOCKED');
1668: FND_MSG_PUB.ADD;
1669: RAISE FND_API.G_EXC_ERROR;
1670: END IF;
1671: CLOSE get_curr_asset_rec;

Line 1707: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_UPDATE_STATUS');

1703: END IF;
1704: End Loop;
1705: --
1706: if l_valid_flag <> 'Y' then
1707: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_UPDATE_STATUS');
1708: FND_MESSAGE.SET_TOKEN('UPDATE_STATUS',p_instance_asset_rec.update_status);
1709: FND_MSG_PUB.Add;
1710: RAISE fnd_api.g_exc_error;
1711: end if;

Line 1708: FND_MESSAGE.SET_TOKEN('UPDATE_STATUS',p_instance_asset_rec.update_status);

1704: End Loop;
1705: --
1706: if l_valid_flag <> 'Y' then
1707: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_UPDATE_STATUS');
1708: FND_MESSAGE.SET_TOKEN('UPDATE_STATUS',p_instance_asset_rec.update_status);
1709: FND_MSG_PUB.Add;
1710: RAISE fnd_api.g_exc_error;
1711: end if;
1712: End if;

Line 1749: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ASSET_COMB');

1745: END IF;
1746: END LOOP;
1747: --
1748: IF l_valid_flag <> 'Y' THEN
1749: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ASSET_COMB');
1750: FND_MESSAGE.SET_TOKEN('ASSET_COMBINATION',p_instance_asset_rec.fa_asset_id||'-'||p_instance_asset_rec.fa_book_type_code);
1751: FND_MSG_PUB.Add;
1752: RAISE fnd_api.g_exc_error;
1753: END IF;

Line 1750: FND_MESSAGE.SET_TOKEN('ASSET_COMBINATION',p_instance_asset_rec.fa_asset_id||'-'||p_instance_asset_rec.fa_book_type_code);

1746: END LOOP;
1747: --
1748: IF l_valid_flag <> 'Y' THEN
1749: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ASSET_COMB');
1750: FND_MESSAGE.SET_TOKEN('ASSET_COMBINATION',p_instance_asset_rec.fa_asset_id||'-'||p_instance_asset_rec.fa_book_type_code);
1751: FND_MSG_PUB.Add;
1752: RAISE fnd_api.g_exc_error;
1753: END IF;
1754: END IF;

Line 1790: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ASSET_LOCATION');

1786: END IF;
1787: END LOOP;
1788: --
1789: IF l_valid_flag <> 'Y' THEN
1790: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ASSET_LOCATION');
1791: FND_MESSAGE.SET_TOKEN('ASSET_LOCATION_ID',p_instance_asset_rec.fa_location_id);
1792: FND_MSG_PUB.Add;
1793: RAISE fnd_api.g_exc_error;
1794: END IF;

Line 1791: FND_MESSAGE.SET_TOKEN('ASSET_LOCATION_ID',p_instance_asset_rec.fa_location_id);

1787: END LOOP;
1788: --
1789: IF l_valid_flag <> 'Y' THEN
1790: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_ASSET_LOCATION');
1791: FND_MESSAGE.SET_TOKEN('ASSET_LOCATION_ID',p_instance_asset_rec.fa_location_id);
1792: FND_MSG_PUB.Add;
1793: RAISE fnd_api.g_exc_error;
1794: END IF;
1795: END IF;

Line 1814: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');

1810:
1811: -- Validation for the Active start date
1812: IF p_instance_asset_rec.active_start_date <> FND_API.G_MISS_DATE THEN
1813: IF p_instance_asset_rec.active_start_date <> l_curr_asset_rec.active_start_date THEN
1814: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
1815: FND_MESSAGE.Set_Token('COLUMN', 'ACTIVE_START_DATE');
1816: FND_MSG_PUB.ADD;
1817: RAISE FND_API.G_EXC_ERROR;
1818: END IF;

Line 1815: FND_MESSAGE.Set_Token('COLUMN', 'ACTIVE_START_DATE');

1811: -- Validation for the Active start date
1812: IF p_instance_asset_rec.active_start_date <> FND_API.G_MISS_DATE THEN
1813: IF p_instance_asset_rec.active_start_date <> l_curr_asset_rec.active_start_date THEN
1814: FND_MESSAGE.Set_Name('CSI', 'CSI_API_UPD_NOT_ALLOWED');
1815: FND_MESSAGE.Set_Token('COLUMN', 'ACTIVE_START_DATE');
1816: FND_MSG_PUB.ADD;
1817: RAISE FND_API.G_EXC_ERROR;
1818: END IF;
1819: END IF;

Line 1931: FND_MESSAGE.SET_NAME('CSI','CSI_FAILED_TO_VALIDATE_TXN');

1927: x_msg_count => x_msg_count,
1928: x_msg_data => x_msg_data);
1929:
1930: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1931: FND_MESSAGE.SET_NAME('CSI','CSI_FAILED_TO_VALIDATE_TXN');
1932: FND_MESSAGE.SET_TOKEN('API_NAME',l_api_name);
1933: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',p_txn_rec.transaction_id );
1934: FND_MSG_PUB.Add;
1935: FOR i in 1..x_msg_Count LOOP

Line 1932: FND_MESSAGE.SET_TOKEN('API_NAME',l_api_name);

1928: x_msg_data => x_msg_data);
1929:
1930: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1931: FND_MESSAGE.SET_NAME('CSI','CSI_FAILED_TO_VALIDATE_TXN');
1932: FND_MESSAGE.SET_TOKEN('API_NAME',l_api_name);
1933: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',p_txn_rec.transaction_id );
1934: FND_MSG_PUB.Add;
1935: FOR i in 1..x_msg_Count LOOP
1936: FND_MSG_PUB.Get(p_msg_index => i,

Line 1933: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',p_txn_rec.transaction_id );

1929:
1930: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1931: FND_MESSAGE.SET_NAME('CSI','CSI_FAILED_TO_VALIDATE_TXN');
1932: FND_MESSAGE.SET_TOKEN('API_NAME',l_api_name);
1933: FND_MESSAGE.SET_TOKEN('TRANSACTION_ID',p_txn_rec.transaction_id );
1934: FND_MSG_PUB.Add;
1935: FOR i in 1..x_msg_Count LOOP
1936: FND_MSG_PUB.Get(p_msg_index => i,
1937: p_encoded => 'F',

Line 1960: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_FULL_DUMP_FAILED');

1956: --
1957: l_full_dump_frequency := csi_datastructures_pub.g_install_param_rec.history_full_dump_frequency;
1958: --
1959: IF l_full_dump_frequency IS NULL THEN
1960: FND_MESSAGE.SET_NAME('CSI','CSI_API_GET_FULL_DUMP_FAILED');
1961: FND_MSG_PUB.ADD;
1962: RAISE FND_API.G_EXC_ERROR;
1963: END IF;
1964: --

Line 3432: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_PARAMETERS');

3428: ELSE
3429: IF (l_csi_debug_level > 0) THEN
3430: debug( 'Get_syncup_tree');
3431: END IF;
3432: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_PARAMETERS');
3433: FND_MSG_PUB.ADD;
3434: RAISE FND_API.G_EXC_ERROR;
3435: END IF;
3436: /*-- Loop untill all item instances or assets are explored --*/