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_ORG_CONTACT_ROLES

Line 751: -- validate HZ_ORG_CONTACT_ROLES, org_contact_role_id

747: END IF;
748:
749: END IF;
750:
751: -- validate HZ_ORG_CONTACT_ROLES, org_contact_role_id
752: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_ORG_CONTACT_ROLES' THEN
753:
754: -- org_contact_role_id is foreign key of HZ_ORG_CONTACT_ROLES
755: -- Do not need to check during update because org_contact_role_id is

Line 752: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_ORG_CONTACT_ROLES' THEN

748:
749: END IF;
750:
751: -- validate HZ_ORG_CONTACT_ROLES, org_contact_role_id
752: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_ORG_CONTACT_ROLES' THEN
753:
754: -- org_contact_role_id is foreign key of HZ_ORG_CONTACT_ROLES
755: -- Do not need to check during update because org_contact_role_id is
756: -- non-updateable.

Line 754: -- org_contact_role_id is foreign key of HZ_ORG_CONTACT_ROLES

750:
751: -- validate HZ_ORG_CONTACT_ROLES, org_contact_role_id
752: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_ORG_CONTACT_ROLES' THEN
753:
754: -- org_contact_role_id is foreign key of HZ_ORG_CONTACT_ROLES
755: -- Do not need to check during update because org_contact_role_id is
756: -- non-updateable.
757: IF p_create_update_flag = 'C'
758: AND p_orig_sys_reference_rec.owner_table_id IS NOT NULL

Line 765: FROM HZ_ORG_CONTACT_ROLES

761: THEN
762: BEGIN
763: SELECT 'Y'
764: INTO l_dummy
765: FROM HZ_ORG_CONTACT_ROLES
766: WHERE org_contact_role_id = p_orig_sys_reference_rec.owner_table_id;
767: EXCEPTION
768: WHEN NO_DATA_FOUND THEN
769: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

Line 772: fnd_message.set_token('TABLE', 'HZ_ORG_CONTACT_ROLES');

768: WHEN NO_DATA_FOUND THEN
769: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
770: fnd_message.set_token('FK', 'owner_table_id');
771: fnd_message.set_token('COLUMN', 'org_contact_role_id');
772: fnd_message.set_token('TABLE', 'HZ_ORG_CONTACT_ROLES');
773: fnd_msg_pub.add;
774: x_return_status := fnd_api.g_ret_sts_error;
775: END;
776: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 778: p_message=>'owner_table_id is foreign key of HZ_ORG_CONTACT_ROLES. ' ||

774: x_return_status := fnd_api.g_ret_sts_error;
775: END;
776: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
777: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
778: p_message=>'owner_table_id is foreign key of HZ_ORG_CONTACT_ROLES. ' ||
779: 'x_return_status = ' || x_return_status,
780: p_msg_level=>fnd_log.level_statement);
781: END IF;
782: