DBA Data[Home] [Help]

APPS.OKL_SETUP_PRCPARAMS_PUB dependencies on OKL_API

Line 27: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,

23: BEGIN
24: x_return_status := G_RET_STS_SUCCESS;
25: l_sppv_rec := p_sppv_rec;
26:
27: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
28: p_pkg_name => G_PKG_NAME,
29: p_init_msg_list => p_init_msg_list,
30: l_api_version => l_api_version,
31: p_api_version => p_api_version,

Line 62: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

58: l_sppv_rec := x_sppv_rec;
59:
60:
61:
62: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
63: x_msg_data => x_msg_data);
64: x_return_status := l_return_status;
65:
66: EXCEPTION

Line 68: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

64: x_return_status := l_return_status;
65:
66: EXCEPTION
67: WHEN G_EXC_ERROR THEN
68: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
69: p_pkg_name => G_PKG_NAME,
70: p_exc_name => G_EXC_NAME_RET_STS_ERR,
71: x_msg_count => x_msg_count,
72: x_msg_data => x_msg_data,

Line 76: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

72: x_msg_data => x_msg_data,
73: p_api_type => G_API_TYPE);
74:
75: WHEN G_EXC_UNEXPECTED_ERROR THEN
76: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
77: p_pkg_name => G_PKG_NAME,
78: p_exc_name => G_EXC_NAME_RET_STS_UNEXP_ERR,
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 => l_api_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 => l_api_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 115: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,

111: BEGIN
112: x_return_status := G_RET_STS_SUCCESS;
113: l_sppv_rec := p_sppv_rec;
114:
115: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
116: p_pkg_name => G_PKG_NAME,
117: p_init_msg_list => p_init_msg_list,
118: l_api_version => l_api_version,
119: p_api_version => p_api_version,

Line 150: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

146: l_sppv_rec := x_sppv_rec;
147:
148:
149:
150: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
151: x_msg_data => x_msg_data);
152: x_return_status := l_return_status;
153:
154: EXCEPTION

Line 156: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

152: x_return_status := l_return_status;
153:
154: EXCEPTION
155: WHEN G_EXC_ERROR THEN
156: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
157: p_pkg_name => G_PKG_NAME,
158: p_exc_name => G_EXC_NAME_RET_STS_ERR,
159: x_msg_count => x_msg_count,
160: x_msg_data => x_msg_data,

Line 164: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

160: x_msg_data => x_msg_data,
161: p_api_type => G_API_TYPE);
162:
163: WHEN G_EXC_UNEXPECTED_ERROR THEN
164: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
165: p_pkg_name => G_PKG_NAME,
166: p_exc_name => G_EXC_NAME_RET_STS_UNEXP_ERR,
167: x_msg_count => x_msg_count,
168: x_msg_data => x_msg_data,

Line 171: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

167: x_msg_count => x_msg_count,
168: x_msg_data => x_msg_data,
169: p_api_type => G_API_TYPE);
170: WHEN OTHERS THEN
171: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
172: p_pkg_name => G_PKG_NAME,
173: p_exc_name => G_EXC_NAME_OTHERS,
174: x_msg_count => x_msg_count,
175: x_msg_data => x_msg_data,

Line 206: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

202: rec_num := p_sppv_tbl.NEXT(rec_num);
203: END LOOP;
204: EXCEPTION
205: WHEN G_EXCEPTION_ERROR THEN
206: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
207: p_pkg_name => G_PKG_NAME,
208: p_exc_name => G_EXC_NAME_RET_STS_ERR,
209: x_msg_count => x_msg_count,
210: x_msg_data => x_msg_data,

Line 213: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

209: x_msg_count => x_msg_count,
210: x_msg_data => x_msg_data,
211: p_api_type => G_API_TYPE);
212: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
213: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
214: p_pkg_name => G_PKG_NAME,
215: p_exc_name => G_EXC_NAME_RET_STS_UNEXP_ERR,
216: x_msg_count => x_msg_count,
217: x_msg_data => x_msg_data,

Line 220: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

216: x_msg_count => x_msg_count,
217: x_msg_data => x_msg_data,
218: p_api_type => G_API_TYPE);
219: WHEN OTHERS THEN
220: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
221: p_pkg_name => G_PKG_NAME,
222: p_exc_name => G_EXC_NAME_OTHERS,
223: x_msg_count => x_msg_count,
224: x_msg_data => x_msg_data,

Line 257: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

253: rec_num := p_sppv_tbl.NEXT(rec_num);
254: END LOOP;
255: EXCEPTION
256: WHEN G_EXCEPTION_ERROR THEN
257: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
258: p_pkg_name => G_PKG_NAME,
259: p_exc_name => G_EXC_NAME_RET_STS_ERR,
260: x_msg_count => x_msg_count,
261: x_msg_data => x_msg_data,

Line 264: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

260: x_msg_count => x_msg_count,
261: x_msg_data => x_msg_data,
262: p_api_type => G_API_TYPE);
263: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
264: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
265: p_pkg_name => G_PKG_NAME,
266: p_exc_name => G_EXC_NAME_RET_STS_UNEXP_ERR,
267: x_msg_count => x_msg_count,
268: x_msg_data => x_msg_data,

Line 271: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

267: x_msg_count => x_msg_count,
268: x_msg_data => x_msg_data,
269: p_api_type => G_API_TYPE);
270: WHEN OTHERS THEN
271: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
272: p_pkg_name => G_PKG_NAME,
273: p_exc_name => G_EXC_NAME_OTHERS,
274: x_msg_count => x_msg_count,
275: x_msg_data => x_msg_data,