140: WHERE acc.debrief_header_id = c_source_object_id;
141:
142:
143: BEGIN
144: x_return_status := FND_API.G_RET_STS_SUCCESS;
145: CSM_UTIL_PKG.LOG('Entering CSM_NOTES_EVENT_PKG.NOTES_MAKE_DIRTY_I_FOREACHUSER ',
146: 'CSM_NOTES_EVENT_PKG.NOTES_MAKE_DIRTY_I_FOREACHUSER',FND_LOG.LEVEL_PROCEDURE);
147:
148: l_user_found := false;
209: 'CSM_NOTES_EVENT_PKG.NOTES_MAKE_DIRTY_I_FOREACHUSER',FND_LOG.LEVEL_PROCEDURE);
210:
211: EXCEPTION
212: WHEN others THEN
213: x_return_status := FND_API.G_RET_STS_ERROR;
214: p_error_msg := ' FAILED NOTES_MAKE_DIRTY_I_FOREACHUSER:' || to_char(p_jtf_note_id);
215: CSM_UTIL_PKG.LOG(p_error_msg, 'CSM_NOTES_EVENT_PKG.NOTES_MAKE_DIRTY_I_FOREACHUSER',FND_LOG.LEVEL_EXCEPTION);
216: END NOTES_MAKE_DIRTY_I_FOREACHUSER;
217:
230: FROM csm_notes_acc acc
231: WHERE acc.jtf_note_id = p_jtf_note_id;
232:
233: BEGIN
234: x_return_status := FND_API.G_RET_STS_SUCCESS;
235: CSM_UTIL_PKG.LOG('Entering CSM_NOTES_EVENT_PKG.NOTES_MAKE_DIRTY_U_FOREACHUSER ',
236: 'CSM_NOTES_EVENT_PKG.NOTES_MAKE_DIRTY_U_FOREACHUSER',FND_LOG.LEVEL_PROCEDURE);
237:
238: l_user_found := false;
259: 'CSM_NOTES_EVENT_PKG.NOTES_MAKE_DIRTY_U_FOREACHUSER',FND_LOG.LEVEL_PROCEDURE);
260:
261: EXCEPTION
262: WHEN others THEN
263: x_return_status := FND_API.G_RET_STS_ERROR;
264: p_error_msg := ' FAILED NOTES_MAKE_DIRTY_U_FOREACHUSER:' || to_char(p_jtf_note_id);
265: CSM_UTIL_PKG.LOG(p_error_msg, 'CSM_NOTES_EVENT_PKG.NOTES_MAKE_DIRTY_U_FOREACHUSER',FND_LOG.LEVEL_EXCEPTION);
266:
267: END NOTES_MAKE_DIRTY_U_FOREACHUSER;
279: WHERE source_object_code = p_sourceobjectcode
280: AND source_object_id = p_sourceobjectid;
281:
282: BEGIN
283: x_return_status := FND_API.G_RET_STS_SUCCESS;
284: CSM_UTIL_PKG.LOG('Entering CSM_NOTES_EVENT_PKG.NOTES_MAKE_DIRTY_I_GRP ',
285: 'CSM_NOTES_EVENT_PKG.NOTES_MAKE_DIRTY_I_GRP',FND_LOG.LEVEL_PROCEDURE);
286:
287: FOR l_notes_by_task_rec in l_notes_by_task_csr(p_sourceobjectcode,
295: 'CSM_NOTES_EVENT_PKG.NOTES_MAKE_DIRTY_I_GRP',FND_LOG.LEVEL_PROCEDURE);
296:
297: EXCEPTION
298: WHEN others THEN
299: x_return_status := FND_API.G_RET_STS_ERROR;
300: p_error_msg := ' FAILED NOTES_MAKE_DIRTY_I_GRP for ' || p_sourceobjectcode || ':' || to_char(p_sourceobjectid);
301: CSM_UTIL_PKG.LOG(p_error_msg, 'CSM_NOTES_EVENT_PKG.NOTES_MAKE_DIRTY_I_GRP',FND_LOG.LEVEL_EXCEPTION);
302:
303: END NOTES_MAKE_DIRTY_I_GRP;
318: AND notes.jtf_note_id = acc.jtf_note_id
319: AND acc.user_id = p_user_id;
320:
321: BEGIN
322: x_return_status := FND_API.G_RET_STS_SUCCESS;
323: CSM_UTIL_PKG.LOG('Entering CSM_NOTES_EVENT_PKG.NOTES_MAKE_DIRTY_D_GRP ',
324: 'CSM_NOTES_EVENT_PKG.NOTES_MAKE_DIRTY_D_GRP',FND_LOG.LEVEL_PROCEDURE);
325:
326: FOR l_notes_by_task_rec IN l_notes_by_task_csr(p_sourceobjectcode,
341: 'CSM_NOTES_EVENT_PKG.NOTES_MAKE_DIRTY_D_GRP',FND_LOG.LEVEL_PROCEDURE);
342:
343: EXCEPTION
344: WHEN others THEN
345: x_return_status := FND_API.G_RET_STS_ERROR;
346: p_error_msg := ' FAILED NOTES_MAKE_DIRTY_D_GRP for ' || p_sourceobjectcode || ':' || to_char(p_sourceobjectid);
347: CSM_UTIL_PKG.LOG(p_error_msg, 'CSM_NOTES_EVENT_PKG.NOTES_MAKE_DIRTY_D_GRP',FND_LOG.LEVEL_EXCEPTION);
348: END NOTES_MAKE_DIRTY_D_GRP;
349: