DBA Data[Home] [Help]

APPS.CSM_NOTES_EVENT_PKG dependencies on FND_API

Line 144: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;

Line 213: x_return_status := FND_API.G_RET_STS_ERROR;

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:

Line 234: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;

Line 263: x_return_status := FND_API.G_RET_STS_ERROR;

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;

Line 283: x_return_status := FND_API.G_RET_STS_SUCCESS;

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,

Line 299: x_return_status := FND_API.G_RET_STS_ERROR;

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;

Line 322: x_return_status := FND_API.G_RET_STS_SUCCESS;

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,

Line 345: x_return_status := FND_API.G_RET_STS_ERROR;

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: