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_TASK_EVENT_PKG dependencies on CSM_UTIL_PKG

Line 24: CSM_UTIL_PKG.LOG('Entering ACC_INSERT for task_id: ' || p_task_id,

20: l_error_msg VARCHAR2(4000);
21: l_return_status VARCHAR2(2000);
22:
23: BEGIN
24: CSM_UTIL_PKG.LOG('Entering ACC_INSERT for task_id: ' || p_task_id,
25: 'CSM_TASK_EVENT_PKG.ACC_INSERT',FND_LOG.LEVEL_PROCEDURE);
26:
27: CSM_ACC_PKG.Insert_Acc
28: ( P_PUBLICATION_ITEM_NAMES => g_tasks_pubi_name

Line 36: CSM_UTIL_PKG.LOG('Leaving ACC_INSERT for task_id: ' || p_task_id,

32: ,P_PK1_NUM_VALUE => p_task_id
33: ,P_USER_ID => p_user_id
34: );
35:
36: CSM_UTIL_PKG.LOG('Leaving ACC_INSERT for task_id: ' || p_task_id,
37: 'CSM_TASK_EVENT_PKG.ACC_INSERT',FND_LOG.LEVEL_PROCEDURE);
38:
39: EXCEPTION
40: WHEN OTHERS THEN

Line 45: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_EVENT_PKG.ACC_INSERT',FND_LOG.LEVEL_EXCEPTION);

41: l_sqlerrno := to_char(SQLCODE);
42: l_sqlerrmsg := substr(SQLERRM, 1,2000);
43: l_error_msg := ' Exception in ACC_INSERT for task_id:'
44: || to_char(p_task_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
45: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_EVENT_PKG.ACC_INSERT',FND_LOG.LEVEL_EXCEPTION);
46: RAISE;
47: END ACC_INSERT;
48:
49:

Line 60: CSM_UTIL_PKG.LOG('Entering ACC_DELETE for task_id: ' || p_task_id,

56: l_error_msg VARCHAR2(4000);
57: l_return_status VARCHAR2(2000);
58:
59: BEGIN
60: CSM_UTIL_PKG.LOG('Entering ACC_DELETE for task_id: ' || p_task_id,
61: 'CSM_TASK_EVENT_PKG.ACC_DELETE',FND_LOG.LEVEL_PROCEDURE);
62:
63: CSM_ACC_PKG.Delete_Acc
64: ( P_PUBLICATION_ITEM_NAMES => g_tasks_pubi_name

Line 71: CSM_UTIL_PKG.LOG('Leaving ACC_DELETE for task_id: ' || p_task_id,

67: ,P_PK1_NUM_VALUE => p_task_id
68: ,P_USER_ID => p_user_id
69: );
70:
71: CSM_UTIL_PKG.LOG('Leaving ACC_DELETE for task_id: ' || p_task_id,
72: 'CSM_TASK_EVENT_PKG.ACC_DELETE',FND_LOG.LEVEL_PROCEDURE);
73:
74: EXCEPTION
75: WHEN OTHERS THEN

Line 80: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_EVENT_PKG.ACC_DELETE',FND_LOG.LEVEL_EXCEPTION);

76: l_sqlerrno := to_char(SQLCODE);
77: l_sqlerrmsg := substr(SQLERRM, 1,2000);
78: l_error_msg := ' Exception in ACC_DELETE for task_id:'
79: || to_char(p_task_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
80: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_EVENT_PKG.ACC_DELETE',FND_LOG.LEVEL_EXCEPTION);
81: RAISE;
82: END ACC_DELETE;
83:
84: /**

Line 166: CSM_UTIL_PKG.LOG(TO_CHAR(l_task_tbl.COUNT) || ' task records sent for purge', 'CSM_SR_EVENT_PKG.PURGE_INCIDENTS_CONC',FND_LOG.LEVEL_EVENT);

162: FETCH l_purge_tasks_csr BULK COLLECT INTO l_task_tbl, l_userid_tbl, l_counter_tbl,l_task_src_type_tbl LIMIT 50;
163: EXIT WHEN l_task_tbl.COUNT = 0;
164:
165: IF l_task_tbl.COUNT > 0 THEN
166: CSM_UTIL_PKG.LOG(TO_CHAR(l_task_tbl.COUNT) || ' task records sent for purge', 'CSM_SR_EVENT_PKG.PURGE_INCIDENTS_CONC',FND_LOG.LEVEL_EVENT);
167: FOR i IN l_task_tbl.FIRST..l_task_tbl.LAST LOOP
168: l_task_id := l_task_tbl(i);
169: l_user_id := l_userid_tbl(i);
170: l_tsk_counter := l_counter_tbl(i);

Line 226: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_EVENT_PKG.PURGE_TASKS_CONC',FND_LOG.LEVEL_EVENT);

222: l_error_msg := ' Exception in PURGE_TASKS_CONC for task_id:' || to_char(l_task_id)
223: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
224: p_status := 'ERROR';
225: p_message := 'Error in CSM_TASK_EVENT_PKG.PURGE_TASKS_CONC: ' || l_error_msg;
226: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_EVENT_PKG.PURGE_TASKS_CONC',FND_LOG.LEVEL_EVENT);
227: END PURGE_TASKS_CONC;
228:
229: /**
230: ** Conc program called every midnight to purge tasks created_by mobile user, depending on the

Line 275: -- CSM_UTIL_PKG.pvt_log('Task ' || l_task_id || ' is escalated' );

271: -- for all the users check for cancelled tasks and history days
272: FOR l_check_esc_task_rec IN c_check_esc_tasks(l_upd_last_run_date) LOOP
273:
274: l_task_id := l_check_esc_task_rec.task_id;
275: -- CSM_UTIL_PKG.pvt_log('Task ' || l_task_id || ' is escalated' );
276: CSM_UTIL_PKG.log('Task ID ' || l_task_id || ' is escalated ' ,
277: 'CSM_TASK_EVENT_PKG.CHECK_ESCALATION_TASKS_CONC',
278: FND_LOG.LEVEL_STATEMENT);
279:

Line 276: CSM_UTIL_PKG.log('Task ID ' || l_task_id || ' is escalated ' ,

272: FOR l_check_esc_task_rec IN c_check_esc_tasks(l_upd_last_run_date) LOOP
273:
274: l_task_id := l_check_esc_task_rec.task_id;
275: -- CSM_UTIL_PKG.pvt_log('Task ' || l_task_id || ' is escalated' );
276: CSM_UTIL_PKG.log('Task ID ' || l_task_id || ' is escalated ' ,
277: 'CSM_TASK_EVENT_PKG.CHECK_ESCALATION_TASKS_CONC',
278: FND_LOG.LEVEL_STATEMENT);
279:
280: csm_task_event_pkg.TASK_MAKE_DIRTY_U_FOREACHUSER(p_task_id=>l_task_id,

Line 305: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_EVENT_PKG.CHECK_ESCALATION_TASKS_CONC',FND_LOG.LEVEL_EXCEPTION);

301: l_error_msg := ' Exception in CHECK_ESCALATION_TASKS_CONC for task_id:' || to_char(l_task_id)
302: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
303: p_status := 'ERROR';
304: p_message := 'Error in CSM_TASK_EVENT_PKG.CHECK_ESCALATION_TASKS_CONC: ' || l_error_msg;
305: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_EVENT_PKG.CHECK_ESCALATION_TASKS_CONC',FND_LOG.LEVEL_EXCEPTION);
306: ROLLBACK;
307: END CHECK_ESCALATION_TASKS_CONC;
308:
309: PROCEDURE TASK_MAKE_DIRTY_U_FOREACHUSER(p_task_id IN NUMBER,

Line 345: AND ((CSM_UTIL_PKG.GetLocalTime(jt.scheduled_start_date, acc.user_id) <

341: WHERE acc.task_id = p_task_id
342: AND jt.task_id = acc.task_id
343: AND jta.task_id = acc.task_id
344: AND jts.task_status_id = jt.task_status_id
345: AND ((CSM_UTIL_PKG.GetLocalTime(jt.scheduled_start_date, acc.user_id) <
346: (SYSDATE - NVL(csm_profile_pkg.get_task_history_days(asg_base.get_user_id),100))
347: )
348: AND
349: (jts.cancelled_flag = 'Y' OR jts.closed_flag = 'Y' OR jts.completed_flag = 'Y' OR jts.rejected_flag = 'Y')

Line 359: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_TASK_EVENT_PKG.TASK_MAKE_DIRTY_U_FOREACHUSER', FND_LOG.LEVEL_PROCEDURE);

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
362: l_task_id := p_task_id;
363:

Line 369: l_dml := CSM_UTIL_PKG.GetAsgDmlConstant(l_dml);

365: l_dml := 'U';
366:
367: --change the DML value to one of the ASG constants for compatability
368: --purposes (in case ASG internally changes these values in future)
369: l_dml := CSM_UTIL_PKG.GetAsgDmlConstant(l_dml);
370:
371: l_publicationitemname := 'CSM_TASKS';
372:
373: --get the current date to be passed to make dirty api

Line 391: l_markdirty := csm_util_pkg.MakeDirtyForUser (l_publicationitemname,

387: l_dmllist(l_access_count) := l_dml;
388: end loop;
389:
390: if l_accesslist.count > 0 then
391: l_markdirty := csm_util_pkg.MakeDirtyForUser (l_publicationitemname,
392: l_accesslist,
393: l_resourcelist,
394: l_dmllist,
395: l_timestamp);

Line 412: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_TASK_EVENT_PKG.TASK_MAKE_DIRTY_U_FOREACHUSER', FND_LOG.LEVEL_PROCEDURE);

408: x_return_status=>l_return_status);
409: END LOOP;
410:
411: l_err_msg := 'Leaving CSM_TASK_EVENT_PKG.TASK_MAKE_DIRTY_U_FOREACHUSER' || ' for task_id ' || to_char(p_task_id);
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;

Line 418: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_TASK_EVENT_PKG.TASK_MAKE_DIRTY_U_FOREACHUSER', FND_LOG.LEVEL_ERROR);

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:
421: WHEN others THEN
422: x_return_status := FND_API.G_RET_STS_ERROR;

Line 424: CSM_UTIL_PKG.LOG( p_error_msg, 'CSM_TASK_EVENT_PKG.TASK_MAKE_DIRTY_U_FOREACHUSER', FND_LOG.LEVEL_ERROR);

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;
427:
428: PROCEDURE TASK_INS_INIT(p_task_id IN NUMBER)

Line 445: CSM_UTIL_PKG.LOG('Entering TASK_INS_INIT for task_id: ' || p_task_id,

441:
442: l_task_rec l_task_csr%ROWTYPE;
443:
444: BEGIN
445: CSM_UTIL_PKG.LOG('Entering TASK_INS_INIT for task_id: ' || p_task_id,
446: 'CSM_TASK_EVENT_PKG.TASK_INS_INIT',FND_LOG.LEVEL_PROCEDURE);
447:
448: OPEN l_task_csr(p_task_id);
449: FETCH l_task_csr INTO l_task_rec;

Line 457: IF CSM_UTIL_PKG.IS_PALM_USER(l_task_rec.CREATED_BY)

453: END IF;
454: CLOSE l_task_csr;
455:
456: -- check if task is created by a mobile user
457: IF CSM_UTIL_PKG.IS_PALM_USER(l_task_rec.CREATED_BY)
458: AND ( l_task_rec.SOURCE_OBJECT_TYPE_CODE IN ('SR', 'TASK') OR l_task_rec.private_flag = 'Y') THEN
459:
460: -- get task notes
461: csm_notes_event_pkg.notes_make_dirty_i_grp(p_sourceobjectcode=>'TASK',

Line 472: CSM_UTIL_PKG.LOG('Leaving TASK_INS_INIT for task_id: ' || p_task_id,

468: csm_task_event_pkg.acc_insert(p_task_id=>p_task_id,
469: p_user_id=>l_task_rec.CREATED_BY);
470: END IF;
471:
472: CSM_UTIL_PKG.LOG('Leaving TASK_INS_INIT for task_id: ' || p_task_id,
473: 'CSM_TASK_EVENT_PKG.TASK_INS_INIT',FND_LOG.LEVEL_PROCEDURE);
474: EXCEPTION
475: WHEN OTHERS THEN
476: l_sqlerrno := to_char(SQLCODE);

Line 480: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_EVENT_PKG.TASK_INS_INIT',FND_LOG.LEVEL_EXCEPTION);

476: l_sqlerrno := to_char(SQLCODE);
477: l_sqlerrmsg := substr(SQLERRM, 1,2000);
478: l_error_msg := ' Exception in TASK_INS_INIT for task_id:'
479: || to_char(p_task_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
480: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_EVENT_PKG.TASK_INS_INIT',FND_LOG.LEVEL_EXCEPTION);
481: RAISE;
482: END TASK_INS_INIT;
483:
484: PROCEDURE TASK_DEL_INIT(p_task_id IN NUMBER)

Line 504: CSM_UTIL_PKG.LOG('Entering TASK_DEL_INIT for task_id: ' || p_task_id,

500:
501: l_task_rec l_task_csr%ROWTYPE;
502:
503: BEGIN
504: CSM_UTIL_PKG.LOG('Entering TASK_DEL_INIT for task_id: ' || p_task_id,
505: 'CSM_TASK_EVENT_PKG.TASK_DEL_INIT',FND_LOG.LEVEL_PROCEDURE);
506:
507: OPEN l_task_csr(p_task_id);
508: FETCH l_task_csr INTO l_task_rec;

Line 526: CSM_UTIL_PKG.LOG('Leaving TASK_DEL_INIT for task_id: ' || p_task_id,

522: -- delete from csm_tasks_acc
523: csm_task_event_pkg.acc_delete(p_task_id=>p_task_id,
524: p_user_id=>l_task_rec.CREATED_BY);
525:
526: CSM_UTIL_PKG.LOG('Leaving TASK_DEL_INIT for task_id: ' || p_task_id,
527: 'CSM_TASK_EVENT_PKG.TASK_DEL_INIT',FND_LOG.LEVEL_PROCEDURE);
528: EXCEPTION
529: WHEN OTHERS THEN
530: l_sqlerrno := to_char(SQLCODE);

Line 534: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_EVENT_PKG.TASK_DEL_INIT',FND_LOG.LEVEL_EXCEPTION);

530: l_sqlerrno := to_char(SQLCODE);
531: l_sqlerrmsg := substr(SQLERRM, 1,2000);
532: l_error_msg := ' Exception in TASK_DEL_INIT for task_id:'
533: || to_char(p_task_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
534: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_EVENT_PKG.TASK_DEL_INIT',FND_LOG.LEVEL_EXCEPTION);
535: RAISE;
536: END TASK_DEL_INIT;
537:
538: END CSM_TASK_EVENT_PKG;