[Home] [Help]
418: BEGIN
419: --Initialize API return status to success
420: x_return_status := FND_API.G_RET_STS_SUCCESS;
421:
422: -- Standard Start of API savepoint
423: SAVEPOINT unassociate_instance_pos;
424:
425: --Standard call to check for call compatibility.
426: IF NOT FND_API.compatible_api_call(
421:
422: -- Standard Start of API savepoint
423: SAVEPOINT unassociate_instance_pos;
424:
425: --Standard call to check for call compatibility.
426: IF NOT FND_API.compatible_api_call(
427: l_api_version,
428: p_api_version,
429: l_api_name,
865: BEGIN
866: --Initialize API return status to success
867: x_return_status := FND_API.G_RET_STS_SUCCESS;
868:
869: -- Standard Start of API savepoint
870: SAVEPOINT remove_instance;
871:
872: --Standard call to check for call compatibility.
873: IF NOT FND_API.compatible_api_call(
868:
869: -- Standard Start of API savepoint
870: SAVEPOINT remove_instance;
871:
872: --Standard call to check for call compatibility.
873: IF NOT FND_API.compatible_api_call(
874: l_api_version,
875: p_api_version,
876: l_api_name,
1386: BEGIN
1387: --Initialize API return status to success
1388: x_return_status := FND_API.G_RET_STS_SUCCESS;
1389:
1390: -- Standard Start of API savepoint
1391: SAVEPOINT update_instance_attr;
1392:
1393: --Standard call to check for call compatibility.
1394: IF NOT FND_API.compatible_api_call(
1389:
1390: -- Standard Start of API savepoint
1391: SAVEPOINT update_instance_attr;
1392:
1393: --Standard call to check for call compatibility.
1394: IF NOT FND_API.compatible_api_call(
1395: l_api_version,
1396: p_api_version,
1397: l_api_name,
1594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1595: END IF;
1596:
1597: --Validate against inventory for changed items.
1598: --Following the old G_MISS standard, passing G_MISS value means no change for that column.
1599: IF (l_uc_instance_rec.relationship_id = FND_API.G_MISS_NUM OR
1600: l_uc_instance_rec.relationship_id IS NULL ) THEN
1601: l_uc_instance_rec.relationship_id := TO_NUMBER(l_position_reference);
1602: END IF;
1626: l_uc_instance_rec.install_date := l_old_uc_instance_rec.install_date;
1627: END IF;
1628:
1629: --For the following updatable columns, front end code following the new
1630: --API G_MISS standard. If the value is blank, then pass G_MISS, othewise
1631: --pass the old value(unchanged) or new value (changed)
1632: IF (l_uc_instance_rec.serial_number = FND_API.G_MISS_CHAR) THEN
1633: l_uc_instance_rec.serial_number := NULL;
1634: END IF;
2419: BEGIN
2420: --Initialize API return status to success
2421: x_return_status := FND_API.G_RET_STS_SUCCESS;
2422:
2423: -- Standard Start of API savepoint
2424: SAVEPOINT install_new_instance;
2425:
2426: --Standard call to check for call compatibility.
2427: IF NOT FND_API.compatible_api_call(
2422:
2423: -- Standard Start of API savepoint
2424: SAVEPOINT install_new_instance;
2425:
2426: --Standard call to check for call compatibility.
2427: IF NOT FND_API.compatible_api_call(
2428: l_api_version,
2429: p_api_version,
2430: l_api_name,
3610: BEGIN
3611: --Initialize API return status to success
3612: x_return_status := FND_API.G_RET_STS_SUCCESS;
3613:
3614: -- Standard Start of API savepoint
3615: SAVEPOINT install_existing_instance;
3616:
3617: --Standard call to check for call compatibility.
3618: IF NOT FND_API.compatible_api_call(
3613:
3614: -- Standard Start of API savepoint
3615: SAVEPOINT install_existing_instance;
3616:
3617: --Standard call to check for call compatibility.
3618: IF NOT FND_API.compatible_api_call(
3619: l_api_version,
3620: p_api_version,
3621: l_api_name, G_PKG_NAME)
4450: BEGIN
4451: -- Initialize API return status to success
4452: x_return_status := FND_API.G_RET_STS_SUCCESS;
4453:
4454: -- Standard Start of API savepoint
4455: SAVEPOINT swap_instance;
4456:
4457: -- Standard call to check for call compatibility.
4458: IF NOT FND_API.compatible_api_call(
4453:
4454: -- Standard Start of API savepoint
4455: SAVEPOINT swap_instance;
4456:
4457: -- Standard call to check for call compatibility.
4458: IF NOT FND_API.compatible_api_call(
4459: l_api_version,
4460: p_api_version,
4461: l_api_name,
5015: -------------------------------
5016: -- Initialize API return status to success
5017: x_return_status := FND_API.G_RET_STS_SUCCESS;
5018:
5019: -- Standard call to check for call compatibility.
5020: IF NOT FND_API.compatible_api_call(
5021: l_api_version,
5022: p_api_version,
5023: l_api_name,
5773:
5774: BEGIN
5775: -- Initialize API return status to success
5776: x_return_status := FND_API.G_RET_STS_SUCCESS;
5777: -- Standard call to check for call compatibility.
5778: IF NOT FND_API.compatible_api_call(
5779: l_api_version,
5780: p_api_version,
5781: l_api_name,
6174: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
6175: FND_LOG.string(FND_LOG.level_procedure,l_full_name,'Start of the API');
6176: END IF;
6177:
6178: -- Standard start of API savepoint
6179: SAVEPOINT create_unassigned_instance;
6180:
6181: -- Initialize Procedure return status to success
6182: x_return_status := FND_API.G_RET_STS_SUCCESS;
6180:
6181: -- Initialize Procedure return status to success
6182: x_return_status := FND_API.G_RET_STS_SUCCESS;
6183:
6184: -- Standard call to check for call compatibility
6185: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version,
6186: l_api_name, G_PKG_NAME) THEN
6187: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6188: END IF;
6502: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
6503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6504: END IF;
6505:
6506: -- Standard check of p_commit
6507: IF FND_API.TO_BOOLEAN(p_commit) THEN
6508: COMMIT WORK;
6509: END IF;
6510:
6507: IF FND_API.TO_BOOLEAN(p_commit) THEN
6508: COMMIT WORK;
6509: END IF;
6510:
6511: -- Standard call to get message count and if count is 1, get message info
6512: FND_MSG_PUB.Count_And_Get
6513: ( p_count => x_msg_count,
6514: p_data => x_msg_data,
6515: p_encoded => FND_API.G_FALSE