68: EXCEPTION
69: WHEN OTHERS THEN
70: FND_MESSAGE.SET_NAME('AR','HZ_FORM_DUP_PROC_ERROR');
71: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
72: APP_EXCEPTION.RAISE_EXCEPTION;
73: END insert_party_site_details;
74:
75: PROCEDURE insert_party_reln_details (
76: p_from_party_id IN NUMBER,
242: CLOSE c_from_reln;
243: END IF;
244: EXCEPTION
245: WHEN FND_API.G_EXC_ERROR THEN
246: --APP_EXCEPTION.RAISE_EXCEPTION;
247: RAISE;
248: WHEN OTHERS THEN
249: FND_MESSAGE.SET_NAME('AR','HZ_FORM_DUP_PROC_ERROR');
250: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
247: RAISE;
248: WHEN OTHERS THEN
249: FND_MESSAGE.SET_NAME('AR','HZ_FORM_DUP_PROC_ERROR');
250: FND_MESSAGE.SET_TOKEN('ERROR', SQLERRM);
251: APP_EXCEPTION.RAISE_EXCEPTION;
252: END insert_party_reln_details;
253:
254: FUNCTION get_party_site_description(
255: p_party_site_id IN NUMBER)