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_PROCESS_TRX_TYPES_PVT dependencies on OKL_API

Line 6: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

2: /* $Header: OKLRTXTB.pls 115.3 2002/11/01 23:16:01 santonyr noship $ */
3:
4: -- Added by Santonyr 09-19-2002
5:
6: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
7: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
8: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
9: G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
10: G_EXCEPTION_ERROR EXCEPTION;

Line 7: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;

3:
4: -- Added by Santonyr 09-19-2002
5:
6: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
7: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
8: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
9: G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
10: G_EXCEPTION_ERROR EXCEPTION;
11:

Line 8: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;

4: -- Added by Santonyr 09-19-2002
5:
6: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
7: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
8: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
9: G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
10: G_EXCEPTION_ERROR EXCEPTION;
11:
12:

Line 30: x_return_status := OKL_API.G_RET_STS_SUCCESS;

26: l_api_name VARCHAR2(30) := 'INSERT_TRX_TYPES';
27:
28: BEGIN
29:
30: x_return_status := OKL_API.G_RET_STS_SUCCESS;
31:
32: -- Set save point
33:
34: l_return_status := Okl_Api.START_ACTIVITY(l_api_name

Line 34: l_return_status := Okl_Api.START_ACTIVITY(l_api_name

30: x_return_status := OKL_API.G_RET_STS_SUCCESS;
31:
32: -- Set save point
33:
34: l_return_status := Okl_Api.START_ACTIVITY(l_api_name
35: ,G_PKG_NAME
36: ,p_init_msg_list
37: ,l_api_version
38: ,p_api_version

Line 73: Okl_Api.end_activity(x_msg_count, x_msg_data);

69: RAISE G_EXCEPTION_ERROR;
70: END IF;
71:
72: x_return_status := l_return_status;
73: Okl_Api.end_activity(x_msg_count, x_msg_data);
74:
75:
76: EXCEPTION
77: WHEN G_EXCEPTION_ERROR THEN

Line 78: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

74:
75:
76: EXCEPTION
77: WHEN G_EXCEPTION_ERROR THEN
78: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
79: ,g_pkg_name
80: ,'OKL_API.G_RET_STS_ERROR'
81: ,x_msg_count
82: ,x_msg_data

Line 80: ,'OKL_API.G_RET_STS_ERROR'

76: EXCEPTION
77: WHEN G_EXCEPTION_ERROR THEN
78: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
79: ,g_pkg_name
80: ,'OKL_API.G_RET_STS_ERROR'
81: ,x_msg_count
82: ,x_msg_data
83: ,'_PVT');
84: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 85: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

81: ,x_msg_count
82: ,x_msg_data
83: ,'_PVT');
84: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
85: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
86: ,g_pkg_name
87: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
88: ,x_msg_count
89: ,x_msg_data

Line 87: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

83: ,'_PVT');
84: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
85: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
86: ,g_pkg_name
87: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
88: ,x_msg_count
89: ,x_msg_data
90: ,'_PVT');
91: WHEN OTHERS THEN

Line 92: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

88: ,x_msg_count
89: ,x_msg_data
90: ,'_PVT');
91: WHEN OTHERS THEN
92: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
93: ,g_pkg_name
94: ,'OTHERS'
95: ,x_msg_count
96: ,x_msg_data

Line 120: x_return_status := OKL_API.G_RET_STS_SUCCESS;

