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

Line 36: l_init_msg_list VARCHAR2(3) := okl_api.g_true;

32: IS
33: l_api_name CONSTANT VARCHAR2(40):= 'OKL_STREAMS_RECON_REPORT';
34: l_api_version CONSTANT NUMBER := 1.0;
35: p_api_version CONSTANT NUMBER := 1.0;
36: l_init_msg_list VARCHAR2(3) := okl_api.g_true;
37: l_msg_count NUMBER;
38: l_msg_data VARCHAR2(2000);
39: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
40: lp_end_date VARCHAR2(200);

Line 39: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;

35: p_api_version CONSTANT NUMBER := 1.0;
36: l_init_msg_list VARCHAR2(3) := okl_api.g_true;
37: l_msg_count NUMBER;
38: l_msg_data VARCHAR2(2000);
39: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
40: lp_end_date VARCHAR2(200);
41: lp_contract_number VARCHAR2(200);
42: ln_org_id okc_k_headers_b.authoring_org_id%TYPE := 0;
43: lv_org_name mtl_organizations.organization_name%TYPE := NULL;

Line 523: x_return_status := OKL_API.G_RET_STS_SUCCESS;

519: GROUP BY khr.contract_number,
520: khr.currency_code
521: ORDER BY 1 DESC;
522: BEGIN
523: x_return_status := OKL_API.G_RET_STS_SUCCESS;
524: -- Call start_activity to create savepoint, check compatibility
525: -- and initialize message list
526: p_retcode := 0;
527: x_return_status := okl_api.start_activity(

Line 527: x_return_status := okl_api.start_activity(

523: x_return_status := OKL_API.G_RET_STS_SUCCESS;
524: -- Call start_activity to create savepoint, check compatibility
525: -- and initialize message list
526: p_retcode := 0;
527: x_return_status := okl_api.start_activity(
528: l_api_name,
529: G_PKG_NAME,
530: l_init_msg_list,
531: l_api_version,

Line 535: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN

531: l_api_version,
532: p_api_version,
533: '_PVT',
534: x_return_status);
535: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
536: fnd_file.put_line(fnd_file.log,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_ERROR_ACTIVITY'),1,30));
537: RAISE okl_api.g_exception_unexpected_error;
538: ELSIF (x_return_Status = okl_api.g_ret_sts_error) THEN
539: fnd_file.put_line(fnd_file.log,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_ERROR_ACTIVITY'),1,30));

Line 537: RAISE okl_api.g_exception_unexpected_error;

533: '_PVT',
534: x_return_status);
535: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
536: fnd_file.put_line(fnd_file.log,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_ERROR_ACTIVITY'),1,30));
537: RAISE okl_api.g_exception_unexpected_error;
538: ELSIF (x_return_Status = okl_api.g_ret_sts_error) THEN
539: fnd_file.put_line(fnd_file.log,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_ERROR_ACTIVITY'),1,30));
540: RAISE okl_api.g_exception_error;
541: END IF;

Line 538: ELSIF (x_return_Status = okl_api.g_ret_sts_error) THEN

534: x_return_status);
535: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
536: fnd_file.put_line(fnd_file.log,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_ERROR_ACTIVITY'),1,30));
537: RAISE okl_api.g_exception_unexpected_error;
538: ELSIF (x_return_Status = okl_api.g_ret_sts_error) THEN
539: fnd_file.put_line(fnd_file.log,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_ERROR_ACTIVITY'),1,30));
540: RAISE okl_api.g_exception_error;
541: END IF;
542: fnd_file.put_line(fnd_file.log,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_START_ACTIVITY'),1,34));

Line 540: RAISE okl_api.g_exception_error;

536: fnd_file.put_line(fnd_file.log,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_ERROR_ACTIVITY'),1,30));
537: RAISE okl_api.g_exception_unexpected_error;
538: ELSIF (x_return_Status = okl_api.g_ret_sts_error) THEN
539: fnd_file.put_line(fnd_file.log,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_ERROR_ACTIVITY'),1,30));
540: RAISE okl_api.g_exception_error;
541: END IF;
542: fnd_file.put_line(fnd_file.log,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_START_ACTIVITY'),1,34));
543: fnd_file.put_line(fnd_file.log,delimit);
544: -- we need to convert the date from varchar2 to date format

Line 555: raise okl_api.g_exception_error;

551: FETCH get_org_id INTO lv_org_name,
552: ln_org_id;
553: IF get_org_id%NOTFOUND THEN
554: fnd_file.put_line(fnd_file.log,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_ERROR_ORG'),1,36));
555: raise okl_api.g_exception_error;
556: END IF;
557: CLOSE get_org_id;
558: -- Filling in the header section of the report file
559: fnd_file.put_line(fnd_file.log, SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_GEN_SUM'),1,52));

Line 885: okl_api.end_activity(l_msg_count, l_msg_data);

881: END IF;
882: fnd_file.put_line(fnd_file.output,delimit);
883: fnd_file.put_line(fnd_file.output,delimit);
884: fnd_file.put_line(fnd_file.output,'Copyright (c) 1979, Oracle Corporation. All rights reserved.');
885: okl_api.end_activity(l_msg_count, l_msg_data);
886: fnd_file.put_line(fnd_file.log,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_END_ACTIVITY'),1,32));
887: p_retcode := 0;
888: EXCEPTION
889: WHEN okl_api.g_exception_error THEN

Line 889: WHEN okl_api.g_exception_error THEN

885: okl_api.end_activity(l_msg_count, l_msg_data);
886: fnd_file.put_line(fnd_file.log,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_END_ACTIVITY'),1,32));
887: p_retcode := 0;
888: EXCEPTION
889: WHEN okl_api.g_exception_error THEN
890: p_retcode := 2;
891: IF get_org_id%ISOPEN THEN
892: CLOSE get_org_id;
893: END IF;

Line 915: x_return_status := okl_api.handle_exceptions(

911: END IF;
912: IF get_diff_csr%ISOPEN THEN
913: CLOSE get_diff_csr;
914: END IF;
915: x_return_status := okl_api.handle_exceptions(
916: l_api_name,
917: g_pkg_name,
918: 'okl_api.g_ret_sts_error',
919: l_msg_count,

Line 918: 'okl_api.g_ret_sts_error',

914: END IF;
915: x_return_status := okl_api.handle_exceptions(
916: l_api_name,
917: g_pkg_name,
918: 'okl_api.g_ret_sts_error',
919: l_msg_count,
920: l_msg_data,
921: '_PVT');
922: -- print the error message in the log file

Line 929: WHEN okl_api.g_exception_unexpected_error THEN

925: FOR i IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST LOOP
926: fnd_file.put_line(fnd_file.output, l_error_msg_rec(i));
927: END LOOP;
928: END IF;
929: WHEN okl_api.g_exception_unexpected_error THEN
930: IF get_org_id%ISOPEN THEN
931: CLOSE get_org_id;
932: END IF;
933: IF get_currency_code%ISOPEN THEN

Line 955: x_return_status := okl_api.handle_exceptions(

951:
952: IF get_diff_csr%ISOPEN THEN
953: CLOSE get_diff_csr;
954: END IF;
955: x_return_status := okl_api.handle_exceptions(
956: l_api_name,
957: g_pkg_name,
958: 'okl_api.g_ret_sts_unexp_error',
959: l_msg_count,

Line 958: 'okl_api.g_ret_sts_unexp_error',

954: END IF;
955: x_return_status := okl_api.handle_exceptions(
956: l_api_name,
957: g_pkg_name,
958: 'okl_api.g_ret_sts_unexp_error',
959: l_msg_count,
960: l_msg_data,
961: '_PVT');
962: -- print the error message in the log file

Line 996: x_return_status := okl_api.handle_exceptions(

992: END IF;
993: IF get_diff_csr%ISOPEN THEN
994: CLOSE get_diff_csr;
995: END IF;
996: x_return_status := okl_api.handle_exceptions(
997: l_api_name,
998: g_pkg_name,
999: 'OTHERS',
1000: l_msg_count,

Line 1034: l_init_msg_list VARCHAR2(3) := okl_api.g_true;

1030: p_retcode NUMBER;
1031: l_api_name CONSTANT VARCHAR2(40):= 'OKL_STREAMS_RECON_REPORT';
1032: l_api_version CONSTANT NUMBER := 1.0;
1033: p_api_version CONSTANT NUMBER := 1.0;
1034: l_init_msg_list VARCHAR2(3) := okl_api.g_true;
1035: l_msg_count NUMBER;
1036: l_msg_data VARCHAR2(2000);
1037: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
1038: lp_end_date VARCHAR2(200);

Line 1037: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;

1033: p_api_version CONSTANT NUMBER := 1.0;
1034: l_init_msg_list VARCHAR2(3) := okl_api.g_true;
1035: l_msg_count NUMBER;
1036: l_msg_data VARCHAR2(2000);
1037: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
1038: lp_end_date VARCHAR2(200);
1039: lp_contract_number VARCHAR2(200);
1040: ln_org_id okc_k_headers_b.authoring_org_id%TYPE := 0;
1041: lv_org_name mtl_organizations.organization_name%TYPE := NULL;

Line 1556: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1552: GROUP BY khr.contract_number,
1553: khr.currency_code
1554: ORDER BY 1 DESC;
1555: BEGIN
1556: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1557: -- Call start_activity to create savepoint, check compatibility
1558: -- and initialize message list
1559: p_retcode := 0;
1560: x_return_status := okl_api.start_activity(

Line 1560: x_return_status := okl_api.start_activity(

1556: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1557: -- Call start_activity to create savepoint, check compatibility
1558: -- and initialize message list
1559: p_retcode := 0;
1560: x_return_status := okl_api.start_activity(
1561: l_api_name,
1562: G_PKG_NAME,
1563: l_init_msg_list,
1564: l_api_version,

Line 1568: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN

1564: l_api_version,
1565: p_api_version,
1566: '_PVT',
1567: x_return_status);
1568: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1569: fnd_file.put_line(fnd_file.log,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_ERROR_ACTIVITY'),1,30));
1570: RAISE okl_api.g_exception_unexpected_error;
1571: ELSIF (x_return_Status = okl_api.g_ret_sts_error) THEN
1572: fnd_file.put_line(fnd_file.log,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_ERROR_ACTIVITY'),1,30));

Line 1570: RAISE okl_api.g_exception_unexpected_error;

1566: '_PVT',
1567: x_return_status);
1568: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1569: fnd_file.put_line(fnd_file.log,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_ERROR_ACTIVITY'),1,30));
1570: RAISE okl_api.g_exception_unexpected_error;
1571: ELSIF (x_return_Status = okl_api.g_ret_sts_error) THEN
1572: fnd_file.put_line(fnd_file.log,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_ERROR_ACTIVITY'),1,30));
1573: RAISE okl_api.g_exception_error;
1574: END IF;

Line 1571: ELSIF (x_return_Status = okl_api.g_ret_sts_error) THEN

1567: x_return_status);
1568: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
1569: fnd_file.put_line(fnd_file.log,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_ERROR_ACTIVITY'),1,30));
1570: RAISE okl_api.g_exception_unexpected_error;
1571: ELSIF (x_return_Status = okl_api.g_ret_sts_error) THEN
1572: fnd_file.put_line(fnd_file.log,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_ERROR_ACTIVITY'),1,30));
1573: RAISE okl_api.g_exception_error;
1574: END IF;
1575: fnd_file.put_line(fnd_file.log,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_START_ACTIVITY'),1,34));

Line 1573: RAISE okl_api.g_exception_error;

1569: fnd_file.put_line(fnd_file.log,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_ERROR_ACTIVITY'),1,30));
1570: RAISE okl_api.g_exception_unexpected_error;
1571: ELSIF (x_return_Status = okl_api.g_ret_sts_error) THEN
1572: fnd_file.put_line(fnd_file.log,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_ERROR_ACTIVITY'),1,30));
1573: RAISE okl_api.g_exception_error;
1574: END IF;
1575: fnd_file.put_line(fnd_file.log,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_START_ACTIVITY'),1,34));
1576: fnd_file.put_line(fnd_file.log,delimit);
1577: -- we need to convert the date from varchar2 to date format

Line 1901: okl_api.end_activity(l_msg_count, l_msg_data);

1897: lt_diff_gt_tbl(i).diff_amount
1898: );
1899: END LOOP;
1900: END IF;
1901: okl_api.end_activity(l_msg_count, l_msg_data);
1902: p_retcode := 0;
1903: RETURN TRUE;
1904: EXCEPTION
1905: WHEN OTHERS THEN

Line 1932: x_return_status := okl_api.handle_exceptions(

1928: END IF;
1929: IF get_diff_csr%ISOPEN THEN
1930: CLOSE get_diff_csr;
1931: END IF;
1932: x_return_status := okl_api.handle_exceptions(
1933: l_api_name,
1934: g_pkg_name,
1935: 'OTHERS',
1936: l_msg_count,