[Home] [Help]
161: where primary_contact_phone_id = p_from_fk_id;
162: END IF;
163: EXCEPTION
164: WHEN OTHERS THEN
165: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
166: x_return_status := FND_API.G_RET_STS_ERROR;
167: raise;
168: END;
169: END IF;
301: where phone_id = p_from_fk_id;
302: END IF;
303: EXCEPTION
304: WHEN OTHERS THEN
305: arp_message.set_line(g_pkg_name || '.' || l_api_name || ': ' || sqlerrm);
306: x_return_status := FND_API.G_RET_STS_ERROR;
307: raise;
308: END;
309: END IF;