116: i NUMBER;
117:
118: BEGIN
119:
120: x_return_status := OKL_API.G_RET_STS_SUCCESS;
121:
122: -- Set save point
123: l_return_status := Okl_Api.START_ACTIVITY(l_api_name
124: ,G_PKG_NAME

Line 123: l_return_status := Okl_Api.START_ACTIVITY(l_api_name

119:
120: x_return_status := OKL_API.G_RET_STS_SUCCESS;
121:
122: -- Set save point
123: l_return_status := Okl_Api.START_ACTIVITY(l_api_name
124: ,G_PKG_NAME
125: ,p_init_msg_list
126: ,l_api_version
127: ,p_api_version

Line 171: Okl_Api.end_activity(x_msg_count, x_msg_data);

167: RAISE G_EXCEPTION_ERROR;
168: END IF;
169:
170: x_return_status := l_return_status;
171: Okl_Api.end_activity(x_msg_count, x_msg_data);
172:
173: EXCEPTION
174: WHEN G_EXCEPTION_ERROR THEN
175: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

Line 175: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

171: Okl_Api.end_activity(x_msg_count, x_msg_data);
172:
173: EXCEPTION
174: WHEN G_EXCEPTION_ERROR THEN
175: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
176: ,g_pkg_name
177: ,'OKL_API.G_RET_STS_ERROR'
178: ,x_msg_count
179: ,x_msg_data

Line 177: ,'OKL_API.G_RET_STS_ERROR'

173: EXCEPTION
174: WHEN G_EXCEPTION_ERROR THEN
175: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
176: ,g_pkg_name
177: ,'OKL_API.G_RET_STS_ERROR'
178: ,x_msg_count
179: ,x_msg_data
180: ,'_PVT');
181: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 182: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

178: ,x_msg_count
179: ,x_msg_data
180: ,'_PVT');
181: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
182: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
183: ,g_pkg_name
184: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
185: ,x_msg_count
186: ,x_msg_data

Line 184: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

180: ,'_PVT');
181: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
182: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
183: ,g_pkg_name
184: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
185: ,x_msg_count
186: ,x_msg_data
187: ,'_PVT');
188: WHEN OTHERS THEN

Line 189: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

185: ,x_msg_count
186: ,x_msg_data
187: ,'_PVT');
188: WHEN OTHERS THEN
189: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
190: ,g_pkg_name
191: ,'OTHERS'
192: ,x_msg_count
193: ,x_msg_data

Line 252: x_return_status := OKL_API.G_RET_STS_SUCCESS;

248:
249:
250: BEGIN
251:
252: x_return_status := OKL_API.G_RET_STS_SUCCESS;
253:
254: -- Set save point
255: l_return_status := Okl_Api.START_ACTIVITY(l_api_name
256: ,G_PKG_NAME

Line 255: l_return_status := Okl_Api.START_ACTIVITY(l_api_name

251:
252: x_return_status := OKL_API.G_RET_STS_SUCCESS;
253:
254: -- Set save point
255: l_return_status := Okl_Api.START_ACTIVITY(l_api_name
256: ,G_PKG_NAME
257: ,p_init_msg_list
258: ,l_api_version
259: ,p_api_version

Line 307: Okl_Api.end_activity(x_msg_count, x_msg_data);

303: END IF;
304:
305:
306: x_return_status := l_return_status;
307: Okl_Api.end_activity(x_msg_count, x_msg_data);
308:
309:
310: EXCEPTION
311: WHEN G_EXCEPTION_ERROR THEN

Line 312: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

308:
309:
310: EXCEPTION
311: WHEN G_EXCEPTION_ERROR THEN
312: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
313: ,g_pkg_name
314: ,'OKL_API.G_RET_STS_ERROR'
315: ,x_msg_count
316: ,x_msg_data

Line 314: ,'OKL_API.G_RET_STS_ERROR'

310: EXCEPTION
311: WHEN G_EXCEPTION_ERROR THEN
312: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
313: ,g_pkg_name
314: ,'OKL_API.G_RET_STS_ERROR'
315: ,x_msg_count
316: ,x_msg_data
317: ,'_PVT');
318: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 319: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

315: ,x_msg_count
316: ,x_msg_data
317: ,'_PVT');
318: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
319: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
320: ,g_pkg_name
321: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
322: ,x_msg_count
323: ,x_msg_data

Line 321: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

317: ,'_PVT');
318: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
319: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
320: ,g_pkg_name
321: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
322: ,x_msg_count
323: ,x_msg_data
324: ,'_PVT');
325: WHEN OTHERS THEN

Line 326: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

322: ,x_msg_count
323: ,x_msg_data
324: ,'_PVT');
325: WHEN OTHERS THEN
326: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
327: ,g_pkg_name
328: ,'OTHERS'
329: ,x_msg_count
330: ,x_msg_data

Line 355: x_return_status := OKL_API.G_RET_STS_SUCCESS;

351: l_api_name VARCHAR2(30) := 'UPDATE_TRX_TYPES';
352: i NUMBER;
353:
354: BEGIN
355: x_return_status := OKL_API.G_RET_STS_SUCCESS;
356:
357: -- Set save point
358: l_return_status := Okl_Api.START_ACTIVITY(l_api_name
359: ,G_PKG_NAME

Line 358: l_return_status := Okl_Api.START_ACTIVITY(l_api_name

354: BEGIN
355: x_return_status := OKL_API.G_RET_STS_SUCCESS;
356:
357: -- Set save point
358: l_return_status := Okl_Api.START_ACTIVITY(l_api_name
359: ,G_PKG_NAME
360: ,p_init_msg_list
361: ,l_api_version
362: ,p_api_version

Line 418: Okl_Api.end_activity(x_msg_count, x_msg_data);

414: END IF;
415:
416:
417: x_return_status := l_return_status;
418: Okl_Api.end_activity(x_msg_count, x_msg_data);
419:
420:
421: EXCEPTION
422: WHEN G_EXCEPTION_ERROR THEN

Line 423: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

419:
420:
421: EXCEPTION
422: WHEN G_EXCEPTION_ERROR THEN
423: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
424: ,g_pkg_name
425: ,'OKL_API.G_RET_STS_ERROR'
426: ,x_msg_count
427: ,x_msg_data

Line 425: ,'OKL_API.G_RET_STS_ERROR'

421: EXCEPTION
422: WHEN G_EXCEPTION_ERROR THEN
423: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
424: ,g_pkg_name
425: ,'OKL_API.G_RET_STS_ERROR'
426: ,x_msg_count
427: ,x_msg_data
428: ,'_PVT');
429: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 430: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

426: ,x_msg_count
427: ,x_msg_data
428: ,'_PVT');
429: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
430: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
431: ,g_pkg_name
432: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
433: ,x_msg_count
434: ,x_msg_data

Line 432: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

428: ,'_PVT');
429: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
430: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
431: ,g_pkg_name
432: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
433: ,x_msg_count
434: ,x_msg_data
435: ,'_PVT');
436: WHEN OTHERS THEN

Line 437: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

433: ,x_msg_count
434: ,x_msg_data
435: ,'_PVT');
436: WHEN OTHERS THEN
437: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
438: ,g_pkg_name
439: ,'OTHERS'
440: ,x_msg_count
441: ,x_msg_data

Line 463: x_return_status := OKL_API.G_RET_STS_SUCCESS;

459: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
460:
461: BEGIN
462:
463: x_return_status := OKL_API.G_RET_STS_SUCCESS;
464:
465: -- Set save point
466: l_return_status := Okl_Api.START_ACTIVITY(l_api_name
467: ,G_PKG_NAME

Line 466: l_return_status := Okl_Api.START_ACTIVITY(l_api_name

462:
463: x_return_status := OKL_API.G_RET_STS_SUCCESS;
464:
465: -- Set save point
466: l_return_status := Okl_Api.START_ACTIVITY(l_api_name
467: ,G_PKG_NAME
468: ,p_init_msg_list
469: ,l_api_version
470: ,p_api_version

Line 495: Okl_Api.end_activity(x_msg_count, x_msg_data);

491: RAISE G_EXCEPTION_ERROR;
492: END IF;
493:
494: x_return_status := l_return_status;
495: Okl_Api.end_activity(x_msg_count, x_msg_data);
496:
497: EXCEPTION
498: WHEN G_EXCEPTION_ERROR THEN
499: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

Line 499: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

495: Okl_Api.end_activity(x_msg_count, x_msg_data);
496:
497: EXCEPTION
498: WHEN G_EXCEPTION_ERROR THEN
499: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
500: ,g_pkg_name
501: ,'OKL_API.G_RET_STS_ERROR'
502: ,x_msg_count
503: ,x_msg_data

Line 501: ,'OKL_API.G_RET_STS_ERROR'

497: EXCEPTION
498: WHEN G_EXCEPTION_ERROR THEN
499: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
500: ,g_pkg_name
501: ,'OKL_API.G_RET_STS_ERROR'
502: ,x_msg_count
503: ,x_msg_data
504: ,'_PVT');
505: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 506: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

502: ,x_msg_count
503: ,x_msg_data
504: ,'_PVT');
505: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
506: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
507: ,g_pkg_name
508: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
509: ,x_msg_count
510: ,x_msg_data

Line 508: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

504: ,'_PVT');
505: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
506: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
507: ,g_pkg_name
508: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
509: ,x_msg_count
510: ,x_msg_data
511: ,'_PVT');
512: WHEN OTHERS THEN

Line 513: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

509: ,x_msg_count
510: ,x_msg_data
511: ,'_PVT');
512: WHEN OTHERS THEN
513: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
514: ,g_pkg_name
515: ,'OTHERS'
516: ,x_msg_count
517: ,x_msg_data

Line 541: x_return_status := OKL_API.G_RET_STS_SUCCESS;

537: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
538:
539: BEGIN
540:
541: x_return_status := OKL_API.G_RET_STS_SUCCESS;
542:
543: -- Set save point
544: l_return_status := Okl_Api.START_ACTIVITY(l_api_name
545: ,G_PKG_NAME

Line 544: l_return_status := Okl_Api.START_ACTIVITY(l_api_name

540:
541: x_return_status := OKL_API.G_RET_STS_SUCCESS;
542:
543: -- Set save point
544: l_return_status := Okl_Api.START_ACTIVITY(l_api_name
545: ,G_PKG_NAME
546: ,p_init_msg_list
547: ,l_api_version
548: ,p_api_version

Line 573: Okl_Api.end_activity(x_msg_count, x_msg_data);

569: RAISE G_EXCEPTION_ERROR;
570: END IF;
571:
572: x_return_status := l_return_status;
573: Okl_Api.end_activity(x_msg_count, x_msg_data);
574:
575:
576: EXCEPTION
577: WHEN G_EXCEPTION_ERROR THEN

Line 578: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

574:
575:
576: EXCEPTION
577: WHEN G_EXCEPTION_ERROR THEN
578: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
579: ,g_pkg_name
580: ,'OKL_API.G_RET_STS_ERROR'
581: ,x_msg_count
582: ,x_msg_data

Line 580: ,'OKL_API.G_RET_STS_ERROR'

576: EXCEPTION
577: WHEN G_EXCEPTION_ERROR THEN
578: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
579: ,g_pkg_name
580: ,'OKL_API.G_RET_STS_ERROR'
581: ,x_msg_count
582: ,x_msg_data
583: ,'_PVT');
584: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 585: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

581: ,x_msg_count
582: ,x_msg_data
583: ,'_PVT');
584: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
585: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
586: ,g_pkg_name
587: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
588: ,x_msg_count
589: ,x_msg_data

Line 587: ,'OKL_API.G_RET_STS_UNEXP_ERROR'

583: ,'_PVT');
584: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
585: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
586: ,g_pkg_name
587: ,'OKL_API.G_RET_STS_UNEXP_ERROR'
588: ,x_msg_count
589: ,x_msg_data
590: ,'_PVT');
591: WHEN OTHERS THEN

Line 592: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name

588: ,x_msg_count
589: ,x_msg_data
590: ,'_PVT');
591: WHEN OTHERS THEN
592: x_return_status := OKL_API.HANDLE_EXCEPTIONS(l_api_name
593: ,g_pkg_name
594: ,'OTHERS'
595: ,x_msg_count
596: ,x_msg_data