eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_NOTES_EVENT_PKG dependencies on FND_LOG

Line 48: 'CSM_NOTES_EVENT_PKG.INSERT_CSM_NOTES_ACC',FND_LOG.LEVEL_EXCEPTION);

44:
45:
46: EXCEPTION WHEN OTHERS THEN
47: CSM_UTIL_PKG.LOG( sqlerrm|| ' for PK ' || to_char(p_jtf_note_id),
48: 'CSM_NOTES_EVENT_PKG.INSERT_CSM_NOTES_ACC',FND_LOG.LEVEL_EXCEPTION);
49: RAISE;
50:
51: END;-- end INSERT_CSM_NOTES_ACC;
52:

Line 146: 'CSM_NOTES_EVENT_PKG.NOTES_MAKE_DIRTY_I_FOREACHUSER',FND_LOG.LEVEL_PROCEDURE);

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;
149: l_jtf_note_id := p_jtf_note_id;
150: --bug 5104453

Line 209: 'CSM_NOTES_EVENT_PKG.NOTES_MAKE_DIRTY_I_FOREACHUSER',FND_LOG.LEVEL_PROCEDURE);

205: p_error_msg := ' No User for JtfNoteId: ' || to_char(l_jtf_note_id) ;
206: END IF;
207:
208: CSM_UTIL_PKG.LOG('Leaving CSM_NOTES_EVENT_PKG.NOTES_MAKE_DIRTY_I_FOREACHUSER ',
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;

Line 215: CSM_UTIL_PKG.LOG(p_error_msg, 'CSM_NOTES_EVENT_PKG.NOTES_MAKE_DIRTY_I_FOREACHUSER',FND_LOG.LEVEL_EXCEPTION);

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:
218: PROCEDURE NOTES_MAKE_DIRTY_U_FOREACHUSER(p_jtf_note_id IN NUMBER,
219: p_error_msg OUT NOCOPY VARCHAR2,

Line 236: 'CSM_NOTES_EVENT_PKG.NOTES_MAKE_DIRTY_U_FOREACHUSER',FND_LOG.LEVEL_PROCEDURE);

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;
239: l_jtf_note_id := p_jtf_note_id;
240:

Line 259: 'CSM_NOTES_EVENT_PKG.NOTES_MAKE_DIRTY_U_FOREACHUSER',FND_LOG.LEVEL_PROCEDURE);

255: p_error_msg := ' No Users for JtfNoteId : ' || to_char(l_jtf_note_id);
256: end if;
257:
258: CSM_UTIL_PKG.LOG('Leaving CSM_NOTES_EVENT_PKG.NOTES_MAKE_DIRTY_U_FOREACHUSER ',
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;

Line 265: CSM_UTIL_PKG.LOG(p_error_msg, 'CSM_NOTES_EVENT_PKG.NOTES_MAKE_DIRTY_U_FOREACHUSER',FND_LOG.LEVEL_EXCEPTION);

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;
268:
269: PROCEDURE NOTES_MAKE_DIRTY_I_GRP(p_sourceobjectcode IN VARCHAR2,

Line 285: 'CSM_NOTES_EVENT_PKG.NOTES_MAKE_DIRTY_I_GRP',FND_LOG.LEVEL_PROCEDURE);

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,
288: p_sourceobjectid) LOOP
289:

Line 295: 'CSM_NOTES_EVENT_PKG.NOTES_MAKE_DIRTY_I_GRP',FND_LOG.LEVEL_PROCEDURE);

291: insert_csm_notes_acc (l_notes_by_task_rec.jtf_note_id, p_userid);
292: END LOOP;
293:
294: CSM_UTIL_PKG.LOG('Leaving CSM_NOTES_EVENT_PKG.NOTES_MAKE_DIRTY_I_GRP ',
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;

Line 301: CSM_UTIL_PKG.LOG(p_error_msg, 'CSM_NOTES_EVENT_PKG.NOTES_MAKE_DIRTY_I_GRP',FND_LOG.LEVEL_EXCEPTION);

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;
304:
305: PROCEDURE NOTES_MAKE_DIRTY_D_GRP(p_sourceobjectcode IN VARCHAR2,

Line 324: 'CSM_NOTES_EVENT_PKG.NOTES_MAKE_DIRTY_D_GRP',FND_LOG.LEVEL_PROCEDURE);

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,
327: p_sourceobjectid,
328: p_userid) LOOP

Line 341: 'CSM_NOTES_EVENT_PKG.NOTES_MAKE_DIRTY_D_GRP',FND_LOG.LEVEL_PROCEDURE);

337:
338: END LOOP;
339:
340: CSM_UTIL_PKG.LOG('Leaving CSM_NOTES_EVENT_PKG.NOTES_MAKE_DIRTY_D_GRP ',
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;

Line 347: CSM_UTIL_PKG.LOG(p_error_msg, 'CSM_NOTES_EVENT_PKG.NOTES_MAKE_DIRTY_D_GRP',FND_LOG.LEVEL_EXCEPTION);

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:
350: PROCEDURE OBJECT_MAPPINGS_ACC_PROCESSOR
351: IS

Line 402: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_NOTES_EVENT_PKG.OBJECT_MAPPINGS_ACC_PROCESSOR',FND_LOG.LEVEL_EXCEPTION);

398: WHEN OTHERS THEN
399: l_sqlerrno := to_char(SQLCODE);
400: l_sqlerrmsg := substr(SQLERRM, 1,2000);
401: l_error_msg := ' Exception in OBJECT_MAPPINGS_ACC_PROCESSOR ' || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
402: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_NOTES_EVENT_PKG.OBJECT_MAPPINGS_ACC_PROCESSOR',FND_LOG.LEVEL_EXCEPTION);
403: RAISE;
404: END OBJECT_MAPPINGS_ACC_PROCESSOR;
405:
406: END CSM_NOTES_EVENT_PKG;