DBA Data[Home] [Help]

APPS.HZ_PARTY_BO_PVT dependencies on FND_MSG_PUB

Line 550: FND_MSG_PUB.ADD;

546: WHEN fnd_api.g_exc_error THEN
547: ROLLBACK TO create_relationships_pvt;
548: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
549: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_RELATIONSHIPS');
550: FND_MSG_PUB.ADD;
551:
552: x_return_status := fnd_api.g_ret_sts_error;
553:
554: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

550: FND_MSG_PUB.ADD;
551:
552: x_return_status := fnd_api.g_ret_sts_error;
553:
554: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
555: p_count => x_msg_count,
556: p_data => x_msg_data);
557:
558: -- Debug info.

Line 574: FND_MSG_PUB.ADD;

570: WHEN fnd_api.g_exc_unexpected_error THEN
571: ROLLBACK TO create_relationships_pvt;
572: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
573: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_RELATIONSHIPS');
574: FND_MSG_PUB.ADD;
575:
576: x_return_status := fnd_api.g_ret_sts_unexp_error;
577:
578: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

574: FND_MSG_PUB.ADD;
575:
576: x_return_status := fnd_api.g_ret_sts_unexp_error;
577:
578: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
579: p_count => x_msg_count,
580: p_data => x_msg_data);
581:
582: -- Debug info.

Line 599: FND_MSG_PUB.ADD;

595: WHEN OTHERS THEN
596: ROLLBACK TO create_relationships_pvt;
597: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
598: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_RELATIONSHIPS');
599: FND_MSG_PUB.ADD;
600:
601: x_return_status := fnd_api.g_ret_sts_unexp_error;
602:
603: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

Line 605: fnd_msg_pub.add;

601: x_return_status := fnd_api.g_ret_sts_unexp_error;
602:
603: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
604: fnd_message.set_token('ERROR' ,SQLERRM);
605: fnd_msg_pub.add;
606:
607: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
608: p_count => x_msg_count,
609: p_data => x_msg_data);

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

603: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
604: fnd_message.set_token('ERROR' ,SQLERRM);
605: fnd_msg_pub.add;
606:
607: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
608: p_count => x_msg_count,
609: p_data => x_msg_data);
610:
611: -- Debug info.

Line 801: FND_MSG_PUB.ADD;

797: WHEN fnd_api.g_exc_error THEN
798: ROLLBACK TO save_relationships_pvt;
799: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
800: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_RELATIONSHIPS');
801: FND_MSG_PUB.ADD;
802:
803: x_return_status := fnd_api.g_ret_sts_error;
804:
805: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

801: FND_MSG_PUB.ADD;
802:
803: x_return_status := fnd_api.g_ret_sts_error;
804:
805: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
806: p_count => x_msg_count,
807: p_data => x_msg_data);
808:
809: -- Debug info.

Line 825: FND_MSG_PUB.ADD;

821: WHEN fnd_api.g_exc_unexpected_error THEN
822: ROLLBACK TO save_relationships_pvt;
823: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
824: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_RELATIONSHIPS');
825: FND_MSG_PUB.ADD;
826:
827: x_return_status := fnd_api.g_ret_sts_unexp_error;
828:
829: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

825: FND_MSG_PUB.ADD;
826:
827: x_return_status := fnd_api.g_ret_sts_unexp_error;
828:
829: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
830: p_count => x_msg_count,
831: p_data => x_msg_data);
832:
833: -- Debug info.

Line 850: FND_MSG_PUB.ADD;

846: WHEN OTHERS THEN
847: ROLLBACK TO save_relationships_pvt;
848: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
849: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_RELATIONSHIPS');
850: FND_MSG_PUB.ADD;
851:
852: x_return_status := fnd_api.g_ret_sts_unexp_error;
853:
854: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

Line 856: fnd_msg_pub.add;

852: x_return_status := fnd_api.g_ret_sts_unexp_error;
853:
854: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
855: fnd_message.set_token('ERROR' ,SQLERRM);
856: fnd_msg_pub.add;
857:
858: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
859: p_count => x_msg_count,
860: p_data => x_msg_data);

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

854: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
855: fnd_message.set_token('ERROR' ,SQLERRM);
856: fnd_msg_pub.add;
857:
858: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
859: p_count => x_msg_count,
860: p_data => x_msg_data);
861:
862: -- Debug info.

Line 902: FND_MSG_PUB.initialize;

898: x_return_status := FND_API.G_RET_STS_SUCCESS;
899:
900: -- Initialize message list if p_init_msg_list is set to TRUE
901: IF FND_API.to_Boolean(p_init_msg_list) THEN
902: FND_MSG_PUB.initialize;
903: END IF;
904:
905: -- Debug info.
906: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 979: FND_MSG_PUB.ADD;

975: WHEN fnd_api.g_exc_error THEN
976: ROLLBACK TO create_relatobj_pvt;
977: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
978: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_RELATIONSHIPS');
979: FND_MSG_PUB.ADD;
980:
981: x_return_status := fnd_api.g_ret_sts_error;
982:
983: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

979: FND_MSG_PUB.ADD;
980:
981: x_return_status := fnd_api.g_ret_sts_error;
982:
983: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
984: p_count => x_msg_count,
985: p_data => x_msg_data);
986:
987: -- Debug info.

Line 1003: FND_MSG_PUB.ADD;

999: WHEN fnd_api.g_exc_unexpected_error THEN
1000: ROLLBACK TO create_relatobj_pvt;
1001: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1002: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_RELATIONSHIPS');
1003: FND_MSG_PUB.ADD;
1004:
1005: x_return_status := fnd_api.g_ret_sts_unexp_error;
1006:
1007: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

1003: FND_MSG_PUB.ADD;
1004:
1005: x_return_status := fnd_api.g_ret_sts_unexp_error;
1006:
1007: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1008: p_count => x_msg_count,
1009: p_data => x_msg_data);
1010:
1011: -- Debug info.

Line 1028: FND_MSG_PUB.ADD;

1024: WHEN OTHERS THEN
1025: ROLLBACK TO create_relatobj_pvt;
1026: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1027: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_RELATIONSHIPS');
1028: FND_MSG_PUB.ADD;
1029:
1030: x_return_status := fnd_api.g_ret_sts_unexp_error;
1031:
1032: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

Line 1034: fnd_msg_pub.add;

1030: x_return_status := fnd_api.g_ret_sts_unexp_error;
1031:
1032: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1033: fnd_message.set_token('ERROR' ,SQLERRM);
1034: fnd_msg_pub.add;
1035:
1036: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1037: p_count => x_msg_count,
1038: p_data => x_msg_data);

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

1032: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1033: fnd_message.set_token('ERROR' ,SQLERRM);
1034: fnd_msg_pub.add;
1035:
1036: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1037: p_count => x_msg_count,
1038: p_data => x_msg_data);
1039:
1040: -- Debug info.

Line 1090: FND_MSG_PUB.initialize;

1086: x_return_status := FND_API.G_RET_STS_SUCCESS;
1087:
1088: -- Initialize message list if p_init_msg_list is set to TRUE
1089: IF FND_API.to_Boolean(p_init_msg_list) THEN
1090: FND_MSG_PUB.initialize;
1091: END IF;
1092:
1093: -- Debug info.
1094: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

Line 1163: FND_MSG_PUB.ADD;

1159: WHEN fnd_api.g_exc_error THEN
1160: ROLLBACK TO update_relatobj_pvt;
1161: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1162: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_RELATIONSHIPS');
1163: FND_MSG_PUB.ADD;
1164:
1165: x_return_status := fnd_api.g_ret_sts_error;
1166:
1167: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

1163: FND_MSG_PUB.ADD;
1164:
1165: x_return_status := fnd_api.g_ret_sts_error;
1166:
1167: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1168: p_count => x_msg_count,
1169: p_data => x_msg_data);
1170:
1171: -- Debug info.

Line 1187: FND_MSG_PUB.ADD;

1183: WHEN fnd_api.g_exc_unexpected_error THEN
1184: ROLLBACK TO update_relatobj_pvt;
1185: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1186: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_RELATIONSHIPS');
1187: FND_MSG_PUB.ADD;
1188:
1189: x_return_status := fnd_api.g_ret_sts_unexp_error;
1190:
1191: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

1187: FND_MSG_PUB.ADD;
1188:
1189: x_return_status := fnd_api.g_ret_sts_unexp_error;
1190:
1191: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1192: p_count => x_msg_count,
1193: p_data => x_msg_data);
1194:
1195: -- Debug info.

Line 1212: FND_MSG_PUB.ADD;

1208: WHEN OTHERS THEN
1209: ROLLBACK TO update_relatobj_pvt;
1210: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1211: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_RELATIONSHIPS');
1212: FND_MSG_PUB.ADD;
1213:
1214: x_return_status := fnd_api.g_ret_sts_unexp_error;
1215:
1216: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

Line 1218: fnd_msg_pub.add;

1214: x_return_status := fnd_api.g_ret_sts_unexp_error;
1215:
1216: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1217: fnd_message.set_token('ERROR' ,SQLERRM);
1218: fnd_msg_pub.add;
1219:
1220: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1221: p_count => x_msg_count,
1222: p_data => x_msg_data);

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

1216: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1217: fnd_message.set_token('ERROR' ,SQLERRM);
1218: fnd_msg_pub.add;
1219:
1220: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1221: p_count => x_msg_count,
1222: p_data => x_msg_data);
1223:
1224: -- Debug info.

Line 1275: FND_MSG_PUB.initialize;

1271: x_return_status := FND_API.G_RET_STS_SUCCESS;
1272:
1273: -- Initialize message list if p_init_msg_list is set to TRUE
1274: IF FND_API.to_Boolean(p_init_msg_list) THEN
1275: FND_MSG_PUB.initialize;
1276: END IF;
1277:
1278:
1279: -- Debug info.

Line 1373: FND_MSG_PUB.ADD;

1369: WHEN fnd_api.g_exc_error THEN
1370: ROLLBACK TO save_relatobj_pvt;
1371: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1372: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_RELATIONSHIPS');
1373: FND_MSG_PUB.ADD;
1374:
1375: x_return_status := fnd_api.g_ret_sts_error;
1376:
1377: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

1373: FND_MSG_PUB.ADD;
1374:
1375: x_return_status := fnd_api.g_ret_sts_error;
1376:
1377: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1378: p_count => x_msg_count,
1379: p_data => x_msg_data);
1380:
1381: -- Debug info.

Line 1397: FND_MSG_PUB.ADD;

1393: WHEN fnd_api.g_exc_unexpected_error THEN
1394: ROLLBACK TO save_relatobj_pvt;
1395: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1396: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_RELATIONSHIPS');
1397: FND_MSG_PUB.ADD;
1398:
1399: x_return_status := fnd_api.g_ret_sts_unexp_error;
1400:
1401: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

1397: FND_MSG_PUB.ADD;
1398:
1399: x_return_status := fnd_api.g_ret_sts_unexp_error;
1400:
1401: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1402: p_count => x_msg_count,
1403: p_data => x_msg_data);
1404:
1405: -- Debug info.

Line 1422: FND_MSG_PUB.ADD;

1418: WHEN OTHERS THEN
1419: ROLLBACK TO save_relatobj_pvt;
1420: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1421: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_RELATIONSHIPS');
1422: FND_MSG_PUB.ADD;
1423:
1424: x_return_status := fnd_api.g_ret_sts_unexp_error;
1425:
1426: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

Line 1428: fnd_msg_pub.add;

1424: x_return_status := fnd_api.g_ret_sts_unexp_error;
1425:
1426: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1427: fnd_message.set_token('ERROR' ,SQLERRM);
1428: fnd_msg_pub.add;
1429:
1430: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1431: p_count => x_msg_count,
1432: p_data => x_msg_data);

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

1426: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1427: fnd_message.set_token('ERROR' ,SQLERRM);
1428: fnd_msg_pub.add;
1429:
1430: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1431: p_count => x_msg_count,
1432: p_data => x_msg_data);
1433:
1434: -- Debug info.

Line 1568: FND_MSG_PUB.initialize;

1564: x_return_status := FND_API.G_RET_STS_SUCCESS;
1565:
1566: -- Initialize message list if p_init_msg_list is set to TRUE
1567: IF FND_API.to_Boolean(p_init_msg_list) THEN
1568: FND_MSG_PUB.initialize;
1569: END IF;
1570:
1571: -- Debug info.
1572: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN

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

1595: END IF;
1596: EXCEPTION
1597: WHEN fnd_api.g_exc_error THEN
1598: x_return_status := fnd_api.g_ret_sts_error;
1599: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1600: p_count => x_msg_count,
1601: p_data => x_msg_data);
1602:
1603: -- Debug info.

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

1613: p_msg_level=>fnd_log.level_procedure);
1614: END IF;
1615: WHEN fnd_api.g_exc_unexpected_error THEN
1616: x_return_status := fnd_api.g_ret_sts_unexp_error;
1617: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1618: p_count => x_msg_count,
1619: p_data => x_msg_data);
1620:
1621: -- Debug info.

Line 1639: fnd_msg_pub.add;

1635: x_return_status := fnd_api.g_ret_sts_unexp_error;
1636:
1637: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1638: fnd_message.set_token('ERROR' ,SQLERRM);
1639: fnd_msg_pub.add;
1640:
1641: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1642: p_count => x_msg_count,
1643: p_data => x_msg_data);

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

1637: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1638: fnd_message.set_token('ERROR' ,SQLERRM);
1639: fnd_msg_pub.add;
1640:
1641: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1642: p_count => x_msg_count,
1643: p_data => x_msg_data);
1644:
1645: -- Debug info.

Line 1768: FND_MSG_PUB.ADD;

1764: WHEN fnd_api.g_exc_error THEN
1765: ROLLBACK TO create_classifications_pvt;
1766: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1767: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CODE_ASSIGNMENTS');
1768: FND_MSG_PUB.ADD;
1769:
1770: x_return_status := fnd_api.g_ret_sts_error;
1771:
1772: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

1768: FND_MSG_PUB.ADD;
1769:
1770: x_return_status := fnd_api.g_ret_sts_error;
1771:
1772: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1773: p_count => x_msg_count,
1774: p_data => x_msg_data);
1775:
1776: -- Debug info.

Line 1792: FND_MSG_PUB.ADD;

1788: WHEN fnd_api.g_exc_unexpected_error THEN
1789: ROLLBACK TO create_classifications_pvt;
1790: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1791: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CODE_ASSIGNMENTS');
1792: FND_MSG_PUB.ADD;
1793:
1794: x_return_status := fnd_api.g_ret_sts_unexp_error;
1795:
1796: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

1792: FND_MSG_PUB.ADD;
1793:
1794: x_return_status := fnd_api.g_ret_sts_unexp_error;
1795:
1796: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1797: p_count => x_msg_count,
1798: p_data => x_msg_data);
1799:
1800: -- Debug info.

Line 1817: FND_MSG_PUB.ADD;

1813: WHEN OTHERS THEN
1814: ROLLBACK TO create_classifications_pvt;
1815: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1816: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CODE_ASSIGNMENTS');
1817: FND_MSG_PUB.ADD;
1818:
1819: x_return_status := fnd_api.g_ret_sts_unexp_error;
1820:
1821: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

Line 1823: fnd_msg_pub.add;

1819: x_return_status := fnd_api.g_ret_sts_unexp_error;
1820:
1821: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1822: fnd_message.set_token('ERROR' ,SQLERRM);
1823: fnd_msg_pub.add;
1824:
1825: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1826: p_count => x_msg_count,
1827: p_data => x_msg_data);

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

1821: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1822: fnd_message.set_token('ERROR' ,SQLERRM);
1823: fnd_msg_pub.add;
1824:
1825: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1826: p_count => x_msg_count,
1827: p_data => x_msg_data);
1828:
1829: -- Debug info.

Line 1922: FND_MSG_PUB.ADD;

1918: p_prefix=>l_debug_prefix,
1919: p_msg_level=>fnd_log.level_procedure);
1920: END IF;
1921: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
1922: FND_MSG_PUB.ADD;
1923: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1924: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CODE_ASSIGNMENTS');
1925: FND_MSG_PUB.ADD;
1926: RAISE FND_API.G_EXC_ERROR;

Line 1925: FND_MSG_PUB.ADD;

1921: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
1922: FND_MSG_PUB.ADD;
1923: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1924: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CODE_ASSIGNMENTS');
1925: FND_MSG_PUB.ADD;
1926: RAISE FND_API.G_EXC_ERROR;
1927: END IF;
1928:
1929: IF(l_ovn IS NULL) THEN

Line 1982: FND_MSG_PUB.ADD;

1978: WHEN fnd_api.g_exc_error THEN
1979: ROLLBACK TO save_classifications_pvt;
1980: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
1981: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CODE_ASSIGNMENTS');
1982: FND_MSG_PUB.ADD;
1983:
1984: x_return_status := fnd_api.g_ret_sts_error;
1985:
1986: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

1982: FND_MSG_PUB.ADD;
1983:
1984: x_return_status := fnd_api.g_ret_sts_error;
1985:
1986: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1987: p_count => x_msg_count,
1988: p_data => x_msg_data);
1989:
1990: -- Debug info.

Line 2006: FND_MSG_PUB.ADD;

2002: WHEN fnd_api.g_exc_unexpected_error THEN
2003: ROLLBACK TO save_classifications_pvt;
2004: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2005: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CODE_ASSIGNMENTS');
2006: FND_MSG_PUB.ADD;
2007:
2008: x_return_status := fnd_api.g_ret_sts_unexp_error;
2009:
2010: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

2006: FND_MSG_PUB.ADD;
2007:
2008: x_return_status := fnd_api.g_ret_sts_unexp_error;
2009:
2010: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2011: p_count => x_msg_count,
2012: p_data => x_msg_data);
2013:
2014: -- Debug info.

Line 2030: FND_MSG_PUB.ADD;

2026: WHEN OTHERS THEN
2027: ROLLBACK TO save_classifications_pvt;
2028: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2029: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CODE_ASSIGNMENTS');
2030: FND_MSG_PUB.ADD;
2031:
2032: x_return_status := fnd_api.g_ret_sts_unexp_error;
2033:
2034: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

Line 2036: fnd_msg_pub.add;

2032: x_return_status := fnd_api.g_ret_sts_unexp_error;
2033:
2034: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2035: fnd_message.set_token('ERROR' ,SQLERRM);
2036: fnd_msg_pub.add;
2037:
2038: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2039: p_count => x_msg_count,
2040: p_data => x_msg_data);

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

2034: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2035: fnd_message.set_token('ERROR' ,SQLERRM);
2036: fnd_msg_pub.add;
2037:
2038: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2039: p_count => x_msg_count,
2040: p_data => x_msg_data);
2041:
2042: -- Debug info.

Line 2153: FND_MSG_PUB.ADD;

2149: WHEN fnd_api.g_exc_error THEN
2150: ROLLBACK TO create_certifications_pvt;
2151: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2152: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CERTIFICATIONS');
2153: FND_MSG_PUB.ADD;
2154:
2155: x_return_status := fnd_api.g_ret_sts_error;
2156:
2157: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

2153: FND_MSG_PUB.ADD;
2154:
2155: x_return_status := fnd_api.g_ret_sts_error;
2156:
2157: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2158: p_count => x_msg_count,
2159: p_data => x_msg_data);
2160:
2161: -- Debug info.

Line 2177: FND_MSG_PUB.ADD;

2173: WHEN fnd_api.g_exc_unexpected_error THEN
2174: ROLLBACK TO create_certifications_pvt;
2175: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2176: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CERTIFICATIONS');
2177: FND_MSG_PUB.ADD;
2178:
2179: x_return_status := fnd_api.g_ret_sts_unexp_error;
2180:
2181: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

2177: FND_MSG_PUB.ADD;
2178:
2179: x_return_status := fnd_api.g_ret_sts_unexp_error;
2180:
2181: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2182: p_count => x_msg_count,
2183: p_data => x_msg_data);
2184:
2185: -- Debug info.

Line 2202: FND_MSG_PUB.ADD;

2198: WHEN OTHERS THEN
2199: ROLLBACK TO create_certifications_pvt;
2200: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2201: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CERTIFICATIONS');
2202: FND_MSG_PUB.ADD;
2203:
2204: x_return_status := fnd_api.g_ret_sts_unexp_error;
2205:
2206: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

Line 2208: fnd_msg_pub.add;

2204: x_return_status := fnd_api.g_ret_sts_unexp_error;
2205:
2206: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2207: fnd_message.set_token('ERROR' ,SQLERRM);
2208: fnd_msg_pub.add;
2209:
2210: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2211: p_count => x_msg_count,
2212: p_data => x_msg_data);

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

2206: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2207: fnd_message.set_token('ERROR' ,SQLERRM);
2208: fnd_msg_pub.add;
2209:
2210: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2211: p_count => x_msg_count,
2212: p_data => x_msg_data);
2213:
2214: -- Debug info.

Line 2303: FND_MSG_PUB.ADD;

2299: p_prefix=>l_debug_prefix,
2300: p_msg_level=>fnd_log.level_procedure);
2301: END IF;
2302: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
2303: FND_MSG_PUB.ADD;
2304: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2305: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CERTIFICATIONS');
2306: FND_MSG_PUB.ADD;
2307: RAISE FND_API.G_EXC_ERROR;

Line 2306: FND_MSG_PUB.ADD;

2302: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
2303: FND_MSG_PUB.ADD;
2304: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2305: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CERTIFICATIONS');
2306: FND_MSG_PUB.ADD;
2307: RAISE FND_API.G_EXC_ERROR;
2308: END IF;
2309:
2310: IF(l_lud IS NULL) THEN

Line 2363: FND_MSG_PUB.ADD;

2359: WHEN fnd_api.g_exc_error THEN
2360: ROLLBACK TO save_certifications_pvt;
2361: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2362: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CERTIFICATIONS');
2363: FND_MSG_PUB.ADD;
2364:
2365: x_return_status := fnd_api.g_ret_sts_error;
2366:
2367: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

2363: FND_MSG_PUB.ADD;
2364:
2365: x_return_status := fnd_api.g_ret_sts_error;
2366:
2367: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2368: p_count => x_msg_count,
2369: p_data => x_msg_data);
2370:
2371: -- Debug info.

Line 2387: FND_MSG_PUB.ADD;

2383: WHEN fnd_api.g_exc_unexpected_error THEN
2384: ROLLBACK TO save_certifications_pvt;
2385: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2386: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CERTIFICATIONS');
2387: FND_MSG_PUB.ADD;
2388:
2389: x_return_status := fnd_api.g_ret_sts_unexp_error;
2390:
2391: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

2387: FND_MSG_PUB.ADD;
2388:
2389: x_return_status := fnd_api.g_ret_sts_unexp_error;
2390:
2391: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2392: p_count => x_msg_count,
2393: p_data => x_msg_data);
2394:
2395: -- Debug info.

Line 2411: FND_MSG_PUB.ADD;

2407: WHEN OTHERS THEN
2408: ROLLBACK TO save_certifications_pvt;
2409: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2410: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_CERTIFICATIONS');
2411: FND_MSG_PUB.ADD;
2412:
2413: x_return_status := fnd_api.g_ret_sts_unexp_error;
2414:
2415: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

Line 2417: fnd_msg_pub.add;

2413: x_return_status := fnd_api.g_ret_sts_unexp_error;
2414:
2415: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2416: fnd_message.set_token('ERROR' ,SQLERRM);
2417: fnd_msg_pub.add;
2418:
2419: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2420: p_count => x_msg_count,
2421: p_data => x_msg_data);

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

2415: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2416: fnd_message.set_token('ERROR' ,SQLERRM);
2417: fnd_msg_pub.add;
2418:
2419: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2420: p_count => x_msg_count,
2421: p_data => x_msg_data);
2422:
2423: -- Debug info.

Line 2534: FND_MSG_PUB.ADD;

2530: WHEN fnd_api.g_exc_error THEN
2531: ROLLBACK TO create_financial_profiles_pvt;
2532: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2533: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_FINANCIAL_PROFILE');
2534: FND_MSG_PUB.ADD;
2535:
2536: x_return_status := fnd_api.g_ret_sts_error;
2537:
2538: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

2534: FND_MSG_PUB.ADD;
2535:
2536: x_return_status := fnd_api.g_ret_sts_error;
2537:
2538: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2539: p_count => x_msg_count,
2540: p_data => x_msg_data);
2541:
2542: -- Debug info.

Line 2558: FND_MSG_PUB.ADD;

2554: WHEN fnd_api.g_exc_unexpected_error THEN
2555: ROLLBACK TO create_financial_profiles_pvt;
2556: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2557: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_FINANCIAL_PROFILE');
2558: FND_MSG_PUB.ADD;
2559:
2560: x_return_status := fnd_api.g_ret_sts_unexp_error;
2561:
2562: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

2558: FND_MSG_PUB.ADD;
2559:
2560: x_return_status := fnd_api.g_ret_sts_unexp_error;
2561:
2562: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2563: p_count => x_msg_count,
2564: p_data => x_msg_data);
2565:
2566: -- Debug info.

Line 2583: FND_MSG_PUB.ADD;

2579: WHEN OTHERS THEN
2580: ROLLBACK TO create_financial_profiles_pvt;
2581: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2582: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_FINANCIAL_PROFILE');
2583: FND_MSG_PUB.ADD;
2584:
2585: x_return_status := fnd_api.g_ret_sts_unexp_error;
2586:
2587: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

Line 2589: fnd_msg_pub.add;

2585: x_return_status := fnd_api.g_ret_sts_unexp_error;
2586:
2587: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2588: fnd_message.set_token('ERROR' ,SQLERRM);
2589: fnd_msg_pub.add;
2590:
2591: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2592: p_count => x_msg_count,
2593: p_data => x_msg_data);

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

2587: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2588: fnd_message.set_token('ERROR' ,SQLERRM);
2589: fnd_msg_pub.add;
2590:
2591: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2592: p_count => x_msg_count,
2593: p_data => x_msg_data);
2594:
2595: -- Debug info.

Line 2683: FND_MSG_PUB.ADD;

2679: p_prefix=>l_debug_prefix,
2680: p_msg_level=>fnd_log.level_procedure);
2681: END IF;
2682: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
2683: FND_MSG_PUB.ADD;
2684: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2685: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_FINANCIAL_PROFILE');
2686: FND_MSG_PUB.ADD;
2687: RAISE FND_API.G_EXC_ERROR;

Line 2686: FND_MSG_PUB.ADD;

2682: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
2683: FND_MSG_PUB.ADD;
2684: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2685: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_FINANCIAL_PROFILE');
2686: FND_MSG_PUB.ADD;
2687: RAISE FND_API.G_EXC_ERROR;
2688: END IF;
2689:
2690: IF(l_lud IS NULL) THEN

Line 2743: FND_MSG_PUB.ADD;

2739: WHEN fnd_api.g_exc_error THEN
2740: ROLLBACK TO save_financial_profiles_pvt;
2741: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2742: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_FINANCIAL_PROFILE');
2743: FND_MSG_PUB.ADD;
2744:
2745: x_return_status := fnd_api.g_ret_sts_error;
2746:
2747: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

2743: FND_MSG_PUB.ADD;
2744:
2745: x_return_status := fnd_api.g_ret_sts_error;
2746:
2747: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2748: p_count => x_msg_count,
2749: p_data => x_msg_data);
2750:
2751: -- Debug info.

Line 2767: FND_MSG_PUB.ADD;

2763: WHEN fnd_api.g_exc_unexpected_error THEN
2764: ROLLBACK TO save_financial_profiles_pvt;
2765: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2766: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_FINANCIAL_PROFILE');
2767: FND_MSG_PUB.ADD;
2768:
2769: x_return_status := fnd_api.g_ret_sts_unexp_error;
2770:
2771: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

2767: FND_MSG_PUB.ADD;
2768:
2769: x_return_status := fnd_api.g_ret_sts_unexp_error;
2770:
2771: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2772: p_count => x_msg_count,
2773: p_data => x_msg_data);
2774:
2775: -- Debug info.

Line 2791: FND_MSG_PUB.ADD;

2787: WHEN OTHERS THEN
2788: ROLLBACK TO save_financial_profiles_pvt;
2789: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2790: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_FINANCIAL_PROFILE');
2791: FND_MSG_PUB.ADD;
2792:
2793: x_return_status := fnd_api.g_ret_sts_unexp_error;
2794:
2795: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

Line 2797: fnd_msg_pub.add;

2793: x_return_status := fnd_api.g_ret_sts_unexp_error;
2794:
2795: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2796: fnd_message.set_token('ERROR' ,SQLERRM);
2797: fnd_msg_pub.add;
2798:
2799: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2800: p_count => x_msg_count,
2801: p_data => x_msg_data);

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

2795: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2796: fnd_message.set_token('ERROR' ,SQLERRM);
2797: fnd_msg_pub.add;
2798:
2799: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2800: p_count => x_msg_count,
2801: p_data => x_msg_data);
2802:
2803: -- Debug info.

Line 2924: FND_MSG_PUB.ADD;

2920: WHEN fnd_api.g_exc_error THEN
2921: ROLLBACK TO save_party_preferences_pvt;
2922: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2923: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PARTY_PREFERENCES');
2924: FND_MSG_PUB.ADD;
2925:
2926: x_return_status := fnd_api.g_ret_sts_error;
2927:
2928: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

2924: FND_MSG_PUB.ADD;
2925:
2926: x_return_status := fnd_api.g_ret_sts_error;
2927:
2928: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2929: p_count => x_msg_count,
2930: p_data => x_msg_data);
2931:
2932: -- Debug info.

Line 2948: FND_MSG_PUB.ADD;

2944: WHEN fnd_api.g_exc_unexpected_error THEN
2945: ROLLBACK TO save_party_preferences_pvt;
2946: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2947: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PARTY_PREFERENCES');
2948: FND_MSG_PUB.ADD;
2949:
2950: x_return_status := fnd_api.g_ret_sts_unexp_error;
2951:
2952: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

2948: FND_MSG_PUB.ADD;
2949:
2950: x_return_status := fnd_api.g_ret_sts_unexp_error;
2951:
2952: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2953: p_count => x_msg_count,
2954: p_data => x_msg_data);
2955:
2956: -- Debug info.

Line 2972: FND_MSG_PUB.ADD;

2968: WHEN OTHERS THEN
2969: ROLLBACK TO save_party_preferences_pvt;
2970: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
2971: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PARTY_PREFERENCES');
2972: FND_MSG_PUB.ADD;
2973:
2974: x_return_status := fnd_api.g_ret_sts_unexp_error;
2975:
2976: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

Line 2978: fnd_msg_pub.add;

2974: x_return_status := fnd_api.g_ret_sts_unexp_error;
2975:
2976: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2977: fnd_message.set_token('ERROR' ,SQLERRM);
2978: fnd_msg_pub.add;
2979:
2980: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2981: p_count => x_msg_count,
2982: p_data => x_msg_data);

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

2976: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2977: fnd_message.set_token('ERROR' ,SQLERRM);
2978: fnd_msg_pub.add;
2979:
2980: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2981: p_count => x_msg_count,
2982: p_data => x_msg_data);
2983:
2984: -- Debug info.

Line 3149: FND_MSG_PUB.ADD;

3145: WHEN fnd_api.g_exc_error THEN
3146: ROLLBACK TO create_party_usage_assgmnt_pvt;
3147: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
3148: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PARTY_USAGE_ASSIGNMENTS');
3149: FND_MSG_PUB.ADD;
3150:
3151: x_return_status := fnd_api.g_ret_sts_error;
3152:
3153: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

3149: FND_MSG_PUB.ADD;
3150:
3151: x_return_status := fnd_api.g_ret_sts_error;
3152:
3153: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3154: p_count => x_msg_count,
3155: p_data => x_msg_data);
3156:
3157: -- Debug info.

Line 3173: FND_MSG_PUB.ADD;

3169: WHEN fnd_api.g_exc_unexpected_error THEN
3170: ROLLBACK TO create_party_usage_assgmnt_pvt;
3171: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
3172: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PARTY_USAGE_ASSIGNMENTS');
3173: FND_MSG_PUB.ADD;
3174:
3175: x_return_status := fnd_api.g_ret_sts_unexp_error;
3176:
3177: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

3173: FND_MSG_PUB.ADD;
3174:
3175: x_return_status := fnd_api.g_ret_sts_unexp_error;
3176:
3177: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3178: p_count => x_msg_count,
3179: p_data => x_msg_data);
3180:
3181: -- Debug info.

Line 3198: FND_MSG_PUB.ADD;

3194: WHEN OTHERS THEN
3195: ROLLBACK TO create_party_usage_assgmnt_pvt;
3196: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
3197: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PARTY_USAGE_ASSIGNMENTS');
3198: FND_MSG_PUB.ADD;
3199:
3200: x_return_status := fnd_api.g_ret_sts_unexp_error;
3201:
3202: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

Line 3204: fnd_msg_pub.add;

3200: x_return_status := fnd_api.g_ret_sts_unexp_error;
3201:
3202: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3203: fnd_message.set_token('ERROR' ,SQLERRM);
3204: fnd_msg_pub.add;
3205:
3206: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3207: p_count => x_msg_count,
3208: p_data => x_msg_data);

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

3202: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3203: fnd_message.set_token('ERROR' ,SQLERRM);
3204: fnd_msg_pub.add;
3205:
3206: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3207: p_count => x_msg_count,
3208: p_data => x_msg_data);
3209:
3210: -- Debug info.

Line 3299: FND_MSG_PUB.ADD;

3295: p_prefix=>l_debug_prefix,
3296: p_msg_level=>fnd_log.level_procedure);
3297: END IF;
3298: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
3299: FND_MSG_PUB.ADD;
3300: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
3301: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PARTY_USAGE_ASSIGNMENTS');
3302: FND_MSG_PUB.ADD;
3303: RAISE FND_API.G_EXC_ERROR;

Line 3302: FND_MSG_PUB.ADD;

3298: FND_MESSAGE.SET_NAME('AR', 'HZ_API_INVALID_ID');
3299: FND_MSG_PUB.ADD;
3300: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
3301: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PARTY_USAGE_ASSIGNMENTS');
3302: FND_MSG_PUB.ADD;
3303: RAISE FND_API.G_EXC_ERROR;
3304: END IF;
3305:
3306: IF(l_lud IS NULL) THEN

Line 3351: FND_MSG_PUB.ADD;

3347: WHEN fnd_api.g_exc_error THEN
3348: ROLLBACK TO save_party_usage_assgmnt_pvt;
3349: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
3350: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PARTY_USAGE_ASSIGNMENTS');
3351: FND_MSG_PUB.ADD;
3352:
3353: x_return_status := fnd_api.g_ret_sts_error;
3354:
3355: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

3351: FND_MSG_PUB.ADD;
3352:
3353: x_return_status := fnd_api.g_ret_sts_error;
3354:
3355: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3356: p_count => x_msg_count,
3357: p_data => x_msg_data);
3358:
3359: -- Debug info.

Line 3375: FND_MSG_PUB.ADD;

3371: WHEN fnd_api.g_exc_unexpected_error THEN
3372: ROLLBACK TO save_party_usage_assgmnt_pvt;
3373: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
3374: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PARTY_USAGE_ASSIGNMENTS');
3375: FND_MSG_PUB.ADD;
3376:
3377: x_return_status := fnd_api.g_ret_sts_unexp_error;
3378:
3379: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

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

3375: FND_MSG_PUB.ADD;
3376:
3377: x_return_status := fnd_api.g_ret_sts_unexp_error;
3378:
3379: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3380: p_count => x_msg_count,
3381: p_data => x_msg_data);
3382:
3383: -- Debug info.

Line 3399: FND_MSG_PUB.ADD;

3395: WHEN OTHERS THEN
3396: ROLLBACK TO save_party_usage_assgmnt_pvt;
3397: FND_MESSAGE.SET_NAME('AR', 'HZ_API_PROPAGATE_ENTITY_ERROR');
3398: FND_MESSAGE.SET_TOKEN('ENTITY', 'HZ_PARTY_USAGE_ASSIGNMENTS');
3399: FND_MSG_PUB.ADD;
3400:
3401: x_return_status := fnd_api.g_ret_sts_unexp_error;
3402:
3403: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

Line 3405: fnd_msg_pub.add;

3401: x_return_status := fnd_api.g_ret_sts_unexp_error;
3402:
3403: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3404: fnd_message.set_token('ERROR' ,SQLERRM);
3405: fnd_msg_pub.add;
3406:
3407: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3408: p_count => x_msg_count,
3409: p_data => x_msg_data);

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

3403: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3404: fnd_message.set_token('ERROR' ,SQLERRM);
3405: fnd_msg_pub.add;
3406:
3407: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
3408: p_count => x_msg_count,
3409: p_data => x_msg_data);
3410:
3411: -- Debug info.

Line 3842: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP

3838: l_msg_data HZ_MESSAGE_OBJ_TBL;
3839: BEGIN
3840: l_msg_data := HZ_MESSAGE_OBJ_TBL();
3841: IF(x_msg_count > 1 AND x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3842: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
3843: l_msg_data.EXTEND;
3844: l_msg_data(I) := HZ_MESSAGE_OBJ(FND_MSG_PUB.Get(I, p_encoded => FND_API.G_FALSE));
3845: END LOOP;
3846: ELSE

Line 3844: l_msg_data(I) := HZ_MESSAGE_OBJ(FND_MSG_PUB.Get(I, p_encoded => FND_API.G_FALSE));

3840: l_msg_data := HZ_MESSAGE_OBJ_TBL();
3841: IF(x_msg_count > 1 AND x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3842: FOR I IN 1..FND_MSG_PUB.Count_Msg LOOP
3843: l_msg_data.EXTEND;
3844: l_msg_data(I) := HZ_MESSAGE_OBJ(FND_MSG_PUB.Get(I, p_encoded => FND_API.G_FALSE));
3845: END LOOP;
3846: ELSE
3847: l_msg_data.EXTEND;
3848: l_msg_data(1) := HZ_MESSAGE_OBJ(x_msg_data);