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
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.
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
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');
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
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: