APPS.BSC_UPDATE_UTIL dependencies on FND_API

Line 4642: x_return_status := FND_API.G_RET_STS_SUCCESS;

4638:
4639: BEGIN
4640: SAVEPOINT BscUpdateUtilPopCalTables;
4641: FND_MSG_PUB.Initialize;
4642: x_return_status := FND_API.G_RET_STS_SUCCESS;
4643:
4644: -- Init BSC/APPS global variables
4645: BSC_APPS.Init_Bsc_Apps;
4646:

Line 4652: IF (p_commit = FND_API.G_TRUE) THEN

4648: IF NOT BSC_UPDATE_UTIL.Init_Calendar_Tables(p_calendar_id) THEN
4649: RAISE e_error;
4650: END IF;
4651:
4652: IF (p_commit = FND_API.G_TRUE) THEN
4653: COMMIT;
4654: END IF;
4655:
4656: EXCEPTION

Line 4664: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4660: G_PKG_NAME,
4661: l_api_name,
4662: BSC_UPDATE_UTIL.Get_Message('BSC_CALTABLES_POP_FAILED')
4663: );
4664: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4665: FND_MSG_PUB.Count_And_Get(
4666: p_encoded => 'F'
4667: ,p_count => x_msg_count
4668: ,p_data => x_msg_data

Line 4670: WHEN FND_API.G_EXC_ERROR THEN

4666: p_encoded => 'F'
4667: ,p_count => x_msg_count
4668: ,p_data => x_msg_data
4669: );
4670: WHEN FND_API.G_EXC_ERROR THEN
4671: ROLLBACK TO BscUpdateUtilPopCalTables;
4672: x_return_status := FND_API.G_RET_STS_ERROR;
4673: FND_MSG_PUB.Count_And_Get(
4674: p_encoded => 'F'

Line 4672: x_return_status := FND_API.G_RET_STS_ERROR;

4668: ,p_data => x_msg_data
4669: );
4670: WHEN FND_API.G_EXC_ERROR THEN
4671: ROLLBACK TO BscUpdateUtilPopCalTables;
4672: x_return_status := FND_API.G_RET_STS_ERROR;
4673: FND_MSG_PUB.Count_And_Get(
4674: p_encoded => 'F'
4675: ,p_count => x_msg_count
4676: ,p_data => x_msg_data

Line 4678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4674: p_encoded => 'F'
4675: ,p_count => x_msg_count
4676: ,p_data => x_msg_data
4677: );
4678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4679: ROLLBACK TO BscUpdateUtilPopCalTables;
4680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4681: FND_MSG_PUB.Count_And_Get(
4682: p_encoded => 'F'

Line 4680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4676: ,p_data => x_msg_data
4677: );
4678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4679: ROLLBACK TO BscUpdateUtilPopCalTables;
4680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4681: FND_MSG_PUB.Count_And_Get(
4682: p_encoded => 'F'
4683: ,p_count => x_msg_count
4684: ,p_data => x_msg_data

Line 4693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4689: G_PKG_NAME,
4690: l_api_name,
4691: SQLERRM
4692: );
4693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4694: FND_MSG_PUB.Count_And_Get(
4695: p_encoded => 'F'
4696: ,p_count => x_msg_count
4697: ,p_data => x_msg_data