2830: okc_debug.Reset_Indentation;
2831: END IF;
2832:
2833: -- store SQL error message on message stack
2834: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2835: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2836: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2837: p_token1_value => sqlcode,
2838: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2831: END IF;
2832:
2833: -- store SQL error message on message stack
2834: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2835: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2836: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2837: p_token1_value => sqlcode,
2838: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2839: p_token2_value => sqlerrm);
2832:
2833: -- store SQL error message on message stack
2834: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2835: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2836: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2837: p_token1_value => sqlcode,
2838: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2839: p_token2_value => sqlerrm);
2840:
2834: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2835: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2836: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2837: p_token1_value => sqlcode,
2838: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2839: p_token2_value => sqlerrm);
2840:
2841: -- notify UNEXPECTED error
2842: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
2923: okc_debug.Reset_Indentation;
2924: END IF;
2925:
2926: -- store SQL error message on message stack
2927: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2928: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2929: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2930: p_token1_value => sqlcode,
2931: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2924: END IF;
2925:
2926: -- store SQL error message on message stack
2927: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2928: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2929: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2930: p_token1_value => sqlcode,
2931: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2932: p_token2_value => sqlerrm);
2925:
2926: -- store SQL error message on message stack
2927: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2928: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2929: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2930: p_token1_value => sqlcode,
2931: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2932: p_token2_value => sqlerrm);
2933:
2927: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
2928: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
2929: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
2930: p_token1_value => sqlcode,
2931: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
2932: p_token2_value => sqlerrm);
2933:
2934: -- notify UNEXPECTED error
2935: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;