DBA Data[Home] [Help]

APPS.XLA_AAD_UPLOAD_PVT dependencies on FND_API

Line 172: RAISE FND_API.G_EXC_ERROR;

168: ,p_source_pathname => p_source_pathname
169: ,p_staging_context_code => p_staging_context_code);
170:
171: IF (l_req_id = 0) THEN
172: RAISE FND_API.G_EXC_ERROR;
173: END IF;
174:
175: l_retcode := xla_aad_loader_util_pvt.wait_for_request(p_req_id => l_req_id);
176: IF (l_retcode = 'ERROR') THEN

Line 177: RAISE FND_API.G_EXC_ERROR;

173: END IF;
174:
175: l_retcode := xla_aad_loader_util_pvt.wait_for_request(p_req_id => l_req_id);
176: IF (l_retcode = 'ERROR') THEN
177: RAISE FND_API.G_EXC_ERROR;
178: END IF;
179:
180: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
181: trace(p_msg => 'END of function upload_data : Return Code = '||l_retcode,

Line 188: WHEN FND_API.G_EXC_ERROR THEN

184: END IF;
185:
186: RETURN 'SUCCESS';
187: EXCEPTION
188: WHEN FND_API.G_EXC_ERROR THEN
189: xla_aad_loader_util_pvt.stack_error
190: (p_appli_s_name => 'XLA'
191: ,p_msg_name => 'XLA_AAD_UPL_FNDLOAD_FAIL'
192: ,p_token_1 => 'CONC_REQUEST_ID'

Line 1401: RAISE FND_API.G_EXC_ERROR;

1397:
1398: END IF;
1399:
1400: IF (l_error_found) THEN
1401: RAISE FND_API.G_EXC_ERROR;
1402: END IF;
1403:
1404: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
1405: trace(p_msg => 'END of procedure populate_mapping_sets',

Line 1412: WHEN FND_API.G_EXC_ERROR THEN

1408: END IF;
1409:
1410: RETURN 'SUCCESS';
1411: EXCEPTION
1412: WHEN FND_API.G_EXC_ERROR THEN
1413: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
1414: trace(p_msg => 'END of procedure populate_adrs: ERROR',
1415: p_module => l_log_module,
1416: p_level => C_LEVEL_PROCEDURE);

Line 2117: RAISE FND_API.G_EXC_ERROR;

2113: p_level => C_LEVEL_EVENT);
2114: END IF;
2115:
2116: IF (l_error_found) THEN
2117: RAISE FND_API.G_EXC_ERROR;
2118: END IF;
2119:
2120: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2121: trace(p_msg => 'END of procedure populate_adrs',

Line 2128: WHEN FND_API.G_EXC_ERROR THEN

2124: END IF;
2125:
2126: RETURN 'SUCCESS';
2127: EXCEPTION
2128: WHEN FND_API.G_EXC_ERROR THEN
2129: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2130: trace(p_msg => 'END of procedure populate_adrs: ERROR',
2131: p_module => l_log_module,
2132: p_level => C_LEVEL_PROCEDURE);

Line 3513: RAISE FND_API.G_EXC_ERROR;

3509:
3510: populate_history(p_staging_context_code => p_staging_context_code);
3511:
3512: IF (l_error_found) THEN
3513: RAISE FND_API.G_EXC_ERROR;
3514: END IF;
3515:
3516: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3517: trace(p_msg => 'END of procedure populate_data',

Line 3524: WHEN FND_API.G_EXC_ERROR THEN

3520: END IF;
3521:
3522: RETURN 'SUCCESS';
3523: EXCEPTION
3524: WHEN FND_API.G_EXC_ERROR THEN
3525: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3526: trace(p_msg => 'END of procedure populate_data: ERROR',
3527: p_module => l_log_module,
3528: p_level => C_LEVEL_PROCEDURE);

Line 3579: RAISE FND_API.G_EXC_ERROR;

3575: (p_application_id => p_application_id
3576: ,p_staging_context_code => p_staging_context_code);
3577:
3578: IF (l_upload_status IN ('WARNING','ERROR')) THEN
3579: RAISE FND_API.G_EXC_ERROR;
3580: END IF;
3581:
3582: l_upload_status := populate_data
3583: (p_application_id => p_application_id

Line 3588: RAISE FND_API.G_EXC_ERROR;

3584: ,p_amb_context_code => p_amb_context_code
3585: ,p_staging_context_code => p_staging_context_code);
3586:
3587: IF (l_upload_status IN ('WARNING','ERROR')) THEN
3588: RAISE FND_API.G_EXC_ERROR;
3589: END IF;
3590:
3591: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3592: trace(p_msg => 'END of function post_upload',

Line 3599: WHEN FND_API.G_EXC_ERROR THEN

3595: END IF;
3596:
3597: RETURN 'SUCCESS';
3598: EXCEPTION
3599: WHEN FND_API.G_EXC_ERROR THEN
3600: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
3601: trace(p_msg => 'END of function post_upload: ERROR',
3602: p_module => l_log_module,
3603: p_level => C_LEVEL_PROCEDURE);

Line 3672: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3668: ,p_caller_version_number => p_api_version
3669: ,p_api_name => l_api_name
3670: ,p_pkg_name => C_DEFAULT_MODULE))
3671: THEN
3672: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3673: END IF;
3674:
3675: -- Initialize variables
3676: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3676: x_return_status := FND_API.G_RET_STS_SUCCESS;

3672: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3673: END IF;
3674:
3675: -- Initialize variables
3676: x_return_status := FND_API.G_RET_STS_SUCCESS;
3677:
3678: -- API Logic
3679: l_staging_context_code := xla_aad_loader_util_pvt.get_staging_context_code
3680: (p_application_id => p_application_id

Line 3689: RAISE FND_API.G_EXC_ERROR;

3685: ,p_source_pathname => p_source_pathname
3686: ,p_staging_context_code => l_staging_context_code);
3687:
3688: IF (x_upload_status IN ('ERROR','WARNING')) THEN
3689: RAISE FND_API.G_EXC_ERROR;
3690: END IF;
3691:
3692: x_upload_status := post_upload
3693: (p_application_id => p_application_id

Line 3703: WHEN FND_API.G_EXC_ERROR THEN

3699: p_module => l_log_module,
3700: p_level => C_LEVEL_PROCEDURE);
3701: END IF;
3702: EXCEPTION
3703: WHEN FND_API.G_EXC_ERROR THEN
3704: ROLLBACK;
3705: x_return_status := FND_API.G_RET_STS_ERROR ;
3706:
3707: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3705: x_return_status := FND_API.G_RET_STS_ERROR ;

3701: END IF;
3702: EXCEPTION
3703: WHEN FND_API.G_EXC_ERROR THEN
3704: ROLLBACK;
3705: x_return_status := FND_API.G_RET_STS_ERROR ;
3706:
3707: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3708: ROLLBACK;
3709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 3707: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3703: WHEN FND_API.G_EXC_ERROR THEN
3704: ROLLBACK;
3705: x_return_status := FND_API.G_RET_STS_ERROR ;
3706:
3707: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3708: ROLLBACK;
3709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3710: x_upload_status := 'ERROR';
3711:

Line 3709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3705: x_return_status := FND_API.G_RET_STS_ERROR ;
3706:
3707: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3708: ROLLBACK;
3709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3710: x_upload_status := 'ERROR';
3711:
3712: WHEN OTHERS THEN
3713: ROLLBACK;

Line 3714: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3710: x_upload_status := 'ERROR';
3711:
3712: WHEN OTHERS THEN
3713: ROLLBACK;
3714: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3715: x_upload_status := 'ERROR';
3716:
3717: xla_aad_loader_util_pvt.stack_error
3718: (p_appli_s_name => 'XLA'