710: );
711:
712: -- Debug Message
713: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
714: hz_utility_v2pub.debug_return_messages (
715: x_msg_count, x_msg_data, 'ERROR');
716: hz_utility_v2pub.debug('Create_Partner (-)');
717: END IF;
718:
712: -- Debug Message
713: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
714: hz_utility_v2pub.debug_return_messages (
715: x_msg_count, x_msg_data, 'ERROR');
716: hz_utility_v2pub.debug('Create_Partner (-)');
717: END IF;
718:
719: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
720: ROLLBACK TO create_partner_pvt;
727: );
728:
729: -- Debug Message
730: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
731: hz_utility_v2pub.debug_return_messages (
732: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
733: hz_utility_v2pub.debug('Create_Partner (-)');
734: END IF;
735:
729: -- Debug Message
730: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
731: hz_utility_v2pub.debug_return_messages (
732: x_msg_count, x_msg_data, 'UNEXPECTED ERROR');
733: hz_utility_v2pub.debug('Create_Partner (-)');
734: END IF;
735:
736: WHEN OTHERS THEN
737: ROLLBACK TO create_partner_pvt;
747: p_data => x_msg_data );
748:
749: -- Debug Message
750: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
751: hz_utility_v2pub.debug_return_messages (
752: x_msg_count, x_msg_data, 'SQL ERROR');
753: hz_utility_v2pub.debug('Create_Partner (-)');
754: END IF;
755:
749: -- Debug Message
750: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW) THEN
751: hz_utility_v2pub.debug_return_messages (
752: x_msg_count, x_msg_data, 'SQL ERROR');
753: hz_utility_v2pub.debug('Create_Partner (-)');
754: END IF;
755:
756: End Create_Partner;
757:
816:
817:
818: BEGIN
819:
820: hz_utility_v2pub.debug('Party Id:' || p_party_id);
821:
822: l_cnt := 0;
823: FOR cur_cnt IN get_site_use_type(p_party_id)
824: LOOP