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 822: FROM HZ_ORG_CONTACT_ROLES

818: THEN
819: BEGIN
820: SELECT 'Y'
821: INTO l_dummy
822: FROM HZ_ORG_CONTACT_ROLES
823: WHERE ORG_CONTACT_ROLE_ID = l_org_contact_role_id;
824:
825: FND_MESSAGE.SET_NAME('AR', 'HZ_API_DUPLICATE_COLUMN');
826: FND_MESSAGE.SET_TOKEN('COLUMN', 'org_contact_role_id');

Line 867: FROM HZ_ORG_CONTACT_ROLES

863: ROWID
864: INTO l_org_contact_role_id,
865: l_object_version_number,
866: l_rowid
867: FROM HZ_ORG_CONTACT_ROLES
868: WHERE ORG_CONTACT_ID = p_org_contact_role_rec.org_contact_id
869: AND ROLE_TYPE = p_org_contact_role_rec.role_type
870: AND STATUS = 'I';
871:

Line 875: HZ_ORG_CONTACT_ROLES_PKG.Update_Row (

871:
872: l_object_version_number := nvl(l_object_version_number, 1) + 1;
873:
874: -- call to table-handler to update the staus to active
875: HZ_ORG_CONTACT_ROLES_PKG.Update_Row (
876: X_Rowid => l_rowid,
877: X_ORG_CONTACT_ROLE_ID => l_org_contact_role_id,
878: X_ORG_CONTACT_ID => p_org_contact_role_rec.org_contact_id,
879: X_ROLE_TYPE => p_org_contact_role_rec.role_type,

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

893: WHEN NO_DATA_FOUND THEN
894:
895: -- Debug info.
896: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
897: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACT_ROLES_PKG.Insert_Row (+)',
898: p_prefix=>l_debug_prefix,
899: p_msg_level=>fnd_log.level_procedure);
900: END IF;
901:

Line 903: HZ_ORG_CONTACT_ROLES_PKG.Insert_Row (

899: p_msg_level=>fnd_log.level_procedure);
900: END IF;
901:
902: -- call table-handler.
903: HZ_ORG_CONTACT_ROLES_PKG.Insert_Row (
904: X_ORG_CONTACT_ROLE_ID => p_org_contact_role_rec.org_contact_role_id,
905: X_ORG_CONTACT_ID => p_org_contact_role_rec.org_contact_id,
906: X_ROLE_TYPE => p_org_contact_role_rec.role_type,
907: X_ROLE_LEVEL => p_org_contact_role_rec.role_level,

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

917: x_org_contact_role_id := p_org_contact_role_rec.org_contact_role_id;
918:
919: -- Debug info.
920: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
921: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACT_ROLES_PKG.Insert_Row (-) ' ||
922: 'x_org_contact_role_id = ' || x_org_contact_role_id,
923: p_prefix=>l_debug_prefix,
924: p_msg_level=>fnd_log.level_procedure);
925: END IF;

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

932: and p_org_contact_role_rec.orig_system <>fnd_api.g_miss_char
933: then
934: l_orig_sys_reference_rec.orig_system := p_org_contact_role_rec.orig_system;
935: l_orig_sys_reference_rec.orig_system_reference := p_org_contact_role_rec.orig_system_reference;
936: l_orig_sys_reference_rec.owner_table_name := 'HZ_ORG_CONTACT_ROLES';
937: l_orig_sys_reference_rec.owner_table_id := p_org_contact_role_rec.org_contact_role_id;
938: -- Bug# 6338010: Start changes made by Neeraj
939: -- Created by module should not be null
940: l_orig_sys_reference_rec.created_by_module := p_org_contact_role_rec.created_by_module;

Line 1017: FROM HZ_ORG_CONTACT_ROLES

1013: SELECT OBJECT_VERSION_NUMBER,
1014: ROWID
1015: INTO l_object_version_number,
1016: l_rowid
1017: FROM HZ_ORG_CONTACT_ROLES
1018: WHERE ORG_CONTACT_ROLE_ID = p_org_contact_role_rec.org_contact_role_id
1019: FOR UPDATE OF ORG_CONTACT_ROLE_ID NOWAIT;
1020:
1021: IF NOT (

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

1024: l_object_version_number IS NOT NULL AND
1025: p_object_version_number = l_object_version_number ) )
1026: THEN
1027: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
1028: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_org_contact_roles');
1029: FND_MSG_PUB.ADD;
1030: RAISE FND_API.G_EXC_ERROR;
1031: END IF;
1032:

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

1062: end if;
1063:
1064: -- Debug info.
1065: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1066: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACT_ROLES_PKG.Update_Row (+) ',
1067: p_prefix=>l_debug_prefix,
1068: p_msg_level=>fnd_log.level_procedure);
1069: END IF;
1070:

Line 1072: HZ_ORG_CONTACT_ROLES_PKG.Update_Row (

1068: p_msg_level=>fnd_log.level_procedure);
1069: END IF;
1070:
1071: -- call to table-handler
1072: HZ_ORG_CONTACT_ROLES_PKG.Update_Row (
1073: X_Rowid => l_rowid,
1074: X_ORG_CONTACT_ROLE_ID => p_org_contact_role_rec.org_contact_role_id,
1075: X_ORG_CONTACT_ID => p_org_contact_role_rec.org_contact_id,
1076: X_ROLE_TYPE => p_org_contact_role_rec.role_type,

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

1085: );
1086:
1087: -- Debug info.
1088: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1089: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACT_ROLES_PKG.Update_Row (-) ',
1090: p_prefix=>l_debug_prefix,
1091: p_msg_level=>fnd_log.level_procedure);
1092: END IF;
1093:

Line 1654: HZ_POPULATE_BOT_PKG.pop_hz_org_contact_roles(

1650: l_org_contact_role_rec );
1651: END IF;
1652:
1653: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1654: HZ_POPULATE_BOT_PKG.pop_hz_org_contact_roles(
1655: p_operation => 'I',
1656: p_org_contact_role_id => x_org_contact_role_id );
1657: END IF;
1658: END IF;

Line 1836: p_owner_table_name => 'HZ_ORG_CONTACT_ROLES',

1832: 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
1833: hz_orig_system_ref_pub.get_owner_table_id
1834: (p_orig_system => p_org_contact_role_rec.orig_system,
1835: p_orig_system_reference => p_org_contact_role_rec.orig_system_reference,
1836: p_owner_table_name => 'HZ_ORG_CONTACT_ROLES',
1837: x_owner_table_id => l_org_contact_role_rec.org_contact_role_id,
1838: x_return_status => x_return_status);
1839: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1840: RAISE FND_API.G_EXC_ERROR;

Line 1874: HZ_POPULATE_BOT_PKG.pop_hz_org_contact_roles(

1870: l_org_contact_role_rec , l_old_org_contact_role_rec );
1871: END IF;
1872:
1873: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1874: HZ_POPULATE_BOT_PKG.pop_hz_org_contact_roles(
1875: p_operation => 'U',
1876: p_org_contact_role_id => l_org_contact_role_rec.org_contact_role_id );
1877: END IF;
1878: END IF;

Line 2208: HZ_ORG_CONTACT_ROLES_PKG.Select_Row (

2204: END IF;
2205:
2206: x_org_contact_role_rec.org_contact_role_id := p_org_contact_role_id;
2207:
2208: HZ_ORG_CONTACT_ROLES_PKG.Select_Row (
2209: X_ORG_CONTACT_ROLE_ID => x_org_contact_role_rec.org_contact_role_id,
2210: X_ORG_CONTACT_ID => x_org_contact_role_rec.org_contact_id,
2211: X_ROLE_TYPE => x_org_contact_role_rec.role_type,
2212: X_ROLE_LEVEL => x_org_contact_role_rec.role_level,