2706: EXCEPTION
2707: -- other appropriate handlers
2708: WHEN OTHERS THEN
2709: -- store SQL error message on message stack
2710: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2711: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2712: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2713: p_token1_value => sqlcode,
2714: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2707: -- other appropriate handlers
2708: WHEN OTHERS THEN
2709: -- store SQL error message on message stack
2710: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2711: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2712: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2713: p_token1_value => sqlcode,
2714: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2715: p_token2_value => sqlerrm);
2708: WHEN OTHERS THEN
2709: -- store SQL error message on message stack
2710: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2711: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2712: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2713: p_token1_value => sqlcode,
2714: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2715: p_token2_value => sqlerrm);
2716:
2710: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2711: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2712: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2713: p_token1_value => sqlcode,
2714: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2715: p_token2_value => sqlerrm);
2716:
2717: -- notify UNEXPECTED error
2718: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2787: EXCEPTION
2788: -- other appropriate handlers
2789: WHEN OTHERS THEN
2790: -- store SQL error message on message stack
2791: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2792: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2793: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2794: p_token1_value => sqlcode,
2795: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2788: -- other appropriate handlers
2789: WHEN OTHERS THEN
2790: -- store SQL error message on message stack
2791: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2792: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2793: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2794: p_token1_value => sqlcode,
2795: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2796: p_token2_value => sqlerrm);
2789: WHEN OTHERS THEN
2790: -- store SQL error message on message stack
2791: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2792: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2793: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2794: p_token1_value => sqlcode,
2795: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2796: p_token2_value => sqlerrm);
2797:
2791: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2792: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2793: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2794: p_token1_value => sqlcode,
2795: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2796: p_token2_value => sqlerrm);
2797:
2798: -- notify UNEXPECTED error
2799: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;