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_ACCOUNT_ROLES

Line 203: 'HZ_CUST_ACCOUNT_ROLES', 'HZ_CUST_SITE_USES_ALL')

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
207: fnd_message.set_name('AR', 'HZ_API_VAL_DEP_FIELDS');

Line 582: -- validate HZ_CUST_ACCOUNT_ROLES, cust_account_role_id

578: END IF;
579:
580: END IF;
581:
582: -- validate HZ_CUST_ACCOUNT_ROLES, cust_account_role_id
583: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_CUST_ACCOUNT_ROLES' THEN
584: -- cust_account_role_id is foreign key of HZ_CUST_ACCOUNT_ROLES
585: -- Do not need to check during update because cust_account_role_id is
586: -- non-updateable.

Line 583: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_CUST_ACCOUNT_ROLES' THEN

579:
580: END IF;
581:
582: -- validate HZ_CUST_ACCOUNT_ROLES, cust_account_role_id
583: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_CUST_ACCOUNT_ROLES' THEN
584: -- cust_account_role_id is foreign key of HZ_CUST_ACCOUNT_ROLES
585: -- Do not need to check during update because cust_account_role_id is
586: -- non-updateable.
587: IF p_create_update_flag = 'C'

Line 584: -- cust_account_role_id is foreign key of HZ_CUST_ACCOUNT_ROLES

580: END IF;
581:
582: -- validate HZ_CUST_ACCOUNT_ROLES, cust_account_role_id
583: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_CUST_ACCOUNT_ROLES' THEN
584: -- cust_account_role_id is foreign key of HZ_CUST_ACCOUNT_ROLES
585: -- Do not need to check during update because cust_account_role_id is
586: -- non-updateable.
587: IF p_create_update_flag = 'C'
588: AND p_orig_sys_reference_rec.owner_table_id IS NOT NULL

Line 595: FROM HZ_CUST_ACCOUNT_ROLES

591: THEN
592: BEGIN
593: SELECT 'Y'
594: INTO l_dummy
595: FROM HZ_CUST_ACCOUNT_ROLES
596: WHERE cust_account_role_id = p_orig_sys_reference_rec.owner_table_id;
597: EXCEPTION
598: WHEN NO_DATA_FOUND THEN
599: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

Line 602: fnd_message.set_token('TABLE', 'HZ_CUST_ACCOUNT_ROLES');

598: WHEN NO_DATA_FOUND THEN
599: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
600: fnd_message.set_token('FK', 'owner_table_id');
601: fnd_message.set_token('COLUMN', 'cust_account_role_id');
602: fnd_message.set_token('TABLE', 'HZ_CUST_ACCOUNT_ROLES');
603: fnd_msg_pub.add;
604: x_return_status := fnd_api.g_ret_sts_error;
605: END;
606: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 608: p_message=>'owner_table_id is foreign key of HZ_CUST_ACCOUNT_ROLES. ' ||

604: x_return_status := fnd_api.g_ret_sts_error;
605: END;
606: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
607: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
608: p_message=>'owner_table_id is foreign key of HZ_CUST_ACCOUNT_ROLES. ' ||
609: 'x_return_status = ' || x_return_status,
610: p_msg_level=>fnd_log.level_statement);
611: END IF;
612: