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

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

222:
223: BEGIN
224:
225: x_retcode := 0;
226: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,
227: p_pkg_name => G_PKG_NAME,
228: p_init_msg_list => l_init_msg_list,
229: l_api_version => l_api_version,
230: p_api_version => p_api_version,

Line 235: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_UNEXPECTED_ERROR));

231: p_api_type => G_API_TYPE,
232: x_return_status => l_return_status);
233:
234: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
235: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_UNEXPECTED_ERROR));
236: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
237: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
238: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));
239: RAISE G_EXCEPTION_ERROR;

Line 238: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));

234: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
235: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_UNEXPECTED_ERROR));
236: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
237: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
238: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));
239: RAISE G_EXCEPTION_ERROR;
240: END IF;
241:
242: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_CONFIRM_PROCESS));

Line 242: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_CONFIRM_PROCESS));

238: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));
239: RAISE G_EXCEPTION_ERROR;
240: END IF;
241:
242: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_CONFIRM_PROCESS));
243: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
244:
245: -- Printing the values in the log file.
246:

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

460: ,p_khr_id => l_okl_dnz_chrs_rec.dnz_chr_id
461: ,p_cancel_date => lp_effective_date);
462:
463:
464: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
465: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'okl_accrual_sec_pvt.cancel_streams',G_UNEXPECTED_ERROR));
466: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
467: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
468: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'okl_accrual_sec_pvt.cancel_streams',G_EXPECTED_ERROR));

Line 466: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

462:
463:
464: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
465: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'okl_accrual_sec_pvt.cancel_streams',G_UNEXPECTED_ERROR));
466: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
467: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
468: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'okl_accrual_sec_pvt.cancel_streams',G_EXPECTED_ERROR));
469: RAISE OKL_API.G_EXCEPTION_ERROR;
470: END IF;

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

463:
464: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
465: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'okl_accrual_sec_pvt.cancel_streams',G_UNEXPECTED_ERROR));
466: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
467: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
468: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'okl_accrual_sec_pvt.cancel_streams',G_EXPECTED_ERROR));
469: RAISE OKL_API.G_EXCEPTION_ERROR;
470: END IF;
471: END LOOP; -- l_okl_dnz_chrs_csr

Line 469: RAISE OKL_API.G_EXCEPTION_ERROR;

465: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'okl_accrual_sec_pvt.cancel_streams',G_UNEXPECTED_ERROR));
466: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
467: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
468: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'okl_accrual_sec_pvt.cancel_streams',G_EXPECTED_ERROR));
469: RAISE OKL_API.G_EXCEPTION_ERROR;
470: END IF;
471: END LOOP; -- l_okl_dnz_chrs_csr
472:
473: END IF; -- l_total_rec_count

Line 486: OKL_API.END_ACTIVITY(l_msg_count, l_msg_data);

482: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD('=',LENGTH(l_content),'='));
483: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
484:
485:
486: OKL_API.END_ACTIVITY(l_msg_count, l_msg_data);
487: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.END_ACTIVITY',G_CONFIRM_PROCESS));
488:
489: -- "No Errors"
490: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_NONE);

Line 487: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.END_ACTIVITY',G_CONFIRM_PROCESS));

483: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' ');
484:
485:
486: OKL_API.END_ACTIVITY(l_msg_count, l_msg_data);
487: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.END_ACTIVITY',G_CONFIRM_PROCESS));
488:
489: -- "No Errors"
490: l_content := FND_MESSAGE.GET_STRING(G_APP_NAME,G_NONE);
491: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_filler || l_content);

Line 498: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

494:
495: EXCEPTION
496: WHEN G_EXCEPTION_ERROR THEN
497: x_retcode := 2;
498: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
499: p_pkg_name => G_PKG_NAME,
500: p_exc_name => G_EXC_NAME_ERROR,
501: x_msg_count => l_msg_count,
502: x_msg_data => l_msg_data,

Line 514: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

510: END LOOP;
511: END IF;
512: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
513: x_retcode := 2;
514: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
515: p_pkg_name => G_PKG_NAME,
516: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
517: x_msg_count => l_msg_count,
518: x_msg_data => l_msg_data,

Line 531: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

527: END IF;
528: WHEN OTHERS THEN
529: x_errbuf := SQLERRM;
530: x_retcode := 2;
531: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
532: p_pkg_name => G_PKG_NAME,
533: p_exc_name => G_EXC_NAME_OTHERS,
534: x_msg_count => l_msg_count,
535: x_msg_data => l_msg_data,

Line 563: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false

559: ----------------------------------------------------------------------------------
560:
561: PROCEDURE activate_agreement_ui(
562: p_api_version IN NUMBER
563: ,p_init_msg_list IN VARCHAR2 DEFAULT okl_api.g_false
564: ,x_return_status OUT nocopy VARCHAR2
565: ,x_msg_count OUT nocopy NUMBER
566: ,x_msg_data OUT nocopy VARCHAR2
567: ,x_request_id OUT nocopy NUMBER

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

576: BEGIN
577:
578: x_return_status := G_RET_STS_SUCCESS;
579:
580: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,
581: p_pkg_name => G_PKG_NAME,
582: p_init_msg_list => p_init_msg_list,
583: l_api_version => l_api_version,
584: p_api_version => p_api_version,

Line 605: OKL_API.set_message(p_app_name => G_APP_NAME,

601: );
602:
603: -- Added these validations to check to see if the request has been submitted successfully.
604: IF x_request_id = 0 THEN
605: OKL_API.set_message(p_app_name => G_APP_NAME,
606: p_msg_name => 'OKL_CONC_REQ_ERROR',
607: p_token1 => 'PROG_NAME',
608: p_token1_value => 'OKL Activate Investor Agreement',
609: p_token2 => 'REQUEST_ID',

Line 615: OKL_API.end_activity(x_msg_count, x_msg_data);

611:
612: RAISE G_EXCEPTION_ERROR;
613: END IF;
614:
615: OKL_API.end_activity(x_msg_count, x_msg_data);
616:
617: EXCEPTION
618: WHEN G_EXCEPTION_ERROR THEN
619:

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

616:
617: EXCEPTION
618: WHEN G_EXCEPTION_ERROR THEN
619:
620: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
621: p_pkg_name => G_PKG_NAME,
622: p_exc_name => G_EXC_NAME_ERROR,
623: x_msg_count => x_msg_count,
624: x_msg_data => x_msg_data,

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

624: x_msg_data => x_msg_data,
625: p_api_type => G_API_TYPE);
626: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
627:
628: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
629: p_pkg_name => G_PKG_NAME,
630: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
631: x_msg_count => x_msg_count,
632: x_msg_data => x_msg_data,

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

632: x_msg_data => x_msg_data,
633: p_api_type => G_API_TYPE);
634: WHEN OTHERS THEN
635:
636: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
637: p_pkg_name => G_PKG_NAME,
638: p_exc_name => G_EXC_NAME_OTHERS,
639: x_msg_count => x_msg_count,
640: x_msg_data => x_msg_data,

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

685:
686: BEGIN
687:
688: x_retcode := 0;
689: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,
690: p_pkg_name => G_PKG_NAME,
691: p_init_msg_list => l_init_msg_list,
692: l_api_version => l_api_version,
693: p_api_version => p_api_version,

Line 699: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_UNEXPECTED_ERROR));

695: x_return_status => l_return_status);
696:
697:
698: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
699: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_UNEXPECTED_ERROR));
700: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
701: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
702: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));
703: RAISE G_EXCEPTION_ERROR;

Line 702: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));

698: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
699: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_UNEXPECTED_ERROR));
700: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
701: ELSIF (l_return_Status = G_RET_STS_ERROR) THEN
702: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));
703: RAISE G_EXCEPTION_ERROR;
704: END IF;
705:
706: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_CONFIRM_PROCESS));

Line 706: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_CONFIRM_PROCESS));

702: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_EXPECTED_ERROR));
703: RAISE G_EXCEPTION_ERROR;
704: END IF;
705:
706: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.START_ACTIVITY',G_CONFIRM_PROCESS));
707: FND_FILE.PUT_LINE(FND_FILE.LOG, ' ');
708:
709: -- Printing the values in the log file.
710:

Line 765: Okl_Api.END_ACTIVITY(l_msg_count, l_msg_data);

761: END IF;
762: --Bug 6691554 - End of Changes
763: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_END));
764:
765: Okl_Api.END_ACTIVITY(l_msg_count, l_msg_data);
766: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.END_ACTIVITY',G_CONFIRM_PROCESS));
767:
768: x_retcode := 0;
769:

Line 766: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.END_ACTIVITY',G_CONFIRM_PROCESS));

762: --Bug 6691554 - End of Changes
763: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'',G_PROCESS_END));
764:
765: Okl_Api.END_ACTIVITY(l_msg_count, l_msg_data);
766: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message(l_api_name,'OKL_API.END_ACTIVITY',G_CONFIRM_PROCESS));
767:
768: x_retcode := 0;
769:
770: EXCEPTION

Line 774: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

770: EXCEPTION
771: WHEN G_EXCEPTION_ERROR THEN
772: x_retcode := 2;
773:
774: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
775: p_pkg_name => G_PKG_NAME,
776: p_exc_name => G_EXC_NAME_ERROR,
777: x_msg_count => l_msg_count,
778: x_msg_data => l_msg_data,

Line 794: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

790:
791: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
792: x_retcode := 2;
793:
794: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
795: p_pkg_name => G_PKG_NAME,
796: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
797: x_msg_count => l_msg_count,
798: x_msg_data => l_msg_data,

Line 813: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

809: WHEN OTHERS THEN
810: x_errbuf := SQLERRM;
811: x_retcode := 2;
812:
813: l_return_status := Okl_Api.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
814: p_pkg_name => G_PKG_NAME,
815: p_exc_name => G_EXC_NAME_OTHERS,
816: x_msg_count => l_msg_count,
817: x_msg_data => l_msg_data,