2554:
2555: WHEN OTHERS THEN
2556:
2557:
2558: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2559: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2560: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2561: p_token1_value => sqlcode,
2562: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2555: WHEN OTHERS THEN
2556:
2557:
2558: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2559: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2560: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2561: p_token1_value => sqlcode,
2562: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2563: p_token2_value => sqlerrm);
2556:
2557:
2558: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2559: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2560: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2561: p_token1_value => sqlcode,
2562: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2563: p_token2_value => sqlerrm);
2564:
2558: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2559: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2560: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2561: p_token1_value => sqlcode,
2562: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2563: p_token2_value => sqlerrm);
2564:
2565: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2566:
2628: EXCEPTION
2629:
2630: WHEN OTHERS THEN
2631:
2632: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2633: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2634: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2635: p_token1_value => sqlcode,
2636: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2629:
2630: WHEN OTHERS THEN
2631:
2632: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2633: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2634: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2635: p_token1_value => sqlcode,
2636: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2637: p_token2_value => sqlerrm);
2630: WHEN OTHERS THEN
2631:
2632: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2633: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2634: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2635: p_token1_value => sqlcode,
2636: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2637: p_token2_value => sqlerrm);
2638:
2632: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2633: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2634: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2635: p_token1_value => sqlcode,
2636: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2637: p_token2_value => sqlerrm);
2638:
2639: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2640: