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_LOCATION_SERVICES_PUB dependencies on HZ_UTILITY_V2PUB

Line 582: l_event_key := 'HZ_LOCSERVICE_OUTBOUND-'||hz_utility_v2pub.request_id||'-'||p_adapter_id||'-'||p_batch_sequence;

578: p_num_batch => p_num_batch,
579: p_batch_seq => p_batch_sequence,
580: p_parameter_list => l_parameter_list );
581:
582: l_event_key := 'HZ_LOCSERVICE_OUTBOUND-'||hz_utility_v2pub.request_id||'-'||p_adapter_id||'-'||p_batch_sequence;
583:
584: -- raise wf event, this will call procedure outdoc_rule
585: log('Raise Workflow Event, event key is: '||l_event_key);
586:

Line 954: last_update_date = hz_utility_v2pub.last_update_date,

950: state = l_location_rec.state,
951: province = l_location_rec.province,
952: postal_code = l_location_rec.postal_code,
953: address_key = l_key,
954: last_update_date = hz_utility_v2pub.last_update_date,
955: last_updated_by = hz_utility_v2pub.last_updated_by,
956: last_update_login = hz_utility_v2pub.last_update_login,
957: validation_status_code = l_location_profile_rec.validation_status_code,
958: date_validated = l_location_profile_rec.date_validated,

Line 955: last_updated_by = hz_utility_v2pub.last_updated_by,

951: province = l_location_rec.province,
952: postal_code = l_location_rec.postal_code,
953: address_key = l_key,
954: last_update_date = hz_utility_v2pub.last_update_date,
955: last_updated_by = hz_utility_v2pub.last_updated_by,
956: last_update_login = hz_utility_v2pub.last_update_login,
957: validation_status_code = l_location_profile_rec.validation_status_code,
958: date_validated = l_location_profile_rec.date_validated,
959: object_version_number = nvl(object_version_number,1)+1

Line 956: last_update_login = hz_utility_v2pub.last_update_login,

952: postal_code = l_location_rec.postal_code,
953: address_key = l_key,
954: last_update_date = hz_utility_v2pub.last_update_date,
955: last_updated_by = hz_utility_v2pub.last_updated_by,
956: last_update_login = hz_utility_v2pub.last_update_login,
957: validation_status_code = l_location_profile_rec.validation_status_code,
958: date_validated = l_location_profile_rec.date_validated,
959: object_version_number = nvl(object_version_number,1)+1
960: WHERE location_id = l_location_rec.location_id;

Line 1000: last_update_date = hz_utility_v2pub.last_update_date,

996: county = l_location_rec.county,
997: postal_code = l_location_rec.postal_code,
998: state = l_location_rec.state,
999: province = l_location_rec.province,
1000: last_update_date = hz_utility_v2pub.last_update_date,
1001: last_updated_by = hz_utility_v2pub.last_updated_by,
1002: last_update_login = hz_utility_v2pub.last_update_login,
1003: request_id = hz_utility_v2pub.request_id,
1004: program_id = hz_utility_v2pub.program_id,

Line 1001: last_updated_by = hz_utility_v2pub.last_updated_by,

997: postal_code = l_location_rec.postal_code,
998: state = l_location_rec.state,
999: province = l_location_rec.province,
1000: last_update_date = hz_utility_v2pub.last_update_date,
1001: last_updated_by = hz_utility_v2pub.last_updated_by,
1002: last_update_login = hz_utility_v2pub.last_update_login,
1003: request_id = hz_utility_v2pub.request_id,
1004: program_id = hz_utility_v2pub.program_id,
1005: program_application_id = hz_utility_v2pub.program_application_id,

Line 1002: last_update_login = hz_utility_v2pub.last_update_login,

998: state = l_location_rec.state,
999: province = l_location_rec.province,
1000: last_update_date = hz_utility_v2pub.last_update_date,
1001: last_updated_by = hz_utility_v2pub.last_updated_by,
1002: last_update_login = hz_utility_v2pub.last_update_login,
1003: request_id = hz_utility_v2pub.request_id,
1004: program_id = hz_utility_v2pub.program_id,
1005: program_application_id = hz_utility_v2pub.program_application_id,
1006: program_update_date = hz_utility_v2pub.program_update_date

Line 1003: request_id = hz_utility_v2pub.request_id,

999: province = l_location_rec.province,
1000: last_update_date = hz_utility_v2pub.last_update_date,
1001: last_updated_by = hz_utility_v2pub.last_updated_by,
1002: last_update_login = hz_utility_v2pub.last_update_login,
1003: request_id = hz_utility_v2pub.request_id,
1004: program_id = hz_utility_v2pub.program_id,
1005: program_application_id = hz_utility_v2pub.program_application_id,
1006: program_update_date = hz_utility_v2pub.program_update_date
1007: WHERE party_id = l_party_id;

Line 1004: program_id = hz_utility_v2pub.program_id,

1000: last_update_date = hz_utility_v2pub.last_update_date,
1001: last_updated_by = hz_utility_v2pub.last_updated_by,
1002: last_update_login = hz_utility_v2pub.last_update_login,
1003: request_id = hz_utility_v2pub.request_id,
1004: program_id = hz_utility_v2pub.program_id,
1005: program_application_id = hz_utility_v2pub.program_application_id,
1006: program_update_date = hz_utility_v2pub.program_update_date
1007: WHERE party_id = l_party_id;
1008: END IF;

Line 1005: program_application_id = hz_utility_v2pub.program_application_id,

1001: last_updated_by = hz_utility_v2pub.last_updated_by,
1002: last_update_login = hz_utility_v2pub.last_update_login,
1003: request_id = hz_utility_v2pub.request_id,
1004: program_id = hz_utility_v2pub.program_id,
1005: program_application_id = hz_utility_v2pub.program_application_id,
1006: program_update_date = hz_utility_v2pub.program_update_date
1007: WHERE party_id = l_party_id;
1008: END IF;
1009: END LOOP;

Line 1006: program_update_date = hz_utility_v2pub.program_update_date

1002: last_update_login = hz_utility_v2pub.last_update_login,
1003: request_id = hz_utility_v2pub.request_id,
1004: program_id = hz_utility_v2pub.program_id,
1005: program_application_id = hz_utility_v2pub.program_application_id,
1006: program_update_date = hz_utility_v2pub.program_update_date
1007: WHERE party_id = l_party_id;
1008: END IF;
1009: END LOOP;
1010: CLOSE ident_address;

Line 1410: p_request_id => hz_utility_v2pub.request_id,

1406: px_adapter_log_id => l_adapter_log_id,
1407: p_created_by_module => p_module,
1408: p_created_by_module_id => p_module_id,
1409: p_http_status_code => NULL,
1410: p_request_id => hz_utility_v2pub.request_id,
1411: p_object_version_number => 1,
1412: p_inout_doc => to_clob(p_addrval_doc) );
1413:
1414: log('Adapter Log ID: '||l_adapter_log_id);

Line 2074: p_module_id => hz_utility_v2pub.request_id,

2070: p_addrval_doc => l_event_nclob_data,
2071: p_adapter_id => l_adapter_id,
2072: p_country_code => NULL,
2073: p_module => 'HZ_LOCSERVICE',
2074: p_module_id => hz_utility_v2pub.request_id,
2075: x_return_status => l_return_status,
2076: x_msg_count => l_msg_count,
2077: x_msg_data => l_msg_data );
2078:

Line 2110: l_event_key := 'HZ_LOCSERVICE_INBOUND-'||hz_utility_v2pub.request_id||'-'||l_adapter_id||'-'||to_char(sysdate,'DD-MON-YYYY HH:MI:SS') ;

2106: p_value => l_batch_sequence,
2107: p_parameterlist => l_parameter_list);
2108:
2109: -- raise event to retrieve inbound xml doc, which is indoc_rule
2110: l_event_key := 'HZ_LOCSERVICE_INBOUND-'||hz_utility_v2pub.request_id||'-'||l_adapter_id||'-'||to_char(sysdate,'DD-MON-YYYY HH:MI:SS') ;
2111:
2112: wf_event.raise(
2113: p_event_name => 'oracle.apps.ar.hz.locservice.parsexml',
2114: p_event_key => l_event_key,