[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 ;
3035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3036: END IF;
3037: -- Initialize message list if p_init_msg_list is set to TRUE.
3038: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3039: FND_MSG_PUB.initialize;
3040: END IF;
3041: -- Initialize API return status to success
3042: x_return_status := FND_API.G_RET_STS_SUCCESS;
3043: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
3121:
3122: EXCEPTION
3123: WHEN FND_API.G_EXC_ERROR THEN
3124: x_return_status := FND_API.G_RET_STS_ERROR ;
3125: FND_MSG_PUB.Count_And_Get
3126: ( p_count => x_msg_count,
3127: p_data => x_msg_data );
3128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3126: ( p_count => x_msg_count,
3127: p_data => x_msg_data );
3128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3130: FND_MSG_PUB.Count_And_Get
3131: ( p_count => x_msg_count,
3132: p_data => x_msg_data );
3133: WHEN OTHERS THEN
3134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3131: ( p_count => x_msg_count,
3132: p_data => x_msg_data );
3133: WHEN OTHERS THEN
3134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3135: IF FND_MSG_PUB.Check_Msg_Level
3136: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3137: THEN
3138: FND_MSG_PUB.Add_Exc_Msg
3139: ( G_PKG_NAME ,
3132: p_data => x_msg_data );
3133: WHEN OTHERS THEN
3134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3135: IF FND_MSG_PUB.Check_Msg_Level
3136: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3137: THEN
3138: FND_MSG_PUB.Add_Exc_Msg
3139: ( G_PKG_NAME ,
3140: l_api_name );
3134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3135: IF FND_MSG_PUB.Check_Msg_Level
3136: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3137: THEN
3138: FND_MSG_PUB.Add_Exc_Msg
3139: ( G_PKG_NAME ,
3140: l_api_name );
3141: END IF;
3142: FND_MSG_PUB.Count_And_Get
3138: FND_MSG_PUB.Add_Exc_Msg
3139: ( G_PKG_NAME ,
3140: l_api_name );
3141: END IF;
3142: FND_MSG_PUB.Count_And_Get
3143: ( p_count => x_msg_count,
3144: p_data => x_msg_data );
3145: END get_attached_item_instances;
3146:
3209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3210: END IF;
3211: -- Initialize message list if p_init_msg_list is set to TRUE.
3212: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3213: FND_MSG_PUB.initialize;
3214: END IF;
3215: -- Initialize API return status to success
3216: x_return_status := FND_API.G_RET_STS_SUCCESS;
3217: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
3272: debug(' After get_attached_asset_links');
3273: EXCEPTION
3274: WHEN FND_API.G_EXC_ERROR THEN
3275: x_return_status := FND_API.G_RET_STS_ERROR ;
3276: FND_MSG_PUB.Count_And_Get
3277: ( p_count => x_msg_count,
3278: p_data => x_msg_data );
3279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3277: ( p_count => x_msg_count,
3278: p_data => x_msg_data );
3279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3281: FND_MSG_PUB.Count_And_Get
3282: ( p_count => x_msg_count,
3283: p_data => x_msg_data );
3284: WHEN OTHERS THEN
3285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3282: ( p_count => x_msg_count,
3283: p_data => x_msg_data );
3284: WHEN OTHERS THEN
3285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3286: IF FND_MSG_PUB.Check_Msg_Level
3287: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3288: THEN
3289: FND_MSG_PUB.Add_Exc_Msg
3290: ( G_PKG_NAME ,
3283: p_data => x_msg_data );
3284: WHEN OTHERS THEN
3285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3286: IF FND_MSG_PUB.Check_Msg_Level
3287: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3288: THEN
3289: FND_MSG_PUB.Add_Exc_Msg
3290: ( G_PKG_NAME ,
3291: l_api_name );
3285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3286: IF FND_MSG_PUB.Check_Msg_Level
3287: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3288: THEN
3289: FND_MSG_PUB.Add_Exc_Msg
3290: ( G_PKG_NAME ,
3291: l_api_name );
3292: END IF;
3293: FND_MSG_PUB.Count_And_Get
3289: FND_MSG_PUB.Add_Exc_Msg
3290: ( G_PKG_NAME ,
3291: l_api_name );
3292: END IF;
3293: FND_MSG_PUB.Count_And_Get
3294: ( p_count => x_msg_count,
3295: p_data => x_msg_data );
3296: END get_attached_asset_links;
3297:
3336: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3337: END IF;
3338: -- Initialize message list if p_init_msg_list is set to TRUE.
3339: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3340: FND_MSG_PUB.initialize;
3341: END IF;
3342: -- Initialize API return status to success
3343: x_return_status := FND_API.G_RET_STS_SUCCESS;
3344: -- Check the profile option CSI_DEBUG_LEVEL for debug message reporting
3387: END LOOP;
3388: EXCEPTION
3389: WHEN FND_API.G_EXC_ERROR THEN
3390: x_return_status := FND_API.G_RET_STS_ERROR ;
3391: FND_MSG_PUB.Count_And_Get
3392: ( p_count => x_msg_count,
3393: p_data => x_msg_data );
3394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3392: ( p_count => x_msg_count,
3393: p_data => x_msg_data );
3394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3396: FND_MSG_PUB.Count_And_Get
3397: ( p_count => x_msg_count,
3398: p_data => x_msg_data );
3399: WHEN OTHERS THEN
3400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3397: ( p_count => x_msg_count,
3398: p_data => x_msg_data );
3399: WHEN OTHERS THEN
3400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3401: IF FND_MSG_PUB.Check_Msg_Level
3402: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3403: THEN
3404: FND_MSG_PUB.Add_Exc_Msg
3405: ( G_PKG_NAME ,
3398: p_data => x_msg_data );
3399: WHEN OTHERS THEN
3400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3401: IF FND_MSG_PUB.Check_Msg_Level
3402: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3403: THEN
3404: FND_MSG_PUB.Add_Exc_Msg
3405: ( G_PKG_NAME ,
3406: l_api_name );
3400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3401: IF FND_MSG_PUB.Check_Msg_Level
3402: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3403: THEN
3404: FND_MSG_PUB.Add_Exc_Msg
3405: ( G_PKG_NAME ,
3406: l_api_name );
3407: END IF;
3408: FND_MSG_PUB.Count_And_Get
3404: FND_MSG_PUB.Add_Exc_Msg
3405: ( G_PKG_NAME ,
3406: l_api_name );
3407: END IF;
3408: FND_MSG_PUB.Count_And_Get
3409: ( p_count => x_msg_count,
3410: p_data => x_msg_data );
3411: END get_fa_asset_details ;
3412:
3453: IF (l_csi_debug_level > 0) THEN
3454: debug( 'Get_syncup_tree');
3455: END IF;
3456: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_PARAMETERS');
3457: FND_MSG_PUB.ADD;
3458: RAISE FND_API.G_EXC_ERROR;
3459: END IF;
3460: /*-- Loop untill all item instances or assets are explored --*/
3461: WHILE l_process_loop
3716: EXCEPTION
3717: WHEN fnd_api.g_exc_error THEN
3718: ROLLBACK TO create_instance_assets;
3719: x_return_status := fnd_api.g_ret_sts_error;
3720: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data );
3721: WHEN others THEN
3722: ROLLBACK TO create_instance_assets;
3723: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3724: fnd_msg_pub.add_exc_msg(g_pkg_name , l_api_name);
3720: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data );
3721: WHEN others THEN
3722: ROLLBACK TO create_instance_assets;
3723: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3724: fnd_msg_pub.add_exc_msg(g_pkg_name , l_api_name);
3725: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
3726: END create_instance_assets;
3727:
3728: END csi_asset_pvt;
3721: WHEN others THEN
3722: ROLLBACK TO create_instance_assets;
3723: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3724: fnd_msg_pub.add_exc_msg(g_pkg_name , l_api_name);
3725: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data );
3726: END create_instance_assets;
3727:
3728: END csi_asset_pvt;
3729: