DBA Data[Home] [Help]

APPS.OKL_SETUP_STREAMTYPES_PUB dependencies on OKL_API

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

23: x_return_status := G_RET_STS_SUCCESS;
24:
25: l_styv_rec := p_styv_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_styv_rec := x_styv_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_EXCEPTION_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_ERROR,
71: x_msg_count => x_msg_count,
72: x_msg_data => x_msg_data,

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

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

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

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

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

109: BEGIN
110: x_return_status := G_RET_STS_SUCCESS;
111: l_styv_rec := p_styv_rec;
112:
113: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
114: p_pkg_name => G_PKG_NAME,
115: p_init_msg_list => p_init_msg_list,
116: l_api_version => l_api_version,
117: p_api_version => p_api_version,

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

144: l_styv_rec := x_styv_rec;
145:
146:
147:
148: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
149: x_msg_data => x_msg_data);
150: x_return_status := l_return_status;
151: EXCEPTION
152: WHEN G_EXCEPTION_ERROR THEN

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

149: x_msg_data => x_msg_data);
150: x_return_status := l_return_status;
151: EXCEPTION
152: WHEN G_EXCEPTION_ERROR THEN
153: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
154: p_pkg_name => G_PKG_NAME,
155: p_exc_name => G_EXC_NAME_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 => l_api_name,

156: x_msg_count => x_msg_count,
157: x_msg_data => x_msg_data,
158: p_api_type => G_API_TYPE);
159: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
160: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
161: p_pkg_name => G_PKG_NAME,
162: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
163: x_msg_count => x_msg_count,
164: x_msg_data => x_msg_data,

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

163: x_msg_count => x_msg_count,
164: x_msg_data => x_msg_data,
165: p_api_type => G_API_TYPE);
166: WHEN OTHERS THEN
167: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
168: p_pkg_name => G_PKG_NAME,
169: p_exc_name => G_EXC_NAME_OTHERS,
170: x_msg_count => x_msg_count,
171: x_msg_data => x_msg_data,

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

185: rec_num INTEGER := 0;
186: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
187: l_api_version CONSTANT NUMBER := 1;
188: BEGIN
189: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
190: p_pkg_name => G_PKG_NAME,
191: p_init_msg_list => p_init_msg_list,
192: l_api_version => l_api_version,
193: p_api_version => p_api_version,

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

216: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
217: END IF;
218:
219: END LOOP;
220: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
221: x_msg_data => x_msg_data);
222: x_return_status := l_return_status;
223: EXCEPTION
224: WHEN G_EXCEPTION_ERROR THEN

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

221: x_msg_data => x_msg_data);
222: x_return_status := l_return_status;
223: EXCEPTION
224: WHEN G_EXCEPTION_ERROR THEN
225: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
226: p_pkg_name => G_PKG_NAME,
227: p_exc_name => G_EXC_NAME_ERROR,
228: x_msg_count => x_msg_count,
229: x_msg_data => x_msg_data,

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

228: x_msg_count => x_msg_count,
229: x_msg_data => x_msg_data,
230: p_api_type => G_API_TYPE);
231: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
232: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
233: p_pkg_name => G_PKG_NAME,
234: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
235: x_msg_count => x_msg_count,
236: x_msg_data => x_msg_data,

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

235: x_msg_count => x_msg_count,
236: x_msg_data => x_msg_data,
237: p_api_type => G_API_TYPE);
238: WHEN OTHERS THEN
239: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
240: p_pkg_name => G_PKG_NAME,
241: p_exc_name => G_EXC_NAME_OTHERS,
242: x_msg_count => x_msg_count,
243: x_msg_data => x_msg_data,

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

259: rec_num INTEGER := 0;
260: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
261: l_api_version CONSTANT NUMBER := 1;
262: BEGIN
263: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
264: p_pkg_name => G_PKG_NAME,
265: p_init_msg_list => p_init_msg_list,
266: l_api_version => l_api_version,
267: p_api_version => p_api_version,

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

290: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
291: END IF;
292:
293: END LOOP;
294: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
295: x_msg_data => x_msg_data);
296: x_return_status := l_return_status;
297: EXCEPTION
298: WHEN G_EXCEPTION_ERROR THEN

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

295: x_msg_data => x_msg_data);
296: x_return_status := l_return_status;
297: EXCEPTION
298: WHEN G_EXCEPTION_ERROR THEN
299: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
300: p_pkg_name => G_PKG_NAME,
301: p_exc_name => G_EXC_NAME_ERROR,
302: x_msg_count => x_msg_count,
303: x_msg_data => x_msg_data,

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

302: x_msg_count => x_msg_count,
303: x_msg_data => x_msg_data,
304: p_api_type => G_API_TYPE);
305: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
306: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
307: p_pkg_name => G_PKG_NAME,
308: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
309: x_msg_count => x_msg_count,
310: x_msg_data => x_msg_data,

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

309: x_msg_count => x_msg_count,
310: x_msg_data => x_msg_data,
311: p_api_type => G_API_TYPE);
312: WHEN OTHERS THEN
313: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
314: p_pkg_name => G_PKG_NAME,
315: p_exc_name => G_EXC_NAME_OTHERS,
316: x_msg_count => x_msg_count,
317: x_msg_data => x_msg_data,