DBA Data[Home] [Help]

APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on FND_API

Line 2769: IF (NOT fnd_api.compatible_api_call

2765: p_level => C_LEVEL_PROCEDURE);
2766: END IF;
2767:
2768: l_retcode := TRUE;
2769: IF (NOT fnd_api.compatible_api_call
2770: (p_current_version_number => p_current_version_number
2771: ,p_caller_version_number => p_caller_version_number
2772: ,p_api_name => p_api_name
2773: ,p_pkg_name => p_pkg_name)) THEN

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

2771: ,p_caller_version_number => p_caller_version_number
2772: ,p_api_name => p_api_name
2773: ,p_pkg_name => p_pkg_name)) THEN
2774:
2775: l_error_text := fnd_msg_pub.get(fnd_msg_pub.G_FIRST, FND_API.G_FALSE);
2776:
2777: xla_aad_loader_util_pvt.stack_error
2778: (p_appli_s_name => 'XLA'
2779: ,p_msg_name => 'XLA_COMMON_ERROR'

Line 2846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2842: ,p_caller_version_number => p_api_version
2843: ,p_api_name => l_api_name
2844: ,p_pkg_name => C_DEFAULT_MODULE))
2845: THEN
2846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2847: END IF;
2848:
2849: -- Initialize global variables
2850: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2850: x_return_status := FND_API.G_RET_STS_SUCCESS;

2846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2847: END IF;
2848:
2849: -- Initialize global variables
2850: x_return_status := FND_API.G_RET_STS_SUCCESS;
2851:
2852: SELECT application_short_name
2853: INTO l_short_name
2854: FROM fnd_application

Line 2908: x_return_status := FND_API.G_RET_STS_ERROR ;

2904: END IF;
2905: EXCEPTION
2906: WHEN NO_DATA_FOUND THEN
2907: ROLLBACK;
2908: x_return_status := FND_API.G_RET_STS_ERROR ;
2909:
2910: WHEN FND_API.G_EXC_ERROR THEN
2911: ROLLBACK;
2912: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 2910: WHEN FND_API.G_EXC_ERROR THEN

2906: WHEN NO_DATA_FOUND THEN
2907: ROLLBACK;
2908: x_return_status := FND_API.G_RET_STS_ERROR ;
2909:
2910: WHEN FND_API.G_EXC_ERROR THEN
2911: ROLLBACK;
2912: x_return_status := FND_API.G_RET_STS_ERROR ;
2913:
2914: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2912: x_return_status := FND_API.G_RET_STS_ERROR ;

2908: x_return_status := FND_API.G_RET_STS_ERROR ;
2909:
2910: WHEN FND_API.G_EXC_ERROR THEN
2911: ROLLBACK;
2912: x_return_status := FND_API.G_RET_STS_ERROR ;
2913:
2914: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2915: ROLLBACK;
2916: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2914: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2910: WHEN FND_API.G_EXC_ERROR THEN
2911: ROLLBACK;
2912: x_return_status := FND_API.G_RET_STS_ERROR ;
2913:
2914: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2915: ROLLBACK;
2916: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2917:
2918: WHEN OTHERS THEN

Line 2916: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2912: x_return_status := FND_API.G_RET_STS_ERROR ;
2913:
2914: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2915: ROLLBACK;
2916: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2917:
2918: WHEN OTHERS THEN
2919: ROLLBACK;
2920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2916: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2917:
2918: WHEN OTHERS THEN
2919: ROLLBACK;
2920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2921:
2922: END purge_subledger_seed;
2923:
2924:

Line 2968: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2964: ,p_caller_version_number => p_api_version
2965: ,p_api_name => l_api_name
2966: ,p_pkg_name => C_DEFAULT_MODULE))
2967: THEN
2968: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2969: END IF;
2970:
2971: -- Initialize global variables
2972: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2972: x_return_status := FND_API.G_RET_STS_SUCCESS;

2968: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2969: END IF;
2970:
2971: -- Initialize global variables
2972: x_return_status := FND_API.G_RET_STS_SUCCESS;
2973:
2974: -- API logic
2975: OPEN c_staging_context_code;
2976: FETCH c_staging_context_code INTO l_staging_context_code;

Line 3860: WHEN FND_API.G_EXC_ERROR THEN

3856: p_module => l_log_module,
3857: p_level => C_LEVEL_PROCEDURE);
3858: END IF;
3859: EXCEPTION
3860: WHEN FND_API.G_EXC_ERROR THEN
3861: ROLLBACK;
3862: x_return_status := FND_API.G_RET_STS_ERROR ;
3863:
3864: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3862: x_return_status := FND_API.G_RET_STS_ERROR ;

3858: END IF;
3859: EXCEPTION
3860: WHEN FND_API.G_EXC_ERROR THEN
3861: ROLLBACK;
3862: x_return_status := FND_API.G_RET_STS_ERROR ;
3863:
3864: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3865: ROLLBACK;
3866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 3864: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3860: WHEN FND_API.G_EXC_ERROR THEN
3861: ROLLBACK;
3862: x_return_status := FND_API.G_RET_STS_ERROR ;
3863:
3864: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3865: ROLLBACK;
3866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3867:
3868: WHEN OTHERS THEN

Line 3866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3862: x_return_status := FND_API.G_RET_STS_ERROR ;
3863:
3864: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3865: ROLLBACK;
3866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3867:
3868: WHEN OTHERS THEN
3869: ROLLBACK;
3870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 3870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3867:
3868: WHEN OTHERS THEN
3869: ROLLBACK;
3870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3871:
3872: xla_aad_loader_util_pvt.stack_error
3873: (p_appli_s_name => 'XLA'
3874: ,p_msg_name => 'XLA_COMMON_ERROR'

Line 4113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

4109: ,p_caller_version_number => p_api_version
4110: ,p_api_name => l_api_name
4111: ,p_pkg_name => C_DEFAULT_MODULE))
4112: THEN
4113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4114: END IF;
4115:
4116: -- Initialize global variables
4117: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4117: x_return_status := FND_API.G_RET_STS_SUCCESS;

4113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4114: END IF;
4115:
4116: -- Initialize global variables
4117: x_return_status := FND_API.G_RET_STS_SUCCESS;
4118:
4119: DELETE FROM xla_aads_h
4120: WHERE application_id = p_application_id;
4121:

Line 4147: WHEN FND_API.G_EXC_ERROR THEN

4143: p_level => C_LEVEL_PROCEDURE);
4144: END IF;
4145: EXCEPTION
4146:
4147: WHEN FND_API.G_EXC_ERROR THEN
4148: ROLLBACK;
4149: x_return_status := FND_API.G_RET_STS_ERROR ;
4150:
4151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4149: x_return_status := FND_API.G_RET_STS_ERROR ;

4145: EXCEPTION
4146:
4147: WHEN FND_API.G_EXC_ERROR THEN
4148: ROLLBACK;
4149: x_return_status := FND_API.G_RET_STS_ERROR ;
4150:
4151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4152: ROLLBACK;
4153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 4151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4147: WHEN FND_API.G_EXC_ERROR THEN
4148: ROLLBACK;
4149: x_return_status := FND_API.G_RET_STS_ERROR ;
4150:
4151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4152: ROLLBACK;
4153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4154:
4155: WHEN OTHERS THEN

Line 4153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4149: x_return_status := FND_API.G_RET_STS_ERROR ;
4150:
4151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4152: ROLLBACK;
4153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4154:
4155: WHEN OTHERS THEN
4156: ROLLBACK;
4157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 4157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4154:
4155: WHEN OTHERS THEN
4156: ROLLBACK;
4157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4158:
4159: END purge_history;
4160:
4161: --=============================================================================