7422: EXCEPTION
7423: -- other appropriate handlers
7424: WHEN OTHERS THEN
7425: -- store SQL error message on message stack
7426: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
7427: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
7428: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
7429: p_token1_value => sqlcode,
7430: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
7423: -- other appropriate handlers
7424: WHEN OTHERS THEN
7425: -- store SQL error message on message stack
7426: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
7427: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
7428: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
7429: p_token1_value => sqlcode,
7430: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
7431: p_token2_value => sqlerrm);
7424: WHEN OTHERS THEN
7425: -- store SQL error message on message stack
7426: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
7427: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
7428: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
7429: p_token1_value => sqlcode,
7430: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
7431: p_token2_value => sqlerrm);
7432:
7426: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
7427: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
7428: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
7429: p_token1_value => sqlcode,
7430: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
7431: p_token2_value => sqlerrm);
7432:
7433: -- notify UNEXPECTED error
7434: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
8114: EXCEPTION
8115: -- other appropriate handlers
8116: WHEN OTHERS THEN
8117: -- store SQL error message on message stack
8118: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
8119: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
8120: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
8121: p_token1_value => sqlcode,
8122: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
8115: -- other appropriate handlers
8116: WHEN OTHERS THEN
8117: -- store SQL error message on message stack
8118: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
8119: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
8120: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
8121: p_token1_value => sqlcode,
8122: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
8123: p_token2_value => sqlerrm);
8116: WHEN OTHERS THEN
8117: -- store SQL error message on message stack
8118: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
8119: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
8120: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
8121: p_token1_value => sqlcode,
8122: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
8123: p_token2_value => sqlerrm);
8124:
8118: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
8119: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
8120: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
8121: p_token1_value => sqlcode,
8122: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
8123: p_token2_value => sqlerrm);
8124:
8125: -- notify UNEXPECTED error
8126: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;