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_ASSIGNMENT_EVENT_PKG dependencies on CSM_TASK_ASSIGNMENT_EVENT_PKG

Line 1: PACKAGE BODY CSM_TASK_ASSIGNMENT_EVENT_PKG AS

1: PACKAGE BODY CSM_TASK_ASSIGNMENT_EVENT_PKG AS
2: /* $Header: csmetab.pls 120.8.12020000.2 2013/04/09 11:00:02 saradhak ship $ */
3:
4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_TASK_ASSIGNMENTS_ACC';

Line 75: AND package_name = 'CSM_TASK_ASSIGNMENT_EVENT_PKG'

71: IS
72: SELECT 1
73: FROM jtm_con_request_data
74: WHERE product_code = 'CSM'
75: AND package_name = 'CSM_TASK_ASSIGNMENT_EVENT_PKG'
76: AND procedure_name = 'PURGE_TASK_ASSIGNMENTS_CONC'
77: FOR UPDATE OF last_run_date NOWAIT
78: ;
79:

Line 97: CSM_UTIL_PKG.LOG(TO_CHAR(l_purge_task_assignment_tbl.COUNT) || ' records sent for purge', 'CSM_TASK_ASSIGNMENT_EVENT_PKG.PURGE_TASK_ASSIGNMENTS_CONC',FND_LOG.LEVEL_EVENT);

93: FETCH l_purge_task_assignments_csr BULK COLLECT INTO l_purge_task_assignment_tbl,l_purge_task_tbl,l_task_src_type_tbl LIMIT 10;
94: EXIT WHEN l_purge_task_assignment_tbl.COUNT = 0;
95:
96: IF l_purge_task_assignment_tbl.COUNT > 0 THEN
97: CSM_UTIL_PKG.LOG(TO_CHAR(l_purge_task_assignment_tbl.COUNT) || ' records sent for purge', 'CSM_TASK_ASSIGNMENT_EVENT_PKG.PURGE_TASK_ASSIGNMENTS_CONC',FND_LOG.LEVEL_EVENT);
98: FOR i IN l_purge_task_assignment_tbl.FIRST..l_purge_task_assignment_tbl.LAST LOOP
99:
100: l_task_assignment_id := l_purge_task_assignment_tbl(i);
101: l_task_id := l_purge_task_tbl(i);

Line 105: csm_task_assignment_event_pkg.TASK_ASSIGNMENT_PURGE_INIT(p_task_assignment_id=>l_task_assignment_id,

101: l_task_id := l_purge_task_tbl(i);
102: --Delete SR tasks only if the corresponding SR is closed
103: IF l_task_src_type_tbl(i) ='SR' AND CSM_SR_EVENT_PKG.IS_SR_OPEN(l_task_id) = FALSE THEN
104:
105: csm_task_assignment_event_pkg.TASK_ASSIGNMENT_PURGE_INIT(p_task_assignment_id=>l_task_assignment_id,
106: p_error_msg=>l_error_msg,
107: x_return_status=>l_return_status);
108: ELSIF l_task_src_type_tbl(i) ='TASK' THEN
109: csm_task_assignment_event_pkg.TASK_ASSIGNMENT_PURGE_INIT(p_task_assignment_id=>l_task_assignment_id,

Line 109: csm_task_assignment_event_pkg.TASK_ASSIGNMENT_PURGE_INIT(p_task_assignment_id=>l_task_assignment_id,

105: csm_task_assignment_event_pkg.TASK_ASSIGNMENT_PURGE_INIT(p_task_assignment_id=>l_task_assignment_id,
106: p_error_msg=>l_error_msg,
107: x_return_status=>l_return_status);
108: ELSIF l_task_src_type_tbl(i) ='TASK' THEN
109: csm_task_assignment_event_pkg.TASK_ASSIGNMENT_PURGE_INIT(p_task_assignment_id=>l_task_assignment_id,
110: p_error_msg=>l_error_msg,
111: x_return_status=>l_return_status);
112:
113: END IF;

Line 132: p_message := 'CSM_TASK_ASSIGNMENT_EVENT_PKG.PURGE_TASK_ASSIGNMENTS_CONC Executed successfully';

128: CLOSE l_upd_last_run_date_csr;
129: COMMIT;
130:
131: p_status := 'SUCCESS';
132: p_message := 'CSM_TASK_ASSIGNMENT_EVENT_PKG.PURGE_TASK_ASSIGNMENTS_CONC Executed successfully';
133:
134: EXCEPTION
135: WHEN OTHERS THEN
136: l_sqlerrno := to_char(SQLCODE);

Line 141: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.PURGE_TASK_ASSIGNMENTS_CONC',FND_LOG.LEVEL_EVENT);

137: l_sqlerrmsg := substr(SQLERRM, 1,2000);
138: ROLLBACK;
139: l_error_msg := ' Exception in PURGE_TASK_ASSIGNMENTS_CONC for task_assignment_id:' || to_char(l_task_assignment_id)
140: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
141: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.PURGE_TASK_ASSIGNMENTS_CONC',FND_LOG.LEVEL_EVENT);
142: p_status := 'ERROR';
143: p_message := 'Error in CSM_TASK_ASSIGNMENT_EVENT_PKG.PURGE_TASK_ASSIGNMENTS_CONC: ' || l_error_msg;
144: -- x_return_status := FND_API.G_RET_STS_ERROR ;
145: -- RAISE;

Line 143: p_message := 'Error in CSM_TASK_ASSIGNMENT_EVENT_PKG.PURGE_TASK_ASSIGNMENTS_CONC: ' || l_error_msg;

139: l_error_msg := ' Exception in PURGE_TASK_ASSIGNMENTS_CONC for task_assignment_id:' || to_char(l_task_assignment_id)
140: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
141: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.PURGE_TASK_ASSIGNMENTS_CONC',FND_LOG.LEVEL_EVENT);
142: p_status := 'ERROR';
143: p_message := 'Error in CSM_TASK_ASSIGNMENT_EVENT_PKG.PURGE_TASK_ASSIGNMENTS_CONC: ' || l_error_msg;
144: -- x_return_status := FND_API.G_RET_STS_ERROR ;
145: -- RAISE;
146: END PURGE_TASK_ASSIGNMENTS_CONC;
147:

Line 171: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_DEBRIEF_HEADER_INS',FND_LOG.LEVEL_PROCEDURE);

167: AND acc.user_id = p_user_id);
168:
169: BEGIN
170: CSM_UTIL_PKG.LOG('Entering SPAWN_DEBRIEF_HEADER_INS for task_assignment_id: ' || p_task_assignment_id,
171: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_DEBRIEF_HEADER_INS',FND_LOG.LEVEL_PROCEDURE);
172:
173: FOR r_debrief_header_rec IN l_debrief_header_csr(p_task_assignment_id) LOOP
174: -- insert debrief headers
175: csm_debrief_header_event_pkg.debrief_header_ins_init(p_debrief_header_id=>r_debrief_header_rec.debrief_header_id,

Line 181: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_DEBRIEF_HEADER_INS',FND_LOG.LEVEL_PROCEDURE);

177: p_flow_type=>p_flow_type);
178: END LOOP;
179:
180: CSM_UTIL_PKG.LOG('Leaving SPAWN_DEBRIEF_HEADER_INS for task_assignment_id: ' || p_task_assignment_id,
181: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_DEBRIEF_HEADER_INS',FND_LOG.LEVEL_PROCEDURE);
182: EXCEPTION
183: WHEN OTHERS THEN
184: l_sqlerrno := to_char(SQLCODE);
185: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 188: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_DEBRIEF_HEADER_INS',FND_LOG.LEVEL_EXCEPTION);

184: l_sqlerrno := to_char(SQLCODE);
185: l_sqlerrmsg := substr(SQLERRM, 1,2000);
186: l_error_msg := ' Exception in SPAWN_DEBRIEF_HEADER_INS for task_assignment_id:'
187: || to_char(p_task_assignment_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
188: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_DEBRIEF_HEADER_INS',FND_LOG.LEVEL_EXCEPTION);
189: RAISE;
190: END SPAWN_DEBRIEF_HEADER_INS;
191:
192: PROCEDURE SPAWN_DEBRIEF_LINE_INS (p_task_assignment_id IN NUMBER,

Line 218: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_DEBRIEF_LINE_INS',FND_LOG.LEVEL_PROCEDURE);

214: AND acc.user_id = p_user_id);
215:
216: BEGIN
217: CSM_UTIL_PKG.LOG('Entering SPAWN_DEBRIEF_LINE_INS for task_assignment_id: ' || p_task_assignment_id,
218: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_DEBRIEF_LINE_INS',FND_LOG.LEVEL_PROCEDURE);
219:
220: FOR r_debrief_line_rec IN l_debrief_lines_csr(p_task_assignment_id) LOOP
221: -- insert debrief lines
222: csm_debrief_event_pkg.debrief_line_ins_init(p_debrief_line_id=>r_debrief_line_rec.debrief_line_id,

Line 228: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_DEBRIEF_LINE_INS',FND_LOG.LEVEL_PROCEDURE);

224: p_flow_type=>p_flow_type);
225: END LOOP;
226:
227: CSM_UTIL_PKG.LOG('Leaving SPAWN_DEBRIEF_LINE_INS for task_assignment_id: ' || p_task_assignment_id,
228: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_DEBRIEF_LINE_INS',FND_LOG.LEVEL_PROCEDURE);
229: EXCEPTION
230: WHEN OTHERS THEN
231: l_sqlerrno := to_char(SQLCODE);
232: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 235: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_DEBRIEF_LINE_INS',FND_LOG.LEVEL_EXCEPTION);

231: l_sqlerrno := to_char(SQLCODE);
232: l_sqlerrmsg := substr(SQLERRM, 1,2000);
233: l_error_msg := ' Exception in SPAWN_DEBRIEF_LINE_INS for task_assignment_id:'
234: || to_char(p_task_assignment_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
235: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_DEBRIEF_LINE_INS',FND_LOG.LEVEL_EXCEPTION);
236: RAISE;
237: END SPAWN_DEBRIEF_LINE_INS;
238:
239: PROCEDURE SPAWN_REQUIREMENT_HEADER_INS(p_task_assignment_id IN NUMBER,

Line 267: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_REQUIREMENT_HEADER_INS',FND_LOG.LEVEL_PROCEDURE);

263: );
264:
265: BEGIN
266: CSM_UTIL_PKG.LOG('Entering SPAWN_REQUIREMENT_HEADER_INS for task_assignment_id: ' || p_task_assignment_id,
267: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_REQUIREMENT_HEADER_INS',FND_LOG.LEVEL_PROCEDURE);
268:
269: IF p_flow_type IS NULL OR p_flow_type <> 'HISTORY' THEN
270: FOR r_req_headers_rec IN l_req_headers_csr(p_task_assignment_id, p_user_id) LOOP
271: -- insert requirement headers

Line 278: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_REQUIREMENT_HEADER_INS',FND_LOG.LEVEL_PROCEDURE);

274: END LOOP;
275: END IF;
276:
277: CSM_UTIL_PKG.LOG('Leaving SPAWN_REQUIREMENT_HEADER_INS for task_assignment_id: ' || p_task_assignment_id,
278: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_REQUIREMENT_HEADER_INS',FND_LOG.LEVEL_PROCEDURE);
279: EXCEPTION
280: WHEN OTHERS THEN
281: l_sqlerrno := to_char(SQLCODE);
282: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 285: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_REQUIREMENT_HEADER_INS',FND_LOG.LEVEL_EXCEPTION);

281: l_sqlerrno := to_char(SQLCODE);
282: l_sqlerrmsg := substr(SQLERRM, 1,2000);
283: l_error_msg := ' Exception in SPAWN_REQUIREMENT_HEADER_INS for task_assignment_id:'
284: || to_char(p_task_assignment_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
285: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_REQUIREMENT_HEADER_INS',FND_LOG.LEVEL_EXCEPTION);
286: RAISE;
287: END SPAWN_REQUIREMENT_HEADER_INS;
288:
289: PROCEDURE SPAWN_REQUIREMENT_LINES_INS(p_task_assignment_id IN NUMBER,

Line 321: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_REQUIREMENTS_INS',FND_LOG.LEVEL_PROCEDURE);

317: );
318:
319: BEGIN
320: CSM_UTIL_PKG.LOG('Entering SPAWN_REQUIREMENTS_INS for task_assignment_id: ' || p_task_assignment_id,
321: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_REQUIREMENTS_INS',FND_LOG.LEVEL_PROCEDURE);
322:
323: IF p_flow_type IS NULL OR p_flow_type <> 'HISTORY' THEN
324: FOR r_req_lines_rec IN l_req_lines_csr(p_task_assignment_id, p_user_id) LOOP
325: -- insert requirement lines

Line 336: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_REQUIREMENTS_INS',FND_LOG.LEVEL_PROCEDURE);

332: END LOOP;
333: END IF;
334:
335: CSM_UTIL_PKG.LOG('Leaving SPAWN_REQUIREMENTS_INS for task_assignment_id: ' || p_task_assignment_id,
336: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_REQUIREMENTS_INS',FND_LOG.LEVEL_PROCEDURE);
337: EXCEPTION
338: WHEN OTHERS THEN
339: l_sqlerrno := to_char(SQLCODE);
340: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 343: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_REQUIREMENTS_INS',FND_LOG.LEVEL_EXCEPTION);

339: l_sqlerrno := to_char(SQLCODE);
340: l_sqlerrmsg := substr(SQLERRM, 1,2000);
341: l_error_msg := ' Exception in SPAWN_REQUIREMENTS_INS for task_assignment_id:'
342: || to_char(p_task_assignment_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
343: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_REQUIREMENTS_INS',FND_LOG.LEVEL_EXCEPTION);
344: RAISE;
345: END SPAWN_REQUIREMENT_LINES_INS;
346:
347: PROCEDURE TASK_ASSIGNMENTS_ACC_PROCESSOR(p_task_assignment_id IN NUMBER,

Line 369: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENTS_ACC_PROCESSOR',FND_LOG.LEVEL_PROCEDURE);

365: AND task_id = p_task_id;
366:
367: BEGIN
368: CSM_UTIL_PKG.LOG('Entering TASK_ASSIGNMENTS_ACC_PROCESSOR for task_assignment_id: ' || p_task_assignment_id,
369: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENTS_ACC_PROCESSOR',FND_LOG.LEVEL_PROCEDURE);
370:
371: IF p_source_object_type_code = 'SR' THEN
372: csm_sr_event_pkg.incidents_acc_i(p_incident_id=>p_incident_id,p_user_id=>p_user_id);
373:

Line 398: csm_task_assignment_event_pkg.acc_insert(p_task_assignment_id=>p_task_assignment_id,

394: csm_task_event_pkg.acc_insert(p_task_id=>p_task_id, p_user_id=>p_user_id);
395: END IF;
396: CLOSE l_task_access_csr;
397:
398: csm_task_assignment_event_pkg.acc_insert(p_task_assignment_id=>p_task_assignment_id,
399: p_user_id=>p_user_id);
400:
401: CSM_UTIL_PKG.LOG('Leaving TASK_ASSIGNMENTS_ACC_PROCESSOR for task_assignment_id: ' || p_task_assignment_id,
402: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENTS_ACC_PROCESSOR',FND_LOG.LEVEL_PROCEDURE);

Line 402: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENTS_ACC_PROCESSOR',FND_LOG.LEVEL_PROCEDURE);

398: csm_task_assignment_event_pkg.acc_insert(p_task_assignment_id=>p_task_assignment_id,
399: p_user_id=>p_user_id);
400:
401: CSM_UTIL_PKG.LOG('Leaving TASK_ASSIGNMENTS_ACC_PROCESSOR for task_assignment_id: ' || p_task_assignment_id,
402: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENTS_ACC_PROCESSOR',FND_LOG.LEVEL_PROCEDURE);
403: EXCEPTION
404: WHEN OTHERS THEN
405: l_sqlerrno := to_char(SQLCODE);
406: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 409: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENTS_ACC_PROCESSOR',FND_LOG.LEVEL_EXCEPTION);

405: l_sqlerrno := to_char(SQLCODE);
406: l_sqlerrmsg := substr(SQLERRM, 1,2000);
407: l_error_msg := ' Exception in TASK_ASSIGNMENTS_ACC_PROCESSOR for task_assignment_id:'
408: || to_char(p_task_assignment_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
409: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENTS_ACC_PROCESSOR',FND_LOG.LEVEL_EXCEPTION);
410: RAISE;
411: END TASK_ASSIGNMENTS_ACC_PROCESSOR;
412:
413: PROCEDURE ACC_INSERT(p_task_assignment_id IN NUMBER, p_user_id IN NUMBER)

Line 422: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.ACC_INSERT',FND_LOG.LEVEL_PROCEDURE);

418: l_return_status VARCHAR2(2000);
419:
420: BEGIN
421: CSM_UTIL_PKG.LOG('Entering ACC_INSERT for task_assignment_id: ' || p_task_assignment_id,
422: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.ACC_INSERT',FND_LOG.LEVEL_PROCEDURE);
423:
424: CSM_ACC_PKG.Insert_Acc
425: ( P_PUBLICATION_ITEM_NAMES => g_pubi_name
426: ,P_ACC_TABLE_NAME => g_acc_table_name

Line 434: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.ACC_INSERT',FND_LOG.LEVEL_PROCEDURE);

430: ,P_USER_ID => p_user_id
431: );
432:
433: CSM_UTIL_PKG.LOG('Leaving ACC_INSERT for task_assignment_id: ' || p_task_assignment_id,
434: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.ACC_INSERT',FND_LOG.LEVEL_PROCEDURE);
435: EXCEPTION
436: WHEN OTHERS THEN
437: l_sqlerrno := to_char(SQLCODE);
438: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 441: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.ACC_INSERT',FND_LOG.LEVEL_EXCEPTION);

437: l_sqlerrno := to_char(SQLCODE);
438: l_sqlerrmsg := substr(SQLERRM, 1,2000);
439: l_error_msg := ' Exception in ACC_INSERT for task_assignment_id:'
440: || to_char(p_task_assignment_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
441: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.ACC_INSERT',FND_LOG.LEVEL_EXCEPTION);
442: RAISE;
443: END ACC_INSERT;
444:
445: --Bug 4938130

Line 565: CSM_UTIL_PKG.LOG('Entering CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_INITIALIZER for task_assignment_id: ' || p_task_assignment_id,

561: l_htm5_user boolean:=false;
562:
563: BEGIN
564: x_return_status := FND_API.G_RET_STS_SUCCESS;
565: CSM_UTIL_PKG.LOG('Entering CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_INITIALIZER for task_assignment_id: ' || p_task_assignment_id,
566: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_INITIALIZER',FND_LOG.LEVEL_PROCEDURE);
567:
568: l_TaskAssgDetails_rec := l_TaskAssgDetails_null_rec;
569:

Line 566: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_INITIALIZER',FND_LOG.LEVEL_PROCEDURE);

562:
563: BEGIN
564: x_return_status := FND_API.G_RET_STS_SUCCESS;
565: CSM_UTIL_PKG.LOG('Entering CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_INITIALIZER for task_assignment_id: ' || p_task_assignment_id,
566: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_INITIALIZER',FND_LOG.LEVEL_PROCEDURE);
567:
568: l_TaskAssgDetails_rec := l_TaskAssgDetails_null_rec;
569:
570: OPEN l_TaskAssgDetails_csr(p_task_assignment_id);

Line 575: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_INITIALIZER',FND_LOG.LEVEL_PROCEDURE);

571: FETCH l_TaskAssgDetails_csr INTO l_taskassgdetails_rec;
572: IF l_taskassgdetails_csr%NOTFOUND THEN
573: CLOSE l_taskassgdetails_csr;
574: CSM_UTIL_PKG.LOG('Not a mobile task_assignment_id: ' || p_task_assignment_id,
575: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_INITIALIZER',FND_LOG.LEVEL_PROCEDURE);
576: RETURN;
577: END IF;
578: CLOSE l_taskassgdetails_csr;
579:

Line 583: CSM_UTIL_PKG.LOG('Leaving TASK_ASSIGNMENT_INITIALIZER as this Task of HTML5 user is not having src incident','CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_INITIALIZER',FND_LOG.LEVEL_PROCEDURE);

579:
580: l_htm5_user :=CSM_UTIL_PKG.IS_HTML5_USER(l_taskassgdetails_rec.user_id);
581:
582: IF l_htm5_user AND l_TaskAssgDetails_rec.source_object_type_code <>'SR' THEN
583: CSM_UTIL_PKG.LOG('Leaving TASK_ASSIGNMENT_INITIALIZER as this Task of HTML5 user is not having src incident','CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_INITIALIZER',FND_LOG.LEVEL_PROCEDURE);
584: RETURN;
585: END IF;
586:
587: -- check if its a SR Task

Line 692: csm_task_assignment_event_pkg.spawn_debrief_line_ins(p_task_assignment_id=>p_task_assignment_id,

688: END IF;
689: END IF;
690:
691: -- spawn debrief line ins
692: csm_task_assignment_event_pkg.spawn_debrief_line_ins(p_task_assignment_id=>p_task_assignment_id,
693: p_user_id=>l_taskassgdetails_rec.user_id,
694: p_flow_type=>NULL);
695:
696: -- spawn debrief header ins

Line 697: csm_task_assignment_event_pkg.spawn_debrief_header_ins(p_task_assignment_id=>p_task_assignment_id,

693: p_user_id=>l_taskassgdetails_rec.user_id,
694: p_flow_type=>NULL);
695:
696: -- spawn debrief header ins
697: csm_task_assignment_event_pkg.spawn_debrief_header_ins(p_task_assignment_id=>p_task_assignment_id,
698: p_user_id=>l_taskassgdetails_rec.user_id,
699: p_flow_type=>NULL);
700:
701: -- spawn requirement lines ins

Line 702: csm_task_assignment_event_pkg.spawn_requirement_lines_ins(p_task_assignment_id=>p_task_assignment_id,

698: p_user_id=>l_taskassgdetails_rec.user_id,
699: p_flow_type=>NULL);
700:
701: -- spawn requirement lines ins
702: csm_task_assignment_event_pkg.spawn_requirement_lines_ins(p_task_assignment_id=>p_task_assignment_id,
703: p_user_id=>l_taskassgdetails_rec.user_id,
704: p_flow_type=>NULL);
705:
706: -- spawn requirement headers ins

Line 707: csm_task_assignment_event_pkg.spawn_requirement_header_ins(p_task_assignment_id=>p_task_assignment_id,

703: p_user_id=>l_taskassgdetails_rec.user_id,
704: p_flow_type=>NULL);
705:
706: -- spawn requirement headers ins
707: csm_task_assignment_event_pkg.spawn_requirement_header_ins(p_task_assignment_id=>p_task_assignment_id,
708: p_user_id=>l_taskassgdetails_rec.user_id,
709: p_flow_type=>NULL);
710:
711: -- task_assignments_acc processor

Line 712: csm_task_assignment_event_pkg.task_assignments_acc_processor

708: p_user_id=>l_taskassgdetails_rec.user_id,
709: p_flow_type=>NULL);
710:
711: -- task_assignments_acc processor
712: csm_task_assignment_event_pkg.task_assignments_acc_processor
713: (p_task_assignment_id=>p_task_assignment_id,
714: p_incident_id=>l_taskassgdetails_rec.incident_id,
715: p_task_id=>l_taskassgdetails_rec.task_id,
716: p_source_object_type_code=>l_taskassgdetails_rec.source_object_type_code,

Line 734: csm_task_assignment_event_pkg.lobs_mdirty_i(p_task_assignment_id=>p_task_assignment_id,

730:
731:
732: IF NOT l_htm5_user THEN
733: -- lobs mdirty I
734: csm_task_assignment_event_pkg.lobs_mdirty_i(p_task_assignment_id=>p_task_assignment_id,
735: p_resource_id=>l_taskassgdetails_rec.resource_id);
736: END IF;
737:
738:

Line 741: CSM_UTIL_PKG.LOG('Inserting task address for htm user','CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_INITIALIZER',FND_LOG.LEVEL_PROCEDURE);

737:
738:
739: --html5 functionality
740: IF l_taskassgdetails_rec.ADDRESS_ID IS NOT NULL AND l_htm5_user THEN
741: CSM_UTIL_PKG.LOG('Inserting task address for htm user','CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_INITIALIZER',FND_LOG.LEVEL_PROCEDURE);
742: csm_party_site_event_pkg.party_sites_acc_i(p_party_site_id => l_taskassgdetails_rec.ADDRESS_ID,
743: p_user_id => l_taskassgdetails_rec.user_id,
744: p_flowtype => NULL,
745: p_error_msg => l_error_msg,

Line 753: CSM_UTIL_PKG.LOG('Leaving CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_INITIALIZER for task_assignment_id: ' || p_task_assignment_id,

749: (p_party_site_id=>l_taskassgdetails_rec.ADDRESS_ID,
750: p_org_id =>l_taskassgdetails_rec.org_id ,p_user_id =>l_taskassgdetails_rec.user_id);
751: END IF;
752:
753: CSM_UTIL_PKG.LOG('Leaving CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_INITIALIZER for task_assignment_id: ' || p_task_assignment_id,
754: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_INITIALIZER',FND_LOG.LEVEL_PROCEDURE);
755: EXCEPTION
756: WHEN OTHERS THEN
757: l_sqlerrno := to_char(SQLCODE);

Line 754: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_INITIALIZER',FND_LOG.LEVEL_PROCEDURE);

750: p_org_id =>l_taskassgdetails_rec.org_id ,p_user_id =>l_taskassgdetails_rec.user_id);
751: END IF;
752:
753: CSM_UTIL_PKG.LOG('Leaving CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_INITIALIZER for task_assignment_id: ' || p_task_assignment_id,
754: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_INITIALIZER',FND_LOG.LEVEL_PROCEDURE);
755: EXCEPTION
756: WHEN OTHERS THEN
757: l_sqlerrno := to_char(SQLCODE);
758: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 762: CSM_UTIL_PKG.LOG(p_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_INITIALIZER',FND_LOG.LEVEL_EXCEPTION);

758: l_sqlerrmsg := substr(SQLERRM, 1,2000);
759: x_return_status := FND_API.G_RET_STS_ERROR;
760: p_error_msg := ' Exception in TASK_ASSIGNMENT_INITIALIZER for task_assignment_id:' || to_char(p_task_assignment_id)
761: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
762: CSM_UTIL_PKG.LOG(p_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_INITIALIZER',FND_LOG.LEVEL_EXCEPTION);
763: RAISE;
764: END TASK_ASSIGNMENT_INITIALIZER;
765:
766: PROCEDURE TASK_ASSIGNMENT_HIST_INIT(p_task_assignment_id IN NUMBER,

Line 838: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_HIST_INIT',FND_LOG.LEVEL_PROCEDURE);

834: BEGIN
835: x_return_status := FND_API.G_RET_STS_SUCCESS;
836: CSM_UTIL_PKG.LOG('Entering TASK_ASSIGNMENT_HIST_INIT for task_assignment_id: ' || p_task_assignment_id
837: || ' and parent_incident_id: ' || p_parent_incident_id,
838: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_HIST_INIT',FND_LOG.LEVEL_PROCEDURE);
839:
840: l_TaskAssgDetails_rec := l_TaskAssgDetails_null_rec;
841: l_flowtype := 'HISTORY';
842:

Line 848: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_HIST_INIT',FND_LOG.LEVEL_EXCEPTION);

844: FETCH l_TaskAssgDetails_csr INTO l_taskassgdetails_rec;
845: IF l_taskassgdetails_csr%NOTFOUND THEN
846: CLOSE l_taskassgdetails_csr;
847: CSM_UTIL_PKG.LOG('No date found for history task_assignment_id: ' || p_task_assignment_id,
848: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_HIST_INIT',FND_LOG.LEVEL_EXCEPTION);
849: RETURN;
850: END IF;
851: CLOSE l_taskassgdetails_csr;
852:

Line 902: csm_task_assignment_event_pkg.spawn_debrief_line_ins(p_task_assignment_id=>p_task_assignment_id,

898: x_return_status=>l_return_status);
899: END IF;
900:
901: -- spawn debrief line ins
902: csm_task_assignment_event_pkg.spawn_debrief_line_ins(p_task_assignment_id=>p_task_assignment_id,
903: p_user_id=>p_user_id,
904: p_flow_type=>l_flowtype);
905:
906: -- spawn debrief header ins

Line 907: csm_task_assignment_event_pkg.spawn_debrief_header_ins(p_task_assignment_id=>p_task_assignment_id,

903: p_user_id=>p_user_id,
904: p_flow_type=>l_flowtype);
905:
906: -- spawn debrief header ins
907: csm_task_assignment_event_pkg.spawn_debrief_header_ins(p_task_assignment_id=>p_task_assignment_id,
908: p_user_id=>p_user_id,
909: p_flow_type=>l_flowtype);
910:
911: -- task_assignments_acc processor

Line 912: csm_task_assignment_event_pkg.task_assignments_acc_processor

908: p_user_id=>p_user_id,
909: p_flow_type=>l_flowtype);
910:
911: -- task_assignments_acc processor
912: csm_task_assignment_event_pkg.task_assignments_acc_processor
913: (p_task_assignment_id=>p_task_assignment_id,
914: p_incident_id=>l_taskassgdetails_rec.incident_id,
915: p_task_id=>l_taskassgdetails_rec.task_id,
916: p_source_object_type_code=>l_taskassgdetails_rec.source_object_type_code,

Line 926: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_HIST_INIT',FND_LOG.LEVEL_PROCEDURE);

922: p_user_id=>p_user_id);
923:
924: CSM_UTIL_PKG.LOG('Leaving TASK_ASSIGNMENT_HIST_INIT for task_assignment_id: ' || p_task_assignment_id
925: || ' and parent_incident_id: ' || p_parent_incident_id,
926: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_HIST_INIT',FND_LOG.LEVEL_PROCEDURE);
927: EXCEPTION
928: WHEN OTHERS THEN
929: l_sqlerrno := to_char(SQLCODE);
930: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 934: CSM_UTIL_PKG.LOG(p_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_HIST_INIT',FND_LOG.LEVEL_EXCEPTION);

930: l_sqlerrmsg := substr(SQLERRM, 1,2000);
931: x_return_status := FND_API.G_RET_STS_ERROR;
932: p_error_msg := ' Exception in TASK_ASSIGNMENT_HIST_INIT for task_assignment_id:' || p_task_assignment_id
933: || ' and parent_incident_id: ' || p_parent_incident_id || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
934: CSM_UTIL_PKG.LOG(p_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_HIST_INIT',FND_LOG.LEVEL_EXCEPTION);
935: RAISE;
936: END TASK_ASSIGNMENT_HIST_INIT;
937:
938: PROCEDURE TASK_ASSIGNMENT_PURGE_INIT (p_task_assignment_id IN NUMBER,

Line 1054: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_PURGE_INIT',FND_LOG.LEVEL_PROCEDURE);

1050: l_htm5_user boolean:=false;
1051:
1052: BEGIN
1053: CSM_UTIL_PKG.LOG('Entering TASK_ASSIGNMENT_PURGE_INIT for task_assignment_id: ' || p_task_assignment_id,
1054: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_PURGE_INIT',FND_LOG.LEVEL_PROCEDURE);
1055: l_task_assg_purge_rec := l_task_assg_purge_null_rec;
1056:
1057: OPEN l_task_assg_purge_csr(p_task_assignment_id);
1058: FETCH l_task_assg_purge_csr INTO l_task_assg_purge_rec;

Line 1062: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_PURGE_INIT',FND_LOG.LEVEL_PROCEDURE);

1058: FETCH l_task_assg_purge_csr INTO l_task_assg_purge_rec;
1059: IF l_task_assg_purge_csr%NOTFOUND THEN
1060: CLOSE l_task_assg_purge_csr;
1061: CSM_UTIL_PKG.LOG('Not a mobile task_assignment_id: ' || p_task_assignment_id,
1062: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_PURGE_INIT',FND_LOG.LEVEL_PROCEDURE);
1063: RETURN;
1064: END IF;
1065: CLOSE l_task_assg_purge_csr;
1066: -- get Service Inv Validation org

Line 1091: csm_task_assignment_event_pkg.lobs_mdirty_D(p_task_assignment_id=>p_task_assignment_id,

1087:
1088:
1089: IF NOT l_htm5_user THEN
1090: -- lobs mdirty D
1091: csm_task_assignment_event_pkg.lobs_mdirty_D(p_task_assignment_id=>p_task_assignment_id,
1092: p_resource_id=>l_task_assg_purge_rec.resource_id);
1093:
1094:
1095:

Line 1180: csm_task_assignment_event_pkg.spawn_debrief_line_del(p_task_assignment_id=>p_task_assignment_id,

1176: END IF;
1177: END IF;
1178:
1179: -- spawn debrief line del
1180: csm_task_assignment_event_pkg.spawn_debrief_line_del(p_task_assignment_id=>p_task_assignment_id,
1181: p_user_id=>l_task_assg_purge_rec.user_id,
1182: p_flow_type=>NULL);
1183:
1184: -- spawn debrief header del

Line 1185: csm_task_assignment_event_pkg.spawn_debrief_header_del(p_task_assignment_id=>p_task_assignment_id,

1181: p_user_id=>l_task_assg_purge_rec.user_id,
1182: p_flow_type=>NULL);
1183:
1184: -- spawn debrief header del
1185: csm_task_assignment_event_pkg.spawn_debrief_header_del(p_task_assignment_id=>p_task_assignment_id,
1186: p_user_id=>l_task_assg_purge_rec.user_id,
1187: p_flow_type=>NULL);
1188:
1189: -- spawn requirement line del

Line 1190: csm_task_assignment_event_pkg.spawn_requirement_lines_del(p_task_assignment_id=>p_task_assignment_id,

1186: p_user_id=>l_task_assg_purge_rec.user_id,
1187: p_flow_type=>NULL);
1188:
1189: -- spawn requirement line del
1190: csm_task_assignment_event_pkg.spawn_requirement_lines_del(p_task_assignment_id=>p_task_assignment_id,
1191: p_user_id=>l_task_assg_purge_rec.user_id,
1192: p_flow_type=>NULL);
1193:
1194: -- spawn requirement header del

Line 1195: csm_task_assignment_event_pkg.spawn_requirement_header_del(p_task_assignment_id=>p_task_assignment_id,

1191: p_user_id=>l_task_assg_purge_rec.user_id,
1192: p_flow_type=>NULL);
1193:
1194: -- spawn requirement header del
1195: csm_task_assignment_event_pkg.spawn_requirement_header_del(p_task_assignment_id=>p_task_assignment_id,
1196: p_user_id=>l_task_assg_purge_rec.user_id,
1197: p_flow_type=>NULL);
1198:
1199: -- delete SR history

Line 1207: csm_task_assignment_event_pkg.task_assignments_acc_d

1203: p_user_id=>l_task_assg_purge_rec.user_id);
1204: END IF;
1205:
1206: -- task_assignments_acc delete
1207: csm_task_assignment_event_pkg.task_assignments_acc_d
1208: (p_task_assignment_id=>p_task_assignment_id,
1209: p_incident_id=>l_task_assg_purge_rec.incident_id,
1210: p_task_id=>l_task_assg_purge_rec.task_id,
1211: p_source_object_type_code=>l_task_assg_purge_rec.source_object_type_code,

Line 1216: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_PURGE_INIT',FND_LOG.LEVEL_PROCEDURE);

1212: p_flow_type=>NULL,
1213: p_user_id=>l_task_assg_purge_rec.user_id);
1214:
1215: CSM_UTIL_PKG.LOG('Leaving TASK_ASSIGNMENT_PURGE_INIT for task_assignment_id: ' || p_task_assignment_id,
1216: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_PURGE_INIT',FND_LOG.LEVEL_PROCEDURE);
1217: EXCEPTION
1218: WHEN OTHERS THEN
1219: l_sqlerrno := to_char(SQLCODE);
1220: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 1223: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_PURGE_INIT',FND_LOG.LEVEL_EXCEPTION);

1219: l_sqlerrno := to_char(SQLCODE);
1220: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1221: l_error_msg := ' Exception in TASK_ASSIGNMENT_PURGE_INIT for task_assignment_id:' || to_char(p_task_assignment_id)
1222: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1223: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_PURGE_INIT',FND_LOG.LEVEL_EXCEPTION);
1224: RAISE;
1225: END TASK_ASSIGNMENT_PURGE_INIT;
1226:
1227: --Bug 4938130

Line 1257: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_DEBRIEF_HEADER_DEL',FND_LOG.LEVEL_PROCEDURE);

1253: ;
1254:
1255: BEGIN
1256: CSM_UTIL_PKG.LOG('Entering SPAWN_DEBRIEF_HEADER_DEL for task_assignment_id: ' || p_task_assignment_id,
1257: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_DEBRIEF_HEADER_DEL',FND_LOG.LEVEL_PROCEDURE);
1258:
1259: FOR r_debrief_header_rec IN l_debrief_header_csr(p_task_assignment_id, p_user_id) LOOP
1260: -- delete debrief headers
1261: csm_debrief_header_event_pkg.debrief_header_del_init(p_debrief_header_id=>r_debrief_header_rec.debrief_header_id,

Line 1267: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_DEBRIEF_HEADER_DEL',FND_LOG.LEVEL_PROCEDURE);

1263: p_flow_type=>p_flow_type);
1264: END LOOP;
1265:
1266: CSM_UTIL_PKG.LOG('Leaving SPAWN_DEBRIEF_HEADER_DEL for task_assignment_id: ' || p_task_assignment_id,
1267: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_DEBRIEF_HEADER_DEL',FND_LOG.LEVEL_PROCEDURE);
1268: EXCEPTION
1269: WHEN OTHERS THEN
1270: l_sqlerrno := to_char(SQLCODE);
1271: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 1274: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_DEBRIEF_HEADER_DEL',FND_LOG.LEVEL_EXCEPTION);

1270: l_sqlerrno := to_char(SQLCODE);
1271: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1272: l_error_msg := ' Exception in SPAWN_DEBRIEF_HEADER_DEL for task_assignment_id:'
1273: || to_char(p_task_assignment_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1274: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_DEBRIEF_HEADER_DEL',FND_LOG.LEVEL_EXCEPTION);
1275: RAISE;
1276: END SPAWN_DEBRIEF_HEADER_DEL;
1277:
1278: PROCEDURE SPAWN_DEBRIEF_LINE_DEL (p_task_assignment_id IN NUMBER,

Line 1304: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_DEBRIEF_DEL',FND_LOG.LEVEL_PROCEDURE);

1300: ;
1301:
1302: BEGIN
1303: CSM_UTIL_PKG.LOG('Entering SPAWN_DEBRIEF_LINE_DEL for task_assignment_id: ' || p_task_assignment_id,
1304: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_DEBRIEF_DEL',FND_LOG.LEVEL_PROCEDURE);
1305:
1306: FOR r_debrief_line_rec IN l_debrief_lines_csr(p_task_assignment_id, p_user_id) LOOP
1307: -- delete debrief lines
1308: csm_debrief_event_pkg.debrief_line_del_init(p_debrief_line_id=>r_debrief_line_rec.debrief_line_id,

Line 1315: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_DEBRIEF_DEL',FND_LOG.LEVEL_PROCEDURE);

1311:
1312: END LOOP;
1313:
1314: CSM_UTIL_PKG.LOG('Leaving SPAWN_DEBRIEF_LINE_DEL for task_assignment_id: ' || p_task_assignment_id,
1315: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_DEBRIEF_DEL',FND_LOG.LEVEL_PROCEDURE);
1316: EXCEPTION
1317: WHEN OTHERS THEN
1318: l_sqlerrno := to_char(SQLCODE);
1319: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 1322: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_DEBRIEF_LINE_DEL',FND_LOG.LEVEL_EXCEPTION);

1318: l_sqlerrno := to_char(SQLCODE);
1319: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1320: l_error_msg := ' Exception in SPAWN_DEBRIEF_LINE_DEL for task_assignment_id:'
1321: || to_char(p_task_assignment_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1322: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_DEBRIEF_LINE_DEL',FND_LOG.LEVEL_EXCEPTION);
1323: RAISE;
1324: END SPAWN_DEBRIEF_LINE_DEL;
1325:
1326: PROCEDURE SPAWN_REQUIREMENT_HEADER_DEL(p_task_assignment_id IN NUMBER,

Line 1354: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_REQUIREMENT_HEADER_DEL',FND_LOG.LEVEL_PROCEDURE);

1350: );
1351:
1352: BEGIN
1353: CSM_UTIL_PKG.LOG('Entering SPAWN_REQUIREMENT_HEADER_DEL for task_assignment_id: ' || p_task_assignment_id,
1354: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_REQUIREMENT_HEADER_DEL',FND_LOG.LEVEL_PROCEDURE);
1355:
1356: IF p_flow_type IS NULL OR p_flow_type <> 'HISTORY' THEN
1357: FOR r_req_headers_rec IN l_req_headers_csr(p_task_assignment_id, p_user_id) LOOP
1358: -- delete requirement headers

Line 1365: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_REQUIREMENT_HEADER_DEL',FND_LOG.LEVEL_PROCEDURE);

1361: END LOOP;
1362: END IF;
1363:
1364: CSM_UTIL_PKG.LOG('Leaving SPAWN_REQUIREMENT_HEADER_DEL for task_assignment_id: ' || p_task_assignment_id,
1365: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_REQUIREMENT_HEADER_DEL',FND_LOG.LEVEL_PROCEDURE);
1366: EXCEPTION
1367: WHEN OTHERS THEN
1368: l_sqlerrno := to_char(SQLCODE);
1369: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 1372: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_REQUIREMENT_HEADER_DEL',FND_LOG.LEVEL_EXCEPTION);

1368: l_sqlerrno := to_char(SQLCODE);
1369: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1370: l_error_msg := ' Exception in SPAWN_REQUIREMENT_HEADER_DEL for task_assignment_id:'
1371: || to_char(p_task_assignment_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1372: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_REQUIREMENT_HEADER_DEL',FND_LOG.LEVEL_EXCEPTION);
1373: RAISE;
1374: END SPAWN_REQUIREMENT_HEADER_DEL;
1375:
1376: PROCEDURE SPAWN_REQUIREMENT_LINES_DEL(p_task_assignment_id IN NUMBER,

Line 1405: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_REQUIREMENT_LINES_DEL',FND_LOG.LEVEL_PROCEDURE);

1401: AND acc.user_id=p_user_id;
1402:
1403: BEGIN
1404: CSM_UTIL_PKG.LOG('Entering SPAWN_REQUIREMENT_LINES_DEL for task_assignment_id: ' || p_task_assignment_id,
1405: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_REQUIREMENT_LINES_DEL',FND_LOG.LEVEL_PROCEDURE);
1406:
1407: IF p_flow_type IS NULL OR p_flow_type <> 'HISTORY' THEN
1408: FOR r_req_lines_rec IN l_req_lines_csr(p_task_assignment_id, p_user_id) LOOP
1409: -- delete requirement lines

Line 1421: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_REQUIREMENT_LINES_DEL',FND_LOG.LEVEL_PROCEDURE);

1417: END LOOP;
1418: END IF;
1419:
1420: CSM_UTIL_PKG.LOG('Leaving SPAWN_REQUIREMENT_LINES_DEL for task_assignment_id: ' || p_task_assignment_id,
1421: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_REQUIREMENT_LINES_DEL',FND_LOG.LEVEL_PROCEDURE);
1422: EXCEPTION
1423: WHEN OTHERS THEN
1424: l_sqlerrno := to_char(SQLCODE);
1425: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 1428: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_REQUIREMENT_LINES_DEL',FND_LOG.LEVEL_EXCEPTION);

1424: l_sqlerrno := to_char(SQLCODE);
1425: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1426: l_error_msg := ' Exception in SPAWN_REQUIREMENT_LINES_DEL for task_assignment_id:'
1427: || to_char(p_task_assignment_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1428: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_REQUIREMENT_LINES_DEL',FND_LOG.LEVEL_EXCEPTION);
1429: RAISE;
1430: END SPAWN_REQUIREMENT_LINES_DEL;
1431:
1432: PROCEDURE TASK_ASSIGNMENTS_ACC_D(p_task_assignment_id IN NUMBER,

Line 1446: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENTS_ACC_D',FND_LOG.LEVEL_PROCEDURE);

1442: l_return_status VARCHAR2(2000);
1443:
1444: BEGIN
1445: CSM_UTIL_PKG.LOG('Entering TASK_ASSIGNMENTS_ACC_D for task_assignment_id: ' || p_task_assignment_id,
1446: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENTS_ACC_D',FND_LOG.LEVEL_PROCEDURE);
1447:
1448: IF p_source_object_type_code = 'SR' THEN
1449: csm_sr_event_pkg.incidents_acc_d(p_incident_id=>p_incident_id,p_user_id=>p_user_id);
1450:

Line 1460: csm_task_assignment_event_pkg.acc_delete(p_task_assignment_id=>p_task_assignment_id,

1456: -- delete tasks
1457: csm_task_event_pkg.acc_delete(p_user_id=>p_user_id, p_task_id=>p_task_id);
1458:
1459: -- delete task assignments
1460: csm_task_assignment_event_pkg.acc_delete(p_task_assignment_id=>p_task_assignment_id,
1461: p_user_id=>p_user_id);
1462:
1463: CSM_UTIL_PKG.LOG('Leaving TASK_ASSIGNMENTS_ACC_D for task_assignment_id: ' || p_task_assignment_id,
1464: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENTS_ACC_D',FND_LOG.LEVEL_PROCEDURE);

Line 1464: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENTS_ACC_D',FND_LOG.LEVEL_PROCEDURE);

1460: csm_task_assignment_event_pkg.acc_delete(p_task_assignment_id=>p_task_assignment_id,
1461: p_user_id=>p_user_id);
1462:
1463: CSM_UTIL_PKG.LOG('Leaving TASK_ASSIGNMENTS_ACC_D for task_assignment_id: ' || p_task_assignment_id,
1464: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENTS_ACC_D',FND_LOG.LEVEL_PROCEDURE);
1465: EXCEPTION
1466: WHEN OTHERS THEN
1467: l_sqlerrno := to_char(SQLCODE);
1468: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 1471: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENTS_ACC_D',FND_LOG.LEVEL_EXCEPTION);

1467: l_sqlerrno := to_char(SQLCODE);
1468: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1469: l_error_msg := ' Exception in TASK_ASSIGNMENTS_ACC_D for task_assignment_id:'
1470: || to_char(p_task_assignment_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1471: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENTS_ACC_D',FND_LOG.LEVEL_EXCEPTION);
1472: RAISE;
1473: END TASK_ASSIGNMENTS_ACC_D;
1474:
1475: PROCEDURE ACC_DELETE(p_task_assignment_id IN NUMBER, p_user_id IN NUMBER)

Line 1484: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.ACC_DELETE',FND_LOG.LEVEL_PROCEDURE);

1480: l_return_status VARCHAR2(2000);
1481:
1482: BEGIN
1483: CSM_UTIL_PKG.LOG('Entering ACC_DELETE for task_assignment_id: ' || p_task_assignment_id,
1484: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.ACC_DELETE',FND_LOG.LEVEL_PROCEDURE);
1485:
1486: CSM_ACC_PKG.Delete_Acc
1487: ( P_PUBLICATION_ITEM_NAMES => g_pubi_name
1488: ,P_ACC_TABLE_NAME => g_acc_table_name

Line 1495: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.ACC_DELETE',FND_LOG.LEVEL_PROCEDURE);

1491: ,P_USER_ID => p_user_id
1492: );
1493:
1494: CSM_UTIL_PKG.LOG('Leaving ACC_DELETE for task_assignment_id: ' || p_task_assignment_id,
1495: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.ACC_DELETE',FND_LOG.LEVEL_PROCEDURE);
1496: EXCEPTION
1497: WHEN OTHERS THEN
1498: l_sqlerrno := to_char(SQLCODE);
1499: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 1502: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.ACC_DELETE',FND_LOG.LEVEL_EXCEPTION);

1498: l_sqlerrno := to_char(SQLCODE);
1499: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1500: l_error_msg := ' Exception in ACC_DELETE for task_assignment_id:'
1501: || to_char(p_task_assignment_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1502: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.ACC_DELETE',FND_LOG.LEVEL_EXCEPTION);
1503: RAISE;
1504: END ACC_DELETE;
1505:
1506: PROCEDURE TASK_ASSIGNMENT_HIST_DEL_INIT(p_task_assignment_id IN NUMBER,

Line 1580: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_HIST_DEL_INIT',FND_LOG.LEVEL_PROCEDURE);

1576: BEGIN
1577: x_return_status := FND_API.G_RET_STS_SUCCESS;
1578: CSM_UTIL_PKG.LOG('Entering TASK_ASSIGNMENT_HIST_DEL_INIT for task_assignment_id: ' || p_task_assignment_id
1579: || ' and parent_incident_id: ' || p_parent_incident_id,
1580: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_HIST_DEL_INIT',FND_LOG.LEVEL_PROCEDURE);
1581:
1582: l_TaskAssgHistPurge_rec := l_TaskAssgHistPurge_null_rec;
1583: l_flowtype := 'HISTORY';
1584:

Line 1590: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_HIST_INIT',FND_LOG.LEVEL_EXCEPTION);

1586: FETCH l_TaskAssgHistPurge_csr INTO l_TaskAssgHistPurge_rec;
1587: IF l_TaskAssgHistPurge_csr%NOTFOUND THEN
1588: CLOSE l_TaskAssgHistPurge_csr;
1589: CSM_UTIL_PKG.LOG('No date found for history task_assignment_id: ' || p_task_assignment_id,
1590: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_HIST_INIT',FND_LOG.LEVEL_EXCEPTION);
1591: RETURN;
1592: END IF;
1593: CLOSE l_TaskAssgHistPurge_csr;
1594:

Line 1639: csm_task_assignment_event_pkg.spawn_debrief_line_del(p_task_assignment_id=>p_task_assignment_id,

1635: x_return_status=>l_return_status);
1636: END IF;
1637:
1638: -- spawn debrief line del
1639: csm_task_assignment_event_pkg.spawn_debrief_line_del(p_task_assignment_id=>p_task_assignment_id,
1640: p_user_id=>p_user_id,
1641: p_flow_type=>l_flowtype);
1642:
1643: -- spawn debrief header del

Line 1644: csm_task_assignment_event_pkg.spawn_debrief_header_del(p_task_assignment_id=>p_task_assignment_id,

1640: p_user_id=>p_user_id,
1641: p_flow_type=>l_flowtype);
1642:
1643: -- spawn debrief header del
1644: csm_task_assignment_event_pkg.spawn_debrief_header_del(p_task_assignment_id=>p_task_assignment_id,
1645: p_user_id=>p_user_id,
1646: p_flow_type=>l_flowtype);
1647:
1648: -- resource extns acc del

Line 1653: csm_task_assignment_event_pkg.task_assignments_acc_d

1649: csm_resource_extns_event_pkg.resource_extns_acc_d(p_resource_id=>l_TaskAssgHistPurge_rec.resource_id,
1650: p_user_id=>p_user_id);
1651:
1652: -- task_assignments_acc delete
1653: csm_task_assignment_event_pkg.task_assignments_acc_d
1654: (p_task_assignment_id=>p_task_assignment_id,
1655: p_incident_id=>l_TaskAssgHistPurge_rec.incident_id,
1656: p_task_id=>l_TaskAssgHistPurge_rec.task_id,
1657: p_source_object_type_code=>l_TaskAssgHistPurge_rec.source_object_type_code,

Line 1663: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_HIST_DEL_INIT',FND_LOG.LEVEL_PROCEDURE);

1659: p_user_id=>p_user_id);
1660:
1661: CSM_UTIL_PKG.LOG('Leaving TASK_ASSIGNMENT_HIST_DEL_INIT for task_assignment_id: ' || p_task_assignment_id
1662: || ' and parent_incident_id: ' || p_parent_incident_id,
1663: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_HIST_DEL_INIT',FND_LOG.LEVEL_PROCEDURE);
1664: EXCEPTION
1665: WHEN OTHERS THEN
1666: l_sqlerrno := to_char(SQLCODE);
1667: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 1671: CSM_UTIL_PKG.LOG(p_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_HIST_DEL_INIT',FND_LOG.LEVEL_EXCEPTION);

1667: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1668: x_return_status := FND_API.G_RET_STS_ERROR;
1669: p_error_msg := ' Exception in TASK_ASSIGNMENT_HIST_DEL_INIT for task_assignment_id:' || p_task_assignment_id
1670: || ' and parent_incident_id: ' || p_parent_incident_id || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1671: CSM_UTIL_PKG.LOG(p_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_HIST_DEL_INIT',FND_LOG.LEVEL_EXCEPTION);
1672: RAISE;
1673: END TASK_ASSIGNMENT_HIST_DEL_INIT;
1674:
1675: END CSM_TASK_ASSIGNMENT_EVENT_PKG;

Line 1675: END CSM_TASK_ASSIGNMENT_EVENT_PKG;

1671: CSM_UTIL_PKG.LOG(p_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_HIST_DEL_INIT',FND_LOG.LEVEL_EXCEPTION);
1672: RAISE;
1673: END TASK_ASSIGNMENT_HIST_DEL_INIT;
1674:
1675: END CSM_TASK_ASSIGNMENT_EVENT_PKG;