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 522: FND_FILE.PUT_LINE (FND_FILE.log, '================================================================');

518:
519: ------------------------------------------------------------
520: -- Process every external billing line for billing import
521: ------------------------------------------------------------
522: FND_FILE.PUT_LINE (FND_FILE.log, '================================================================');
523: FND_FILE.PUT_LINE (FND_FILE.log, ' *** START PROCESSING THIRD PARTY BILLING RECORDS ***');
524: FND_FILE.PUT_LINE (FND_FILE.log, '================================================================');
525:
526: -- -----------------------------------------------------

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

519: ------------------------------------------------------------
520: -- Process every external billing line for billing import
521: ------------------------------------------------------------
522: FND_FILE.PUT_LINE (FND_FILE.log, '================================================================');
523: FND_FILE.PUT_LINE (FND_FILE.log, ' *** START PROCESSING THIRD PARTY BILLING RECORDS ***');
524: FND_FILE.PUT_LINE (FND_FILE.log, '================================================================');
525:
526: -- -----------------------------------------------------
527: -- Fetch property tax

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

520: -- Process every external billing line for billing import
521: ------------------------------------------------------------
522: FND_FILE.PUT_LINE (FND_FILE.log, '================================================================');
523: FND_FILE.PUT_LINE (FND_FILE.log, ' *** START PROCESSING THIRD PARTY BILLING RECORDS ***');
524: FND_FILE.PUT_LINE (FND_FILE.log, '================================================================');
525:
526: -- -----------------------------------------------------
527: -- Fetch property tax
528: -- -----------------------------------------------------

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

548: -- --------------------------------------------
549: -- Print error message and stop processing
550: -- --------------------------------------------
551: if l_bill_try_id is null or l_cm_try_id is null then
552: FND_FILE.PUT_LINE (FND_FILE.log, '********************** ERROR **********************');
553: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'BILLING or CREDIT MEMO transaction type is invalid.');
554: FND_FILE.PUT_LINE (FND_FILE.log, '********************** ERROR **********************');
555:
556: RAISE OKL_API.G_EXCEPTION_ERROR;

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

549: -- Print error message and stop processing
550: -- --------------------------------------------
551: if l_bill_try_id is null or l_cm_try_id is null then
552: FND_FILE.PUT_LINE (FND_FILE.log, '********************** ERROR **********************');
553: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'BILLING or CREDIT MEMO transaction type is invalid.');
554: FND_FILE.PUT_LINE (FND_FILE.log, '********************** ERROR **********************');
555:
556: RAISE OKL_API.G_EXCEPTION_ERROR;
557: END IF;

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

550: -- --------------------------------------------
551: if l_bill_try_id is null or l_cm_try_id is null then
552: FND_FILE.PUT_LINE (FND_FILE.log, '********************** ERROR **********************');
553: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'BILLING or CREDIT MEMO transaction type is invalid.');
554: FND_FILE.PUT_LINE (FND_FILE.log, '********************** ERROR **********************');
555:
556: RAISE OKL_API.G_EXCEPTION_ERROR;
557: END IF;
558:

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

568: l_program_id := NULL;
569: end if;
570:
571: if l_request_id is null then
572: FND_FILE.PUT_LINE (FND_FILE.log, '********************** ERROR **********************');
573: FND_FILE.PUT_LINE (FND_FILE.log,
574: 'Cannot determine request Id from profile. The function Fnd_Global.CONC_REQUEST_ID returns -1.');
575: FND_FILE.PUT_LINE (FND_FILE.log, '********************** ERROR **********************');
576: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 573: FND_FILE.PUT_LINE (FND_FILE.log,

569: end if;
570:
571: if l_request_id is null then
572: FND_FILE.PUT_LINE (FND_FILE.log, '********************** ERROR **********************');
573: FND_FILE.PUT_LINE (FND_FILE.log,
574: 'Cannot determine request Id from profile. The function Fnd_Global.CONC_REQUEST_ID returns -1.');
575: FND_FILE.PUT_LINE (FND_FILE.log, '********************** ERROR **********************');
576: RAISE OKL_API.G_EXCEPTION_ERROR;
577: END IF;

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

571: if l_request_id is null then
572: FND_FILE.PUT_LINE (FND_FILE.log, '********************** ERROR **********************');
573: FND_FILE.PUT_LINE (FND_FILE.log,
574: 'Cannot determine request Id from profile. The function Fnd_Global.CONC_REQUEST_ID returns -1.');
575: FND_FILE.PUT_LINE (FND_FILE.log, '********************** ERROR **********************');
576: RAISE OKL_API.G_EXCEPTION_ERROR;
577: END IF;
578:
579: -- -------------------------------

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

1749: FETCH op_unit_csr INTO l_op_unit_name;
1750: CLOSE op_unit_csr;
1751:
1752: -- Start New Out File stmathew
1753: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'Oracle Leasing and Finance Management'||LPAD(' ', 55, ' '));
1754: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1755: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 53, ' ')||'Third Party Billing Import'||LPAD(' ', 53, ' '));
1756: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'------------------------'||LPAD(' ', 54, ' '));
1757: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

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

1750: CLOSE op_unit_csr;
1751:
1752: -- Start New Out File stmathew
1753: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'Oracle Leasing and Finance Management'||LPAD(' ', 55, ' '));
1754: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1755: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 53, ' ')||'Third Party Billing Import'||LPAD(' ', 53, ' '));
1756: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'------------------------'||LPAD(' ', 54, ' '));
1757: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1758: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

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

1751:
1752: -- Start New Out File stmathew
1753: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'Oracle Leasing and Finance Management'||LPAD(' ', 55, ' '));
1754: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1755: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 53, ' ')||'Third Party Billing Import'||LPAD(' ', 53, ' '));
1756: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'------------------------'||LPAD(' ', 54, ' '));
1757: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1758: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1759: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Operating Unit: '||l_op_unit_name);

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

1752: -- Start New Out File stmathew
1753: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'Oracle Leasing and Finance Management'||LPAD(' ', 55, ' '));
1754: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1755: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 53, ' ')||'Third Party Billing Import'||LPAD(' ', 53, ' '));
1756: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'------------------------'||LPAD(' ', 54, ' '));
1757: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1758: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1759: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Operating Unit: '||l_op_unit_name);
1760: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Request Id: '||l_request_id||LPAD(' ',74,' ') ||'Run Date: '||TO_CHAR(SYSDATE));

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

1753: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'Oracle Leasing and Finance Management'||LPAD(' ', 55, ' '));
1754: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1755: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 53, ' ')||'Third Party Billing Import'||LPAD(' ', 53, ' '));
1756: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'------------------------'||LPAD(' ', 54, ' '));
1757: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1758: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1759: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Operating Unit: '||l_op_unit_name);
1760: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Request Id: '||l_request_id||LPAD(' ',74,' ') ||'Run Date: '||TO_CHAR(SYSDATE));
1761: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);

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

1754: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1755: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 53, ' ')||'Third Party Billing Import'||LPAD(' ', 53, ' '));
1756: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'------------------------'||LPAD(' ', 54, ' '));
1757: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1758: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1759: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Operating Unit: '||l_op_unit_name);
1760: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Request Id: '||l_request_id||LPAD(' ',74,' ') ||'Run Date: '||TO_CHAR(SYSDATE));
1761: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);
1762: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));

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

1755: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 53, ' ')||'Third Party Billing Import'||LPAD(' ', 53, ' '));
1756: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'------------------------'||LPAD(' ', 54, ' '));
1757: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1758: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1759: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Operating Unit: '||l_op_unit_name);
1760: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Request Id: '||l_request_id||LPAD(' ',74,' ') ||'Run Date: '||TO_CHAR(SYSDATE));
1761: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);
1762: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
1763: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

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

