68: l_debug_prefix VARCHAR2(30);
69: l_contact_pref_id NUMBER;
70: l_contact_pref_rec HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE;
71: BEGIN
72: -- Standard start of API savepoint
73: SAVEPOINT create_contact_preferences_pvt;
74:
75: -- initialize API return status to success.
76: x_return_status := FND_API.G_RET_STS_SUCCESS;
258: l_contact_pref_id NUMBER;
259: l_contact_pref_rec HZ_CONTACT_PREFERENCE_V2PUB.CONTACT_PREFERENCE_REC_TYPE;
260: l_ovn NUMBER := NULL;
261: BEGIN
262: -- Standard start of API savepoint
263: SAVEPOINT save_contact_preferences_pvt;
264:
265: -- initialize API return status to success.
266: x_return_status := FND_API.G_RET_STS_SUCCESS;