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_TAX_LINK_GT

Line 2382: | ZX_IMPORT_TAX_LINES_GT and ZX_TRX_TAX_LINK_GT |

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,
2386: p_init_msg_list IN VARCHAR2,

Line 2772: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_TAX_LINK_GT;

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);
2774: END IF;
2775:
2776: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

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

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

Line 2793: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_TAX_LINK_GT;

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

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

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

Line 2824: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_TAX_LINK_GT;

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);
2826: END IF;
2827:
2828: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

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

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

Line 2847: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_TAX_LINK_GT;

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

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

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

Line 2888: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_TAX_LINK_GT;

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);
2890: END IF;
2891:
2892: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

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

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

Line 2911: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_TAX_LINK_GT;

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

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

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

Line 2947: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_TAX_LINK_GT;

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);
2949: END IF;
2950:
2951: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_HEADERS_GT;

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

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

Line 2970: SELECT COUNT(*) INTO l_dummy_number FROM ZX_TRX_TAX_LINK_GT;

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

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

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