2545: END IF;
2546:
2547: -- store SQL error message on message stack
2548: OKC_API.SET_MESSAGE
2549: (p_app_name => okc_version_pvt.G_APP_NAME,
2550: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2551: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2552: p_token1_value => sqlcode,
2553: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2546:
2547: -- store SQL error message on message stack
2548: OKC_API.SET_MESSAGE
2549: (p_app_name => okc_version_pvt.G_APP_NAME,
2550: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2551: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2552: p_token1_value => sqlcode,
2553: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2554: p_token2_value => sqlerrm);
2547: -- store SQL error message on message stack
2548: OKC_API.SET_MESSAGE
2549: (p_app_name => okc_version_pvt.G_APP_NAME,
2550: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2551: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2552: p_token1_value => sqlcode,
2553: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2554: p_token2_value => sqlerrm);
2555:
2549: (p_app_name => okc_version_pvt.G_APP_NAME,
2550: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2551: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2552: p_token1_value => sqlcode,
2553: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2554: p_token2_value => sqlerrm);
2555:
2556: -- notify UNEXPECTED error
2557: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2644:
2645: -- store SQL error message on message stack
2646:
2647: OKC_API.SET_MESSAGE
2648: (p_app_name => okc_version_pvt.G_APP_NAME,
2649: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2650: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2651: p_token1_value => sqlcode,
2652: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2645: -- store SQL error message on message stack
2646:
2647: OKC_API.SET_MESSAGE
2648: (p_app_name => okc_version_pvt.G_APP_NAME,
2649: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2650: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2651: p_token1_value => sqlcode,
2652: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2653: p_token2_value => sqlerrm);
2646:
2647: OKC_API.SET_MESSAGE
2648: (p_app_name => okc_version_pvt.G_APP_NAME,
2649: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2650: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2651: p_token1_value => sqlcode,
2652: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2653: p_token2_value => sqlerrm);
2654:
2648: (p_app_name => okc_version_pvt.G_APP_NAME,
2649: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2650: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2651: p_token1_value => sqlcode,
2652: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2653: p_token2_value => sqlerrm);
2654:
2655: -- notify UNEXPECTED error
2656: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;