76: END IF; -- chk for Relationship Create or Update Events
77: RETURN 'SUCCESS';
78: EXCEPTION
79: WHEN OTHERS THEN
80: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
81: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
82: FND_MSG_PUB.ADD;
83: WF_CORE.CONTEXT('HZ_WF_SYNCH',
84: 'propagate_user_role',
77: RETURN 'SUCCESS';
78: EXCEPTION
79: WHEN OTHERS THEN
80: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
81: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
82: FND_MSG_PUB.ADD;
83: WF_CORE.CONTEXT('HZ_WF_SYNCH',
84: 'propagate_user_role',
85: p_event.getEventName(),
667: RETURN 'SUCCESS';
668:
669: EXCEPTION
670: WHEN OTHERS THEN
671: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
672: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
673: FND_MSG_PUB.ADD;
674: WF_CORE.CONTEXT('HZ_WF_SYNCH',
675: 'propagate_user_role',
668:
669: EXCEPTION
670: WHEN OTHERS THEN
671: FND_MESSAGE.SET_NAME('AR', 'HZ_API_OTHERS_EXCEP');
672: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
673: FND_MSG_PUB.ADD;
674: WF_CORE.CONTEXT('HZ_WF_SYNCH',
675: 'propagate_user_role',
676: p_event.getEventName(),