DBA Data[Home] [Help]

APPS.HZ_FORMAT_PHONE_V2PUB dependencies on FND_MSG_PUB

Line 217: fnd_msg_pub.initialize;

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;

Line 436: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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.

Line 460: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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.

Line 483: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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.

Line 508: fnd_msg_pub.add;

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);

Line 510: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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.

Line 639: FND_MSG_PUB.initialize;

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;

Line 660: fnd_msg_pub.add;

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:

Line 667: fnd_msg_pub.add;

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: /*--------------------------------------------------------

Line 714: fnd_msg_pub.add;

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

Line 853: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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.

Line 878: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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.

Line 901: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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.

Line 927: fnd_msg_pub.add;

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);

Line 929: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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.

Line 1045: FND_MSG_PUB.initialize;

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;

Line 1223: fnd_msg_pub.count_and_get(

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:

Line 1246: fnd_msg_pub.count_and_get(

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:

Line 1269: fnd_msg_pub.count_and_get(

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:

Line 1294: fnd_msg_pub.add;

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,

Line 1296: fnd_msg_pub.count_and_get(

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:

Line 1386: FND_MSG_PUB.initialize;

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;

Line 1448: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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.

Line 1472: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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.

Line 1495: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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.

Line 1521: fnd_msg_pub.add;

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);

Line 1523: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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.