104: l_debug_prefix VARCHAR2(30);
105: l_psu_id NUMBER;
106: l_psu_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_USE_REC_TYPE;
107: BEGIN
108: -- Standard start of API savepoint
109: SAVEPOINT create_party_site_uses_pvt;
110:
111: -- initialize API return status to success.
112: x_return_status := FND_API.G_RET_STS_SUCCESS;
276: l_psu_id NUMBER;
277: l_psu_rec HZ_PARTY_SITE_V2PUB.PARTY_SITE_USE_REC_TYPE;
278: l_ovn NUMBER := NULL;
279: BEGIN
280: -- Standard start of API savepoint
281: SAVEPOINT save_party_site_uses_pvt;
282:
283: -- initialize API return status to success.
284: x_return_status := FND_API.G_RET_STS_SUCCESS;