eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_CREATE_STREAMS_PUB dependencies on OKL_API

Line 39: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,

35: l_data VARCHAR2(100);
36: l_count NUMBER ;
37:
38: BEGIN
39: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,
40: p_pkg_name => G_PKG_NAME,
41: p_init_msg_list => p_init_msg_list,
42: l_api_version => l_api_version,
43: p_api_version => p_api_version,

Line 97: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,

93: END IF;
94:
95:
96:
97: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,
98: x_msg_data => x_msg_data);
99: x_return_status := l_return_status;
100: EXCEPTION
101: WHEN G_EXCEPTION_ERROR THEN

Line 102: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

98: x_msg_data => x_msg_data);
99: x_return_status := l_return_status;
100: EXCEPTION
101: WHEN G_EXCEPTION_ERROR THEN
102: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
103: p_pkg_name => G_PKG_NAME,
104: p_exc_name => G_EXC_NAME_ERROR,
105: x_msg_count => x_msg_count,
106: x_msg_data => x_msg_data,

Line 109: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

105: x_msg_count => x_msg_count,
106: x_msg_data => x_msg_data,
107: p_api_type => G_API_TYPE);
108: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
109: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
110: p_pkg_name => G_PKG_NAME,
111: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
112: x_msg_count => x_msg_count,
113: x_msg_data => x_msg_data,

Line 116: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

112: x_msg_count => x_msg_count,
113: x_msg_data => x_msg_data,
114: p_api_type => G_API_TYPE);
115: WHEN OTHERS THEN
116: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
117: p_pkg_name => G_PKG_NAME,
118: p_exc_name => G_EXC_NAME_OTHERS,
119: x_msg_count => x_msg_count,
120: x_msg_data => x_msg_data,

Line 152: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,

148: l_data VARCHAR2(100);
149: l_count NUMBER ;
150: l_api_version CONSTANT NUMBER := 1;
151: BEGIN
152: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,
153: p_pkg_name => G_PKG_NAME,
154: p_init_msg_list => p_init_msg_list,
155: l_api_version => l_api_version,
156: p_api_version => p_api_version,

Line 209: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,

205: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
206: END IF;
207:
208:
209: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,
210: x_msg_data => x_msg_data);
211: x_return_status := l_return_status;
212: EXCEPTION
213: WHEN G_EXCEPTION_ERROR THEN

Line 214: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

210: x_msg_data => x_msg_data);
211: x_return_status := l_return_status;
212: EXCEPTION
213: WHEN G_EXCEPTION_ERROR THEN
214: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
215: p_pkg_name => G_PKG_NAME,
216: p_exc_name => G_EXC_NAME_ERROR,
217: x_msg_count => x_msg_count,
218: x_msg_data => x_msg_data,

Line 221: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

217: x_msg_count => x_msg_count,
218: x_msg_data => x_msg_data,
219: p_api_type => G_API_TYPE);
220: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
221: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
222: p_pkg_name => G_PKG_NAME,
223: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
224: x_msg_count => x_msg_count,
225: x_msg_data => x_msg_data,

Line 228: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

224: x_msg_count => x_msg_count,
225: x_msg_data => x_msg_data,
226: p_api_type => G_API_TYPE);
227: WHEN OTHERS THEN
228: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
229: p_pkg_name => G_PKG_NAME,
230: p_exc_name => G_EXC_NAME_OTHERS,
231: x_msg_count => x_msg_count,
232: x_msg_data => x_msg_data,

Line 265: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,

261: l_data VARCHAR2(100);
262: l_count NUMBER ;
263:
264: BEGIN
265: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,
266: p_pkg_name => G_PKG_NAME,
267: p_init_msg_list => p_init_msg_list,
268: l_api_version => l_api_version,
269: p_api_version => p_api_version,

Line 321: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,

317: END IF;
318:
319:
320:
321: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,
322: x_msg_data => x_msg_data);
323: x_return_status := l_return_status;
324: EXCEPTION
325: WHEN G_EXCEPTION_ERROR THEN

Line 326: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

322: x_msg_data => x_msg_data);
323: x_return_status := l_return_status;
324: EXCEPTION
325: WHEN G_EXCEPTION_ERROR THEN
326: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
327: p_pkg_name => G_PKG_NAME,
328: p_exc_name => G_EXC_NAME_ERROR,
329: x_msg_count => x_msg_count,
330: x_msg_data => x_msg_data,

Line 333: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

329: x_msg_count => x_msg_count,
330: x_msg_data => x_msg_data,
331: p_api_type => G_API_TYPE);
332: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
333: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
334: p_pkg_name => G_PKG_NAME,
335: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
336: x_msg_count => x_msg_count,
337: x_msg_data => x_msg_data,

Line 340: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

336: x_msg_count => x_msg_count,
337: x_msg_data => x_msg_data,
338: p_api_type => G_API_TYPE);
339: WHEN OTHERS THEN
340: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
341: p_pkg_name => G_PKG_NAME,
342: p_exc_name => G_EXC_NAME_OTHERS,
343: x_msg_count => x_msg_count,
344: x_msg_data => x_msg_data,

Line 365: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,

361: l_data VARCHAR2(100);
362: l_count NUMBER ;
363:
364: BEGIN
365: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,
366: p_pkg_name => G_PKG_NAME,
367: p_init_msg_list => p_init_msg_list,
368: l_api_version => l_api_version,
369: p_api_version => p_api_version,

Line 414: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,

410: END IF;
411:
412:
413:
414: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,
415: x_msg_data => x_msg_data);
416: x_return_status := l_return_status;
417: EXCEPTION
418: WHEN G_EXCEPTION_ERROR THEN

Line 419: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

415: x_msg_data => x_msg_data);
416: x_return_status := l_return_status;
417: EXCEPTION
418: WHEN G_EXCEPTION_ERROR THEN
419: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
420: p_pkg_name => G_PKG_NAME,
421: p_exc_name => G_EXC_NAME_ERROR,
422: x_msg_count => x_msg_count,
423: x_msg_data => x_msg_data,

Line 426: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

422: x_msg_count => x_msg_count,
423: x_msg_data => x_msg_data,
424: p_api_type => G_API_TYPE);
425: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
426: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
427: p_pkg_name => G_PKG_NAME,
428: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
429: x_msg_count => x_msg_count,
430: x_msg_data => x_msg_data,

Line 433: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

429: x_msg_count => x_msg_count,
430: x_msg_data => x_msg_data,
431: p_api_type => G_API_TYPE);
432: WHEN OTHERS THEN
433: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
434: p_pkg_name => G_PKG_NAME,
435: p_exc_name => G_EXC_NAME_OTHERS,
436: x_msg_count => x_msg_count,
437: x_msg_data => x_msg_data,

Line 470: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,

466: l_data VARCHAR2(100);
467: l_count NUMBER ;
468:
469: BEGIN
470: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,
471: p_pkg_name => G_PKG_NAME,
472: p_init_msg_list => p_init_msg_list,
473: l_api_version => l_api_version,
474: p_api_version => p_api_version,

Line 528: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,

524: END IF;
525:
526:
527:
528: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,
529: x_msg_data => x_msg_data);
530: x_return_status := l_return_status;
531: EXCEPTION
532: WHEN G_EXCEPTION_ERROR THEN

Line 533: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

529: x_msg_data => x_msg_data);
530: x_return_status := l_return_status;
531: EXCEPTION
532: WHEN G_EXCEPTION_ERROR THEN
533: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
534: p_pkg_name => G_PKG_NAME,
535: p_exc_name => G_EXC_NAME_ERROR,
536: x_msg_count => x_msg_count,
537: x_msg_data => x_msg_data,

Line 540: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

536: x_msg_count => x_msg_count,
537: x_msg_data => x_msg_data,
538: p_api_type => G_API_TYPE);
539: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
540: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
541: p_pkg_name => G_PKG_NAME,
542: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
543: x_msg_count => x_msg_count,
544: x_msg_data => x_msg_data,

Line 547: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

543: x_msg_count => x_msg_count,
544: x_msg_data => x_msg_data,
545: p_api_type => G_API_TYPE);
546: WHEN OTHERS THEN
547: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
548: p_pkg_name => G_PKG_NAME,
549: p_exc_name => G_EXC_NAME_OTHERS,
550: x_msg_count => x_msg_count,
551: x_msg_data => x_msg_data,

Line 583: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,

579: l_data VARCHAR2(100);
580: l_count NUMBER ;
581: l_api_version CONSTANT NUMBER := 1;
582: BEGIN
583: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,
584: p_pkg_name => G_PKG_NAME,
585: p_init_msg_list => p_init_msg_list,
586: l_api_version => l_api_version,
587: p_api_version => p_api_version,

Line 640: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,

636: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
637: END IF;
638:
639:
640: Okl_Api.END_ACTIVITY(x_msg_count => x_msg_count,
641: x_msg_data => x_msg_data);
642: x_return_status := l_return_status;
643: EXCEPTION
644: WHEN G_EXCEPTION_ERROR THEN

Line 645: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

641: x_msg_data => x_msg_data);
642: x_return_status := l_return_status;
643: EXCEPTION
644: WHEN G_EXCEPTION_ERROR THEN
645: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
646: p_pkg_name => G_PKG_NAME,
647: p_exc_name => G_EXC_NAME_ERROR,
648: x_msg_count => x_msg_count,
649: x_msg_data => x_msg_data,

Line 652: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

648: x_msg_count => x_msg_count,
649: x_msg_data => x_msg_data,
650: p_api_type => G_API_TYPE);
651: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
652: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
653: p_pkg_name => G_PKG_NAME,
654: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
655: x_msg_count => x_msg_count,
656: x_msg_data => x_msg_data,

Line 659: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

655: x_msg_count => x_msg_count,
656: x_msg_data => x_msg_data,
657: p_api_type => G_API_TYPE);
658: WHEN OTHERS THEN
659: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
660: p_pkg_name => G_PKG_NAME,
661: p_exc_name => G_EXC_NAME_OTHERS,
662: x_msg_count => x_msg_count,
663: x_msg_data => x_msg_data,