APPS.HZ_MOSR_VALIDATE_PKG dependencies on HZ_CUST_SITE_USES_ALL

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 649: -- validate HZ_CUST_SITE_USES_ALL, site_use_id

645: END IF;
646:
647: END IF;
648:
649: -- validate HZ_CUST_SITE_USES_ALL, site_use_id
650: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_CUST_SITE_USES_ALL' THEN
651:
652: -- site_use_id is foreign key of HZ_CUST_SITE_USES_ALL
653: -- Do not need to check during update because site_use_id is

Line 650: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_CUST_SITE_USES_ALL' THEN

646:
647: END IF;
648:
649: -- validate HZ_CUST_SITE_USES_ALL, site_use_id
650: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_CUST_SITE_USES_ALL' THEN
651:
652: -- site_use_id is foreign key of HZ_CUST_SITE_USES_ALL
653: -- Do not need to check during update because site_use_id is
654: -- non-updateable.

Line 652: -- site_use_id is foreign key of HZ_CUST_SITE_USES_ALL

648:
649: -- validate HZ_CUST_SITE_USES_ALL, site_use_id
650: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_CUST_SITE_USES_ALL' THEN
651:
652: -- site_use_id is foreign key of HZ_CUST_SITE_USES_ALL
653: -- Do not need to check during update because site_use_id is
654: -- non-updateable.
655: IF p_create_update_flag = 'C'
656: AND p_orig_sys_reference_rec.owner_table_id IS NOT NULL

Line 663: FROM HZ_CUST_SITE_USES_ALL

659: THEN
660: BEGIN
661: SELECT 'Y'
662: INTO l_dummy
663: FROM HZ_CUST_SITE_USES_ALL
664: WHERE site_use_id = p_orig_sys_reference_rec.owner_table_id;
665: EXCEPTION
666: WHEN NO_DATA_FOUND THEN
667: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

Line 670: fnd_message.set_token('TABLE', 'HZ_CUST_SITE_USES_ALL');

666: WHEN NO_DATA_FOUND THEN
667: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
668: fnd_message.set_token('FK', 'owner_table_id');
669: fnd_message.set_token('COLUMN', 'site_use_id');
670: fnd_message.set_token('TABLE', 'HZ_CUST_SITE_USES_ALL');
671: fnd_msg_pub.add;
672: x_return_status := fnd_api.g_ret_sts_error;
673: END;
674: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 676: p_message=>'owner_table_id is foreign key of HZ_CUST_SITE_USES_ALL. ' ||

672: x_return_status := fnd_api.g_ret_sts_error;
673: END;
674: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
675: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
676: p_message=>'owner_table_id is foreign key of HZ_CUST_SITE_USES_ALL. ' ||
677: 'x_return_status = ' || x_return_status,
678: p_msg_level=>fnd_log.level_statement);
679: END IF;
680: