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_TRX_HEADERS_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 768: FROM ZX_TRX_HEADERS_GT

764: -- ENTITY_CODE,
765: -- EVENT_CLASS_CODE,
766: QUOTE_FLAG,
767: ICX_SESSION_ID
768: FROM ZX_TRX_HEADERS_GT
769: WHERE rownum = 1;
770:
771: CURSOR event_classes IS
772: SELECT distinct

Line 778: ZX_TRX_HEADERS_GT header

774: header.application_id,
775: header.entity_code,
776: evntmap.processing_precedence
777: FROM ZX_EVNT_CLS_MAPPINGS evntmap,
778: ZX_TRX_HEADERS_GT header
779: WHERE header.application_id = evntmap.application_id
780: AND header.entity_code = evntmap.entity_code
781: AND header.event_class_code = evntmap.event_class_code
782: ORDER BY evntmap.processing_precedence;

Line 793: FROM ZX_TRX_HEADERS_GT;

789: ICX_SESSION_ID,
790: EVENT_TYPE_CODE,
791: TAX_EVENT_TYPE_CODE,
792: DOC_EVENT_STATUS
793: FROM ZX_TRX_HEADERS_GT;
794:
795: l_application_id_tbl NUMBER_tbl_type;
796: l_entity_code_tbl VARCHAR2_30_tbl_type;
797: l_event_class_code_tbl VARCHAR2_30_tbl_type;

Line 923: from ZX_TRX_HEADERS_GT

919: into l_evnt_cls.event_class_code(1),
920: l_evnt_cls.application_id(1),
921: l_evnt_cls.entity_code(1),
922: l_evnt_cls.internal_organization_id(1)
923: from ZX_TRX_HEADERS_GT
924: where rownum=1;
925: END IF;
926:
927: -- added for bug fix 5417887

Line 1209: (SELECT /+ cardinality (ZX_TRX_HEADERS_GT 1) /

1205: FORALL i IN l_trx_id_tbl.FIRST .. l_trx_id_tbl.LAST
1206: */
1207: DELETE FROM zx_lines_det_factors
1208: WHERE (APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID) IN
1209: (SELECT /*+ cardinality (ZX_TRX_HEADERS_GT 1) */
1210: APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID
1211: FROM ZX_TRX_HEADERS_GT);
1212:
1213: /*

Line 1211: FROM ZX_TRX_HEADERS_GT);

1207: DELETE FROM zx_lines_det_factors
1208: WHERE (APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID) IN
1209: (SELECT /*+ cardinality (ZX_TRX_HEADERS_GT 1) */
1210: APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID
1211: FROM ZX_TRX_HEADERS_GT);
1212:
1213: /*
1214: exit when c_HEADERS%NOTFOUND;
1215: END LOOP;

Line 1268: IN (SELECT /+ unnest cardinality (ZX_TRX_HEADERS_GT 1) /

1264:
1265: */
1266: DELETE /*+ ORDERED USE_NL_WITH_INDEX (Z,ZX_LINES_DET_FACTORS_U1) */ FROM zx_lines_det_factors Z
1267: WHERE (Z.APPLICATION_ID, Z.ENTITY_CODE, Z.EVENT_CLASS_CODE, Z.TRX_ID)
1268: IN (SELECT /*+ unnest cardinality (ZX_TRX_HEADERS_GT 1) */
1269: APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID
1270: FROM ZX_TRX_HEADERS_GT)
1271: AND Z.line_level_action ='DELETE';
1272:

Line 1270: FROM ZX_TRX_HEADERS_GT)

1266: DELETE /*+ ORDERED USE_NL_WITH_INDEX (Z,ZX_LINES_DET_FACTORS_U1) */ FROM zx_lines_det_factors Z
1267: WHERE (Z.APPLICATION_ID, Z.ENTITY_CODE, Z.EVENT_CLASS_CODE, Z.TRX_ID)
1268: IN (SELECT /*+ unnest cardinality (ZX_TRX_HEADERS_GT 1) */
1269: APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID
1270: FROM ZX_TRX_HEADERS_GT)
1271: AND Z.line_level_action ='DELETE';
1272:
1273:
1274: /*

Line 1335: UPDATE ZX_TRX_HEADERS_GT headers

1331: /*---------------------------------------------------------+
1332: | Set the out parameter |
1333: +--------------------------------------------------------*/
1334: BEGIN
1335: UPDATE ZX_TRX_HEADERS_GT headers
1336: SET doc_level_recalc_flag = (SELECT distinct(lines.threshold_indicator_flag)
1337: FROM ZX_LINES_DET_FACTORS lines
1338: WHERE lines.application_id = headers.application_id
1339: AND lines.event_class_code = headers.event_class_code

Line 1377: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

1373: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1374: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Start Time :'||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
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;

Line 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);

1374: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Start Time :'||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
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:

Line 1383: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

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
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

Line 1393: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

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);
1396: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
1397: FND_FILE.put_line(which => FND_FILE.LOG

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

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

Line 1420: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

1416: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1417: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Start Time :'||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
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;

Line 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);

1417: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Start Time :'||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
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:

Line 1426: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

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
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

Line 1436: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

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);
1439: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
1440: FND_FILE.put_line(which => FND_FILE.LOG

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

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

Line 1467: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

1463: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
1464: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Start Time :'||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
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;

Line 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);

1464: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Start Time :'||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
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:

Line 1473: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

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
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

Line 1483: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

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);
1486: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
1487: FND_FILE.put_line(which => FND_FILE.LOG

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

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

Line 1514: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

1510: 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'));
1511: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Total Time :'|| l_total_time);
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

Line 1524: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

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);
1527: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
1528: FND_FILE.put_line(which => FND_FILE.LOG

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

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

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 2412: ZX_TRX_HEADERS_GT header

2408: header.entity_code,
2409: header.internal_organization_id,
2410: evntmap.processing_precedence
2411: FROM ZX_EVNT_CLS_MAPPINGS evntmap,
2412: ZX_TRX_HEADERS_GT header
2413: WHERE header.application_id = evntmap.application_id
2414: AND header.entity_code = evntmap.entity_code
2415: AND header.event_class_code = evntmap.event_class_code
2416: ORDER BY evntmap.processing_precedence;

Line 2526: from ZX_TRX_HEADERS_GT

2522: into l_evnt_cls.event_class_code(1),
2523: l_evnt_cls.application_id(1),
2524: l_evnt_cls.entity_code(1),
2525: l_evnt_cls.internal_organization_id(1)
2526: from ZX_TRX_HEADERS_GT
2527: where rownum=1;
2528: END IF;
2529:
2530:

Line 2766: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

2762: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
2763: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Start Time :'||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
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;

Line 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);

2763: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Start Time :'||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
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);

Line 2776: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

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);
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

Line 2784: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

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);
2787: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
2788: FND_FILE.put_line(which => FND_FILE.LOG

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

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

Line 2818: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

2814: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
2815: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Start Time :'||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
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;

Line 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);

2815: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Start Time :'||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
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);

Line 2828: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

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);
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

Line 2838: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

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);
2841: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
2842: FND_FILE.put_line(which => FND_FILE.LOG

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

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

Line 2882: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

2878: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
2879: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Start Time :'||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
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;

Line 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);

2879: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Start Time :'||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
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);

Line 2892: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

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);
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

Line 2902: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

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);
2905: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
2906: FND_FILE.put_line(which => FND_FILE.LOG

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

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

Line 2941: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

2937: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
2938: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Start Time :'||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
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;

Line 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);

2938: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Start Time :'||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
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);

Line 2951: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

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);
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

Line 2961: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

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);
2964: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRANSACTION_LINES_GT;
2965: FND_FILE.put_line(which => FND_FILE.LOG

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

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

Line 5048: | GTT involved : ZX_TRX_HEADERS_GT, ZX_ITM_DISTRIBUTIONS_GT |

5044: /* =======================================================================*
5045: | PROCEDURE determine_recovery : Calculate the distribution of tax amounts
5046: | into recoverable and/or non-recoverable tax amounts. |
5047: | This API also supports processing for multiple event classes |
5048: | GTT involved : ZX_TRX_HEADERS_GT, ZX_ITM_DISTRIBUTIONS_GT |
5049: * =======================================================================*/
5050:
5051: PROCEDURE Determine_recovery
5052: ( p_api_version IN NUMBER,

Line 5087: ZX_TRX_HEADERS_GT header

5083: header.entity_code,
5084: header.internal_organization_id,
5085: evntmap.processing_precedence
5086: FROM ZX_EVNT_CLS_MAPPINGS evntmap,
5087: ZX_TRX_HEADERS_GT header
5088: WHERE header.application_id = evntmap.application_id
5089: AND header.entity_code = evntmap.entity_code
5090: AND header.event_class_code = evntmap.event_class_code
5091: ORDER BY evntmap.processing_precedence;

Line 5105: FROM ZX_TRX_HEADERS_GT

5101: EVENT_CLASS_CODE,
5102: TRX_ID,
5103: QUOTE_FLAG,
5104: ICX_SESSION_ID
5105: FROM ZX_TRX_HEADERS_GT
5106: WHERE event_class_code = p_event_class_code
5107: AND application_id = p_application_id
5108: AND entity_code = p_entity_code
5109: AND (validation_check_flag is null OR

Line 5116: FROM ZX_TRX_HEADERS_GT;

5112: -- added for bug fix 5417887
5113: CURSOR c_headers is
5114: SELECT APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, ICX_SESSION_ID,
5115: EVENT_TYPE_CODE, TAX_EVENT_TYPE_CODE, DOC_EVENT_STATUS
5116: FROM ZX_TRX_HEADERS_GT;
5117:
5118: CURSOR check_trx_line_dist_qty
5119: IS
5120: SELECT APPLICATION_ID,

Line 5167: FROM zx_trx_headers_gt hdr,

5163: hdr.application_id application_id,
5164: hdr.entity_code entity_code,
5165: hdr.event_class_code event_class_code,
5166: hdr.trx_id trx_id
5167: FROM zx_trx_headers_gt hdr,
5168: zx_evnt_typ_mappings zetm,
5169: zx_evnt_cls_typs zect
5170: WHERE zetm.event_class_code = hdr.event_class_code
5171: AND zetm.application_id = hdr.application_id

Line 5315: FROM ZX_TRX_HEADERS_GT

5311: INTO l_evnt_cls.event_class_code(1),
5312: l_evnt_cls.application_id(1),
5313: l_evnt_cls.internal_organization_id(1),
5314: l_evnt_cls.entity_code(1)
5315: FROM ZX_TRX_HEADERS_GT
5316: WHERE rownum=1;
5317: END IF;
5318:
5319: /*-----------------------------------------+

Line 5418: FROM ZX_TRX_HEADERS_GT

5414: END IF;
5415:
5416: select ICX_SESSION_ID,QUOTE_FLAG
5417: INTO l_event_class_rec.ICX_SESSION_ID,l_event_class_rec.QUOTE_FLAG
5418: FROM ZX_TRX_HEADERS_GT
5419: where rownum = 1;
5420:
5421: IF l_event_class_rec.QUOTE_FLAG = 'Y' and
5422: l_event_class_rec.ICX_SESSION_ID is not null THEN

Line 5881: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

5877: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
5878: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Start Time :'||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
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;

Line 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);

5878: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Start Time :'||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
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:

Line 5887: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

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
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'));

Line 5898: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

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
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

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

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

Line 5926: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

5922: IF ( G_LEVEL_UNEXPECTED >= G_CURRENT_RUNTIME_LEVEL) THEN
5923: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Start Time :'||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
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;

Line 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);

5923: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Start Time :'||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
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:

Line 5932: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

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
5934: FND_FILE.put_line(which => FND_FILE.LOG
5935: ,buff => 'ZX_API_PUB.Determine_recovery.Exception FND_API.G_EXC_ERROR');
5936:

Line 5946: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

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
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

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

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

Line 5985: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

5981:
5982: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Start Time :'||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
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;

Line 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);

5982: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Start Time :'||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
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:

Line 5991: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

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
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

Line 6004: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

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
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

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

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

Line 6038: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

6034: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name,SQLERRM);
6035: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Start Time :'||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
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;

Line 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);

6035: FND_LOG.STRING(G_LEVEL_UNEXPECTED,G_MODULE_NAME||l_api_name||'.Statistics','Start Time :'||to_char(l_start_time,'DD-MM-YYYY HH24:MI:SS'));
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:

Line 6044: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

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
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

Line 6057: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

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
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

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

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

Line 7735: FROM ZX_TRX_HEADERS_GT zthg

7731: , zthg.trx_id
7732: , zetm.event_type_code -- Bug 5598384
7733: , zect.tax_event_type_code
7734: , zect.status_code
7735: FROM ZX_TRX_HEADERS_GT zthg
7736: , ZX_EVNT_TYP_MAPPINGS zetm
7737: , ZX_EVNT_CLS_TYPS zect
7738: WHERE zthg.event_class_code = zetm.event_class_code
7739: AND zthg.entity_code = zetm.entity_code

Line 9225: FROM ZX_TRX_HEADERS_GT headers

9221: SELECT internal_organization_id,
9222: application_id
9223: INTO l_internal_organization_id,
9224: l_app_id
9225: FROM ZX_TRX_HEADERS_GT headers
9226: WHERE rownum =1;
9227:
9228: EXCEPTION
9229: WHEN NO_DATA_FOUND THEN

Line 13309: -- Fetch from zx_trx_headers_gt and zx_trx_transaction_lines_gt into

13305: -- This overloaded procedure acts as a wrapper on TDS default_tax_attribs
13306: -- procedure to default the tax determining attributes. It follows the
13307: -- following logic defaulting the determining attributes.
13308: --
13309: -- Fetch from zx_trx_headers_gt and zx_trx_transaction_lines_gt into
13310: -- global structure zx_global_structures_pkg.trx_line_dist_tbl
13311: -- For records in trx_line_dist_tbl
13312: -- Loop
13313: -- If line_level_action is UPDATE

Line 13385: FROM ZX_TRX_HEADERS_GT;

13381: RNDG_BILL_TO_PARTY_SITE_ID,
13382: RNDG_BILL_FROM_PARTY_SITE_ID,
13383: QUOTE_FLAG,
13384: ESTABLISHMENT_ID
13385: FROM ZX_TRX_HEADERS_GT;
13386:
13387: BEGIN
13388: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
13389: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN','ZX_API_PUB: '||l_api_name||'()+');