DBA Data[Home] [Help]

APPS.OKL_OPI_PVT dependencies on FND_FILE

Line 737: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS REPORTED = ' || l_cust_reported);

733: --dbms_output.PUT_LINE('CUSTOMERS NOT REPORTED = ' || l_cust_not_reported);
734: --dbms_output.PUT_LINE('CUSTOMERS TO BE REPORTED PROCESSED SUCCESSFULLY = ' || l_rows_processed);
735: --dbms_output.PUT_LINE('CUSTOMERS TO BE REPORTED NOT PROCESSED = ' || l_rows_failed);
736:
737: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS REPORTED = ' || l_cust_reported);
738: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS NOT REPORTED = ' || l_cust_not_reported);
739: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS TO BE REPORTED PROCESSED SUCCESSFULLY = ' || l_rows_processed);
740: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS TO BE REPORTED NOT PROCESSED = ' || l_rows_failed);
741:

Line 738: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS NOT REPORTED = ' || l_cust_not_reported);

734: --dbms_output.PUT_LINE('CUSTOMERS TO BE REPORTED PROCESSED SUCCESSFULLY = ' || l_rows_processed);
735: --dbms_output.PUT_LINE('CUSTOMERS TO BE REPORTED NOT PROCESSED = ' || l_rows_failed);
736:
737: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS REPORTED = ' || l_cust_reported);
738: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS NOT REPORTED = ' || l_cust_not_reported);
739: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS TO BE REPORTED PROCESSED SUCCESSFULLY = ' || l_rows_processed);
740: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS TO BE REPORTED NOT PROCESSED = ' || l_rows_failed);
741:
742: COMMIT;

Line 739: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS TO BE REPORTED PROCESSED SUCCESSFULLY = ' || l_rows_processed);

735: --dbms_output.PUT_LINE('CUSTOMERS TO BE REPORTED NOT PROCESSED = ' || l_rows_failed);
736:
737: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS REPORTED = ' || l_cust_reported);
738: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS NOT REPORTED = ' || l_cust_not_reported);
739: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS TO BE REPORTED PROCESSED SUCCESSFULLY = ' || l_rows_processed);
740: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS TO BE REPORTED NOT PROCESSED = ' || l_rows_failed);
741:
742: COMMIT;
743: EXCEPTION

Line 740: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS TO BE REPORTED NOT PROCESSED = ' || l_rows_failed);

736:
737: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS REPORTED = ' || l_cust_reported);
738: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS NOT REPORTED = ' || l_cust_not_reported);
739: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS TO BE REPORTED PROCESSED SUCCESSFULLY = ' || l_rows_processed);
740: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'CUSTOMERS TO BE REPORTED NOT PROCESSED = ' || l_rows_failed);
741:
742: COMMIT;
743: EXCEPTION
744: WHEN OTHERS THEN

Line 750: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'SQL ERROR : SQLCODE = ' || SQLCODE);

746: CLOSE l_report_all_csr;
747: END IF;
748: errbuf := substr(SQLERRM, 1, 200);
749: retcode := 1;
750: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'SQL ERROR : SQLCODE = ' || SQLCODE);
751: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, ' MESSAGE = ' || SQLERRM);
752: ROLLBACK;
753: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
754: END report_all_credit_bureau;

Line 751: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, ' MESSAGE = ' || SQLERRM);

747: END IF;
748: errbuf := substr(SQLERRM, 1, 200);
749: retcode := 1;
750: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, 'SQL ERROR : SQLCODE = ' || SQLCODE);
751: Fnd_File.PUT_LINE(Fnd_File.OUTPUT, ' MESSAGE = ' || SQLERRM);
752: ROLLBACK;
753: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
754: END report_all_credit_bureau;
755: */

Line 1466: fnd_file.put_line(fnd_file.log, 'OKL_OPEN_INT.OKL_OPEN_INT_PARTY_MERGE');

1462: l_count NUMBER(10) := 0;
1463: --
1464: BEGIN
1465: --
1466: fnd_file.put_line(fnd_file.log, 'OKL_OPEN_INT.OKL_OPEN_INT_PARTY_MERGE');
1467: --
1468: arp_message.set_line('OKL_OPEN_INT.OKL_OPEN_INT_PARTY_MERGE()+');
1469:
1470: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1523: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||

1519: exception
1520: when others then
1521: arp_message.set_line(G_PKG_NAME || '.' || l_api_name || ': ' || sqlerrm);
1522: --
1523: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
1524: 'OKL_OPEN_INT for = '|| p_from_id));
1525: --
1526: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
1527: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1526: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);

1522: --
1523: fnd_file.put_line(fnd_file.log,(G_PKG_NAME || '.' || l_api_name ||
1524: 'OKL_OPEN_INT for = '|| p_from_id));
1525: --
1526: fnd_file.put_line(fnd_file.log, G_PKG_NAME||'.'||l_api_name||':'||sqlerrm);
1527: x_return_status := FND_API.G_RET_STS_ERROR;
1528: end;
1529: end if;
1530: END OKL_OPEN_INT_PARTY_MERGE ;