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.XNB_CMN_PVT dependencies on HZ_CONTACT_POINTS

Line 1776: FROM hz_contact_points

1772: BEGIN
1773:
1774: SELECT owner_table_name
1775: INTO l_table_name
1776: FROM hz_contact_points
1777: WHERE contact_point_id = l_param_value;
1778:
1779: EXCEPTION
1780:

Line 1784: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCT_UPDATE','Check the Owner Table Name in HZ_CONTACT_POINTS');

1780:
1781: WHEN NO_DATA_FOUND THEN
1782: WF_CORE.CONTEXT('XNB_CMN_PVT_TEMP', 'PUBLISH_ACCT_UPDATE', p_event.getEventName());
1783: WF_EVENT.setErrorInfo(p_event, 'ERROR');
1784: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCT_UPDATE','Check the Owner Table Name in HZ_CONTACT_POINTS');
1785: RAISE;
1786:
1787: WHEN OTHERS THEN
1788: XNB_DEBUG.log('XNB_CMN_PVT.PUBLISH_ACCT_UPDATE', SQLERRM);

Line 1800: FROM hz_contact_points a,

1796: BEGIN
1797:
1798: SELECT c.account_number
1799: BULK COLLECT INTO l_acc_num
1800: FROM hz_contact_points a,
1801: hz_parties b,
1802: hz_cust_accounts c
1803: WHERE a.contact_point_id = l_param_value
1804: AND a.owner_table_id = b.party_id