1756: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 54, ' ')||'------------------------'||LPAD(' ', 54, ' '));
1757: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1758: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1759: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Operating Unit: '||l_op_unit_name);
1760: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Request Id: '||l_request_id||LPAD(' ',74,' ') ||'Run Date: '||TO_CHAR(SYSDATE));
1761: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);
1762: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
1763: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1764: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

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

1757: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1758: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1759: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Operating Unit: '||l_op_unit_name);
1760: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Request Id: '||l_request_id||LPAD(' ',74,' ') ||'Run Date: '||TO_CHAR(SYSDATE));
1761: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);
1762: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
1763: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1764: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1765: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Processing Details:'||LPAD(' ', 113, ' '));

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

1758: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1759: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Operating Unit: '||l_op_unit_name);
1760: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Request Id: '||l_request_id||LPAD(' ',74,' ') ||'Run Date: '||TO_CHAR(SYSDATE));
1761: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);
1762: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
1763: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1764: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1765: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Processing Details:'||LPAD(' ', 113, ' '));
1766: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

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

1759: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Operating Unit: '||l_op_unit_name);
1760: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Request Id: '||l_request_id||LPAD(' ',74,' ') ||'Run Date: '||TO_CHAR(SYSDATE));
1761: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);
1762: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
1763: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1764: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1765: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Processing Details:'||LPAD(' ', 113, ' '));
1766: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1767: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Actual Property Tax records: '||l_succ_apt_cnt);

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

1760: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Request Id: '||l_request_id||LPAD(' ',74,' ') ||'Run Date: '||TO_CHAR(SYSDATE));
1761: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);
1762: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
1763: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1764: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1765: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Processing Details:'||LPAD(' ', 113, ' '));
1766: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1767: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Actual Property Tax records: '||l_succ_apt_cnt);
1768: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Actual Property Tax records: '||l_err_apt_cnt);

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

1761: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Currency: '||Okl_Accounting_Util.get_func_curr_code);
1762: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
1763: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1764: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1765: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Processing Details:'||LPAD(' ', 113, ' '));
1766: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1767: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Actual Property Tax records: '||l_succ_apt_cnt);
1768: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Actual Property Tax records: '||l_err_apt_cnt);
1769: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Non-Actual Property Tax records: '||l_succ_non_apt_cnt);

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

1762: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
1763: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1764: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1765: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Processing Details:'||LPAD(' ', 113, ' '));
1766: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1767: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Actual Property Tax records: '||l_succ_apt_cnt);
1768: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Actual Property Tax records: '||l_err_apt_cnt);
1769: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Non-Actual Property Tax records: '||l_succ_non_apt_cnt);
1770: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Non-Actual Property Tax records: '||l_err_non_apt_cnt);

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

1763: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1764: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1765: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Processing Details:'||LPAD(' ', 113, ' '));
1766: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1767: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Actual Property Tax records: '||l_succ_apt_cnt);
1768: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Actual Property Tax records: '||l_err_apt_cnt);
1769: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Non-Actual Property Tax records: '||l_succ_non_apt_cnt);
1770: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Non-Actual Property Tax records: '||l_err_non_apt_cnt);
1771: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Total records processed: '||g_total_rec_count);

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

1764: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1765: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Processing Details:'||LPAD(' ', 113, ' '));
1766: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1767: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Actual Property Tax records: '||l_succ_apt_cnt);
1768: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Actual Property Tax records: '||l_err_apt_cnt);
1769: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Non-Actual Property Tax records: '||l_succ_non_apt_cnt);
1770: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Non-Actual Property Tax records: '||l_err_non_apt_cnt);
1771: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Total records processed: '||g_total_rec_count);
1772: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

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

