DBA Data[Home] [Help]

APPS.HZ_BUSINESS_EVENT_V2PVT dependencies on FND_MESSAGE

Line 71: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 72: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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;

Line 136: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 137: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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;

Line 200: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 201: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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;

Line 265: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 266: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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;

Line 328: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 329: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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;

Line 394: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 395: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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;

Line 467: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 468: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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;

Line 534: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 535: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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;

Line 599: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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;

Line 600: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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:

Line 665: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 666: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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;

Line 729: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 730: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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;

Line 795: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 796: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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;

Line 860: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 861: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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;

Line 927: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 928: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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;

Line 990: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 991: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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;

Line 1056: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 1057: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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;

Line 1121: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 1122: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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;

Line 1188: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 1189: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);

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;

Line 1270: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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;

Line 1271: fnd_message.set_token('ERROR', SQLERRM);

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:

Line 1365: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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;

Line 1366: fnd_message.set_token('ERROR', SQLERRM);

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:

Line 1428: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 1429: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 1494: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 1495: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 1580: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 1581: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 1664: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 1665: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 1730: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 1731: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 1799: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 1800: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 1872: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 1873: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 1944: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 1945: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 2010: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 2011: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 2073: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 2074: fnd_message.set_token('ERROR' ,SQLERRM);

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:

Line 2138: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 2139: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 2205: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 2206: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 2272: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 2273: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 2358: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 2359: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 2425: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 2426: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 2490: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 2491: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 2556: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 2557: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 2619: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 2620: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 2685: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 2686: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 2750: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 2751: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 2816: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 2817: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 2875: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 2876: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 2936: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 2937: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 3010: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 3011: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 3086: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 3087: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 3150: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 3151: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 3217: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 3218: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 3291: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 3292: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 3367: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 3368: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 3432: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 3433: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 3497: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 3498: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 3560: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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;

Line 3561: fnd_message.set_token('ERROR' ,SQLERRM);

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:

Line 3617: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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;

Line 3618: fnd_message.set_token('ERROR' ,SQLERRM);

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:

Line 3674: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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;

Line 3675: fnd_message.set_token('ERROR' ,SQLERRM);

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:

Line 3731: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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;

Line 3732: fnd_message.set_token('ERROR' ,SQLERRM);

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:

Line 3788: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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;

Line 3789: fnd_message.set_token('ERROR' ,SQLERRM);

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:

Line 3844: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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;

Line 3845: fnd_message.set_token('ERROR' ,SQLERRM);

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:

Line 3905: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 3906: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 3963: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 3964: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 4021: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 4022: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 4079: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 4080: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 4137: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 4138: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 4197: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 4198: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 4255: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 4256: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 4315: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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;

Line 4316: fnd_message.set_token('ERROR' ,SQLERRM);

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:

Line 4373: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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;

Line 4374: fnd_message.set_token('ERROR' ,SQLERRM);

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:

Line 4431: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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;

Line 4432: fnd_message.set_token('ERROR' ,SQLERRM);

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:

Line 4489: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 4490: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 4550: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 4551: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 4608: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 4609: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 4670: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 4671: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 4729: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 4730: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 4791: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 4792: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 4853: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 4854: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 4911: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 4912: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 4969: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 4970: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 5029: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 5030: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 5090: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 5091: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 5150: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 5151: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 5208: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 5209: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 5265: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 5266: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 5322: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 5323: fnd_message.set_token('ERROR' ,SQLERRM);

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;

Line 5383: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');

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:

Line 5384: fnd_message.set_token('ERROR' ,SQLERRM);

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;