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.ZX_API_PUB dependencies on FND_FILE

Line 1385: FND_FILE.put_line(which => FND_FILE.LOG

1381: END IF;
1382:
1383: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
1384: IF fnd_global.conc_request_id <> -1 AND l_dummy_number > 1 THEN
1385: FND_FILE.put_line(which => FND_FILE.LOG
1386: ,buff => 'Transfer_Mode: '||G_DATA_TRANSFER_MODE);
1387: FND_FILE.put_line(which => FND_FILE.LOG
1388: ,buff => 'ZX_API_PUB.Calculate.Statistics Start Time:'||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
1389: FND_FILE.put_line(which => FND_FILE.LOG

Line 1387: FND_FILE.put_line(which => FND_FILE.LOG

1383: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
1384: IF fnd_global.conc_request_id <> -1 AND l_dummy_number > 1 THEN
1385: FND_FILE.put_line(which => FND_FILE.LOG
1386: ,buff => 'Transfer_Mode: '||G_DATA_TRANSFER_MODE);
1387: FND_FILE.put_line(which => FND_FILE.LOG
1388: ,buff => 'ZX_API_PUB.Calculate.Statistics Start Time:'||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
1389: FND_FILE.put_line(which => FND_FILE.LOG
1390: ,buff => 'ZX_API_PUB.Calculate.Statistics End Time:'||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
1391: FND_FILE.put_line(which => FND_FILE.LOG

Line 1389: FND_FILE.put_line(which => FND_FILE.LOG

1385: FND_FILE.put_line(which => FND_FILE.LOG
1386: ,buff => 'Transfer_Mode: '||G_DATA_TRANSFER_MODE);
1387: FND_FILE.put_line(which => FND_FILE.LOG
1388: ,buff => 'ZX_API_PUB.Calculate.Statistics Start Time:'||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
1389: FND_FILE.put_line(which => FND_FILE.LOG
1390: ,buff => 'ZX_API_PUB.Calculate.Statistics End Time:'||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
1391: FND_FILE.put_line(which => FND_FILE.LOG
1392: ,buff => 'ZX_API_PUB.Calculate.Statistics Total Time:'||l_total_time);
1393: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

Line 1391: FND_FILE.put_line(which => FND_FILE.LOG

1387: FND_FILE.put_line(which => FND_FILE.LOG
1388: ,buff => 'ZX_API_PUB.Calculate.Statistics Start Time:'||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
1389: FND_FILE.put_line(which => FND_FILE.LOG
1390: ,buff => 'ZX_API_PUB.Calculate.Statistics End Time:'||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
1391: FND_FILE.put_line(which => FND_FILE.LOG
1392: ,buff => 'ZX_API_PUB.Calculate.Statistics Total Time:'||l_total_time);
1393: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
1394: FND_FILE.put_line(which => FND_FILE.LOG
1395: ,buff => 'ZX_API_PUB.Calculate.Statistics: Number of Records in ZX_TRX_HEADERS_GT :'||l_dummy_number);

Line 1394: FND_FILE.put_line(which => FND_FILE.LOG

1390: ,buff => 'ZX_API_PUB.Calculate.Statistics End Time:'||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
1391: FND_FILE.put_line(which => FND_FILE.LOG
1392: ,buff => 'ZX_API_PUB.Calculate.Statistics Total Time:'||l_total_time);
1393: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
1394: FND_FILE.put_line(which => FND_FILE.LOG
1395: ,buff => 'ZX_API_PUB.Calculate.Statistics: Number of Records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
1396: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
1397: FND_FILE.put_line(which => FND_FILE.LOG
1398: ,buff => 'ZX_API_PUB.Calculate.Statistics: Number of Records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);

Line 1397: FND_FILE.put_line(which => FND_FILE.LOG

1393: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
1394: FND_FILE.put_line(which => FND_FILE.LOG
1395: ,buff => 'ZX_API_PUB.Calculate.Statistics: Number of Records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
1396: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
1397: FND_FILE.put_line(which => FND_FILE.LOG
1398: ,buff => 'ZX_API_PUB.Calculate.Statistics: Number of Records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
1399: END IF;
1400:
1401: EXCEPTION

Line 1428: FND_FILE.put_line(which => FND_FILE.LOG

1424: END IF;
1425:
1426: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
1427: IF fnd_global.conc_request_id <> -1 AND l_dummy_number > 1 THEN
1428: FND_FILE.put_line(which => FND_FILE.LOG
1429: ,buff => 'Exception FND_API.G_EXC_ERROR : Transfer_Mode: '||G_DATA_TRANSFER_MODE);
1430: FND_FILE.put_line(which => FND_FILE.LOG
1431: ,buff => 'ZX_API_PUB.Calculate.Statistics Start Time:'||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
1432: FND_FILE.put_line(which => FND_FILE.LOG

Line 1430: FND_FILE.put_line(which => FND_FILE.LOG

1426: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
1427: IF fnd_global.conc_request_id <> -1 AND l_dummy_number > 1 THEN
1428: FND_FILE.put_line(which => FND_FILE.LOG
1429: ,buff => 'Exception FND_API.G_EXC_ERROR : Transfer_Mode: '||G_DATA_TRANSFER_MODE);
1430: FND_FILE.put_line(which => FND_FILE.LOG
1431: ,buff => 'ZX_API_PUB.Calculate.Statistics Start Time:'||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
1432: FND_FILE.put_line(which => FND_FILE.LOG
1433: ,buff => 'ZX_API_PUB.Calculate.Statistics End Time:'||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
1434: FND_FILE.put_line(which => FND_FILE.LOG

Line 1432: FND_FILE.put_line(which => FND_FILE.LOG

1428: FND_FILE.put_line(which => FND_FILE.LOG
1429: ,buff => 'Exception FND_API.G_EXC_ERROR : Transfer_Mode: '||G_DATA_TRANSFER_MODE);
1430: FND_FILE.put_line(which => FND_FILE.LOG
1431: ,buff => 'ZX_API_PUB.Calculate.Statistics Start Time:'||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
1432: FND_FILE.put_line(which => FND_FILE.LOG
1433: ,buff => 'ZX_API_PUB.Calculate.Statistics End Time:'||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
1434: FND_FILE.put_line(which => FND_FILE.LOG
1435: ,buff => 'ZX_API_PUB.Calculate.Statistics Total Time:'||l_total_time);
1436: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

Line 1434: FND_FILE.put_line(which => FND_FILE.LOG

1430: FND_FILE.put_line(which => FND_FILE.LOG
1431: ,buff => 'ZX_API_PUB.Calculate.Statistics Start Time:'||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
1432: FND_FILE.put_line(which => FND_FILE.LOG
1433: ,buff => 'ZX_API_PUB.Calculate.Statistics End Time:'||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
1434: FND_FILE.put_line(which => FND_FILE.LOG
1435: ,buff => 'ZX_API_PUB.Calculate.Statistics Total Time:'||l_total_time);
1436: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
1437: FND_FILE.put_line(which => FND_FILE.LOG
1438: ,buff => 'ZX_API_PUB.Calculate.Statistics: Number of Records in ZX_TRX_HEADERS_GT :'||l_dummy_number);

Line 1437: FND_FILE.put_line(which => FND_FILE.LOG

1433: ,buff => 'ZX_API_PUB.Calculate.Statistics End Time:'||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
1434: FND_FILE.put_line(which => FND_FILE.LOG
1435: ,buff => 'ZX_API_PUB.Calculate.Statistics Total Time:'||l_total_time);
1436: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
1437: FND_FILE.put_line(which => FND_FILE.LOG
1438: ,buff => 'ZX_API_PUB.Calculate.Statistics: Number of Records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
1439: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
1440: FND_FILE.put_line(which => FND_FILE.LOG
1441: ,buff => 'ZX_API_PUB.Calculate.Statistics: Number of Records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);

Line 1440: FND_FILE.put_line(which => FND_FILE.LOG

1436: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
1437: FND_FILE.put_line(which => FND_FILE.LOG
1438: ,buff => 'ZX_API_PUB.Calculate.Statistics: Number of Records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
1439: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
1440: FND_FILE.put_line(which => FND_FILE.LOG
1441: ,buff => 'ZX_API_PUB.Calculate.Statistics: Number of Records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
1442: END IF;
1443:
1444: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1475: FND_FILE.put_line(which => FND_FILE.LOG

1471: END IF;
1472:
1473: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
1474: IF fnd_global.conc_request_id <> -1 AND l_dummy_number > 1 THEN
1475: FND_FILE.put_line(which => FND_FILE.LOG
1476: ,buff => 'Exception FND_API.G_EXC_UNEXPECTED_ERROR : Transfer_Mode: '||G_DATA_TRANSFER_MODE);
1477: FND_FILE.put_line(which => FND_FILE.LOG
1478: ,buff => 'ZX_API_PUB.Calculate.Statistics Start Time:'||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
1479: FND_FILE.put_line(which => FND_FILE.LOG

Line 1477: FND_FILE.put_line(which => FND_FILE.LOG

1473: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
1474: IF fnd_global.conc_request_id <> -1 AND l_dummy_number > 1 THEN
1475: FND_FILE.put_line(which => FND_FILE.LOG
1476: ,buff => 'Exception FND_API.G_EXC_UNEXPECTED_ERROR : Transfer_Mode: '||G_DATA_TRANSFER_MODE);
1477: FND_FILE.put_line(which => FND_FILE.LOG
1478: ,buff => 'ZX_API_PUB.Calculate.Statistics Start Time:'||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
1479: FND_FILE.put_line(which => FND_FILE.LOG
1480: ,buff => 'ZX_API_PUB.Calculate.Statistics End Time:'||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
1481: FND_FILE.put_line(which => FND_FILE.LOG

Line 1479: FND_FILE.put_line(which => FND_FILE.LOG

1475: FND_FILE.put_line(which => FND_FILE.LOG
1476: ,buff => 'Exception FND_API.G_EXC_UNEXPECTED_ERROR : Transfer_Mode: '||G_DATA_TRANSFER_MODE);
1477: FND_FILE.put_line(which => FND_FILE.LOG
1478: ,buff => 'ZX_API_PUB.Calculate.Statistics Start Time:'||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
1479: FND_FILE.put_line(which => FND_FILE.LOG
1480: ,buff => 'ZX_API_PUB.Calculate.Statistics End Time:'||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
1481: FND_FILE.put_line(which => FND_FILE.LOG
1482: ,buff => 'ZX_API_PUB.Calculate.Statistics Total Time:'||l_total_time);
1483: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

Line 1481: FND_FILE.put_line(which => FND_FILE.LOG

1477: FND_FILE.put_line(which => FND_FILE.LOG
1478: ,buff => 'ZX_API_PUB.Calculate.Statistics Start Time:'||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
1479: FND_FILE.put_line(which => FND_FILE.LOG
1480: ,buff => 'ZX_API_PUB.Calculate.Statistics End Time:'||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
1481: FND_FILE.put_line(which => FND_FILE.LOG
1482: ,buff => 'ZX_API_PUB.Calculate.Statistics Total Time:'||l_total_time);
1483: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
1484: FND_FILE.put_line(which => FND_FILE.LOG
1485: ,buff => 'ZX_API_PUB.Calculate.Statistics: Number of Records in ZX_TRX_HEADERS_GT :'||l_dummy_number);

Line 1484: FND_FILE.put_line(which => FND_FILE.LOG

1480: ,buff => 'ZX_API_PUB.Calculate.Statistics End Time:'||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
1481: FND_FILE.put_line(which => FND_FILE.LOG
1482: ,buff => 'ZX_API_PUB.Calculate.Statistics Total Time:'||l_total_time);
1483: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
1484: FND_FILE.put_line(which => FND_FILE.LOG
1485: ,buff => 'ZX_API_PUB.Calculate.Statistics: Number of Records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
1486: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
1487: FND_FILE.put_line(which => FND_FILE.LOG
1488: ,buff => 'ZX_API_PUB.Calculate.Statistics: Number of Records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);

Line 1487: FND_FILE.put_line(which => FND_FILE.LOG

1483: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
1484: FND_FILE.put_line(which => FND_FILE.LOG
1485: ,buff => 'ZX_API_PUB.Calculate.Statistics: Number of Records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
1486: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
1487: FND_FILE.put_line(which => FND_FILE.LOG
1488: ,buff => 'ZX_API_PUB.Calculate.Statistics: Number of Records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
1489: END IF;
1490:
1491: WHEN OTHERS THEN

Line 1516: FND_FILE.put_line(which => FND_FILE.LOG

1512: END IF;
1513:
1514: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
1515: IF fnd_global.conc_request_id <> -1 AND l_dummy_number > 1 THEN
1516: FND_FILE.put_line(which => FND_FILE.LOG
1517: ,buff => 'Exception OTHERS : Transfer_Mode: '||G_DATA_TRANSFER_MODE);
1518: FND_FILE.put_line(which => FND_FILE.LOG
1519: ,buff => 'ZX_API_PUB.Calculate.Statistics Start Time:'||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
1520: FND_FILE.put_line(which => FND_FILE.LOG

Line 1518: FND_FILE.put_line(which => FND_FILE.LOG

1514: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
1515: IF fnd_global.conc_request_id <> -1 AND l_dummy_number > 1 THEN
1516: FND_FILE.put_line(which => FND_FILE.LOG
1517: ,buff => 'Exception OTHERS : Transfer_Mode: '||G_DATA_TRANSFER_MODE);
1518: FND_FILE.put_line(which => FND_FILE.LOG
1519: ,buff => 'ZX_API_PUB.Calculate.Statistics Start Time:'||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
1520: FND_FILE.put_line(which => FND_FILE.LOG
1521: ,buff => 'ZX_API_PUB.Calculate.Statistics End Time:'||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
1522: FND_FILE.put_line(which => FND_FILE.LOG

Line 1520: FND_FILE.put_line(which => FND_FILE.LOG

1516: FND_FILE.put_line(which => FND_FILE.LOG
1517: ,buff => 'Exception OTHERS : Transfer_Mode: '||G_DATA_TRANSFER_MODE);
1518: FND_FILE.put_line(which => FND_FILE.LOG
1519: ,buff => 'ZX_API_PUB.Calculate.Statistics Start Time:'||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
1520: FND_FILE.put_line(which => FND_FILE.LOG
1521: ,buff => 'ZX_API_PUB.Calculate.Statistics End Time:'||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
1522: FND_FILE.put_line(which => FND_FILE.LOG
1523: ,buff => 'ZX_API_PUB.Calculate.Statistics Total Time:'||l_total_time);
1524: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

Line 1522: FND_FILE.put_line(which => FND_FILE.LOG

1518: FND_FILE.put_line(which => FND_FILE.LOG
1519: ,buff => 'ZX_API_PUB.Calculate.Statistics Start Time:'||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
1520: FND_FILE.put_line(which => FND_FILE.LOG
1521: ,buff => 'ZX_API_PUB.Calculate.Statistics End Time:'||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
1522: FND_FILE.put_line(which => FND_FILE.LOG
1523: ,buff => 'ZX_API_PUB.Calculate.Statistics Total Time:'||l_total_time);
1524: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
1525: FND_FILE.put_line(which => FND_FILE.LOG
1526: ,buff => 'ZX_API_PUB.Calculate.Statistics: Number of Records in ZX_TRX_HEADERS_GT :'||l_dummy_number);

Line 1525: FND_FILE.put_line(which => FND_FILE.LOG

1521: ,buff => 'ZX_API_PUB.Calculate.Statistics End Time:'||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
1522: FND_FILE.put_line(which => FND_FILE.LOG
1523: ,buff => 'ZX_API_PUB.Calculate.Statistics Total Time:'||l_total_time);
1524: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
1525: FND_FILE.put_line(which => FND_FILE.LOG
1526: ,buff => 'ZX_API_PUB.Calculate.Statistics: Number of Records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
1527: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
1528: FND_FILE.put_line(which => FND_FILE.LOG
1529: ,buff => 'ZX_API_PUB.Calculate.Statistics: Number of Records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);

Line 1528: FND_FILE.put_line(which => FND_FILE.LOG

1524: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
1525: FND_FILE.put_line(which => FND_FILE.LOG
1526: ,buff => 'ZX_API_PUB.Calculate.Statistics: Number of Records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
1527: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
1528: FND_FILE.put_line(which => FND_FILE.LOG
1529: ,buff => 'ZX_API_PUB.Calculate.Statistics: Number of Records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
1530: END IF;
1531:
1532:

Line 2235: FND_FILE.put_line(which => FND_FILE.LOG

2231: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||' Statistics','Total Time :'|| l_total_time);
2232: END IF;
2233:
2234: IF fnd_global.conc_request_id <> -1 THEN
2235: FND_FILE.put_line(which => FND_FILE.LOG
2236: ,buff => 'Transfer_Mode: '||G_DATA_TRANSFER_MODE);
2237: FND_FILE.put_line(which => FND_FILE.LOG
2238: ,buff => 'ZX_API_PUB.CALCULATE.Statistics Start Time:'
2239: ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));

Line 2237: FND_FILE.put_line(which => FND_FILE.LOG

2233:
2234: IF fnd_global.conc_request_id <> -1 THEN
2235: FND_FILE.put_line(which => FND_FILE.LOG
2236: ,buff => 'Transfer_Mode: '||G_DATA_TRANSFER_MODE);
2237: FND_FILE.put_line(which => FND_FILE.LOG
2238: ,buff => 'ZX_API_PUB.CALCULATE.Statistics Start Time:'
2239: ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
2240: FND_FILE.put_line(which => FND_FILE.LOG
2241: ,buff => 'ZX_API_PUB.CALCULATE.Statistics End Time:'

Line 2240: FND_FILE.put_line(which => FND_FILE.LOG

2236: ,buff => 'Transfer_Mode: '||G_DATA_TRANSFER_MODE);
2237: FND_FILE.put_line(which => FND_FILE.LOG
2238: ,buff => 'ZX_API_PUB.CALCULATE.Statistics Start Time:'
2239: ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
2240: FND_FILE.put_line(which => FND_FILE.LOG
2241: ,buff => 'ZX_API_PUB.CALCULATE.Statistics End Time:'
2242: ||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
2243: FND_FILE.put_line(which => FND_FILE.LOG
2244: ,buff => 'ZX_API_PUB.CALCULATE.Statistics Total Time:'

Line 2243: FND_FILE.put_line(which => FND_FILE.LOG

2239: ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
2240: FND_FILE.put_line(which => FND_FILE.LOG
2241: ,buff => 'ZX_API_PUB.CALCULATE.Statistics End Time:'
2242: ||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
2243: FND_FILE.put_line(which => FND_FILE.LOG
2244: ,buff => 'ZX_API_PUB.CALCULATE.Statistics Total Time:'
2245: ||l_total_time);
2246: END IF;
2247:

Line 2279: FND_FILE.put_line(which => FND_FILE.LOG

2275: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Total Time :'|| l_total_time);
2276: END IF;
2277:
2278: IF fnd_global.conc_request_id <> -1 THEN
2279: FND_FILE.put_line(which => FND_FILE.LOG
2280: ,buff => 'ZX_API_PUB.CALCULATE.Exception FND_API.G_EXC_ERROR Transfer_Mode: '||G_DATA_TRANSFER_MODE);
2281: FND_FILE.put_line(which => FND_FILE.LOG
2282: ,buff => 'ZX_API_PUB.CALCULATE.Statistics Start Time:'
2283: ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));

Line 2281: FND_FILE.put_line(which => FND_FILE.LOG

2277:
2278: IF fnd_global.conc_request_id <> -1 THEN
2279: FND_FILE.put_line(which => FND_FILE.LOG
2280: ,buff => 'ZX_API_PUB.CALCULATE.Exception FND_API.G_EXC_ERROR Transfer_Mode: '||G_DATA_TRANSFER_MODE);
2281: FND_FILE.put_line(which => FND_FILE.LOG
2282: ,buff => 'ZX_API_PUB.CALCULATE.Statistics Start Time:'
2283: ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
2284: FND_FILE.put_line(which => FND_FILE.LOG
2285: ,buff => 'ZX_API_PUB.CALCULATE.Statistics End Time:'

Line 2284: FND_FILE.put_line(which => FND_FILE.LOG

2280: ,buff => 'ZX_API_PUB.CALCULATE.Exception FND_API.G_EXC_ERROR Transfer_Mode: '||G_DATA_TRANSFER_MODE);
2281: FND_FILE.put_line(which => FND_FILE.LOG
2282: ,buff => 'ZX_API_PUB.CALCULATE.Statistics Start Time:'
2283: ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
2284: FND_FILE.put_line(which => FND_FILE.LOG
2285: ,buff => 'ZX_API_PUB.CALCULATE.Statistics End Time:'
2286: ||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
2287: FND_FILE.put_line(which => FND_FILE.LOG
2288: ,buff => 'ZX_API_PUB.CALCULATE.Statistics Total Time:'

Line 2287: FND_FILE.put_line(which => FND_FILE.LOG

2283: ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
2284: FND_FILE.put_line(which => FND_FILE.LOG
2285: ,buff => 'ZX_API_PUB.CALCULATE.Statistics End Time:'
2286: ||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
2287: FND_FILE.put_line(which => FND_FILE.LOG
2288: ,buff => 'ZX_API_PUB.CALCULATE.Statistics Total Time:'
2289: ||l_total_time);
2290: END IF;
2291:

Line 2322: FND_FILE.put_line(which => FND_FILE.LOG

2318: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Total Time :'|| l_total_time);
2319: END IF;
2320:
2321: IF fnd_global.conc_request_id <> -1 THEN
2322: FND_FILE.put_line(which => FND_FILE.LOG
2323: ,buff => 'ZX_API_PUB.CALCULATE.Exception FND_API.G_EXC_UNEXPECTED_ERROR Transfer_Mode: '||G_DATA_TRANSFER_MODE);
2324: FND_FILE.put_line(which => FND_FILE.LOG
2325: ,buff => 'ZX_API_PUB.CALCULATE.Statistics Start Time:'
2326: ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));

Line 2324: FND_FILE.put_line(which => FND_FILE.LOG

2320:
2321: IF fnd_global.conc_request_id <> -1 THEN
2322: FND_FILE.put_line(which => FND_FILE.LOG
2323: ,buff => 'ZX_API_PUB.CALCULATE.Exception FND_API.G_EXC_UNEXPECTED_ERROR Transfer_Mode: '||G_DATA_TRANSFER_MODE);
2324: FND_FILE.put_line(which => FND_FILE.LOG
2325: ,buff => 'ZX_API_PUB.CALCULATE.Statistics Start Time:'
2326: ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
2327: FND_FILE.put_line(which => FND_FILE.LOG
2328: ,buff => 'ZX_API_PUB.CALCULATE.Statistics End Time:'

Line 2327: FND_FILE.put_line(which => FND_FILE.LOG

2323: ,buff => 'ZX_API_PUB.CALCULATE.Exception FND_API.G_EXC_UNEXPECTED_ERROR Transfer_Mode: '||G_DATA_TRANSFER_MODE);
2324: FND_FILE.put_line(which => FND_FILE.LOG
2325: ,buff => 'ZX_API_PUB.CALCULATE.Statistics Start Time:'
2326: ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
2327: FND_FILE.put_line(which => FND_FILE.LOG
2328: ,buff => 'ZX_API_PUB.CALCULATE.Statistics End Time:'
2329: ||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
2330: FND_FILE.put_line(which => FND_FILE.LOG
2331: ,buff => 'ZX_API_PUB.CALCULATE.Statistics Total Time:'

Line 2330: FND_FILE.put_line(which => FND_FILE.LOG

2326: ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
2327: FND_FILE.put_line(which => FND_FILE.LOG
2328: ,buff => 'ZX_API_PUB.CALCULATE.Statistics End Time:'
2329: ||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
2330: FND_FILE.put_line(which => FND_FILE.LOG
2331: ,buff => 'ZX_API_PUB.CALCULATE.Statistics Total Time:'
2332: ||l_total_time);
2333: END IF;
2334:

Line 2362: FND_FILE.put_line(which => FND_FILE.LOG

2358: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Total Time :'|| l_total_time);
2359: END IF;
2360:
2361: IF fnd_global.conc_request_id <> -1 THEN
2362: FND_FILE.put_line(which => FND_FILE.LOG
2363: ,buff => 'ZX_API_PUB.CALCULATE.Exception OTHERS Transfer_Mode: '||G_DATA_TRANSFER_MODE);
2364: FND_FILE.put_line(which => FND_FILE.LOG
2365: ,buff => 'ZX_API_PUB.CALCULATE.Statistics Start Time:'
2366: ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));

Line 2364: FND_FILE.put_line(which => FND_FILE.LOG

2360:
2361: IF fnd_global.conc_request_id <> -1 THEN
2362: FND_FILE.put_line(which => FND_FILE.LOG
2363: ,buff => 'ZX_API_PUB.CALCULATE.Exception OTHERS Transfer_Mode: '||G_DATA_TRANSFER_MODE);
2364: FND_FILE.put_line(which => FND_FILE.LOG
2365: ,buff => 'ZX_API_PUB.CALCULATE.Statistics Start Time:'
2366: ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
2367: FND_FILE.put_line(which => FND_FILE.LOG
2368: ,buff => 'ZX_API_PUB.CALCULATE.Statistics End Time:'

Line 2367: FND_FILE.put_line(which => FND_FILE.LOG

2363: ,buff => 'ZX_API_PUB.CALCULATE.Exception OTHERS Transfer_Mode: '||G_DATA_TRANSFER_MODE);
2364: FND_FILE.put_line(which => FND_FILE.LOG
2365: ,buff => 'ZX_API_PUB.CALCULATE.Statistics Start Time:'
2366: ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
2367: FND_FILE.put_line(which => FND_FILE.LOG
2368: ,buff => 'ZX_API_PUB.CALCULATE.Statistics End Time:'
2369: ||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
2370: FND_FILE.put_line(which => FND_FILE.LOG
2371: ,buff => 'ZX_API_PUB.CALCULATE.Statistics Total Time:'

Line 2370: FND_FILE.put_line(which => FND_FILE.LOG

2366: ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
2367: FND_FILE.put_line(which => FND_FILE.LOG
2368: ,buff => 'ZX_API_PUB.CALCULATE.Statistics End Time:'
2369: ||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
2370: FND_FILE.put_line(which => FND_FILE.LOG
2371: ,buff => 'ZX_API_PUB.CALCULATE.Statistics Total Time:'
2372: ||l_total_time);
2373: END IF;
2374:

Line 2778: FND_FILE.put_line(which => FND_FILE.LOG

2774: END IF;
2775:
2776: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
2777: IF fnd_global.conc_request_id <> -1 AND l_dummy_number > 1 THEN
2778: FND_FILE.put_line(which => FND_FILE.LOG
2779: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics Start Time:' ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
2780: FND_FILE.put_line(which => FND_FILE.LOG
2781: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics End Time:' ||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
2782: FND_FILE.put_line(which => FND_FILE.LOG

Line 2780: FND_FILE.put_line(which => FND_FILE.LOG

2776: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
2777: IF fnd_global.conc_request_id <> -1 AND l_dummy_number > 1 THEN
2778: FND_FILE.put_line(which => FND_FILE.LOG
2779: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics Start Time:' ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
2780: FND_FILE.put_line(which => FND_FILE.LOG
2781: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics End Time:' ||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
2782: FND_FILE.put_line(which => FND_FILE.LOG
2783: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics Total Time:' ||l_total_time);
2784: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

Line 2782: FND_FILE.put_line(which => FND_FILE.LOG

2778: FND_FILE.put_line(which => FND_FILE.LOG
2779: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics Start Time:' ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
2780: FND_FILE.put_line(which => FND_FILE.LOG
2781: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics End Time:' ||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
2782: FND_FILE.put_line(which => FND_FILE.LOG
2783: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics Total Time:' ||l_total_time);
2784: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
2785: FND_FILE.put_line(which => FND_FILE.LOG
2786: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRX_HEADERS_GT :'||l_dummy_number);

Line 2785: FND_FILE.put_line(which => FND_FILE.LOG

2781: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics End Time:' ||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
2782: FND_FILE.put_line(which => FND_FILE.LOG
2783: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics Total Time:' ||l_total_time);
2784: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
2785: FND_FILE.put_line(which => FND_FILE.LOG
2786: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
2787: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
2788: FND_FILE.put_line(which => FND_FILE.LOG
2789: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);

Line 2788: FND_FILE.put_line(which => FND_FILE.LOG

2784: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
2785: FND_FILE.put_line(which => FND_FILE.LOG
2786: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
2787: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
2788: FND_FILE.put_line(which => FND_FILE.LOG
2789: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
2790: SELECT COUNT(*) INTO l_dummy_number FROM ZX_IMPORT_TAX_LINES_GT;
2791: FND_FILE.put_line(which => FND_FILE.Log
2792: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_IMPORT_TAX_LINES_GT :'||l_dummy_number);

Line 2791: FND_FILE.put_line(which => FND_FILE.Log

2787: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
2788: FND_FILE.put_line(which => FND_FILE.LOG
2789: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
2790: SELECT COUNT(*) INTO l_dummy_number FROM ZX_IMPORT_TAX_LINES_GT;
2791: FND_FILE.put_line(which => FND_FILE.Log
2792: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_IMPORT_TAX_LINES_GT :'||l_dummy_number);
2793: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_TAX_LINK_GT;
2794: FND_FILE.put_line(which => FND_FILE.LOG
2795: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRX_TAX_LINK_GT :'||l_dummy_number);

Line 2794: FND_FILE.put_line(which => FND_FILE.LOG

2790: SELECT COUNT(*) INTO l_dummy_number FROM ZX_IMPORT_TAX_LINES_GT;
2791: FND_FILE.put_line(which => FND_FILE.Log
2792: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_IMPORT_TAX_LINES_GT :'||l_dummy_number);
2793: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_TAX_LINK_GT;
2794: FND_FILE.put_line(which => FND_FILE.LOG
2795: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRX_TAX_LINK_GT :'||l_dummy_number);
2796: END IF;
2797:
2798:

Line 2830: FND_FILE.put_line(which => FND_FILE.LOG

2826: END IF;
2827:
2828: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
2829: IF fnd_global.conc_request_id <> -1 AND l_dummy_number > 1 THEN
2830: FND_FILE.put_line(which => FND_FILE.LOG
2831: ,buff => 'ZX_API_PUB.import_document_with_tax.Exception FND_API.G_EXC_ERROR');
2832: FND_FILE.put_line(which => FND_FILE.LOG
2833: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics Start Time:' ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
2834: FND_FILE.put_line(which => FND_FILE.LOG

Line 2832: FND_FILE.put_line(which => FND_FILE.LOG

2828: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
2829: IF fnd_global.conc_request_id <> -1 AND l_dummy_number > 1 THEN
2830: FND_FILE.put_line(which => FND_FILE.LOG
2831: ,buff => 'ZX_API_PUB.import_document_with_tax.Exception FND_API.G_EXC_ERROR');
2832: FND_FILE.put_line(which => FND_FILE.LOG
2833: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics Start Time:' ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
2834: FND_FILE.put_line(which => FND_FILE.LOG
2835: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics End Time:' ||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
2836: FND_FILE.put_line(which => FND_FILE.LOG

Line 2834: FND_FILE.put_line(which => FND_FILE.LOG

2830: FND_FILE.put_line(which => FND_FILE.LOG
2831: ,buff => 'ZX_API_PUB.import_document_with_tax.Exception FND_API.G_EXC_ERROR');
2832: FND_FILE.put_line(which => FND_FILE.LOG
2833: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics Start Time:' ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
2834: FND_FILE.put_line(which => FND_FILE.LOG
2835: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics End Time:' ||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
2836: FND_FILE.put_line(which => FND_FILE.LOG
2837: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics Total Time:' ||l_total_time);
2838: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

Line 2836: FND_FILE.put_line(which => FND_FILE.LOG

2832: FND_FILE.put_line(which => FND_FILE.LOG
2833: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics Start Time:' ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
2834: FND_FILE.put_line(which => FND_FILE.LOG
2835: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics End Time:' ||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
2836: FND_FILE.put_line(which => FND_FILE.LOG
2837: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics Total Time:' ||l_total_time);
2838: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
2839: FND_FILE.put_line(which => FND_FILE.LOG
2840: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRX_HEADERS_GT :'||l_dummy_number);

Line 2839: FND_FILE.put_line(which => FND_FILE.LOG

2835: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics End Time:' ||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
2836: FND_FILE.put_line(which => FND_FILE.LOG
2837: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics Total Time:' ||l_total_time);
2838: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
2839: FND_FILE.put_line(which => FND_FILE.LOG
2840: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
2841: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
2842: FND_FILE.put_line(which => FND_FILE.LOG
2843: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);

Line 2842: FND_FILE.put_line(which => FND_FILE.LOG

2838: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
2839: FND_FILE.put_line(which => FND_FILE.LOG
2840: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
2841: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
2842: FND_FILE.put_line(which => FND_FILE.LOG
2843: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
2844: SELECT COUNT(*) INTO l_dummy_number FROM ZX_IMPORT_TAX_LINES_GT;
2845: FND_FILE.put_line(which => FND_FILE.Log
2846: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_IMPORT_TAX_LINES_GT :'||l_dummy_number);

Line 2845: FND_FILE.put_line(which => FND_FILE.Log

2841: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
2842: FND_FILE.put_line(which => FND_FILE.LOG
2843: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
2844: SELECT COUNT(*) INTO l_dummy_number FROM ZX_IMPORT_TAX_LINES_GT;
2845: FND_FILE.put_line(which => FND_FILE.Log
2846: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_IMPORT_TAX_LINES_GT :'||l_dummy_number);
2847: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_TAX_LINK_GT;
2848: FND_FILE.put_line(which => FND_FILE.LOG
2849: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRX_TAX_LINK_GT :'||l_dummy_number);

Line 2848: FND_FILE.put_line(which => FND_FILE.LOG

2844: SELECT COUNT(*) INTO l_dummy_number FROM ZX_IMPORT_TAX_LINES_GT;
2845: FND_FILE.put_line(which => FND_FILE.Log
2846: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_IMPORT_TAX_LINES_GT :'||l_dummy_number);
2847: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_TAX_LINK_GT;
2848: FND_FILE.put_line(which => FND_FILE.LOG
2849: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRX_TAX_LINK_GT :'||l_dummy_number);
2850: END IF;
2851:
2852:

Line 2894: FND_FILE.put_line(which => FND_FILE.LOG

2890: END IF;
2891:
2892: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
2893: IF fnd_global.conc_request_id <> -1 AND l_dummy_number > 1 THEN
2894: FND_FILE.put_line(which => FND_FILE.LOG
2895: ,buff => 'ZX_API_PUB.import_document_with_tax.Exception FND_API.G_EXC_UNEXPECTED_ERROR');
2896: FND_FILE.put_line(which => FND_FILE.LOG
2897: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics Start Time:' ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
2898: FND_FILE.put_line(which => FND_FILE.LOG

Line 2896: FND_FILE.put_line(which => FND_FILE.LOG

2892: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
2893: IF fnd_global.conc_request_id <> -1 AND l_dummy_number > 1 THEN
2894: FND_FILE.put_line(which => FND_FILE.LOG
2895: ,buff => 'ZX_API_PUB.import_document_with_tax.Exception FND_API.G_EXC_UNEXPECTED_ERROR');
2896: FND_FILE.put_line(which => FND_FILE.LOG
2897: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics Start Time:' ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
2898: FND_FILE.put_line(which => FND_FILE.LOG
2899: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics End Time:' ||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
2900: FND_FILE.put_line(which => FND_FILE.LOG

Line 2898: FND_FILE.put_line(which => FND_FILE.LOG

2894: FND_FILE.put_line(which => FND_FILE.LOG
2895: ,buff => 'ZX_API_PUB.import_document_with_tax.Exception FND_API.G_EXC_UNEXPECTED_ERROR');
2896: FND_FILE.put_line(which => FND_FILE.LOG
2897: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics Start Time:' ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
2898: FND_FILE.put_line(which => FND_FILE.LOG
2899: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics End Time:' ||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
2900: FND_FILE.put_line(which => FND_FILE.LOG
2901: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics Total Time:' ||l_total_time);
2902: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

Line 2900: FND_FILE.put_line(which => FND_FILE.LOG

2896: FND_FILE.put_line(which => FND_FILE.LOG
2897: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics Start Time:' ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
2898: FND_FILE.put_line(which => FND_FILE.LOG
2899: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics End Time:' ||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
2900: FND_FILE.put_line(which => FND_FILE.LOG
2901: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics Total Time:' ||l_total_time);
2902: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
2903: FND_FILE.put_line(which => FND_FILE.LOG
2904: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRX_HEADERS_GT :'||l_dummy_number);

Line 2903: FND_FILE.put_line(which => FND_FILE.LOG

2899: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics End Time:' ||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
2900: FND_FILE.put_line(which => FND_FILE.LOG
2901: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics Total Time:' ||l_total_time);
2902: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
2903: FND_FILE.put_line(which => FND_FILE.LOG
2904: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
2905: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
2906: FND_FILE.put_line(which => FND_FILE.LOG
2907: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);

Line 2906: FND_FILE.put_line(which => FND_FILE.LOG

2902: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
2903: FND_FILE.put_line(which => FND_FILE.LOG
2904: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
2905: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
2906: FND_FILE.put_line(which => FND_FILE.LOG
2907: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
2908: SELECT COUNT(*) INTO l_dummy_number FROM ZX_IMPORT_TAX_LINES_GT;
2909: FND_FILE.put_line(which => FND_FILE.Log
2910: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_IMPORT_TAX_LINES_GT :'||l_dummy_number);

Line 2909: FND_FILE.put_line(which => FND_FILE.Log

2905: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
2906: FND_FILE.put_line(which => FND_FILE.LOG
2907: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
2908: SELECT COUNT(*) INTO l_dummy_number FROM ZX_IMPORT_TAX_LINES_GT;
2909: FND_FILE.put_line(which => FND_FILE.Log
2910: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_IMPORT_TAX_LINES_GT :'||l_dummy_number);
2911: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_TAX_LINK_GT;
2912: FND_FILE.put_line(which => FND_FILE.LOG
2913: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRX_TAX_LINK_GT :'||l_dummy_number);

Line 2912: FND_FILE.put_line(which => FND_FILE.LOG

2908: SELECT COUNT(*) INTO l_dummy_number FROM ZX_IMPORT_TAX_LINES_GT;
2909: FND_FILE.put_line(which => FND_FILE.Log
2910: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_IMPORT_TAX_LINES_GT :'||l_dummy_number);
2911: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_TAX_LINK_GT;
2912: FND_FILE.put_line(which => FND_FILE.LOG
2913: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRX_TAX_LINK_GT :'||l_dummy_number);
2914: END IF;
2915:
2916: WHEN OTHERS THEN

Line 2953: FND_FILE.put_line(which => FND_FILE.LOG

2949: END IF;
2950:
2951: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
2952: IF fnd_global.conc_request_id <> -1 AND l_dummy_number > 1 THEN
2953: FND_FILE.put_line(which => FND_FILE.LOG
2954: ,buff => 'ZX_API_PUB.import_document_with_tax.Exception OTHERS');
2955: FND_FILE.put_line(which => FND_FILE.LOG
2956: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics Start Time:' ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
2957: FND_FILE.put_line(which => FND_FILE.LOG

Line 2955: FND_FILE.put_line(which => FND_FILE.LOG

2951: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
2952: IF fnd_global.conc_request_id <> -1 AND l_dummy_number > 1 THEN
2953: FND_FILE.put_line(which => FND_FILE.LOG
2954: ,buff => 'ZX_API_PUB.import_document_with_tax.Exception OTHERS');
2955: FND_FILE.put_line(which => FND_FILE.LOG
2956: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics Start Time:' ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
2957: FND_FILE.put_line(which => FND_FILE.LOG
2958: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics End Time:' ||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
2959: FND_FILE.put_line(which => FND_FILE.LOG

Line 2957: FND_FILE.put_line(which => FND_FILE.LOG

2953: FND_FILE.put_line(which => FND_FILE.LOG
2954: ,buff => 'ZX_API_PUB.import_document_with_tax.Exception OTHERS');
2955: FND_FILE.put_line(which => FND_FILE.LOG
2956: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics Start Time:' ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
2957: FND_FILE.put_line(which => FND_FILE.LOG
2958: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics End Time:' ||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
2959: FND_FILE.put_line(which => FND_FILE.LOG
2960: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics Total Time:' ||l_total_time);
2961: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

Line 2959: FND_FILE.put_line(which => FND_FILE.LOG

2955: FND_FILE.put_line(which => FND_FILE.LOG
2956: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics Start Time:' ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
2957: FND_FILE.put_line(which => FND_FILE.LOG
2958: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics End Time:' ||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
2959: FND_FILE.put_line(which => FND_FILE.LOG
2960: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics Total Time:' ||l_total_time);
2961: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
2962: FND_FILE.put_line(which => FND_FILE.LOG
2963: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRX_HEADERS_GT :'||l_dummy_number);

Line 2962: FND_FILE.put_line(which => FND_FILE.LOG

2958: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics End Time:' ||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
2959: FND_FILE.put_line(which => FND_FILE.LOG
2960: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics Total Time:' ||l_total_time);
2961: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
2962: FND_FILE.put_line(which => FND_FILE.LOG
2963: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
2964: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
2965: FND_FILE.put_line(which => FND_FILE.LOG
2966: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);

Line 2965: FND_FILE.put_line(which => FND_FILE.LOG

2961: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
2962: FND_FILE.put_line(which => FND_FILE.LOG
2963: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
2964: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
2965: FND_FILE.put_line(which => FND_FILE.LOG
2966: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
2967: SELECT COUNT(*) INTO l_dummy_number FROM ZX_IMPORT_TAX_LINES_GT;
2968: FND_FILE.put_line(which => FND_FILE.Log
2969: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_IMPORT_TAX_LINES_GT :'||l_dummy_number);

Line 2968: FND_FILE.put_line(which => FND_FILE.Log

2964: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
2965: FND_FILE.put_line(which => FND_FILE.LOG
2966: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
2967: SELECT COUNT(*) INTO l_dummy_number FROM ZX_IMPORT_TAX_LINES_GT;
2968: FND_FILE.put_line(which => FND_FILE.Log
2969: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_IMPORT_TAX_LINES_GT :'||l_dummy_number);
2970: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_TAX_LINK_GT;
2971: FND_FILE.put_line(which => FND_FILE.LOG
2972: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRX_TAX_LINK_GT :'||l_dummy_number);

Line 2971: FND_FILE.put_line(which => FND_FILE.LOG

2967: SELECT COUNT(*) INTO l_dummy_number FROM ZX_IMPORT_TAX_LINES_GT;
2968: FND_FILE.put_line(which => FND_FILE.Log
2969: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_IMPORT_TAX_LINES_GT :'||l_dummy_number);
2970: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_TAX_LINK_GT;
2971: FND_FILE.put_line(which => FND_FILE.LOG
2972: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRX_TAX_LINK_GT :'||l_dummy_number);
2973: END IF;
2974:
2975: END import_document_with_tax;

Line 5889: FND_FILE.put_line(which => FND_FILE.LOG

5885: END IF;
5886:
5887: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
5888: IF fnd_global.conc_request_id <> -1 AND l_dummy_number > 1 THEN
5889: FND_FILE.put_line(which => FND_FILE.LOG
5890: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics Start Time:'
5891: ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
5892: FND_FILE.put_line(which => FND_FILE.LOG
5893: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics End Time:'

Line 5892: FND_FILE.put_line(which => FND_FILE.LOG

5888: IF fnd_global.conc_request_id <> -1 AND l_dummy_number > 1 THEN
5889: FND_FILE.put_line(which => FND_FILE.LOG
5890: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics Start Time:'
5891: ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
5892: FND_FILE.put_line(which => FND_FILE.LOG
5893: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics End Time:'
5894: ||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
5895: FND_FILE.put_line(which => FND_FILE.LOG
5896: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics Total Time:'

Line 5895: FND_FILE.put_line(which => FND_FILE.LOG

5891: ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
5892: FND_FILE.put_line(which => FND_FILE.LOG
5893: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics End Time:'
5894: ||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
5895: FND_FILE.put_line(which => FND_FILE.LOG
5896: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics Total Time:'
5897: ||l_total_time);
5898: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
5899: FND_FILE.put_line(which => FND_FILE.LOG

Line 5899: FND_FILE.put_line(which => FND_FILE.LOG

5895: FND_FILE.put_line(which => FND_FILE.LOG
5896: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics Total Time:'
5897: ||l_total_time);
5898: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
5899: FND_FILE.put_line(which => FND_FILE.LOG
5900: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics: Number of Records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
5901: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
5902: FND_FILE.put_line(which => FND_FILE.LOG
5903: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics: Number of Records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);

Line 5902: FND_FILE.put_line(which => FND_FILE.LOG

5898: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
5899: FND_FILE.put_line(which => FND_FILE.LOG
5900: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics: Number of Records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
5901: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
5902: FND_FILE.put_line(which => FND_FILE.LOG
5903: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics: Number of Records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
5904: END IF;
5905:
5906: EXCEPTION

Line 5934: FND_FILE.put_line(which => FND_FILE.LOG

5930: END IF;
5931:
5932: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
5933: IF fnd_global.conc_request_id <> -1 AND l_dummy_number > 1 THEN
5934: FND_FILE.put_line(which => FND_FILE.LOG
5935: ,buff => 'ZX_API_PUB.Determine_recovery.Exception FND_API.G_EXC_ERROR');
5936:
5937: FND_FILE.put_line(which => FND_FILE.LOG
5938: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics Start Time:'

Line 5937: FND_FILE.put_line(which => FND_FILE.LOG

5933: IF fnd_global.conc_request_id <> -1 AND l_dummy_number > 1 THEN
5934: FND_FILE.put_line(which => FND_FILE.LOG
5935: ,buff => 'ZX_API_PUB.Determine_recovery.Exception FND_API.G_EXC_ERROR');
5936:
5937: FND_FILE.put_line(which => FND_FILE.LOG
5938: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics Start Time:'
5939: ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
5940: FND_FILE.put_line(which => FND_FILE.LOG
5941: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics End Time:'

Line 5940: FND_FILE.put_line(which => FND_FILE.LOG

5936:
5937: FND_FILE.put_line(which => FND_FILE.LOG
5938: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics Start Time:'
5939: ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
5940: FND_FILE.put_line(which => FND_FILE.LOG
5941: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics End Time:'
5942: ||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
5943: FND_FILE.put_line(which => FND_FILE.LOG
5944: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics Total Time:'

Line 5943: FND_FILE.put_line(which => FND_FILE.LOG

5939: ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
5940: FND_FILE.put_line(which => FND_FILE.LOG
5941: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics End Time:'
5942: ||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
5943: FND_FILE.put_line(which => FND_FILE.LOG
5944: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics Total Time:'
5945: ||l_total_time);
5946: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
5947: FND_FILE.put_line(which => FND_FILE.LOG

Line 5947: FND_FILE.put_line(which => FND_FILE.LOG

5943: FND_FILE.put_line(which => FND_FILE.LOG
5944: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics Total Time:'
5945: ||l_total_time);
5946: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
5947: FND_FILE.put_line(which => FND_FILE.LOG
5948: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics: Number of Records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
5949: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
5950: FND_FILE.put_line(which => FND_FILE.LOG
5951: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics: Number of Records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);

Line 5950: FND_FILE.put_line(which => FND_FILE.LOG

5946: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
5947: FND_FILE.put_line(which => FND_FILE.LOG
5948: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics: Number of Records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
5949: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
5950: FND_FILE.put_line(which => FND_FILE.LOG
5951: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics: Number of Records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
5952: END IF;
5953:
5954:

Line 5993: FND_FILE.put_line(which => FND_FILE.LOG

5989: END IF;
5990:
5991: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
5992: IF fnd_global.conc_request_id <> -1 AND l_dummy_number > 1 THEN
5993: FND_FILE.put_line(which => FND_FILE.LOG
5994: ,buff => 'ZX_API_PUB.Determine_recovery.Exception FND_API.G_EXC_ERROR');
5995: FND_FILE.put_line(which => FND_FILE.LOG
5996: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics Start Time:'
5997: ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));

Line 5995: FND_FILE.put_line(which => FND_FILE.LOG

5991: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
5992: IF fnd_global.conc_request_id <> -1 AND l_dummy_number > 1 THEN
5993: FND_FILE.put_line(which => FND_FILE.LOG
5994: ,buff => 'ZX_API_PUB.Determine_recovery.Exception FND_API.G_EXC_ERROR');
5995: FND_FILE.put_line(which => FND_FILE.LOG
5996: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics Start Time:'
5997: ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
5998: FND_FILE.put_line(which => FND_FILE.LOG
5999: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics End Time:'

Line 5998: FND_FILE.put_line(which => FND_FILE.LOG

5994: ,buff => 'ZX_API_PUB.Determine_recovery.Exception FND_API.G_EXC_ERROR');
5995: FND_FILE.put_line(which => FND_FILE.LOG
5996: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics Start Time:'
5997: ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
5998: FND_FILE.put_line(which => FND_FILE.LOG
5999: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics End Time:'
6000: ||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
6001: FND_FILE.put_line(which => FND_FILE.LOG
6002: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics Total Time:'

Line 6001: FND_FILE.put_line(which => FND_FILE.LOG

5997: ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
5998: FND_FILE.put_line(which => FND_FILE.LOG
5999: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics End Time:'
6000: ||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
6001: FND_FILE.put_line(which => FND_FILE.LOG
6002: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics Total Time:'
6003: ||l_total_time);
6004: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
6005: FND_FILE.put_line(which => FND_FILE.LOG

Line 6005: FND_FILE.put_line(which => FND_FILE.LOG

6001: FND_FILE.put_line(which => FND_FILE.LOG
6002: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics Total Time:'
6003: ||l_total_time);
6004: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
6005: FND_FILE.put_line(which => FND_FILE.LOG
6006: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics: Number of Records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
6007: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
6008: FND_FILE.put_line(which => FND_FILE.LOG
6009: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics: Number of Records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);

Line 6008: FND_FILE.put_line(which => FND_FILE.LOG

6004: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
6005: FND_FILE.put_line(which => FND_FILE.LOG
6006: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics: Number of Records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
6007: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
6008: FND_FILE.put_line(which => FND_FILE.LOG
6009: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics: Number of Records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
6010: END IF;
6011:
6012:

Line 6046: FND_FILE.put_line(which => FND_FILE.LOG

6042: END IF;
6043:
6044: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
6045: IF fnd_global.conc_request_id <> -1 AND l_dummy_number > 1 THEN
6046: FND_FILE.put_line(which => FND_FILE.LOG
6047: ,buff => 'ZX_API_PUB.Determine_recovery.Exception OTHERS');
6048: FND_FILE.put_line(which => FND_FILE.LOG
6049: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics Start Time:'
6050: ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));

Line 6048: FND_FILE.put_line(which => FND_FILE.LOG

6044: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
6045: IF fnd_global.conc_request_id <> -1 AND l_dummy_number > 1 THEN
6046: FND_FILE.put_line(which => FND_FILE.LOG
6047: ,buff => 'ZX_API_PUB.Determine_recovery.Exception OTHERS');
6048: FND_FILE.put_line(which => FND_FILE.LOG
6049: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics Start Time:'
6050: ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
6051: FND_FILE.put_line(which => FND_FILE.LOG
6052: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics End Time:'

Line 6051: FND_FILE.put_line(which => FND_FILE.LOG

6047: ,buff => 'ZX_API_PUB.Determine_recovery.Exception OTHERS');
6048: FND_FILE.put_line(which => FND_FILE.LOG
6049: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics Start Time:'
6050: ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
6051: FND_FILE.put_line(which => FND_FILE.LOG
6052: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics End Time:'
6053: ||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
6054: FND_FILE.put_line(which => FND_FILE.LOG
6055: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics Total Time:'

Line 6054: FND_FILE.put_line(which => FND_FILE.LOG

6050: ||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
6051: FND_FILE.put_line(which => FND_FILE.LOG
6052: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics End Time:'
6053: ||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
6054: FND_FILE.put_line(which => FND_FILE.LOG
6055: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics Total Time:'
6056: ||l_total_time);
6057: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
6058: FND_FILE.put_line(which => FND_FILE.LOG

Line 6058: FND_FILE.put_line(which => FND_FILE.LOG

6054: FND_FILE.put_line(which => FND_FILE.LOG
6055: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics Total Time:'
6056: ||l_total_time);
6057: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
6058: FND_FILE.put_line(which => FND_FILE.LOG
6059: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics: Number of Records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
6060: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
6061: FND_FILE.put_line(which => FND_FILE.LOG
6062: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics: Number of Records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);

Line 6061: FND_FILE.put_line(which => FND_FILE.LOG

6057: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
6058: FND_FILE.put_line(which => FND_FILE.LOG
6059: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics: Number of Records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
6060: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
6061: FND_FILE.put_line(which => FND_FILE.LOG
6062: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics: Number of Records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
6063: END IF;
6064:
6065: END determine_recovery;