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_CUST_ACCOUNTS

Line 549: -- validate HZ_CUST_ACCOUNTS, cust_account_id

545: END IF;
546:
547: END IF;
548:
549: -- validate HZ_CUST_ACCOUNTS, cust_account_id
550: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_CUST_ACCOUNTS' THEN
551: -- cust_account_id is foreign key of HZ_CUST_ACCOUNTS
552: -- Do not need to check during update because cust_account_id is
553: -- non-updateable.

Line 550: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_CUST_ACCOUNTS' THEN

546:
547: END IF;
548:
549: -- validate HZ_CUST_ACCOUNTS, cust_account_id
550: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_CUST_ACCOUNTS' THEN
551: -- cust_account_id is foreign key of HZ_CUST_ACCOUNTS
552: -- Do not need to check during update because cust_account_id is
553: -- non-updateable.
554: IF p_create_update_flag = 'C'

Line 551: -- cust_account_id is foreign key of HZ_CUST_ACCOUNTS

547: END IF;
548:
549: -- validate HZ_CUST_ACCOUNTS, cust_account_id
550: ELSIF p_orig_sys_reference_rec.owner_table_name = 'HZ_CUST_ACCOUNTS' THEN
551: -- cust_account_id is foreign key of HZ_CUST_ACCOUNTS
552: -- Do not need to check during update because cust_account_id is
553: -- non-updateable.
554: IF p_create_update_flag = 'C'
555: AND p_orig_sys_reference_rec.owner_table_id IS NOT NULL

Line 562: FROM HZ_CUST_ACCOUNTS

558: THEN
559: BEGIN
560: SELECT 'Y'
561: INTO l_dummy
562: FROM HZ_CUST_ACCOUNTS
563: WHERE cust_account_id = p_orig_sys_reference_rec.owner_table_id;
564: EXCEPTION
565: WHEN NO_DATA_FOUND THEN
566: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');

Line 569: fnd_message.set_token('TABLE', 'HZ_CUST_ACCOUNTS');

565: WHEN NO_DATA_FOUND THEN
566: fnd_message.set_name('AR', 'HZ_API_INVALID_FK');
567: fnd_message.set_token('FK', 'owner_table_id');
568: fnd_message.set_token('COLUMN', 'cust_account_id');
569: fnd_message.set_token('TABLE', 'HZ_CUST_ACCOUNTS');
570: fnd_msg_pub.add;
571: x_return_status := fnd_api.g_ret_sts_error;
572: END;
573: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN

Line 575: p_message=>'owner_table_id is foreign key of HZ_CUST_ACCOUNTS. ' ||

571: x_return_status := fnd_api.g_ret_sts_error;
572: END;
573: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
574: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,
575: p_message=>'owner_table_id is foreign key of HZ_CUST_ACCOUNTS. ' ||
576: 'x_return_status = ' || x_return_status,
577: p_msg_level=>fnd_log.level_statement);
578: END IF;
579: