APPS.OKL_CSBRW_PVT dependencies on OKC_API

Line 4: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

1: PACKAGE BODY OKL_CSBRW_PVT AS
2: /* $Header: OKLRFBRB.pls 120.2 2005/10/30 04:33:43 appldev noship $ */
3: FUNCTION cust_amount_info( p_api_version IN NUMBER,
4: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
5: x_msg_count OUT NOCOPY NUMBER,
6: x_msg_data OUT NOCOPY VARCHAR2,
7: p_cust_account_id IN NUMBER,
8: x_amnt_applied OUT NOCOPY NUMBER,

Line 46: x_return_status := OKC_API.START_ACTIVITY(l_api_name,

42:
43:
44: BEGIN
45:
46: x_return_status := OKC_API.START_ACTIVITY(l_api_name,
47: G_PKG_NAME,
48: p_init_msg_list,
49: l_api_version,
50: p_api_version,

Line 53: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

49: l_api_version,
50: p_api_version,
51: '_PROCESS',
52: x_return_status);
53: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
54: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
55: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
56: RAISE OKC_API.G_EXCEPTION_ERROR;
57: END IF;

Line 54: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

50: p_api_version,
51: '_PROCESS',
52: x_return_status);
53: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
54: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
55: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
56: RAISE OKC_API.G_EXCEPTION_ERROR;
57: END IF;
58:

Line 55: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

51: '_PROCESS',
52: x_return_status);
53: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
54: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
55: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
56: RAISE OKC_API.G_EXCEPTION_ERROR;
57: END IF;
58:
59:

Line 56: RAISE OKC_API.G_EXCEPTION_ERROR;

52: x_return_status);
53: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
54: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
55: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
56: RAISE OKC_API.G_EXCEPTION_ERROR;
57: END IF;
58:
59:
60: open cust_amnt_applied;

Line 70: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

66: CLOSE cust_amnt_outstnading ;
67:
68:
69: return (x_return_status);
70: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
71: EXCEPTION
72: WHEN OKC_API.G_EXCEPTION_ERROR THEN
73: x_return_status := OKC_API.HANDLE_EXCEPTIONS
74: (

Line 72: WHEN OKC_API.G_EXCEPTION_ERROR THEN

68:
69: return (x_return_status);
70: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
71: EXCEPTION
72: WHEN OKC_API.G_EXCEPTION_ERROR THEN
73: x_return_status := OKC_API.HANDLE_EXCEPTIONS
74: (
75: l_api_name,
76: G_PKG_NAME,

Line 73: x_return_status := OKC_API.HANDLE_EXCEPTIONS

69: return (x_return_status);
70: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
71: EXCEPTION
72: WHEN OKC_API.G_EXCEPTION_ERROR THEN
73: x_return_status := OKC_API.HANDLE_EXCEPTIONS
74: (
75: l_api_name,
76: G_PKG_NAME,
77: 'OKC_API.G_RET_STS_ERROR',

Line 77: 'OKC_API.G_RET_STS_ERROR',

73: x_return_status := OKC_API.HANDLE_EXCEPTIONS
74: (
75: l_api_name,
76: G_PKG_NAME,
77: 'OKC_API.G_RET_STS_ERROR',
78: x_msg_count,
79: x_msg_data,
80: '_PROCESS'
81: );

Line 82: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

78: x_msg_count,
79: x_msg_data,
80: '_PROCESS'
81: );
82: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
83: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
84: (
85: l_api_name,
86: G_PKG_NAME,

Line 83: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

79: x_msg_data,
80: '_PROCESS'
81: );
82: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
83: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
84: (
85: l_api_name,
86: G_PKG_NAME,
87: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 87: 'OKC_API.G_RET_STS_UNEXP_ERROR',

83: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
84: (
85: l_api_name,
86: G_PKG_NAME,
87: 'OKC_API.G_RET_STS_UNEXP_ERROR',
88: x_msg_count,
89: x_msg_data,
90: '_PROCESS'
91: );

Line 93: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

89: x_msg_data,
90: '_PROCESS'
91: );
92: WHEN OTHERS THEN
93: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
94: ,p_msg_name => G_UNEXPECTED_ERROR
95: ,p_token1 => G_SQLCODE_TOKEN
96: ,p_token1_value => SQLCODE
97: ,p_token2 => G_SQLERRM_TOKEN

Line 99: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

95: ,p_token1 => G_SQLCODE_TOKEN
96: ,p_token1_value => SQLCODE
97: ,p_token2 => G_SQLERRM_TOKEN
98: ,p_token2_value => SQLERRM);
99: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
100: return (x_return_status);
101: END cust_amount_info;
102:
103: END OKL_CSBRW_PVT;