210: EXCEPTION
211: WHEN OTHERS THEN
212: ROLLBACK TO Scope_Update_Event;
213:
214: FND_MESSAGE.SET_NAME( 'AMW', 'GENERIC_MESSAGE' );
215: FND_MESSAGE.SET_TOKEN( 'GENERIC_TEXT' ,SQLERRM );
216: FND_MSG_PUB.ADD;
217:
218: WF_CORE.CONTEXT('AMW_PROCCERT_EVENT_PVT', 'SCOPE_UPDATE', p_event.getEventName(), p_subscription_guid);
211: WHEN OTHERS THEN
212: ROLLBACK TO Scope_Update_Event;
213:
214: FND_MESSAGE.SET_NAME( 'AMW', 'GENERIC_MESSAGE' );
215: FND_MESSAGE.SET_TOKEN( 'GENERIC_TEXT' ,SQLERRM );
216: FND_MSG_PUB.ADD;
217:
218: WF_CORE.CONTEXT('AMW_PROCCERT_EVENT_PVT', 'SCOPE_UPDATE', p_event.getEventName(), p_subscription_guid);
219: WF_EVENT.setErrorInfo(p_event, 'ERROR');
1213: EXCEPTION
1214: WHEN OTHERS THEN
1215: ROLLBACK TO Evaluation_Update_Event;
1216:
1217: FND_MESSAGE.SET_NAME( 'AMW', 'GENERIC_MESSAGE' );
1218: FND_MESSAGE.SET_TOKEN( 'GENERIC_TEXT' ,SQLERRM );
1219: FND_MSG_PUB.ADD;
1220:
1221: WF_CORE.CONTEXT('AMW_PROCCERT_EVENT_PVT', 'EVALUATION_UPDATE', p_event.getEventName(), p_subscription_guid);
1214: WHEN OTHERS THEN
1215: ROLLBACK TO Evaluation_Update_Event;
1216:
1217: FND_MESSAGE.SET_NAME( 'AMW', 'GENERIC_MESSAGE' );
1218: FND_MESSAGE.SET_TOKEN( 'GENERIC_TEXT' ,SQLERRM );
1219: FND_MSG_PUB.ADD;
1220:
1221: WF_CORE.CONTEXT('AMW_PROCCERT_EVENT_PVT', 'EVALUATION_UPDATE', p_event.getEventName(), p_subscription_guid);
1222: WF_EVENT.setErrorInfo(p_event, 'ERROR');
1988: EXCEPTION
1989: WHEN OTHERS THEN
1990: ROLLBACK TO Certification_Update_Event;
1991:
1992: FND_MESSAGE.SET_NAME( 'AMW', 'GENERIC_MESSAGE' );
1993: FND_MESSAGE.SET_TOKEN( 'GENERIC_TEXT' ,SQLERRM );
1994: FND_MSG_PUB.ADD;
1995:
1996: WF_CORE.CONTEXT('AMW_PROCCERT_EVENT_PVT', 'CERTIFICAITON_UPDATE',
1989: WHEN OTHERS THEN
1990: ROLLBACK TO Certification_Update_Event;
1991:
1992: FND_MESSAGE.SET_NAME( 'AMW', 'GENERIC_MESSAGE' );
1993: FND_MESSAGE.SET_TOKEN( 'GENERIC_TEXT' ,SQLERRM );
1994: FND_MSG_PUB.ADD;
1995:
1996: WF_CORE.CONTEXT('AMW_PROCCERT_EVENT_PVT', 'CERTIFICAITON_UPDATE',
1997: p_event.getEventName(), p_subscription_guid);