1765: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,'Processing Details:'||LPAD(' ', 113, ' '));
1766: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1767: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Actual Property Tax records: '||l_succ_apt_cnt);
1768: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Actual Property Tax records: '||l_err_apt_cnt);
1769: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Non-Actual Property Tax records: '||l_succ_non_apt_cnt);
1770: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Non-Actual Property Tax records: '||l_err_non_apt_cnt);
1771: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Total records processed: '||g_total_rec_count);
1772: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1773: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));

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

1766: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1767: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Actual Property Tax records: '||l_succ_apt_cnt);
1768: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Actual Property Tax records: '||l_err_apt_cnt);
1769: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Non-Actual Property Tax records: '||l_succ_non_apt_cnt);
1770: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Non-Actual Property Tax records: '||l_err_non_apt_cnt);
1771: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Total records processed: '||g_total_rec_count);
1772: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1773: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
1774: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));

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

1767: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Actual Property Tax records: '||l_succ_apt_cnt);
1768: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Actual Property Tax records: '||l_err_apt_cnt);
1769: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Non-Actual Property Tax records: '||l_succ_non_apt_cnt);
1770: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Non-Actual Property Tax records: '||l_err_non_apt_cnt);
1771: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Total records processed: '||g_total_rec_count);
1772: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1773: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
1774: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1775:

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

1768: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Actual Property Tax records: '||l_err_apt_cnt);
1769: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Non-Actual Property Tax records: '||l_succ_non_apt_cnt);
1770: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Non-Actual Property Tax records: '||l_err_non_apt_cnt);
1771: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Total records processed: '||g_total_rec_count);
1772: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1773: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
1774: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1775:
1776: -- End New Out File stmathew

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

1769: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Successful Non-Actual Property Tax records: '||l_succ_non_apt_cnt);
1770: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Non-Actual Property Tax records: '||l_err_non_apt_cnt);
1771: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Total records processed: '||g_total_rec_count);
1772: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1773: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
1774: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1775:
1776: -- End New Out File stmathew
1777: IF x_msg_count > 0 THEN

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

1770: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Number of Errored Non-Actual Property Tax records: '||l_err_non_apt_cnt);
1771: Fnd_File.PUT_LINE (Fnd_File.OUTPUT, ' Total records processed: '||g_total_rec_count);
1772: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1773: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD('-', 132, '-'));
1774: Fnd_File.PUT_LINE (Fnd_File.OUTPUT,RPAD(' ', 132, ' '));
1775:
1776: -- End New Out File stmathew
1777: IF x_msg_count > 0 THEN
1778: FOR i IN 1..x_msg_count LOOP

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

