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 FND_FILE

Line 599: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL', 'OKL_MGP_REP_TITLE'));

595: RAISE Okl_Api.G_EXCEPTION_ERROR;
596: END IF;
597:
598: -- Create report header
599: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL', 'OKL_MGP_REP_TITLE'));
600: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL', 'OKL_MGP_REP_TITLE_UNDERLINE'));
601: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
602: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_SOB_TITLE')
603: ||' '||RPAD(l_sob_name, 65)

Line 600: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL', 'OKL_MGP_REP_TITLE_UNDERLINE'));

596: END IF;
597:
598: -- Create report header
599: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL', 'OKL_MGP_REP_TITLE'));
600: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL', 'OKL_MGP_REP_TITLE_UNDERLINE'));
601: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
602: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_SOB_TITLE')
603: ||' '||RPAD(l_sob_name, 65)
604: ||FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_OU_TITLE')

Line 601: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

597:
598: -- Create report header
599: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL', 'OKL_MGP_REP_TITLE'));
600: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL', 'OKL_MGP_REP_TITLE_UNDERLINE'));
601: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
602: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_SOB_TITLE')
603: ||' '||RPAD(l_sob_name, 65)
604: ||FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_OU_TITLE')
605: ||' '||l_org_name);

Line 602: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_SOB_TITLE')

598: -- Create report header
599: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL', 'OKL_MGP_REP_TITLE'));
600: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL', 'OKL_MGP_REP_TITLE_UNDERLINE'));
601: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
602: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_SOB_TITLE')
603: ||' '||RPAD(l_sob_name, 65)
604: ||FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_OU_TITLE')
605: ||' '||l_org_name);
606: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_PROG_DATE_TITLE')

Line 606: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_PROG_DATE_TITLE')

602: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_SOB_TITLE')
603: ||' '||RPAD(l_sob_name, 65)
604: ||FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_OU_TITLE')
605: ||' '||l_org_name);
606: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_PROG_DATE_TITLE')
607: ||' '||RPAD(l_sysdate, 61)||FND_MESSAGE.GET_STRING('OKL','OKL_MGP_RPT_DATE_RANGE')
608: ||' '||l_period_from||' '||FND_MESSAGE.GET_STRING('OKL','OKL_MGP_RPT_TO_FIELD')
609: ||' '||l_period_to);
610: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_CURR_TITLE')

Line 610: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_CURR_TITLE')

606: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_PROG_DATE_TITLE')
607: ||' '||RPAD(l_sysdate, 61)||FND_MESSAGE.GET_STRING('OKL','OKL_MGP_RPT_DATE_RANGE')
608: ||' '||l_period_from||' '||FND_MESSAGE.GET_STRING('OKL','OKL_MGP_RPT_TO_FIELD')
609: ||' '||l_period_to);
610: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_CURR_TITLE')
611: ||' '||RPAD(l_currency_code,58)||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_BATCH_NAME')
612: ||' '||p_batch_name);
613: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
614:

Line 613: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

609: ||' '||l_period_to);
610: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_CURR_TITLE')
611: ||' '||RPAD(l_currency_code,58)||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_BATCH_NAME')
612: ||' '||p_batch_name);
613: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
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') ||' '||

Line 617: fnd_file.put_line(FND_FILE.OUTPUT, FND_MESSAGE.GET_STRING('OKL','OKL_SEC_REP_METHOD') ||' '||

613: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
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;

Line 619: fnd_file.put_line(FND_FILE.OUTPUT, FND_MESSAGE.GET_STRING('OKL','OKL_SEC_REP_METHOD_INVALID'));

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:
623: -- process contracts

Line 663: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

659:
660: BEGIN
661:
662: -- create report body content
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));

Line 664: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_CTR_NUM_TITLE')||': '||l_contract_number);

660: BEGIN
661:
662: -- create report body content
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')||':');

Line 665: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CURRENCY')||': '||l_contract_currency);

661:
662: -- create report body content
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));

Line 666: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_MGP_LOCAL_PRODUCT')||': '||l_product_name);

662: -- create report body content
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));

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 668: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REVERSE_REVENUE')||':');

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:
672: -- For each contract identify the income accrued or non-accrued

Line 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));

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:
672: -- For each contract identify the income accrued or non-accrued
673: FOR x IN accrual_trx_csr(l_contract_id,l_period_from, l_period_to)

Line 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));

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:
672: -- For each contract identify the income accrued or non-accrued
673: FOR x IN accrual_trx_csr(l_contract_id,l_period_from, l_period_to)
674: LOOP

