APPS.HZ_CONTACT_PREFERENCE_V2PUB dependencies on HZ_CONTACT_PREFERENCES

Line 170: hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_PREFERENCES_PKG.Insert_Row (+) ',

166: END IF;
167:
168: -- Debug info.
169: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
170: hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_PREFERENCES_PKG.Insert_Row (+) ',
171: p_prefix=>l_debug_prefix,
172: p_msg_level=>fnd_log.level_procedure);
173: END IF;
174:

Line 176: HZ_CONTACT_PREFERENCES_PKG.Insert_Row (

172: p_msg_level=>fnd_log.level_procedure);
173: END IF;
174:
175: -- call table handler to insert a row
176: HZ_CONTACT_PREFERENCES_PKG.Insert_Row (
177: X_Rowid => l_rowid,
178: X_CONTACT_PREFERENCE_ID => p_contact_preference_rec.contact_preference_id,
179: X_CONTACT_LEVEL_TABLE => p_contact_preference_rec.contact_level_table,
180: X_CONTACT_LEVEL_TABLE_ID => p_contact_preference_rec.contact_level_table_id,

Line 204: hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_PREFERENCES_PKG.Insert_Row (-) ' ||

200: );
201:
202: -- Debug info.
203: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
204: hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_PREFERENCES_PKG.Insert_Row (-) ' ||
205: 'x_contact_preference_id = ' || p_contact_preference_rec.contact_preference_id,
206: p_prefix=>l_debug_prefix,
207: p_msg_level=>fnd_log.level_procedure);
208: END IF;

Line 231: * HZ_CONTACT_PREFERENCES_PKG.Update_Row

227: * DESCRIPTION
228: * Private procedure to update contact preference
229: * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
230: * HZ_REGRISTRY_VALIDATE_V2PUB.validate_contact_preference
231: * HZ_CONTACT_PREFERENCES_PKG.Update_Row
232: *
233: * SCOPE - PRIVATE
234: *
235: * EXETERNAL PROCEDURES/FUNCTIONS ACCESSED

Line 284: FROM HZ_CONTACT_PREFERENCES

280: BEGIN
281: -- check last update date.
282: SELECT rowid, object_version_number
283: INTO l_rowid, l_object_version_number
284: FROM HZ_CONTACT_PREFERENCES
285: WHERE contact_preference_id = p_contact_preference_rec.contact_preference_id
286:
287: FOR UPDATE NOWAIT;
288:

Line 296: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_contact_preferences');

292: l_object_version_number IS NOT NULL AND
293: p_object_version_number = l_object_version_number ) )
294: THEN
295: FND_MESSAGE.SET_NAME('AR', 'HZ_API_RECORD_CHANGED');
296: FND_MESSAGE.SET_TOKEN('TABLE', 'hz_contact_preferences');
297: FND_MSG_PUB.ADD;
298: RAISE FND_API.G_EXC_ERROR;
299: END IF;
300:

Line 331: hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_PREFERENCES_PKG.Update_Row (+)',

327: END IF;
328:
329: -- Debug info.
330: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
331: hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_PREFERENCES_PKG.Update_Row (+)',
332: p_prefix=>l_debug_prefix,
333: p_msg_level=>fnd_log.level_procedure);
334: END IF;
335:

Line 337: HZ_CONTACT_PREFERENCES_PKG.Update_Row (

333: p_msg_level=>fnd_log.level_procedure);
334: END IF;
335:
336: -- call table handler to update a row
337: HZ_CONTACT_PREFERENCES_PKG.Update_Row (
338: X_Rowid => l_rowid,
339: X_CONTACT_PREFERENCE_ID => p_contact_preference_rec.contact_preference_id,
340: X_CONTACT_LEVEL_TABLE => p_contact_preference_rec.contact_level_table,
341: X_CONTACT_LEVEL_TABLE_ID => p_contact_preference_rec.contact_level_table_id,

Line 365: hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_PREFERENCES_PKG.Update_Row (-)',

361: );
362:
363: -- Debug info.
364: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
365: hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_PREFERENCES_PKG.Update_Row (-)',
366: p_prefix=>l_debug_prefix,
367: p_msg_level=>fnd_log.level_procedure);
368: END IF;
369:

Line 463: HZ_POPULATE_BOT_PKG.pop_hz_contact_preferences(

459: l_contact_preference_rec );
460: END IF;
461:
462: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
463: HZ_POPULATE_BOT_PKG.pop_hz_contact_preferences(
464: p_operation => 'I',
465: p_contact_preference_id => x_contact_preference_id);
466: END IF;
467: END IF;

Line 666: HZ_POPULATE_BOT_PKG.pop_hz_contact_preferences(

662: l_contact_preference_rec , l_old_contact_preference_rec );
663: END IF;
664:
665: IF(HZ_UTILITY_V2PUB.G_EXECUTE_API_CALLOUTS in ('EVENTS_ENABLED', 'BO_EVENTS_ENABLED')) THEN
666: HZ_POPULATE_BOT_PKG.pop_hz_contact_preferences(
667: p_operation => 'U',
668: p_contact_preference_id => l_contact_preference_rec.contact_preference_id);
669: END IF;
670: END IF;

Line 844: hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_PREFERENCES_PKG.Select_Row (+)',

840:
841: x_contact_preference_rec.contact_preference_id := p_contact_preference_id;
842:
843: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
844: hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_PREFERENCES_PKG.Select_Row (+)',
845: p_prefix=>l_debug_prefix,
846: p_msg_level=>fnd_log.level_procedure);
847: END IF;
848:

Line 849: HZ_CONTACT_PREFERENCES_PKG.Select_Row (

845: p_prefix=>l_debug_prefix,
846: p_msg_level=>fnd_log.level_procedure);
847: END IF;
848:
849: HZ_CONTACT_PREFERENCES_PKG.Select_Row (
850: X_CONTACT_PREFERENCE_ID => x_contact_preference_rec.contact_preference_id,
851: X_CONTACT_LEVEL_TABLE => x_contact_preference_rec.contact_level_table,
852: X_CONTACT_LEVEL_TABLE_ID => x_contact_preference_rec.contact_level_table_id,
853: X_CONTACT_TYPE => x_contact_preference_rec.contact_type,

Line 874: hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_PREFERENCES_PKG.Select_Row (-)',

870: X_APPLICATION_ID => x_contact_preference_rec.application_id
871: );
872:
873: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
874: hz_utility_v2pub.debug(p_message=>'HZ_CONTACT_PREFERENCES_PKG.Select_Row (-)',
875: p_prefix=>l_debug_prefix,
876: p_msg_level=>fnd_log.level_procedure);
877: END IF;
878: