DBA Data[Home] [Help]

APPS.OKL_KPL_PVT dependencies on OKC_API

Line 2645: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;

2641: FUNCTION create_version(
2642: p_chr_id IN NUMBER,
2643: p_major_version IN NUMBER) RETURN VARCHAR2 IS
2644:
2645: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
2646:
2647: BEGIN
2648: INSERT INTO OKL_K_PARTY_ROLES_H
2649: (

Line 2710: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,

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,

Line 2718: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

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;
2719: return l_return_status;
2720: END create_version;
2721:
2722: FUNCTION restore_version(

Line 2726: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;

2722: FUNCTION restore_version(
2723: p_chr_id IN NUMBER,
2724: p_major_version IN NUMBER) RETURN VARCHAR2 IS
2725:
2726: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
2727:
2728: BEGIN
2729: INSERT INTO OKL_K_PARTY_ROLES
2730: (

Line 2791: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,

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,

Line 2799: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

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;
2800: return l_return_status;
2801: END restore_version;
2802:
2803: END OKL_KPL_PVT;