3517: l_query_string long;
3518:
3519: BEGIN
3520:
3521: -- Standard Start of API Savepoint
3522: savepoint Generate_Dim_Hier_Query_PVT;
3523:
3524: -- Standard call to check for call compatibility
3525: if not FND_API.Compatible_API_Call (
3520:
3521: -- Standard Start of API Savepoint
3522: savepoint Generate_Dim_Hier_Query_PVT;
3523:
3524: -- Standard call to check for call compatibility
3525: if not FND_API.Compatible_API_Call (
3526: p_current_version_number => l_api_version
3527: ,p_caller_version_number => p_api_version
3528: ,p_api_name => l_api_name
3765:
3766: -----------------------
3767: -- Finalize API Call --
3768: -----------------------
3769: -- Standard check of p_commit
3770: if FND_API.To_Boolean(p_commit) then
3771: commit work;
3772: end if;
3773:
3770: if FND_API.To_Boolean(p_commit) then
3771: commit work;
3772: end if;
3773:
3774: -- Standard call to get message count and if count is 1, get message info
3775: FND_MSG_PUB.Count_And_Get (
3776: p_count => x_msg_count
3777: ,p_data => x_msg_data
3778: );