1941: p_level => C_LEVEL_PROCEDURE);
1942: END IF;
1943: EXCEPTION
1944: WHEN G_EXC_WARNING THEN
1945: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1946: x_overwrite_status := 'WARNING';
1947:
1948: WHEN FND_API.G_EXC_ERROR THEN
1949: x_return_status := FND_API.G_RET_STS_ERROR ;
1944: WHEN G_EXC_WARNING THEN
1945: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1946: x_overwrite_status := 'WARNING';
1947:
1948: WHEN FND_API.G_EXC_ERROR THEN
1949: x_return_status := FND_API.G_RET_STS_ERROR ;
1950: x_overwrite_status := 'ERROR';
1951:
1952: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1945: x_return_status := FND_API.G_RET_STS_SUCCESS ;
1946: x_overwrite_status := 'WARNING';
1947:
1948: WHEN FND_API.G_EXC_ERROR THEN
1949: x_return_status := FND_API.G_RET_STS_ERROR ;
1950: x_overwrite_status := 'ERROR';
1951:
1952: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1953: ROLLBACK;
1948: WHEN FND_API.G_EXC_ERROR THEN
1949: x_return_status := FND_API.G_RET_STS_ERROR ;
1950: x_overwrite_status := 'ERROR';
1951:
1952: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1953: ROLLBACK;
1954: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1955: x_overwrite_status := 'ERROR';
1956:
1950: x_overwrite_status := 'ERROR';
1951:
1952: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1953: ROLLBACK;
1954: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1955: x_overwrite_status := 'ERROR';
1956:
1957: WHEN OTHERS THEN
1958: ROLLBACK;
1955: x_overwrite_status := 'ERROR';
1956:
1957: WHEN OTHERS THEN
1958: ROLLBACK;
1959: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1960: x_overwrite_status := 'ERROR';
1961:
1962: xla_aad_loader_util_pvt.stack_error
1963: (p_appli_s_name => 'XLA'
2011: ,p_caller_version_number => p_api_version
2012: ,p_api_name => l_api_name
2013: ,p_pkg_name => C_DEFAULT_MODULE))
2014: THEN
2015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2016: END IF;
2017:
2018: -- Initialize global variables
2019: x_return_status := FND_API.G_RET_STS_SUCCESS;
2015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2016: END IF;
2017:
2018: -- Initialize global variables
2019: x_return_status := FND_API.G_RET_STS_SUCCESS;
2020:
2021: g_application_id := p_application_id;
2022: g_amb_context_code := p_amb_context_code;
2023: g_force_flag := p_force_flag;
2028: x_overwrite_status := pre_overwrite;
2029: IF (x_overwrite_status = 'WARNING') THEN
2030: RAISE G_EXC_WARNING;
2031: ELSIF (x_overwrite_status = 'ERROR') THEN
2032: RAISE FND_API.G_EXC_ERROR;
2033: END IF;
2034:
2035: x_overwrite_status := validation;
2036: IF (x_overwrite_status = 'WARNING') THEN
2035: x_overwrite_status := validation;
2036: IF (x_overwrite_status = 'WARNING') THEN
2037: RAISE G_EXC_WARNING;
2038: ELSIF (x_overwrite_status = 'ERROR') THEN
2039: RAISE FND_API.G_EXC_ERROR;
2040: END IF;
2041:
2042: record_log;
2043:
2080: p_level => C_LEVEL_PROCEDURE);
2081: END IF;
2082: EXCEPTION
2083: WHEN G_EXC_WARNING THEN
2084: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2085: x_overwrite_status := 'WARNING';
2086:
2087: WHEN FND_API.G_EXC_ERROR THEN
2088: x_return_status := FND_API.G_RET_STS_ERROR ;
2083: WHEN G_EXC_WARNING THEN
2084: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2085: x_overwrite_status := 'WARNING';
2086:
2087: WHEN FND_API.G_EXC_ERROR THEN
2088: x_return_status := FND_API.G_RET_STS_ERROR ;
2089: x_overwrite_status := 'ERROR';
2090:
2091: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2084: x_return_status := FND_API.G_RET_STS_SUCCESS ;
2085: x_overwrite_status := 'WARNING';
2086:
2087: WHEN FND_API.G_EXC_ERROR THEN
2088: x_return_status := FND_API.G_RET_STS_ERROR ;
2089: x_overwrite_status := 'ERROR';
2090:
2091: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2092: ROLLBACK;
2087: WHEN FND_API.G_EXC_ERROR THEN
2088: x_return_status := FND_API.G_RET_STS_ERROR ;
2089: x_overwrite_status := 'ERROR';
2090:
2091: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2092: ROLLBACK;
2093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2094: x_overwrite_status := 'ERROR';
2095:
2089: x_overwrite_status := 'ERROR';
2090:
2091: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2092: ROLLBACK;
2093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2094: x_overwrite_status := 'ERROR';
2095:
2096: WHEN OTHERS THEN
2097: ROLLBACK;
2094: x_overwrite_status := 'ERROR';
2095:
2096: WHEN OTHERS THEN
2097: ROLLBACK;
2098: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2099: x_overwrite_status := 'ERROR';
2100:
2101: xla_aad_loader_util_pvt.stack_error
2102: (p_appli_s_name => 'XLA'