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_EXT_BILLING_CHARGES_PVT dependencies on FND_FILE

Line 536: FND_FILE.PUT_LINE (FND_FILE.log, '================================================================');

532:
533: ------------------------------------------------------------
534: -- Process every external billing line for billing import
535: ------------------------------------------------------------
536: FND_FILE.PUT_LINE (FND_FILE.log, '================================================================');
537: FND_FILE.PUT_LINE (FND_FILE.log, ' *** START PROCESSING THIRD PARTY BILLING RECORDS ***');
538: FND_FILE.PUT_LINE (FND_FILE.log, '================================================================');
539:
540: -- -----------------------------------------------------

Line 537: FND_FILE.PUT_LINE (FND_FILE.log, ' * START PROCESSING THIRD PARTY BILLING RECORDS *');

533: ------------------------------------------------------------
534: -- Process every external billing line for billing import
535: ------------------------------------------------------------
536: FND_FILE.PUT_LINE (FND_FILE.log, '================================================================');
537: FND_FILE.PUT_LINE (FND_FILE.log, ' *** START PROCESSING THIRD PARTY BILLING RECORDS ***');
538: FND_FILE.PUT_LINE (FND_FILE.log, '================================================================');
539:
540: -- -----------------------------------------------------
541: -- Fetch property tax

Line 538: FND_FILE.PUT_LINE (FND_FILE.log, '================================================================');

534: -- Process every external billing line for billing import
535: ------------------------------------------------------------
536: FND_FILE.PUT_LINE (FND_FILE.log, '================================================================');
537: FND_FILE.PUT_LINE (FND_FILE.log, ' *** START PROCESSING THIRD PARTY BILLING RECORDS ***');
538: FND_FILE.PUT_LINE (FND_FILE.log, '================================================================');
539:
540: -- -----------------------------------------------------
541: -- Fetch property tax
542: -- -----------------------------------------------------

Line 566: FND_FILE.PUT_LINE (FND_FILE.log, ' ERROR ');

562: -- --------------------------------------------
563: -- Print error message and stop processing
564: -- --------------------------------------------
565: if l_bill_try_id is null or l_cm_try_id is null then
566: FND_FILE.PUT_LINE (FND_FILE.log, '********************** ERROR **********************');
567: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'BILLING or CREDIT MEMO transaction type is invalid.');
568: FND_FILE.PUT_LINE (FND_FILE.log, '********************** ERROR **********************');
569:
570: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 567: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'BILLING or CREDIT MEMO transaction type is invalid.');

563: -- Print error message and stop processing
564: -- --------------------------------------------
565: if l_bill_try_id is null or l_cm_try_id is null then
566: FND_FILE.PUT_LINE (FND_FILE.log, '********************** ERROR **********************');
567: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'BILLING or CREDIT MEMO transaction type is invalid.');
568: FND_FILE.PUT_LINE (FND_FILE.log, '********************** ERROR **********************');
569:
570: RAISE OKL_API.G_EXCEPTION_ERROR;
571: END IF;

Line 568: FND_FILE.PUT_LINE (FND_FILE.log, ' ERROR ');

564: -- --------------------------------------------
565: if l_bill_try_id is null or l_cm_try_id is null then
566: FND_FILE.PUT_LINE (FND_FILE.log, '********************** ERROR **********************');
567: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'BILLING or CREDIT MEMO transaction type is invalid.');
568: FND_FILE.PUT_LINE (FND_FILE.log, '********************** ERROR **********************');
569:
570: RAISE OKL_API.G_EXCEPTION_ERROR;
571: END IF;
572:

Line 586: FND_FILE.PUT_LINE (FND_FILE.log, ' ERROR ');

582: l_program_id := NULL;
583: end if;
584:
585: if l_request_id is null then
586: FND_FILE.PUT_LINE (FND_FILE.log, '********************** ERROR **********************');
587: FND_FILE.PUT_LINE (FND_FILE.log,
588: 'Cannot determine request Id from profile. The function Fnd_Global.CONC_REQUEST_ID returns -1.');
589: FND_FILE.PUT_LINE (FND_FILE.log, '********************** ERROR **********************');
590: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 587: FND_FILE.PUT_LINE (FND_FILE.log,

583: end if;
584:
585: if l_request_id is null then
586: FND_FILE.PUT_LINE (FND_FILE.log, '********************** ERROR **********************');
587: FND_FILE.PUT_LINE (FND_FILE.log,
588: 'Cannot determine request Id from profile. The function Fnd_Global.CONC_REQUEST_ID returns -1.');
589: FND_FILE.PUT_LINE (FND_FILE.log, '********************** ERROR **********************');
590: RAISE OKL_API.G_EXCEPTION_ERROR;
591: END IF;

Line 589: FND_FILE.PUT_LINE (FND_FILE.log, ' ERROR ');

585: if l_request_id is null then
586: FND_FILE.PUT_LINE (FND_FILE.log, '********************** ERROR **********************');
587: FND_FILE.PUT_LINE (FND_FILE.log,
588: 'Cannot determine request Id from profile. The function Fnd_Global.CONC_REQUEST_ID returns -1.');
589: FND_FILE.PUT_LINE (FND_FILE.log, '********************** ERROR **********************');
590: RAISE OKL_API.G_EXCEPTION_ERROR;
591: END IF;
592:
593: -- -------------------------------

Line 1825: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'Oracle Lease and Finance Management'||LPAD(' ', 55, ' '));

1821: FETCH op_unit_csr INTO l_op_unit_name;
1822: CLOSE op_unit_csr;
1823:
1824: -- Start New Out File stmathew
1825: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'Oracle Lease and Finance Management'||LPAD(' ', 55, ' '));
1826: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1827: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 53, ' ')||'Third Party Billing Import'||LPAD(' ', 53, ' '));
1828: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'------------------------'||LPAD(' ', 54, ' '));
1829: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

Line 1826: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

1822: CLOSE op_unit_csr;
1823:
1824: -- Start New Out File stmathew
1825: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'Oracle Lease and Finance Management'||LPAD(' ', 55, ' '));
1826: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1827: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 53, ' ')||'Third Party Billing Import'||LPAD(' ', 53, ' '));
1828: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'------------------------'||LPAD(' ', 54, ' '));
1829: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1830: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

Line 1827: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 53, ' ')||'Third Party Billing Import'||LPAD(' ', 53, ' '));

1823:
1824: -- Start New Out File stmathew
1825: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'Oracle Lease and Finance Management'||LPAD(' ', 55, ' '));
1826: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1827: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 53, ' ')||'Third Party Billing Import'||LPAD(' ', 53, ' '));
1828: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'------------------------'||LPAD(' ', 54, ' '));
1829: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1830: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1831: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Operating Unit: '||l_op_unit_name);

Line 1828: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'------------------------'||LPAD(' ', 54, ' '));

1824: -- Start New Out File stmathew
1825: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'Oracle Lease and Finance Management'||LPAD(' ', 55, ' '));
1826: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1827: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 53, ' ')||'Third Party Billing Import'||LPAD(' ', 53, ' '));
1828: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'------------------------'||LPAD(' ', 54, ' '));
1829: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1830: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1831: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Operating Unit: '||l_op_unit_name);
1832: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Request Id: '||l_request_id||LPAD(' ',74,' ') ||'Run Date: '||TO_CHAR(SYSDATE));

Line 1829: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

1825: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'Oracle Lease and Finance Management'||LPAD(' ', 55, ' '));
1826: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1827: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 53, ' ')||'Third Party Billing Import'||LPAD(' ', 53, ' '));
1828: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'------------------------'||LPAD(' ', 54, ' '));
1829: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1830: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1831: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Operating Unit: '||l_op_unit_name);
1832: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Request Id: '||l_request_id||LPAD(' ',74,' ') ||'Run Date: '||TO_CHAR(SYSDATE));
1833: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);

Line 1830: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

1826: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1827: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 53, ' ')||'Third Party Billing Import'||LPAD(' ', 53, ' '));
1828: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'------------------------'||LPAD(' ', 54, ' '));
1829: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1830: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1831: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Operating Unit: '||l_op_unit_name);
1832: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Request Id: '||l_request_id||LPAD(' ',74,' ') ||'Run Date: '||TO_CHAR(SYSDATE));
1833: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);
1834: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));

Line 1831: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Operating Unit: '||l_op_unit_name);

1827: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 53, ' ')||'Third Party Billing Import'||LPAD(' ', 53, ' '));
1828: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'------------------------'||LPAD(' ', 54, ' '));
1829: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1830: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1831: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Operating Unit: '||l_op_unit_name);
1832: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Request Id: '||l_request_id||LPAD(' ',74,' ') ||'Run Date: '||TO_CHAR(SYSDATE));
1833: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);
1834: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
1835: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

Line 1832: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Request Id: '||l_request_id||LPAD(' ',74,' ') ||'Run Date: '||TO_CHAR(SYSDATE));

1828: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'------------------------'||LPAD(' ', 54, ' '));
1829: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1830: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1831: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Operating Unit: '||l_op_unit_name);
1832: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Request Id: '||l_request_id||LPAD(' ',74,' ') ||'Run Date: '||TO_CHAR(SYSDATE));
1833: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);
1834: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
1835: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1836: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

Line 1833: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);

1829: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1830: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1831: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Operating Unit: '||l_op_unit_name);
1832: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Request Id: '||l_request_id||LPAD(' ',74,' ') ||'Run Date: '||TO_CHAR(SYSDATE));
1833: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);
1834: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
1835: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1836: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1837: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Processing Details:'||LPAD(' ', 113, ' '));

Line 1834: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));

1830: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1831: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Operating Unit: '||l_op_unit_name);
1832: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Request Id: '||l_request_id||LPAD(' ',74,' ') ||'Run Date: '||TO_CHAR(SYSDATE));
1833: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);
1834: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
1835: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1836: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1837: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Processing Details:'||LPAD(' ', 113, ' '));
1838: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

Line 1835: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

1831: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Operating Unit: '||l_op_unit_name);
1832: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Request Id: '||l_request_id||LPAD(' ',74,' ') ||'Run Date: '||TO_CHAR(SYSDATE));
1833: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);
1834: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
1835: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1836: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1837: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Processing Details:'||LPAD(' ', 113, ' '));
1838: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1839: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Actual Property Tax records: '||l_succ_apt_cnt);

Line 1836: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

1832: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Request Id: '||l_request_id||LPAD(' ',74,' ') ||'Run Date: '||TO_CHAR(SYSDATE));
1833: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);
1834: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
1835: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1836: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1837: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Processing Details:'||LPAD(' ', 113, ' '));
1838: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1839: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Actual Property Tax records: '||l_succ_apt_cnt);
1840: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Actual Property Tax records: '||l_err_apt_cnt);

Line 1837: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Processing Details:'||LPAD(' ', 113, ' '));

1833: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);
1834: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
1835: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1836: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1837: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Processing Details:'||LPAD(' ', 113, ' '));
1838: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1839: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Actual Property Tax records: '||l_succ_apt_cnt);
1840: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Actual Property Tax records: '||l_err_apt_cnt);
1841: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Non-Actual Property Tax records: '||l_succ_non_apt_cnt);

Line 1838: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

1834: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
1835: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1836: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1837: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Processing Details:'||LPAD(' ', 113, ' '));
1838: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1839: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Actual Property Tax records: '||l_succ_apt_cnt);
1840: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Actual Property Tax records: '||l_err_apt_cnt);
1841: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Non-Actual Property Tax records: '||l_succ_non_apt_cnt);
1842: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Non-Actual Property Tax records: '||l_err_non_apt_cnt);

Line 1839: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Actual Property Tax records: '||l_succ_apt_cnt);

1835: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1836: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1837: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Processing Details:'||LPAD(' ', 113, ' '));
1838: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1839: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Actual Property Tax records: '||l_succ_apt_cnt);
1840: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Actual Property Tax records: '||l_err_apt_cnt);
1841: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Non-Actual Property Tax records: '||l_succ_non_apt_cnt);
1842: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Non-Actual Property Tax records: '||l_err_non_apt_cnt);
1843: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Total records processed: '||g_total_rec_count);

Line 1840: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Actual Property Tax records: '||l_err_apt_cnt);

1836: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1837: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Processing Details:'||LPAD(' ', 113, ' '));
1838: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1839: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Actual Property Tax records: '||l_succ_apt_cnt);
1840: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Actual Property Tax records: '||l_err_apt_cnt);
1841: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Non-Actual Property Tax records: '||l_succ_non_apt_cnt);
1842: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Non-Actual Property Tax records: '||l_err_non_apt_cnt);
1843: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Total records processed: '||g_total_rec_count);
1844: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

Line 1841: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Non-Actual Property Tax records: '||l_succ_non_apt_cnt);

1837: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Processing Details:'||LPAD(' ', 113, ' '));
1838: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1839: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Actual Property Tax records: '||l_succ_apt_cnt);
1840: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Actual Property Tax records: '||l_err_apt_cnt);
1841: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Non-Actual Property Tax records: '||l_succ_non_apt_cnt);
1842: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Non-Actual Property Tax records: '||l_err_non_apt_cnt);
1843: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Total records processed: '||g_total_rec_count);
1844: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1845: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));

Line 1842: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Non-Actual Property Tax records: '||l_err_non_apt_cnt);

1838: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1839: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Actual Property Tax records: '||l_succ_apt_cnt);
1840: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Actual Property Tax records: '||l_err_apt_cnt);
1841: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Non-Actual Property Tax records: '||l_succ_non_apt_cnt);
1842: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Non-Actual Property Tax records: '||l_err_non_apt_cnt);
1843: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Total records processed: '||g_total_rec_count);
1844: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1845: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
1846: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

Line 1843: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Total records processed: '||g_total_rec_count);

1839: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Actual Property Tax records: '||l_succ_apt_cnt);
1840: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Actual Property Tax records: '||l_err_apt_cnt);
1841: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Non-Actual Property Tax records: '||l_succ_non_apt_cnt);
1842: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Non-Actual Property Tax records: '||l_err_non_apt_cnt);
1843: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Total records processed: '||g_total_rec_count);
1844: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1845: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
1846: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1847:

Line 1844: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

1840: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Actual Property Tax records: '||l_err_apt_cnt);
1841: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Non-Actual Property Tax records: '||l_succ_non_apt_cnt);
1842: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Non-Actual Property Tax records: '||l_err_non_apt_cnt);
1843: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Total records processed: '||g_total_rec_count);
1844: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1845: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
1846: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1847:
1848: -- End New Out File stmathew

Line 1845: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));

1841: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Non-Actual Property Tax records: '||l_succ_non_apt_cnt);
1842: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Non-Actual Property Tax records: '||l_err_non_apt_cnt);
1843: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Total records processed: '||g_total_rec_count);
1844: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1845: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
1846: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1847:
1848: -- End New Out File stmathew
1849: IF x_msg_count > 0 THEN

Line 1846: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

1842: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Non-Actual Property Tax records: '||l_err_non_apt_cnt);
1843: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Total records processed: '||g_total_rec_count);
1844: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1845: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
1846: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1847:
1848: -- End New Out File stmathew
1849: IF x_msg_count > 0 THEN
1850: FOR i IN 1..x_msg_count LOOP

Line 1852: Fnd_File.PUT_LINE (Fnd_File.log,'Details of TAPI errors:'||LPAD(' ', 97, ' '));

1848: -- End New Out File stmathew
1849: IF x_msg_count > 0 THEN
1850: FOR i IN 1..x_msg_count LOOP
1851: IF i = 1 THEN
1852: Fnd_File.PUT_LINE (Fnd_File.log,'Details of TAPI errors:'||LPAD(' ', 97, ' '));
1853: Fnd_File.PUT_LINE (Fnd_File.log,RPAD(' ', 132, ' '));
1854: END IF;
1855: Fnd_Msg_Pub.get (p_msg_index => i,
1856: p_encoded => 'F',

Line 1853: Fnd_File.PUT_LINE (Fnd_File.log,RPAD(' ', 132, ' '));

1849: IF x_msg_count > 0 THEN
1850: FOR i IN 1..x_msg_count LOOP
1851: IF i = 1 THEN
1852: Fnd_File.PUT_LINE (Fnd_File.log,'Details of TAPI errors:'||LPAD(' ', 97, ' '));
1853: Fnd_File.PUT_LINE (Fnd_File.log,RPAD(' ', 132, ' '));
1854: END IF;
1855: Fnd_Msg_Pub.get (p_msg_index => i,
1856: p_encoded => 'F',
1857: p_data => lx_msg_data,

Line 1859: Fnd_File.PUT_LINE (Fnd_File.log,TO_CHAR(i) || ': ' || lx_msg_data);

1855: Fnd_Msg_Pub.get (p_msg_index => i,
1856: p_encoded => 'F',
1857: p_data => lx_msg_data,
1858: p_msg_index_out => l_msg_index_out);
1859: Fnd_File.PUT_LINE (Fnd_File.log,TO_CHAR(i) || ': ' || lx_msg_data);
1860: END LOOP;
1861: END IF;
1862:
1863: -- ---------------------------------------------------------

Line 1866: Fnd_File.PUT_LINE (Fnd_File.log,RPAD(' ', 132, ' '));

1862:
1863: -- ---------------------------------------------------------
1864: -- print all error messages from okl_ext_billing_interface
1865: -- ---------------------------------------------------------
1866: Fnd_File.PUT_LINE (Fnd_File.log,RPAD(' ', 132, ' '));
1867: Fnd_File.PUT_LINE (Fnd_File.log,RPAD(' ', 132, ' '));
1868: Fnd_File.PUT_LINE (Fnd_File.log,'Contract Number'||LPAD(' ', 16, ' ')
1869: ||'Asset Number'||LPAD(' ', 19, ' ')
1870: ||'Stream Name'||LPAD(' ', 20, ' ')

Line 1867: Fnd_File.PUT_LINE (Fnd_File.log,RPAD(' ', 132, ' '));

1863: -- ---------------------------------------------------------
1864: -- print all error messages from okl_ext_billing_interface
1865: -- ---------------------------------------------------------
1866: Fnd_File.PUT_LINE (Fnd_File.log,RPAD(' ', 132, ' '));
1867: Fnd_File.PUT_LINE (Fnd_File.log,RPAD(' ', 132, ' '));
1868: Fnd_File.PUT_LINE (Fnd_File.log,'Contract Number'||LPAD(' ', 16, ' ')
1869: ||'Asset Number'||LPAD(' ', 19, ' ')
1870: ||'Stream Name'||LPAD(' ', 20, ' ')
1871: ||'Invoice Date'||' Error Message');

Line 1868: Fnd_File.PUT_LINE (Fnd_File.log,'Contract Number'||LPAD(' ', 16, ' ')

1864: -- print all error messages from okl_ext_billing_interface
1865: -- ---------------------------------------------------------
1866: Fnd_File.PUT_LINE (Fnd_File.log,RPAD(' ', 132, ' '));
1867: Fnd_File.PUT_LINE (Fnd_File.log,RPAD(' ', 132, ' '));
1868: Fnd_File.PUT_LINE (Fnd_File.log,'Contract Number'||LPAD(' ', 16, ' ')
1869: ||'Asset Number'||LPAD(' ', 19, ' ')
1870: ||'Stream Name'||LPAD(' ', 20, ' ')
1871: ||'Invoice Date'||' Error Message');
1872: Fnd_File.PUT_LINE (Fnd_File.log,'---------------'||LPAD(' ', 16, ' ')

Line 1872: Fnd_File.PUT_LINE (Fnd_File.log,'---------------'||LPAD(' ', 16, ' ')

1868: Fnd_File.PUT_LINE (Fnd_File.log,'Contract Number'||LPAD(' ', 16, ' ')
1869: ||'Asset Number'||LPAD(' ', 19, ' ')
1870: ||'Stream Name'||LPAD(' ', 20, ' ')
1871: ||'Invoice Date'||' Error Message');
1872: Fnd_File.PUT_LINE (Fnd_File.log,'---------------'||LPAD(' ', 16, ' ')
1873: ||'------------'||LPAD(' ', 19, ' ')
1874: ||'-----------'||LPAD(' ', 20, ' ')
1875: ||'------------'||' -------------');
1876:

Line 1879: Fnd_File.PUT_LINE (Fnd_File.log,error_msg_rec.contract_number||' '

1875: ||'------------'||' -------------');
1876:
1877: FOR error_msg_rec in error_msg_csr( l_request_id, 'ERROR' )
1878: LOOP
1879: Fnd_File.PUT_LINE (Fnd_File.log,error_msg_rec.contract_number||' '
1880: ||error_msg_rec.asset_number||' '
1881: ||error_msg_rec.sty_name||' '
1882: ||error_msg_rec.invoice_date||' '
1883: ||error_msg_rec.error_message);

Line 1885: Fnd_File.PUT_LINE (Fnd_File.log,RPAD(' ', 132, ' '));

1881: ||error_msg_rec.sty_name||' '
1882: ||error_msg_rec.invoice_date||' '
1883: ||error_msg_rec.error_message);
1884: END LOOP;
1885: Fnd_File.PUT_LINE (Fnd_File.log,RPAD(' ', 132, ' '));
1886: Fnd_File.PUT_LINE (Fnd_File.log,RPAD(' ', 132, ' '));
1887: Fnd_File.PUT_LINE (Fnd_File.log,RPAD(' ', 132, ' '));
1888: -- -------------------------------
1889: -- End Print processing Summary

Line 1886: Fnd_File.PUT_LINE (Fnd_File.log,RPAD(' ', 132, ' '));

1882: ||error_msg_rec.invoice_date||' '
1883: ||error_msg_rec.error_message);
1884: END LOOP;
1885: Fnd_File.PUT_LINE (Fnd_File.log,RPAD(' ', 132, ' '));
1886: Fnd_File.PUT_LINE (Fnd_File.log,RPAD(' ', 132, ' '));
1887: Fnd_File.PUT_LINE (Fnd_File.log,RPAD(' ', 132, ' '));
1888: -- -------------------------------
1889: -- End Print processing Summary
1890: -- -------------------------------

Line 1887: Fnd_File.PUT_LINE (Fnd_File.log,RPAD(' ', 132, ' '));

1883: ||error_msg_rec.error_message);
1884: END LOOP;
1885: Fnd_File.PUT_LINE (Fnd_File.log,RPAD(' ', 132, ' '));
1886: Fnd_File.PUT_LINE (Fnd_File.log,RPAD(' ', 132, ' '));
1887: Fnd_File.PUT_LINE (Fnd_File.log,RPAD(' ', 132, ' '));
1888: -- -------------------------------
1889: -- End Print processing Summary
1890: -- -------------------------------
1891:

Line 1892: FND_FILE.PUT_LINE (FND_FILE.log, '================================================================');

1888: -- -------------------------------
1889: -- End Print processing Summary
1890: -- -------------------------------
1891:
1892: FND_FILE.PUT_LINE (FND_FILE.log, '================================================================');
1893: FND_FILE.PUT_LINE (FND_FILE.log, ' *** END PROCESSING THIRD PARTY BILLING RECORDS ***');
1894: FND_FILE.PUT_LINE (FND_FILE.log, '================================================================');
1895:
1896: ------------------------------------------------------------

Line 1893: FND_FILE.PUT_LINE (FND_FILE.log, ' * END PROCESSING THIRD PARTY BILLING RECORDS *');

1889: -- End Print processing Summary
1890: -- -------------------------------
1891:
1892: FND_FILE.PUT_LINE (FND_FILE.log, '================================================================');
1893: FND_FILE.PUT_LINE (FND_FILE.log, ' *** END PROCESSING THIRD PARTY BILLING RECORDS ***');
1894: FND_FILE.PUT_LINE (FND_FILE.log, '================================================================');
1895:
1896: ------------------------------------------------------------
1897: -- End processing

Line 1894: FND_FILE.PUT_LINE (FND_FILE.log, '================================================================');

1890: -- -------------------------------
1891:
1892: FND_FILE.PUT_LINE (FND_FILE.log, '================================================================');
1893: FND_FILE.PUT_LINE (FND_FILE.log, ' *** END PROCESSING THIRD PARTY BILLING RECORDS ***');
1894: FND_FILE.PUT_LINE (FND_FILE.log, '================================================================');
1895:
1896: ------------------------------------------------------------
1897: -- End processing
1898: ------------------------------------------------------------

Line 1913: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=>ERROR: '||SQLERRM);

1909: ------------------------------------------------------------
1910: -- Exception handling
1911: ------------------------------------------------------------
1912: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1913: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=>ERROR: '||SQLERRM);
1914: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1915: p_api_name => l_api_name,
1916: p_pkg_name => G_PKG_NAME,
1917: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',

Line 1922: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=>ERROR: '||SQLERRM);

1918: x_msg_count => x_msg_count,
1919: x_msg_data => x_msg_data,
1920: p_api_type => '_PVT');
1921: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1922: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=>ERROR: '||SQLERRM);
1923: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1924: p_api_name => l_api_name,
1925: p_pkg_name => G_PKG_NAME,
1926: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',

Line 1931: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=>ERROR: '||SQLERRM);

1927: x_msg_count => x_msg_count,
1928: x_msg_data => x_msg_data,
1929: p_api_type => '_PVT');
1930: WHEN OTHERS THEN
1931: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=>ERROR: '||SQLERRM);
1932: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1933: p_api_name => l_api_name,
1934: p_pkg_name => G_PKG_NAME,
1935: p_exc_name => 'OTHERS',