606: ,p_caller_version_number => p_api_version
607: ,p_api_name => l_api_name
608: ,p_pkg_name => C_DEFAULT_MODULE))
609: THEN
610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
611: END IF;
612:
613: -- Initialize global variables
614: x_return_status := FND_API.G_RET_STS_SUCCESS;
610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
611: END IF;
612:
613: -- Initialize global variables
614: x_return_status := FND_API.G_RET_STS_SUCCESS;
615:
616: -- API Logic
617: l_staging_context_code := xla_aad_loader_util_pvt.get_staging_context_code
618: (p_application_id => p_application_id
622: ,p_amb_context_code => p_amb_context_code
623: ,p_staging_context_code => l_staging_context_code);
624:
625: IF (x_import_status = 'ERROR') THEN
626: RAISE FND_API.G_EXC_ERROR;
627: END IF;
628:
629: xla_aad_upload_pvt.upload
630: (p_api_version => 1.0
633: ,p_source_pathname => p_source_pathname
634: ,p_amb_context_code => p_amb_context_code
635: ,x_upload_status => x_import_status);
636: IF (x_import_status = 'ERROR') THEN
637: RAISE FND_API.G_EXC_ERROR;
638: END IF;
639:
640: post_import(p_application_id => p_application_id
641: ,p_amb_context_code => p_amb_context_code
646: p_module => l_log_module,
647: p_level => C_LEVEL_PROCEDURE);
648: END IF;
649: EXCEPTION
650: WHEN FND_API.G_EXC_ERROR THEN
651: x_return_status := FND_API.G_RET_STS_ERROR ;
652: x_import_status := 'ERROR';
653:
654: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
647: p_level => C_LEVEL_PROCEDURE);
648: END IF;
649: EXCEPTION
650: WHEN FND_API.G_EXC_ERROR THEN
651: x_return_status := FND_API.G_RET_STS_ERROR ;
652: x_import_status := 'ERROR';
653:
654: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
655: ROLLBACK;
650: WHEN FND_API.G_EXC_ERROR THEN
651: x_return_status := FND_API.G_RET_STS_ERROR ;
652: x_import_status := 'ERROR';
653:
654: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
655: ROLLBACK;
656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
657: x_import_status := 'ERROR';
658:
652: x_import_status := 'ERROR';
653:
654: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
655: ROLLBACK;
656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
657: x_import_status := 'ERROR';
658:
659: WHEN OTHERS THEN
660: ROLLBACK;
657: x_import_status := 'ERROR';
658:
659: WHEN OTHERS THEN
660: ROLLBACK;
661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
662: x_import_status := 'ERROR';
663:
664: xla_aad_loader_util_pvt.stack_error
665: (p_appli_s_name => 'XLA'