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_TASK_EVENT_PKG

Line 1: PACKAGE BODY CSM_TASK_EVENT_PKG AS

1: PACKAGE BODY CSM_TASK_EVENT_PKG AS
2: /* $Header: csmetskb.pls 120.3.12020000.3 2013/04/09 11:00:32 saradhak ship $ */
3:
4: l_markdirty_failed EXCEPTION;
5:

Line 25: 'CSM_TASK_EVENT_PKG.ACC_INSERT',FND_LOG.LEVEL_PROCEDURE);

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
29: ,P_ACC_TABLE_NAME => g_tasks_acc_table_name

Line 37: 'CSM_TASK_EVENT_PKG.ACC_INSERT',FND_LOG.LEVEL_PROCEDURE);

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
41: l_sqlerrno := to_char(SQLCODE);

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 61: 'CSM_TASK_EVENT_PKG.ACC_DELETE',FND_LOG.LEVEL_PROCEDURE);

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
65: ,P_ACC_TABLE_NAME => g_tasks_acc_table_name

Line 72: 'CSM_TASK_EVENT_PKG.ACC_DELETE',FND_LOG.LEVEL_PROCEDURE);

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
76: l_sqlerrno := to_char(SQLCODE);

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 124: AND package_name = 'CSM_TASK_EVENT_PKG'

120: IS
121: SELECT 1
122: FROM jtm_con_request_data
123: WHERE product_code = 'CSM'
124: AND package_name = 'CSM_TASK_EVENT_PKG'
125: AND procedure_name = 'PURGE_TASKS_CONC'
126: FOR UPDATE OF last_run_date NOWAIT
127: ;
128:

Line 185: csm_task_event_pkg.task_del_init(p_task_id=>l_task_id);

181: IF l_tsk_counter > l_tas_counter THEN
182:
183: IF l_task_src_type_tbl(i) ='SR' AND CSM_SR_EVENT_PKG.IS_SR_OPEN(l_task_id) = FALSE THEN
184: --Delete the taskonly if the SR is closed
185: csm_task_event_pkg.task_del_init(p_task_id=>l_task_id);
186:
187: ELSIF l_task_src_type_tbl(i) ='TASK' THEN
188: --Delete simply,as there are no SR attached for a personal task
189: csm_task_event_pkg.task_del_init(p_task_id=>l_task_id);

Line 189: csm_task_event_pkg.task_del_init(p_task_id=>l_task_id);

185: csm_task_event_pkg.task_del_init(p_task_id=>l_task_id);
186:
187: ELSIF l_task_src_type_tbl(i) ='TASK' THEN
188: --Delete simply,as there are no SR attached for a personal task
189: csm_task_event_pkg.task_del_init(p_task_id=>l_task_id);
190:
191: END IF;
192:
193: END IF; -- if counter > 1

Line 208: AND package_name = 'CSM_TASK_EVENT_PKG'

204: -- update last_run_date
205: UPDATE jtm_con_request_data
206: SET last_run_date = l_last_run_date
207: WHERE product_code = 'CSM'
208: AND package_name = 'CSM_TASK_EVENT_PKG'
209: AND procedure_name = 'PURGE_TASKS_CONC';
210:
211:
212: COMMIT;

Line 215: p_message := 'CSM_TASK_EVENT_PKG.PURGE_TASKS_CONC Executed successfully';

211:
212: COMMIT;
213:
214: p_status := 'SUCCESS';
215: p_message := 'CSM_TASK_EVENT_PKG.PURGE_TASKS_CONC Executed successfully';
216:
217: EXCEPTION
218: WHEN OTHERS THEN
219: l_sqlerrno := to_char(SQLCODE);

Line 225: p_message := 'Error in CSM_TASK_EVENT_PKG.PURGE_TASKS_CONC: ' || l_error_msg;

221: ROLLBACK;
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: /**

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 253: AND package_name = 'CSM_TASK_EVENT_PKG'

249: IS
250: SELECT last_run_date
251: FROM jtm_con_request_data
252: WHERE product_code = 'CSM'
253: AND package_name = 'CSM_TASK_EVENT_PKG'
254: AND procedure_name = 'CHECK_ESCALATION_TASKS_CONC'
255: FOR UPDATE OF last_run_date NOWAIT;
256:
257: l_upd_last_run_date DATE;

Line 277: 'CSM_TASK_EVENT_PKG.CHECK_ESCALATION_TASKS_CONC',

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,
281: p_error_msg=>l_error_msg,

Line 280: csm_task_event_pkg.TASK_MAKE_DIRTY_U_FOREACHUSER(p_task_id=>l_task_id,

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,
281: p_error_msg=>l_error_msg,
282: x_return_status=>l_return_status);
283: END LOOP;
284:

Line 295: p_message := 'CSM_TASK_EVENT_PKG.CHECK_ESCALATION_TASKS_CONC Executed successfully';

291:
292: COMMIT;
293:
294: p_status := 'SUCCESS';
295: p_message := 'CSM_TASK_EVENT_PKG.CHECK_ESCALATION_TASKS_CONC Executed successfully';
296:
297: EXCEPTION
298: WHEN OTHERS THEN
299: l_sqlerrno := to_char(SQLCODE);

Line 304: p_message := 'Error in CSM_TASK_EVENT_PKG.CHECK_ESCALATION_TASKS_CONC: ' || l_error_msg;

300: l_sqlerrmsg := substr(SQLERRM, 1,2000);
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:

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 358: l_err_msg := 'Entering CSM_TASK_EVENT_PKG.TASK_MAKE_DIRTY_U_FOREACHUSER' || ' for task_id ' || to_char(p_task_id);

354: SELECT CSM_ACTIVITY_SEQ.nextval FROM dual;
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;

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 411: l_err_msg := 'Leaving CSM_TASK_EVENT_PKG.TASK_MAKE_DIRTY_U_FOREACHUSER' || ' for task_id ' || to_char(p_task_id);

407: p_error_msg=>l_error_msg,
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

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 446: 'CSM_TASK_EVENT_PKG.TASK_INS_INIT',FND_LOG.LEVEL_PROCEDURE);

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;
450: IF l_task_csr%NOTFOUND THEN

Line 457: CSM_UTIL_PKG.LOG('Leaving TASK_INS_INIT as this task is created by HTML5 user','CSM_TASK_EVENT_PKG.TASK_INS_INIT',FND_LOG.LEVEL_PROCEDURE);

453: END IF;
454: CLOSE l_task_csr;
455:
456: IF CSM_UTIL_PKG.IS_HTML5_USER(l_task_rec.CREATED_BY) THEN
457: CSM_UTIL_PKG.LOG('Leaving TASK_INS_INIT as this task is created by HTML5 user','CSM_TASK_EVENT_PKG.TASK_INS_INIT',FND_LOG.LEVEL_PROCEDURE);
458: RETURN;
459: END IF;
460:
461: -- check if task is created by a mobile user

Line 473: csm_task_event_pkg.acc_insert(p_task_id=>p_task_id,

469: p_error_msg=>l_error_msg,
470: x_return_status=>l_return_status);
471:
472: -- insert into csm_tasks_acc
473: csm_task_event_pkg.acc_insert(p_task_id=>p_task_id,
474: p_user_id=>l_task_rec.CREATED_BY);
475: IF l_task_rec.SOURCE_OBJECT_TYPE_CODE ='TASK' AND l_task_rec.ADDRESS_ID IS NOT NULL THEN
476: --insert party sites
477: csm_party_site_event_pkg.party_sites_acc_i(p_party_site_id => l_task_rec.ADDRESS_ID,

Line 487: 'CSM_TASK_EVENT_PKG.TASK_INS_INIT',FND_LOG.LEVEL_PROCEDURE);

483:
484: END IF;
485:
486: CSM_UTIL_PKG.LOG('Leaving TASK_INS_INIT for task_id: ' || p_task_id,
487: 'CSM_TASK_EVENT_PKG.TASK_INS_INIT',FND_LOG.LEVEL_PROCEDURE);
488: EXCEPTION
489: WHEN OTHERS THEN
490: l_sqlerrno := to_char(SQLCODE);
491: l_sqlerrmsg := substr(SQLERRM, 1,2000);

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

490: l_sqlerrno := to_char(SQLCODE);
491: l_sqlerrmsg := substr(SQLERRM, 1,2000);
492: l_error_msg := ' Exception in TASK_INS_INIT for task_id:'
493: || to_char(p_task_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
494: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_EVENT_PKG.TASK_INS_INIT',FND_LOG.LEVEL_EXCEPTION);
495: RAISE;
496: END TASK_INS_INIT;
497:
498: PROCEDURE TASK_DEL_INIT(p_task_id IN NUMBER)

Line 519: 'CSM_TASK_EVENT_PKG.TASK_DEL_INIT',FND_LOG.LEVEL_PROCEDURE);

515: l_task_rec l_task_csr%ROWTYPE;
516:
517: BEGIN
518: CSM_UTIL_PKG.LOG('Entering TASK_DEL_INIT for task_id: ' || p_task_id,
519: 'CSM_TASK_EVENT_PKG.TASK_DEL_INIT',FND_LOG.LEVEL_PROCEDURE);
520:
521: OPEN l_task_csr(p_task_id);
522: FETCH l_task_csr INTO l_task_rec;
523: IF l_task_csr%NOTFOUND THEN

Line 537: csm_task_event_pkg.acc_delete(p_task_id=>p_task_id,

533: p_error_msg=>l_error_msg,
534: x_return_status=>l_return_status);
535:
536: -- delete from csm_tasks_acc
537: csm_task_event_pkg.acc_delete(p_task_id=>p_task_id,
538: p_user_id=>l_task_rec.CREATED_BY);
539:
540: IF l_task_rec.SOURCE_OBJECT_TYPE_CODE ='TASK' AND l_task_rec.ADDRESS_ID IS NOT NULL THEN
541:

Line 551: 'CSM_TASK_EVENT_PKG.TASK_DEL_INIT',FND_LOG.LEVEL_PROCEDURE);

547: x_return_status => l_return_status);
548: END IF;
549:
550: CSM_UTIL_PKG.LOG('Leaving TASK_DEL_INIT for task_id: ' || p_task_id,
551: 'CSM_TASK_EVENT_PKG.TASK_DEL_INIT',FND_LOG.LEVEL_PROCEDURE);
552: EXCEPTION
553: WHEN OTHERS THEN
554: l_sqlerrno := to_char(SQLCODE);
555: l_sqlerrmsg := substr(SQLERRM, 1,2000);

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

554: l_sqlerrno := to_char(SQLCODE);
555: l_sqlerrmsg := substr(SQLERRM, 1,2000);
556: l_error_msg := ' Exception in TASK_DEL_INIT for task_id:'
557: || to_char(p_task_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
558: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_EVENT_PKG.TASK_DEL_INIT',FND_LOG.LEVEL_EXCEPTION);
559: RAISE;
560: END TASK_DEL_INIT;
561:
562: END CSM_TASK_EVENT_PKG;

Line 562: END CSM_TASK_EVENT_PKG;

558: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_EVENT_PKG.TASK_DEL_INIT',FND_LOG.LEVEL_EXCEPTION);
559: RAISE;
560: END TASK_DEL_INIT;
561:
562: END CSM_TASK_EVENT_PKG;