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_MULTI_GAAP_PVT dependencies on OKL_ACCOUNTING_UTIL

Line 308: l_outer_error_msg_tbl Okl_Accounting_Util.Error_Message_Type;

304: l_period_to DATE := FND_DATE.CANONICAL_TO_DATE(p_period_to);
305: l_ae_lines_tbl ae_lines_tbl_type;
306: l_asset_deprn_tbl asset_deprn_tbl_type;
307: l_report_deprn_tbl asset_deprn_tbl_type;
308: l_outer_error_msg_tbl Okl_Accounting_Util.Error_Message_Type;
309: l_pdtv_rec OKL_SETUPPRODUCTS_PUB.pdtv_rec_type;
310: l_pdt_parameters_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
311: l_rep_summary_tbl rep_prd_summary_tbl_type;
312:

Line 547: l_sob_id := Okl_Accounting_Util.GET_SET_OF_BOOKS_ID;

543: fetch get_sec_rep_method into l_sec_rep_method;
544: close get_sec_rep_method;
545:
546: -- Find set of books id
547: l_sob_id := Okl_Accounting_Util.GET_SET_OF_BOOKS_ID;
548: IF (l_sob_id IS NULL) THEN
549: Okl_Api.set_message(p_app_name => g_app_name,
550: p_msg_name => 'OKL_AGN_SOB_ID_ERROR');
551: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 555: l_sob_name := Okl_Accounting_Util.GET_SET_OF_BOOKS_NAME(l_sob_id);

551: RAISE Okl_Api.G_EXCEPTION_ERROR;
552: END IF;
553:
554: -- Find set of books name
555: l_sob_name := Okl_Accounting_Util.GET_SET_OF_BOOKS_NAME(l_sob_id);
556:
557: -- Find org name for report
558: l_org_id := mo_global.get_current_org_id();
559: IF l_org_id IS NULL THEN

Line 591: l_currency_code := Okl_Accounting_Util.GET_FUNC_CURR_CODE;

587: RAISE Okl_Api.G_EXCEPTION_ERROR;
588: END IF;
589:
590: -- Find functional currency code for the set of books id
591: l_currency_code := Okl_Accounting_Util.GET_FUNC_CURR_CODE;
592: IF (l_currency_code IS NULL) THEN
593: Okl_Api.set_message(p_app_name => g_app_name,
594: p_msg_name => 'OKL_AGN_CURR_CODE_ERROR');
595: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 618: OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_SEC_REP_METHOD',l_sec_rep_method,540,0));

614:
615: -- if the secondary representation method is not report abort the run. Bug 7584164
616: if l_sec_rep_method <> 'REPORT' then
617: fnd_file.put_line(FND_FILE.OUTPUT, FND_MESSAGE.GET_STRING('OKL','OKL_SEC_REP_METHOD') ||' '||
618: OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_SEC_REP_METHOD',l_sec_rep_method,540,0));
619: fnd_file.put_line(FND_FILE.OUTPUT, FND_MESSAGE.GET_STRING('OKL','OKL_SEC_REP_METHOD_INVALID'));
620: return;
621: end if;
622:

Line 649: l_error_msg_tbl Okl_Accounting_Util.Error_Message_Type;

645: l_contract_currency := l_gaap_contracts_tbl(x).khr_currency_code;
646:
647: DECLARE
648: -- Declare local variables which need to be re-initialized to null for each contract
649: l_error_msg_tbl Okl_Accounting_Util.Error_Message_Type;
650: l_accrual_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE;
651: l_deprn_accrual_activity OKL_TRX_CONTRACTS.ACCRUAL_ACTIVITY%TYPE;
652: l_record_status VARCHAR2(10);
653: l_record_status2 VARCHAR2(10);

Line 667: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_MGP_LOCAL_BK_CLASS')||': '||OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_BOOK_CLASS',l_deal_type,540,0));

