DBA Data[Home] [Help]

APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on FND_API

Line 2210: IF (NOT fnd_api.compatible_api_call

2206: p_level => C_LEVEL_PROCEDURE);
2207: END IF;
2208:
2209: l_retcode := TRUE;
2210: IF (NOT fnd_api.compatible_api_call
2211: (p_current_version_number => p_current_version_number
2212: ,p_caller_version_number => p_caller_version_number
2213: ,p_api_name => p_api_name
2214: ,p_pkg_name => p_pkg_name)) THEN

Line 2216: l_error_text := fnd_msg_pub.get(fnd_msg_pub.G_FIRST, FND_API.G_FALSE);

2212: ,p_caller_version_number => p_caller_version_number
2213: ,p_api_name => p_api_name
2214: ,p_pkg_name => p_pkg_name)) THEN
2215:
2216: l_error_text := fnd_msg_pub.get(fnd_msg_pub.G_FIRST, FND_API.G_FALSE);
2217:
2218: xla_aad_loader_util_pvt.stack_error
2219: (p_appli_s_name => 'XLA'
2220: ,p_msg_name => 'XLA_COMMON_ERROR'

Line 2287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2283: ,p_caller_version_number => p_api_version
2284: ,p_api_name => l_api_name
2285: ,p_pkg_name => C_DEFAULT_MODULE))
2286: THEN
2287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2288: END IF;
2289:
2290: -- Initialize global variables
2291: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2291: x_return_status := FND_API.G_RET_STS_SUCCESS;

2287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2288: END IF;
2289:
2290: -- Initialize global variables
2291: x_return_status := FND_API.G_RET_STS_SUCCESS;
2292:
2293: SELECT application_short_name
2294: INTO l_short_name
2295: FROM fnd_application

Line 2349: x_return_status := FND_API.G_RET_STS_ERROR ;

2345: END IF;
2346: EXCEPTION
2347: WHEN NO_DATA_FOUND THEN
2348: ROLLBACK;
2349: x_return_status := FND_API.G_RET_STS_ERROR ;
2350:
2351: WHEN FND_API.G_EXC_ERROR THEN
2352: ROLLBACK;
2353: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 2351: WHEN FND_API.G_EXC_ERROR THEN

2347: WHEN NO_DATA_FOUND THEN
2348: ROLLBACK;
2349: x_return_status := FND_API.G_RET_STS_ERROR ;
2350:
2351: WHEN FND_API.G_EXC_ERROR THEN
2352: ROLLBACK;
2353: x_return_status := FND_API.G_RET_STS_ERROR ;
2354:
2355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2353: x_return_status := FND_API.G_RET_STS_ERROR ;

2349: x_return_status := FND_API.G_RET_STS_ERROR ;
2350:
2351: WHEN FND_API.G_EXC_ERROR THEN
2352: ROLLBACK;
2353: x_return_status := FND_API.G_RET_STS_ERROR ;
2354:
2355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2356: ROLLBACK;
2357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2351: WHEN FND_API.G_EXC_ERROR THEN
2352: ROLLBACK;
2353: x_return_status := FND_API.G_RET_STS_ERROR ;
2354:
2355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2356: ROLLBACK;
2357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2358:
2359: WHEN OTHERS THEN

Line 2357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2353: x_return_status := FND_API.G_RET_STS_ERROR ;
2354:
2355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2356: ROLLBACK;
2357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2358:
2359: WHEN OTHERS THEN
2360: ROLLBACK;
2361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2358:
2359: WHEN OTHERS THEN
2360: ROLLBACK;
2361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2362:
2363: END purge_subledger_seed;
2364:
2365:

Line 2409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2405: ,p_caller_version_number => p_api_version
2406: ,p_api_name => l_api_name
2407: ,p_pkg_name => C_DEFAULT_MODULE))
2408: THEN
2409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2410: END IF;
2411:
2412: -- Initialize global variables
2413: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2413: x_return_status := FND_API.G_RET_STS_SUCCESS;

2409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2410: END IF;
2411:
2412: -- Initialize global variables
2413: x_return_status := FND_API.G_RET_STS_SUCCESS;
2414:
2415: -- API logic
2416: OPEN c_staging_context_code;
2417: FETCH c_staging_context_code INTO l_staging_context_code;

Line 2876: WHEN FND_API.G_EXC_ERROR THEN

2872: p_module => l_log_module,
2873: p_level => C_LEVEL_PROCEDURE);
2874: END IF;
2875: EXCEPTION
2876: WHEN FND_API.G_EXC_ERROR THEN
2877: ROLLBACK;
2878: x_return_status := FND_API.G_RET_STS_ERROR ;
2879:
2880: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2878: x_return_status := FND_API.G_RET_STS_ERROR ;

2874: END IF;
2875: EXCEPTION
2876: WHEN FND_API.G_EXC_ERROR THEN
2877: ROLLBACK;
2878: x_return_status := FND_API.G_RET_STS_ERROR ;
2879:
2880: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2881: ROLLBACK;
2882: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2880: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2876: WHEN FND_API.G_EXC_ERROR THEN
2877: ROLLBACK;
2878: x_return_status := FND_API.G_RET_STS_ERROR ;
2879:
2880: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2881: ROLLBACK;
2882: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2883:
2884: WHEN OTHERS THEN

Line 2882: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2878: x_return_status := FND_API.G_RET_STS_ERROR ;
2879:
2880: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2881: ROLLBACK;
2882: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2883:
2884: WHEN OTHERS THEN
2885: ROLLBACK;
2886: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2886: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2882: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2883:
2884: WHEN OTHERS THEN
2885: ROLLBACK;
2886: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2887:
2888: xla_aad_loader_util_pvt.stack_error
2889: (p_appli_s_name => 'XLA'
2890: ,p_msg_name => 'XLA_COMMON_ERROR'

Line 3129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3125: ,p_caller_version_number => p_api_version
3126: ,p_api_name => l_api_name
3127: ,p_pkg_name => C_DEFAULT_MODULE))
3128: THEN
3129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3130: END IF;
3131:
3132: -- Initialize global variables
3133: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3133: x_return_status := FND_API.G_RET_STS_SUCCESS;

3129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3130: END IF;
3131:
3132: -- Initialize global variables
3133: x_return_status := FND_API.G_RET_STS_SUCCESS;
3134:
3135: DELETE FROM xla_aads_h
3136: WHERE application_id = p_application_id;
3137:

Line 3163: WHEN FND_API.G_EXC_ERROR THEN

3159: p_level => C_LEVEL_PROCEDURE);
3160: END IF;
3161: EXCEPTION
3162:
3163: WHEN FND_API.G_EXC_ERROR THEN
3164: ROLLBACK;
3165: x_return_status := FND_API.G_RET_STS_ERROR ;
3166:
3167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3165: x_return_status := FND_API.G_RET_STS_ERROR ;

3161: EXCEPTION
3162:
3163: WHEN FND_API.G_EXC_ERROR THEN
3164: ROLLBACK;
3165: x_return_status := FND_API.G_RET_STS_ERROR ;
3166:
3167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3168: ROLLBACK;
3169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 3167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3163: WHEN FND_API.G_EXC_ERROR THEN
3164: ROLLBACK;
3165: x_return_status := FND_API.G_RET_STS_ERROR ;
3166:
3167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3168: ROLLBACK;
3169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3170:
3171: WHEN OTHERS THEN

Line 3169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3165: x_return_status := FND_API.G_RET_STS_ERROR ;
3166:
3167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3168: ROLLBACK;
3169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3170:
3171: WHEN OTHERS THEN
3172: ROLLBACK;
3173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 3173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3170:
3171: WHEN OTHERS THEN
3172: ROLLBACK;
3173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3174:
3175: END purge_history;
3176:
3177: