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_VERTEX_TAX_SERVICE_PKG dependencies on HZ_LOCATIONS

Line 2642: ' pg_ship_to_loc_id_tab before hz_locations : '||pg_ship_to_loc_id_tab(i));

2638: END IF;
2639:
2640: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2641: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2642: ' pg_ship_to_loc_id_tab before hz_locations : '||pg_ship_to_loc_id_tab(i));
2643: END IF;
2644: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2645: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2646: ' pg_bill_to_loc_id_tab before hz_locations : '||pg_bill_to_loc_id_tab(i));

Line 2646: ' pg_bill_to_loc_id_tab before hz_locations : '||pg_bill_to_loc_id_tab(i));

2642: ' pg_ship_to_loc_id_tab before hz_locations : '||pg_ship_to_loc_id_tab(i));
2643: END IF;
2644: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2645: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
2646: ' pg_bill_to_loc_id_tab before hz_locations : '||pg_bill_to_loc_id_tab(i));
2647: END IF;
2648:
2649: if (inv_in_rec.fJurisSTGeoCd is null) then
2650: BEGIN

Line 2656: FROM hz_locations loc

2652: INTO inv_in_rec.fJurisSTStAbbrv
2653: ,inv_in_rec.fJurisSTCoName
2654: ,inv_in_rec.fJurisSTCiName
2655: ,inv_in_rec.fJurisSTZipCd
2656: FROM hz_locations loc
2657: WHERE loc.location_id = NVL(pg_ship_to_loc_id_tab(I),pg_bill_to_loc_id_tab(I));
2658: EXCEPTION
2659: WHEN OTHERS THEN
2660: inv_in_rec.fJurisSTStAbbrv := NULL;