355: END IF;
356:
357: -- Debug info.
358: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
359: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACTS_PKG.Insert_Row (+)',
360: p_prefix=>l_debug_prefix,
361: p_msg_level=>fnd_log.level_procedure);
362: END IF;
363:
361: p_msg_level=>fnd_log.level_procedure);
362: END IF;
363:
364: -- call table-handler.
365: HZ_ORG_CONTACTS_PKG.Insert_Row (
366: X_ORG_CONTACT_ID => p_org_contact_rec.org_contact_id,
367: X_PARTY_RELATIONSHIP_ID => x_party_rel_id,
368: X_COMMENTS => p_org_contact_rec.comments,
369: X_CONTACT_NUMBER => l_contact_number,
409: );
410:
411: -- Debug info.
412: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
413: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACTS_PKG.Insert_Row (-)',
414: p_prefix=>l_debug_prefix,
415: p_msg_level=>fnd_log.level_procedure);
416: END IF;
417:
649: end if;
650:
651: -- Debug info.
652: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
653: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACTS_PKG.Update_Row (+) ',
654: p_prefix=>l_debug_prefix,
655: p_msg_level=>fnd_log.level_procedure);
656: END IF;
657: -- call to table-handler
654: p_prefix=>l_debug_prefix,
655: p_msg_level=>fnd_log.level_procedure);
656: END IF;
657: -- call to table-handler
658: HZ_ORG_CONTACTS_PKG.Update_Row (
659: X_Rowid => l_rowid,
660: X_ORG_CONTACT_ID => p_org_contact_rec.org_contact_id,
661: X_PARTY_RELATIONSHIP_ID => p_org_contact_rec.party_rel_rec.relationship_id,
662: X_COMMENTS => p_org_contact_rec.comments,
702: X_STATUS => l_org_status
703: );
704: -- Debug info.
705: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
706: hz_utility_v2pub.debug(p_message=>'HZ_ORG_CONTACTS_PKG.Update_Row (-) ',
707: p_prefix=>l_debug_prefix,
708: p_msg_level=>fnd_log.level_procedure);
709: END IF;
710:
2049: END IF;
2050:
2051: x_org_contact_rec.org_contact_id := p_org_contact_id;
2052:
2053: HZ_ORG_CONTACTS_PKG.Select_Row (
2054: X_ORG_CONTACT_ID => x_org_contact_rec.org_contact_id,
2055: X_PARTY_RELATIONSHIP_ID => l_party_relationship_id,
2056: X_COMMENTS => x_org_contact_rec.comments,
2057: X_CONTACT_NUMBER => x_org_contact_rec.contact_number,