66: END LOOP;
67: CLOSE c_from_ps_loc;
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:
67: CLOSE c_from_ps_loc;
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 (
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);
251: APP_EXCEPTION.RAISE_EXCEPTION;
252: END insert_party_reln_details;
253:
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);
251: APP_EXCEPTION.RAISE_EXCEPTION;
252: END insert_party_reln_details;
253:
254: FUNCTION get_party_site_description(