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 ZX_TRANSACTION_LINES_GT

Line 735: | GTT involved : ZX_TRX_HEADERS_GT, ZX_TRANSACTION_LINES_GT |

731: /* ======================================================================*
732: | PROCEDURE calculate_tax : Calculates and records tax info |
733: | There exists a pl/sql version of same API for performance |
734: | This API also supports processing for multiple event classes |
735: | GTT involved : ZX_TRX_HEADERS_GT, ZX_TRANSACTION_LINES_GT |
736: * ======================================================================*/
737:
738: PROCEDURE Calculate_tax
739: ( p_api_version IN NUMBER,

Line 1379: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;

1375: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','End Time :'||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
1376: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Total Time :'|| l_total_time);
1377: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
1378: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
1379: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
1380: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
1381: END IF;
1382:
1383: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

Line 1380: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);

1376: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Total Time :'|| l_total_time);
1377: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
1378: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
1379: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
1380: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
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

Line 1396: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;

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);
1399: END IF;
1400:

Line 1398: ,buff => 'ZX_API_PUB.Calculate.Statistics: Number of Records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);

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
1402: WHEN FND_API.G_EXC_ERROR THEN

Line 1422: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;

1418: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','End Time :'||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
1419: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Total Time :'|| l_total_time);
1420: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
1421: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
1422: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
1423: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
1424: END IF;
1425:
1426: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

Line 1423: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);

1419: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Total Time :'|| l_total_time);
1420: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
1421: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
1422: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
1423: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
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

Line 1439: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;

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);
1442: END IF;
1443:

Line 1441: ,buff => 'ZX_API_PUB.Calculate.Statistics: Number of Records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);

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
1445: ROLLBACK TO Calculate_tax_PVT;

Line 1469: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;

1465: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','End Time :'||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
1466: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Total Time :'|| l_total_time);
1467: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
1468: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
1469: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
1470: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
1471: END IF;
1472:
1473: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

Line 1470: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);

1466: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Total Time :'|| l_total_time);
1467: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
1468: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
1469: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
1470: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
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

Line 1486: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;

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);
1489: END IF;
1490:

Line 1488: ,buff => 'ZX_API_PUB.Calculate.Statistics: Number of Records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);

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
1492: ROLLBACK TO Calculate_tax_PVT;

Line 1527: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;

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);
1530: END IF;
1531:

Line 1529: ,buff => 'ZX_API_PUB.Calculate.Statistics: Number of Records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);

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:
1533: END calculate_tax; --gtt version

Line 2381: | GTT involved : ZX_TRX_HEADERS_GT, ZX_TRANSACTION_LINES_GT , |

2377:
2378: /* ======================================================================*
2379: | PROCEDURE import_document_with_tax : Imports document with tax |
2380: | This API also supports processing for multiple event classes |
2381: | GTT involved : ZX_TRX_HEADERS_GT, ZX_TRANSACTION_LINES_GT , |
2382: | ZX_IMPORT_TAX_LINES_GT and ZX_TRX_TAX_LINK_GT |
2383: * ======================================================================*/
2384: PROCEDURE Import_document_with_tax
2385: ( p_api_version IN NUMBER,

Line 2768: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;

2764: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','End Time :'||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
2765: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Total Time :'|| l_total_time);
2766: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
2767: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
2768: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
2769: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
2770: SELECT COUNT(*) INTO l_dummy_number FROM ZX_IMPORT_TAX_LINES_GT;
2771: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_IMPORT_TAX_LINES_GT :'||l_dummy_number);
2772: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_TAX_LINK_GT;

Line 2769: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);

2765: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Total Time :'|| l_total_time);
2766: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
2767: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
2768: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
2769: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
2770: SELECT COUNT(*) INTO l_dummy_number FROM ZX_IMPORT_TAX_LINES_GT;
2771: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_IMPORT_TAX_LINES_GT :'||l_dummy_number);
2772: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_TAX_LINK_GT;
2773: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRX_TAX_LINK_GT :'||l_dummy_number);

Line 2787: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;

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);
2790: SELECT COUNT(*) INTO l_dummy_number FROM ZX_IMPORT_TAX_LINES_GT;
2791: FND_FILE.put_line(which => FND_FILE.Log

Line 2789: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);

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);
2793: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_TAX_LINK_GT;

Line 2820: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;

2816: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','End Time :'||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
2817: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Total Time :'|| l_total_time);
2818: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
2819: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
2820: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
2821: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
2822: SELECT COUNT(*) INTO l_dummy_number FROM ZX_IMPORT_TAX_LINES_GT;
2823: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_IMPORT_TAX_LINES_GT :'||l_dummy_number);
2824: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_TAX_LINK_GT;

Line 2821: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);

2817: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Total Time :'|| l_total_time);
2818: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
2819: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
2820: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
2821: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
2822: SELECT COUNT(*) INTO l_dummy_number FROM ZX_IMPORT_TAX_LINES_GT;
2823: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_IMPORT_TAX_LINES_GT :'||l_dummy_number);
2824: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_TAX_LINK_GT;
2825: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRX_TAX_LINK_GT :'||l_dummy_number);

Line 2841: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;

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);
2844: SELECT COUNT(*) INTO l_dummy_number FROM ZX_IMPORT_TAX_LINES_GT;
2845: FND_FILE.put_line(which => FND_FILE.Log

Line 2843: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);

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);
2847: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_TAX_LINK_GT;

Line 2884: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;

2880: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','End Time :'||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
2881: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Total Time :'|| l_total_time);
2882: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
2883: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
2884: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
2885: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
2886: SELECT COUNT(*) INTO l_dummy_number FROM ZX_IMPORT_TAX_LINES_GT;
2887: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_IMPORT_TAX_LINES_GT :'||l_dummy_number);
2888: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_TAX_LINK_GT;

Line 2885: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);

2881: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Total Time :'|| l_total_time);
2882: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
2883: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
2884: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
2885: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
2886: SELECT COUNT(*) INTO l_dummy_number FROM ZX_IMPORT_TAX_LINES_GT;
2887: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_IMPORT_TAX_LINES_GT :'||l_dummy_number);
2888: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_TAX_LINK_GT;
2889: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRX_TAX_LINK_GT :'||l_dummy_number);

Line 2905: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;

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);
2908: SELECT COUNT(*) INTO l_dummy_number FROM ZX_IMPORT_TAX_LINES_GT;
2909: FND_FILE.put_line(which => FND_FILE.Log

Line 2907: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);

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);
2911: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_TAX_LINK_GT;

Line 2943: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;

2939: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','End Time :'||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
2940: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Total Time :'|| l_total_time);
2941: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
2942: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
2943: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
2944: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
2945: SELECT COUNT(*) INTO l_dummy_number FROM ZX_IMPORT_TAX_LINES_GT;
2946: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_IMPORT_TAX_LINES_GT :'||l_dummy_number);
2947: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_TAX_LINK_GT;

Line 2944: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);

2940: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Total Time :'|| l_total_time);
2941: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
2942: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
2943: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
2944: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
2945: SELECT COUNT(*) INTO l_dummy_number FROM ZX_IMPORT_TAX_LINES_GT;
2946: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_IMPORT_TAX_LINES_GT :'||l_dummy_number);
2947: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_TAX_LINK_GT;
2948: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRX_TAX_LINK_GT :'||l_dummy_number);

Line 2964: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;

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);
2967: SELECT COUNT(*) INTO l_dummy_number FROM ZX_IMPORT_TAX_LINES_GT;
2968: FND_FILE.put_line(which => FND_FILE.Log

Line 2966: ,buff => 'ZX_API_PUB.import_document_with_tax.Statistics: Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);

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);
2970: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_TAX_LINK_GT;

Line 5883: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;

5879: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','End Time :'||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
5880: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Total Time :'|| l_total_time);
5881: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
5882: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
5883: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
5884: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
5885: END IF;
5886:
5887: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

Line 5884: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);

5880: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Total Time :'|| l_total_time);
5881: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
5882: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
5883: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
5884: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
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

Line 5901: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;

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);
5904: END IF;
5905:

Line 5903: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics: Number of Records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);

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
5907: WHEN FND_API.G_EXC_ERROR THEN

Line 5928: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;

5924: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','End Time :'||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
5925: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Total Time :'|| l_total_time);
5926: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
5927: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
5928: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
5929: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
5930: END IF;
5931:
5932: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

Line 5929: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);

5925: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Total Time :'|| l_total_time);
5926: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
5927: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
5928: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
5929: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
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

Line 5949: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;

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);
5952: END IF;
5953:

Line 5951: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics: Number of Records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);

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:
5955: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5987: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;

5983: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','End Time :'||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
5984: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Total Time :'|| l_total_time);
5985: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
5986: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
5987: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
5988: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
5989: END IF;
5990:
5991: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

Line 5988: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);

5984: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Total Time :'|| l_total_time);
5985: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
5986: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
5987: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
5988: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
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

Line 6007: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;

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);
6010: END IF;
6011:

Line 6009: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics: Number of Records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);

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:
6013: WHEN OTHERS THEN

Line 6040: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;

6036: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','End Time :'||to_char(l_end_time,'DD-MM-YYYY HH24:MI:SS'));
6037: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Total Time :'|| l_total_time);
6038: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
6039: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
6040: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
6041: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
6042: END IF;
6043:
6044: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

Line 6041: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);

6037: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Total Time :'|| l_total_time);
6038: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;
6039: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRX_HEADERS_GT :'||l_dummy_number);
6040: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
6041: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Number of records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);
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

Line 6060: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;

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);
6063: END IF;
6064:

Line 6062: ,buff => 'ZX_API_PUB.Determine_recovery.Statistics: Number of Records in ZX_TRANSACTION_LINES_GT :'||l_dummy_number);

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;
6066: