DBA Data[Home] [Help]

APPS.HZ_MOSR_VALIDATE_PKG dependencies on HZ_PARTY_SITES

Line 480: -- validate HZ_PARTY_SITES, party_site_id

476: END IF;
477:
478: END IF;
479:
480: -- validate HZ_PARTY_SITES, party_site_id
481: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_PARTY_SITES' THEN
482:
483: -- party_site_id is foreign key of HZ_PARTY_SITES
484: -- Do not need to check during update because party_site_id is

Line 481: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_PARTY_SITES' THEN

477:
478: END IF;
479:
480: -- validate HZ_PARTY_SITES, party_site_id
481: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_PARTY_SITES' THEN
482:
483: -- party_site_id is foreign key of HZ_PARTY_SITES
484: -- Do not need to check during update because party_site_id is
485: -- non-updateable.

Line 483: -- party_site_id is foreign key of HZ_PARTY_SITES

479:
480: -- validate HZ_PARTY_SITES, party_site_id
481: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_PARTY_SITES' THEN
482:
483: -- party_site_id is foreign key of HZ_PARTY_SITES
484: -- Do not need to check during update because party_site_id is
485: -- non-updateable.
486: IF p_create_update_flag = 'C'
487: AND p_orig_sys_reference_rec.owner_table_id IS NOT NULL

Line 494: FROM HZ_PARTY_SITES

490: THEN
491: BEGIN
492: SELECT 'Y'
493: INTO l_dummy
494: FROM HZ_PARTY_SITES
495: WHERE party_site_id = p_orig_sys_reference_rec.owner_table_id;
496: EXCEPTION
497: WHEN NO_DATA_FOUND THEN
498: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

Line 501: fnd_message.set_token('TABLE', 'HZ_PARTY_SITES');

497: WHEN NO_DATA_FOUND THEN
498: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
499: fnd_message.set_token('FK', 'owner_table_id');
500: fnd_message.set_token('COLUMN', 'party_site_id');
501: fnd_message.set_token('TABLE', 'HZ_PARTY_SITES');
502: fnd_msg_pub.add;
503: x_return_status := fnd_api.g_ret_sts_error;
504: END;
505: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 507: p_message=>'owner_table_id is foreign key of HZ_PARTY_SITES. ' ||

503: x_return_status := fnd_api.g_ret_sts_error;
504: END;
505: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
506: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
507: p_message=>'owner_table_id is foreign key of HZ_PARTY_SITES. ' ||
508: 'x_return_status = ' || x_return_status,
509: p_msg_level=>fnd_log.level_statement);
510: END IF;
511: