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_ACCOUNTING_UTIL

Line 4: SUBTYPE error_message_type IS Okl_Accounting_Util.ERROR_MESSAGE_TYPE;

1: PACKAGE BODY OKL_STREAMS_RECON_PVT AS
2: /* $Header: OKLRSCRB.pls 120.10 2007/06/21 14:34:24 varangan noship $ */
3:
4: SUBTYPE error_message_type IS Okl_Accounting_Util.ERROR_MESSAGE_TYPE;
5:
6: --------------------------------------------------------------------------------
7: -- Start of Commnets
8: -- Badrinath Kuchibhotla

Line 536: fnd_file.put_line(fnd_file.log,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_ERROR_ACTIVITY'),1,30));

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));
540: RAISE okl_api.g_exception_error;

Line 539: fnd_file.put_line(fnd_file.log,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_ERROR_ACTIVITY'),1,30));

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));
543: fnd_file.put_line(fnd_file.log,delimit);

Line 542: fnd_file.put_line(fnd_file.log,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_START_ACTIVITY'),1,34));

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
545: -- Since the parametr we use in the concurrent program is fnd_standard_date
546: IF p_end_date IS NOT NULL THEN

Line 554: fnd_file.put_line(fnd_file.log,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_ERROR_ORG'),1,36));

550: OPEN get_org_id;
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

Line 559: fnd_file.put_line(fnd_file.log, SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_GEN_SUM'),1,52));

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));
560: fnd_file.put_line(fnd_file.log, ' ');
561: fnd_file.put_line(fnd_file.output,RPAD(delimit,55)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_ACCT_LEASE_MANAGEMENT'),1,30)||LPAD(delimit,55));
562: fnd_file.put_line(fnd_file.output,RPAD(delimit,47)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_RECON_PROCESS_REPORT'),1,50)||LPAD(delimit,47));
563: fnd_file.put_line(fnd_file.output,RPAD(delimit,47)||RPAD(lv_dash,38,lv_dash)||LPAD(delimit,47));

Line 561: fnd_file.put_line(fnd_file.output,RPAD(delimit,55)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_ACCT_LEASE_MANAGEMENT'),1,30)||LPAD(delimit,55));

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));
560: fnd_file.put_line(fnd_file.log, ' ');
561: fnd_file.put_line(fnd_file.output,RPAD(delimit,55)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_ACCT_LEASE_MANAGEMENT'),1,30)||LPAD(delimit,55));
562: fnd_file.put_line(fnd_file.output,RPAD(delimit,47)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_RECON_PROCESS_REPORT'),1,50)||LPAD(delimit,47));
563: fnd_file.put_line(fnd_file.output,RPAD(delimit,47)||RPAD(lv_dash,38,lv_dash)||LPAD(delimit,47));
564: fnd_file.put_line(fnd_file.output,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_RUN_DATE'),1,12)||RPAD(delimit,8)||': '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
565: fnd_file.put_line(fnd_file.output,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_OPERUNIT'),1,20)||RPAD(delimit,2)||': '||lv_org_name);

Line 562: fnd_file.put_line(fnd_file.output,RPAD(delimit,47)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_RECON_PROCESS_REPORT'),1,50)||LPAD(delimit,47));

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));
560: fnd_file.put_line(fnd_file.log, ' ');
561: fnd_file.put_line(fnd_file.output,RPAD(delimit,55)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_ACCT_LEASE_MANAGEMENT'),1,30)||LPAD(delimit,55));
562: fnd_file.put_line(fnd_file.output,RPAD(delimit,47)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_RECON_PROCESS_REPORT'),1,50)||LPAD(delimit,47));
563: fnd_file.put_line(fnd_file.output,RPAD(delimit,47)||RPAD(lv_dash,38,lv_dash)||LPAD(delimit,47));
564: fnd_file.put_line(fnd_file.output,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_RUN_DATE'),1,12)||RPAD(delimit,8)||': '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
565: fnd_file.put_line(fnd_file.output,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_OPERUNIT'),1,20)||RPAD(delimit,2)||': '||lv_org_name);
566: fnd_file.put_line(fnd_file.output,delimit);

Line 564: fnd_file.put_line(fnd_file.output,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_RUN_DATE'),1,12)||RPAD(delimit,8)||': '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));

560: fnd_file.put_line(fnd_file.log, ' ');
561: fnd_file.put_line(fnd_file.output,RPAD(delimit,55)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_ACCT_LEASE_MANAGEMENT'),1,30)||LPAD(delimit,55));
562: fnd_file.put_line(fnd_file.output,RPAD(delimit,47)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_RECON_PROCESS_REPORT'),1,50)||LPAD(delimit,47));
563: fnd_file.put_line(fnd_file.output,RPAD(delimit,47)||RPAD(lv_dash,38,lv_dash)||LPAD(delimit,47));
564: fnd_file.put_line(fnd_file.output,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_RUN_DATE'),1,12)||RPAD(delimit,8)||': '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
565: fnd_file.put_line(fnd_file.output,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_OPERUNIT'),1,20)||RPAD(delimit,2)||': '||lv_org_name);
566: fnd_file.put_line(fnd_file.output,delimit);
567: fnd_file.put_line(fnd_file.output,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_PARAMETERS'),1,13));
568: fnd_file.put_line(fnd_file.output,RPAD(lv_dash,13,lv_dash));

Line 565: fnd_file.put_line(fnd_file.output,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_OPERUNIT'),1,20)||RPAD(delimit,2)||': '||lv_org_name);

561: fnd_file.put_line(fnd_file.output,RPAD(delimit,55)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_ACCT_LEASE_MANAGEMENT'),1,30)||LPAD(delimit,55));
562: fnd_file.put_line(fnd_file.output,RPAD(delimit,47)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_RECON_PROCESS_REPORT'),1,50)||LPAD(delimit,47));
563: fnd_file.put_line(fnd_file.output,RPAD(delimit,47)||RPAD(lv_dash,38,lv_dash)||LPAD(delimit,47));
564: fnd_file.put_line(fnd_file.output,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_RUN_DATE'),1,12)||RPAD(delimit,8)||': '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
565: fnd_file.put_line(fnd_file.output,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_OPERUNIT'),1,20)||RPAD(delimit,2)||': '||lv_org_name);
566: fnd_file.put_line(fnd_file.output,delimit);
567: fnd_file.put_line(fnd_file.output,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_PARAMETERS'),1,13));
568: fnd_file.put_line(fnd_file.output,RPAD(lv_dash,13,lv_dash));
569: lp_contract_number := SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_CONTRACT_NUMBER'),1,20)||RPAD(delimit,1)||': ';

Line 567: fnd_file.put_line(fnd_file.output,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_PARAMETERS'),1,13));

563: fnd_file.put_line(fnd_file.output,RPAD(delimit,47)||RPAD(lv_dash,38,lv_dash)||LPAD(delimit,47));
564: fnd_file.put_line(fnd_file.output,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_RUN_DATE'),1,12)||RPAD(delimit,8)||': '||to_char(sysdate,'DD-MON-YYYY HH24:MI'));
565: fnd_file.put_line(fnd_file.output,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_OPERUNIT'),1,20)||RPAD(delimit,2)||': '||lv_org_name);
566: fnd_file.put_line(fnd_file.output,delimit);
567: fnd_file.put_line(fnd_file.output,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_PARAMETERS'),1,13));
568: fnd_file.put_line(fnd_file.output,RPAD(lv_dash,13,lv_dash));
569: lp_contract_number := SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_CONTRACT_NUMBER'),1,20)||RPAD(delimit,1)||': ';
570: fnd_file.put_line(fnd_file.output,lp_contract_number||NVL(p_contract_number,okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_NOT_SUPPLIED')));
571: lp_end_date := SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_END_DATE'),1,12)||RPAD(delimit,8)||': ';

Line 569: lp_contract_number := SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_CONTRACT_NUMBER'),1,20)||RPAD(delimit,1)||': ';

565: fnd_file.put_line(fnd_file.output,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_OPERUNIT'),1,20)||RPAD(delimit,2)||': '||lv_org_name);
566: fnd_file.put_line(fnd_file.output,delimit);
567: fnd_file.put_line(fnd_file.output,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_PARAMETERS'),1,13));
568: fnd_file.put_line(fnd_file.output,RPAD(lv_dash,13,lv_dash));
569: lp_contract_number := SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_CONTRACT_NUMBER'),1,20)||RPAD(delimit,1)||': ';
570: fnd_file.put_line(fnd_file.output,lp_contract_number||NVL(p_contract_number,okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_NOT_SUPPLIED')));
571: lp_end_date := SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_END_DATE'),1,12)||RPAD(delimit,8)||': ';
572: fnd_file.put_line(fnd_file.output,lp_end_date||NVL(p_end_date,okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_NOT_SUPPLIED')));
573: fnd_file.put_line(fnd_file.output,delimit);

Line 570: fnd_file.put_line(fnd_file.output,lp_contract_number||NVL(p_contract_number,okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_NOT_SUPPLIED')));

566: fnd_file.put_line(fnd_file.output,delimit);
567: fnd_file.put_line(fnd_file.output,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_PARAMETERS'),1,13));
568: fnd_file.put_line(fnd_file.output,RPAD(lv_dash,13,lv_dash));
569: lp_contract_number := SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_CONTRACT_NUMBER'),1,20)||RPAD(delimit,1)||': ';
570: fnd_file.put_line(fnd_file.output,lp_contract_number||NVL(p_contract_number,okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_NOT_SUPPLIED')));
571: lp_end_date := SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_END_DATE'),1,12)||RPAD(delimit,8)||': ';
572: fnd_file.put_line(fnd_file.output,lp_end_date||NVL(p_end_date,okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_NOT_SUPPLIED')));
573: fnd_file.put_line(fnd_file.output,delimit);
574: -- Filling in the summary section of the report file

Line 571: lp_end_date := SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_END_DATE'),1,12)||RPAD(delimit,8)||': ';

567: fnd_file.put_line(fnd_file.output,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_PARAMETERS'),1,13));
568: fnd_file.put_line(fnd_file.output,RPAD(lv_dash,13,lv_dash));
569: lp_contract_number := SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_CONTRACT_NUMBER'),1,20)||RPAD(delimit,1)||': ';
570: fnd_file.put_line(fnd_file.output,lp_contract_number||NVL(p_contract_number,okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_NOT_SUPPLIED')));
571: lp_end_date := SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_END_DATE'),1,12)||RPAD(delimit,8)||': ';
572: fnd_file.put_line(fnd_file.output,lp_end_date||NVL(p_end_date,okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_NOT_SUPPLIED')));
573: fnd_file.put_line(fnd_file.output,delimit);
574: -- Filling in the summary section of the report file
575: -- Now we are populating the FND_FILE to display the above resultant record

Line 572: fnd_file.put_line(fnd_file.output,lp_end_date||NVL(p_end_date,okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_NOT_SUPPLIED')));

568: fnd_file.put_line(fnd_file.output,RPAD(lv_dash,13,lv_dash));
569: lp_contract_number := SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_CONTRACT_NUMBER'),1,20)||RPAD(delimit,1)||': ';
570: fnd_file.put_line(fnd_file.output,lp_contract_number||NVL(p_contract_number,okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_NOT_SUPPLIED')));
571: lp_end_date := SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_END_DATE'),1,12)||RPAD(delimit,8)||': ';
572: fnd_file.put_line(fnd_file.output,lp_end_date||NVL(p_end_date,okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_NOT_SUPPLIED')));
573: fnd_file.put_line(fnd_file.output,delimit);
574: -- Filling in the summary section of the report file
575: -- Now we are populating the FND_FILE to display the above resultant record
576: fnd_file.put_line(fnd_file.output,RPAD(delimit,12)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_SUMMARY'),1,10));

Line 576: fnd_file.put_line(fnd_file.output,RPAD(delimit,12)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_SUMMARY'),1,10));

572: fnd_file.put_line(fnd_file.output,lp_end_date||NVL(p_end_date,okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_NOT_SUPPLIED')));
573: fnd_file.put_line(fnd_file.output,delimit);
574: -- Filling in the summary section of the report file
575: -- Now we are populating the FND_FILE to display the above resultant record
576: fnd_file.put_line(fnd_file.output,RPAD(delimit,12)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_SUMMARY'),1,10));
577: fnd_file.put_line(fnd_file.output,RPAD(delimit,12)||RPAD(lv_dash,7,lv_dash));
578: fnd_file.put_line(fnd_file.output,delimit);
579: lv_sum_bil_dash := RPAD(delimit,45);
580: lv_tot_amt := RPAD(delimit,15)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_TOT_BILL_STREAM'),1,29)||RPAD(delimit,7)||':';

Line 580: lv_tot_amt := RPAD(delimit,15)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_TOT_BILL_STREAM'),1,29)||RPAD(delimit,7)||':';

576: fnd_file.put_line(fnd_file.output,RPAD(delimit,12)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_SUMMARY'),1,10));
577: fnd_file.put_line(fnd_file.output,RPAD(delimit,12)||RPAD(lv_dash,7,lv_dash));
578: fnd_file.put_line(fnd_file.output,delimit);
579: lv_sum_bil_dash := RPAD(delimit,45);
580: lv_tot_amt := RPAD(delimit,15)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_TOT_BILL_STREAM'),1,29)||RPAD(delimit,7)||':';
581: lv_bil_amt := RPAD(delimit,15)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_BILL_STREAM'),1,25)||RPAD(delimit,10)||':';
582: lv_can_amt := RPAD(delimit,15)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_CANCEL_STREAM'),1,29)||RPAD(delimit,7)||':';
583: lv_clb_amt := RPAD(delimit,15)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_UNBILL_STREAM'),1,28)||RPAD(delimit,8)||':';
584: lv_dif_amt := RPAD(delimit,15)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_DIFF_STREAM'),1,13)||RPAD(delimit,19)||':';

Line 581: lv_bil_amt := RPAD(delimit,15)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_BILL_STREAM'),1,25)||RPAD(delimit,10)||':';

577: fnd_file.put_line(fnd_file.output,RPAD(delimit,12)||RPAD(lv_dash,7,lv_dash));
578: fnd_file.put_line(fnd_file.output,delimit);
579: lv_sum_bil_dash := RPAD(delimit,45);
580: lv_tot_amt := RPAD(delimit,15)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_TOT_BILL_STREAM'),1,29)||RPAD(delimit,7)||':';
581: lv_bil_amt := RPAD(delimit,15)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_BILL_STREAM'),1,25)||RPAD(delimit,10)||':';
582: lv_can_amt := RPAD(delimit,15)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_CANCEL_STREAM'),1,29)||RPAD(delimit,7)||':';
583: lv_clb_amt := RPAD(delimit,15)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_UNBILL_STREAM'),1,28)||RPAD(delimit,8)||':';
584: lv_dif_amt := RPAD(delimit,15)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_DIFF_STREAM'),1,13)||RPAD(delimit,19)||':';
585: lv_dif_amt1 := RPAD(delimit,45);

Line 582: lv_can_amt := RPAD(delimit,15)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_CANCEL_STREAM'),1,29)||RPAD(delimit,7)||':';

578: fnd_file.put_line(fnd_file.output,delimit);
579: lv_sum_bil_dash := RPAD(delimit,45);
580: lv_tot_amt := RPAD(delimit,15)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_TOT_BILL_STREAM'),1,29)||RPAD(delimit,7)||':';
581: lv_bil_amt := RPAD(delimit,15)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_BILL_STREAM'),1,25)||RPAD(delimit,10)||':';
582: lv_can_amt := RPAD(delimit,15)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_CANCEL_STREAM'),1,29)||RPAD(delimit,7)||':';
583: lv_clb_amt := RPAD(delimit,15)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_UNBILL_STREAM'),1,28)||RPAD(delimit,8)||':';
584: lv_dif_amt := RPAD(delimit,15)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_DIFF_STREAM'),1,13)||RPAD(delimit,19)||':';
585: lv_dif_amt1 := RPAD(delimit,45);
586: lv_dif_amt2 := RPAD(delimit,45);

Line 583: lv_clb_amt := RPAD(delimit,15)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_UNBILL_STREAM'),1,28)||RPAD(delimit,8)||':';

579: lv_sum_bil_dash := RPAD(delimit,45);
580: lv_tot_amt := RPAD(delimit,15)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_TOT_BILL_STREAM'),1,29)||RPAD(delimit,7)||':';
581: lv_bil_amt := RPAD(delimit,15)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_BILL_STREAM'),1,25)||RPAD(delimit,10)||':';
582: lv_can_amt := RPAD(delimit,15)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_CANCEL_STREAM'),1,29)||RPAD(delimit,7)||':';
583: lv_clb_amt := RPAD(delimit,15)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_UNBILL_STREAM'),1,28)||RPAD(delimit,8)||':';
584: lv_dif_amt := RPAD(delimit,15)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_DIFF_STREAM'),1,13)||RPAD(delimit,19)||':';
585: lv_dif_amt1 := RPAD(delimit,45);
586: lv_dif_amt2 := RPAD(delimit,45);
587: lv_sum_bil_dash := lv_sum_bil_dash||RPAD(lv_dash,22,lv_dash)||RPAD(delimit,1);

Line 584: lv_dif_amt := RPAD(delimit,15)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_DIFF_STREAM'),1,13)||RPAD(delimit,19)||':';

580: lv_tot_amt := RPAD(delimit,15)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_TOT_BILL_STREAM'),1,29)||RPAD(delimit,7)||':';
581: lv_bil_amt := RPAD(delimit,15)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_BILL_STREAM'),1,25)||RPAD(delimit,10)||':';
582: lv_can_amt := RPAD(delimit,15)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_CANCEL_STREAM'),1,29)||RPAD(delimit,7)||':';
583: lv_clb_amt := RPAD(delimit,15)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_UNBILL_STREAM'),1,28)||RPAD(delimit,8)||':';
584: lv_dif_amt := RPAD(delimit,15)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_DIFF_STREAM'),1,13)||RPAD(delimit,19)||':';
585: lv_dif_amt1 := RPAD(delimit,45);
586: lv_dif_amt2 := RPAD(delimit,45);
587: lv_sum_bil_dash := lv_sum_bil_dash||RPAD(lv_dash,22,lv_dash)||RPAD(delimit,1);
588: FOR get_currency_code_rec IN get_currency_code(p_org_id => ln_org_id,

Line 591: fnd_file.put_line(fnd_file.output,delimit||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_CURRENCY'),1,11)||' : '||get_currency_code_rec.currency_code);

587: lv_sum_bil_dash := lv_sum_bil_dash||RPAD(lv_dash,22,lv_dash)||RPAD(delimit,1);
588: FOR get_currency_code_rec IN get_currency_code(p_org_id => ln_org_id,
589: p_contract_number => p_contract_number,
590: p_end_date => lv_end_date) LOOP
591: fnd_file.put_line(fnd_file.output,delimit||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_CURRENCY'),1,11)||' : '||get_currency_code_rec.currency_code);
592: fnd_file.put_line(fnd_file.output,delimit);
593: -- To get total streams total
594: OPEN get_total_csr(p_org_id => ln_org_id,
595: p_curr_code => get_currency_code_rec.currency_code,

Line 674: fnd_file.put_line(fnd_file.log, SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_GEN_DETAIL_UNBILL'),1,64));

670: fnd_file.put_line(fnd_file.output,delimit);
671: a := a + 1;
672: END LOOP;
673: -- Filling in the Details section of the unbilled Streams report file
674: fnd_file.put_line(fnd_file.log, SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_GEN_DETAIL_UNBILL'),1,64));
675: fnd_file.put_line(fnd_file.log, ' ');
676: IF lt_value_tbl.COUNT > 0 THEN
677: FOR i IN lt_value_tbl.FIRST..lt_value_tbl.LAST LOOP
678: IF lt_value_tbl(i).clb_amt <> 0 THEN

Line 686: fnd_file.put_line(fnd_file.output,RPAD(delimit,12)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_DLTS_UNBILLED_STREAM'),1,36));

682: lv_value_clb := 'N';
683: END IF;
684: END LOOP;
685: END IF;
686: fnd_file.put_line(fnd_file.output,RPAD(delimit,12)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_DLTS_UNBILLED_STREAM'),1,36));
687: fnd_file.put_line(fnd_file.output,RPAD(delimit,12)||RPAD(lv_dash,27,lv_dash));
688: fnd_file.put_line(fnd_file.output,delimit);
689: IF lv_value_clb = 'Y' THEN
690: -- To get details of Closing balance based on the deal type and

Line 711: lv_dlt_curr_code := delimit||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_CURRENCY'),1,11)||' : '||lt_curr_tbl(m);

707: k := k + 1;
708: END IF;
709: END LOOP;
710: FOR m IN lt_curr_tbl.FIRST..lt_curr_tbl.LAST LOOP
711: lv_dlt_curr_code := delimit||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_CURRENCY'),1,11)||' : '||lt_curr_tbl(m);
712: fnd_file.put_line(fnd_file.output,lv_dlt_curr_code);
713: fnd_file.put_line(fnd_file.output,delimit);
714: lv_dlt_tot_amt := NULL;
715: lv_dlt_amt := NULL;

Line 718: lv_dlt_book := delimit||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_BOOK_CLASSIFICATION'),1,25)||delimit||lv_dash||delimit;

714: lv_dlt_tot_amt := NULL;
715: lv_dlt_amt := NULL;
716: ln_dlt_tot_amt := 0;
717: ln_dlt_amt := 0;
718: lv_dlt_book := delimit||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_BOOK_CLASSIFICATION'),1,25)||delimit||lv_dash||delimit;
719: lv_dlt_pdt := RPAD(delimit,10)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_FINANCIAL_PRODUCT'),1,23)||delimit;
720: FOR j IN lt_unbill_tbl.FIRST..lt_unbill_tbl.LAST LOOP
721: IF lv_book_class <> lt_unbill_tbl(j).book_class AND
722: lt_unbill_tbl(j).currency_code = lt_curr_tbl(m) THEN

Line 719: lv_dlt_pdt := RPAD(delimit,10)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_FINANCIAL_PRODUCT'),1,23)||delimit;

715: lv_dlt_amt := NULL;
716: ln_dlt_tot_amt := 0;
717: ln_dlt_amt := 0;
718: lv_dlt_book := delimit||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_BOOK_CLASSIFICATION'),1,25)||delimit||lv_dash||delimit;
719: lv_dlt_pdt := RPAD(delimit,10)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_FINANCIAL_PRODUCT'),1,23)||delimit;
720: FOR j IN lt_unbill_tbl.FIRST..lt_unbill_tbl.LAST LOOP
721: IF lv_book_class <> lt_unbill_tbl(j).book_class AND
722: lt_unbill_tbl(j).currency_code = lt_curr_tbl(m) THEN
723: fnd_file.put_line(fnd_file.output,lv_dlt_book||lt_unbill_tbl(j).book_class);

Line 737: lv_dlt_amt := RPAD(delimit,15)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_TOTAL'),1,7)||RPAD(delimit,24)||':';

733: ln_dlt_tot_amt := ln_dlt_tot_amt + lt_unbill_tbl(h).amount;
734: END IF;
735: END LOOP;
736: fnd_file.put_line(fnd_file.output,RPAD(delimit,45)||RPAD(lv_dash,22,lv_dash));
737: lv_dlt_amt := RPAD(delimit,15)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_TOTAL'),1,7)||RPAD(delimit,24)||':';
738: lv_dlt_amt := lv_dlt_amt||LPAD(SUBSTR(LTRIM(RTRIM(TO_CHAR(NVL(ln_dlt_amt,0),lv_frm_amt))),1,22),22);
739: fnd_file.put_line(fnd_file.output,lv_dlt_amt);
740: END IF;
741: END LOOP;

Line 743: lv_dlt_tot_amt := RPAD(delimit,15)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_TOTAL_UNBILL_STREAM'),1,29)||RPAD(delimit,7)||':';

739: fnd_file.put_line(fnd_file.output,lv_dlt_amt);
740: END IF;
741: END LOOP;
742: fnd_file.put_line(fnd_file.output,RPAD(delimit,45)||RPAD(lv_dash,22,lv_dash));
743: lv_dlt_tot_amt := RPAD(delimit,15)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_TOTAL_UNBILL_STREAM'),1,29)||RPAD(delimit,7)||':';
744: lv_dlt_tot_amt := lv_dlt_tot_amt||LPAD(SUBSTR(LTRIM(RTRIM(TO_CHAR(NVL(ln_dlt_tot_amt,0),lv_frm_amt))),1,22),22);
745: fnd_file.put_line(fnd_file.output,lv_dlt_tot_amt);
746: fnd_file.put_line(fnd_file.output,RPAD(delimit,45)||RPAD(lv_dash,22,lv_dash));
747: END LOOP;

Line 750: fnd_file.put_line(fnd_file.output,RPAD(delimit,12)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_NO_RECORDS'),1,21));

746: fnd_file.put_line(fnd_file.output,RPAD(delimit,45)||RPAD(lv_dash,22,lv_dash));
747: END LOOP;
748: END IF;
749: ELSIF lv_value_clb = 'N' THEN
750: fnd_file.put_line(fnd_file.output,RPAD(delimit,12)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_NO_RECORDS'),1,21));
751: END IF;
752: -- Filling in the Details section of the Difference report file
753: fnd_file.put_line(fnd_file.log, SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_GEN_DETAIL_DIFF'),1,67));
754: fnd_file.put_line(fnd_file.log, ' ');

Line 753: fnd_file.put_line(fnd_file.log, SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_GEN_DETAIL_DIFF'),1,67));

749: ELSIF lv_value_clb = 'N' THEN
750: fnd_file.put_line(fnd_file.output,RPAD(delimit,12)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_NO_RECORDS'),1,21));
751: END IF;
752: -- Filling in the Details section of the Difference report file
753: fnd_file.put_line(fnd_file.log, SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_GEN_DETAIL_DIFF'),1,67));
754: fnd_file.put_line(fnd_file.log, ' ');
755: fnd_file.put_line(fnd_file.output,delimit);
756: fnd_file.put_line(fnd_file.output,RPAD(delimit,12)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_DLTS_DIFF_STREAM'),1,38));
757: fnd_file.put_line(fnd_file.output,RPAD(delimit,12)||RPAD(lv_dash,29,lv_dash));

Line 756: fnd_file.put_line(fnd_file.output,RPAD(delimit,12)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_DLTS_DIFF_STREAM'),1,38));

752: -- Filling in the Details section of the Difference report file
753: fnd_file.put_line(fnd_file.log, SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_GEN_DETAIL_DIFF'),1,67));
754: fnd_file.put_line(fnd_file.log, ' ');
755: fnd_file.put_line(fnd_file.output,delimit);
756: fnd_file.put_line(fnd_file.output,RPAD(delimit,12)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_DLTS_DIFF_STREAM'),1,38));
757: fnd_file.put_line(fnd_file.output,RPAD(delimit,12)||RPAD(lv_dash,29,lv_dash));
758: fnd_file.put_line(fnd_file.output,delimit);
759: FOR get_diff_rec IN get_diff_csr(p_org_id => ln_org_id,
760: p_contract_number => p_contract_number,

Line 809: lv_diff_dlts := lv_diff_dlts||okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_CONTRACT_NUMBER')||RPAD(delimit,1);

805: END IF;
806: END IF;
807: END LOOP;
808: lv_diff_dlts := delimit;
809: lv_diff_dlts := lv_diff_dlts||okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_CONTRACT_NUMBER')||RPAD(delimit,1);
810: lv_diff_dlts := lv_diff_dlts||okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_TOT_BILL_STREAM')||RPAD(delimit,1);
811: lv_diff_dlts := lv_diff_dlts||LPAD(SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_BILL_STREAM'),5),22)||RPAD(delimit,1);
812: lv_diff_dlts := lv_diff_dlts||LPAD(SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_CANCEL_STREAM'),5),22)||RPAD(delimit,1);
813: lv_diff_dlts := lv_diff_dlts||LPAD(SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_UNBILL_STREAM'),5),22)||RPAD(delimit,1);

Line 810: lv_diff_dlts := lv_diff_dlts||okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_TOT_BILL_STREAM')||RPAD(delimit,1);

806: END IF;
807: END LOOP;
808: lv_diff_dlts := delimit;
809: lv_diff_dlts := lv_diff_dlts||okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_CONTRACT_NUMBER')||RPAD(delimit,1);
810: lv_diff_dlts := lv_diff_dlts||okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_TOT_BILL_STREAM')||RPAD(delimit,1);
811: lv_diff_dlts := lv_diff_dlts||LPAD(SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_BILL_STREAM'),5),22)||RPAD(delimit,1);
812: lv_diff_dlts := lv_diff_dlts||LPAD(SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_CANCEL_STREAM'),5),22)||RPAD(delimit,1);
813: lv_diff_dlts := lv_diff_dlts||LPAD(SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_UNBILL_STREAM'),5),22)||RPAD(delimit,1);
814: lv_diff_dlts := lv_diff_dlts||LPAD(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_DIFF_STREAM'),22)||RPAD(delimit,1);

Line 811: lv_diff_dlts := lv_diff_dlts||LPAD(SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_BILL_STREAM'),5),22)||RPAD(delimit,1);

807: END LOOP;
808: lv_diff_dlts := delimit;
809: lv_diff_dlts := lv_diff_dlts||okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_CONTRACT_NUMBER')||RPAD(delimit,1);
810: lv_diff_dlts := lv_diff_dlts||okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_TOT_BILL_STREAM')||RPAD(delimit,1);
811: lv_diff_dlts := lv_diff_dlts||LPAD(SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_BILL_STREAM'),5),22)||RPAD(delimit,1);
812: lv_diff_dlts := lv_diff_dlts||LPAD(SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_CANCEL_STREAM'),5),22)||RPAD(delimit,1);
813: lv_diff_dlts := lv_diff_dlts||LPAD(SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_UNBILL_STREAM'),5),22)||RPAD(delimit,1);
814: lv_diff_dlts := lv_diff_dlts||LPAD(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_DIFF_STREAM'),22)||RPAD(delimit,1);
815: lv_diff_dlts_dash := delimit;

Line 812: lv_diff_dlts := lv_diff_dlts||LPAD(SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_CANCEL_STREAM'),5),22)||RPAD(delimit,1);

808: lv_diff_dlts := delimit;
809: lv_diff_dlts := lv_diff_dlts||okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_CONTRACT_NUMBER')||RPAD(delimit,1);
810: lv_diff_dlts := lv_diff_dlts||okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_TOT_BILL_STREAM')||RPAD(delimit,1);
811: lv_diff_dlts := lv_diff_dlts||LPAD(SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_BILL_STREAM'),5),22)||RPAD(delimit,1);
812: lv_diff_dlts := lv_diff_dlts||LPAD(SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_CANCEL_STREAM'),5),22)||RPAD(delimit,1);
813: lv_diff_dlts := lv_diff_dlts||LPAD(SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_UNBILL_STREAM'),5),22)||RPAD(delimit,1);
814: lv_diff_dlts := lv_diff_dlts||LPAD(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_DIFF_STREAM'),22)||RPAD(delimit,1);
815: lv_diff_dlts_dash := delimit;
816: lv_diff_dlts_dash := lv_diff_dlts_dash||RPAD(lv_dash,15,lv_dash)||RPAD(delimit,1);

Line 813: lv_diff_dlts := lv_diff_dlts||LPAD(SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_UNBILL_STREAM'),5),22)||RPAD(delimit,1);

809: lv_diff_dlts := lv_diff_dlts||okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_CONTRACT_NUMBER')||RPAD(delimit,1);
810: lv_diff_dlts := lv_diff_dlts||okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_TOT_BILL_STREAM')||RPAD(delimit,1);
811: lv_diff_dlts := lv_diff_dlts||LPAD(SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_BILL_STREAM'),5),22)||RPAD(delimit,1);
812: lv_diff_dlts := lv_diff_dlts||LPAD(SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_CANCEL_STREAM'),5),22)||RPAD(delimit,1);
813: lv_diff_dlts := lv_diff_dlts||LPAD(SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_UNBILL_STREAM'),5),22)||RPAD(delimit,1);
814: lv_diff_dlts := lv_diff_dlts||LPAD(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_DIFF_STREAM'),22)||RPAD(delimit,1);
815: lv_diff_dlts_dash := delimit;
816: lv_diff_dlts_dash := lv_diff_dlts_dash||RPAD(lv_dash,15,lv_dash)||RPAD(delimit,1);
817: lv_diff_dlts_dash := lv_diff_dlts_dash||RPAD(lv_dash,22,lv_dash)||RPAD(delimit,1);

Line 814: lv_diff_dlts := lv_diff_dlts||LPAD(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_DIFF_STREAM'),22)||RPAD(delimit,1);

810: lv_diff_dlts := lv_diff_dlts||okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_TOT_BILL_STREAM')||RPAD(delimit,1);
811: lv_diff_dlts := lv_diff_dlts||LPAD(SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_BILL_STREAM'),5),22)||RPAD(delimit,1);
812: lv_diff_dlts := lv_diff_dlts||LPAD(SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_CANCEL_STREAM'),5),22)||RPAD(delimit,1);
813: lv_diff_dlts := lv_diff_dlts||LPAD(SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_UNBILL_STREAM'),5),22)||RPAD(delimit,1);
814: lv_diff_dlts := lv_diff_dlts||LPAD(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_DIFF_STREAM'),22)||RPAD(delimit,1);
815: lv_diff_dlts_dash := delimit;
816: lv_diff_dlts_dash := lv_diff_dlts_dash||RPAD(lv_dash,15,lv_dash)||RPAD(delimit,1);
817: lv_diff_dlts_dash := lv_diff_dlts_dash||RPAD(lv_dash,22,lv_dash)||RPAD(delimit,1);
818: lv_diff_dlts_dash := lv_diff_dlts_dash||RPAD(lv_dash,22,lv_dash)||RPAD(delimit,1);

Line 845: fnd_file.put_line(fnd_file.output,RPAD(delimit,12)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_NO_RECORDS'),1,21));

841: lv_value_dif := 'N';
842: END IF;
843: END LOOP;
844: ELSIF NVL(lv_value_dif,'N') = 'N' THEN
845: fnd_file.put_line(fnd_file.output,RPAD(delimit,12)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_NO_RECORDS'),1,21));
846: END IF;
847: IF lv_value_dif = 'Y' THEN
848: fnd_file.put_line(fnd_file.output,delimit||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_CURRENCY'),1,11)||' : '||lt_curr_tbl_1(j));
849:

Line 848: fnd_file.put_line(fnd_file.output,delimit||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_CURRENCY'),1,11)||' : '||lt_curr_tbl_1(j));

844: ELSIF NVL(lv_value_dif,'N') = 'N' THEN
845: fnd_file.put_line(fnd_file.output,RPAD(delimit,12)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_NO_RECORDS'),1,21));
846: END IF;
847: IF lv_value_dif = 'Y' THEN
848: fnd_file.put_line(fnd_file.output,delimit||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_CURRENCY'),1,11)||' : '||lt_curr_tbl_1(j));
849:
850: fnd_file.put_line(fnd_file.output,delimit||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_REMARKS'),1,11)||' : ');
851: fnd_file.put_line(fnd_file.output,lv_diff_dlts);
852: fnd_file.put_line(fnd_file.output,lv_diff_dlts_dash);

Line 850: fnd_file.put_line(fnd_file.output,delimit||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_REMARKS'),1,11)||' : ');

846: END IF;
847: IF lv_value_dif = 'Y' THEN
848: fnd_file.put_line(fnd_file.output,delimit||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_CURRENCY'),1,11)||' : '||lt_curr_tbl_1(j));
849:
850: fnd_file.put_line(fnd_file.output,delimit||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_REMARKS'),1,11)||' : ');
851: fnd_file.put_line(fnd_file.output,lv_diff_dlts);
852: fnd_file.put_line(fnd_file.output,lv_diff_dlts_dash);
853: FOR i IN lt_diff_tbl_1.FIRST..lt_diff_tbl_1.LAST LOOP
854: IF lt_diff_tbl_1(i).currency_code = lt_curr_tbl_1(j) THEN

Line 872: lv_diff_dlts_amt := RPAD(delimit,112)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_TOTAL'),1,7)||delimit;

868: ln_diff_dlts_amt := ln_diff_dlts_amt + lt_diff_tbl_1(i).diff_amount;
869: END IF;
870: END IF;
871: END LOOP;
872: lv_diff_dlts_amt := RPAD(delimit,112)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_TOTAL'),1,7)||delimit;
873: lv_diff_dlts_amt := lv_diff_dlts_amt||LPAD(SUBSTR(LTRIM(RTRIM(TO_CHAR(NVL(ln_diff_dlts_amt,0),lv_frm_amt))),1,13),13);
874: fnd_file.put_line(fnd_file.output,RPAD(delimit,118)||RPAD(lv_dash,13,lv_dash));
875: fnd_file.put_line(fnd_file.output,lv_diff_dlts_amt);
876: fnd_file.put_line(fnd_file.output,RPAD(delimit,118)||RPAD(lv_dash,13,lv_dash));

Line 878: fnd_file.put_line(fnd_file.output,RPAD(delimit,12)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_NO_RECORDS'),1,21));

874: fnd_file.put_line(fnd_file.output,RPAD(delimit,118)||RPAD(lv_dash,13,lv_dash));
875: fnd_file.put_line(fnd_file.output,lv_diff_dlts_amt);
876: fnd_file.put_line(fnd_file.output,RPAD(delimit,118)||RPAD(lv_dash,13,lv_dash));
877: ELSIF NVL(lv_value_dif,'N') = 'N' THEN
878: fnd_file.put_line(fnd_file.output,RPAD(delimit,12)||SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_NO_RECORDS'),1,21));
879: END IF;
880: END LOOP;
881: END IF;
882: fnd_file.put_line(fnd_file.output,delimit);

Line 886: fnd_file.put_line(fnd_file.log,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_END_ACTIVITY'),1,32));

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
890: p_retcode := 2;

Line 923: okl_accounting_util.get_error_message(l_error_msg_rec);

919: l_msg_count,
920: l_msg_data,
921: '_PVT');
922: -- print the error message in the log file
923: okl_accounting_util.get_error_message(l_error_msg_rec);
924: IF (l_error_msg_rec.COUNT > 0) 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;

Line 963: okl_accounting_util.get_error_message(l_error_msg_rec);

959: l_msg_count,
960: l_msg_data,
961: '_PVT');
962: -- print the error message in the log file
963: okl_accounting_util.get_error_message(l_error_msg_rec);
964: IF (l_error_msg_rec.COUNT > 0) THEN
965: FOR i IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST LOOP
966: fnd_file.put_line(fnd_file.output, l_error_msg_rec(i));
967: END LOOP;

Line 1004: okl_accounting_util.get_error_message(l_error_msg_rec);

1000: l_msg_count,
1001: l_msg_data,
1002: '_PVT');
1003: -- print the error message in the log file
1004: okl_accounting_util.get_error_message(l_error_msg_rec);
1005: IF (l_error_msg_rec.COUNT > 0) THEN
1006: FOR i IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST LOOP
1007: fnd_file.put_line(fnd_file.output, l_error_msg_rec(i));
1008: END LOOP;

Line 1569: fnd_file.put_line(fnd_file.log,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_ERROR_ACTIVITY'),1,30));

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));
1573: RAISE okl_api.g_exception_error;

Line 1572: fnd_file.put_line(fnd_file.log,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_ERROR_ACTIVITY'),1,30));

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));
1576: fnd_file.put_line(fnd_file.log,delimit);

Line 1575: fnd_file.put_line(fnd_file.log,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_START_ACTIVITY'),1,34));

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
1578: -- Since the parametr we use in the concurrent program is fnd_standard_date
1579: IF P_END_DATE IS NOT NULL THEN

Line 1611: lt_bill_smry_gt_tbl(smry_cnt).total_strm := okl_accounting_util.format_amount(NVL(ln_tot_curr_amt,0),lt_bill_smry_gt_tbl(smry_cnt).currency_code);

1607: IF get_billed_csr%NOTFOUND THEN
1608: ln_bil_curr_amt := 0;
1609: END IF;
1610: CLOSE get_billed_csr;
1611: lt_bill_smry_gt_tbl(smry_cnt).total_strm := okl_accounting_util.format_amount(NVL(ln_tot_curr_amt,0),lt_bill_smry_gt_tbl(smry_cnt).currency_code);
1612: lt_bill_smry_gt_tbl(smry_cnt).bill_total_strm := okl_accounting_util.format_amount(NVL(ln_bil_curr_amt,0),lt_bill_smry_gt_tbl(smry_cnt).currency_code);
1613: -- To get differnece in the stream amount
1614: -- to show the difference of Total billable streams and billed streams we do the below
1615: ln_dif_amt1 := ln_tot_curr_amt - ln_bil_curr_amt;

Line 1612: lt_bill_smry_gt_tbl(smry_cnt).bill_total_strm := okl_accounting_util.format_amount(NVL(ln_bil_curr_amt,0),lt_bill_smry_gt_tbl(smry_cnt).currency_code);

1608: ln_bil_curr_amt := 0;
1609: END IF;
1610: CLOSE get_billed_csr;
1611: lt_bill_smry_gt_tbl(smry_cnt).total_strm := okl_accounting_util.format_amount(NVL(ln_tot_curr_amt,0),lt_bill_smry_gt_tbl(smry_cnt).currency_code);
1612: lt_bill_smry_gt_tbl(smry_cnt).bill_total_strm := okl_accounting_util.format_amount(NVL(ln_bil_curr_amt,0),lt_bill_smry_gt_tbl(smry_cnt).currency_code);
1613: -- To get differnece in the stream amount
1614: -- to show the difference of Total billable streams and billed streams we do the below
1615: ln_dif_amt1 := ln_tot_curr_amt - ln_bil_curr_amt;
1616: lt_bill_smry_gt_tbl(smry_cnt).diff1_total_strm := okl_accounting_util.format_amount(NVL(ln_dif_amt1,0),lt_bill_smry_gt_tbl(smry_cnt).currency_code);

Line 1616: lt_bill_smry_gt_tbl(smry_cnt).diff1_total_strm := okl_accounting_util.format_amount(NVL(ln_dif_amt1,0),lt_bill_smry_gt_tbl(smry_cnt).currency_code);

1612: lt_bill_smry_gt_tbl(smry_cnt).bill_total_strm := okl_accounting_util.format_amount(NVL(ln_bil_curr_amt,0),lt_bill_smry_gt_tbl(smry_cnt).currency_code);
1613: -- To get differnece in the stream amount
1614: -- to show the difference of Total billable streams and billed streams we do the below
1615: ln_dif_amt1 := ln_tot_curr_amt - ln_bil_curr_amt;
1616: lt_bill_smry_gt_tbl(smry_cnt).diff1_total_strm := okl_accounting_util.format_amount(NVL(ln_dif_amt1,0),lt_bill_smry_gt_tbl(smry_cnt).currency_code);
1617: -- To get cancelled streams total
1618: OPEN get_cancel_csr(p_org_id => ln_org_id,
1619: p_curr_code => get_currency_code_rec.currency_code,
1620: p_contract_number => P_CONTRACT_NUMBER,

Line 1627: lt_bill_smry_gt_tbl(smry_cnt).cancel_total_strm := okl_accounting_util.format_amount(NVL(ln_can_curr_amt,0),lt_bill_smry_gt_tbl(smry_cnt).currency_code);

1623: IF get_cancel_csr%NOTFOUND THEN
1624: ln_can_curr_amt := 0;
1625: END IF;
1626: CLOSE get_cancel_csr;
1627: lt_bill_smry_gt_tbl(smry_cnt).cancel_total_strm := okl_accounting_util.format_amount(NVL(ln_can_curr_amt,0),lt_bill_smry_gt_tbl(smry_cnt).currency_code);
1628: -- to show the difference of 1 difference amount and the cancelled amounts
1629: ln_dif_amt2 := ln_dif_amt1 - ln_can_curr_amt;
1630: lt_bill_smry_gt_tbl(smry_cnt).diff2_total_strm := okl_accounting_util.format_amount(NVL(ln_dif_amt2,0),lt_bill_smry_gt_tbl(smry_cnt).currency_code);
1631: -- To get Closing balance streams total

Line 1630: lt_bill_smry_gt_tbl(smry_cnt).diff2_total_strm := okl_accounting_util.format_amount(NVL(ln_dif_amt2,0),lt_bill_smry_gt_tbl(smry_cnt).currency_code);

1626: CLOSE get_cancel_csr;
1627: lt_bill_smry_gt_tbl(smry_cnt).cancel_total_strm := okl_accounting_util.format_amount(NVL(ln_can_curr_amt,0),lt_bill_smry_gt_tbl(smry_cnt).currency_code);
1628: -- to show the difference of 1 difference amount and the cancelled amounts
1629: ln_dif_amt2 := ln_dif_amt1 - ln_can_curr_amt;
1630: lt_bill_smry_gt_tbl(smry_cnt).diff2_total_strm := okl_accounting_util.format_amount(NVL(ln_dif_amt2,0),lt_bill_smry_gt_tbl(smry_cnt).currency_code);
1631: -- To get Closing balance streams total
1632: OPEN get_clobal_csr(p_org_id => ln_org_id,
1633: p_curr_code => get_currency_code_rec.currency_code,
1634: p_contract_number => P_CONTRACT_NUMBER,

Line 1646: lt_bill_smry_gt_tbl(smry_cnt).clobal_total_strm := okl_accounting_util.format_amount(NVL(ln_clb_curr_amt,0),lt_bill_smry_gt_tbl(smry_cnt).currency_code);

1642: -- there was value for un billed streams
1643: IF ln_clb_curr_amt <> 0 THEN
1644: lt_value_tbl(a).clb_amt := ln_clb_curr_amt;
1645: END IF;
1646: lt_bill_smry_gt_tbl(smry_cnt).clobal_total_strm := okl_accounting_util.format_amount(NVL(ln_clb_curr_amt,0),lt_bill_smry_gt_tbl(smry_cnt).currency_code);
1647: -- To get differnece in the stream amount
1648: -- the components of these are the total Billable streasm less billed streams
1649: -- To get differnece in the stream amount
1650: -- less cancelled streams and less unbilled streams

Line 1662: lt_bill_smry_gt_tbl(smry_cnt).main_diff_total := okl_accounting_util.format_amount(NVL(ln_dif_amt,0),lt_bill_smry_gt_tbl(smry_cnt).currency_code);

1658: ELSIF ln_dif_amt = 0 THEN
1659: lt_value_tbl(a).dif_amt := ln_dif_amt;
1660: lt_value_tbl(a).curr_code := get_currency_code_rec.currency_code;
1661: END IF;
1662: lt_bill_smry_gt_tbl(smry_cnt).main_diff_total := okl_accounting_util.format_amount(NVL(ln_dif_amt,0),lt_bill_smry_gt_tbl(smry_cnt).currency_code);
1663: a := a + 1;
1664: smry_cnt := smry_cnt+1;
1665: END LOOP;
1666: -- Filling in the Details section of the unbilled Streams report file

Line 1863: okl_accounting_util.format_amount(lt_unbill_gt_tbl(i).amount,lt_unbill_gt_tbl(i).currency_code),

1859: ('UNBILLED_DTLS',
1860: lt_unbill_gt_tbl(i).currency_code,
1861: lt_unbill_gt_tbl(i).book_class,
1862: lt_unbill_gt_tbl(i).product_name,
1863: okl_accounting_util.format_amount(lt_unbill_gt_tbl(i).amount,lt_unbill_gt_tbl(i).currency_code),
1864: lt_unbill_gt_tbl(i).amount
1865: );
1866: END LOOP;
1867: END IF;

Line 1888: okl_accounting_util.format_amount(lt_diff_gt_tbl(i).total_billable_streams,lt_diff_gt_tbl(i).currency_code),

1884: VALUES
1885: ('DIFF_DTLS',
1886: lt_diff_gt_tbl(i).currency_code,
1887: lt_diff_gt_tbl(i).contract_number,
1888: okl_accounting_util.format_amount(lt_diff_gt_tbl(i).total_billable_streams,lt_diff_gt_tbl(i).currency_code),
1889: okl_accounting_util.format_amount(lt_diff_gt_tbl(i).billed_streams,lt_diff_gt_tbl(i).currency_code),
1890: okl_accounting_util.format_amount(lt_diff_gt_tbl(i).cancelled_streams,lt_diff_gt_tbl(i).currency_code),
1891: okl_accounting_util.format_amount(lt_diff_gt_tbl(i).unbilled_streams,lt_diff_gt_tbl(i).currency_code),
1892: okl_accounting_util.format_amount(lt_diff_gt_tbl(i).diff_amount,lt_diff_gt_tbl(i).currency_code),

Line 1889: okl_accounting_util.format_amount(lt_diff_gt_tbl(i).billed_streams,lt_diff_gt_tbl(i).currency_code),

1885: ('DIFF_DTLS',
1886: lt_diff_gt_tbl(i).currency_code,
1887: lt_diff_gt_tbl(i).contract_number,
1888: okl_accounting_util.format_amount(lt_diff_gt_tbl(i).total_billable_streams,lt_diff_gt_tbl(i).currency_code),
1889: okl_accounting_util.format_amount(lt_diff_gt_tbl(i).billed_streams,lt_diff_gt_tbl(i).currency_code),
1890: okl_accounting_util.format_amount(lt_diff_gt_tbl(i).cancelled_streams,lt_diff_gt_tbl(i).currency_code),
1891: okl_accounting_util.format_amount(lt_diff_gt_tbl(i).unbilled_streams,lt_diff_gt_tbl(i).currency_code),
1892: okl_accounting_util.format_amount(lt_diff_gt_tbl(i).diff_amount,lt_diff_gt_tbl(i).currency_code),
1893: lt_diff_gt_tbl(i).total_billable_streams,

Line 1890: okl_accounting_util.format_amount(lt_diff_gt_tbl(i).cancelled_streams,lt_diff_gt_tbl(i).currency_code),

1886: lt_diff_gt_tbl(i).currency_code,
1887: lt_diff_gt_tbl(i).contract_number,
1888: okl_accounting_util.format_amount(lt_diff_gt_tbl(i).total_billable_streams,lt_diff_gt_tbl(i).currency_code),
1889: okl_accounting_util.format_amount(lt_diff_gt_tbl(i).billed_streams,lt_diff_gt_tbl(i).currency_code),
1890: okl_accounting_util.format_amount(lt_diff_gt_tbl(i).cancelled_streams,lt_diff_gt_tbl(i).currency_code),
1891: okl_accounting_util.format_amount(lt_diff_gt_tbl(i).unbilled_streams,lt_diff_gt_tbl(i).currency_code),
1892: okl_accounting_util.format_amount(lt_diff_gt_tbl(i).diff_amount,lt_diff_gt_tbl(i).currency_code),
1893: lt_diff_gt_tbl(i).total_billable_streams,
1894: lt_diff_gt_tbl(i).billed_streams,

Line 1891: okl_accounting_util.format_amount(lt_diff_gt_tbl(i).unbilled_streams,lt_diff_gt_tbl(i).currency_code),

1887: lt_diff_gt_tbl(i).contract_number,
1888: okl_accounting_util.format_amount(lt_diff_gt_tbl(i).total_billable_streams,lt_diff_gt_tbl(i).currency_code),
1889: okl_accounting_util.format_amount(lt_diff_gt_tbl(i).billed_streams,lt_diff_gt_tbl(i).currency_code),
1890: okl_accounting_util.format_amount(lt_diff_gt_tbl(i).cancelled_streams,lt_diff_gt_tbl(i).currency_code),
1891: okl_accounting_util.format_amount(lt_diff_gt_tbl(i).unbilled_streams,lt_diff_gt_tbl(i).currency_code),
1892: okl_accounting_util.format_amount(lt_diff_gt_tbl(i).diff_amount,lt_diff_gt_tbl(i).currency_code),
1893: lt_diff_gt_tbl(i).total_billable_streams,
1894: lt_diff_gt_tbl(i).billed_streams,
1895: lt_diff_gt_tbl(i).cancelled_streams,

Line 1892: okl_accounting_util.format_amount(lt_diff_gt_tbl(i).diff_amount,lt_diff_gt_tbl(i).currency_code),

1888: okl_accounting_util.format_amount(lt_diff_gt_tbl(i).total_billable_streams,lt_diff_gt_tbl(i).currency_code),
1889: okl_accounting_util.format_amount(lt_diff_gt_tbl(i).billed_streams,lt_diff_gt_tbl(i).currency_code),
1890: okl_accounting_util.format_amount(lt_diff_gt_tbl(i).cancelled_streams,lt_diff_gt_tbl(i).currency_code),
1891: okl_accounting_util.format_amount(lt_diff_gt_tbl(i).unbilled_streams,lt_diff_gt_tbl(i).currency_code),
1892: okl_accounting_util.format_amount(lt_diff_gt_tbl(i).diff_amount,lt_diff_gt_tbl(i).currency_code),
1893: lt_diff_gt_tbl(i).total_billable_streams,
1894: lt_diff_gt_tbl(i).billed_streams,
1895: lt_diff_gt_tbl(i).cancelled_streams,
1896: lt_diff_gt_tbl(i).unbilled_streams,

Line 1940: okl_accounting_util.get_error_message(l_error_msg_rec);

1936: l_msg_count,
1937: l_msg_data,
1938: '_PVT');
1939: -- print the error message in the log file
1940: okl_accounting_util.get_error_message(l_error_msg_rec);
1941: IF (l_error_msg_rec.COUNT > 0) THEN
1942: FOR i IN l_error_msg_rec.FIRST..l_error_msg_rec.LAST LOOP
1943: fnd_file.put_line(fnd_file.log, l_error_msg_rec(i));
1944: END LOOP;