APPS.OKC_VERSION_PUB dependencies on OKC_API

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

35: p_cvmv_tbl IN cvmv_tbl_type,
36: p_commit IN VARCHAR2 ,
37: x_cvmv_tbl OUT NOCOPY cvmv_tbl_type) IS
38: i NUMBER := 0;
39: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
40:
41: BEGIN
42: x_return_status := OKC_API.G_RET_STS_SUCCESS;
43: IF p_cvmv_tbl.COUNT > 0 THEN

Line 42: x_return_status := OKC_API.G_RET_STS_SUCCESS;

38: i NUMBER := 0;
39: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
40:
41: BEGIN
42: x_return_status := OKC_API.G_RET_STS_SUCCESS;
43: IF p_cvmv_tbl.COUNT > 0 THEN
44: i := p_cvmv_tbl.FIRST;
45: LOOP
46: version_contract(

Line 55: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

51: x_msg_data => x_msg_data,
52: p_cvmv_rec => p_cvmv_tbl(i),
53: p_commit => p_commit,
54: x_cvmv_rec => x_cvmv_tbl(i));
55: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
56: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
57: x_return_status := l_return_status;
58: raise G_EXCEPTION_HALT_PROCESSING;
59: ELSE

Line 56: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

52: p_cvmv_rec => p_cvmv_tbl(i),
53: p_commit => p_commit,
54: x_cvmv_rec => x_cvmv_tbl(i));
55: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
56: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
57: x_return_status := l_return_status;
58: raise G_EXCEPTION_HALT_PROCESSING;
59: ELSE
60: x_return_status := l_return_status;

Line 71: OKC_API.set_message(p_app_name => g_app_name,

67: EXCEPTION
68: WHEN G_EXCEPTION_HALT_PROCESSING THEN
69: NULL;
70: WHEN OTHERS THEN
71: OKC_API.set_message(p_app_name => g_app_name,
72: p_msg_name => g_unexpected_error,
73: p_token1 => g_sqlcode_token,
74: p_token1_value => sqlcode,
75: p_token2 => g_sqlerrm_token,

Line 77: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

73: p_token1 => g_sqlcode_token,
74: p_token1_value => sqlcode,
75: p_token2 => g_sqlerrm_token,
76: p_token2_value => sqlerrm);
77: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
78: END Version_Contract;
79:
80: PROCEDURE save_version(
81: p_chr_id IN NUMBER,