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_PARTY_CONTACT_V2PUB dependencies on HZ_ORG_CONTACT_ROLES

Line 827: FROM HZ_ORG_CONTACT_ROLES

823: THEN
824: BEGIN
825: SELECT 'Y'
826: INTO l_dummy
827: FROM HZ_ORG_CONTACT_ROLES
828: WHERE ORG_CONTACT_ROLE_ID = l_org_contact_role_id;
829:
830: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
831: FND_MESSAGE.SET_TOKEN('COLUMN', 'org_contact_role_id');

Line 872: FROM HZ_ORG_CONTACT_ROLES

868: ROWID
869: INTO l_org_contact_role_id,
870: l_object_version_number,
871: l_rowid
872: FROM HZ_ORG_CONTACT_ROLES
873: WHERE ORG_CONTACT_ID = p_org_contact_role_rec.org_contact_id
874: AND ROLE_TYPE = p_org_contact_role_rec.role_type
875: AND STATUS = 'I';
876:

Line 880: HZ_ORG_CONTACT_ROLES_PKG.Update_Row (

876:
877: l_object_version_number := nvl(l_object_version_number, 1) + 1;
878:
879: -- call to table-handler to update the staus to active
880: HZ_ORG_CONTACT_ROLES_PKG.Update_Row (
881: X_Rowid => l_rowid,
882: X_ORG_CONTACT_ROLE_ID => l_org_contact_role_id,
883: X_ORG_CONTACT_ID => p_org_contact_role_rec.org_contact_id,
884: X_ROLE_TYPE => p_org_contact_role_rec.role_type,

Line 902: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACT_ROLES_PKG.Insert_Row (+)',

898: WHEN NO_DATA_FOUND THEN
899:
900: -- Debug info.
901: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
902: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACT_ROLES_PKG.Insert_Row (+)',
903: p_prefix=>l_debug_prefix,
904: p_msg_level=>fnd_log.level_procedure);
905: END IF;
906:

Line 908: HZ_ORG_CONTACT_ROLES_PKG.Insert_Row (

904: p_msg_level=>fnd_log.level_procedure);
905: END IF;
906:
907: -- call table-handler.
908: HZ_ORG_CONTACT_ROLES_PKG.Insert_Row (
909: X_ORG_CONTACT_ROLE_ID => p_org_contact_role_rec.org_contact_role_id,
910: X_ORG_CONTACT_ID => p_org_contact_role_rec.org_contact_id,
911: X_ROLE_TYPE => p_org_contact_role_rec.role_type,
912: X_ROLE_LEVEL => p_org_contact_role_rec.role_level,

Line 926: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACT_ROLES_PKG.Insert_Row (-) ' ||

922: x_org_contact_role_id := p_org_contact_role_rec.org_contact_role_id;
923:
924: -- Debug info.
925: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
926: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACT_ROLES_PKG.Insert_Row (-) ' ||
927: 'x_org_contact_role_id = ' || x_org_contact_role_id,
928: p_prefix=>l_debug_prefix,
929: p_msg_level=>fnd_log.level_procedure);
930: END IF;

Line 941: l_orig_sys_reference_rec.owner_table_name := 'HZ_ORG_CONTACT_ROLES';

937: and p_org_contact_role_rec.orig_system <>fnd_api.g_miss_char
938: then
939: l_orig_sys_reference_rec.orig_system := p_org_contact_role_rec.orig_system;
940: l_orig_sys_reference_rec.orig_system_reference := p_org_contact_role_rec.orig_system_reference;
941: l_orig_sys_reference_rec.owner_table_name := 'HZ_ORG_CONTACT_ROLES';
942: l_orig_sys_reference_rec.owner_table_id := p_org_contact_role_rec.org_contact_role_id;
943: -- Bug# 6338010: Start changes made by Neeraj
944: -- Created by module should not be null
945: l_orig_sys_reference_rec.created_by_module := p_org_contact_role_rec.created_by_module;

Line 1022: FROM HZ_ORG_CONTACT_ROLES

1018: SELECT OBJECT_VERSION_NUMBER,
1019: ROWID
1020: INTO l_object_version_number,
1021: l_rowid
1022: FROM HZ_ORG_CONTACT_ROLES
1023: WHERE ORG_CONTACT_ROLE_ID = p_org_contact_role_rec.org_contact_role_id
1024: FOR UPDATE OF ORG_CONTACT_ROLE_ID NOWAIT;
1025:
1026: IF NOT (

Line 1033: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_org_contact_roles');

1029: l_object_version_number IS NOT NULL AND
1030: p_object_version_number = l_object_version_number ) )
1031: THEN
1032: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1033: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_org_contact_roles');
1034: FND_MSG_PUB.ADD;
1035: RAISE FND_API.G_EXC_ERROR;
1036: END IF;
1037:

Line 1071: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACT_ROLES_PKG.Update_Row (+) ',

1067: end if;
1068:
1069: -- Debug info.
1070: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1071: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACT_ROLES_PKG.Update_Row (+) ',
1072: p_prefix=>l_debug_prefix,
1073: p_msg_level=>fnd_log.level_procedure);
1074: END IF;
1075:

Line 1077: HZ_ORG_CONTACT_ROLES_PKG.Update_Row (

1073: p_msg_level=>fnd_log.level_procedure);
1074: END IF;
1075:
1076: -- call to table-handler
1077: HZ_ORG_CONTACT_ROLES_PKG.Update_Row (
1078: X_Rowid => l_rowid,
1079: X_ORG_CONTACT_ROLE_ID => p_org_contact_role_rec.org_contact_role_id,
1080: X_ORG_CONTACT_ID => p_org_contact_role_rec.org_contact_id,
1081: X_ROLE_TYPE => p_org_contact_role_rec.role_type,

Line 1094: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACT_ROLES_PKG.Update_Row (-) ',

1090: );
1091:
1092: -- Debug info.
1093: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1094: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACT_ROLES_PKG.Update_Row (-) ',
1095: p_prefix=>l_debug_prefix,
1096: p_msg_level=>fnd_log.level_procedure);
1097: END IF;
1098:

Line 1662: HZ_POPULATE_BOT_PKG.pop_hz_org_contact_roles(

1658: l_org_contact_role_rec );
1659: END IF;
1660:
1661: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1662: HZ_POPULATE_BOT_PKG.pop_hz_org_contact_roles(
1663: p_operation => 'I',
1664: p_org_contact_role_id => x_org_contact_role_id );
1665: END IF;
1666: END IF;

Line 1844: p_owner_table_name => 'HZ_ORG_CONTACT_ROLES',

1840: and (p_org_contact_role_rec.org_contact_role_id = FND_API.G_MISS_NUM or p_org_contact_role_rec.org_contact_role_id is null) THEN
1841: hz_orig_system_ref_pub.get_owner_table_id
1842: (p_orig_system => p_org_contact_role_rec.orig_system,
1843: p_orig_system_reference => p_org_contact_role_rec.orig_system_reference,
1844: p_owner_table_name => 'HZ_ORG_CONTACT_ROLES',
1845: x_owner_table_id => l_org_contact_role_rec.org_contact_role_id,
1846: x_return_status => x_return_status);
1847: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1848: RAISE FND_API.G_EXC_ERROR;

Line 1882: HZ_POPULATE_BOT_PKG.pop_hz_org_contact_roles(

1878: l_org_contact_role_rec , l_old_org_contact_role_rec );
1879: END IF;
1880:
1881: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1882: HZ_POPULATE_BOT_PKG.pop_hz_org_contact_roles(
1883: p_operation => 'U',
1884: p_org_contact_role_id => l_org_contact_role_rec.org_contact_role_id );
1885: END IF;
1886: END IF;

Line 2216: HZ_ORG_CONTACT_ROLES_PKG.Select_Row (

2212: END IF;
2213:
2214: x_org_contact_role_rec.org_contact_role_id := p_org_contact_role_id;
2215:
2216: HZ_ORG_CONTACT_ROLES_PKG.Select_Row (
2217: X_ORG_CONTACT_ROLE_ID => x_org_contact_role_rec.org_contact_role_id,
2218: X_ORG_CONTACT_ID => x_org_contact_role_rec.org_contact_id,
2219: X_ROLE_TYPE => x_org_contact_role_rec.role_type,
2220: X_ROLE_LEVEL => x_org_contact_role_rec.role_level,