DBA Data[Home] [Help]

APPS.HZ_CUST_ACCOUNT_ROLE_V2PUB dependencies on HZ_CUST_ACCOUNT_ROLES

Line 122: * HZ_CUST_ACCOUNT_ROLES_PKG.Insert_Row

118: * Private procedure to create customer account role.
119: *
120: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
121: * HZ_ACCOUNT_VALIDATE_V2PUB.validate_cust_account_role
122: * HZ_CUST_ACCOUNT_ROLES_PKG.Insert_Row
123: * HZ_PARTY_SITE_V2PUB.create_party_site
124: *
125: * ARGUMENTS
126: * IN/OUT:

Line 259: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNT_ROLES_PKG.Insert_Row (+)',

255: END IF;
256: */
257: -- Debug info.
258: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
259: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNT_ROLES_PKG.Insert_Row (+)',
260: p_prefix=>l_debug_prefix,
261: p_msg_level=>fnd_log.level_procedure);
262: END IF;
263:

Line 265: HZ_CUST_ACCOUNT_ROLES_PKG.Insert_Row (

261: p_msg_level=>fnd_log.level_procedure);
262: END IF;
263:
264: -- Call table-handler.
265: HZ_CUST_ACCOUNT_ROLES_PKG.Insert_Row (
266: X_CUST_ACCOUNT_ROLE_ID => p_cust_account_role_rec.cust_account_role_id,
267: X_PARTY_ID => p_cust_account_role_rec.party_id,
268: X_CUST_ACCOUNT_ID => p_cust_account_role_rec.cust_account_id,
269: X_CUST_ACCT_SITE_ID => p_cust_account_role_rec.cust_acct_site_id,

Line 309: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNT_ROLES_PKG.Insert_Row (-) ' ||

305:
306:
307: -- Debug info.
308: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
309: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNT_ROLES_PKG.Insert_Row (-) ' ||
310: 'x_cust_account_role_id = ' || p_cust_account_role_rec.cust_account_role_id,
311: p_prefix=>l_debug_prefix,
312: p_msg_level=>fnd_log.level_procedure);
313: END IF;

Line 325: l_orig_sys_reference_rec.owner_table_name := 'HZ_CUST_ACCOUNT_ROLES';

321:
322: if (p_cust_account_role_rec.orig_system is not null and p_cust_account_role_rec.orig_system<>fnd_api.g_miss_char ) then
323: l_orig_sys_reference_rec.orig_system := p_cust_account_role_rec.orig_system;
324: l_orig_sys_reference_rec.orig_system_reference := p_cust_account_role_rec.orig_system_reference;
325: l_orig_sys_reference_rec.owner_table_name := 'HZ_CUST_ACCOUNT_ROLES';
326: l_orig_sys_reference_rec.owner_table_id := p_cust_account_role_rec.cust_account_role_id;
327: l_orig_sys_reference_rec.created_by_module := p_cust_account_role_rec.created_by_module;
328:
329: hz_orig_system_ref_pub.create_orig_system_reference(

Line 358: * HZ_CUST_ACCOUNT_ROLES_PKG.Update_Row

354: * Private procedure to update customer account role.
355: *
356: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
357: * HZ_ACCOUNT_VALIDATE_V2PUB.validate_cust_account_role
358: * HZ_CUST_ACCOUNT_ROLES_PKG.Update_Row
359: *
360: * ARGUMENTS
361: * IN/OUT:
362: * p_cust_account_role_rec Customer account role record.

Line 403: FROM HZ_CUST_ACCOUNT_ROLES

399: -- Lock record.
400: BEGIN
401: SELECT ROWID, OBJECT_VERSION_NUMBER
402: INTO l_rowid, l_object_version_number
403: FROM HZ_CUST_ACCOUNT_ROLES
404: WHERE CUST_ACCOUNT_ROLE_ID = p_cust_account_role_rec.cust_account_role_id
405: FOR UPDATE NOWAIT;
406:
407: IF NOT (

Line 414: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_account_roles' );

410: l_object_version_number IS NOT NULL AND
411: p_object_version_number = l_object_version_number ) )
412: THEN
413: FND_MESSAGE.SET_NAME( 'AR', 'HZ_API_RECORD_CHANGED' );
414: FND_MESSAGE.SET_TOKEN( 'TABLE', 'hz_cust_account_roles' );
415: FND_MSG_PUB.ADD;
416: RAISE FND_API.G_EXC_ERROR;
417: END IF;
418:

Line 454: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNT_ROLES_PKG.Update_Row (+)',

450: end if;
451:
452: -- Debug info.
453: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
454: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNT_ROLES_PKG.Update_Row (+)',
455: p_prefix=>l_debug_prefix,
456: p_msg_level=>fnd_log.level_procedure);
457: END IF;
458:

Line 460: HZ_CUST_ACCOUNT_ROLES_PKG.Update_Row (

456: p_msg_level=>fnd_log.level_procedure);
457: END IF;
458:
459: -- Call table-handler.
460: HZ_CUST_ACCOUNT_ROLES_PKG.Update_Row (
461: X_Rowid => l_rowid,
462: X_CUST_ACCOUNT_ROLE_ID => p_cust_account_role_rec.cust_account_role_id,
463: X_PARTY_ID => p_cust_account_role_rec.party_id,
464: X_CUST_ACCOUNT_ID => p_cust_account_role_rec.cust_account_id,

Line 504: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNT_ROLES_PKG.Update_Row (-)',

500: );
501:
502: -- Debug info.
503: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
504: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNT_ROLES_PKG.Update_Row (-)',
505: p_prefix=>l_debug_prefix,
506: p_msg_level=>fnd_log.level_procedure);
507: END IF;
508:

Line 850: HZ_POPULATE_BOT_PKG.pop_hz_cust_account_roles(

846: l_cust_account_role_rec );
847: END IF;
848:
849: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
850: HZ_POPULATE_BOT_PKG.pop_hz_cust_account_roles(
851: p_operation => 'I',
852: p_cust_account_role_id => x_cust_account_role_id);
853: END IF;
854: END IF;

Line 1031: p_owner_table_name => 'HZ_CUST_ACCOUNT_ROLES',

1027:
1028: hz_orig_system_ref_pub.get_owner_table_id
1029: (p_orig_system => p_cust_account_role_rec.orig_system,
1030: p_orig_system_reference => p_cust_account_role_rec.orig_system_reference,
1031: p_owner_table_name => 'HZ_CUST_ACCOUNT_ROLES',
1032: x_owner_table_id => l_cust_account_role_rec.cust_account_role_id,
1033: x_return_status => x_return_status);
1034: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1035: RAISE FND_API.G_EXC_ERROR;

Line 1068: HZ_POPULATE_BOT_PKG.pop_hz_cust_account_roles(

1064: l_cust_account_role_rec , l_old_cust_account_role_rec );
1065: END IF;
1066:
1067: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
1068: HZ_POPULATE_BOT_PKG.pop_hz_cust_account_roles(
1069: p_operation => 'U',
1070: p_cust_account_role_id => l_cust_account_role_rec.cust_account_role_id);
1071: END IF;
1072: END IF;

Line 1179: * HZ_CUST_ACCOUNT_ROLES_PKG.Select_Row

1175: * DESCRIPTION
1176: * Gets customer account role record
1177: *
1178: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
1179: * HZ_CUST_ACCOUNT_ROLES_PKG.Select_Row
1180: *
1181: * ARGUMENTS
1182: * IN:
1183: * p_init_msg_list Initialize message stack if it is set to

Line 1247: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNT_ROLES_PKG.Select_Row (+)',

1243: x_cust_account_role_rec.cust_account_role_id := p_cust_account_role_id;
1244:
1245: -- Debug info.
1246: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1247: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNT_ROLES_PKG.Select_Row (+)',
1248: p_prefix=>l_debug_prefix,
1249: p_msg_level=>fnd_log.level_procedure);
1250: END IF;
1251:

Line 1254: HZ_CUST_ACCOUNT_ROLES_PKG.Select_Row (

1250: END IF;
1251:
1252:
1253: -- Call table-handler.
1254: HZ_CUST_ACCOUNT_ROLES_PKG.Select_Row (
1255: X_CUST_ACCOUNT_ROLE_ID => x_cust_account_role_rec.cust_account_role_id,
1256: X_PARTY_ID => x_cust_account_role_rec.party_id,
1257: X_CUST_ACCOUNT_ID => x_cust_account_role_rec.cust_account_id,
1258: X_CUST_ACCT_SITE_ID => x_cust_account_role_rec.cust_acct_site_id,

Line 1296: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNT_ROLES_PKG.Select_Row (-)',

1292: );
1293:
1294: -- Debug info.
1295: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
1296: hz_utility_v2pub.debug(p_message=>'HZ_CUST_ACCOUNT_ROLES_PKG.Select_Row (-)',
1297: p_prefix=>l_debug_prefix,
1298: p_msg_level=>fnd_log.level_procedure);
1299: END IF;
1300: