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 1633: RAISE FND_API.G_EXC_ERROR;

1629: p_component_code => 'populate_mapping_sets');
1630: END IF;
1631:
1632: IF (l_error_found) THEN
1633: RAISE FND_API.G_EXC_ERROR;
1634: END IF;
1635:
1636: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
1637: trace(p_msg => 'END of procedure populate_mapping_sets',

Line 1644: WHEN FND_API.G_EXC_ERROR THEN

1640: END IF;
1641:
1642: RETURN 'SUCCESS';
1643: EXCEPTION
1644: WHEN FND_API.G_EXC_ERROR THEN
1645: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
1646: trace(p_msg => 'END of procedure populate_adrs: ERROR',
1647: p_module => l_log_module,
1648: p_level => C_LEVEL_PROCEDURE);

Line 2490: RAISE FND_API.G_EXC_ERROR;

2486: p_encoded_message => '# insert (XLA_ADR_CONDITIONS) = '||l_num_rows,
2487: p_component_code => 'populate_adrs');
2488:
2489: IF (l_error_found) THEN
2490: RAISE FND_API.G_EXC_ERROR;
2491: END IF;
2492:
2493: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2494: trace(p_msg => 'END of procedure populate_adrs',

Line 2501: WHEN FND_API.G_EXC_ERROR THEN

2497: END IF;
2498:
2499: RETURN 'SUCCESS';
2500: EXCEPTION
2501: WHEN FND_API.G_EXC_ERROR THEN
2502: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2503: trace(p_msg => 'END of procedure populate_adrs: ERROR',
2504: p_module => l_log_module,
2505: p_level => C_LEVEL_PROCEDURE);

Line 4309: RAISE FND_API.G_EXC_ERROR;

4305: populate_history(p_staging_context_code => p_staging_context_code);
4306:
4307:
4308: IF (l_error_found) THEN
4309: RAISE FND_API.G_EXC_ERROR;
4310: END IF;
4311:
4312: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
4313: trace(p_msg => 'END of procedure populate_data',

Line 4320: WHEN FND_API.G_EXC_ERROR THEN

4316: END IF;
4317:
4318: RETURN 'SUCCESS';
4319: EXCEPTION
4320: WHEN FND_API.G_EXC_ERROR THEN
4321: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
4322: trace(p_msg => 'END of procedure populate_data: ERROR',
4323: p_module => l_log_module,
4324: p_level => C_LEVEL_PROCEDURE);

Line 4375: RAISE FND_API.G_EXC_ERROR;

4371: (p_application_id => p_application_id
4372: ,p_staging_context_code => p_staging_context_code);
4373:
4374: IF (l_upload_status IN ('WARNING','ERROR')) THEN
4375: RAISE FND_API.G_EXC_ERROR;
4376: END IF;
4377:
4378: l_upload_status := populate_data
4379: (p_application_id => p_application_id

Line 4384: RAISE FND_API.G_EXC_ERROR;

4380: ,p_amb_context_code => p_amb_context_code
4381: ,p_staging_context_code => p_staging_context_code);
4382:
4383: IF (l_upload_status IN ('WARNING','ERROR')) THEN
4384: RAISE FND_API.G_EXC_ERROR;
4385: END IF;
4386:
4387: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
4388: trace(p_msg => 'END of function post_upload',

Line 4396: WHEN FND_API.G_EXC_ERROR THEN

4392:
4393:
4394: RETURN 'SUCCESS';
4395: EXCEPTION
4396: WHEN FND_API.G_EXC_ERROR THEN
4397: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
4398: trace(p_msg => 'END of function post_upload: ERROR',
4399: p_module => l_log_module,
4400: p_level => C_LEVEL_PROCEDURE);

Line 4469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4465: ,p_caller_version_number => p_api_version
4466: ,p_api_name => l_api_name
4467: ,p_pkg_name => C_DEFAULT_MODULE))
4468: THEN
4469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4470: END IF;
4471:
4472: -- Initialize variables
4473: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4473: x_return_status := FND_API.G_RET_STS_SUCCESS;

4469: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4470: END IF;
4471:
4472: -- Initialize variables
4473: x_return_status := FND_API.G_RET_STS_SUCCESS;
4474:
4475: -- API Logic
4476: l_staging_context_code := xla_aad_loader_util_pvt.get_staging_context_code
4477: (p_application_id => p_application_id

Line 4486: RAISE FND_API.G_EXC_ERROR;

4482: ,p_source_pathname => p_source_pathname
4483: ,p_staging_context_code => l_staging_context_code);
4484:
4485: IF (x_upload_status IN ('ERROR','WARNING')) THEN
4486: RAISE FND_API.G_EXC_ERROR;
4487: END IF;
4488:
4489: x_upload_status := post_upload
4490: (p_application_id => p_application_id

Line 4500: WHEN FND_API.G_EXC_ERROR THEN

4496: p_module => l_log_module,
4497: p_level => C_LEVEL_PROCEDURE);
4498: END IF;
4499: EXCEPTION
4500: WHEN FND_API.G_EXC_ERROR THEN
4501: ROLLBACK;
4502: x_return_status := FND_API.G_RET_STS_ERROR ;
4503:
4504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4502: x_return_status := FND_API.G_RET_STS_ERROR ;

4498: END IF;
4499: EXCEPTION
4500: WHEN FND_API.G_EXC_ERROR THEN
4501: ROLLBACK;
4502: x_return_status := FND_API.G_RET_STS_ERROR ;
4503:
4504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4505: ROLLBACK;
4506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 4504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4500: WHEN FND_API.G_EXC_ERROR THEN
4501: ROLLBACK;
4502: x_return_status := FND_API.G_RET_STS_ERROR ;
4503:
4504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4505: ROLLBACK;
4506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4507: x_upload_status := 'ERROR';
4508:

Line 4506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4502: x_return_status := FND_API.G_RET_STS_ERROR ;
4503:
4504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4505: ROLLBACK;
4506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4507: x_upload_status := 'ERROR';
4508:
4509: WHEN OTHERS THEN
4510: ROLLBACK;

Line 4511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4507: x_upload_status := 'ERROR';
4508:
4509: WHEN OTHERS THEN
4510: ROLLBACK;
4511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4512: x_upload_status := 'ERROR';
4513:
4514: xla_aad_loader_util_pvt.stack_error
4515: (p_appli_s_name => 'XLA'