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.HZ_GNR_PKG dependencies on HZ_LOCATIONS

Line 203: 'HZ_LOCATIONS') THEN

199: FND_MSG_PUB.ADD;
200: RAISE FND_API.G_EXC_ERROR;
201:
202: ELSIF p_location_table_name NOT IN ( 'HR_LOCATIONS_ALL',
203: 'HZ_LOCATIONS') THEN
204:
205: FND_MESSAGE.SET_NAME('AR', 'HZ_GEO_LOC_TABLE_INVALID');
206: FND_MSG_PUB.ADD;
207: RAISE FND_API.G_EXC_ERROR;

Line 639: FROM hz_locations loc

635: ATTRIBUTE7,
636: ATTRIBUTE8,
637: ATTRIBUTE9,
638: ATTRIBUTE10
639: FROM hz_locations loc
640: WHERE (((p_from_location_id IS NOT NULL and p_to_location_id IS NOT NULL) and
641: (location_id BETWEEN p_from_location_id and p_to_location_id )) or
642: ((p_from_location_id IS NOT NULL and p_to_location_id IS NULL) and
643: ( location_id >= p_from_location_id)) or

Line 706: FROM hz_locations loc

702: ATTRIBUTE7,
703: ATTRIBUTE8,
704: ATTRIBUTE9,
705: ATTRIBUTE10
706: FROM hz_locations loc
707: WHERE (((p_from_location_id IS NOT NULL and p_to_location_id IS NOT NULL) and
708: (location_id BETWEEN p_from_location_id and p_to_location_id )) or
709: ((p_from_location_id IS NOT NULL and p_to_location_id IS NULL) and
710: ( location_id >= p_from_location_id)) or

Line 773: FROM hz_locations loc

769: ATTRIBUTE7,
770: ATTRIBUTE8,
771: ATTRIBUTE9,
772: ATTRIBUTE10
773: FROM hz_locations loc
774: WHERE (((p_from_location_id IS NOT NULL and p_to_location_id IS NOT NULL) and
775: (location_id BETWEEN p_from_location_id and p_to_location_id )) or
776: ((p_from_location_id IS NOT NULL and p_to_location_id IS NULL) and
777: ( location_id >= p_from_location_id)) or

Line 828: FROM hz_locations loc

824: loc.ATTRIBUTE7,
825: loc.ATTRIBUTE8,
826: loc.ATTRIBUTE9,
827: loc.ATTRIBUTE10
828: FROM hz_locations loc
829: WHERE
830: -- Only locations which had Loc_assignments record before
831: /*Bug 6750566 Changes Start
832: EXISTS (

Line 853: WHERE loc_tbl_name = 'HZ_LOCATIONS';

849:
850: CURSOR c_r12_upg_map_cnt IS
851: SELECT DISTINCT country_code
852: FROM hz_geo_struct_map
853: WHERE loc_tbl_name = 'HZ_LOCATIONS';
854:
855: TYPE mapped_country_tbl_type IS TABLE OF VARCHAR2(10) INDEX BY BINARY_INTEGER;
856: mapped_country_list mapped_country_tbl_type;
857:

Line 900: -- ignore whatever usage code is passed for HZ_LOCATIONS_ALL.

896: retcode := 0;
897:
898: -- Set l_usage_code. This depends on table name and run type.
899: -- 1. If table is HR_LOCATIONS_ALL, GNR for only TAX usage is generated. It will
900: -- ignore whatever usage code is passed for HZ_LOCATIONS_ALL.
901: -- 2. If table is HZ_LOCATIONS,
902: -- i. If run type is ALL, we delete GNR for all usages, so we will generate GNR for all usages.
903: -- ii.If run type is ERROR or NEW, we will generate GNR for specific usage passed.
904: -- If no usage is passed, we will generate for all usages

Line 901: -- 2. If table is HZ_LOCATIONS,

897:
898: -- Set l_usage_code. This depends on table name and run type.
899: -- 1. If table is HR_LOCATIONS_ALL, GNR for only TAX usage is generated. It will
900: -- ignore whatever usage code is passed for HZ_LOCATIONS_ALL.
901: -- 2. If table is HZ_LOCATIONS,
902: -- i. If run type is ALL, we delete GNR for all usages, so we will generate GNR for all usages.
903: -- ii.If run type is ERROR or NEW, we will generate GNR for specific usage passed.
904: -- If no usage is passed, we will generate for all usages
905: IF (p_location_table_name = 'HZ_LOCATIONS') THEN

Line 905: IF (p_location_table_name = 'HZ_LOCATIONS') THEN

901: -- 2. If table is HZ_LOCATIONS,
902: -- i. If run type is ALL, we delete GNR for all usages, so we will generate GNR for all usages.
903: -- ii.If run type is ERROR or NEW, we will generate GNR for specific usage passed.
904: -- If no usage is passed, we will generate for all usages
905: IF (p_location_table_name = 'HZ_LOCATIONS') THEN
906: IF (l_run_type IN ('ALL','R12UPGRADE')) THEN
907: l_usage_code := 'ALL';
908: ELSE
909: l_usage_code := NVL(p_usage_code,'ALL');

Line 1214: -- Table : HZ_LOCATIONS Run Type : ALL

1210: HZ_GNR_UTIL_PKG.out(l_err_loc_msg_prefix || l_num_err_locations);
1211:
1212: HZ_GNR_UTIL_PKG.log('Geo Name Referencing process completed successfully');
1213:
1214: -- Table : HZ_LOCATIONS Run Type : ALL
1215: ELSIF ((p_location_table_name = 'HZ_LOCATIONS') AND (l_run_type = 'ALL')) THEN
1216: HZ_GNR_UTIL_PKG.outandlog('Processing for Table : HZ_LOCATIONS and Run Type : ALL');
1217: HZ_GNR_UTIL_PKG.outandlog('Parameters: Country Code :'||NVL(l_country_code,'NULL'));
1218: HZ_GNR_UTIL_PKG.outandlog(' Usage Code :'||l_usage_code);

Line 1215: ELSIF ((p_location_table_name = 'HZ_LOCATIONS') AND (l_run_type = 'ALL')) THEN

1211:
1212: HZ_GNR_UTIL_PKG.log('Geo Name Referencing process completed successfully');
1213:
1214: -- Table : HZ_LOCATIONS Run Type : ALL
1215: ELSIF ((p_location_table_name = 'HZ_LOCATIONS') AND (l_run_type = 'ALL')) THEN
1216: HZ_GNR_UTIL_PKG.outandlog('Processing for Table : HZ_LOCATIONS and Run Type : ALL');
1217: HZ_GNR_UTIL_PKG.outandlog('Parameters: Country Code :'||NVL(l_country_code,'NULL'));
1218: HZ_GNR_UTIL_PKG.outandlog(' Usage Code :'||l_usage_code);
1219: HZ_GNR_UTIL_PKG.outandlog(' From Location Id :'||NVL(TO_CHAR(l_from_location_id),'NULL')

Line 1216: HZ_GNR_UTIL_PKG.outandlog('Processing for Table : HZ_LOCATIONS and Run Type : ALL');

1212: HZ_GNR_UTIL_PKG.log('Geo Name Referencing process completed successfully');
1213:
1214: -- Table : HZ_LOCATIONS Run Type : ALL
1215: ELSIF ((p_location_table_name = 'HZ_LOCATIONS') AND (l_run_type = 'ALL')) THEN
1216: HZ_GNR_UTIL_PKG.outandlog('Processing for Table : HZ_LOCATIONS and Run Type : ALL');
1217: HZ_GNR_UTIL_PKG.outandlog('Parameters: Country Code :'||NVL(l_country_code,'NULL'));
1218: HZ_GNR_UTIL_PKG.outandlog(' Usage Code :'||l_usage_code);
1219: HZ_GNR_UTIL_PKG.outandlog(' From Location Id :'||NVL(TO_CHAR(l_from_location_id),'NULL')
1220: ||': To Location Id:'||NVL(TO_CHAR(l_to_location_id),'NULL'));

Line 1350: -- Table : HZ_LOCATIONS Run Type : NEW

1346: HZ_GNR_UTIL_PKG.out(l_err_loc_msg_prefix || l_num_err_locations);
1347:
1348: HZ_GNR_UTIL_PKG.log('Geo Name Referencing process completed successfully');
1349:
1350: -- Table : HZ_LOCATIONS Run Type : NEW
1351: ELSIF ((p_location_table_name = 'HZ_LOCATIONS') AND (l_run_type = 'NEW')) THEN
1352: HZ_GNR_UTIL_PKG.outandlog('Processing for Table : HZ_LOCATIONS and Run Type : NEW');
1353: HZ_GNR_UTIL_PKG.outandlog('Parameters: Country Code :'||NVL(l_country_code,'NULL'));
1354: HZ_GNR_UTIL_PKG.outandlog(' Usage Code :'||l_usage_code);

Line 1351: ELSIF ((p_location_table_name = 'HZ_LOCATIONS') AND (l_run_type = 'NEW')) THEN

1347:
1348: HZ_GNR_UTIL_PKG.log('Geo Name Referencing process completed successfully');
1349:
1350: -- Table : HZ_LOCATIONS Run Type : NEW
1351: ELSIF ((p_location_table_name = 'HZ_LOCATIONS') AND (l_run_type = 'NEW')) THEN
1352: HZ_GNR_UTIL_PKG.outandlog('Processing for Table : HZ_LOCATIONS and Run Type : NEW');
1353: HZ_GNR_UTIL_PKG.outandlog('Parameters: Country Code :'||NVL(l_country_code,'NULL'));
1354: HZ_GNR_UTIL_PKG.outandlog(' Usage Code :'||l_usage_code);
1355: HZ_GNR_UTIL_PKG.outandlog(' From Location Id :'||NVL(TO_CHAR(l_from_location_id),'NULL')

Line 1352: HZ_GNR_UTIL_PKG.outandlog('Processing for Table : HZ_LOCATIONS and Run Type : NEW');

1348: HZ_GNR_UTIL_PKG.log('Geo Name Referencing process completed successfully');
1349:
1350: -- Table : HZ_LOCATIONS Run Type : NEW
1351: ELSIF ((p_location_table_name = 'HZ_LOCATIONS') AND (l_run_type = 'NEW')) THEN
1352: HZ_GNR_UTIL_PKG.outandlog('Processing for Table : HZ_LOCATIONS and Run Type : NEW');
1353: HZ_GNR_UTIL_PKG.outandlog('Parameters: Country Code :'||NVL(l_country_code,'NULL'));
1354: HZ_GNR_UTIL_PKG.outandlog(' Usage Code :'||l_usage_code);
1355: HZ_GNR_UTIL_PKG.outandlog(' From Location Id :'||NVL(TO_CHAR(l_from_location_id),'NULL')
1356: ||': To Location Id:'||NVL(TO_CHAR(l_to_location_id),'NULL'));

Line 1454: -- Table : HZ_LOCATIONS Run Type : ERROR

1450: HZ_GNR_UTIL_PKG.out(l_err_loc_msg_prefix || l_num_err_locations);
1451:
1452: HZ_GNR_UTIL_PKG.log('Geo Name Referencing process completed successfully');
1453:
1454: -- Table : HZ_LOCATIONS Run Type : ERROR
1455: ELSIF ((p_location_table_name = 'HZ_LOCATIONS') AND (l_run_type = 'ERROR')) THEN
1456: HZ_GNR_UTIL_PKG.outandlog('Processing for Table : HZ_LOCATIONS and Run Type : ERROR');
1457: HZ_GNR_UTIL_PKG.outandlog('Parameters: Country Code :'||NVL(l_country_code,'NULL'));
1458: HZ_GNR_UTIL_PKG.outandlog(' Usage Code :'||l_usage_code);

Line 1455: ELSIF ((p_location_table_name = 'HZ_LOCATIONS') AND (l_run_type = 'ERROR')) THEN

1451:
1452: HZ_GNR_UTIL_PKG.log('Geo Name Referencing process completed successfully');
1453:
1454: -- Table : HZ_LOCATIONS Run Type : ERROR
1455: ELSIF ((p_location_table_name = 'HZ_LOCATIONS') AND (l_run_type = 'ERROR')) THEN
1456: HZ_GNR_UTIL_PKG.outandlog('Processing for Table : HZ_LOCATIONS and Run Type : ERROR');
1457: HZ_GNR_UTIL_PKG.outandlog('Parameters: Country Code :'||NVL(l_country_code,'NULL'));
1458: HZ_GNR_UTIL_PKG.outandlog(' Usage Code :'||l_usage_code);
1459: HZ_GNR_UTIL_PKG.outandlog(' From Location Id :'||NVL(TO_CHAR(l_from_location_id),'NULL')

Line 1456: HZ_GNR_UTIL_PKG.outandlog('Processing for Table : HZ_LOCATIONS and Run Type : ERROR');

1452: HZ_GNR_UTIL_PKG.log('Geo Name Referencing process completed successfully');
1453:
1454: -- Table : HZ_LOCATIONS Run Type : ERROR
1455: ELSIF ((p_location_table_name = 'HZ_LOCATIONS') AND (l_run_type = 'ERROR')) THEN
1456: HZ_GNR_UTIL_PKG.outandlog('Processing for Table : HZ_LOCATIONS and Run Type : ERROR');
1457: HZ_GNR_UTIL_PKG.outandlog('Parameters: Country Code :'||NVL(l_country_code,'NULL'));
1458: HZ_GNR_UTIL_PKG.outandlog(' Usage Code :'||l_usage_code);
1459: HZ_GNR_UTIL_PKG.outandlog(' From Location Id :'||NVL(TO_CHAR(l_from_location_id),'NULL')
1460: ||': To Location Id:'||NVL(TO_CHAR(l_to_location_id),'NULL'));

Line 1558: -- Table : HZ_LOCATIONS Run Type : R12UPGRADE

1554: HZ_GNR_UTIL_PKG.out(l_err_loc_msg_prefix || l_num_err_locations);
1555:
1556: HZ_GNR_UTIL_PKG.log('Geo Name Referencing process completed successfully');
1557:
1558: -- Table : HZ_LOCATIONS Run Type : R12UPGRADE
1559: ELSIF ((p_location_table_name = 'HZ_LOCATIONS') AND (l_run_type = 'R12UPGRADE')) THEN
1560: HZ_GNR_UTIL_PKG.outandlog('Processing for Table : HZ_LOCATIONS and Run Type : R12UPGRADE');
1561: HZ_GNR_UTIL_PKG.outandlog('Parameters: Usage Code :'||l_usage_code);
1562: HZ_GNR_UTIL_PKG.outandlog(' Number of workers:'||TO_CHAR(l_num_workers));

Line 1559: ELSIF ((p_location_table_name = 'HZ_LOCATIONS') AND (l_run_type = 'R12UPGRADE')) THEN

1555:
1556: HZ_GNR_UTIL_PKG.log('Geo Name Referencing process completed successfully');
1557:
1558: -- Table : HZ_LOCATIONS Run Type : R12UPGRADE
1559: ELSIF ((p_location_table_name = 'HZ_LOCATIONS') AND (l_run_type = 'R12UPGRADE')) THEN
1560: HZ_GNR_UTIL_PKG.outandlog('Processing for Table : HZ_LOCATIONS and Run Type : R12UPGRADE');
1561: HZ_GNR_UTIL_PKG.outandlog('Parameters: Usage Code :'||l_usage_code);
1562: HZ_GNR_UTIL_PKG.outandlog(' Number of workers:'||TO_CHAR(l_num_workers));
1563: HZ_GNR_UTIL_PKG.outandlog('Records from HZ_LOC_ASSIGNMENTS with valid mapping are being migrated.');

Line 1560: HZ_GNR_UTIL_PKG.outandlog('Processing for Table : HZ_LOCATIONS and Run Type : R12UPGRADE');

1556: HZ_GNR_UTIL_PKG.log('Geo Name Referencing process completed successfully');
1557:
1558: -- Table : HZ_LOCATIONS Run Type : R12UPGRADE
1559: ELSIF ((p_location_table_name = 'HZ_LOCATIONS') AND (l_run_type = 'R12UPGRADE')) THEN
1560: HZ_GNR_UTIL_PKG.outandlog('Processing for Table : HZ_LOCATIONS and Run Type : R12UPGRADE');
1561: HZ_GNR_UTIL_PKG.outandlog('Parameters: Usage Code :'||l_usage_code);
1562: HZ_GNR_UTIL_PKG.outandlog(' Number of workers:'||TO_CHAR(l_num_workers));
1563: HZ_GNR_UTIL_PKG.outandlog('Records from HZ_LOC_ASSIGNMENTS with valid mapping are being migrated.');
1564: HZ_GNR_UTIL_PKG.outandlog(' ');

Line 2027: l_mapid := get_map_id(l_country_code,'HZ_LOCATIONS',p_address_style);

2023: p_module => l_module
2024: );
2025: END IF;
2026:
2027: l_mapid := get_map_id(l_country_code,'HZ_LOCATIONS',p_address_style);
2028:
2029: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2030: hz_utility_v2pub.debug
2031: (p_message => ' Map Id for the above country : '||l_mapid,