4796: EXCEPTION
4797: -- other appropriate handlers
4798: WHEN OTHERS THEN
4799: -- store SQL error message on message stack
4800: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
4801: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
4802: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
4803: p_token1_value => sqlcode,
4804: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
4797: -- other appropriate handlers
4798: WHEN OTHERS THEN
4799: -- store SQL error message on message stack
4800: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
4801: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
4802: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
4803: p_token1_value => sqlcode,
4804: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
4805: p_token2_value => sqlerrm);
4798: WHEN OTHERS THEN
4799: -- store SQL error message on message stack
4800: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
4801: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
4802: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
4803: p_token1_value => sqlcode,
4804: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
4805: p_token2_value => sqlerrm);
4806:
4800: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
4801: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
4802: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
4803: p_token1_value => sqlcode,
4804: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
4805: p_token2_value => sqlerrm);
4806:
4807: -- notify UNEXPECTED error
4808: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;