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:
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,
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;
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
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:
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,
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:
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:
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,
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: