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_CONTACT_POINTS

Line 515: -- validate HZ_CONTACT_POINTS, contact_point_id

511:
512: END IF;
513:
514:
515: -- validate HZ_CONTACT_POINTS, contact_point_id
516: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_CONTACT_POINTS' THEN
517:
518: -- contact_point_id is foreign key of HZ_CONTACT_POINTS
519: -- Do not need to check during update because contact_point_id is

Line 516: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_CONTACT_POINTS' THEN

512: END IF;
513:
514:
515: -- validate HZ_CONTACT_POINTS, contact_point_id
516: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_CONTACT_POINTS' THEN
517:
518: -- contact_point_id is foreign key of HZ_CONTACT_POINTS
519: -- Do not need to check during update because contact_point_id is
520: -- non-updateable.

Line 518: -- contact_point_id is foreign key of HZ_CONTACT_POINTS

514:
515: -- validate HZ_CONTACT_POINTS, contact_point_id
516: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_CONTACT_POINTS' THEN
517:
518: -- contact_point_id is foreign key of HZ_CONTACT_POINTS
519: -- Do not need to check during update because contact_point_id is
520: -- non-updateable.
521: IF p_create_update_flag = 'C'
522: AND p_orig_sys_reference_rec.owner_table_id IS NOT NULL

Line 529: FROM HZ_CONTACT_POINTS

525: THEN
526: BEGIN
527: SELECT 'Y'
528: INTO l_dummy
529: FROM HZ_CONTACT_POINTS
530: WHERE contact_point_id = p_orig_sys_reference_rec.owner_table_id;
531: EXCEPTION
532: WHEN NO_DATA_FOUND THEN
533: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

Line 536: fnd_message.set_token('TABLE', 'HZ_CONTACT_POINTS');

532: WHEN NO_DATA_FOUND THEN
533: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
534: fnd_message.set_token('FK', 'owner_table_id');
535: fnd_message.set_token('COLUMN', 'contact_point_id');
536: fnd_message.set_token('TABLE', 'HZ_CONTACT_POINTS');
537: fnd_msg_pub.add;
538: x_return_status := fnd_api.g_ret_sts_error;
539: END;
540: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 542: p_message=>'owner_table_id is foreign key of HZ_CONTACT_POINTS. ' ||

538: x_return_status := fnd_api.g_ret_sts_error;
539: END;
540: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
541: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
542: p_message=>'owner_table_id is foreign key of HZ_CONTACT_POINTS. ' ||
543: 'x_return_status = ' || x_return_status,
544: p_msg_level=>fnd_log.level_statement);
545: END IF;
546: