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

Line 101: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

97: -- Added by HKPATEL for default date for bug 3254298
98: l_date_transaction_occurred := OKL_ACCOUNTING_UTIL.get_valid_gl_date(l_date_transaction_occurred);
99:
100: IF l_date_transaction_occurred IS NULL THEN
101: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
102: p_msg_name => 'OKL_INVALID_GL_DATE');
103: RAISE OKL_API.G_EXCEPTION_ERROR;
104:
105: END IF;

Line 103: RAISE OKL_API.G_EXCEPTION_ERROR;

99:
100: IF l_date_transaction_occurred IS NULL THEN
101: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
102: p_msg_name => 'OKL_INVALID_GL_DATE');
103: RAISE OKL_API.G_EXCEPTION_ERROR;
104:
105: END IF;
106: -- Added code ends here
107:

Line 217: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;

213: l_dist_tbl TABV_TBL_TYPE;
214: l_aetv_rec OKL_ACCT_EVENT_PUB.AETV_REC_TYPE;
215: i NUMBER := 0;
216: l_api_version NUMBER := 1.0;
217: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
218: l_msg_count NUMBER := 0;
219: l_msg_data VARCHAR2(2000);
220: l_id NUMBER;
221: l_aet_id NUMBER;

Line 225: x_return_status := OKL_API.G_RET_STS_SUCCESS;

221: l_aet_id NUMBER;
222:
223: BEGIN
224:
225: x_return_status := OKL_API.G_RET_STS_SUCCESS;
226:
227: IF (p_flag = 'DIST') THEN
228:
229: OPEN dist_csr(p_source_id, p_source_table);

Line 323: x_return_status := OKL_API.G_RET_STS_SUCCESS;

319: WHERE ID = v_source_id;
320:
321: BEGIN
322:
323: x_return_status := OKL_API.G_RET_STS_SUCCESS;
324:
325: FOR i IN 1..p_tabv_tbl.COUNT
326: LOOP
327: IF (p_tabv_tbl(i).CR_DR_FLAG = 'C') THEN

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

376: l_total_dr_amount NUMBER := 0;
377: l_total_acc_dr_amount NUMBER := 0;
378: l_tabv_rec_out TABV_REC_TYPE;
379: l_tabv_rec TABV_REC_TYPE;
380: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
381: l_check_status NUMBER;
382: l_source_table OKL_TRNS_ACC_DSTRS.source_table%TYPE := 'OKL_TXL_CNTRCT_LNS';
383:
384: -- Added by Santonyr to fix the bug 3089327 on 07th Aug, 2003

Line 402: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

398:
399:
400: BEGIN
401:
402: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
403: G_PKG_NAME,
404: p_init_msg_list,
405: l_api_version,
406: p_api_version,

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

405: l_api_version,
406: p_api_version,
407: '_PVT',
408: x_return_status);
409: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
410: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
411: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
412: RAISE OKL_API.G_EXCEPTION_ERROR;
413: END IF;

Line 410: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

406: p_api_version,
407: '_PVT',
408: x_return_status);
409: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
410: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
411: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
412: RAISE OKL_API.G_EXCEPTION_ERROR;
413: END IF;
414:

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

407: '_PVT',
408: x_return_status);
409: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
410: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
411: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
412: RAISE OKL_API.G_EXCEPTION_ERROR;
413: END IF;
414:
415: -- Added by Santonyr to fix the bug 3089327 on 07th Aug, 2003

Line 412: RAISE OKL_API.G_EXCEPTION_ERROR;

408: x_return_status);
409: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
410: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
411: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
412: RAISE OKL_API.G_EXCEPTION_ERROR;
413: END IF;
414:
415: -- Added by Santonyr to fix the bug 3089327 on 07th Aug, 2003
416:

Line 427: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

423: CLOSE tcn_csr;
424:
425: IF (l_tsu_code = 'CANCELED') THEN
426:
427: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
428: p_msg_name => 'OKL_TRX_CANCELED');
429:
430: RAISE OKL_API.G_EXCEPTION_ERROR;
431:

Line 430: RAISE OKL_API.G_EXCEPTION_ERROR;

426:
427: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
428: p_msg_name => 'OKL_TRX_CANCELED');
429:
430: RAISE OKL_API.G_EXCEPTION_ERROR;
431:
432: END IF;
433:
434:

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

436:
437: validate_line_amount(p_tabv_tbl => p_tabv_tbl,
438: x_return_status => l_return_status);
439:
440: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
441: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
442: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
443: RAISE OKL_API.G_EXCEPTION_ERROR;
444: END IF;

Line 441: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

437: validate_line_amount(p_tabv_tbl => p_tabv_tbl,
438: x_return_status => l_return_status);
439:
440: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
441: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
442: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
443: RAISE OKL_API.G_EXCEPTION_ERROR;
444: END IF;
445:

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

438: x_return_status => l_return_status);
439:
440: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
441: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
442: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
443: RAISE OKL_API.G_EXCEPTION_ERROR;
444: END IF;
445:
446: --Validation to check if the transactions have been transferred to GL.If so they cannot be updated

Line 443: RAISE OKL_API.G_EXCEPTION_ERROR;

439:
440: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
441: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
442: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
443: RAISE OKL_API.G_EXCEPTION_ERROR;
444: END IF;
445:
446: --Validation to check if the transactions have been transferred to GL.If so they cannot be updated
447:

Line 469: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

465: p_source_id => p_tabv_tbl(1).source_id,
466: p_source_table => l_source_table,
467: x_return_status => l_return_status);
468:
469: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
470: RAISE OKL_API.G_EXCEPTION_ERROR;
471: END IF;
472:
473: END IF;

Line 470: RAISE OKL_API.G_EXCEPTION_ERROR;

466: p_source_table => l_source_table,
467: x_return_status => l_return_status);
468:
469: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
470: RAISE OKL_API.G_EXCEPTION_ERROR;
471: END IF;
472:
473: END IF;
474:

Line 477: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

473: END IF;
474:
475:
476: IF (l_check_status = 3) THEN
477: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
478: p_msg_name => 'OKL_AE_GONE_TO_GL');
479: RAISE OKL_API.G_EXCEPTION_ERROR;
480: END IF;
481:

Line 479: RAISE OKL_API.G_EXCEPTION_ERROR;

475:
476: IF (l_check_status = 3) THEN
477: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
478: p_msg_name => 'OKL_AE_GONE_TO_GL');
479: RAISE OKL_API.G_EXCEPTION_ERROR;
480: END IF;
481:
482:
483:

Line 499: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

495: x_msg_data => x_msg_data,
496: p_tabv_rec => l_tabv_rec_out,
497: x_tabv_rec => x_tabv_tbl(i) );
498:
499: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
500: RAISE OKL_API.G_EXCEPTION_ERROR;
501: END IF;
502:
503: END LOOP;

Line 500: RAISE OKL_API.G_EXCEPTION_ERROR;

496: p_tabv_rec => l_tabv_rec_out,
497: x_tabv_rec => x_tabv_tbl(i) );
498:
499: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
500: RAISE OKL_API.G_EXCEPTION_ERROR;
501: END IF;
502:
503: END LOOP;
504:

Line 506: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

502:
503: END LOOP;
504:
505:
506: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
507:
508: x_return_status := l_return_status;
509:
510: EXCEPTION

Line 511: WHEN OKL_API.G_EXCEPTION_ERROR THEN

507:
508: x_return_status := l_return_status;
509:
510: EXCEPTION
511: WHEN OKL_API.G_EXCEPTION_ERROR THEN
512: x_return_status := OKL_API.HANDLE_EXCEPTIONS
513: (
514: l_api_name,
515: G_PKG_NAME,

Line 512: x_return_status := OKL_API.HANDLE_EXCEPTIONS

508: x_return_status := l_return_status;
509:
510: EXCEPTION
511: WHEN OKL_API.G_EXCEPTION_ERROR THEN
512: x_return_status := OKL_API.HANDLE_EXCEPTIONS
513: (
514: l_api_name,
515: G_PKG_NAME,
516: 'OKL_API.G_RET_STS_ERROR',

Line 516: 'OKL_API.G_RET_STS_ERROR',

512: x_return_status := OKL_API.HANDLE_EXCEPTIONS
513: (
514: l_api_name,
515: G_PKG_NAME,
516: 'OKL_API.G_RET_STS_ERROR',
517: x_msg_count,
518: x_msg_data,
519: '_PVT'
520: );

Line 521: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

517: x_msg_count,
518: x_msg_data,
519: '_PVT'
520: );
521: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
522: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
523: (
524: l_api_name,
525: G_PKG_NAME,

Line 522: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

518: x_msg_data,
519: '_PVT'
520: );
521: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
522: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
523: (
524: l_api_name,
525: G_PKG_NAME,
526: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 526: 'OKL_API.G_RET_STS_UNEXP_ERROR',

522: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
523: (
524: l_api_name,
525: G_PKG_NAME,
526: 'OKL_API.G_RET_STS_UNEXP_ERROR',
527: x_msg_count,
528: x_msg_data,
529: '_PVT'
530: );

Line 532: x_return_status :=OKL_API.HANDLE_EXCEPTIONS

528: x_msg_data,
529: '_PVT'
530: );
531: WHEN OTHERS THEN
532: x_return_status :=OKL_API.HANDLE_EXCEPTIONS
533: (
534: l_api_name,
535: G_PKG_NAME,
536: 'OTHERS',