67:
68: END IF;
69: EXCEPTION
70: WHEN OTHERS THEN
71: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
72: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
73: FND_MSG_PUB.ADD;
74: ROLLBACK TO create_person_event;
75:
68: END IF;
69: EXCEPTION
70: WHEN OTHERS THEN
71: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
72: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
73: FND_MSG_PUB.ADD;
74: ROLLBACK TO create_person_event;
75:
76: END create_person_event;
132:
133: END IF;
134: EXCEPTION
135: WHEN OTHERS THEN
136: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
137: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
138: FND_MSG_PUB.ADD;
139: ROLLBACK TO update_person_event;
140:
133: END IF;
134: EXCEPTION
135: WHEN OTHERS THEN
136: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
137: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
138: FND_MSG_PUB.ADD;
139: ROLLBACK TO update_person_event;
140:
141: END update_person_event;
196:
197: END IF;
198: EXCEPTION
199: WHEN OTHERS THEN
200: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
201: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
202: FND_MSG_PUB.ADD;
203: ROLLBACK TO create_group_event;
204:
197: END IF;
198: EXCEPTION
199: WHEN OTHERS THEN
200: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
201: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
202: FND_MSG_PUB.ADD;
203: ROLLBACK TO create_group_event;
204:
205: END create_group_event;
261:
262: END IF;
263: EXCEPTION
264: WHEN OTHERS THEN
265: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
266: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
267: FND_MSG_PUB.ADD;
268: ROLLBACK TO update_group_event;
269:
262: END IF;
263: EXCEPTION
264: WHEN OTHERS THEN
265: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
266: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
267: FND_MSG_PUB.ADD;
268: ROLLBACK TO update_group_event;
269:
270: END update_group_event;
324:
325: END IF;
326: EXCEPTION
327: WHEN OTHERS THEN
328: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
329: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
330: FND_MSG_PUB.ADD;
331: ROLLBACK TO create_organization_event;
332:
325: END IF;
326: EXCEPTION
327: WHEN OTHERS THEN
328: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
329: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
330: FND_MSG_PUB.ADD;
331: ROLLBACK TO create_organization_event;
332:
333: END create_organization_event;
390:
391: END IF;
392: EXCEPTION
393: WHEN OTHERS THEN
394: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
395: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
396: FND_MSG_PUB.ADD;
397: ROLLBACK TO update_organization_event;
398:
391: END IF;
392: EXCEPTION
393: WHEN OTHERS THEN
394: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
395: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
396: FND_MSG_PUB.ADD;
397: ROLLBACK TO update_organization_event;
398:
399: END update_organization_event;
463:
464: END IF;
465: EXCEPTION
466: WHEN OTHERS THEN
467: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
468: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
469: FND_MSG_PUB.ADD;
470: ROLLBACK TO create_relationship_event;
471:
464: END IF;
465: EXCEPTION
466: WHEN OTHERS THEN
467: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
468: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
469: FND_MSG_PUB.ADD;
470: ROLLBACK TO create_relationship_event;
471:
472: END create_relationship_event;
530:
531: END IF;
532: EXCEPTION
533: WHEN OTHERS THEN
534: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
535: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
536: FND_MSG_PUB.ADD;
537: ROLLBACK TO update_relationship_event;
538:
531: END IF;
532: EXCEPTION
533: WHEN OTHERS THEN
534: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
535: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
536: FND_MSG_PUB.ADD;
537: ROLLBACK TO update_relationship_event;
538:
539: END update_relationship_event;
595:
596: END IF;
597: EXCEPTION
598: WHEN OTHERS THEN
599: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
600: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
601: FND_MSG_PUB.ADD;
602: ROLLBACK TO create_party_site_event;
603: END create_party_site_event;
596: END IF;
597: EXCEPTION
598: WHEN OTHERS THEN
599: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
600: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
601: FND_MSG_PUB.ADD;
602: ROLLBACK TO create_party_site_event;
603: END create_party_site_event;
604:
661:
662: END IF;
663: EXCEPTION
664: WHEN OTHERS THEN
665: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
666: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
667: FND_MSG_PUB.ADD;
668: ROLLBACK TO update_party_site_event;
669:
662: END IF;
663: EXCEPTION
664: WHEN OTHERS THEN
665: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
666: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
667: FND_MSG_PUB.ADD;
668: ROLLBACK TO update_party_site_event;
669:
670: END update_party_site_event;
725:
726: END IF;
727: EXCEPTION
728: WHEN OTHERS THEN
729: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
730: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
731: FND_MSG_PUB.ADD;
732: ROLLBACK TO create_party_site_use_event;
733:
726: END IF;
727: EXCEPTION
728: WHEN OTHERS THEN
729: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
730: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
731: FND_MSG_PUB.ADD;
732: ROLLBACK TO create_party_site_use_event;
733:
734: END create_party_site_use_event;
791:
792: END IF;
793: EXCEPTION
794: WHEN OTHERS THEN
795: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
796: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
797: FND_MSG_PUB.ADD;
798: ROLLBACK TO update_party_site_use_event;
799:
792: END IF;
793: EXCEPTION
794: WHEN OTHERS THEN
795: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
796: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
797: FND_MSG_PUB.ADD;
798: ROLLBACK TO update_party_site_use_event;
799:
800: END update_party_site_use_event;
856:
857: END IF;
858: EXCEPTION
859: WHEN OTHERS THEN
860: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
861: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
862: FND_MSG_PUB.ADD;
863: ROLLBACK TO create_org_contact_event;
864:
857: END IF;
858: EXCEPTION
859: WHEN OTHERS THEN
860: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
861: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
862: FND_MSG_PUB.ADD;
863: ROLLBACK TO create_org_contact_event;
864:
865: END create_org_contact_event;
923:
924: END IF;
925: EXCEPTION
926: WHEN OTHERS THEN
927: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
928: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
929: FND_MSG_PUB.ADD;
930: ROLLBACK TO update_org_contact_event;
931:
924: END IF;
925: EXCEPTION
926: WHEN OTHERS THEN
927: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
928: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
929: FND_MSG_PUB.ADD;
930: ROLLBACK TO update_org_contact_event;
931:
932: END update_org_contact_event;
986:
987: END IF;
988: EXCEPTION
989: WHEN OTHERS THEN
990: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
991: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
992: FND_MSG_PUB.ADD;
993: ROLLBACK TO create_org_contact_role_event;
994:
987: END IF;
988: EXCEPTION
989: WHEN OTHERS THEN
990: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
991: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
992: FND_MSG_PUB.ADD;
993: ROLLBACK TO create_org_contact_role_event;
994:
995: END create_org_contact_role_event;
1052:
1053: END IF;
1054: EXCEPTION
1055: WHEN OTHERS THEN
1056: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1057: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1058: FND_MSG_PUB.ADD;
1059: ROLLBACK TO update_org_contact_role_event;
1060:
1053: END IF;
1054: EXCEPTION
1055: WHEN OTHERS THEN
1056: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1057: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1058: FND_MSG_PUB.ADD;
1059: ROLLBACK TO update_org_contact_role_event;
1060:
1061: END update_org_contact_role_event;
1117:
1118: END IF;
1119: EXCEPTION
1120: WHEN OTHERS THEN
1121: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1122: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1123: FND_MSG_PUB.ADD;
1124: ROLLBACK TO create_location_event;
1125:
1118: END IF;
1119: EXCEPTION
1120: WHEN OTHERS THEN
1121: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1122: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1123: FND_MSG_PUB.ADD;
1124: ROLLBACK TO create_location_event;
1125:
1126: END create_location_event;
1184:
1185: END IF;
1186: EXCEPTION
1187: WHEN OTHERS THEN
1188: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1189: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1190: FND_MSG_PUB.ADD;
1191: ROLLBACK TO update_location_event;
1192:
1185: END IF;
1186: EXCEPTION
1187: WHEN OTHERS THEN
1188: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
1189: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
1190: FND_MSG_PUB.ADD;
1191: ROLLBACK TO update_location_event;
1192:
1193: END update_location_event;
1266:
1267: END IF;
1268: EXCEPTION
1269: WHEN OTHERS THEN
1270: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1271: fnd_message.set_token('ERROR', SQLERRM);
1272: fnd_msg_pub.add;
1273: ROLLBACK TO create_contact_point_event;
1274: END create_contact_point_event;
1267: END IF;
1268: EXCEPTION
1269: WHEN OTHERS THEN
1270: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1271: fnd_message.set_token('ERROR', SQLERRM);
1272: fnd_msg_pub.add;
1273: ROLLBACK TO create_contact_point_event;
1274: END create_contact_point_event;
1275:
1361:
1362: END IF;
1363: EXCEPTION
1364: WHEN OTHERS THEN
1365: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1366: fnd_message.set_token('ERROR', SQLERRM);
1367: fnd_msg_pub.add;
1368: ROLLBACK TO update_contact_point_event;
1369: END update_contact_point_event;
1362: END IF;
1363: EXCEPTION
1364: WHEN OTHERS THEN
1365: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1366: fnd_message.set_token('ERROR', SQLERRM);
1367: fnd_msg_pub.add;
1368: ROLLBACK TO update_contact_point_event;
1369: END update_contact_point_event;
1370:
1424:
1425: END IF;
1426: EXCEPTION
1427: WHEN OTHERS THEN
1428: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1429: fnd_message.set_token('ERROR' ,SQLERRM);
1430: fnd_msg_pub.add;
1431: ROLLBACK TO create_contact_prefer_event;
1432:
1425: END IF;
1426: EXCEPTION
1427: WHEN OTHERS THEN
1428: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1429: fnd_message.set_token('ERROR' ,SQLERRM);
1430: fnd_msg_pub.add;
1431: ROLLBACK TO create_contact_prefer_event;
1432:
1433: END create_contact_prefer_event;
1490:
1491: END IF;
1492: EXCEPTION
1493: WHEN OTHERS THEN
1494: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1495: fnd_message.set_token('ERROR' ,SQLERRM);
1496: fnd_msg_pub.add;
1497: ROLLBACK TO update_contact_prefer_event;
1498:
1491: END IF;
1492: EXCEPTION
1493: WHEN OTHERS THEN
1494: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1495: fnd_message.set_token('ERROR' ,SQLERRM);
1496: fnd_msg_pub.add;
1497: ROLLBACK TO update_contact_prefer_event;
1498:
1499: END update_contact_prefer_event;
1576:
1577: END IF;
1578: EXCEPTION
1579: WHEN OTHERS THEN
1580: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1581: fnd_message.set_token('ERROR' ,SQLERRM);
1582: fnd_msg_pub.add;
1583: ROLLBACK TO create_cust_account_event;
1584:
1577: END IF;
1578: EXCEPTION
1579: WHEN OTHERS THEN
1580: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1581: fnd_message.set_token('ERROR' ,SQLERRM);
1582: fnd_msg_pub.add;
1583: ROLLBACK TO create_cust_account_event;
1584:
1585: END create_cust_account_event;
1660:
1661: END IF;
1662: EXCEPTION
1663: WHEN OTHERS THEN
1664: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1665: fnd_message.set_token('ERROR' ,SQLERRM);
1666: fnd_msg_pub.add;
1667: ROLLBACK TO create_cust_account_event;
1668:
1661: END IF;
1662: EXCEPTION
1663: WHEN OTHERS THEN
1664: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1665: fnd_message.set_token('ERROR' ,SQLERRM);
1666: fnd_msg_pub.add;
1667: ROLLBACK TO create_cust_account_event;
1668:
1669: END create_cust_account_event;
1726:
1727: END IF;
1728: EXCEPTION
1729: WHEN OTHERS THEN
1730: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1731: fnd_message.set_token('ERROR' ,SQLERRM);
1732: fnd_msg_pub.add;
1733: ROLLBACK TO update_cust_account_event;
1734:
1727: END IF;
1728: EXCEPTION
1729: WHEN OTHERS THEN
1730: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1731: fnd_message.set_token('ERROR' ,SQLERRM);
1732: fnd_msg_pub.add;
1733: ROLLBACK TO update_cust_account_event;
1734:
1735: END update_cust_account_event;
1795:
1796: END IF;
1797: EXCEPTION
1798: WHEN OTHERS THEN
1799: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1800: fnd_message.set_token('ERROR' ,SQLERRM);
1801: fnd_msg_pub.add;
1802: ROLLBACK TO create_cust_acct_relate_event;
1803:
1796: END IF;
1797: EXCEPTION
1798: WHEN OTHERS THEN
1799: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1800: fnd_message.set_token('ERROR' ,SQLERRM);
1801: fnd_msg_pub.add;
1802: ROLLBACK TO create_cust_acct_relate_event;
1803:
1804: END create_cust_acct_relate_event;
1868:
1869: END IF;
1870: EXCEPTION
1871: WHEN OTHERS THEN
1872: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1873: fnd_message.set_token('ERROR' ,SQLERRM);
1874: fnd_msg_pub.add;
1875: ROLLBACK TO update_cust_acct_relate_event;
1876:
1869: END IF;
1870: EXCEPTION
1871: WHEN OTHERS THEN
1872: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1873: fnd_message.set_token('ERROR' ,SQLERRM);
1874: fnd_msg_pub.add;
1875: ROLLBACK TO update_cust_acct_relate_event;
1876:
1877: END update_cust_acct_relate_event;
1940:
1941: END IF;
1942: EXCEPTION
1943: WHEN OTHERS THEN
1944: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1945: fnd_message.set_token('ERROR' ,SQLERRM);
1946: fnd_msg_pub.add;
1947: ROLLBACK TO create_customer_profile_event;
1948:
1941: END IF;
1942: EXCEPTION
1943: WHEN OTHERS THEN
1944: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
1945: fnd_message.set_token('ERROR' ,SQLERRM);
1946: fnd_msg_pub.add;
1947: ROLLBACK TO create_customer_profile_event;
1948:
1949: END create_customer_profile_event;
2006:
2007: END IF;
2008: EXCEPTION
2009: WHEN OTHERS THEN
2010: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2011: fnd_message.set_token('ERROR' ,SQLERRM);
2012: fnd_msg_pub.add;
2013: ROLLBACK TO update_customer_profile_event;
2014:
2007: END IF;
2008: EXCEPTION
2009: WHEN OTHERS THEN
2010: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2011: fnd_message.set_token('ERROR' ,SQLERRM);
2012: fnd_msg_pub.add;
2013: ROLLBACK TO update_customer_profile_event;
2014:
2015: END update_customer_profile_event;
2069:
2070: END IF;
2071: EXCEPTION
2072: WHEN OTHERS THEN
2073: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2074: fnd_message.set_token('ERROR' ,SQLERRM);
2075: fnd_msg_pub.add;
2076: ROLLBACK TO create_cust_profile_amt_event;
2077:
2070: END IF;
2071: EXCEPTION
2072: WHEN OTHERS THEN
2073: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2074: fnd_message.set_token('ERROR' ,SQLERRM);
2075: fnd_msg_pub.add;
2076: ROLLBACK TO create_cust_profile_amt_event;
2077:
2078:
2134:
2135: END IF;
2136: EXCEPTION
2137: WHEN OTHERS THEN
2138: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2139: fnd_message.set_token('ERROR' ,SQLERRM);
2140: fnd_msg_pub.add;
2141: ROLLBACK TO update_cust_profile_amt_event;
2142:
2135: END IF;
2136: EXCEPTION
2137: WHEN OTHERS THEN
2138: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2139: fnd_message.set_token('ERROR' ,SQLERRM);
2140: fnd_msg_pub.add;
2141: ROLLBACK TO update_cust_profile_amt_event;
2142:
2143: END update_cust_profile_amt_event;
2201:
2202: END IF;
2203: EXCEPTION
2204: WHEN OTHERS THEN
2205: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2206: fnd_message.set_token('ERROR' ,SQLERRM);
2207: fnd_msg_pub.add;
2208: ROLLBACK TO create_cust_acct_site_event;
2209:
2202: END IF;
2203: EXCEPTION
2204: WHEN OTHERS THEN
2205: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2206: fnd_message.set_token('ERROR' ,SQLERRM);
2207: fnd_msg_pub.add;
2208: ROLLBACK TO create_cust_acct_site_event;
2209:
2210: END create_cust_acct_site_event;
2268:
2269: END IF;
2270: EXCEPTION
2271: WHEN OTHERS THEN
2272: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2273: fnd_message.set_token('ERROR' ,SQLERRM);
2274: fnd_msg_pub.add;
2275: ROLLBACK TO update_cust_acct_site_event;
2276:
2269: END IF;
2270: EXCEPTION
2271: WHEN OTHERS THEN
2272: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2273: fnd_message.set_token('ERROR' ,SQLERRM);
2274: fnd_msg_pub.add;
2275: ROLLBACK TO update_cust_acct_site_event;
2276:
2277: END update_cust_acct_site_event;
2354:
2355: END IF;
2356: EXCEPTION
2357: WHEN OTHERS THEN
2358: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2359: fnd_message.set_token('ERROR' ,SQLERRM);
2360: fnd_msg_pub.add;
2361: ROLLBACK TO create_cust_site_use_event;
2362:
2355: END IF;
2356: EXCEPTION
2357: WHEN OTHERS THEN
2358: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2359: fnd_message.set_token('ERROR' ,SQLERRM);
2360: fnd_msg_pub.add;
2361: ROLLBACK TO create_cust_site_use_event;
2362:
2363: END create_cust_site_use_event;
2421:
2422: END IF;
2423: EXCEPTION
2424: WHEN OTHERS THEN
2425: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2426: fnd_message.set_token('ERROR' ,SQLERRM);
2427: fnd_msg_pub.add;
2428: ROLLBACK TO update_cust_site_use_event;
2429:
2422: END IF;
2423: EXCEPTION
2424: WHEN OTHERS THEN
2425: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2426: fnd_message.set_token('ERROR' ,SQLERRM);
2427: fnd_msg_pub.add;
2428: ROLLBACK TO update_cust_site_use_event;
2429:
2430: END update_cust_site_use_event;
2486:
2487: END IF;
2488: EXCEPTION
2489: WHEN OTHERS THEN
2490: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2491: fnd_message.set_token('ERROR' ,SQLERRM);
2492: fnd_msg_pub.add;
2493: ROLLBACK TO create_cust_account_role_event;
2494:
2487: END IF;
2488: EXCEPTION
2489: WHEN OTHERS THEN
2490: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2491: fnd_message.set_token('ERROR' ,SQLERRM);
2492: fnd_msg_pub.add;
2493: ROLLBACK TO create_cust_account_role_event;
2494:
2495: END create_cust_account_role_event;
2552:
2553: END IF;
2554: EXCEPTION
2555: WHEN OTHERS THEN
2556: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2557: fnd_message.set_token('ERROR' ,SQLERRM);
2558: fnd_msg_pub.add;
2559: ROLLBACK TO update_cust_account_role_event;
2560:
2553: END IF;
2554: EXCEPTION
2555: WHEN OTHERS THEN
2556: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2557: fnd_message.set_token('ERROR' ,SQLERRM);
2558: fnd_msg_pub.add;
2559: ROLLBACK TO update_cust_account_role_event;
2560:
2561: END update_cust_account_role_event;
2615:
2616: END IF;
2617: EXCEPTION
2618: WHEN OTHERS THEN
2619: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2620: fnd_message.set_token('ERROR' ,SQLERRM);
2621: fnd_msg_pub.add;
2622: ROLLBACK TO create_role_resp_event;
2623:
2616: END IF;
2617: EXCEPTION
2618: WHEN OTHERS THEN
2619: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2620: fnd_message.set_token('ERROR' ,SQLERRM);
2621: fnd_msg_pub.add;
2622: ROLLBACK TO create_role_resp_event;
2623:
2624: END create_role_resp_event;
2681:
2682: END IF;
2683: EXCEPTION
2684: WHEN OTHERS THEN
2685: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2686: fnd_message.set_token('ERROR' ,SQLERRM);
2687: fnd_msg_pub.add;
2688: ROLLBACK TO update_role_resp_event;
2689:
2682: END IF;
2683: EXCEPTION
2684: WHEN OTHERS THEN
2685: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2686: fnd_message.set_token('ERROR' ,SQLERRM);
2687: fnd_msg_pub.add;
2688: ROLLBACK TO update_role_resp_event;
2689:
2690: END update_role_resp_event;
2746:
2747: END IF;
2748: EXCEPTION
2749: WHEN OTHERS THEN
2750: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2751: fnd_message.set_token('ERROR' ,SQLERRM);
2752: fnd_msg_pub.add;
2753: ROLLBACK TO create_class_category_event;
2754:
2747: END IF;
2748: EXCEPTION
2749: WHEN OTHERS THEN
2750: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2751: fnd_message.set_token('ERROR' ,SQLERRM);
2752: fnd_msg_pub.add;
2753: ROLLBACK TO create_class_category_event;
2754:
2755: END create_class_category_event;
2812:
2813: END IF;
2814: EXCEPTION
2815: WHEN OTHERS THEN
2816: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2817: fnd_message.set_token('ERROR' ,SQLERRM);
2818: fnd_msg_pub.add;
2819: ROLLBACK TO update_class_category_event;
2820:
2813: END IF;
2814: EXCEPTION
2815: WHEN OTHERS THEN
2816: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2817: fnd_message.set_token('ERROR' ,SQLERRM);
2818: fnd_msg_pub.add;
2819: ROLLBACK TO update_class_category_event;
2820:
2821: END update_class_category_event;
2871:
2872: END IF;
2873: EXCEPTION
2874: WHEN OTHERS THEN
2875: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2876: fnd_message.set_token('ERROR' ,SQLERRM);
2877: fnd_msg_pub.add;
2878: ROLLBACK TO create_class_codey_event;
2879:
2872: END IF;
2873: EXCEPTION
2874: WHEN OTHERS THEN
2875: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2876: fnd_message.set_token('ERROR' ,SQLERRM);
2877: fnd_msg_pub.add;
2878: ROLLBACK TO create_class_codey_event;
2879:
2880: END create_class_code_event;
2932:
2933: END IF;
2934: EXCEPTION
2935: WHEN OTHERS THEN
2936: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2937: fnd_message.set_token('ERROR' ,SQLERRM);
2938: fnd_msg_pub.add;
2939: ROLLBACK TO update_class_category_event;
2940:
2933: END IF;
2934: EXCEPTION
2935: WHEN OTHERS THEN
2936: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
2937: fnd_message.set_token('ERROR' ,SQLERRM);
2938: fnd_msg_pub.add;
2939: ROLLBACK TO update_class_category_event;
2940:
2941: END update_class_code_event;
3006:
3007: END IF;
3008: EXCEPTION
3009: WHEN OTHERS THEN
3010: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3011: fnd_message.set_token('ERROR' ,SQLERRM);
3012: fnd_msg_pub.add;
3013: ROLLBACK TO create_class_code_rel_event;
3014:
3007: END IF;
3008: EXCEPTION
3009: WHEN OTHERS THEN
3010: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3011: fnd_message.set_token('ERROR' ,SQLERRM);
3012: fnd_msg_pub.add;
3013: ROLLBACK TO create_class_code_rel_event;
3014:
3015: END create_class_code_rel_event;
3082:
3083: END IF;
3084: EXCEPTION
3085: WHEN OTHERS THEN
3086: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3087: fnd_message.set_token('ERROR' ,SQLERRM);
3088: fnd_msg_pub.add;
3089: ROLLBACK TO update_class_code_rel_event;
3090:
3083: END IF;
3084: EXCEPTION
3085: WHEN OTHERS THEN
3086: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3087: fnd_message.set_token('ERROR' ,SQLERRM);
3088: fnd_msg_pub.add;
3089: ROLLBACK TO update_class_code_rel_event;
3090:
3091: END update_class_code_rel_event;
3146:
3147: END IF;
3148: EXCEPTION
3149: WHEN OTHERS THEN
3150: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3151: fnd_message.set_token('ERROR' ,SQLERRM);
3152: fnd_msg_pub.add;
3153: ROLLBACK TO create_code_assignment_event;
3154:
3147: END IF;
3148: EXCEPTION
3149: WHEN OTHERS THEN
3150: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3151: fnd_message.set_token('ERROR' ,SQLERRM);
3152: fnd_msg_pub.add;
3153: ROLLBACK TO create_code_assignment_event;
3154:
3155: END create_code_assignment_event;
3213:
3214: END IF;
3215: EXCEPTION
3216: WHEN OTHERS THEN
3217: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3218: fnd_message.set_token('ERROR' ,SQLERRM);
3219: fnd_msg_pub.add;
3220: ROLLBACK TO update_code_assignment_event;
3221:
3214: END IF;
3215: EXCEPTION
3216: WHEN OTHERS THEN
3217: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3218: fnd_message.set_token('ERROR' ,SQLERRM);
3219: fnd_msg_pub.add;
3220: ROLLBACK TO update_code_assignment_event;
3221:
3222: END update_code_assignment_event;
3287:
3288: END IF;
3289: EXCEPTION
3290: WHEN OTHERS THEN
3291: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3292: fnd_message.set_token('ERROR' ,SQLERRM);
3293: fnd_msg_pub.add;
3294: ROLLBACK TO create_class_cat_use_event;
3295:
3288: END IF;
3289: EXCEPTION
3290: WHEN OTHERS THEN
3291: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3292: fnd_message.set_token('ERROR' ,SQLERRM);
3293: fnd_msg_pub.add;
3294: ROLLBACK TO create_class_cat_use_event;
3295:
3296: END create_class_cat_use_event;
3363:
3364: END IF;
3365: EXCEPTION
3366: WHEN OTHERS THEN
3367: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3368: fnd_message.set_token('ERROR' ,SQLERRM);
3369: fnd_msg_pub.add;
3370: ROLLBACK TO update_class_cat_use_event;
3371:
3364: END IF;
3365: EXCEPTION
3366: WHEN OTHERS THEN
3367: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3368: fnd_message.set_token('ERROR' ,SQLERRM);
3369: fnd_msg_pub.add;
3370: ROLLBACK TO update_class_cat_use_event;
3371:
3372: END update_class_cat_use_event;
3428:
3429: END IF;
3430: EXCEPTION
3431: WHEN OTHERS THEN
3432: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3433: fnd_message.set_token('ERROR' ,SQLERRM);
3434: fnd_msg_pub.add;
3435: ROLLBACK TO create_person_language_event;
3436:
3429: END IF;
3430: EXCEPTION
3431: WHEN OTHERS THEN
3432: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3433: fnd_message.set_token('ERROR' ,SQLERRM);
3434: fnd_msg_pub.add;
3435: ROLLBACK TO create_person_language_event;
3436:
3437: END create_person_language_event;
3493:
3494: END IF;
3495: EXCEPTION
3496: WHEN OTHERS THEN
3497: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3498: fnd_message.set_token('ERROR' ,SQLERRM);
3499: fnd_msg_pub.add;
3500: ROLLBACK TO update_person_language_event;
3501:
3494: END IF;
3495: EXCEPTION
3496: WHEN OTHERS THEN
3497: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3498: fnd_message.set_token('ERROR' ,SQLERRM);
3499: fnd_msg_pub.add;
3500: ROLLBACK TO update_person_language_event;
3501:
3502: END update_person_language_event;
3556:
3557: END IF;
3558: EXCEPTION
3559: WHEN OTHERS THEN
3560: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3561: fnd_message.set_token('ERROR' ,SQLERRM);
3562: fnd_msg_pub.add;
3563: ROLLBACK TO create_bill_pref_event;
3564: END create_bill_pref_event;
3557: END IF;
3558: EXCEPTION
3559: WHEN OTHERS THEN
3560: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3561: fnd_message.set_token('ERROR' ,SQLERRM);
3562: fnd_msg_pub.add;
3563: ROLLBACK TO create_bill_pref_event;
3564: END create_bill_pref_event;
3565:
3613:
3614: END IF;
3615: EXCEPTION
3616: WHEN OTHERS THEN
3617: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3618: fnd_message.set_token('ERROR' ,SQLERRM);
3619: fnd_msg_pub.add;
3620: ROLLBACK TO update_bill_pref_event;
3621: END update_bill_pref_event;
3614: END IF;
3615: EXCEPTION
3616: WHEN OTHERS THEN
3617: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3618: fnd_message.set_token('ERROR' ,SQLERRM);
3619: fnd_msg_pub.add;
3620: ROLLBACK TO update_bill_pref_event;
3621: END update_bill_pref_event;
3622:
3670:
3671: END IF;
3672: EXCEPTION
3673: WHEN OTHERS THEN
3674: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3675: fnd_message.set_token('ERROR' ,SQLERRM);
3676: fnd_msg_pub.add;
3677: ROLLBACK TO create_bank_acct_uses_event;
3678: END create_bank_acct_uses_event;
3671: END IF;
3672: EXCEPTION
3673: WHEN OTHERS THEN
3674: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3675: fnd_message.set_token('ERROR' ,SQLERRM);
3676: fnd_msg_pub.add;
3677: ROLLBACK TO create_bank_acct_uses_event;
3678: END create_bank_acct_uses_event;
3679:
3727:
3728: END IF;
3729: EXCEPTION
3730: WHEN OTHERS THEN
3731: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3732: fnd_message.set_token('ERROR' ,SQLERRM);
3733: fnd_msg_pub.add;
3734: ROLLBACK TO create_bank_acct_uses_event;
3735: END update_bank_acct_uses_event;
3728: END IF;
3729: EXCEPTION
3730: WHEN OTHERS THEN
3731: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3732: fnd_message.set_token('ERROR' ,SQLERRM);
3733: fnd_msg_pub.add;
3734: ROLLBACK TO create_bank_acct_uses_event;
3735: END update_bank_acct_uses_event;
3736:
3784:
3785: END IF;
3786: EXCEPTION
3787: WHEN OTHERS THEN
3788: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3789: fnd_message.set_token('ERROR' ,SQLERRM);
3790: fnd_msg_pub.add;
3791: ROLLBACK TO create_suspension_act_event;
3792: END create_suspension_act_event;
3785: END IF;
3786: EXCEPTION
3787: WHEN OTHERS THEN
3788: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3789: fnd_message.set_token('ERROR' ,SQLERRM);
3790: fnd_msg_pub.add;
3791: ROLLBACK TO create_suspension_act_event;
3792: END create_suspension_act_event;
3793:
3840:
3841: END IF;
3842: EXCEPTION
3843: WHEN OTHERS THEN
3844: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3845: fnd_message.set_token('ERROR' ,SQLERRM);
3846: fnd_msg_pub.add;
3847: ROLLBACK TO update_suspension_act_event;
3848: END update_suspension_act_event;
3841: END IF;
3842: EXCEPTION
3843: WHEN OTHERS THEN
3844: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3845: fnd_message.set_token('ERROR' ,SQLERRM);
3846: fnd_msg_pub.add;
3847: ROLLBACK TO update_suspension_act_event;
3848: END update_suspension_act_event;
3849:
3901:
3902: END IF;
3903: EXCEPTION
3904: WHEN OTHERS THEN
3905: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3906: fnd_message.set_token('ERROR' ,SQLERRM);
3907: fnd_msg_pub.add;
3908: ROLLBACK TO create_stock_markets_event;
3909:
3902: END IF;
3903: EXCEPTION
3904: WHEN OTHERS THEN
3905: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3906: fnd_message.set_token('ERROR' ,SQLERRM);
3907: fnd_msg_pub.add;
3908: ROLLBACK TO create_stock_markets_event;
3909:
3910: END create_stock_markets_event;
3959:
3960: END IF;
3961: EXCEPTION
3962: WHEN OTHERS THEN
3963: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3964: fnd_message.set_token('ERROR' ,SQLERRM);
3965: fnd_msg_pub.add;
3966: ROLLBACK TO update_stock_markets_event;
3967:
3960: END IF;
3961: EXCEPTION
3962: WHEN OTHERS THEN
3963: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
3964: fnd_message.set_token('ERROR' ,SQLERRM);
3965: fnd_msg_pub.add;
3966: ROLLBACK TO update_stock_markets_event;
3967:
3968: END update_stock_markets_event;
4017:
4018: END IF;
4019: EXCEPTION
4020: WHEN OTHERS THEN
4021: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4022: fnd_message.set_token('ERROR' ,SQLERRM);
4023: fnd_msg_pub.add;
4024: ROLLBACK TO create_sec_issued_event;
4025:
4018: END IF;
4019: EXCEPTION
4020: WHEN OTHERS THEN
4021: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4022: fnd_message.set_token('ERROR' ,SQLERRM);
4023: fnd_msg_pub.add;
4024: ROLLBACK TO create_sec_issued_event;
4025:
4026: END create_sec_issued_event;
4075:
4076: END IF;
4077: EXCEPTION
4078: WHEN OTHERS THEN
4079: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4080: fnd_message.set_token('ERROR' ,SQLERRM);
4081: fnd_msg_pub.add;
4082: ROLLBACK TO update_sec_issued_event;
4083:
4076: END IF;
4077: EXCEPTION
4078: WHEN OTHERS THEN
4079: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4080: fnd_message.set_token('ERROR' ,SQLERRM);
4081: fnd_msg_pub.add;
4082: ROLLBACK TO update_sec_issued_event;
4083:
4084: END update_sec_issued_event;
4133:
4134: END IF;
4135: EXCEPTION
4136: WHEN OTHERS THEN
4137: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4138: fnd_message.set_token('ERROR' ,SQLERRM);
4139: fnd_msg_pub.add;
4140: ROLLBACK TO create_fin_reports_event;
4141:
4134: END IF;
4135: EXCEPTION
4136: WHEN OTHERS THEN
4137: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4138: fnd_message.set_token('ERROR' ,SQLERRM);
4139: fnd_msg_pub.add;
4140: ROLLBACK TO create_fin_reports_event;
4141:
4142: END create_fin_reports_event;
4193:
4194: END IF;
4195: EXCEPTION
4196: WHEN OTHERS THEN
4197: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4198: fnd_message.set_token('ERROR' ,SQLERRM);
4199: fnd_msg_pub.add;
4200: ROLLBACK TO update_fin_reports_event;
4201:
4194: END IF;
4195: EXCEPTION
4196: WHEN OTHERS THEN
4197: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4198: fnd_message.set_token('ERROR' ,SQLERRM);
4199: fnd_msg_pub.add;
4200: ROLLBACK TO update_fin_reports_event;
4201:
4202: END update_fin_reports_event;
4251:
4252: END IF;
4253: EXCEPTION
4254: WHEN OTHERS THEN
4255: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4256: fnd_message.set_token('ERROR' ,SQLERRM);
4257: fnd_msg_pub.add;
4258: ROLLBACK TO create_fin_numbers_event;
4259:
4252: END IF;
4253: EXCEPTION
4254: WHEN OTHERS THEN
4255: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4256: fnd_message.set_token('ERROR' ,SQLERRM);
4257: fnd_msg_pub.add;
4258: ROLLBACK TO create_fin_numbers_event;
4259:
4260: END create_fin_numbers_event;
4311:
4312: END IF;
4313: EXCEPTION
4314: WHEN OTHERS THEN
4315: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4316: fnd_message.set_token('ERROR' ,SQLERRM);
4317: fnd_msg_pub.add;
4318: ROLLBACK TO update_fin_numbers_event;
4319: END update_fin_numbers_event;
4312: END IF;
4313: EXCEPTION
4314: WHEN OTHERS THEN
4315: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4316: fnd_message.set_token('ERROR' ,SQLERRM);
4317: fnd_msg_pub.add;
4318: ROLLBACK TO update_fin_numbers_event;
4319: END update_fin_numbers_event;
4320:
4369:
4370: END IF;
4371: EXCEPTION
4372: WHEN OTHERS THEN
4373: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4374: fnd_message.set_token('ERROR' ,SQLERRM);
4375: fnd_msg_pub.add;
4376: ROLLBACK TO create_certifications_event;
4377: END create_certifications_event;
4370: END IF;
4371: EXCEPTION
4372: WHEN OTHERS THEN
4373: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4374: fnd_message.set_token('ERROR' ,SQLERRM);
4375: fnd_msg_pub.add;
4376: ROLLBACK TO create_certifications_event;
4377: END create_certifications_event;
4378:
4427:
4428: END IF;
4429: EXCEPTION
4430: WHEN OTHERS THEN
4431: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4432: fnd_message.set_token('ERROR' ,SQLERRM);
4433: fnd_msg_pub.add;
4434: ROLLBACK TO update_certifications_event;
4435: END update_certifications_event;
4428: END IF;
4429: EXCEPTION
4430: WHEN OTHERS THEN
4431: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4432: fnd_message.set_token('ERROR' ,SQLERRM);
4433: fnd_msg_pub.add;
4434: ROLLBACK TO update_certifications_event;
4435: END update_certifications_event;
4436:
4485:
4486: END IF;
4487: EXCEPTION
4488: WHEN OTHERS THEN
4489: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4490: fnd_message.set_token('ERROR' ,SQLERRM);
4491: fnd_msg_pub.add;
4492: ROLLBACK TO create_per_interest_event;
4493:
4486: END IF;
4487: EXCEPTION
4488: WHEN OTHERS THEN
4489: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4490: fnd_message.set_token('ERROR' ,SQLERRM);
4491: fnd_msg_pub.add;
4492: ROLLBACK TO create_per_interest_event;
4493:
4494: END create_person_interest_event;
4546:
4547: END IF;
4548: EXCEPTION
4549: WHEN OTHERS THEN
4550: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4551: fnd_message.set_token('ERROR' ,SQLERRM);
4552: fnd_msg_pub.add;
4553: ROLLBACK TO update_per_interest_event;
4554:
4547: END IF;
4548: EXCEPTION
4549: WHEN OTHERS THEN
4550: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4551: fnd_message.set_token('ERROR' ,SQLERRM);
4552: fnd_msg_pub.add;
4553: ROLLBACK TO update_per_interest_event;
4554:
4555: END update_person_interest_event;
4604:
4605: END IF;
4606: EXCEPTION
4607: WHEN OTHERS THEN
4608: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4609: fnd_message.set_token('ERROR' ,SQLERRM);
4610: fnd_msg_pub.add;
4611: ROLLBACK TO create_citizenship_event;
4612:
4605: END IF;
4606: EXCEPTION
4607: WHEN OTHERS THEN
4608: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4609: fnd_message.set_token('ERROR' ,SQLERRM);
4610: fnd_msg_pub.add;
4611: ROLLBACK TO create_citizenship_event;
4612:
4613: END create_citizenship_event;
4666:
4667: END IF;
4668: EXCEPTION
4669: WHEN OTHERS THEN
4670: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4671: fnd_message.set_token('ERROR' ,SQLERRM);
4672: fnd_msg_pub.add;
4673: ROLLBACK TO update_citizenship_event;
4674:
4667: END IF;
4668: EXCEPTION
4669: WHEN OTHERS THEN
4670: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4671: fnd_message.set_token('ERROR' ,SQLERRM);
4672: fnd_msg_pub.add;
4673: ROLLBACK TO update_citizenship_event;
4674:
4675: END update_citizenship_event;
4725:
4726: END IF;
4727: EXCEPTION
4728: WHEN OTHERS THEN
4729: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4730: fnd_message.set_token('ERROR' ,SQLERRM);
4731: fnd_msg_pub.add;
4732: ROLLBACK TO create_education_event;
4733:
4726: END IF;
4727: EXCEPTION
4728: WHEN OTHERS THEN
4729: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4730: fnd_message.set_token('ERROR' ,SQLERRM);
4731: fnd_msg_pub.add;
4732: ROLLBACK TO create_education_event;
4733:
4734: END create_education_event;
4787:
4788: END IF;
4789: EXCEPTION
4790: WHEN OTHERS THEN
4791: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4792: fnd_message.set_token('ERROR' ,SQLERRM);
4793: fnd_msg_pub.add;
4794: ROLLBACK TO update_education_event;
4795:
4788: END IF;
4789: EXCEPTION
4790: WHEN OTHERS THEN
4791: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4792: fnd_message.set_token('ERROR' ,SQLERRM);
4793: fnd_msg_pub.add;
4794: ROLLBACK TO update_education_event;
4795:
4796: END update_education_event;
4849:
4850: END IF;
4851: EXCEPTION
4852: WHEN OTHERS THEN
4853: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4854: fnd_message.set_token('ERROR' ,SQLERRM);
4855: fnd_msg_pub.add;
4856: ROLLBACK TO update_emp_history_event;
4857:
4850: END IF;
4851: EXCEPTION
4852: WHEN OTHERS THEN
4853: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4854: fnd_message.set_token('ERROR' ,SQLERRM);
4855: fnd_msg_pub.add;
4856: ROLLBACK TO update_emp_history_event;
4857:
4858: END update_emp_history_event;
4907:
4908: END IF;
4909: EXCEPTION
4910: WHEN OTHERS THEN
4911: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4912: fnd_message.set_token('ERROR' ,SQLERRM);
4913: fnd_msg_pub.add;
4914: ROLLBACK TO create_emp_history_event;
4915:
4908: END IF;
4909: EXCEPTION
4910: WHEN OTHERS THEN
4911: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4912: fnd_message.set_token('ERROR' ,SQLERRM);
4913: fnd_msg_pub.add;
4914: ROLLBACK TO create_emp_history_event;
4915:
4916: END create_emp_history_event;
4965:
4966: END IF;
4967: EXCEPTION
4968: WHEN OTHERS THEN
4969: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4970: fnd_message.set_token('ERROR' ,SQLERRM);
4971: fnd_msg_pub.add;
4972: ROLLBACK TO create_work_class_event;
4973:
4966: END IF;
4967: EXCEPTION
4968: WHEN OTHERS THEN
4969: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
4970: fnd_message.set_token('ERROR' ,SQLERRM);
4971: fnd_msg_pub.add;
4972: ROLLBACK TO create_work_class_event;
4973:
4974: END create_work_class_event;
5025:
5026: END IF;
5027: EXCEPTION
5028: WHEN OTHERS THEN
5029: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5030: fnd_message.set_token('ERROR' ,SQLERRM);
5031: fnd_msg_pub.add;
5032: ROLLBACK TO update_work_class_event;
5033:
5026: END IF;
5027: EXCEPTION
5028: WHEN OTHERS THEN
5029: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5030: fnd_message.set_token('ERROR' ,SQLERRM);
5031: fnd_msg_pub.add;
5032: ROLLBACK TO update_work_class_event;
5033:
5034: END update_work_class_event;
5086:
5087: END IF;
5088: EXCEPTION
5089: WHEN OTHERS THEN
5090: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5091: fnd_message.set_token('ERROR' ,SQLERRM);
5092: fnd_msg_pub.add;
5093: ROLLBACK TO create_credit_ratings_event;
5094:
5087: END IF;
5088: EXCEPTION
5089: WHEN OTHERS THEN
5090: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5091: fnd_message.set_token('ERROR' ,SQLERRM);
5092: fnd_msg_pub.add;
5093: ROLLBACK TO create_credit_ratings_event;
5094:
5095: END create_credit_ratings_event;
5146:
5147: END IF;
5148: EXCEPTION
5149: WHEN OTHERS THEN
5150: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5151: fnd_message.set_token('ERROR' ,SQLERRM);
5152: fnd_msg_pub.add;
5153: ROLLBACK TO update_credit_ratings_event;
5154:
5147: END IF;
5148: EXCEPTION
5149: WHEN OTHERS THEN
5150: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5151: fnd_message.set_token('ERROR' ,SQLERRM);
5152: fnd_msg_pub.add;
5153: ROLLBACK TO update_credit_ratings_event;
5154:
5155: END update_credit_ratings_event;
5204:
5205: END IF;
5206: EXCEPTION
5207: WHEN OTHERS THEN
5208: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5209: fnd_message.set_token('ERROR' ,SQLERRM);
5210: fnd_msg_pub.add;
5211: ROLLBACK TO create_fin_profile_event;
5212:
5205: END IF;
5206: EXCEPTION
5207: WHEN OTHERS THEN
5208: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5209: fnd_message.set_token('ERROR' ,SQLERRM);
5210: fnd_msg_pub.add;
5211: ROLLBACK TO create_fin_profile_event;
5212:
5213: END create_fin_profile_event;
5261:
5262: END IF;
5263: EXCEPTION
5264: WHEN OTHERS THEN
5265: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5266: fnd_message.set_token('ERROR' ,SQLERRM);
5267: fnd_msg_pub.add;
5268: ROLLBACK TO update_fin_profile_event;
5269:
5262: END IF;
5263: EXCEPTION
5264: WHEN OTHERS THEN
5265: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5266: fnd_message.set_token('ERROR' ,SQLERRM);
5267: fnd_msg_pub.add;
5268: ROLLBACK TO update_fin_profile_event;
5269:
5270: END update_fin_profile_event;
5318:
5319: END IF;
5320: EXCEPTION
5321: WHEN OTHERS THEN
5322: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5323: fnd_message.set_token('ERROR' ,SQLERRM);
5324: fnd_msg_pub.add;
5325: ROLLBACK TO create_orig_system_ref_event;
5326:
5319: END IF;
5320: EXCEPTION
5321: WHEN OTHERS THEN
5322: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5323: fnd_message.set_token('ERROR' ,SQLERRM);
5324: fnd_msg_pub.add;
5325: ROLLBACK TO create_orig_system_ref_event;
5326:
5327: END create_orig_system_ref_event;
5379:
5380: END IF;
5381: EXCEPTION
5382: WHEN OTHERS THEN
5383: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5384: fnd_message.set_token('ERROR' ,SQLERRM);
5385: fnd_msg_pub.add;
5386: ROLLBACK TO update_orig_system_ref_event;
5387:
5380: END IF;
5381: EXCEPTION
5382: WHEN OTHERS THEN
5383: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
5384: fnd_message.set_token('ERROR' ,SQLERRM);
5385: fnd_msg_pub.add;
5386: ROLLBACK TO update_orig_system_ref_event;
5387:
5388: END update_orig_system_ref_event;