9381: p_level => C_LEVEL_PROCEDURE);
9382: END IF;
9383:
9384: EXCEPTION
9385: WHEN FND_API.G_EXC_ERROR THEN
9386: RAISE;
9387: x_return_status := FND_API.G_RET_STS_ERROR ;
9388: x_analysis_status := 'ERROR';
9389:
9383:
9384: EXCEPTION
9385: WHEN FND_API.G_EXC_ERROR THEN
9386: RAISE;
9387: x_return_status := FND_API.G_RET_STS_ERROR ;
9388: x_analysis_status := 'ERROR';
9389:
9390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9391: ROLLBACK;
9386: RAISE;
9387: x_return_status := FND_API.G_RET_STS_ERROR ;
9388: x_analysis_status := 'ERROR';
9389:
9390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9391: ROLLBACK;
9392: RAISE;
9393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9394: x_analysis_status := 'ERROR';
9389:
9390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9391: ROLLBACK;
9392: RAISE;
9393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9394: x_analysis_status := 'ERROR';
9395:
9396: WHEN OTHERS THEN
9397: ROLLBACK;
9395:
9396: WHEN OTHERS THEN
9397: ROLLBACK;
9398: RAISE;
9399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9400: x_analysis_status := 'ERROR';
9401:
9402: xla_aad_loader_util_pvt.stack_error
9403: (p_appli_s_name => 'XLA'
9449: ,p_caller_version_number => p_api_version
9450: ,p_api_name => l_api_name
9451: ,p_pkg_name => C_DEFAULT_MODULE))
9452: THEN
9453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
9454: END IF;
9455:
9456: -- Initialize global variables
9457: x_return_status := FND_API.G_RET_STS_SUCCESS;
9453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
9454: END IF;
9455:
9456: -- Initialize global variables
9457: x_return_status := FND_API.G_RET_STS_SUCCESS;
9458:
9459: g_application_id := p_application_id;
9460: g_amb_context_code := p_amb_context_code;
9461: g_staging_context_code := p_staging_context_code;
9467:
9468: -- API Logic
9469: x_analysis_status := pre_analysis;
9470: IF (x_analysis_status = 'ERROR') THEN
9471: RAISE FND_API.G_EXC_ERROR;
9472: END IF;
9473:
9474: x_analysis_status := validation;
9475: IF (x_analysis_status = 'ERROR') THEN
9472: END IF;
9473:
9474: x_analysis_status := validation;
9475: IF (x_analysis_status = 'ERROR') THEN
9476: RAISE FND_API.G_EXC_ERROR;
9477: END IF;
9478:
9479: analyze_aads;
9480: post_analysis;
9485: p_level => C_LEVEL_PROCEDURE);
9486: END IF;
9487:
9488: EXCEPTION
9489: WHEN FND_API.G_EXC_ERROR THEN
9490: RAISE;
9491: x_return_status := FND_API.G_RET_STS_ERROR ;
9492: x_analysis_status := 'ERROR';
9493:
9487:
9488: EXCEPTION
9489: WHEN FND_API.G_EXC_ERROR THEN
9490: RAISE;
9491: x_return_status := FND_API.G_RET_STS_ERROR ;
9492: x_analysis_status := 'ERROR';
9493:
9494: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9495: ROLLBACK;
9490: RAISE;
9491: x_return_status := FND_API.G_RET_STS_ERROR ;
9492: x_analysis_status := 'ERROR';
9493:
9494: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9495: ROLLBACK;
9496: RAISE;
9497: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9498: x_analysis_status := 'ERROR';
9493:
9494: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9495: ROLLBACK;
9496: RAISE;
9497: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9498: x_analysis_status := 'ERROR';
9499:
9500: WHEN OTHERS THEN
9501: ROLLBACK;
9499:
9500: WHEN OTHERS THEN
9501: ROLLBACK;
9502: RAISE;
9503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
9504: x_analysis_status := 'ERROR';
9505:
9506: xla_aad_loader_util_pvt.stack_error
9507: (p_appli_s_name => 'XLA'