502:
503: WHEN OTHERS THEN
504: x_return_status := fnd_api.g_ret_sts_unexp_error;
505:
506: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
507: fnd_message.set_token('ERROR' ,SQLERRM);
508: fnd_msg_pub.add;
509:
510: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
503: WHEN OTHERS THEN
504: x_return_status := fnd_api.g_ret_sts_unexp_error;
505:
506: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
507: fnd_message.set_token('ERROR' ,SQLERRM);
508: fnd_msg_pub.add;
509:
510: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
511: p_count => x_msg_count,
653: from HZ_CONTACT_POINTS
654: where CONTACT_POINT_ID = p_contact_point_id;
655: EXCEPTION
656: WHEN NO_DATA_FOUND THEN
657: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
658: fnd_message.set_token('RECORD', 'Contact Point');
659: fnd_message.set_token('VALUE', TO_CHAR(p_contact_point_id));
660: fnd_msg_pub.add;
661: RAISE fnd_api.g_exc_error;
654: where CONTACT_POINT_ID = p_contact_point_id;
655: EXCEPTION
656: WHEN NO_DATA_FOUND THEN
657: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
658: fnd_message.set_token('RECORD', 'Contact Point');
659: fnd_message.set_token('VALUE', TO_CHAR(p_contact_point_id));
660: fnd_msg_pub.add;
661: RAISE fnd_api.g_exc_error;
662: END ;
655: EXCEPTION
656: WHEN NO_DATA_FOUND THEN
657: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
658: fnd_message.set_token('RECORD', 'Contact Point');
659: fnd_message.set_token('VALUE', TO_CHAR(p_contact_point_id));
660: fnd_msg_pub.add;
661: RAISE fnd_api.g_exc_error;
662: END ;
663:
662: END ;
663:
664:
665: IF l_contact_point_type <> 'PHONE' THEN
666: fnd_message.set_name('AR', 'HZ_WRONG_CONTACT_POINT_TYPE');
667: fnd_msg_pub.add;
668: RAISE fnd_api.g_exc_error;
669: END IF;
670:
707: where CONTACT_POINT_ID = p_contact_point_id
708: and CONTACT_POINT_TYPE = 'PHONE';
709: EXCEPTION
710: WHEN NO_DATA_FOUND THEN
711: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
712: fnd_message.set_token('RECORD', 'Contact Point');
713: fnd_message.set_token('VALUE', TO_CHAR(p_contact_point_id));
714: fnd_msg_pub.add;
715: RAISE fnd_api.g_exc_error;
708: and CONTACT_POINT_TYPE = 'PHONE';
709: EXCEPTION
710: WHEN NO_DATA_FOUND THEN
711: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
712: fnd_message.set_token('RECORD', 'Contact Point');
713: fnd_message.set_token('VALUE', TO_CHAR(p_contact_point_id));
714: fnd_msg_pub.add;
715: RAISE fnd_api.g_exc_error;
716: END ;
709: EXCEPTION
710: WHEN NO_DATA_FOUND THEN
711: fnd_message.set_name('AR', 'HZ_API_NO_RECORD');
712: fnd_message.set_token('RECORD', 'Contact Point');
713: fnd_message.set_token('VALUE', TO_CHAR(p_contact_point_id));
714: fnd_msg_pub.add;
715: RAISE fnd_api.g_exc_error;
716: END ;
717:
921:
922: WHEN OTHERS THEN
923: x_return_status := fnd_api.g_ret_sts_unexp_error;
924:
925: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
926: fnd_message.set_token('ERROR' ,SQLERRM);
927: fnd_msg_pub.add;
928:
929: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
922: WHEN OTHERS THEN
923: x_return_status := fnd_api.g_ret_sts_unexp_error;
924:
925: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
926: fnd_message.set_token('ERROR' ,SQLERRM);
927: fnd_msg_pub.add;
928:
929: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
930: p_count => x_msg_count,
1288:
1289: WHEN OTHERS THEN
1290: x_return_status := fnd_api.g_ret_sts_unexp_error;
1291:
1292: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1293: fnd_message.set_token('ERROR' ,SQLERRM);
1294: fnd_msg_pub.add;
1295:
1296: fnd_msg_pub.count_and_get(
1289: WHEN OTHERS THEN
1290: x_return_status := fnd_api.g_ret_sts_unexp_error;
1291:
1292: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1293: fnd_message.set_token('ERROR' ,SQLERRM);
1294: fnd_msg_pub.add;
1295:
1296: fnd_msg_pub.count_and_get(
1297: p_encoded => fnd_api.g_false,
1515:
1516: WHEN OTHERS THEN
1517: x_return_status := fnd_api.g_ret_sts_unexp_error;
1518:
1519: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1520: fnd_message.set_token('ERROR' ,SQLERRM);
1521: fnd_msg_pub.add;
1522:
1523: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1516: WHEN OTHERS THEN
1517: x_return_status := fnd_api.g_ret_sts_unexp_error;
1518:
1519: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1520: fnd_message.set_token('ERROR' ,SQLERRM);
1521: fnd_msg_pub.add;
1522:
1523: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1524: p_count => x_msg_count,