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 FND_FILE

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

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
547: lv_end_date := fnd_date.canonical_to_date(p_end_date);

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

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

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 563: fnd_file.put_line(fnd_file.output,RPAD(delimit,47)||RPAD(lv_dash,38,lv_dash)||LPAD(delimit,47));

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);
567: fnd_file.put_line(fnd_file.output,SUBSTR(okl_accounting_util.get_message_token('OKL_LP_CONCURRENT_PROCESS','OKL_PARAMETERS'),1,13));

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

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)||': ';
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')));

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 568: fnd_file.put_line(fnd_file.output,RPAD(lv_dash,13,lv_dash));

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)||': ';
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')));

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

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));
577: fnd_file.put_line(fnd_file.output,RPAD(delimit,12)||RPAD(lv_dash,7,lv_dash));

Line 575: -- Now we are populating the FND_FILE to display the above resultant record

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

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 577: fnd_file.put_line(fnd_file.output,RPAD(delimit,12)||RPAD(lv_dash,7,lv_dash));

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)||':';
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)||':';

Line 578: 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)||':';
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)||':';

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

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,
596: p_contract_number => p_contract_number,

Line 613: fnd_file.put_line(fnd_file.output,lv_tot_amt||LPAD(SUBSTR(LTRIM(RTRIM(TO_CHAR(NVL(ln_tot_curr_amt,0),lv_frm_amt))),1,22),22));

609: IF get_billed_csr%NOTFOUND THEN
610: ln_bil_curr_amt := 0;
611: END IF;
612: CLOSE get_billed_csr;
613: fnd_file.put_line(fnd_file.output,lv_tot_amt||LPAD(SUBSTR(LTRIM(RTRIM(TO_CHAR(NVL(ln_tot_curr_amt,0),lv_frm_amt))),1,22),22));
614: fnd_file.put_line(fnd_file.output,lv_bil_amt||LPAD(SUBSTR(LTRIM(RTRIM(TO_CHAR(NVL(ln_bil_curr_amt,0),lv_frm_amt))),1,22),22));
615: fnd_file.put_line(fnd_file.output,lv_sum_bil_dash);
616: -- To get differnece in the stream amount
617: -- to show the difference of Total billable streams and billed streams we do the below

Line 614: fnd_file.put_line(fnd_file.output,lv_bil_amt||LPAD(SUBSTR(LTRIM(RTRIM(TO_CHAR(NVL(ln_bil_curr_amt,0),lv_frm_amt))),1,22),22));

610: ln_bil_curr_amt := 0;
611: END IF;
612: CLOSE get_billed_csr;
613: fnd_file.put_line(fnd_file.output,lv_tot_amt||LPAD(SUBSTR(LTRIM(RTRIM(TO_CHAR(NVL(ln_tot_curr_amt,0),lv_frm_amt))),1,22),22));
614: fnd_file.put_line(fnd_file.output,lv_bil_amt||LPAD(SUBSTR(LTRIM(RTRIM(TO_CHAR(NVL(ln_bil_curr_amt,0),lv_frm_amt))),1,22),22));
615: fnd_file.put_line(fnd_file.output,lv_sum_bil_dash);
616: -- To get differnece in the stream amount
617: -- to show the difference of Total billable streams and billed streams we do the below
618: ln_dif_amt1 := ln_tot_curr_amt - ln_bil_curr_amt;

Line 615: fnd_file.put_line(fnd_file.output,lv_sum_bil_dash);

611: END IF;
612: CLOSE get_billed_csr;
613: fnd_file.put_line(fnd_file.output,lv_tot_amt||LPAD(SUBSTR(LTRIM(RTRIM(TO_CHAR(NVL(ln_tot_curr_amt,0),lv_frm_amt))),1,22),22));
614: fnd_file.put_line(fnd_file.output,lv_bil_amt||LPAD(SUBSTR(LTRIM(RTRIM(TO_CHAR(NVL(ln_bil_curr_amt,0),lv_frm_amt))),1,22),22));
615: fnd_file.put_line(fnd_file.output,lv_sum_bil_dash);
616: -- To get differnece in the stream amount
617: -- to show the difference of Total billable streams and billed streams we do the below
618: ln_dif_amt1 := ln_tot_curr_amt - ln_bil_curr_amt;
619: fnd_file.put_line(fnd_file.output,lv_dif_amt1||LPAD(SUBSTR(LTRIM(RTRIM(TO_CHAR(NVL(ln_dif_amt1,0),lv_frm_amt))),1,22),22));

Line 619: fnd_file.put_line(fnd_file.output,lv_dif_amt1||LPAD(SUBSTR(LTRIM(RTRIM(TO_CHAR(NVL(ln_dif_amt1,0),lv_frm_amt))),1,22),22));

615: fnd_file.put_line(fnd_file.output,lv_sum_bil_dash);
616: -- To get differnece in the stream amount
617: -- to show the difference of Total billable streams and billed streams we do the below
618: ln_dif_amt1 := ln_tot_curr_amt - ln_bil_curr_amt;
619: fnd_file.put_line(fnd_file.output,lv_dif_amt1||LPAD(SUBSTR(LTRIM(RTRIM(TO_CHAR(NVL(ln_dif_amt1,0),lv_frm_amt))),1,22),22));
620: -- To get cancelled streams total
621: OPEN get_cancel_csr(p_org_id => ln_org_id,
622: p_curr_code => get_currency_code_rec.currency_code,
623: p_contract_number => p_contract_number,

Line 630: fnd_file.put_line(fnd_file.output,lv_can_amt||LPAD(SUBSTR(LTRIM(RTRIM(TO_CHAR(NVL(ln_can_curr_amt,0),lv_frm_amt))),1,22),22));

626: IF get_cancel_csr%NOTFOUND THEN
627: ln_can_curr_amt := 0;
628: END IF;
629: CLOSE get_cancel_csr;
630: fnd_file.put_line(fnd_file.output,lv_can_amt||LPAD(SUBSTR(LTRIM(RTRIM(TO_CHAR(NVL(ln_can_curr_amt,0),lv_frm_amt))),1,22),22));
631: fnd_file.put_line(fnd_file.output,lv_sum_bil_dash);
632: -- to show the difference of 1 difference amount and the cancelled amounts
633: ln_dif_amt2 := ln_dif_amt1 - ln_can_curr_amt;
634: fnd_file.put_line(fnd_file.output,lv_dif_amt2||LPAD(SUBSTR(LTRIM(RTRIM(TO_CHAR(NVL(ln_dif_amt2,0),lv_frm_amt))),1,22),22));

Line 631: fnd_file.put_line(fnd_file.output,lv_sum_bil_dash);

627: ln_can_curr_amt := 0;
628: END IF;
629: CLOSE get_cancel_csr;
630: fnd_file.put_line(fnd_file.output,lv_can_amt||LPAD(SUBSTR(LTRIM(RTRIM(TO_CHAR(NVL(ln_can_curr_amt,0),lv_frm_amt))),1,22),22));
631: fnd_file.put_line(fnd_file.output,lv_sum_bil_dash);
632: -- to show the difference of 1 difference amount and the cancelled amounts
633: ln_dif_amt2 := ln_dif_amt1 - ln_can_curr_amt;
634: fnd_file.put_line(fnd_file.output,lv_dif_amt2||LPAD(SUBSTR(LTRIM(RTRIM(TO_CHAR(NVL(ln_dif_amt2,0),lv_frm_amt))),1,22),22));
635: -- To get Closing balance streams total

Line 634: fnd_file.put_line(fnd_file.output,lv_dif_amt2||LPAD(SUBSTR(LTRIM(RTRIM(TO_CHAR(NVL(ln_dif_amt2,0),lv_frm_amt))),1,22),22));

630: fnd_file.put_line(fnd_file.output,lv_can_amt||LPAD(SUBSTR(LTRIM(RTRIM(TO_CHAR(NVL(ln_can_curr_amt,0),lv_frm_amt))),1,22),22));
631: fnd_file.put_line(fnd_file.output,lv_sum_bil_dash);
632: -- to show the difference of 1 difference amount and the cancelled amounts
633: ln_dif_amt2 := ln_dif_amt1 - ln_can_curr_amt;
634: fnd_file.put_line(fnd_file.output,lv_dif_amt2||LPAD(SUBSTR(LTRIM(RTRIM(TO_CHAR(NVL(ln_dif_amt2,0),lv_frm_amt))),1,22),22));
635: -- To get Closing balance streams total
636: OPEN get_clobal_csr(p_org_id => ln_org_id,
637: p_curr_code => get_currency_code_rec.currency_code,
638: p_contract_number => p_contract_number,

Line 650: fnd_file.put_line(fnd_file.output,lv_clb_amt||LPAD(SUBSTR(LTRIM(RTRIM(TO_CHAR(NVL(ln_clb_curr_amt,0),lv_frm_amt))),1,22),22));

646: -- there was value for un billed streams
647: IF ln_clb_curr_amt <> 0 THEN
648: lt_value_tbl(a).clb_amt := ln_clb_curr_amt;
649: END IF;
650: fnd_file.put_line(fnd_file.output,lv_clb_amt||LPAD(SUBSTR(LTRIM(RTRIM(TO_CHAR(NVL(ln_clb_curr_amt,0),lv_frm_amt))),1,22),22));
651: fnd_file.put_line(fnd_file.output,lv_sum_bil_dash);
652: -- To get differnece in the stream amount
653: -- the components of these are the total Billable streasm less billed streams
654: -- To get differnece in the stream amount

Line 651: fnd_file.put_line(fnd_file.output,lv_sum_bil_dash);

647: IF ln_clb_curr_amt <> 0 THEN
648: lt_value_tbl(a).clb_amt := ln_clb_curr_amt;
649: END IF;
650: fnd_file.put_line(fnd_file.output,lv_clb_amt||LPAD(SUBSTR(LTRIM(RTRIM(TO_CHAR(NVL(ln_clb_curr_amt,0),lv_frm_amt))),1,22),22));
651: fnd_file.put_line(fnd_file.output,lv_sum_bil_dash);
652: -- To get differnece in the stream amount
653: -- the components of these are the total Billable streasm less billed streams
654: -- To get differnece in the stream amount
655: -- less cancelled streams and less unbilled streams

Line 667: fnd_file.put_line(fnd_file.output,lv_dif_amt||LPAD(SUBSTR(LTRIM(RTRIM(TO_CHAR(NVL(ln_dif_amt,0),lv_frm_amt))),1,22),22));

663: ELSIF ln_dif_amt = 0 THEN
664: lt_value_tbl(a).dif_amt := ln_dif_amt;
665: lt_value_tbl(a).curr_code := get_currency_code_rec.currency_code;
666: END IF;
667: fnd_file.put_line(fnd_file.output,lv_dif_amt||LPAD(SUBSTR(LTRIM(RTRIM(TO_CHAR(NVL(ln_dif_amt,0),lv_frm_amt))),1,22),22));
668: fnd_file.put_line(fnd_file.output,lv_sum_bil_dash);
669: fnd_file.put_line(fnd_file.output,delimit);
670: fnd_file.put_line(fnd_file.output,delimit);
671: a := a + 1;

Line 668: fnd_file.put_line(fnd_file.output,lv_sum_bil_dash);

664: lt_value_tbl(a).dif_amt := ln_dif_amt;
665: lt_value_tbl(a).curr_code := get_currency_code_rec.currency_code;
666: END IF;
667: fnd_file.put_line(fnd_file.output,lv_dif_amt||LPAD(SUBSTR(LTRIM(RTRIM(TO_CHAR(NVL(ln_dif_amt,0),lv_frm_amt))),1,22),22));
668: fnd_file.put_line(fnd_file.output,lv_sum_bil_dash);
669: fnd_file.put_line(fnd_file.output,delimit);
670: fnd_file.put_line(fnd_file.output,delimit);
671: a := a + 1;
672: END LOOP;

Line 669: fnd_file.put_line(fnd_file.output,delimit);

665: lt_value_tbl(a).curr_code := get_currency_code_rec.currency_code;
666: END IF;
667: fnd_file.put_line(fnd_file.output,lv_dif_amt||LPAD(SUBSTR(LTRIM(RTRIM(TO_CHAR(NVL(ln_dif_amt,0),lv_frm_amt))),1,22),22));
668: fnd_file.put_line(fnd_file.output,lv_sum_bil_dash);
669: fnd_file.put_line(fnd_file.output,delimit);
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

Line 670: fnd_file.put_line(fnd_file.output,delimit);

666: END IF;
667: fnd_file.put_line(fnd_file.output,lv_dif_amt||LPAD(SUBSTR(LTRIM(RTRIM(TO_CHAR(NVL(ln_dif_amt,0),lv_frm_amt))),1,22),22));
668: fnd_file.put_line(fnd_file.output,lv_sum_bil_dash);
669: fnd_file.put_line(fnd_file.output,delimit);
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));

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

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
679: lv_value_clb := 'Y';

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 687: fnd_file.put_line(fnd_file.output,RPAD(delimit,12)||RPAD(lv_dash,27,lv_dash));

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
691: -- Product associated to the same

Line 688: fnd_file.put_line(fnd_file.output,delimit);

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
691: -- Product associated to the same
692: FOR get_dlts_clobal_rec IN get_dlts_clobal_csr(p_org_id => ln_org_id,

Line 712: fnd_file.put_line(fnd_file.output,lv_dlt_curr_code);

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;
716: ln_dlt_tot_amt := 0;

Line 713: fnd_file.put_line(fnd_file.output,delimit);

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;
716: ln_dlt_tot_amt := 0;
717: ln_dlt_amt := 0;

Line 723: fnd_file.put_line(fnd_file.output,lv_dlt_book||lt_unbill_tbl(j).book_class);

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);
724: lv_book_class := lt_unbill_tbl(j).book_class;
725: fnd_file.put_line(fnd_file.output,delimit);
726: fnd_file.put_line(fnd_file.output,lv_dlt_pdt);
727: ln_dlt_amt := 0;

Line 725: fnd_file.put_line(fnd_file.output,delimit);

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);
724: lv_book_class := lt_unbill_tbl(j).book_class;
725: fnd_file.put_line(fnd_file.output,delimit);
726: fnd_file.put_line(fnd_file.output,lv_dlt_pdt);
727: ln_dlt_amt := 0;
728: FOR h IN lt_unbill_tbl.FIRST..lt_unbill_tbl.LAST LOOP
729: IF lt_unbill_tbl(j).book_class = lt_unbill_tbl(h).book_class AND

Line 726: fnd_file.put_line(fnd_file.output,lv_dlt_pdt);

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);
724: lv_book_class := lt_unbill_tbl(j).book_class;
725: fnd_file.put_line(fnd_file.output,delimit);
726: fnd_file.put_line(fnd_file.output,lv_dlt_pdt);
727: ln_dlt_amt := 0;
728: FOR h IN lt_unbill_tbl.FIRST..lt_unbill_tbl.LAST LOOP
729: IF lt_unbill_tbl(j).book_class = lt_unbill_tbl(h).book_class AND
730: lt_unbill_tbl(j).currency_code = lt_curr_tbl(m) THEN

Line 731: fnd_file.put_line(fnd_file.output,RPAD(delimit,15)||RPAD(substr(lt_unbill_tbl(h).product_name,1,20),20,delimit)||RPAD(delimit,9)||':'||LPAD(SUBSTR(LTRIM(RTRIM(TO_CHAR(NVL(lt_unbill_tbl(h).amount,0),lv_frm_amt))),1,22),22));

727: ln_dlt_amt := 0;
728: FOR h IN lt_unbill_tbl.FIRST..lt_unbill_tbl.LAST LOOP
729: IF lt_unbill_tbl(j).book_class = lt_unbill_tbl(h).book_class AND
730: lt_unbill_tbl(j).currency_code = lt_curr_tbl(m) THEN
731: fnd_file.put_line(fnd_file.output,RPAD(delimit,15)||RPAD(substr(lt_unbill_tbl(h).product_name,1,20),20,delimit)||RPAD(delimit,9)||':'||LPAD(SUBSTR(LTRIM(RTRIM(TO_CHAR(NVL(lt_unbill_tbl(h).amount,0),lv_frm_amt))),1,22),22));
732: ln_dlt_amt := ln_dlt_amt + lt_unbill_tbl(h).amount;
733: ln_dlt_tot_amt := ln_dlt_tot_amt + lt_unbill_tbl(h).amount;
734: END IF;
735: END LOOP;

Line 736: fnd_file.put_line(fnd_file.output,RPAD(delimit,45)||RPAD(lv_dash,22,lv_dash));

732: ln_dlt_amt := ln_dlt_amt + lt_unbill_tbl(h).amount;
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;

Line 739: fnd_file.put_line(fnd_file.output,lv_dlt_amt);

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;
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)||':';

Line 742: fnd_file.put_line(fnd_file.output,RPAD(delimit,45)||RPAD(lv_dash,22,lv_dash));

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

Line 745: fnd_file.put_line(fnd_file.output,lv_dlt_tot_amt);

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;
748: END IF;
749: ELSIF lv_value_clb = 'N' THEN

Line 746: fnd_file.put_line(fnd_file.output,RPAD(delimit,45)||RPAD(lv_dash,22,lv_dash));

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

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

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

Line 755: fnd_file.put_line(fnd_file.output,delimit);

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));
758: fnd_file.put_line(fnd_file.output,delimit);
759: FOR get_diff_rec IN get_diff_csr(p_org_id => ln_org_id,

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 757: fnd_file.put_line(fnd_file.output,RPAD(delimit,12)||RPAD(lv_dash,29,lv_dash));

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,
761: p_end_date => lv_end_date) LOOP

Line 758: fnd_file.put_line(fnd_file.output,delimit);

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,
761: p_end_date => lv_end_date) LOOP
762: lt_diff_tbl(h).contract_number := get_diff_rec.contract_number;

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 851: fnd_file.put_line(fnd_file.output,lv_diff_dlts);

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
855: lt_diff_tbl_1(i).diff_amount := NVL(TO_NUMBER(lt_diff_tbl_1(i).total_billable_streams),0) -

Line 852: fnd_file.put_line(fnd_file.output,lv_diff_dlts_dash);

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
855: lt_diff_tbl_1(i).diff_amount := NVL(TO_NUMBER(lt_diff_tbl_1(i).total_billable_streams),0) -
856: (NVL(TO_NUMBER(lt_diff_tbl_1(i).billed_streams),0) +

Line 867: fnd_file.puT_line(fnd_file.output,lv_diff_dlts_khr);

863: lv_diff_dlts_khr := lv_diff_dlts_khr||LPAD(SUBSTR(LTRIM(RTRIM(TO_CHAR(NVL(TO_NUMBER(lt_diff_tbl_1(i).billed_streams),0),lv_frm_amt))),1,22),22)||RPAD(delimit,1);
864: lv_diff_dlts_khr := lv_diff_dlts_khr||LPAD(SUBSTR(LTRIM(RTRIM(TO_CHAR(NVL(TO_NUMBER(lt_diff_tbl_1(i).cancelled_streams),0),lv_frm_amt))),1,22),22)||RPAD(delimit,1);
865: lv_diff_dlts_khr := lv_diff_dlts_khr||LPAD(SUBSTR(LTRIM(RTRIM(TO_CHAR(NVL(TO_NUMBER(lt_diff_tbl_1(i).unbilled_streams),0),lv_frm_amt))),1,22),22)||RPAD(delimit,1);
866: lv_diff_dlts_khr := lv_diff_dlts_khr||LPAD(SUBSTR(LTRIM(RTRIM(TO_CHAR(NVL(lt_diff_tbl_1(i).diff_amount,0),lv_frm_amt))),1,22),22)||RPAD(delimit,1);
867: fnd_file.puT_line(fnd_file.output,lv_diff_dlts_khr);
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;

Line 874: fnd_file.put_line(fnd_file.output,RPAD(delimit,118)||RPAD(lv_dash,13,lv_dash));

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

Line 875: fnd_file.put_line(fnd_file.output,lv_diff_dlts_amt);

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

Line 876: fnd_file.put_line(fnd_file.output,RPAD(delimit,118)||RPAD(lv_dash,13,lv_dash));

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

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

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

Line 883: fnd_file.put_line(fnd_file.output,delimit);

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

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

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 926: fnd_file.put_line(fnd_file.output, l_error_msg_rec(i));

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;
928: END IF;
929: WHEN okl_api.g_exception_unexpected_error THEN
930: IF get_org_id%ISOPEN THEN

Line 966: fnd_file.put_line(fnd_file.output, l_error_msg_rec(i));

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;
968: END IF;
969: WHEN OTHERS THEN
970: p_errbuf := SQLERRM;

Line 1007: fnd_file.put_line(fnd_file.output, l_error_msg_rec(i));

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;
1009: END IF;
1010: fnd_file.put_line(fnd_file.log, SQLERRM);
1011: END recon_qry;

Line 1010: fnd_file.put_line(fnd_file.log, SQLERRM);

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;
1009: END IF;
1010: fnd_file.put_line(fnd_file.log, SQLERRM);
1011: END recon_qry;
1012:
1013: -------------------------------------------------------------------------------
1014: -- Function xml_recon_qry

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

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
1580: lv_end_date := fnd_date.canonical_to_date(P_END_DATE);

Line 1943: fnd_file.put_line(fnd_file.log, l_error_msg_rec(i));

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;
1945: END IF;
1946: fnd_file.put_line(fnd_file.log, SQLERRM);
1947: END xml_recon_qry;

Line 1946: fnd_file.put_line(fnd_file.log, SQLERRM);

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;
1945: END IF;
1946: fnd_file.put_line(fnd_file.log, SQLERRM);
1947: END xml_recon_qry;
1948: END OKL_STREAMS_RECON_PVT;