DBA Data[Home] [Help]

APPS.HZ_BUSINESS_EVENT_V2PVT dependencies on FND_MSG_PUB

Line 73: FND_MSG_PUB.ADD;

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;
77:

Line 138: FND_MSG_PUB.ADD;

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;
142:

Line 202: FND_MSG_PUB.ADD;

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;
206:

Line 267: FND_MSG_PUB.ADD;

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;
271:

Line 330: FND_MSG_PUB.ADD;

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;
334:

Line 396: FND_MSG_PUB.ADD;

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;
400:

Line 469: FND_MSG_PUB.ADD;

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;
473:

Line 536: FND_MSG_PUB.ADD;

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;
540:

Line 601: FND_MSG_PUB.ADD;

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:
605: PROCEDURE update_party_site_event (

Line 667: FND_MSG_PUB.ADD;

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;
671:

Line 731: FND_MSG_PUB.ADD;

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;
735:

Line 797: FND_MSG_PUB.ADD;

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;
801:

Line 862: FND_MSG_PUB.ADD;

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;
866:

Line 929: FND_MSG_PUB.ADD;

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;
933:

Line 992: FND_MSG_PUB.ADD;

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;
996:

Line 1058: FND_MSG_PUB.ADD;

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;
1062:

Line 1123: FND_MSG_PUB.ADD;

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;
1127:

Line 1190: FND_MSG_PUB.ADD;

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;
1194:

Line 1272: fnd_msg_pub.add;

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:
1276:

Line 1367: fnd_msg_pub.add;

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:
1371: -- HZ_CONTACT_PREFERENCE_V2PUB

Line 1430: fnd_msg_pub.add;

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;
1434:

Line 1496: fnd_msg_pub.add;

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;
1500:

Line 1582: fnd_msg_pub.add;

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;
1586:

Line 1666: fnd_msg_pub.add;

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;
1670:

Line 1732: fnd_msg_pub.add;

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;
1736:

Line 1801: fnd_msg_pub.add;

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;
1805:

Line 1874: fnd_msg_pub.add;

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;
1878:

Line 1946: fnd_msg_pub.add;

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;
1950:

Line 2012: fnd_msg_pub.add;

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;
2016:

Line 2075: fnd_msg_pub.add;

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:
2079: END create_cust_profile_amt_event;

Line 2140: fnd_msg_pub.add;

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;
2144:

Line 2207: fnd_msg_pub.add;

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;
2211:

Line 2274: fnd_msg_pub.add;

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;
2278:

Line 2360: fnd_msg_pub.add;

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;
2364:

Line 2427: fnd_msg_pub.add;

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;
2431:

Line 2492: fnd_msg_pub.add;

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;
2496:

Line 2558: fnd_msg_pub.add;

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;
2562:

Line 2621: fnd_msg_pub.add;

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;
2625:

Line 2687: fnd_msg_pub.add;

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;
2691:

Line 2752: fnd_msg_pub.add;

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;
2756:

Line 2818: fnd_msg_pub.add;

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;
2822:

Line 2877: fnd_msg_pub.add;

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;
2881:

Line 2938: fnd_msg_pub.add;

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;
2942:

Line 3012: fnd_msg_pub.add;

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;
3016:

Line 3088: fnd_msg_pub.add;

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;
3092:

Line 3152: fnd_msg_pub.add;

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;
3156:

Line 3219: fnd_msg_pub.add;

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;
3223:

Line 3293: fnd_msg_pub.add;

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;
3297:

Line 3369: fnd_msg_pub.add;

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;
3373:

Line 3434: fnd_msg_pub.add;

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;
3438:

Line 3499: fnd_msg_pub.add;

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;
3503:

Line 3562: fnd_msg_pub.add;

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:
3566:

Line 3619: fnd_msg_pub.add;

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:
3623:

Line 3676: fnd_msg_pub.add;

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:
3680:

Line 3733: fnd_msg_pub.add;

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:
3737:

Line 3790: fnd_msg_pub.add;

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:
3794:

Line 3846: fnd_msg_pub.add;

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:
3850: Bug No : 4580024 */

Line 3907: fnd_msg_pub.add;

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;
3911:

Line 3965: fnd_msg_pub.add;

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;
3969:

Line 4023: fnd_msg_pub.add;

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;
4027:

Line 4081: fnd_msg_pub.add;

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;
4085:

Line 4139: fnd_msg_pub.add;

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;
4143:

Line 4199: fnd_msg_pub.add;

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;
4203:

Line 4257: fnd_msg_pub.add;

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;
4261:

Line 4317: fnd_msg_pub.add;

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:
4321:

Line 4375: fnd_msg_pub.add;

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:
4379:

Line 4433: fnd_msg_pub.add;

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:
4437: -- HZ_PERSON_INFO_V2PUB

Line 4491: fnd_msg_pub.add;

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;
4495:

Line 4552: fnd_msg_pub.add;

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;
4556:

Line 4610: fnd_msg_pub.add;

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;
4614:

Line 4672: fnd_msg_pub.add;

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;
4676:

Line 4731: fnd_msg_pub.add;

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;
4735:

Line 4793: fnd_msg_pub.add;

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;
4797:

Line 4855: fnd_msg_pub.add;

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;
4859:

Line 4913: fnd_msg_pub.add;

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;
4917:

Line 4971: fnd_msg_pub.add;

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;
4975:

Line 5031: fnd_msg_pub.add;

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;
5035:

Line 5092: fnd_msg_pub.add;

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;
5096:

Line 5152: fnd_msg_pub.add;

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;
5156:

Line 5210: fnd_msg_pub.add;

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;
5214:

Line 5267: fnd_msg_pub.add;

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;
5271:

Line 5324: fnd_msg_pub.add;

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;
5328:

Line 5385: fnd_msg_pub.add;

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;
5389: