APPS.OKL_CREDIT_MGNT_PUB dependencies on OKL_API

Line 7: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

3:
4: --
5: PROCEDURE submit_credit_request
6: (p_api_version IN NUMBER
7: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
8: ,x_return_status OUT NOCOPY VARCHAR2
9: ,x_msg_count OUT NOCOPY NUMBER
10: ,x_msg_data OUT NOCOPY VARCHAR2
11: ,p_contract_id IN NUMBER

Line 20: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

16: ,p_notes IN VARCHAR2
17: ,p_chr_rec IN okl_credit_mgnt_pvt.l_chr_rec
18: ) IS
19:
20: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
21: l_api_version CONSTANT NUMBER := 1;
22:
23:
24: BEGIN

Line 26: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => G_APP_NAME,

22:
23:
24: BEGIN
25:
26: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => G_APP_NAME,
27: p_pkg_name => G_PKG_NAME,
28: p_init_msg_list => p_init_msg_list,
29: l_api_version => l_api_version,
30: p_api_version => p_api_version,

Line 34: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

30: p_api_version => p_api_version,
31: p_api_type => G_API_TYPE,
32: x_return_status => l_return_status);
33:
34: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
35: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
36: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
37: RAISE G_EXCEPTION_ERROR;
38: END IF;

Line 36: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

32: x_return_status => l_return_status);
33:
34: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
35: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
36: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
37: RAISE G_EXCEPTION_ERROR;
38: END IF;
39:
40:

Line 57: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

53: ,p_chr_rec => p_chr_rec
54: );
55:
56:
57: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
58: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
59: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
60: RAISE G_EXCEPTION_ERROR;
61: END IF;

Line 59: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

55:
56:
57: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
58: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
59: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
60: RAISE G_EXCEPTION_ERROR;
61: END IF;
62:
63: okl_api.end_activity(x_msg_count => x_msg_count,

Line 63: okl_api.end_activity(x_msg_count => x_msg_count,

59: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
60: RAISE G_EXCEPTION_ERROR;
61: END IF;
62:
63: okl_api.end_activity(x_msg_count => x_msg_count,
64: x_msg_data => x_msg_data);
65: -- x_return_status := l_return_status;
66:
67: EXCEPTION

Line 69: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => G_APP_NAME,

65: -- x_return_status := l_return_status;
66:
67: EXCEPTION
68: WHEN G_EXCEPTION_ERROR THEN
69: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => G_APP_NAME,
70: p_pkg_name => G_PKG_NAME,
71: p_exc_name => G_EXC_NAME_ERROR,
72: x_msg_count => x_msg_count,
73: x_msg_data => x_msg_data,

Line 76: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => G_APP_NAME,

72: x_msg_count => x_msg_count,
73: x_msg_data => x_msg_data,
74: p_api_type => G_API_TYPE);
75: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
76: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => G_APP_NAME,
77: p_pkg_name => G_PKG_NAME,
78: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
79: x_msg_count => x_msg_count,
80: x_msg_data => x_msg_data,

Line 83: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => G_APP_NAME,

79: x_msg_count => x_msg_count,
80: x_msg_data => x_msg_data,
81: p_api_type => G_API_TYPE);
82: WHEN OTHERS THEN
83: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => G_APP_NAME,
84: p_pkg_name => G_PKG_NAME,
85: p_exc_name => G_EXC_NAME_OTHERS,
86: x_msg_count => x_msg_count,
87: x_msg_data => x_msg_data,

Line 94: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

90:
91:
92: PROCEDURE compile_credit_request
93: (p_api_version IN NUMBER
94: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
95: ,x_return_status OUT NOCOPY VARCHAR2
96: ,x_msg_count OUT NOCOPY NUMBER
97: ,x_msg_data OUT NOCOPY VARCHAR2
98: ,p_contract_id IN NUMBER

Line 102: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

98: ,p_contract_id IN NUMBER
99: ,x_chr_rec OUT NOCOPY okl_credit_mgnt_pvt.l_chr_rec
100: ) IS
101:
102: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
103: l_api_version CONSTANT NUMBER := 1;
104:
105:
106: BEGIN

Line 108: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => G_APP_NAME,

104:
105:
106: BEGIN
107:
108: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => G_APP_NAME,
109: p_pkg_name => G_PKG_NAME,
110: p_init_msg_list => p_init_msg_list,
111: l_api_version => l_api_version,
112: p_api_version => p_api_version,

Line 116: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

112: p_api_version => p_api_version,
113: p_api_type => G_API_TYPE,
114: x_return_status => l_return_status);
115:
116: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
117: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
118: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
119: RAISE G_EXCEPTION_ERROR;
120: END IF;

Line 118: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

114: x_return_status => l_return_status);
115:
116: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
117: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
118: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
119: RAISE G_EXCEPTION_ERROR;
120: END IF;
121:
122: okl_credit_mgnt_pvt.compile_credit_request

Line 133: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

129: ,x_chr_rec => x_chr_rec
130: );
131:
132:
133: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
134: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
135: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
136: RAISE G_EXCEPTION_ERROR;
137: END IF;

Line 135: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

131:
132:
133: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
134: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
135: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
136: RAISE G_EXCEPTION_ERROR;
137: END IF;
138:
139: okl_api.end_activity(x_msg_count => x_msg_count,

Line 139: okl_api.end_activity(x_msg_count => x_msg_count,

135: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
136: RAISE G_EXCEPTION_ERROR;
137: END IF;
138:
139: okl_api.end_activity(x_msg_count => x_msg_count,
140: x_msg_data => x_msg_data);
141:
142: x_return_status := l_return_status;
143:

Line 146: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => G_APP_NAME,

142: x_return_status := l_return_status;
143:
144: EXCEPTION
145: WHEN G_EXCEPTION_ERROR THEN
146: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => G_APP_NAME,
147: p_pkg_name => G_PKG_NAME,
148: p_exc_name => G_EXC_NAME_ERROR,
149: x_msg_count => x_msg_count,
150: x_msg_data => x_msg_data,

Line 153: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => G_APP_NAME,

149: x_msg_count => x_msg_count,
150: x_msg_data => x_msg_data,
151: p_api_type => G_API_TYPE);
152: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
153: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => G_APP_NAME,
154: p_pkg_name => G_PKG_NAME,
155: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
156: x_msg_count => x_msg_count,
157: x_msg_data => x_msg_data,

Line 160: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => G_APP_NAME,

156: x_msg_count => x_msg_count,
157: x_msg_data => x_msg_data,
158: p_api_type => G_API_TYPE);
159: WHEN OTHERS THEN
160: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => G_APP_NAME,
161: p_pkg_name => G_PKG_NAME,
162: p_exc_name => G_EXC_NAME_OTHERS,
163: x_msg_count => x_msg_count,
164: x_msg_data => x_msg_data,