[Home] [Help]
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
224: select address1||','||address2||','||address3||','||address4||','||city||','||state||','||postal_code||','||country
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;
236: End;
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;
259: EXCEPTION
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;
351:
824: END IF;
825:
826: -- Initialize message list if p_init_msg_list is set to TRUE.
827: IF FND_API.to_Boolean( p_init_msg_list ) THEN
828: FND_MSG_PUB.initialize;
829: END IF;
830:
831: -- Initialize API return status to success
832: x_return_status := FND_API.G_RET_STS_SUCCESS;
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:
861: -- Generate the where clause
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;
903:
928: -- End disable trace
929: ****/
930:
931: -- Standard call to get message count and if count is get message info.
932: FND_MSG_PUB.Count_And_Get
933: (p_count => x_msg_count ,
934: p_data => x_msg_data );
935:
936: EXCEPTION
941: ROLLBACK TO get_instance_asset_pvt;
942: END IF;
943: */
944: x_return_status := FND_API.G_RET_STS_ERROR ;
945: FND_MSG_PUB.Count_And_Get
946: ( p_count => x_msg_count,
947: p_data => x_msg_data);
948: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
949: /*
952: ROLLBACK TO get_instance_asset_pvt;
953: END IF;
954: */
955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
956: FND_MSG_PUB.Count_And_Get
957: ( p_count => x_msg_count,
958: p_data => x_msg_data);
959: WHEN OTHERS THEN
960: /*
966: IF DBMS_SQL.IS_OPEN(l_get_inst_asset_cursor_id) THEN
967: DBMS_SQL.CLOSE_CURSOR(l_get_inst_asset_cursor_id);
968: END IF;
969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
970: IF FND_MSG_PUB.Check_Msg_Level
971: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
972: THEN
973: FND_MSG_PUB.Add_Exc_Msg
974: ( G_PKG_NAME ,
967: DBMS_SQL.CLOSE_CURSOR(l_get_inst_asset_cursor_id);
968: END IF;
969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
970: IF FND_MSG_PUB.Check_Msg_Level
971: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
972: THEN
973: FND_MSG_PUB.Add_Exc_Msg
974: ( G_PKG_NAME ,
975: l_api_name );
969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
970: IF FND_MSG_PUB.Check_Msg_Level
971: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
972: THEN
973: FND_MSG_PUB.Add_Exc_Msg
974: ( G_PKG_NAME ,
975: l_api_name );
976: END IF;
977: FND_MSG_PUB.Count_And_Get
973: FND_MSG_PUB.Add_Exc_Msg
974: ( G_PKG_NAME ,
975: l_api_name );
976: END IF;
977: FND_MSG_PUB.Count_And_Get
978: ( p_count => x_msg_count,
979: p_data => x_msg_data );
980: END get_instance_assets;
981:
1033: END IF;
1034:
1035: -- Initialize message list if p_init_msg_list is set to TRUE.
1036: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1037: FND_MSG_PUB.initialize;
1038: END IF;
1039:
1040: -- Initialize API return status to success
1041: x_return_status := FND_API.G_RET_STS_SUCCESS;
1139: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1140: l_msg_index := 1;
1141: l_msg_count := x_msg_count;
1142: WHILE l_msg_count > 0 LOOP
1143: x_msg_data := FND_MSG_PUB.GET ( l_msg_index, FND_API.G_FALSE );
1144: debug( ' Failed Pvt:update_instance_asset..');
1145: debug('message data = '||x_msg_data);
1146: l_msg_index := l_msg_index + 1;
1147: l_msg_count := l_msg_count - 1;
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;
1221: --
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;
1269: END IF;
1270: --
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;
1376: --
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;
1435:
1497: COMMIT WORK;
1498: END IF;
1499:
1500: -- Standard call to get message count and if count is get message info.
1501: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1502:
1503: debug(' end of create_instance_asset.'||x_return_status);
1504:
1505: EXCEPTION
1507: IF fnd_api.to_boolean(p_commit) THEN
1508: ROLLBACK TO create_instance_asset_pvt;
1509: END IF;
1510: x_return_status := fnd_api.g_ret_sts_error;
1511: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1512: l_error_message := csi_gen_utility_pvt.dump_error_stack;
1513: debug('error(E): '||l_error_message);
1514: WHEN fnd_api.g_exc_unexpected_error THEN
1515: IF fnd_api.to_boolean(p_commit) THEN
1515: IF fnd_api.to_boolean(p_commit) THEN
1516: ROLLBACK TO create_instance_asset_pvt;
1517: END IF;
1518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1519: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1520: l_error_message := csi_gen_utility_pvt.dump_error_stack;
1521: debug('error(U): '||l_error_message);
1522: WHEN OTHERS THEN
1523: IF fnd_api.to_boolean(p_commit) THEN
1523: IF fnd_api.to_boolean(p_commit) THEN
1524: ROLLBACK TO create_instance_asset_pvt;
1525: END IF;
1526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1527: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1528: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1529: l_error_message := csi_gen_utility_pvt.dump_error_stack;
1530: debug('error(0): '||l_error_message);
1531: END create_instance_asset;
1524: ROLLBACK TO create_instance_asset_pvt;
1525: END IF;
1526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1527: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
1528: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1529: l_error_message := csi_gen_utility_pvt.dump_error_stack;
1530: debug('error(0): '||l_error_message);
1531: END create_instance_asset;
1532:
1606: END IF;
1607:
1608: -- Initialize message list if p_init_msg_list is set to TRUE.
1609: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1610: FND_MSG_PUB.initialize;
1611: END IF;
1612:
1613: -- Initialize API return status to success
1614: x_return_status := FND_API.G_RET_STS_SUCCESS;
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:
1666: IF get_curr_asset_rec%NOTFOUND THEN
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;
1672: --
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;
1713: --
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;
1755: --
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;
1796: --
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;
1820:
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',
1938: p_data => x_msg_data,
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',
1938: p_data => x_msg_data,
1939: p_msg_index_out => x_msg_index_out );
1940: debug( 'message data = '||x_msg_data);
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: --
1965: SELECT mod(l_object_version_number,l_full_dump_frequency)
2387: );
2388:
2389: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2390: FOR i in 1..x_msg_Count LOOP
2391: FND_MSG_PUB.Get(p_msg_index => i,
2392: p_encoded => 'F',
2393: p_data => x_msg_data,
2394: p_msg_index_out => x_msg_index_out );
2395: End LOOP;
2404: COMMIT WORK;
2405: END IF;
2406:
2407: -- Standard call to get message count and if count is get message info.
2408: FND_MSG_PUB.Count_And_Get(
2409: p_count => x_msg_count ,
2410: p_data => x_msg_data);
2411: EXCEPTION
2412: WHEN FND_API.G_EXC_ERROR THEN
2413: X_return_status := FND_API.G_RET_STS_ERROR ;
2414: IF fnd_api.to_boolean(p_commit) THEN
2415: ROLLBACK TO update_instance_asset_pvt;
2416: END IF;
2417: FND_MSG_PUB.Count_And_Get (
2418: p_count => x_msg_count,
2419: p_data => x_msg_data);
2420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2421: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2421: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2422: IF fnd_api.to_boolean(p_commit) THEN
2423: ROLLBACK TO update_instance_asset_pvt;
2424: END IF;
2425: FND_MSG_PUB.Count_And_Get(
2426: p_count => x_msg_count,
2427: p_data => x_msg_data);
2428: WHEN OTHERS THEN
2429: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2429: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2430: IF fnd_api.to_boolean(p_commit) THEN
2431: ROLLBACK TO update_instance_asset_pvt;
2432: END IF;
2433: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2434: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
2435: END IF;
2436: FND_MSG_PUB.Count_And_Get(
2437: p_count => x_msg_count,
2430: IF fnd_api.to_boolean(p_commit) THEN
2431: ROLLBACK TO update_instance_asset_pvt;
2432: END IF;
2433: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2434: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
2435: END IF;
2436: FND_MSG_PUB.Count_And_Get(
2437: p_count => x_msg_count,
2438: p_data => x_msg_data);
2432: END IF;
2433: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2434: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, l_api_name );
2435: END IF;
2436: FND_MSG_PUB.Count_And_Get(
2437: p_count => x_msg_count,
2438: p_data => x_msg_data);
2439: END update_instance_asset;
2440:
2513: END IF;
2514:
2515: -- Initialize message list if p_init_msg_list is set to TRUE.
2516: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2517: FND_MSG_PUB.initialize;
2518: END IF;
2519:
2520: -- Initialize API return status to success
2521: x_return_status := FND_API.G_RET_STS_SUCCESS;
2787: -- End disable trace
2788: ****/
2789:
2790: -- Standard call to get message count and if count is get message info.
2791: FND_MSG_PUB.Count_And_Get
2792: (p_count => x_msg_count ,
2793: p_data => x_msg_data );
2794: EXCEPTION
2795: WHEN OTHERS THEN
2799: THEN
2800: ROLLBACK TO get_instance_asset_hist;
2801: END IF;
2802: */
2803: IF FND_MSG_PUB.Check_Msg_Level
2804: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2805: THEN
2806: FND_MSG_PUB.Add_Exc_Msg
2807: ( G_PKG_NAME, l_api_name );
2800: ROLLBACK TO get_instance_asset_hist;
2801: END IF;
2802: */
2803: IF FND_MSG_PUB.Check_Msg_Level
2804: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2805: THEN
2806: FND_MSG_PUB.Add_Exc_Msg
2807: ( G_PKG_NAME, l_api_name );
2808: END IF;
2802: */
2803: IF FND_MSG_PUB.Check_Msg_Level
2804: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2805: THEN
2806: FND_MSG_PUB.Add_Exc_Msg
2807: ( G_PKG_NAME, l_api_name );
2808: END IF;
2809: FND_MSG_PUB.Count_And_Get
2810: ( p_count => x_msg_count,
2805: THEN
2806: FND_MSG_PUB.Add_Exc_Msg
2807: ( G_PKG_NAME, l_api_name );
2808: END IF;
2809: FND_MSG_PUB.Count_And_Get
2810: ( p_count => x_msg_count,
2811: p_data => x_msg_data);
2812:
2813: END get_instance_asset_hist ;
3011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3012: END IF;
3013: -- Initialize message list if p_init_msg_list is set to TRUE.
3014: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3015: FND_MSG_PUB.initialize;
3016: END IF;
3017: -- Initialize API return status to success
3018: x_return_status := FND_API.G_RET_STS_SUCCESS;
3019: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
3097:
3098: EXCEPTION
3099: WHEN FND_API.G_EXC_ERROR THEN
3100: x_return_status := FND_API.G_RET_STS_ERROR ;
3101: FND_MSG_PUB.Count_And_Get
3102: ( p_count => x_msg_count,
3103: p_data => x_msg_data );
3104: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3102: ( p_count => x_msg_count,
3103: p_data => x_msg_data );
3104: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3106: FND_MSG_PUB.Count_And_Get
3107: ( p_count => x_msg_count,
3108: p_data => x_msg_data );
3109: WHEN OTHERS THEN
3110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3107: ( p_count => x_msg_count,
3108: p_data => x_msg_data );
3109: WHEN OTHERS THEN
3110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3111: IF FND_MSG_PUB.Check_Msg_Level
3112: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3113: THEN
3114: FND_MSG_PUB.Add_Exc_Msg
3115: ( G_PKG_NAME ,
3108: p_data => x_msg_data );
3109: WHEN OTHERS THEN
3110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3111: IF FND_MSG_PUB.Check_Msg_Level
3112: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3113: THEN
3114: FND_MSG_PUB.Add_Exc_Msg
3115: ( G_PKG_NAME ,
3116: l_api_name );
3110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3111: IF FND_MSG_PUB.Check_Msg_Level
3112: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3113: THEN
3114: FND_MSG_PUB.Add_Exc_Msg
3115: ( G_PKG_NAME ,
3116: l_api_name );
3117: END IF;
3118: FND_MSG_PUB.Count_And_Get
3114: FND_MSG_PUB.Add_Exc_Msg
3115: ( G_PKG_NAME ,
3116: l_api_name );
3117: END IF;
3118: FND_MSG_PUB.Count_And_Get
3119: ( p_count => x_msg_count,
3120: p_data => x_msg_data );
3121: END get_attached_item_instances;
3122:
3185: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3186: END IF;
3187: -- Initialize message list if p_init_msg_list is set to TRUE.
3188: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3189: FND_MSG_PUB.initialize;
3190: END IF;
3191: -- Initialize API return status to success
3192: x_return_status := FND_API.G_RET_STS_SUCCESS;
3193: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
3248: debug(' After get_attached_asset_links');
3249: EXCEPTION
3250: WHEN FND_API.G_EXC_ERROR THEN
3251: x_return_status := FND_API.G_RET_STS_ERROR ;
3252: FND_MSG_PUB.Count_And_Get
3253: ( p_count => x_msg_count,
3254: p_data => x_msg_data );
3255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3253: ( p_count => x_msg_count,
3254: p_data => x_msg_data );
3255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3257: FND_MSG_PUB.Count_And_Get
3258: ( p_count => x_msg_count,
3259: p_data => x_msg_data );
3260: WHEN OTHERS THEN
3261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3258: ( p_count => x_msg_count,
3259: p_data => x_msg_data );
3260: WHEN OTHERS THEN
3261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3262: IF FND_MSG_PUB.Check_Msg_Level
3263: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3264: THEN
3265: FND_MSG_PUB.Add_Exc_Msg
3266: ( G_PKG_NAME ,
3259: p_data => x_msg_data );
3260: WHEN OTHERS THEN
3261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3262: IF FND_MSG_PUB.Check_Msg_Level
3263: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3264: THEN
3265: FND_MSG_PUB.Add_Exc_Msg
3266: ( G_PKG_NAME ,
3267: l_api_name );
3261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3262: IF FND_MSG_PUB.Check_Msg_Level
3263: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3264: THEN
3265: FND_MSG_PUB.Add_Exc_Msg
3266: ( G_PKG_NAME ,
3267: l_api_name );
3268: END IF;
3269: FND_MSG_PUB.Count_And_Get
3265: FND_MSG_PUB.Add_Exc_Msg
3266: ( G_PKG_NAME ,
3267: l_api_name );
3268: END IF;
3269: FND_MSG_PUB.Count_And_Get
3270: ( p_count => x_msg_count,
3271: p_data => x_msg_data );
3272: END get_attached_asset_links;
3273:
3312: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3313: END IF;
3314: -- Initialize message list if p_init_msg_list is set to TRUE.
3315: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3316: FND_MSG_PUB.initialize;
3317: END IF;
3318: -- Initialize API return status to success
3319: x_return_status := FND_API.G_RET_STS_SUCCESS;
3320: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
3363: END LOOP;
3364: EXCEPTION
3365: WHEN FND_API.G_EXC_ERROR THEN
3366: x_return_status := FND_API.G_RET_STS_ERROR ;
3367: FND_MSG_PUB.Count_And_Get
3368: ( p_count => x_msg_count,
3369: p_data => x_msg_data );
3370: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3368: ( p_count => x_msg_count,
3369: p_data => x_msg_data );
3370: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3371: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3372: FND_MSG_PUB.Count_And_Get
3373: ( p_count => x_msg_count,
3374: p_data => x_msg_data );
3375: WHEN OTHERS THEN
3376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3373: ( p_count => x_msg_count,
3374: p_data => x_msg_data );
3375: WHEN OTHERS THEN
3376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3377: IF FND_MSG_PUB.Check_Msg_Level
3378: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3379: THEN
3380: FND_MSG_PUB.Add_Exc_Msg
3381: ( G_PKG_NAME ,
3374: p_data => x_msg_data );
3375: WHEN OTHERS THEN
3376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3377: IF FND_MSG_PUB.Check_Msg_Level
3378: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3379: THEN
3380: FND_MSG_PUB.Add_Exc_Msg
3381: ( G_PKG_NAME ,
3382: l_api_name );
3376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3377: IF FND_MSG_PUB.Check_Msg_Level
3378: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3379: THEN
3380: FND_MSG_PUB.Add_Exc_Msg
3381: ( G_PKG_NAME ,
3382: l_api_name );
3383: END IF;
3384: FND_MSG_PUB.Count_And_Get
3380: FND_MSG_PUB.Add_Exc_Msg
3381: ( G_PKG_NAME ,
3382: l_api_name );
3383: END IF;
3384: FND_MSG_PUB.Count_And_Get
3385: ( p_count => x_msg_count,
3386: p_data => x_msg_data );
3387: END get_fa_asset_details ;
3388:
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 --*/
3437: WHILE l_process_loop
3692: EXCEPTION
3693: WHEN fnd_api.g_exc_error THEN
3694: ROLLBACK TO create_instance_assets;
3695: x_return_status := fnd_api.g_ret_sts_error;
3696: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data );
3697: WHEN others THEN
3698: ROLLBACK TO create_instance_assets;
3699: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3700: fnd_msg_pub.add_exc_msg(g_pkg_name , l_api_name);
3696: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data );
3697: WHEN others THEN
3698: ROLLBACK TO create_instance_assets;
3699: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3700: fnd_msg_pub.add_exc_msg(g_pkg_name , l_api_name);
3701: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
3702: END create_instance_assets;
3703:
3704: END csi_asset_pvt;
3697: WHEN others THEN
3698: ROLLBACK TO create_instance_assets;
3699: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3700: fnd_msg_pub.add_exc_msg(g_pkg_name , l_api_name);
3701: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
3702: END create_instance_assets;
3703:
3704: END csi_asset_pvt;
3705: