213: END IF;
214:
215: -- Initialize message list if p_init_msg_list is set to TRUE.
216: IF fnd_api.to_boolean(p_init_msg_list) THEN
217: fnd_msg_pub.initialize;
218: END IF;
219:
220: -- Initialize API return status to success.
221: x_return_status := fnd_api.g_ret_sts_success;
432: x_msg_data );
433:
434:
435: -- Standard call to get msg count and if count is 1, get msg info.
436: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
437: p_count => x_msg_count,
438: p_data => x_msg_data);
439:
440: -- Debug info.
456: EXCEPTION
457: WHEN fnd_api.g_exc_error THEN
458: x_return_status := fnd_api.g_ret_sts_error;
459:
460: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
461: p_count => x_msg_count,
462: p_data => x_msg_data);
463:
464: -- Debug info.
479:
480: WHEN fnd_api.g_exc_unexpected_error THEN
481: x_return_status := fnd_api.g_ret_sts_unexp_error;
482:
483: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
484: p_count => x_msg_count,
485: p_data => x_msg_data);
486:
487: -- Debug info.
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,
512: p_data => x_msg_data);
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,
512: p_data => x_msg_data);
513:
514: -- Debug info.
635: END IF;
636:
637: -- initialize message list if p_init_msg_list is set to TRUE.
638: IF FND_API.to_Boolean(p_init_msg_list) THEN
639: FND_MSG_PUB.initialize;
640: END IF;
641:
642: -- initialize API return status to success.
643: x_return_status := FND_API.G_RET_STS_SUCCESS;
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:
664:
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:
671: /*--------------------------------------------------------
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:
718: IF l_phone_area_code IS NULL OR
849:
850: x_formatted_phone_number := l_formatted_phone_number;
851:
852: -- Standard call to get msg count and if count is 1, get msg info.
853: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
854: p_count => x_msg_count,
855: p_data => x_msg_data);
856:
857: -- Debug info.
874:
875: WHEN fnd_api.g_exc_error THEN
876: x_return_status := fnd_api.g_ret_sts_error;
877:
878: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
879: p_count => x_msg_count,
880: p_data => x_msg_data);
881:
882: -- Debug info.
897:
898: WHEN fnd_api.g_exc_unexpected_error THEN
899: x_return_status := fnd_api.g_ret_sts_unexp_error;
900:
901: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
902: p_count => x_msg_count,
903: p_data => x_msg_data);
904:
905: -- Debug info.
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,
931: p_data => x_msg_data);
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,
931: p_data => x_msg_data);
932:
933: -- Debug info.
1041: END IF;
1042:
1043: -- initialize message list if p_init_msg_list is set to TRUE.
1044: IF FND_API.to_Boolean(p_init_msg_list) THEN
1045: FND_MSG_PUB.initialize;
1046: END IF;
1047:
1048: -- initialize API return status to success.
1049: x_return_status := FND_API.G_RET_STS_SUCCESS;
1219:
1220: x_formatted_phone_number := l_formatted_phone_number;
1221:
1222: -- Standard call to get msg count and if count is 1, get msg info.
1223: fnd_msg_pub.count_and_get(
1224: p_encoded => fnd_api.g_false,
1225: p_count => x_msg_count,
1226: p_data => x_msg_data);
1227:
1242:
1243: EXCEPTION
1244: WHEN fnd_api.g_exc_error THEN
1245: x_return_status := fnd_api.g_ret_sts_error;
1246: fnd_msg_pub.count_and_get(
1247: p_encoded => fnd_api.g_false,
1248: p_count => x_msg_count,
1249: p_data => x_msg_data);
1250:
1265:
1266:
1267: WHEN fnd_api.g_exc_unexpected_error THEN
1268: x_return_status := fnd_api.g_ret_sts_unexp_error;
1269: fnd_msg_pub.count_and_get(
1270: p_encoded => fnd_api.g_false,
1271: p_count => x_msg_count,
1272: p_data => x_msg_data);
1273:
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,
1298: p_count => x_msg_count,
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,
1298: p_count => x_msg_count,
1299: p_data => x_msg_data);
1300:
1382: END IF;
1383:
1384: -- initialize message list if p_init_msg_list is set to TRUE.
1385: IF FND_API.to_Boolean(p_init_msg_list) THEN
1386: FND_MSG_PUB.initialize;
1387: END IF;
1388:
1389: -- initialize API return status to success.
1390: x_return_status := FND_API.G_RET_STS_SUCCESS;
1444: x_mobile_flag := 'N';
1445: END IF; ---p_phone_country_code is NULL
1446:
1447: -- Standard call to get msg count and if count is 1, get msg info.
1448: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1449: p_count => x_msg_count,
1450: p_data => x_msg_data);
1451:
1452: -- Debug info.
1468: EXCEPTION
1469: WHEN fnd_api.g_exc_error THEN
1470: x_return_status := fnd_api.g_ret_sts_error;
1471:
1472: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1473: p_count => x_msg_count,
1474: p_data => x_msg_data);
1475:
1476: -- Debug info.
1491:
1492: WHEN fnd_api.g_exc_unexpected_error THEN
1493: x_return_status := fnd_api.g_ret_sts_unexp_error;
1494:
1495: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1496: p_count => x_msg_count,
1497: p_data => x_msg_data);
1498:
1499: -- Debug info.
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,
1525: p_data => x_msg_data);
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,
1525: p_data => x_msg_data);
1526:
1527: -- Debug info.