663: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
664: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_CTR_NUM_TITLE')||': '||l_contract_number);
665: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CURRENCY')||': '||l_contract_currency);
666: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_MGP_LOCAL_PRODUCT')||': '||l_product_name);
667: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_MGP_LOCAL_BK_CLASS')||': '||OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_BOOK_CLASS',l_deal_type,540,0));
668: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REVERSE_REVENUE')||':');
669: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REP_STY_TYPE'),35)||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REP_ACTIVITY'),15)||LPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_AMT_TITLE'),20));
670: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REP_STY_LINE'),35)||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REP_ACT_LINE'),15)||LPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_AMT_LINE'),20));
671:

Line 688: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||RPAD(GET_CATEGORY_NAME(i.asset_category_id),35)||RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('OKL_ACCRUAL_ACTIVITY',i.accrual_activity),15)||LPAD(NVL(i.deprn_amount,0),20));

684: -- Open cursor local_deprn_csr
685: FOR i IN local_deprn_csr(l_contract_id, l_period_from, l_period_to)
686: LOOP
687:
688: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||RPAD(GET_CATEGORY_NAME(i.asset_category_id),35)||RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('OKL_ACCRUAL_ACTIVITY',i.accrual_activity),15)||LPAD(NVL(i.deprn_amount,0),20));
689:
690: IF l_asset_deprn_tbl.COUNT > 0 THEN
691: l_record_status := 'NOT-ADDED';
692: -- records exist in the pl/sql table

Line 766: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REPORT_BK_CLASS')||': '||OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_BOOK_CLASS',l_pdt_parameters_rec.deal_type,540,0));

762:
763: -- Bug# 2824234. Adding currency code for reporting streams.
764: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CURRENCY')||': '||l_contract_currency);
765: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REPORT_PRODUCT')||': '||l_pdt_parameters_rec.name);
766: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REPORT_BK_CLASS')||': '||OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('OKL_BOOK_CLASS',l_pdt_parameters_rec.deal_type,540,0));
767: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_MGP_ACCOUNT_REVENUE')||':');
768: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REP_STY_TYPE'),35)||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REP_ACTIVITY'),15)||LPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_AMT_TITLE'),20));
769: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REP_STY_LINE'),35)||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REP_ACT_LINE'),15)||LPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_AMT_LINE'),20));
770:

Line 878: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('OKL_ACCRUAL_ACTIVITY',l_accrual_activity),15)||

874: END IF; --IF l_contract_verified = 'NO' THEN
875:
876: -- Print the accrual/non-accrual data onto the report file
877: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||RPAD(j.stream_type,35)||
878: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('OKL_ACCRUAL_ACTIVITY',l_accrual_activity),15)||
879: LPAD(j.total_amount,20));
880:
881: IF l_rep_summary_tbl.COUNT > 0 THEN
882: l_record_status3 := 'NOT-ADDED';

Line 938: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||RPAD(NVL(GET_CATEGORY_NAME(i.asset_category_id),' '),35)||RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('OKL_ACCRUAL_ACTIVITY',l_deprn_accrual_activity),15)||LPAD(NVL(i.deprn_amount,0),20));

934: --open reporting deprn cursor
935: FOR i IN reporting_deprn_csr(l_contract_id, l_period_from, l_period_to, l_book_type_code)
936: LOOP
937:
938: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||RPAD(NVL(GET_CATEGORY_NAME(i.asset_category_id),' '),35)||RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('OKL_ACCRUAL_ACTIVITY',l_deprn_accrual_activity),15)||LPAD(NVL(i.deprn_amount,0),20));
939:
940: IF l_report_deprn_tbl.COUNT > 0 THEN
941: l_record_status2 := 'NOT-ADDED';
942: -- records exist in the pl/sql table

Line 992: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_error_msg_tbl);

988: l_contract_error_count := l_contract_error_count + 1;
989: FND_FILE.PUT_LINE(FND_FILE.LOG,l_contract_number||', '||
990: FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_ERROR_STATUS')||' '||
991: l_return_status);
992: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_error_msg_tbl);
993: IF (l_error_msg_tbl.COUNT > 0) THEN
994: FOR i IN l_error_msg_tbl.FIRST..l_error_msg_tbl.LAST
995: LOOP
996: IF l_error_msg_tbl(i) IS NOT NULL THEN

Line 1012: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_error_msg_tbl);

1008: l_contract_error_count := l_contract_error_count + 1;
1009: FND_FILE.PUT_LINE(FND_FILE.LOG,l_contract_number||', '||
1010: FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_ERROR_STATUS')||' '||
1011: l_return_status);
1012: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_error_msg_tbl);
1013: IF (l_error_msg_tbl.COUNT > 0) THEN
1014: FOR i IN l_error_msg_tbl.FIRST..l_error_msg_tbl.LAST
1015: LOOP
1016: IF l_error_msg_tbl(i) IS NOT NULL THEN

Line 1035: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_error_msg_tbl);

1031: l_contract_error_count := l_contract_error_count + 1;
1032: FND_FILE.PUT_LINE(FND_FILE.LOG,l_contract_number||', '||
1033: FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_ERROR_STATUS')||' '||
1034: l_return_status);
1035: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_error_msg_tbl);
1036: IF (l_error_msg_tbl.COUNT > 0) THEN
1037: FOR i IN l_error_msg_tbl.FIRST..l_error_msg_tbl.LAST
1038: LOOP
1039: IF l_error_msg_tbl(i) IS NOT NULL THEN

Line 1082: l_concat_desc := okl_accounting_util.get_concat_segments(l_ae_lines_tbl(i).ccid);

1078: ,l_ae_lines_tbl);
1079: IF l_ae_lines_tbl.COUNT >0 THEN
1080: FOR i IN l_ae_lines_tbl.FIRST..l_ae_lines_tbl.LAST
1081: LOOP
1082: l_concat_desc := okl_accounting_util.get_concat_segments(l_ae_lines_tbl(i).ccid);
1083: l_cr_dr_flag := OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('CR_DR',l_ae_lines_tbl(i).crd_code,101,101);
1084: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_cr_dr_flag||' '||l_ae_lines_tbl(i).line_type||' '||l_concat_desc);
1085: END LOOP;
1086: END IF;

Line 1083: l_cr_dr_flag := OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('CR_DR',l_ae_lines_tbl(i).crd_code,101,101);

1079: IF l_ae_lines_tbl.COUNT >0 THEN
1080: FOR i IN l_ae_lines_tbl.FIRST..l_ae_lines_tbl.LAST
1081: LOOP
1082: l_concat_desc := okl_accounting_util.get_concat_segments(l_ae_lines_tbl(i).ccid);
1083: l_cr_dr_flag := OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('CR_DR',l_ae_lines_tbl(i).crd_code,101,101);
1084: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_cr_dr_flag||' '||l_ae_lines_tbl(i).line_type||' '||l_concat_desc);
1085: END LOOP;
1086: END IF;
1087: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

Line 1117: l_concat_desc := okl_accounting_util.get_concat_segments(l_ae_lines_tbl(i).ccid);

1113: ,l_ae_lines_tbl);
1114: IF l_ae_lines_tbl.COUNT >0 THEN
1115: FOR i IN l_ae_lines_tbl.FIRST..l_ae_lines_tbl.LAST
1116: LOOP
1117: l_concat_desc := okl_accounting_util.get_concat_segments(l_ae_lines_tbl(i).ccid);
1118: l_cr_dr_flag := OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('CR_DR',l_ae_lines_tbl(i).crd_code,101,101);
1119: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_cr_dr_flag||' '||l_ae_lines_tbl(i).line_type||' '||l_concat_desc);
1120: END LOOP;
1121: END IF;

Line 1118: l_cr_dr_flag := OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('CR_DR',l_ae_lines_tbl(i).crd_code,101,101);

1114: IF l_ae_lines_tbl.COUNT >0 THEN
1115: FOR i IN l_ae_lines_tbl.FIRST..l_ae_lines_tbl.LAST
1116: LOOP
1117: l_concat_desc := okl_accounting_util.get_concat_segments(l_ae_lines_tbl(i).ccid);
1118: l_cr_dr_flag := OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('CR_DR',l_ae_lines_tbl(i).crd_code,101,101);
1119: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_cr_dr_flag||' '||l_ae_lines_tbl(i).line_type||' '||l_concat_desc);
1120: END LOOP;
1121: END IF;
1122: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

Line 1145: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('OKL_ACCRUAL_ACTIVITY','NON-ACCRUAL'),23)||

1141: FOR j IN l_asset_deprn_tbl.FIRST..l_asset_deprn_tbl.LAST
1142: LOOP
1143: IF SIGN(l_asset_deprn_tbl(j).deprn_amount) = -1 THEN
1144: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_asset_deprn_tbl(j).category_name,35)||
1145: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('OKL_ACCRUAL_ACTIVITY','NON-ACCRUAL'),23)||
1146: LPAD(ABS(l_asset_deprn_tbl(j).deprn_amount),18));
1147: ELSE
1148: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_asset_deprn_tbl(j).category_name,35)||
1149: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('OKL_ACCRUAL_ACTIVITY','ACCRUAL'),23)||

Line 1149: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('OKL_ACCRUAL_ACTIVITY','ACCRUAL'),23)||

1145: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('OKL_ACCRUAL_ACTIVITY','NON-ACCRUAL'),23)||
1146: LPAD(ABS(l_asset_deprn_tbl(j).deprn_amount),18));
1147: ELSE
1148: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_asset_deprn_tbl(j).category_name,35)||
1149: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('OKL_ACCRUAL_ACTIVITY','ACCRUAL'),23)||
1150: LPAD(ABS(l_asset_deprn_tbl(j).deprn_amount),18));
1151: END IF;
1152: END LOOP;
1153: END IF;

Line 1175: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('OKL_ACCRUAL_ACTIVITY','NON-ACCRUAL'),23)||

1171: FOR k IN l_report_deprn_tbl.FIRST..l_report_deprn_tbl.LAST
1172: LOOP
1173: IF SIGN(l_report_deprn_tbl(k).deprn_amount) = -1 THEN
1174: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_report_deprn_tbl(k).category_name,35)||
1175: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('OKL_ACCRUAL_ACTIVITY','NON-ACCRUAL'),23)||
1176: LPAD(ABS(l_report_deprn_tbl(k).deprn_amount),18));
1177: ELSE
1178: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_report_deprn_tbl(k).category_name,35)||
1179: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('OKL_ACCRUAL_ACTIVITY','ACCRUAL'),23)||

Line 1179: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('OKL_ACCRUAL_ACTIVITY','ACCRUAL'),23)||

1175: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('OKL_ACCRUAL_ACTIVITY','NON-ACCRUAL'),23)||
1176: LPAD(ABS(l_report_deprn_tbl(k).deprn_amount),18));
1177: ELSE
1178: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_report_deprn_tbl(k).category_name,35)||
1179: RPAD(Okl_Accounting_Util.Get_Lookup_Meaning('OKL_ACCRUAL_ACTIVITY','ACCRUAL'),23)||
1180: LPAD(ABS(l_report_deprn_tbl(k).deprn_amount),18));
1181: END IF;
1182: END LOOP;
1183: END IF;

Line 1209: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);

1205: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1206: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_ERROR'));
1207: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')
1208: ||' '||l_return_status);
1209: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);
1210: IF (l_outer_error_msg_tbl.COUNT > 0) THEN
1211: FOR i IN l_outer_error_msg_tbl.FIRST..l_outer_error_msg_tbl.LAST
1212: LOOP
1213: IF l_outer_error_msg_tbl(i) IS NOT NULL THEN

Line 1226: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);

1222:
1223: -- print the error message in the log file
1224: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')
1225: ||' '||l_return_status);
1226: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);
1227: IF (l_outer_error_msg_tbl.COUNT > 0) THEN
1228: FOR i IN l_outer_error_msg_tbl.FIRST..l_outer_error_msg_tbl.LAST
1229: LOOP
1230: IF l_outer_error_msg_tbl(i) IS NOT NULL THEN

Line 1249: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);

1245:
1246: -- print the error message in the log file
1247: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')
1248: ||' '||l_return_status);
1249: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_outer_error_msg_tbl);
1250: IF (l_outer_error_msg_tbl.COUNT > 0) THEN
1251: FOR i IN l_outer_error_msg_tbl.FIRST..l_outer_error_msg_tbl.LAST
1252: LOOP
1253: IF l_outer_error_msg_tbl(i) IS NOT NULL THEN