102: ROLLBACK TO Event;
103:
104: FND_MESSAGE.SET_NAME( 'AR', 'GENERIC_MESSAGE' );
105: FND_MESSAGE.SET_TOKEN( 'GENERIC_TEXT' ,SQLERRM );
106: FND_MSG_PUB.ADD;
107:
108: WF_CORE.CONTEXT('IEX_BUS_EVENT_SUB_PVT', 'SYNC_SUMMARY', 'IEX SUMMARY', NULL);
109: WF_EVENT.setErrorInfo(p_event, 'ERROR');
110:
183: WHEN OTHERS THEN
184:
185: FND_MESSAGE.SET_NAME( 'AR', 'GENERIC_MESSAGE' );
186: FND_MESSAGE.SET_TOKEN( 'GENERIC_TEXT' ,SQLERRM );
187: FND_MSG_PUB.ADD;
188:
189: WF_CORE.CONTEXT('IEX_BUS_EVENT_SUB_PVT', 'SYNC_SUMMARY', p_event.getEventName(), p_subscription_guid);
190: WF_EVENT.setErrorInfo(p_event, 'ERROR');
191:
254: WHEN OTHERS THEN
255:
256: FND_MESSAGE.SET_NAME( 'AR', 'GENERIC_MESSAGE' );
257: FND_MESSAGE.SET_TOKEN( 'GENERIC_TEXT' ,SQLERRM );
258: FND_MSG_PUB.ADD;
259:
260: WF_CORE.CONTEXT('IEX_BUS_EVENT_SUB_PVT', 'SYNC_SUMMARY', p_event.getEventName(), p_subscription_guid);
261: WF_EVENT.setErrorInfo(p_event, 'ERROR');
262:
329: WHEN OTHERS THEN
330:
331: FND_MESSAGE.SET_NAME( 'AR', 'GENERIC_MESSAGE' );
332: FND_MESSAGE.SET_TOKEN( 'GENERIC_TEXT' ,SQLERRM );
333: FND_MSG_PUB.ADD;
334:
335: WF_CORE.CONTEXT('IEX_BUS_EVENT_SUB_PVT', 'SYNC_SUMMARY', p_event.getEventName(), p_subscription_guid);
336: WF_EVENT.setErrorInfo(p_event, 'ERROR');
337:
400: WHEN OTHERS THEN
401:
402: FND_MESSAGE.SET_NAME( 'AR', 'GENERIC_MESSAGE' );
403: FND_MESSAGE.SET_TOKEN( 'GENERIC_TEXT' ,SQLERRM );
404: FND_MSG_PUB.ADD;
405:
406: WF_CORE.CONTEXT('IEX_BUS_EVENT_SUB_PVT', 'SYNC_ADJ', p_event.getEventName(), p_subscription_guid);
407: WF_EVENT.setErrorInfo(p_event, 'ERROR');
408:
474: WHEN OTHERS THEN
475:
476: FND_MESSAGE.SET_NAME( 'AR', 'GENERIC_MESSAGE' );
477: FND_MESSAGE.SET_TOKEN( 'GENERIC_TEXT' ,SQLERRM );
478: FND_MSG_PUB.ADD;
479:
480: WF_CORE.CONTEXT('IEX_BUS_EVENT_SUB_PVT', 'SYNC_RECEIPTS', p_event.getEventName(), p_subscription_guid);
481: WF_EVENT.setErrorInfo(p_event, 'ERROR');
482:
543: WHEN OTHERS THEN
544:
545: FND_MESSAGE.SET_NAME( 'AR', 'GENERIC_MESSAGE' );
546: FND_MESSAGE.SET_TOKEN( 'GENERIC_TEXT' ,SQLERRM );
547: FND_MSG_PUB.ADD;
548:
549: WF_CORE.CONTEXT('IEX_BUS_EVENT_SUB_PVT', 'SYNC_INVOICES', p_event.getEventName(), p_subscription_guid);
550: WF_EVENT.setErrorInfo(p_event, 'ERROR');
551:
1203: ROLLBACK TO Event;
1204:
1205: FND_MESSAGE.SET_NAME( 'AR', 'GENERIC_MESSAGE' );
1206: FND_MESSAGE.SET_TOKEN( 'GENERIC_TEXT' ,SQLERRM );
1207: FND_MSG_PUB.ADD;
1208:
1209: WF_CORE.CONTEXT('IEX_BUS_EVENT_SUB_PVT', 'SYNC_SUMMARY', 'IEX SUMMARY', NULL);
1210:
1211: RETURN 'ERROR';