351: p_ps_id => l_ps_id);
352: END IF;
353: EXCEPTION
354: WHEN pty_out_rel THEN
355: fnd_message.set_name('AR', 'HZ_API_ERROR_PTY_OUT_REL');
356: fnd_message.set_token('PARTY_ID',TO_CHAR(p_pty_id));
357: fnd_message.set_token('RELATIONSHIP_ID',TO_CHAR(p_rel_id));
358: fnd_msg_pub.add;
359: x_return_status := fnd_api.G_RET_STS_ERROR;
352: END IF;
353: EXCEPTION
354: WHEN pty_out_rel THEN
355: fnd_message.set_name('AR', 'HZ_API_ERROR_PTY_OUT_REL');
356: fnd_message.set_token('PARTY_ID',TO_CHAR(p_pty_id));
357: fnd_message.set_token('RELATIONSHIP_ID',TO_CHAR(p_rel_id));
358: fnd_msg_pub.add;
359: x_return_status := fnd_api.G_RET_STS_ERROR;
360: fnd_msg_pub.Count_And_Get(
353: EXCEPTION
354: WHEN pty_out_rel THEN
355: fnd_message.set_name('AR', 'HZ_API_ERROR_PTY_OUT_REL');
356: fnd_message.set_token('PARTY_ID',TO_CHAR(p_pty_id));
357: fnd_message.set_token('RELATIONSHIP_ID',TO_CHAR(p_rel_id));
358: fnd_msg_pub.add;
359: x_return_status := fnd_api.G_RET_STS_ERROR;
360: fnd_msg_pub.Count_And_Get(
361: p_encoded => FND_API.G_FALSE,
361: p_encoded => FND_API.G_FALSE,
362: p_count => x_msg_count,
363: p_data => x_msg_data);
364: WHEN no_contact_for_rel THEN
365: fnd_message.set_name('AR', 'HZ_API_ERROR_NO_CT_REL');
366: fnd_message.set_token('RELATIONSHIP_ID',TO_CHAR(p_rel_id));
367: fnd_msg_pub.add;
368: x_return_status := fnd_api.G_RET_STS_ERROR;
369: fnd_msg_pub.Count_And_Get(
362: p_count => x_msg_count,
363: p_data => x_msg_data);
364: WHEN no_contact_for_rel THEN
365: fnd_message.set_name('AR', 'HZ_API_ERROR_NO_CT_REL');
366: fnd_message.set_token('RELATIONSHIP_ID',TO_CHAR(p_rel_id));
367: fnd_msg_pub.add;
368: x_return_status := fnd_api.G_RET_STS_ERROR;
369: fnd_msg_pub.Count_And_Get(
370: p_encoded => FND_API.G_FALSE,
389: p_ctx_id => p_ctx_id,
390: p_ps_id => p_ps_id);
391: EXCEPTION
392: WHEN site_not_for_pty THEN
393: fnd_message.set_name('AR', 'HZ_API_ERROR_SITE_NOT_PTY');
394: fnd_message.set_token('PARTY_ID',TO_CHAR(p_pty_id));
395: fnd_message.set_token('PARTY_SITE_ID',TO_CHAR(p_ps_id));
396: fnd_msg_pub.add;
397: x_return_status := fnd_api.G_RET_STS_ERROR;
390: p_ps_id => p_ps_id);
391: EXCEPTION
392: WHEN site_not_for_pty THEN
393: fnd_message.set_name('AR', 'HZ_API_ERROR_SITE_NOT_PTY');
394: fnd_message.set_token('PARTY_ID',TO_CHAR(p_pty_id));
395: fnd_message.set_token('PARTY_SITE_ID',TO_CHAR(p_ps_id));
396: fnd_msg_pub.add;
397: x_return_status := fnd_api.G_RET_STS_ERROR;
398: fnd_msg_pub.Count_And_Get(
391: EXCEPTION
392: WHEN site_not_for_pty THEN
393: fnd_message.set_name('AR', 'HZ_API_ERROR_SITE_NOT_PTY');
394: fnd_message.set_token('PARTY_ID',TO_CHAR(p_pty_id));
395: fnd_message.set_token('PARTY_SITE_ID',TO_CHAR(p_ps_id));
396: fnd_msg_pub.add;
397: x_return_status := fnd_api.G_RET_STS_ERROR;
398: fnd_msg_pub.Count_And_Get(
399: p_encoded => FND_API.G_FALSE,
460:
461: END IF;
462: EXCEPTION
463: WHEN cpt_pb THEN
464: fnd_message.set_name('AR', 'HZ_API_ERROR_CPT');
465: fnd_message.set_token('CONTACT_POINT_ID',TO_CHAR(p_cpt_id));
466: fnd_msg_pub.add;
467: x_return_status := fnd_api.G_RET_STS_ERROR;
468: fnd_msg_pub.Count_And_Get(
461: END IF;
462: EXCEPTION
463: WHEN cpt_pb THEN
464: fnd_message.set_name('AR', 'HZ_API_ERROR_CPT');
465: fnd_message.set_token('CONTACT_POINT_ID',TO_CHAR(p_cpt_id));
466: fnd_msg_pub.add;
467: x_return_status := fnd_api.G_RET_STS_ERROR;
468: fnd_msg_pub.Count_And_Get(
469: p_encoded => FND_API.G_FALSE,
469: p_encoded => FND_API.G_FALSE,
470: p_count => x_msg_count,
471: p_data => x_msg_data);
472: WHEN rel_pb THEN
473: fnd_message.set_name('AR', 'HZ_API_ERROR_REL');
474: fnd_message.set_token('PARTY_ID',TO_CHAR(p_pty_id));
475: fnd_message.set_token('PARTY2_ID', TO_CHAR(l_id));
476: fnd_msg_pub.add;
477: x_return_status := fnd_api.G_RET_STS_ERROR;
470: p_count => x_msg_count,
471: p_data => x_msg_data);
472: WHEN rel_pb THEN
473: fnd_message.set_name('AR', 'HZ_API_ERROR_REL');
474: fnd_message.set_token('PARTY_ID',TO_CHAR(p_pty_id));
475: fnd_message.set_token('PARTY2_ID', TO_CHAR(l_id));
476: fnd_msg_pub.add;
477: x_return_status := fnd_api.G_RET_STS_ERROR;
478: fnd_msg_pub.Count_And_Get(
471: p_data => x_msg_data);
472: WHEN rel_pb THEN
473: fnd_message.set_name('AR', 'HZ_API_ERROR_REL');
474: fnd_message.set_token('PARTY_ID',TO_CHAR(p_pty_id));
475: fnd_message.set_token('PARTY2_ID', TO_CHAR(l_id));
476: fnd_msg_pub.add;
477: x_return_status := fnd_api.G_RET_STS_ERROR;
478: fnd_msg_pub.Count_And_Get(
479: p_encoded => FND_API.G_FALSE,