1776: -- End New Out File stmathew
1777: IF x_msg_count > 0 THEN
1778: FOR i IN 1..x_msg_count LOOP
1779: IF i = 1 THEN
1780: Fnd_File.PUT_LINE (Fnd_File.log,'Details of TAPI errors:'||LPAD(' ', 97, ' '));
1781: Fnd_File.PUT_LINE (Fnd_File.log,RPAD(' ', 132, ' '));
1782: END IF;
1783: Fnd_Msg_Pub.get (p_msg_index => i,
1784: p_encoded => 'F',

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

1777: IF x_msg_count > 0 THEN
1778: FOR i IN 1..x_msg_count LOOP
1779: IF i = 1 THEN
1780: Fnd_File.PUT_LINE (Fnd_File.log,'Details of TAPI errors:'||LPAD(' ', 97, ' '));
1781: Fnd_File.PUT_LINE (Fnd_File.log,RPAD(' ', 132, ' '));
1782: END IF;
1783: Fnd_Msg_Pub.get (p_msg_index => i,
1784: p_encoded => 'F',
1785: p_data => lx_msg_data,

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

1783: Fnd_Msg_Pub.get (p_msg_index => i,
1784: p_encoded => 'F',
1785: p_data => lx_msg_data,
1786: p_msg_index_out => l_msg_index_out);
1787: Fnd_File.PUT_LINE (Fnd_File.log,TO_CHAR(i) || ': ' || lx_msg_data);
1788: END LOOP;
1789: END IF;
1790:
1791: -- ---------------------------------------------------------

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

1790:
1791: -- ---------------------------------------------------------
1792: -- print all error messages from okl_ext_billing_interface
1793: -- ---------------------------------------------------------
1794: Fnd_File.PUT_LINE (Fnd_File.log,RPAD(' ', 132, ' '));
1795: Fnd_File.PUT_LINE (Fnd_File.log,RPAD(' ', 132, ' '));
1796: Fnd_File.PUT_LINE (Fnd_File.log,'Contract Number'||LPAD(' ', 16, ' ')
1797: ||'Asset Number'||LPAD(' ', 19, ' ')
1798: ||'Stream Name'||LPAD(' ', 20, ' ')

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

1791: -- ---------------------------------------------------------
1792: -- print all error messages from okl_ext_billing_interface
1793: -- ---------------------------------------------------------
1794: Fnd_File.PUT_LINE (Fnd_File.log,RPAD(' ', 132, ' '));
1795: Fnd_File.PUT_LINE (Fnd_File.log,RPAD(' ', 132, ' '));
1796: Fnd_File.PUT_LINE (Fnd_File.log,'Contract Number'||LPAD(' ', 16, ' ')
1797: ||'Asset Number'||LPAD(' ', 19, ' ')
1798: ||'Stream Name'||LPAD(' ', 20, ' ')
1799: ||'Invoice Date'||' Error Message');

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

1792: -- print all error messages from okl_ext_billing_interface
1793: -- ---------------------------------------------------------
1794: Fnd_File.PUT_LINE (Fnd_File.log,RPAD(' ', 132, ' '));
1795: Fnd_File.PUT_LINE (Fnd_File.log,RPAD(' ', 132, ' '));
1796: Fnd_File.PUT_LINE (Fnd_File.log,'Contract Number'||LPAD(' ', 16, ' ')
1797: ||'Asset Number'||LPAD(' ', 19, ' ')
1798: ||'Stream Name'||LPAD(' ', 20, ' ')
1799: ||'Invoice Date'||' Error Message');
1800: Fnd_File.PUT_LINE (Fnd_File.log,'---------------'||LPAD(' ', 16, ' ')

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

1796: Fnd_File.PUT_LINE (Fnd_File.log,'Contract Number'||LPAD(' ', 16, ' ')
1797: ||'Asset Number'||LPAD(' ', 19, ' ')
1798: ||'Stream Name'||LPAD(' ', 20, ' ')
1799: ||'Invoice Date'||' Error Message');
1800: Fnd_File.PUT_LINE (Fnd_File.log,'---------------'||LPAD(' ', 16, ' ')
1801: ||'------------'||LPAD(' ', 19, ' ')
1802: ||'-----------'||LPAD(' ', 20, ' ')
1803: ||'------------'||' -------------');
1804:

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

1803: ||'------------'||' -------------');
1804:
1805: FOR error_msg_rec in error_msg_csr( l_request_id, 'ERROR' )
1806: LOOP
1807: Fnd_File.PUT_LINE (Fnd_File.log,error_msg_rec.contract_number||' '
1808: ||error_msg_rec.asset_number||' '
1809: ||error_msg_rec.sty_name||' '
1810: ||error_msg_rec.invoice_date||' '
1811: ||error_msg_rec.error_message);

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

1809: ||error_msg_rec.sty_name||' '
1810: ||error_msg_rec.invoice_date||' '
1811: ||error_msg_rec.error_message);
1812: END LOOP;
1813: Fnd_File.PUT_LINE (Fnd_File.log,RPAD(' ', 132, ' '));
1814: Fnd_File.PUT_LINE (Fnd_File.log,RPAD(' ', 132, ' '));
1815: Fnd_File.PUT_LINE (Fnd_File.log,RPAD(' ', 132, ' '));
1816: -- -------------------------------
1817: -- End Print processing Summary

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

1810: ||error_msg_rec.invoice_date||' '
1811: ||error_msg_rec.error_message);
1812: END LOOP;
1813: Fnd_File.PUT_LINE (Fnd_File.log,RPAD(' ', 132, ' '));
1814: Fnd_File.PUT_LINE (Fnd_File.log,RPAD(' ', 132, ' '));
1815: Fnd_File.PUT_LINE (Fnd_File.log,RPAD(' ', 132, ' '));
1816: -- -------------------------------
1817: -- End Print processing Summary
1818: -- -------------------------------

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

1811: ||error_msg_rec.error_message);
1812: END LOOP;
1813: Fnd_File.PUT_LINE (Fnd_File.log,RPAD(' ', 132, ' '));
1814: Fnd_File.PUT_LINE (Fnd_File.log,RPAD(' ', 132, ' '));
1815: Fnd_File.PUT_LINE (Fnd_File.log,RPAD(' ', 132, ' '));
1816: -- -------------------------------
1817: -- End Print processing Summary
1818: -- -------------------------------
1819:

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

1816: -- -------------------------------
1817: -- End Print processing Summary
1818: -- -------------------------------
1819:
1820: FND_FILE.PUT_LINE (FND_FILE.log, '================================================================');
1821: FND_FILE.PUT_LINE (FND_FILE.log, ' *** END PROCESSING THIRD PARTY BILLING RECORDS ***');
1822: FND_FILE.PUT_LINE (FND_FILE.log, '================================================================');
1823:
1824: ------------------------------------------------------------

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

1817: -- End Print processing Summary
1818: -- -------------------------------
1819:
1820: FND_FILE.PUT_LINE (FND_FILE.log, '================================================================');
1821: FND_FILE.PUT_LINE (FND_FILE.log, ' *** END PROCESSING THIRD PARTY BILLING RECORDS ***');
1822: FND_FILE.PUT_LINE (FND_FILE.log, '================================================================');
1823:
1824: ------------------------------------------------------------
1825: -- End processing

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

1818: -- -------------------------------
1819:
1820: FND_FILE.PUT_LINE (FND_FILE.log, '================================================================');
1821: FND_FILE.PUT_LINE (FND_FILE.log, ' *** END PROCESSING THIRD PARTY BILLING RECORDS ***');
1822: FND_FILE.PUT_LINE (FND_FILE.log, '================================================================');
1823:
1824: ------------------------------------------------------------
1825: -- End processing
1826: ------------------------------------------------------------

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

1837: ------------------------------------------------------------
1838: -- Exception handling
1839: ------------------------------------------------------------
1840: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1841: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=>ERROR: '||SQLERRM);
1842: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1843: p_api_name => l_api_name,
1844: p_pkg_name => G_PKG_NAME,
1845: p_exc_name => 'Okl_Api.G_RET_STS_ERROR',

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

1846: x_msg_count => x_msg_count,
1847: x_msg_data => x_msg_data,
1848: p_api_type => '_PVT');
1849: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1850: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=>ERROR: '||SQLERRM);
1851: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1852: p_api_name => l_api_name,
1853: p_pkg_name => G_PKG_NAME,
1854: p_exc_name => 'Okl_Api.G_RET_STS_UNEXP_ERROR',

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

1855: x_msg_count => x_msg_count,
1856: x_msg_data => x_msg_data,
1857: p_api_type => '_PVT');
1858: WHEN OTHERS THEN
1859: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=>ERROR: '||SQLERRM);
1860: x_return_status := Okl_Api.HANDLE_EXCEPTIONS (
1861: p_api_name => l_api_name,
1862: p_pkg_name => G_PKG_NAME,
1863: p_exc_name => 'OTHERS',