6932: END IF;
6933:
6934: EXCEPTION
6935: WHEN G_EXC_WARNING THEN
6936: x_return_status := FND_API.G_RET_STS_SUCCESS ;
6937: x_merge_status := 'ERROR';
6938:
6939: WHEN FND_API.G_EXC_ERROR THEN
6940: x_return_status := FND_API.G_RET_STS_ERROR ;
6935: WHEN G_EXC_WARNING THEN
6936: x_return_status := FND_API.G_RET_STS_SUCCESS ;
6937: x_merge_status := 'ERROR';
6938:
6939: WHEN FND_API.G_EXC_ERROR THEN
6940: x_return_status := FND_API.G_RET_STS_ERROR ;
6941: x_merge_status := 'ERROR';
6942:
6943: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6936: x_return_status := FND_API.G_RET_STS_SUCCESS ;
6937: x_merge_status := 'ERROR';
6938:
6939: WHEN FND_API.G_EXC_ERROR THEN
6940: x_return_status := FND_API.G_RET_STS_ERROR ;
6941: x_merge_status := 'ERROR';
6942:
6943: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6944: ROLLBACK;
6939: WHEN FND_API.G_EXC_ERROR THEN
6940: x_return_status := FND_API.G_RET_STS_ERROR ;
6941: x_merge_status := 'ERROR';
6942:
6943: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6944: ROLLBACK;
6945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6946: x_merge_status := 'ERROR';
6947:
6941: x_merge_status := 'ERROR';
6942:
6943: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6944: ROLLBACK;
6945: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6946: x_merge_status := 'ERROR';
6947:
6948: WHEN OTHERS THEN
6949: ROLLBACK;
6946: x_merge_status := 'ERROR';
6947:
6948: WHEN OTHERS THEN
6949: ROLLBACK;
6950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6951: x_merge_status := 'ERROR';
6952:
6953: xla_aad_loader_util_pvt.stack_error
6954: (p_appli_s_name => 'XLA'
7007: ,p_caller_version_number => p_api_version
7008: ,p_api_name => l_api_name
7009: ,p_pkg_name => C_DEFAULT_MODULE))
7010: THEN
7011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
7012: END IF;
7013:
7014: -- Initialize global variables
7015: x_return_status := FND_API.G_RET_STS_SUCCESS;
7011: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
7012: END IF;
7013:
7014: -- Initialize global variables
7015: x_return_status := FND_API.G_RET_STS_SUCCESS;
7016:
7017: g_usr_id := xla_environment_pkg.g_usr_id;
7018: g_login_id := xla_environment_pkg.g_login_id;
7019: g_application_id := p_application_id;
7062: p_level => C_LEVEL_PROCEDURE);
7063: END IF;
7064: EXCEPTION
7065: WHEN G_EXC_WARNING THEN
7066: x_return_status := FND_API.G_RET_STS_SUCCESS ;
7067: x_merge_status := 'ERROR';
7068:
7069: WHEN FND_API.G_EXC_ERROR THEN
7070: x_return_status := FND_API.G_RET_STS_ERROR ;
7065: WHEN G_EXC_WARNING THEN
7066: x_return_status := FND_API.G_RET_STS_SUCCESS ;
7067: x_merge_status := 'ERROR';
7068:
7069: WHEN FND_API.G_EXC_ERROR THEN
7070: x_return_status := FND_API.G_RET_STS_ERROR ;
7071: x_merge_status := 'ERROR';
7072:
7073: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7066: x_return_status := FND_API.G_RET_STS_SUCCESS ;
7067: x_merge_status := 'ERROR';
7068:
7069: WHEN FND_API.G_EXC_ERROR THEN
7070: x_return_status := FND_API.G_RET_STS_ERROR ;
7071: x_merge_status := 'ERROR';
7072:
7073: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7074: ROLLBACK;
7069: WHEN FND_API.G_EXC_ERROR THEN
7070: x_return_status := FND_API.G_RET_STS_ERROR ;
7071: x_merge_status := 'ERROR';
7072:
7073: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7074: ROLLBACK;
7075: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7076: x_merge_status := 'ERROR';
7077:
7071: x_merge_status := 'ERROR';
7072:
7073: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7074: ROLLBACK;
7075: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7076: x_merge_status := 'ERROR';
7077:
7078: WHEN OTHERS THEN
7079: ROLLBACK;
7076: x_merge_status := 'ERROR';
7077:
7078: WHEN OTHERS THEN
7079: ROLLBACK;
7080: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
7081: x_merge_status := 'ERROR';
7082:
7083: xla_aad_loader_util_pvt.stack_error
7084: (p_appli_s_name => 'XLA'