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_CUST_ACCT_SITES_ALL

Line 202: If p_orig_sys_entity_map_rec.owner_table_name in ('HZ_CUST_ACCT_SITES_ALL',

198: p_column_value => p_orig_sys_entity_map_rec.multiple_flag,
199: x_return_status => x_return_status );
200:
201: IF p_create_update_flag = 'C' THEN
202: If p_orig_sys_entity_map_rec.owner_table_name in ('HZ_CUST_ACCT_SITES_ALL',
203: 'HZ_CUST_ACCOUNT_ROLES', 'HZ_CUST_SITE_USES_ALL')
204: then
205: if p_orig_sys_entity_map_rec.multiple_flag = 'N'
206: then

Line 615: -- validate HZ_CUST_ACCT_SITES_ALL, cust_acct_site_id

611: END IF;
612:
613: END IF;
614:
615: -- validate HZ_CUST_ACCT_SITES_ALL, cust_acct_site_id
616: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_CUST_ACCT_SITES_ALL' THEN
617:
618: -- cust_acct_site_id is foreign key of HZ_CUST_ACCT_SITES_ALL
619: -- Do not need to check during update because cust_acct_site_id is

Line 616: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_CUST_ACCT_SITES_ALL' THEN

612:
613: END IF;
614:
615: -- validate HZ_CUST_ACCT_SITES_ALL, cust_acct_site_id
616: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_CUST_ACCT_SITES_ALL' THEN
617:
618: -- cust_acct_site_id is foreign key of HZ_CUST_ACCT_SITES_ALL
619: -- Do not need to check during update because cust_acct_site_id is
620: -- non-updateable.

Line 618: -- cust_acct_site_id is foreign key of HZ_CUST_ACCT_SITES_ALL

614:
615: -- validate HZ_CUST_ACCT_SITES_ALL, cust_acct_site_id
616: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_CUST_ACCT_SITES_ALL' THEN
617:
618: -- cust_acct_site_id is foreign key of HZ_CUST_ACCT_SITES_ALL
619: -- Do not need to check during update because cust_acct_site_id is
620: -- non-updateable.
621: IF p_create_update_flag = 'C'
622: AND p_orig_sys_reference_rec.owner_table_id IS NOT NULL

Line 629: FROM HZ_CUST_ACCT_SITES_ALL -- Bug 3730175

625: THEN
626: BEGIN
627: SELECT 'Y'
628: INTO l_dummy
629: FROM HZ_CUST_ACCT_SITES_ALL -- Bug 3730175
630: WHERE cust_acct_site_id = p_orig_sys_reference_rec.owner_table_id;
631: EXCEPTION
632: WHEN NO_DATA_FOUND THEN
633: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

Line 636: fnd_message.set_token('TABLE', 'HZ_CUST_ACCT_SITES_ALL');

632: WHEN NO_DATA_FOUND THEN
633: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
634: fnd_message.set_token('FK', 'owner_table_id');
635: fnd_message.set_token('COLUMN', 'cust_acct_site_id');
636: fnd_message.set_token('TABLE', 'HZ_CUST_ACCT_SITES_ALL');
637: fnd_msg_pub.add;
638: x_return_status := fnd_api.g_ret_sts_error;
639: END;
640: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 642: p_message=>'owner_table_id is foreign key of HZ_CUST_ACCT_SITES_ALL. ' ||

638: x_return_status := fnd_api.g_ret_sts_error;
639: END;
640: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
641: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
642: p_message=>'owner_table_id is foreign key of HZ_CUST_ACCT_SITES_ALL. ' ||
643: 'x_return_status = ' || x_return_status,
644: p_msg_level=>fnd_log.level_statement);
645: END IF;
646: