2641: EXCEPTION
2642: -- other appropriate handlers
2643: WHEN OTHERS THEN
2644: -- store SQL error message on message stack
2645: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2646: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2647: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2648: p_token1_value => sqlcode,
2649: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2642: -- other appropriate handlers
2643: WHEN OTHERS THEN
2644: -- store SQL error message on message stack
2645: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2646: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2647: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2648: p_token1_value => sqlcode,
2649: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2650: p_token2_value => sqlerrm);
2643: WHEN OTHERS THEN
2644: -- store SQL error message on message stack
2645: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2646: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2647: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2648: p_token1_value => sqlcode,
2649: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2650: p_token2_value => sqlerrm);
2651:
2645: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2646: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2647: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2648: p_token1_value => sqlcode,
2649: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2650: p_token2_value => sqlerrm);
2651:
2652: -- notify UNEXPECTED error
2653: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2709: EXCEPTION
2710: -- other appropriate handlers
2711: WHEN OTHERS THEN
2712: -- store SQL error message on message stack
2713: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2714: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2715: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2716: p_token1_value => sqlcode,
2717: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2710: -- other appropriate handlers
2711: WHEN OTHERS THEN
2712: -- store SQL error message on message stack
2713: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2714: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2715: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2716: p_token1_value => sqlcode,
2717: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2718: p_token2_value => sqlerrm);
2711: WHEN OTHERS THEN
2712: -- store SQL error message on message stack
2713: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2714: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2715: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2716: p_token1_value => sqlcode,
2717: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2718: p_token2_value => sqlerrm);
2719:
2713: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2714: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2715: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2716: p_token1_value => sqlcode,
2717: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2718: p_token2_value => sqlerrm);
2719:
2720: -- notify UNEXPECTED error
2721: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;