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

Line 683: -- validate HZ_LOCATIONS , location_id

679: END IF;
680:
681: END IF;
682:
683: -- validate HZ_LOCATIONS , location_id
684: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_LOCATIONS' THEN
685:
686: -- location_id is foreign key of HZ_LOCATIONS
687: -- Do not need to check during update because location_id is

Line 684: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_LOCATIONS' THEN

680:
681: END IF;
682:
683: -- validate HZ_LOCATIONS , location_id
684: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_LOCATIONS' THEN
685:
686: -- location_id is foreign key of HZ_LOCATIONS
687: -- Do not need to check during update because location_id is
688: -- non-updateable.

Line 686: -- location_id is foreign key of HZ_LOCATIONS

682:
683: -- validate HZ_LOCATIONS , location_id
684: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_LOCATIONS' THEN
685:
686: -- location_id is foreign key of HZ_LOCATIONS
687: -- Do not need to check during update because location_id is
688: -- non-updateable.
689: IF p_create_update_flag = 'C'
690: AND p_orig_sys_reference_rec.owner_table_id IS NOT NULL

Line 697: FROM HZ_LOCATIONS

693: THEN
694: BEGIN
695: SELECT 'Y'
696: INTO l_dummy
697: FROM HZ_LOCATIONS
698: WHERE location_id = p_orig_sys_reference_rec.owner_table_id;
699: EXCEPTION
700: WHEN NO_DATA_FOUND THEN
701: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

Line 704: fnd_message.set_token('TABLE', 'HZ_LOCATIONS');

700: WHEN NO_DATA_FOUND THEN
701: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
702: fnd_message.set_token('FK', 'owner_table_id');
703: fnd_message.set_token('COLUMN', 'location_id');
704: fnd_message.set_token('TABLE', 'HZ_LOCATIONS');
705: fnd_msg_pub.add;
706: x_return_status := fnd_api.g_ret_sts_error;
707: END;
708: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 710: p_message=>'owner_table_id is foreign key of HZ_LOCATIONS. ' ||

706: x_return_status := fnd_api.g_ret_sts_error;
707: END;
708: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
709: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
710: p_message=>'owner_table_id is foreign key of HZ_LOCATIONS. ' ||
711: 'x_return_status = ' || x_return_status,
712: p_msg_level=>fnd_log.level_statement);
713: END IF;
714: