544: END IF;
545: EXCEPTION
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;
545: EXCEPTION
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:
568: p_msg_level=>fnd_log.level_procedure);
569: END IF;
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;
569: END IF;
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:
593: END IF;
594:
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;
594:
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:
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');
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,
600:
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,
795: END IF;
796: EXCEPTION
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;
796: EXCEPTION
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:
819: p_msg_level=>fnd_log.level_procedure);
820: END IF;
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;
820: END IF;
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:
844: END IF;
845:
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;
845:
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:
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');
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,
851:
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,
973: END IF;
974: EXCEPTION
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;
974: EXCEPTION
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:
997: p_msg_level=>fnd_log.level_procedure);
998: END IF;
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;
998: END IF;
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:
1022: END IF;
1023:
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;
1023:
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:
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');
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,
1029:
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,
1157: END IF;
1158: EXCEPTION
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;
1158: EXCEPTION
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:
1181: p_msg_level=>fnd_log.level_procedure);
1182: END IF;
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;
1182: END IF;
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:
1206: END IF;
1207:
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;
1207:
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:
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');
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,
1213:
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,
1367: END IF;
1368: EXCEPTION
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;
1368: EXCEPTION
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:
1391: p_msg_level=>fnd_log.level_procedure);
1392: END IF;
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;
1392: END IF;
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:
1416: END IF;
1417:
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;
1417:
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:
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');
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,
1423:
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,
1633:
1634: WHEN OTHERS THEN
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,
1634: WHEN OTHERS THEN
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,
1762: END IF;
1763: EXCEPTION
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;
1763: EXCEPTION
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:
1786: p_msg_level=>fnd_log.level_procedure);
1787: END IF;
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;
1787: END IF;
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:
1811: END IF;
1812:
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;
1812:
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:
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');
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,
1818:
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,
1917: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.check_code_assign_op, owner table name: '||p_owner_table_name||' owner table id: '||p_owner_table_id,
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;
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;
1927: END IF;
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;
1927: END IF;
1928:
1976: END IF;
1977: EXCEPTION
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;
1977: EXCEPTION
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:
2000: p_msg_level=>fnd_log.level_procedure);
2001: END IF;
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;
2001: END IF;
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:
2024: p_msg_level=>fnd_log.level_procedure);
2025: END IF;
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;
2025: END IF;
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:
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');
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,
2031:
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,
2147: END IF;
2148: EXCEPTION
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;
2148: EXCEPTION
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:
2171: p_msg_level=>fnd_log.level_procedure);
2172: END IF;
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;
2172: END IF;
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:
2196: END IF;
2197:
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;
2197:
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:
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');
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,
2203:
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,
2298: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.check_certification_op, party id: '||p_party_id,
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;
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;
2308: END IF;
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;
2308: END IF;
2309:
2357: END IF;
2358: EXCEPTION
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;
2358: EXCEPTION
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:
2381: p_msg_level=>fnd_log.level_procedure);
2382: END IF;
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;
2382: END IF;
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:
2405: p_msg_level=>fnd_log.level_procedure);
2406: END IF;
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;
2406: END IF;
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:
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');
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,
2412:
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,
2528: END IF;
2529: EXCEPTION
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;
2529: EXCEPTION
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:
2552: p_msg_level=>fnd_log.level_procedure);
2553: END IF;
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;
2553: END IF;
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:
2577: END IF;
2578:
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;
2578:
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:
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');
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,
2584:
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,
2678: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.check_financial_prof_op, financial profile id: '||l_fin_prof_rec.financial_profile_id||', party id: '||p_party_id,
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;
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;
2688: END IF;
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;
2688: END IF;
2689:
2737: END IF;
2738: EXCEPTION
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;
2738: EXCEPTION
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:
2761: p_msg_level=>fnd_log.level_procedure);
2762: END IF;
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;
2762: END IF;
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:
2785: p_msg_level=>fnd_log.level_procedure);
2786: END IF;
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;
2786: END IF;
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:
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');
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,
2792:
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,
2918: END IF;
2919: EXCEPTION
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;
2919: EXCEPTION
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:
2942: p_msg_level=>fnd_log.level_procedure);
2943: END IF;
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;
2943: END IF;
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:
2966: p_msg_level=>fnd_log.level_procedure);
2967: END IF;
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;
2967: END IF;
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:
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');
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,
2973:
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,
3143:
3144: EXCEPTION
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;
3144: EXCEPTION
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:
3167: p_msg_level=>fnd_log.level_procedure);
3168: END IF;
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;
3168: END IF;
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:
3192: END IF;
3193:
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;
3193:
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:
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');
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,
3199:
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,
3294: hz_utility_v2pub.debug(p_message=>'Error occurred at hz_party_bo_pvt.check_party_usage_op, party_usage_code ' || l_party_usg_rec.party_usage_code||', party id: '||p_party_id,
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;
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;
3304: END IF;
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;
3304: END IF;
3305:
3345: END IF;
3346: EXCEPTION
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;
3346: EXCEPTION
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:
3369: p_msg_level=>fnd_log.level_procedure);
3370: END IF;
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;
3370: END IF;
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:
3393: p_msg_level=>fnd_log.level_procedure);
3394: END IF;
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;
3394: END IF;
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:
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');
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,
3400:
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,