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

Line 864: ,p_destination_table_name => 'HZ_LOCATIONS'

860: ,p_message_name => 'MESSAGE NAME'
861: -- ,p_message_text => 'Country Code validation fails for : '||site_data.site_identification_number
862: ,p_message_text => l_msg
863: ,p_source_table_name => 'RRS_SITES_INTERFACE'
864: ,p_destination_table_name => 'HZ_LOCATIONS'
865: ,p_process_status => '3'
866: ,p_transaction_type => site_data.transaction_type
867: ,p_batch_id => site_data.batch_id
868: ,p_processing_errors => local_processing_errors

Line 886: ,p_destination_table_name => 'HZ_LOCATIONS'

882: ,p_message_name => 'MESSAGE NAME'
883: -- ,p_message_text => 'Invalid Country Code. country Code is required for : '||site_data.site_identification_number
884: ,p_message_text => l_msg
885: ,p_source_table_name => 'RRS_SITES_INTERFACE'
886: ,p_destination_table_name => 'HZ_LOCATIONS'
887: ,p_process_status => '3'
888: ,p_transaction_type => site_data.transaction_type
889: ,p_batch_id => site_data.batch_id
890: ,p_processing_errors => local_processing_errors

Line 920: ,p_destination_table_name => 'HZ_LOCATIONS'

916: ,p_message_name => 'MESSAGE NAME'
917: -- ,p_message_text => 'Location Status and Location ID combination is not valid for : '||site_data.site_identification_number
918: ,p_message_text => l_msg
919: ,p_source_table_name => 'RRS_SITES_INTERFACE'
920: ,p_destination_table_name => 'HZ_LOCATIONS'
921: ,p_process_status => '3'
922: ,p_transaction_type => site_data.transaction_type
923: ,p_batch_id => site_data.batch_id
924: ,p_processing_errors => local_processing_errors

Line 955: ,p_destination_table_name => 'HZ_LOCATIONS'

951: ,p_message_name => 'MESSAGE NAME'
952: -- ,p_message_text => 'Location Status and Address combination is not valid for : '||site_data.site_identification_number
953: ,p_message_text => l_msg
954: ,p_source_table_name => 'RRS_SITES_INTERFACE'
955: ,p_destination_table_name => 'HZ_LOCATIONS'
956: ,p_process_status => '3'
957: ,p_transaction_type => site_data.transaction_type
958: ,p_batch_id => site_data.batch_id
959: ,p_processing_errors => local_processing_errors

Line 994: ,p_destination_table_name => 'HZ_LOCATIONS'

990: ,p_message_name => 'MESSAGE NAME'
991: -- ,p_message_text => 'Location status , Address1 and Country validations fails for : '||site_data.site_identification_number
992: ,p_message_text => l_msg
993: ,p_source_table_name => 'RRS_SITES_INTERFACE'
994: ,p_destination_table_name => 'HZ_LOCATIONS'
995: ,p_process_status => '3'
996: ,p_transaction_type => site_data.transaction_type
997: ,p_batch_id => site_data.batch_id
998: ,p_processing_errors => local_processing_errors

Line 1017: ,p_destination_table_name => 'HZ_LOCATIONS'

1013: ,p_message_name => 'MESSAGE NAME'
1014: -- ,p_message_text => 'Location Status and Location ID combination is not valid for : '||site_data.site_identification_number
1015: ,p_message_text => l_msg
1016: ,p_source_table_name => 'RRS_SITES_INTERFACE'
1017: ,p_destination_table_name => 'HZ_LOCATIONS'
1018: ,p_process_status => '3'
1019: ,p_transaction_type => site_data.transaction_type
1020: ,p_batch_id => site_data.batch_id
1021: ,p_processing_errors => local_processing_errors

Line 1039: ,p_destination_table_name => 'HZ_LOCATIONS'

1035: ,p_message_name => 'MESSAGE NAME'
1036: -- ,p_message_text => 'Location Status and Address combination is not valid for : '||site_data.site_identification_number
1037: ,p_message_text => l_msg
1038: ,p_source_table_name => 'RRS_SITES_INTERFACE'
1039: ,p_destination_table_name => 'HZ_LOCATIONS'
1040: ,p_process_status => '3'
1041: ,p_transaction_type => site_data.transaction_type
1042: ,p_batch_id => site_data.batch_id
1043: ,p_processing_errors => local_processing_errors

Line 1086: ,p_destination_table_name => 'HZ_LOCATIONS'

1082: ,p_message_name => 'MESSAGE NAME'
1083: -- ,p_message_text => 'Both langitude and latitude should be either Null or Not Null for : '||site_data.site_identification_number
1084: ,p_message_text => l_msg
1085: ,p_source_table_name => 'RRS_SITES_INTERFACE'
1086: ,p_destination_table_name => 'HZ_LOCATIONS'
1087: ,p_process_status => '3'
1088: ,p_transaction_type => site_data.transaction_type
1089: ,p_batch_id => site_data.batch_id
1090: ,p_processing_errors => local_processing_errors

Line 1109: ,p_destination_table_name => 'HZ_LOCATIONS'

1105: ,p_message_name => 'MESSAGE NAME'
1106: -- ,p_message_text => 'Longitude should be between -180 and 180 for : '||site_data.site_identification_number
1107: ,p_message_text => l_msg
1108: ,p_source_table_name => 'RRS_SITES_INTERFACE'
1109: ,p_destination_table_name => 'HZ_LOCATIONS'
1110: ,p_process_status => '3'
1111: ,p_transaction_type => site_data.transaction_type
1112: ,p_batch_id => site_data.batch_id
1113: ,p_processing_errors => local_processing_errors

Line 1131: ,p_destination_table_name => 'HZ_LOCATIONS'

1127: ,p_message_name => 'MESSAGE NAME'
1128: -- ,p_message_text => 'Latitude should be between -90 and 90 for : '||site_data.site_identification_number
1129: ,p_message_text => l_msg
1130: ,p_source_table_name => 'RRS_SITES_INTERFACE'
1131: ,p_destination_table_name => 'HZ_LOCATIONS'
1132: ,p_process_status => '3'
1133: ,p_transaction_type => site_data.transaction_type
1134: ,p_batch_id => site_data.batch_id
1135: ,p_processing_errors => local_processing_errors

Line 1167: ,p_destination_table_name => 'HZ_LOCATIONS'

1163: ,p_message_name => 'MESSAGE NAME'
1164: -- ,p_message_text => 'Geometry Source Code validation fails for : '||site_data.site_identification_number
1165: ,p_message_text => l_msg
1166: ,p_source_table_name => 'RRS_SITES_INTERFACE'
1167: ,p_destination_table_name => 'HZ_LOCATIONS'
1168: ,p_process_status => '3'
1169: ,p_transaction_type => site_data.transaction_type
1170: ,p_batch_id => site_data.batch_id
1171: ,p_processing_errors => local_processing_errors

Line 1197: from hz_locations

1193: l_upd_geo_data := 'N';
1194:
1195: select geometry_source
1196: into l_db_geo_source
1197: from hz_locations
1198: where location_id = site_data.location_id;
1199:
1200: If l_db_geo_source is NULL then
1201: IF (FND_PROFILE.VALUE('RRS_GEOCODE_SRC_PREFERENCE') = 'RRS_USER_ENTERED') then

Line 1206: UPDATE HZ_LOCATIONS

1202: l_geo_source := 'RRS_USER_ENTERED';
1203: else
1204: l_geo_source := 'RRS_GOOGLE';
1205: end if;
1206: UPDATE HZ_LOCATIONS
1207: SET GEOMETRY_SOURCE = l_geo_source
1208: WHERE LOCATION_ID = site_data.location_id;
1209: end if;
1210:

Line 1230: ,p_destination_table_name => 'HZ_LOCATIONS'

1226: ,p_message_name => 'MESSAGE NAME'
1227: -- ,p_message_text => 'Longitude-Latitude should be Null for Geometry Source as System Generated for : '||site_data.site_identification_number
1228: ,p_message_text => l_msg
1229: ,p_source_table_name => 'RRS_SITES_INTERFACE'
1230: ,p_destination_table_name => 'HZ_LOCATIONS'
1231: ,p_process_status => '3'
1232: ,p_transaction_type => site_data.transaction_type
1233: ,p_batch_id => site_data.batch_id
1234: ,p_processing_errors => local_processing_errors

Line 1455: ,p_destination_table_name => 'HZ_LOCATIONS'

1451: ,p_column_name => 'LOCATION_ID'
1452: ,p_message_name => 'MESSAGE NAME'
1453: ,p_message_text => 'Error Creating the location for : '||site_data.site_identification_number||' '||x_msg_data
1454: ,p_source_table_name => 'RRS_SITES_INTERFACE'
1455: ,p_destination_table_name => 'HZ_LOCATIONS'
1456: ,p_process_status => '3'
1457: ,p_transaction_type => site_data.transaction_type
1458: ,p_batch_id => site_data.batch_id
1459: ,p_processing_errors => local_processing_errors

Line 1561: -- call for updating HZ_Locations for Geometry coordinates.

1557:
1558: end if;
1559:
1560:
1561: -- call for updating HZ_Locations for Geometry coordinates.
1562:
1563: if l_upd_geo_data = 'Y' and l_row_status = 'S' then
1564: RRS_SITE_UTILS.Update_geometry_for_locations ( p_loc_id => nvl(site_data.location_id , x_location_id)
1565: ,p_lat => site_data.latitude

Line 1585: ,p_destination_table_name => 'HZ_LOCATIONS'

1581: ,p_column_name => 'GEOMETRY_SOURCE'
1582: ,p_message_name => 'MESSAGE NAME'
1583: ,p_message_text => 'Error Updating the Geometry Information for : '||site_data.site_identification_number
1584: ,p_source_table_name => 'RRS_SITES_INTERFACE'
1585: ,p_destination_table_name => 'HZ_LOCATIONS'
1586: ,p_process_status => '3'
1587: ,p_transaction_type => site_data.transaction_type
1588: ,p_batch_id => site_data.batch_id
1589: ,p_processing_errors => local_processing_errors

Line 1897: from hz_locations

1893: begin
1894:
1895: select location_id
1896: into l_location_id
1897: from hz_locations
1898: where location_id = p_location_id;
1899: /*
1900: and country = p_country_code
1901: */

Line 1941: From HZ_locations

1937: ,province
1938: ,county
1939: */
1940: Into l_address1
1941: From HZ_locations
1942: where address1 = p_address1
1943: and country = p_country_code;
1944: exception
1945: When no_data_found then

Line 2532: HZ_LOCATIONS H

2528: ,h.COUNTRY country
2529: ,h.GEOMETRY_SOURCE geometry_source
2530: ,h.object_version_number
2531: FROM RRS_SITES_INTERFACE a, RRS_SITES_B B , RRS_SITES_TL C, RRS_SITE_USES D,
2532: HZ_LOCATIONS H
2533: WHERE TRANSACTION_TYPE = G_TX_TYPE_UPDATE
2534: and BATCH_ID = l_batch_id
2535: and Process_status = G_PS_IN_PROCESS
2536: and b.site_id = c.site_id

Line 2835: ,p_destination_table_name => 'HZ_LOCATIONS'

2831: ,p_column_name => 'ADDRESS1'
2832: ,p_message_name => 'MESSAGE NAME'
2833: ,p_message_text => 'Location Status and Address combination is not valid for : '||site_data.site_id_num_intf
2834: ,p_source_table_name => 'RRS_SITES_INTERFACE'
2835: ,p_destination_table_name => 'HZ_LOCATIONS'
2836: ,p_process_status => '3'
2837: ,p_transaction_type => site_data.transaction_type_intf
2838: ,p_batch_id => site_data.batch_id
2839: ,p_processing_errors => local_processing_errors

Line 2853: ,p_destination_table_name => 'HZ_LOCATIONS'

2849: ,p_column_name => 'LOCATION_STATUS'
2850: ,p_message_name => 'MESSAGE NAME'
2851: ,p_message_text => 'Location Status cannot be null or New for : '||site_data.site_id_num_intf
2852: ,p_source_table_name => 'RRS_SITES_INTERFACE'
2853: ,p_destination_table_name => 'HZ_LOCATIONS'
2854: ,p_process_status => '3'
2855: ,p_transaction_type => site_data.transaction_type_intf
2856: ,p_batch_id => site_data.batch_id
2857: ,p_processing_errors => local_processing_errors

Line 2876: ,p_destination_table_name => 'HZ_LOCATIONS'

2872: ,p_message_name => 'MESSAGE NAME'
2873: -- ,p_message_text => 'Both longitude and latitude should be either Null or Not Null for : '||site_data.site_id_num_intf
2874: ,p_message_text => l_msg||' for '||site_data.site_id_num_intf
2875: ,p_source_table_name => 'RRS_SITES_INTERFACE'
2876: ,p_destination_table_name => 'HZ_LOCATIONS'
2877: ,p_process_status => '3'
2878: ,p_transaction_type => site_data.transaction_type_intf
2879: ,p_batch_id => site_data.batch_id
2880: ,p_processing_errors => local_processing_errors

Line 2892: ,p_destination_table_name => 'HZ_LOCATIONS'

2888: ,p_column_name => 'LONGITUDE '
2889: ,p_message_name => 'MESSAGE NAME'
2890: ,p_message_text => 'Longitude should be between -180 and 180 for : '||site_data.site_id_num_intf
2891: ,p_source_table_name => 'RRS_SITES_INTERFACE'
2892: ,p_destination_table_name => 'HZ_LOCATIONS'
2893: ,p_process_status => '3'
2894: ,p_transaction_type => site_data.transaction_type_intf
2895: ,p_batch_id => site_data.batch_id
2896: ,p_processing_errors => local_processing_errors

Line 2908: ,p_destination_table_name => 'HZ_LOCATIONS'

2904: ,p_column_name => 'LATITUDE'
2905: ,p_message_name => 'MESSAGE NAME'
2906: ,p_message_text => 'Latitude should be between -90 and 90 for : '||site_data.site_id_num_intf
2907: ,p_source_table_name => 'RRS_SITES_INTERFACE'
2908: ,p_destination_table_name => 'HZ_LOCATIONS'
2909: ,p_process_status => '3'
2910: ,p_transaction_type => site_data.transaction_type_intf
2911: ,p_batch_id => site_data.batch_id
2912: ,p_processing_errors => local_processing_errors

Line 2938: ,p_destination_table_name => 'HZ_LOCATIONS'

2934: ,p_column_name => 'GEOMETRY_SOURCE'
2935: ,p_message_name => 'MESSAGE NAME'
2936: ,p_message_text => 'Geometry Source Code validation fails for : '||site_data.site_id_num_intf
2937: ,p_source_table_name => 'RRS_SITES_INTERFACE'
2938: ,p_destination_table_name => 'HZ_LOCATIONS'
2939: ,p_process_status => '3'
2940: ,p_transaction_type => site_data.transaction_type_intf
2941: ,p_batch_id => site_data.batch_id
2942: ,p_processing_errors => local_processing_errors

Line 2967: ,p_destination_table_name => 'HZ_LOCATIONS'

2963: ,p_column_name => 'GEOMETRY_SOURCE'
2964: ,p_message_name => 'MESSAGE NAME'
2965: ,p_message_text => 'Longitude-Latitude should be Null for Geometry Source as System Generated for : '||site_data.site_id_num_intf
2966: ,p_source_table_name => 'RRS_SITES_INTERFACE'
2967: ,p_destination_table_name => 'HZ_LOCATIONS'
2968: ,p_process_status => '3'
2969: ,p_transaction_type => site_data.transaction_type_intf
2970: ,p_batch_id => site_data.batch_id
2971: ,p_processing_errors => local_processing_errors

Line 3324: -- call for updating HZ_Locations for Geometry coordinates.

3320:
3321: end if;
3322:
3323: If l_row_status = 'S' then
3324: -- call for updating HZ_Locations for Geometry coordinates.
3325: RRS_SITE_UTILS.Update_geometry_for_locations ( p_loc_id => site_data.location_id
3326: ,p_lat => site_data.latitude_intf
3327: ,p_long => site_data.longitude_intf
3328: ,p_status => 'GOOD'

Line 3346: ,p_destination_table_name => 'HZ_LOCATIONS'

3342: ,p_column_name => 'GEOMETRY_SOURCE'
3343: ,p_message_name => 'MESSAGE NAME'
3344: ,p_message_text => 'Error Updating the Geometry Information for : '||site_data.site_id_num_intf
3345: ,p_source_table_name => 'RRS_SITES_INTERFACE'
3346: ,p_destination_table_name => 'HZ_LOCATIONS'
3347: ,p_process_status => '3'
3348: ,p_transaction_type => site_data.transaction_type_intf
3349: ,p_batch_id => site_data.batch_id
3350: ,p_processing_errors => local_processing_errors