353: IS
354: SELECT CSM_ACTIVITY_SEQ.nextval FROM dual;
355:
356: BEGIN
357: x_return_status := FND_API.G_RET_STS_SUCCESS;
358: l_err_msg := 'Entering CSM_TASK_EVENT_PKG.TASK_MAKE_DIRTY_U_FOREACHUSER' || ' for task_id ' || to_char(p_task_id);
359: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_TASK_EVENT_PKG.TASK_MAKE_DIRTY_U_FOREACHUSER', FND_LOG.LEVEL_PROCEDURE);
360:
361: --get the activity attributes
412: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_TASK_EVENT_PKG.TASK_MAKE_DIRTY_U_FOREACHUSER', FND_LOG.LEVEL_PROCEDURE);
413:
414: EXCEPTION
415: WHEN l_markdirty_failed THEN
416: x_return_status := FND_API.G_RET_STS_ERROR;
417: p_error_msg := ' FAILED TASK_MAKE_DIRTY_U_FOREACHUSER:' || to_char(l_task_id);
418: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_TASK_EVENT_PKG.TASK_MAKE_DIRTY_U_FOREACHUSER', FND_LOG.LEVEL_ERROR);
419: RAISE;
420:
418: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_TASK_EVENT_PKG.TASK_MAKE_DIRTY_U_FOREACHUSER', FND_LOG.LEVEL_ERROR);
419: RAISE;
420:
421: WHEN others THEN
422: x_return_status := FND_API.G_RET_STS_ERROR;
423: p_error_msg := ' FAILED TASK_MAKE_DIRTY_U_FOREACHUSER:' || to_char(l_task_id);
424: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_TASK_EVENT_PKG.TASK_MAKE_DIRTY_U_FOREACHUSER', FND_LOG.LEVEL_ERROR);
425: RAISE;
426: END TASK_MAKE_DIRTY_U_FOREACHUSER;