Line 676: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||RPAD(x.stream_type,35)||RPAD(x.accrual_activity,15)||LPAD(x.total_amount,20));

672: -- For each contract identify the income accrued or non-accrued
673: FOR x IN accrual_trx_csr(l_contract_id,l_period_from, l_period_to)
674: LOOP
675: -- Print the accrual/non-accrual data onto the report file for audit trail
676: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||RPAD(x.stream_type,35)||RPAD(x.accrual_activity,15)||LPAD(x.total_amount,20));
677: END LOOP;
678: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
679: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REVERSE_DEPR')||':');
680: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CURRENCY')||': '||l_currency_code);

Line 678: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

674: LOOP
675: -- Print the accrual/non-accrual data onto the report file for audit trail
676: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||RPAD(x.stream_type,35)||RPAD(x.accrual_activity,15)||LPAD(x.total_amount,20));
677: END LOOP;
678: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
679: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REVERSE_DEPR')||':');
680: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CURRENCY')||': '||l_currency_code);
681: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_ADA_RPT_AST_CAT_PROMPT'),35)||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REP_ACTIVITY'),15)||LPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_AMT_TITLE'),20));
682: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_ADA_RPT_AST_CAT_UNDERLINE'),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));

Line 679: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REVERSE_DEPR')||':');

675: -- Print the accrual/non-accrual data onto the report file for audit trail
676: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||RPAD(x.stream_type,35)||RPAD(x.accrual_activity,15)||LPAD(x.total_amount,20));
677: END LOOP;
678: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
679: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REVERSE_DEPR')||':');
680: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CURRENCY')||': '||l_currency_code);
681: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_ADA_RPT_AST_CAT_PROMPT'),35)||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REP_ACTIVITY'),15)||LPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_AMT_TITLE'),20));
682: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_ADA_RPT_AST_CAT_UNDERLINE'),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));
683:

Line 680: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CURRENCY')||': '||l_currency_code);

676: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||RPAD(x.stream_type,35)||RPAD(x.accrual_activity,15)||LPAD(x.total_amount,20));
677: END LOOP;
678: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
679: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REVERSE_DEPR')||':');
680: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CURRENCY')||': '||l_currency_code);
681: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_ADA_RPT_AST_CAT_PROMPT'),35)||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REP_ACTIVITY'),15)||LPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_AMT_TITLE'),20));
682: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_ADA_RPT_AST_CAT_UNDERLINE'),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));
683:
684: -- Open cursor local_deprn_csr

Line 681: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_ADA_RPT_AST_CAT_PROMPT'),35)||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REP_ACTIVITY'),15)||LPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_AMT_TITLE'),20));

677: END LOOP;
678: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
679: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REVERSE_DEPR')||':');
680: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CURRENCY')||': '||l_currency_code);
681: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_ADA_RPT_AST_CAT_PROMPT'),35)||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REP_ACTIVITY'),15)||LPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_AMT_TITLE'),20));
682: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_ADA_RPT_AST_CAT_UNDERLINE'),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));
683:
684: -- Open cursor local_deprn_csr
685: FOR i IN local_deprn_csr(l_contract_id, l_period_from, l_period_to)

Line 682: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_ADA_RPT_AST_CAT_UNDERLINE'),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));

678: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
679: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REVERSE_DEPR')||':');
680: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CURRENCY')||': '||l_currency_code);
681: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_ADA_RPT_AST_CAT_PROMPT'),35)||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REP_ACTIVITY'),15)||LPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_AMT_TITLE'),20));
682: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_ADA_RPT_AST_CAT_UNDERLINE'),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));
683:
684: -- Open cursor local_deprn_csr
685: FOR i IN local_deprn_csr(l_contract_id, l_period_from, l_period_to)
686: LOOP

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 733: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

729: END IF;
730: l_count := l_count+1;
731: END IF;
732: END LOOP;
733: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
734:
735: l_pdtv_rec.id := l_rep_product_id;
736: OKL_SETUPPRODUCTS_PUB.Getpdt_parameters
737: (p_api_version => l_api_version,

Line 764: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CURRENCY')||': '||l_contract_currency);

760: END IF;
761: END IF;
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));

Line 765: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REPORT_PRODUCT')||': '||l_pdt_parameters_rec.name);

761: END IF;
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));

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 767: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_MGP_ACCOUNT_REVENUE')||':');

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:
771: l_contract_verified := 'NO';

Line 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));

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:
771: l_contract_verified := 'NO';
772:

Line 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));

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:
771: l_contract_verified := 'NO';
772:
773: -- open reporting streams cursor

Line 877: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||RPAD(j.stream_type,35)||

873: END IF; --IF j.accrual_yn='Y'
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

Line 928: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

924: l_count3 := l_count3+1;
925: END IF; -- IF l_rep_summary_tbl.COUNT > 0 THEN
926: END LOOP;
927:
928: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
929: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_MGP_ACCOUNT_DEPR')||':');
930: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CURRENCY')||': '||l_currency_code);
931: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_ADA_RPT_AST_CAT_PROMPT'),35)||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REP_ACTIVITY'),15)||LPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_AMT_TITLE'),20));
932: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_ADA_RPT_AST_CAT_UNDERLINE'),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));

Line 929: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_MGP_ACCOUNT_DEPR')||':');

925: END IF; -- IF l_rep_summary_tbl.COUNT > 0 THEN
926: END LOOP;
927:
928: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
929: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_MGP_ACCOUNT_DEPR')||':');
930: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CURRENCY')||': '||l_currency_code);
931: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_ADA_RPT_AST_CAT_PROMPT'),35)||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REP_ACTIVITY'),15)||LPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_AMT_TITLE'),20));
932: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_ADA_RPT_AST_CAT_UNDERLINE'),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));
933:

Line 930: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CURRENCY')||': '||l_currency_code);

926: END LOOP;
927:
928: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
929: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_MGP_ACCOUNT_DEPR')||':');
930: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CURRENCY')||': '||l_currency_code);
931: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_ADA_RPT_AST_CAT_PROMPT'),35)||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REP_ACTIVITY'),15)||LPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_AMT_TITLE'),20));
932: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_ADA_RPT_AST_CAT_UNDERLINE'),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));
933:
934: --open reporting deprn cursor

Line 931: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_ADA_RPT_AST_CAT_PROMPT'),35)||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REP_ACTIVITY'),15)||LPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_AMT_TITLE'),20));

927:
928: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
929: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_MGP_ACCOUNT_DEPR')||':');
930: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CURRENCY')||': '||l_currency_code);
931: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_ADA_RPT_AST_CAT_PROMPT'),35)||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REP_ACTIVITY'),15)||LPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_AMT_TITLE'),20));
932: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_ADA_RPT_AST_CAT_UNDERLINE'),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));
933:
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)

Line 932: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_ADA_RPT_AST_CAT_UNDERLINE'),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));

928: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
929: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_MGP_ACCOUNT_DEPR')||':');
930: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CURRENCY')||': '||l_currency_code);
931: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_ADA_RPT_AST_CAT_PROMPT'),35)||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REP_ACTIVITY'),15)||LPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_AMT_TITLE'),20));
932: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' '||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_ADA_RPT_AST_CAT_UNDERLINE'),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));
933:
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

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 980: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

976: END IF;
977: l_count2 := l_count2+1;
978: END IF;
979: END LOOP; --FOR i IN local_deprn_csr(l_contract_id)
980: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
981:
982:
983: EXCEPTION
984: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

Line 989: FND_FILE.PUT_LINE(FND_FILE.LOG,l_contract_number||', '||

985: l_return_status := Okl_Api.G_RET_STS_ERROR;
986: -- Select the contract for error reporting
987: l_contract_error_tbl(l_contract_error_count) := l_contract_number;
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

Line 997: FND_FILE.PUT_LINE(FND_FILE.LOG,l_error_msg_tbl(i));

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
997: FND_FILE.PUT_LINE(FND_FILE.LOG,l_error_msg_tbl(i));
998: END IF;
999: END LOOP;
1000: END IF;
1001:

Line 1009: FND_FILE.PUT_LINE(FND_FILE.LOG,l_contract_number||', '||

1005:
1006: -- Select the contract for error reporting
1007: l_contract_error_tbl(l_contract_error_count) := l_contract_number;
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

Line 1017: FND_FILE.PUT_LINE(FND_FILE.LOG,l_error_msg_tbl(i));

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
1017: FND_FILE.PUT_LINE(FND_FILE.LOG,l_error_msg_tbl(i));
1018: END IF;
1019: END LOOP;
1020: END IF;
1021:

Line 1032: FND_FILE.PUT_LINE(FND_FILE.LOG,l_contract_number||', '||

1028: l_return_status := Okl_Api.G_RET_STS_ERROR;
1029: -- Select the contract for error reporting
1030: l_contract_error_tbl(l_contract_error_count) := l_contract_number;
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

Line 1040: FND_FILE.PUT_LINE(FND_FILE.LOG,l_error_msg_tbl(i));

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
1040: FND_FILE.PUT_LINE(FND_FILE.LOG,l_error_msg_tbl(i));
1041: END IF;
1042: END LOOP;
1043: END IF;
1044:

Line 1051: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

1047: END LOOP;
1048: END IF;
1049:
1050: -- Print summary for each product onto the report
1051: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1052: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1053: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_LOCAL_PRD_SUMRY')||':');
1054: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1055:

Line 1052: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

1048: END IF;
1049:
1050: -- Print summary for each product onto the report
1051: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1052: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1053: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_LOCAL_PRD_SUMRY')||':');
1054: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1055:
1056:

Line 1053: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_LOCAL_PRD_SUMRY')||':');

1049:
1050: -- Print summary for each product onto the report
1051: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1052: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1053: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_LOCAL_PRD_SUMRY')||':');
1054: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1055:
1056:
1057: -- Print summary for each product onto the report

Line 1054: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

1050: -- Print summary for each product onto the report
1051: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1052: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1053: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_LOCAL_PRD_SUMRY')||':');
1054: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1055:
1056:
1057: -- Print summary for each product onto the report
1058: OPEN product_summary_csr(l_period_from, l_period_to);

Line 1064: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_PRD_NAME')||' : '||l_product_summary.product_name);

1060: EXIT WHEN product_summary_csr%NOTFOUND;
1061: FETCH product_summary_csr INTO l_product_summary;
1062: IF product_summary_csr%FOUND THEN
1063: l_product_name := l_product_summary.product_name;
1064: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_PRD_NAME')||' : '||l_product_summary.product_name);
1065: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REP_STY_TYPE')||' : '||l_product_summary.stream_type);
1066: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CURRENCY')||' : '||l_product_summary.currency_code);
1067: IF l_product_summary.accrual_activity = 'ACCRUAL' THEN
1068: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_AMT_ACCRUED')||' : '||l_product_summary.total_amount);

Line 1065: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REP_STY_TYPE')||' : '||l_product_summary.stream_type);

1061: FETCH product_summary_csr INTO l_product_summary;
1062: IF product_summary_csr%FOUND THEN
1063: l_product_name := l_product_summary.product_name;
1064: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_PRD_NAME')||' : '||l_product_summary.product_name);
1065: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REP_STY_TYPE')||' : '||l_product_summary.stream_type);
1066: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CURRENCY')||' : '||l_product_summary.currency_code);
1067: IF l_product_summary.accrual_activity = 'ACCRUAL' THEN
1068: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_AMT_ACCRUED')||' : '||l_product_summary.total_amount);
1069: ELSIF l_product_summary.accrual_activity = 'NON-ACCRUAL' THEN

Line 1066: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CURRENCY')||' : '||l_product_summary.currency_code);

1062: IF product_summary_csr%FOUND THEN
1063: l_product_name := l_product_summary.product_name;
1064: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_PRD_NAME')||' : '||l_product_summary.product_name);
1065: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REP_STY_TYPE')||' : '||l_product_summary.stream_type);
1066: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CURRENCY')||' : '||l_product_summary.currency_code);
1067: IF l_product_summary.accrual_activity = 'ACCRUAL' THEN
1068: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_AMT_ACCRUED')||' : '||l_product_summary.total_amount);
1069: ELSIF l_product_summary.accrual_activity = 'NON-ACCRUAL' THEN
1070: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_AMT_NON_ACCRUED')||' : '||l_product_summary.total_amount);

Line 1068: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_AMT_ACCRUED')||' : '||l_product_summary.total_amount);

1064: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_PRD_NAME')||' : '||l_product_summary.product_name);
1065: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REP_STY_TYPE')||' : '||l_product_summary.stream_type);
1066: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CURRENCY')||' : '||l_product_summary.currency_code);
1067: IF l_product_summary.accrual_activity = 'ACCRUAL' THEN
1068: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_AMT_ACCRUED')||' : '||l_product_summary.total_amount);
1069: ELSIF l_product_summary.accrual_activity = 'NON-ACCRUAL' THEN
1070: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_AMT_NON_ACCRUED')||' : '||l_product_summary.total_amount);
1071: END IF;
1072:

Line 1070: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_AMT_NON_ACCRUED')||' : '||l_product_summary.total_amount);

1066: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CURRENCY')||' : '||l_product_summary.currency_code);
1067: IF l_product_summary.accrual_activity = 'ACCRUAL' THEN
1068: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_AMT_ACCRUED')||' : '||l_product_summary.total_amount);
1069: ELSIF l_product_summary.accrual_activity = 'NON-ACCRUAL' THEN
1070: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_AMT_NON_ACCRUED')||' : '||l_product_summary.total_amount);
1071: END IF;
1072:
1073: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_ACCOUNTS'));
1074: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_ACCOUNTS_LINE'));

Line 1073: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_ACCOUNTS'));

1069: ELSIF l_product_summary.accrual_activity = 'NON-ACCRUAL' THEN
1070: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_AMT_NON_ACCRUED')||' : '||l_product_summary.total_amount);
1071: END IF;
1072:
1073: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_ACCOUNTS'));
1074: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_ACCOUNTS_LINE'));
1075: GET_TEMPLATE_LINES(l_product_summary.product_name
1076: ,l_product_summary.stream_type
1077: ,l_product_summary.accrual_activity

Line 1074: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_ACCOUNTS_LINE'));

1070: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_AMT_NON_ACCRUED')||' : '||l_product_summary.total_amount);
1071: END IF;
1072:
1073: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_ACCOUNTS'));
1074: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_ACCOUNTS_LINE'));
1075: GET_TEMPLATE_LINES(l_product_summary.product_name
1076: ,l_product_summary.stream_type
1077: ,l_product_summary.accrual_activity
1078: ,l_ae_lines_tbl);

Line 1084: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_cr_dr_flag||' '||l_ae_lines_tbl(i).line_type||' '||l_concat_desc);

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,'');
1088: END IF;

Line 1087: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

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,'');
1088: END IF;
1089: END LOOP;
1090:
1091: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

Line 1091: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

1087: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1088: END IF;
1089: END LOOP;
1090:
1091: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1092: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1093: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REPORT_PRD_SUMRY')||':');
1094: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1095:

Line 1092: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

1088: END IF;
1089: END LOOP;
1090:
1091: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1092: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1093: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REPORT_PRD_SUMRY')||':');
1094: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1095:
1096: -- Print reporting summary for each product

Line 1093: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REPORT_PRD_SUMRY')||':');

1089: END LOOP;
1090:
1091: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1092: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1093: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REPORT_PRD_SUMRY')||':');
1094: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1095:
1096: -- Print reporting summary for each product
1097: IF l_rep_summary_tbl.COUNT > 0 THEN

Line 1094: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

1090:
1091: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1092: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1093: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REPORT_PRD_SUMRY')||':');
1094: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1095:
1096: -- Print reporting summary for each product
1097: IF l_rep_summary_tbl.COUNT > 0 THEN
1098: FOR i IN l_rep_summary_tbl.FIRST..l_rep_summary_tbl.LAST

Line 1100: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_PRD_NAME')||' : '||l_rep_summary_tbl(i).product_name);

1096: -- Print reporting summary for each product
1097: IF l_rep_summary_tbl.COUNT > 0 THEN
1098: FOR i IN l_rep_summary_tbl.FIRST..l_rep_summary_tbl.LAST
1099: LOOP
1100: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_PRD_NAME')||' : '||l_rep_summary_tbl(i).product_name);
1101: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REP_STY_TYPE')||' : '||l_rep_summary_tbl(i).stream_type);
1102: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CURRENCY')||' : '||l_rep_summary_tbl(i).currency_code);
1103: IF l_rep_summary_tbl(i).accrual_activity = 'ACCRUAL' THEN
1104: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_AMT_ACCOUNT')||' : '||l_rep_summary_tbl(i).total_amount);

Line 1101: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REP_STY_TYPE')||' : '||l_rep_summary_tbl(i).stream_type);

1097: IF l_rep_summary_tbl.COUNT > 0 THEN
1098: FOR i IN l_rep_summary_tbl.FIRST..l_rep_summary_tbl.LAST
1099: LOOP
1100: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_PRD_NAME')||' : '||l_rep_summary_tbl(i).product_name);
1101: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REP_STY_TYPE')||' : '||l_rep_summary_tbl(i).stream_type);
1102: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CURRENCY')||' : '||l_rep_summary_tbl(i).currency_code);
1103: IF l_rep_summary_tbl(i).accrual_activity = 'ACCRUAL' THEN
1104: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_AMT_ACCOUNT')||' : '||l_rep_summary_tbl(i).total_amount);
1105: ELSIF l_rep_summary_tbl(i).accrual_activity = 'NON-ACCRUAL' THEN

Line 1102: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CURRENCY')||' : '||l_rep_summary_tbl(i).currency_code);

1098: FOR i IN l_rep_summary_tbl.FIRST..l_rep_summary_tbl.LAST
1099: LOOP
1100: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_PRD_NAME')||' : '||l_rep_summary_tbl(i).product_name);
1101: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REP_STY_TYPE')||' : '||l_rep_summary_tbl(i).stream_type);
1102: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CURRENCY')||' : '||l_rep_summary_tbl(i).currency_code);
1103: IF l_rep_summary_tbl(i).accrual_activity = 'ACCRUAL' THEN
1104: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_AMT_ACCOUNT')||' : '||l_rep_summary_tbl(i).total_amount);
1105: ELSIF l_rep_summary_tbl(i).accrual_activity = 'NON-ACCRUAL' THEN
1106: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_AMT_NON_ACCOUNT')||' : '||l_rep_summary_tbl(i).total_amount);

Line 1104: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_AMT_ACCOUNT')||' : '||l_rep_summary_tbl(i).total_amount);

1100: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_PRD_NAME')||' : '||l_rep_summary_tbl(i).product_name);
1101: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REP_STY_TYPE')||' : '||l_rep_summary_tbl(i).stream_type);
1102: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CURRENCY')||' : '||l_rep_summary_tbl(i).currency_code);
1103: IF l_rep_summary_tbl(i).accrual_activity = 'ACCRUAL' THEN
1104: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_AMT_ACCOUNT')||' : '||l_rep_summary_tbl(i).total_amount);
1105: ELSIF l_rep_summary_tbl(i).accrual_activity = 'NON-ACCRUAL' THEN
1106: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_AMT_NON_ACCOUNT')||' : '||l_rep_summary_tbl(i).total_amount);
1107: END IF;
1108: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_ACCOUNTS'));

Line 1106: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_AMT_NON_ACCOUNT')||' : '||l_rep_summary_tbl(i).total_amount);

1102: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CURRENCY')||' : '||l_rep_summary_tbl(i).currency_code);
1103: IF l_rep_summary_tbl(i).accrual_activity = 'ACCRUAL' THEN
1104: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_AMT_ACCOUNT')||' : '||l_rep_summary_tbl(i).total_amount);
1105: ELSIF l_rep_summary_tbl(i).accrual_activity = 'NON-ACCRUAL' THEN
1106: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_AMT_NON_ACCOUNT')||' : '||l_rep_summary_tbl(i).total_amount);
1107: END IF;
1108: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_ACCOUNTS'));
1109: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_ACCOUNTS_LINE'));
1110: GET_TEMPLATE_LINES(l_rep_summary_tbl(i).product_name

Line 1108: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_ACCOUNTS'));

1104: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_AMT_ACCOUNT')||' : '||l_rep_summary_tbl(i).total_amount);
1105: ELSIF l_rep_summary_tbl(i).accrual_activity = 'NON-ACCRUAL' THEN
1106: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_AMT_NON_ACCOUNT')||' : '||l_rep_summary_tbl(i).total_amount);
1107: END IF;
1108: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_ACCOUNTS'));
1109: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_ACCOUNTS_LINE'));
1110: GET_TEMPLATE_LINES(l_rep_summary_tbl(i).product_name
1111: ,l_rep_summary_tbl(i).stream_type
1112: ,l_rep_summary_tbl(i).accrual_activity

Line 1109: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_ACCOUNTS_LINE'));

1105: ELSIF l_rep_summary_tbl(i).accrual_activity = 'NON-ACCRUAL' THEN
1106: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_AMT_NON_ACCOUNT')||' : '||l_rep_summary_tbl(i).total_amount);
1107: END IF;
1108: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_ACCOUNTS'));
1109: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_ACCOUNTS_LINE'));
1110: GET_TEMPLATE_LINES(l_rep_summary_tbl(i).product_name
1111: ,l_rep_summary_tbl(i).stream_type
1112: ,l_rep_summary_tbl(i).accrual_activity
1113: ,l_ae_lines_tbl);

Line 1119: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, l_cr_dr_flag||' '||l_ae_lines_tbl(i).line_type||' '||l_concat_desc);

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,'');
1123: END LOOP;

Line 1122: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

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,'');
1123: END LOOP;
1124: END IF;
1125:
1126: -- print local depreciation summary

Line 1127: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

1123: END LOOP;
1124: END IF;
1125:
1126: -- print local depreciation summary
1127: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1128: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_LOCAL_DEPR_SUMRY'));
1129: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1130: -- Create Report Content
1131: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CURRENCY')||': '||l_currency_code);

Line 1128: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_LOCAL_DEPR_SUMRY'));

1124: END IF;
1125:
1126: -- print local depreciation summary
1127: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1128: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_LOCAL_DEPR_SUMRY'));
1129: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1130: -- Create Report Content
1131: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CURRENCY')||': '||l_currency_code);
1132: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_ADA_RPT_AST_CAT_PROMPT'),35)

Line 1129: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

1125:
1126: -- print local depreciation summary
1127: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1128: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_LOCAL_DEPR_SUMRY'));
1129: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1130: -- Create Report Content
1131: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CURRENCY')||': '||l_currency_code);
1132: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_ADA_RPT_AST_CAT_PROMPT'),35)
1133: ||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_ACTIVITY'),23)

Line 1131: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CURRENCY')||': '||l_currency_code);

1127: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1128: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_LOCAL_DEPR_SUMRY'));
1129: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1130: -- Create Report Content
1131: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CURRENCY')||': '||l_currency_code);
1132: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_ADA_RPT_AST_CAT_PROMPT'),35)
1133: ||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_ACTIVITY'),23)
1134: ||LPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_AMT_TITLE'),18));
1135:

Line 1132: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_ADA_RPT_AST_CAT_PROMPT'),35)

1128: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_LOCAL_DEPR_SUMRY'));
1129: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1130: -- Create Report Content
1131: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CURRENCY')||': '||l_currency_code);
1132: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_ADA_RPT_AST_CAT_PROMPT'),35)
1133: ||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_ACTIVITY'),23)
1134: ||LPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_AMT_TITLE'),18));
1135:
1136: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_ADA_RPT_AST_CAT_UNDERLINE'),35)

Line 1136: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_ADA_RPT_AST_CAT_UNDERLINE'),35)

1132: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_ADA_RPT_AST_CAT_PROMPT'),35)
1133: ||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_ACTIVITY'),23)
1134: ||LPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_AMT_TITLE'),18));
1135:
1136: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_ADA_RPT_AST_CAT_UNDERLINE'),35)
1137: ||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_ADA_RPT_ACTIVITY_UNDERLINE'),23)
1138: ||LPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_AMT_LINE'),18));
1139:
1140: IF l_asset_deprn_tbl.COUNT > 0 THEN

Line 1144: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_asset_deprn_tbl(j).category_name,35)||

1140: IF l_asset_deprn_tbl.COUNT > 0 THEN
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)||

Line 1148: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_asset_deprn_tbl(j).category_name,35)||

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)||
1150: LPAD(ABS(l_asset_deprn_tbl(j).deprn_amount),18));
1151: END IF;
1152: END LOOP;

Line 1155: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

1151: END IF;
1152: END LOOP;
1153: END IF;
1154:
1155: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1156: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1157: -- print reporting depreciation summary
1158: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REPORT_DEPR_SUMRY'));
1159: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

Line 1156: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

1152: END LOOP;
1153: END IF;
1154:
1155: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1156: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1157: -- print reporting depreciation summary
1158: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REPORT_DEPR_SUMRY'));
1159: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1160: -- Create Report Content

Line 1158: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REPORT_DEPR_SUMRY'));

1154:
1155: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1156: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1157: -- print reporting depreciation summary
1158: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REPORT_DEPR_SUMRY'));
1159: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1160: -- Create Report Content
1161: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CURRENCY')||': '||l_currency_code);
1162: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_ADA_RPT_AST_CAT_PROMPT'),35)

Line 1159: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

1155: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1156: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1157: -- print reporting depreciation summary
1158: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REPORT_DEPR_SUMRY'));
1159: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1160: -- Create Report Content
1161: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CURRENCY')||': '||l_currency_code);
1162: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_ADA_RPT_AST_CAT_PROMPT'),35)
1163: ||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_ACTIVITY'),23)

Line 1161: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CURRENCY')||': '||l_currency_code);

1157: -- print reporting depreciation summary
1158: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REPORT_DEPR_SUMRY'));
1159: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1160: -- Create Report Content
1161: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CURRENCY')||': '||l_currency_code);
1162: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_ADA_RPT_AST_CAT_PROMPT'),35)
1163: ||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_ACTIVITY'),23)
1164: ||LPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_AMT_TITLE'),18));
1165:

Line 1162: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_ADA_RPT_AST_CAT_PROMPT'),35)

1158: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_MGP_REPORT_DEPR_SUMRY'));
1159: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1160: -- Create Report Content
1161: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CURRENCY')||': '||l_currency_code);
1162: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_ADA_RPT_AST_CAT_PROMPT'),35)
1163: ||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_ACTIVITY'),23)
1164: ||LPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_AMT_TITLE'),18));
1165:
1166: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_ADA_RPT_AST_CAT_UNDERLINE'),35)

Line 1166: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_ADA_RPT_AST_CAT_UNDERLINE'),35)

1162: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_ADA_RPT_AST_CAT_PROMPT'),35)
1163: ||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_ACTIVITY'),23)
1164: ||LPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_AMT_TITLE'),18));
1165:
1166: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_ADA_RPT_AST_CAT_UNDERLINE'),35)
1167: ||RPAD(FND_MESSAGE.GET_STRING('OKL','OKL_ADA_RPT_ACTIVITY_UNDERLINE'),23)
1168: ||LPAD(FND_MESSAGE.GET_STRING('OKL','OKL_GLP_RPT_AMT_LINE'),18));
1169:
1170: IF l_report_deprn_tbl.COUNT > 0 THEN

Line 1174: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_report_deprn_tbl(k).category_name,35)||

1170: IF l_report_deprn_tbl.COUNT > 0 THEN
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)||

Line 1178: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,RPAD(l_report_deprn_tbl(k).category_name,35)||

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)||
1180: LPAD(ABS(l_report_deprn_tbl(k).deprn_amount),18));
1181: END IF;
1182: END LOOP;

Line 1185: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

1181: END IF;
1182: END LOOP;
1183: END IF;
1184:
1185: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1186: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNTRCT_ERROR_TITLE'));
1187: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNT_ERR_UNDERLINE'));
1188: IF l_contract_error_tbl.COUNT > 0 THEN
1189: FOR x IN l_contract_error_tbl.FIRST..l_contract_error_tbl.LAST

Line 1186: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNTRCT_ERROR_TITLE'));

1182: END LOOP;
1183: END IF;
1184:
1185: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1186: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNTRCT_ERROR_TITLE'));
1187: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNT_ERR_UNDERLINE'));
1188: IF l_contract_error_tbl.COUNT > 0 THEN
1189: FOR x IN l_contract_error_tbl.FIRST..l_contract_error_tbl.LAST
1190: LOOP

Line 1187: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNT_ERR_UNDERLINE'));

1183: END IF;
1184:
1185: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1186: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNTRCT_ERROR_TITLE'));
1187: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNT_ERR_UNDERLINE'));
1188: IF l_contract_error_tbl.COUNT > 0 THEN
1189: FOR x IN l_contract_error_tbl.FIRST..l_contract_error_tbl.LAST
1190: LOOP
1191: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_contract_error_tbl(x));

Line 1191: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_contract_error_tbl(x));

1187: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_CNT_ERR_UNDERLINE'));
1188: IF l_contract_error_tbl.COUNT > 0 THEN
1189: FOR x IN l_contract_error_tbl.FIRST..l_contract_error_tbl.LAST
1190: LOOP
1191: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_contract_error_tbl(x));
1192: END LOOP;
1193: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1194: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_ADD_INFO'));
1195: END IF;

Line 1193: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

1189: FOR x IN l_contract_error_tbl.FIRST..l_contract_error_tbl.LAST
1190: LOOP
1191: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_contract_error_tbl(x));
1192: END LOOP;
1193: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1194: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_ADD_INFO'));
1195: END IF;
1196:
1197: retcode := 0;

Line 1194: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_ADD_INFO'));

1190: LOOP
1191: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_contract_error_tbl(x));
1192: END LOOP;
1193: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');
1194: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_ADD_INFO'));
1195: END IF;
1196:
1197: retcode := 0;
1198: l_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 1205: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'');

1201: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1202: l_return_status := Okl_Api.G_RET_STS_ERROR;
1203:
1204: -- print the error message in the log file
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);

Line 1206: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_ERROR'));

1202: l_return_status := Okl_Api.G_RET_STS_ERROR;
1203:
1204: -- print the error message in the log file
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

Line 1207: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')

1203:
1204: -- print the error message in the log file
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

Line 1214: FND_FILE.PUT_LINE(FND_FILE.LOG, l_outer_error_msg_tbl(i));

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
1214: FND_FILE.PUT_LINE(FND_FILE.LOG, l_outer_error_msg_tbl(i));
1215: END IF;
1216: END LOOP;
1217: END IF;
1218: retcode := 0;

Line 1224: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')

1220: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1221: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
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

Line 1231: FND_FILE.PUT_LINE(FND_FILE.LOG, l_outer_error_msg_tbl(i));

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
1231: FND_FILE.PUT_LINE(FND_FILE.LOG, l_outer_error_msg_tbl(i));
1232: END IF;
1233: END LOOP;
1234: END IF;
1235:

Line 1247: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET_STRING('OKL','OKL_AGN_RPT_PROGRAM_STATUS')

1243:
1244: l_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
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

Line 1254: FND_FILE.PUT_LINE(FND_FILE.LOG, l_outer_error_msg_tbl(i));

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
1254: FND_FILE.PUT_LINE(FND_FILE.LOG, l_outer_error_msg_tbl(i));
1255: END IF;
1256: END LOOP;
1257: END IF;
1258: