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 CSM_UTIL_PKG

Line 47: CSM_UTIL_PKG.LOG( sqlerrm|| ' for PK ' || to_char(p_jtf_note_id),

43: );
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;

Line 145: CSM_UTIL_PKG.LOG('Entering CSM_NOTES_EVENT_PKG.NOTES_MAKE_DIRTY_I_FOREACHUSER ',

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

Line 208: CSM_UTIL_PKG.LOG('Leaving CSM_NOTES_EVENT_PKG.NOTES_MAKE_DIRTY_I_FOREACHUSER ',

204: ELSE
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

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 235: CSM_UTIL_PKG.LOG('Entering CSM_NOTES_EVENT_PKG.NOTES_MAKE_DIRTY_U_FOREACHUSER ',

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

Line 258: CSM_UTIL_PKG.LOG('Leaving CSM_NOTES_EVENT_PKG.NOTES_MAKE_DIRTY_U_FOREACHUSER ',

254: else
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

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 284: CSM_UTIL_PKG.LOG('Entering CSM_NOTES_EVENT_PKG.NOTES_MAKE_DIRTY_I_GRP ',

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

Line 294: CSM_UTIL_PKG.LOG('Leaving CSM_NOTES_EVENT_PKG.NOTES_MAKE_DIRTY_I_GRP ',

290: -- insert into csm_notes_acc table
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

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 323: CSM_UTIL_PKG.LOG('Entering CSM_NOTES_EVENT_PKG.NOTES_MAKE_DIRTY_D_GRP ',

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,
327: p_sourceobjectid,

Line 340: CSM_UTIL_PKG.LOG('Leaving CSM_NOTES_EVENT_PKG.NOTES_MAKE_DIRTY_D_GRP ',

336: );
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

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 376: l_omfs_palm_user_list := csm_util_pkg.get_all_omfs_palm_user_list;

372:
373: BEGIN
374: --get mfs users
375: l_omfs_palm_user_list := l_null_user_list;
376: l_omfs_palm_user_list := csm_util_pkg.get_all_omfs_palm_user_list;
377:
378: -- insert into csm_object_mappings_acc
379: FOR r_mappings_rec IN l_mappings_csr LOOP
380:

Line 391: l_markdirty := CSM_UTIL_PKG.MakeDirtyForUser('CSF_M_OBJECT_MAPPINGS',

387: INSERT_CSM_OBJECT_MAPPINGS_ACC(r_mappings_rec.access_id, r_mappings_rec.mapping_id);
388:
389: --mark dirty the SDQ for all users
390: IF l_single_access_id_list.count > 0 THEN
391: l_markdirty := CSM_UTIL_PKG.MakeDirtyForUser('CSF_M_OBJECT_MAPPINGS',
392: l_single_access_id_list, l_omfs_palm_user_list,
393: ASG_DOWNLOAD.INS, sysdate);
394: END IF;
395: END LOOP;

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;