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 2006/09/15 13:00:29 trajasek noship $ */
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 320: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_REQUIREMENTS_INS',FND_LOG.LEVEL_PROCEDURE);

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

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

327: END LOOP;
328: END IF;
329:
330: CSM_UTIL_PKG.LOG('Leaving SPAWN_REQUIREMENTS_INS for task_assignment_id: ' || p_task_assignment_id,
331: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_REQUIREMENTS_INS',FND_LOG.LEVEL_PROCEDURE);
332: EXCEPTION
333: WHEN OTHERS THEN
334: l_sqlerrno := to_char(SQLCODE);
335: l_sqlerrmsg := substr(SQLERRM, 1,2000);

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

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

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

360: AND task_id = p_task_id;
361:
362: BEGIN
363: CSM_UTIL_PKG.LOG('Entering TASK_ASSIGNMENTS_ACC_PROCESSOR for task_assignment_id: ' || p_task_assignment_id,
364: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENTS_ACC_PROCESSOR',FND_LOG.LEVEL_PROCEDURE);
365:
366: IF p_source_object_type_code = 'SR' THEN
367: csm_sr_event_pkg.incidents_acc_i(p_incident_id=>p_incident_id,
368: p_user_id=>p_user_id);

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

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

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

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

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

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

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

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

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

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

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

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

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

551: l_TaskAssgDetails_null_rec l_TaskAssgDetails_csr%ROWTYPE;
552:
553: BEGIN
554: x_return_status := FND_API.G_RET_STS_SUCCESS;
555: CSM_UTIL_PKG.LOG('Entering CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_INITIALIZER for task_assignment_id: ' || p_task_assignment_id,
556: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_INITIALIZER',FND_LOG.LEVEL_PROCEDURE);
557:
558: l_TaskAssgDetails_rec := l_TaskAssgDetails_null_rec;
559:

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

552:
553: BEGIN
554: x_return_status := FND_API.G_RET_STS_SUCCESS;
555: CSM_UTIL_PKG.LOG('Entering CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_INITIALIZER for task_assignment_id: ' || p_task_assignment_id,
556: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_INITIALIZER',FND_LOG.LEVEL_PROCEDURE);
557:
558: l_TaskAssgDetails_rec := l_TaskAssgDetails_null_rec;
559:
560: OPEN l_TaskAssgDetails_csr(p_task_assignment_id);

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

561: FETCH l_TaskAssgDetails_csr INTO l_taskassgdetails_rec;
562: IF l_taskassgdetails_csr%NOTFOUND THEN
563: CLOSE l_taskassgdetails_csr;
564: CSM_UTIL_PKG.LOG('Not a mobile task_assignment_id: ' || p_task_assignment_id,
565: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_INITIALIZER',FND_LOG.LEVEL_PROCEDURE);
566: RETURN;
567: END IF;
568: CLOSE l_taskassgdetails_csr;
569:

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

665: END IF;
666: END IF;
667:
668: -- spawn debrief line ins
669: csm_task_assignment_event_pkg.spawn_debrief_line_ins(p_task_assignment_id=>p_task_assignment_id,
670: p_user_id=>l_taskassgdetails_rec.user_id,
671: p_flow_type=>NULL);
672:
673: -- spawn debrief header ins

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

670: p_user_id=>l_taskassgdetails_rec.user_id,
671: p_flow_type=>NULL);
672:
673: -- spawn debrief header ins
674: csm_task_assignment_event_pkg.spawn_debrief_header_ins(p_task_assignment_id=>p_task_assignment_id,
675: p_user_id=>l_taskassgdetails_rec.user_id,
676: p_flow_type=>NULL);
677:
678: -- spawn requirement lines ins

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

675: p_user_id=>l_taskassgdetails_rec.user_id,
676: p_flow_type=>NULL);
677:
678: -- spawn requirement lines ins
679: csm_task_assignment_event_pkg.spawn_requirement_lines_ins(p_task_assignment_id=>p_task_assignment_id,
680: p_user_id=>l_taskassgdetails_rec.user_id,
681: p_flow_type=>NULL);
682:
683: -- spawn requirement headers ins

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

680: p_user_id=>l_taskassgdetails_rec.user_id,
681: p_flow_type=>NULL);
682:
683: -- spawn requirement headers ins
684: csm_task_assignment_event_pkg.spawn_requirement_header_ins(p_task_assignment_id=>p_task_assignment_id,
685: p_user_id=>l_taskassgdetails_rec.user_id,
686: p_flow_type=>NULL);
687:
688: -- task_assignments_acc processor

Line 689: csm_task_assignment_event_pkg.task_assignments_acc_processor

685: p_user_id=>l_taskassgdetails_rec.user_id,
686: p_flow_type=>NULL);
687:
688: -- task_assignments_acc processor
689: csm_task_assignment_event_pkg.task_assignments_acc_processor
690: (p_task_assignment_id=>p_task_assignment_id,
691: p_incident_id=>l_taskassgdetails_rec.incident_id,
692: p_task_id=>l_taskassgdetails_rec.task_id,
693: p_source_object_type_code=>l_taskassgdetails_rec.source_object_type_code,

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

704: END IF;
705: END IF;
706:
707: -- lobs mdirty I
708: csm_task_assignment_event_pkg.lobs_mdirty_i(p_task_assignment_id=>p_task_assignment_id,
709: p_resource_id=>l_taskassgdetails_rec.resource_id);
710:
711: CSM_UTIL_PKG.LOG('Leaving CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_INITIALIZER for task_assignment_id: ' || p_task_assignment_id,
712: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_INITIALIZER',FND_LOG.LEVEL_PROCEDURE);

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

707: -- lobs mdirty I
708: csm_task_assignment_event_pkg.lobs_mdirty_i(p_task_assignment_id=>p_task_assignment_id,
709: p_resource_id=>l_taskassgdetails_rec.resource_id);
710:
711: CSM_UTIL_PKG.LOG('Leaving CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_INITIALIZER for task_assignment_id: ' || p_task_assignment_id,
712: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_INITIALIZER',FND_LOG.LEVEL_PROCEDURE);
713: EXCEPTION
714: WHEN OTHERS THEN
715: l_sqlerrno := to_char(SQLCODE);

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

708: csm_task_assignment_event_pkg.lobs_mdirty_i(p_task_assignment_id=>p_task_assignment_id,
709: p_resource_id=>l_taskassgdetails_rec.resource_id);
710:
711: CSM_UTIL_PKG.LOG('Leaving CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_INITIALIZER for task_assignment_id: ' || p_task_assignment_id,
712: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_INITIALIZER',FND_LOG.LEVEL_PROCEDURE);
713: EXCEPTION
714: WHEN OTHERS THEN
715: l_sqlerrno := to_char(SQLCODE);
716: l_sqlerrmsg := substr(SQLERRM, 1,2000);

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

716: l_sqlerrmsg := substr(SQLERRM, 1,2000);
717: x_return_status := FND_API.G_RET_STS_ERROR;
718: p_error_msg := ' Exception in TASK_ASSIGNMENT_INITIALIZER for task_assignment_id:' || to_char(p_task_assignment_id)
719: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
720: CSM_UTIL_PKG.LOG(p_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_INITIALIZER',FND_LOG.LEVEL_EXCEPTION);
721: RAISE;
722: END TASK_ASSIGNMENT_INITIALIZER;
723:
724: PROCEDURE TASK_ASSIGNMENT_HIST_INIT(p_task_assignment_id IN NUMBER,

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

792: BEGIN
793: x_return_status := FND_API.G_RET_STS_SUCCESS;
794: CSM_UTIL_PKG.LOG('Entering TASK_ASSIGNMENT_HIST_INIT for task_assignment_id: ' || p_task_assignment_id
795: || ' and parent_incident_id: ' || p_parent_incident_id,
796: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_HIST_INIT',FND_LOG.LEVEL_PROCEDURE);
797:
798: l_TaskAssgDetails_rec := l_TaskAssgDetails_null_rec;
799: l_flowtype := 'HISTORY';
800:

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

802: FETCH l_TaskAssgDetails_csr INTO l_taskassgdetails_rec;
803: IF l_taskassgdetails_csr%NOTFOUND THEN
804: CLOSE l_taskassgdetails_csr;
805: CSM_UTIL_PKG.LOG('No date found for history task_assignment_id: ' || p_task_assignment_id,
806: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_HIST_INIT',FND_LOG.LEVEL_EXCEPTION);
807: RETURN;
808: END IF;
809: CLOSE l_taskassgdetails_csr;
810:

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

856: x_return_status=>l_return_status);
857: END IF;
858:
859: -- spawn debrief line ins
860: csm_task_assignment_event_pkg.spawn_debrief_line_ins(p_task_assignment_id=>p_task_assignment_id,
861: p_user_id=>p_user_id,
862: p_flow_type=>l_flowtype);
863:
864: -- spawn debrief header ins

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

861: p_user_id=>p_user_id,
862: p_flow_type=>l_flowtype);
863:
864: -- spawn debrief header ins
865: csm_task_assignment_event_pkg.spawn_debrief_header_ins(p_task_assignment_id=>p_task_assignment_id,
866: p_user_id=>p_user_id,
867: p_flow_type=>l_flowtype);
868:
869: -- task_assignments_acc processor

Line 870: csm_task_assignment_event_pkg.task_assignments_acc_processor

866: p_user_id=>p_user_id,
867: p_flow_type=>l_flowtype);
868:
869: -- task_assignments_acc processor
870: csm_task_assignment_event_pkg.task_assignments_acc_processor
871: (p_task_assignment_id=>p_task_assignment_id,
872: p_incident_id=>l_taskassgdetails_rec.incident_id,
873: p_task_id=>l_taskassgdetails_rec.task_id,
874: p_source_object_type_code=>l_taskassgdetails_rec.source_object_type_code,

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

880: p_user_id=>p_user_id);
881:
882: CSM_UTIL_PKG.LOG('Leaving TASK_ASSIGNMENT_HIST_INIT for task_assignment_id: ' || p_task_assignment_id
883: || ' and parent_incident_id: ' || p_parent_incident_id,
884: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_HIST_INIT',FND_LOG.LEVEL_PROCEDURE);
885: EXCEPTION
886: WHEN OTHERS THEN
887: l_sqlerrno := to_char(SQLCODE);
888: l_sqlerrmsg := substr(SQLERRM, 1,2000);

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

888: l_sqlerrmsg := substr(SQLERRM, 1,2000);
889: x_return_status := FND_API.G_RET_STS_ERROR;
890: p_error_msg := ' Exception in TASK_ASSIGNMENT_HIST_INIT for task_assignment_id:' || p_task_assignment_id
891: || ' and parent_incident_id: ' || p_parent_incident_id || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
892: CSM_UTIL_PKG.LOG(p_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_HIST_INIT',FND_LOG.LEVEL_EXCEPTION);
893: RAISE;
894: END TASK_ASSIGNMENT_HIST_INIT;
895:
896: PROCEDURE TASK_ASSIGNMENT_PURGE_INIT (p_task_assignment_id IN NUMBER,

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

1001: l_task_assg_purge_null_rec l_task_assg_purge_csr%ROWTYPE;
1002:
1003: BEGIN
1004: CSM_UTIL_PKG.LOG('Entering TASK_ASSIGNMENT_PURGE_INIT for task_assignment_id: ' || p_task_assignment_id,
1005: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_PURGE_INIT',FND_LOG.LEVEL_PROCEDURE);
1006: l_task_assg_purge_rec := l_task_assg_purge_null_rec;
1007:
1008: OPEN l_task_assg_purge_csr(p_task_assignment_id);
1009: FETCH l_task_assg_purge_csr INTO l_task_assg_purge_rec;

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

1009: FETCH l_task_assg_purge_csr INTO l_task_assg_purge_rec;
1010: IF l_task_assg_purge_csr%NOTFOUND THEN
1011: CLOSE l_task_assg_purge_csr;
1012: CSM_UTIL_PKG.LOG('Not a mobile task_assignment_id: ' || p_task_assignment_id,
1013: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_PURGE_INIT',FND_LOG.LEVEL_PROCEDURE);
1014: RETURN;
1015: END IF;
1016: CLOSE l_task_assg_purge_csr;
1017: -- get Service Inv Validation org

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

1017: -- get Service Inv Validation org
1018: l_organization_id := csm_profile_pkg.get_organization_id(l_task_assg_purge_rec.user_id);
1019:
1020: -- lobs mdirty D
1021: csm_task_assignment_event_pkg.lobs_mdirty_D(p_task_assignment_id=>p_task_assignment_id,
1022: p_resource_id=>l_task_assg_purge_rec.resource_id);
1023:
1024: -- delete task notes
1025: csm_notes_event_pkg.notes_make_dirty_d_grp(p_sourceobjectcode=>'TASK',

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

1108: END IF;
1109: END IF;
1110:
1111: -- spawn debrief line del
1112: csm_task_assignment_event_pkg.spawn_debrief_line_del(p_task_assignment_id=>p_task_assignment_id,
1113: p_user_id=>l_task_assg_purge_rec.user_id,
1114: p_flow_type=>NULL);
1115:
1116: -- spawn debrief header del

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

1113: p_user_id=>l_task_assg_purge_rec.user_id,
1114: p_flow_type=>NULL);
1115:
1116: -- spawn debrief header del
1117: csm_task_assignment_event_pkg.spawn_debrief_header_del(p_task_assignment_id=>p_task_assignment_id,
1118: p_user_id=>l_task_assg_purge_rec.user_id,
1119: p_flow_type=>NULL);
1120:
1121: -- spawn requirement line del

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

1118: p_user_id=>l_task_assg_purge_rec.user_id,
1119: p_flow_type=>NULL);
1120:
1121: -- spawn requirement line del
1122: csm_task_assignment_event_pkg.spawn_requirement_lines_del(p_task_assignment_id=>p_task_assignment_id,
1123: p_user_id=>l_task_assg_purge_rec.user_id,
1124: p_flow_type=>NULL);
1125:
1126: -- spawn requirement header del

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

1123: p_user_id=>l_task_assg_purge_rec.user_id,
1124: p_flow_type=>NULL);
1125:
1126: -- spawn requirement header del
1127: csm_task_assignment_event_pkg.spawn_requirement_header_del(p_task_assignment_id=>p_task_assignment_id,
1128: p_user_id=>l_task_assg_purge_rec.user_id,
1129: p_flow_type=>NULL);
1130:
1131: -- delete SR history

Line 1139: csm_task_assignment_event_pkg.task_assignments_acc_d

1135: p_user_id=>l_task_assg_purge_rec.user_id);
1136: END IF;
1137:
1138: -- task_assignments_acc delete
1139: csm_task_assignment_event_pkg.task_assignments_acc_d
1140: (p_task_assignment_id=>p_task_assignment_id,
1141: p_incident_id=>l_task_assg_purge_rec.incident_id,
1142: p_task_id=>l_task_assg_purge_rec.task_id,
1143: p_source_object_type_code=>l_task_assg_purge_rec.source_object_type_code,

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

1144: p_flow_type=>NULL,
1145: p_user_id=>l_task_assg_purge_rec.user_id);
1146:
1147: CSM_UTIL_PKG.LOG('Leaving TASK_ASSIGNMENT_PURGE_INIT for task_assignment_id: ' || p_task_assignment_id,
1148: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_PURGE_INIT',FND_LOG.LEVEL_PROCEDURE);
1149: EXCEPTION
1150: WHEN OTHERS THEN
1151: l_sqlerrno := to_char(SQLCODE);
1152: l_sqlerrmsg := substr(SQLERRM, 1,2000);

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

1151: l_sqlerrno := to_char(SQLCODE);
1152: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1153: l_error_msg := ' Exception in TASK_ASSIGNMENT_PURGE_INIT for task_assignment_id:' || to_char(p_task_assignment_id)
1154: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1155: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_PURGE_INIT',FND_LOG.LEVEL_EXCEPTION);
1156: RAISE;
1157: END TASK_ASSIGNMENT_PURGE_INIT;
1158:
1159: --Bug 4938130

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

1185: ;
1186:
1187: BEGIN
1188: CSM_UTIL_PKG.LOG('Entering SPAWN_DEBRIEF_HEADER_DEL for task_assignment_id: ' || p_task_assignment_id,
1189: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_DEBRIEF_HEADER_DEL',FND_LOG.LEVEL_PROCEDURE);
1190:
1191: FOR r_debrief_header_rec IN l_debrief_header_csr(p_task_assignment_id, p_user_id) LOOP
1192: -- delete debrief headers
1193: csm_debrief_header_event_pkg.debrief_header_del_init(p_debrief_header_id=>r_debrief_header_rec.debrief_header_id,

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

1195: p_flow_type=>p_flow_type);
1196: END LOOP;
1197:
1198: CSM_UTIL_PKG.LOG('Leaving SPAWN_DEBRIEF_HEADER_DEL for task_assignment_id: ' || p_task_assignment_id,
1199: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_DEBRIEF_HEADER_DEL',FND_LOG.LEVEL_PROCEDURE);
1200: EXCEPTION
1201: WHEN OTHERS THEN
1202: l_sqlerrno := to_char(SQLCODE);
1203: l_sqlerrmsg := substr(SQLERRM, 1,2000);

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

1202: l_sqlerrno := to_char(SQLCODE);
1203: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1204: l_error_msg := ' Exception in SPAWN_DEBRIEF_HEADER_DEL for task_assignment_id:'
1205: || to_char(p_task_assignment_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1206: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_DEBRIEF_HEADER_DEL',FND_LOG.LEVEL_EXCEPTION);
1207: RAISE;
1208: END SPAWN_DEBRIEF_HEADER_DEL;
1209:
1210: PROCEDURE SPAWN_DEBRIEF_LINE_DEL (p_task_assignment_id IN NUMBER,

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

1232: ;
1233:
1234: BEGIN
1235: CSM_UTIL_PKG.LOG('Entering SPAWN_DEBRIEF_LINE_DEL for task_assignment_id: ' || p_task_assignment_id,
1236: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_DEBRIEF_DEL',FND_LOG.LEVEL_PROCEDURE);
1237:
1238: FOR r_debrief_line_rec IN l_debrief_lines_csr(p_task_assignment_id, p_user_id) LOOP
1239: -- delete debrief lines
1240: csm_debrief_event_pkg.debrief_line_del_init(p_debrief_line_id=>r_debrief_line_rec.debrief_line_id,

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

1243:
1244: END LOOP;
1245:
1246: CSM_UTIL_PKG.LOG('Leaving SPAWN_DEBRIEF_LINE_DEL for task_assignment_id: ' || p_task_assignment_id,
1247: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_DEBRIEF_DEL',FND_LOG.LEVEL_PROCEDURE);
1248: EXCEPTION
1249: WHEN OTHERS THEN
1250: l_sqlerrno := to_char(SQLCODE);
1251: l_sqlerrmsg := substr(SQLERRM, 1,2000);

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

1250: l_sqlerrno := to_char(SQLCODE);
1251: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1252: l_error_msg := ' Exception in SPAWN_DEBRIEF_LINE_DEL for task_assignment_id:'
1253: || to_char(p_task_assignment_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1254: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_DEBRIEF_LINE_DEL',FND_LOG.LEVEL_EXCEPTION);
1255: RAISE;
1256: END SPAWN_DEBRIEF_LINE_DEL;
1257:
1258: PROCEDURE SPAWN_REQUIREMENT_HEADER_DEL(p_task_assignment_id IN NUMBER,

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

1282: );
1283:
1284: BEGIN
1285: CSM_UTIL_PKG.LOG('Entering SPAWN_REQUIREMENT_HEADER_DEL for task_assignment_id: ' || p_task_assignment_id,
1286: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_REQUIREMENT_HEADER_DEL',FND_LOG.LEVEL_PROCEDURE);
1287:
1288: IF p_flow_type IS NULL OR p_flow_type <> 'HISTORY' THEN
1289: FOR r_req_headers_rec IN l_req_headers_csr(p_task_assignment_id, p_user_id) LOOP
1290: -- delete requirement headers

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

1293: END LOOP;
1294: END IF;
1295:
1296: CSM_UTIL_PKG.LOG('Leaving SPAWN_REQUIREMENT_HEADER_DEL for task_assignment_id: ' || p_task_assignment_id,
1297: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_REQUIREMENT_HEADER_DEL',FND_LOG.LEVEL_PROCEDURE);
1298: EXCEPTION
1299: WHEN OTHERS THEN
1300: l_sqlerrno := to_char(SQLCODE);
1301: l_sqlerrmsg := substr(SQLERRM, 1,2000);

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

1300: l_sqlerrno := to_char(SQLCODE);
1301: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1302: l_error_msg := ' Exception in SPAWN_REQUIREMENT_HEADER_DEL for task_assignment_id:'
1303: || to_char(p_task_assignment_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1304: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_REQUIREMENT_HEADER_DEL',FND_LOG.LEVEL_EXCEPTION);
1305: RAISE;
1306: END SPAWN_REQUIREMENT_HEADER_DEL;
1307:
1308: PROCEDURE SPAWN_REQUIREMENT_LINES_DEL(p_task_assignment_id IN NUMBER,

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

1332: AND acc.requirement_line_id = line.requirement_line_id;
1333:
1334: BEGIN
1335: CSM_UTIL_PKG.LOG('Entering SPAWN_REQUIREMENT_LINES_DEL for task_assignment_id: ' || p_task_assignment_id,
1336: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_REQUIREMENT_LINES_DEL',FND_LOG.LEVEL_PROCEDURE);
1337:
1338: IF p_flow_type IS NULL OR p_flow_type <> 'HISTORY' THEN
1339: FOR r_req_lines_rec IN l_req_lines_csr(p_task_assignment_id, p_user_id) LOOP
1340: -- delete requirement lines

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

1343: END LOOP;
1344: END IF;
1345:
1346: CSM_UTIL_PKG.LOG('Leaving SPAWN_REQUIREMENT_LINES_DEL for task_assignment_id: ' || p_task_assignment_id,
1347: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_REQUIREMENT_LINES_DEL',FND_LOG.LEVEL_PROCEDURE);
1348: EXCEPTION
1349: WHEN OTHERS THEN
1350: l_sqlerrno := to_char(SQLCODE);
1351: l_sqlerrmsg := substr(SQLERRM, 1,2000);

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

1350: l_sqlerrno := to_char(SQLCODE);
1351: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1352: l_error_msg := ' Exception in SPAWN_REQUIREMENT_LINES_DEL for task_assignment_id:'
1353: || to_char(p_task_assignment_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1354: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.SPAWN_REQUIREMENT_LINES_DEL',FND_LOG.LEVEL_EXCEPTION);
1355: RAISE;
1356: END SPAWN_REQUIREMENT_LINES_DEL;
1357:
1358: PROCEDURE TASK_ASSIGNMENTS_ACC_D(p_task_assignment_id IN NUMBER,

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

1368: l_return_status VARCHAR2(2000);
1369:
1370: BEGIN
1371: CSM_UTIL_PKG.LOG('Entering TASK_ASSIGNMENTS_ACC_D for task_assignment_id: ' || p_task_assignment_id,
1372: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENTS_ACC_D',FND_LOG.LEVEL_PROCEDURE);
1373:
1374: IF p_source_object_type_code = 'SR' THEN
1375: csm_sr_event_pkg.incidents_acc_d(p_incident_id=>p_incident_id,
1376: p_user_id=>p_user_id);

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

1384: -- delete tasks
1385: csm_task_event_pkg.acc_delete(p_user_id=>p_user_id, p_task_id=>p_task_id);
1386:
1387: -- delete task assignments
1388: csm_task_assignment_event_pkg.acc_delete(p_task_assignment_id=>p_task_assignment_id,
1389: p_user_id=>p_user_id);
1390:
1391: CSM_UTIL_PKG.LOG('Leaving TASK_ASSIGNMENTS_ACC_D for task_assignment_id: ' || p_task_assignment_id,
1392: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENTS_ACC_D',FND_LOG.LEVEL_PROCEDURE);

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

1388: csm_task_assignment_event_pkg.acc_delete(p_task_assignment_id=>p_task_assignment_id,
1389: p_user_id=>p_user_id);
1390:
1391: CSM_UTIL_PKG.LOG('Leaving TASK_ASSIGNMENTS_ACC_D for task_assignment_id: ' || p_task_assignment_id,
1392: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENTS_ACC_D',FND_LOG.LEVEL_PROCEDURE);
1393: EXCEPTION
1394: WHEN OTHERS THEN
1395: l_sqlerrno := to_char(SQLCODE);
1396: l_sqlerrmsg := substr(SQLERRM, 1,2000);

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

1395: l_sqlerrno := to_char(SQLCODE);
1396: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1397: l_error_msg := ' Exception in TASK_ASSIGNMENTS_ACC_D for task_assignment_id:'
1398: || to_char(p_task_assignment_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1399: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENTS_ACC_D',FND_LOG.LEVEL_EXCEPTION);
1400: RAISE;
1401: END TASK_ASSIGNMENTS_ACC_D;
1402:
1403: PROCEDURE ACC_DELETE(p_task_assignment_id IN NUMBER, p_user_id IN NUMBER)

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

1408: l_return_status VARCHAR2(2000);
1409:
1410: BEGIN
1411: CSM_UTIL_PKG.LOG('Entering ACC_DELETE for task_assignment_id: ' || p_task_assignment_id,
1412: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.ACC_DELETE',FND_LOG.LEVEL_PROCEDURE);
1413:
1414: CSM_ACC_PKG.Delete_Acc
1415: ( P_PUBLICATION_ITEM_NAMES => g_pubi_name
1416: ,P_ACC_TABLE_NAME => g_acc_table_name

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

1419: ,P_USER_ID => p_user_id
1420: );
1421:
1422: CSM_UTIL_PKG.LOG('Leaving ACC_DELETE for task_assignment_id: ' || p_task_assignment_id,
1423: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.ACC_DELETE',FND_LOG.LEVEL_PROCEDURE);
1424: EXCEPTION
1425: WHEN OTHERS THEN
1426: l_sqlerrno := to_char(SQLCODE);
1427: l_sqlerrmsg := substr(SQLERRM, 1,2000);

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

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

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

1504: BEGIN
1505: x_return_status := FND_API.G_RET_STS_SUCCESS;
1506: CSM_UTIL_PKG.LOG('Entering TASK_ASSIGNMENT_HIST_DEL_INIT for task_assignment_id: ' || p_task_assignment_id
1507: || ' and parent_incident_id: ' || p_parent_incident_id,
1508: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_HIST_DEL_INIT',FND_LOG.LEVEL_PROCEDURE);
1509:
1510: l_TaskAssgHistPurge_rec := l_TaskAssgHistPurge_null_rec;
1511: l_flowtype := 'HISTORY';
1512:

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

1514: FETCH l_TaskAssgHistPurge_csr INTO l_TaskAssgHistPurge_rec;
1515: IF l_TaskAssgHistPurge_csr%NOTFOUND THEN
1516: CLOSE l_TaskAssgHistPurge_csr;
1517: CSM_UTIL_PKG.LOG('No date found for history task_assignment_id: ' || p_task_assignment_id,
1518: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_HIST_INIT',FND_LOG.LEVEL_EXCEPTION);
1519: RETURN;
1520: END IF;
1521: CLOSE l_TaskAssgHistPurge_csr;
1522:

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

1563: x_return_status=>l_return_status);
1564: END IF;
1565:
1566: -- spawn debrief line del
1567: csm_task_assignment_event_pkg.spawn_debrief_line_del(p_task_assignment_id=>p_task_assignment_id,
1568: p_user_id=>p_user_id,
1569: p_flow_type=>l_flowtype);
1570:
1571: -- spawn debrief header del

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

1568: p_user_id=>p_user_id,
1569: p_flow_type=>l_flowtype);
1570:
1571: -- spawn debrief header del
1572: csm_task_assignment_event_pkg.spawn_debrief_header_del(p_task_assignment_id=>p_task_assignment_id,
1573: p_user_id=>p_user_id,
1574: p_flow_type=>l_flowtype);
1575:
1576: -- resource extns acc del

Line 1581: csm_task_assignment_event_pkg.task_assignments_acc_d

1577: csm_resource_extns_event_pkg.resource_extns_acc_d(p_resource_id=>l_TaskAssgHistPurge_rec.resource_id,
1578: p_user_id=>p_user_id);
1579:
1580: -- task_assignments_acc delete
1581: csm_task_assignment_event_pkg.task_assignments_acc_d
1582: (p_task_assignment_id=>p_task_assignment_id,
1583: p_incident_id=>l_TaskAssgHistPurge_rec.incident_id,
1584: p_task_id=>l_TaskAssgHistPurge_rec.task_id,
1585: p_source_object_type_code=>l_TaskAssgHistPurge_rec.source_object_type_code,

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

1587: p_user_id=>p_user_id);
1588:
1589: CSM_UTIL_PKG.LOG('Leaving TASK_ASSIGNMENT_HIST_DEL_INIT for task_assignment_id: ' || p_task_assignment_id
1590: || ' and parent_incident_id: ' || p_parent_incident_id,
1591: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_HIST_DEL_INIT',FND_LOG.LEVEL_PROCEDURE);
1592: EXCEPTION
1593: WHEN OTHERS THEN
1594: l_sqlerrno := to_char(SQLCODE);
1595: l_sqlerrmsg := substr(SQLERRM, 1,2000);

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

1595: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1596: x_return_status := FND_API.G_RET_STS_ERROR;
1597: p_error_msg := ' Exception in TASK_ASSIGNMENT_HIST_DEL_INIT for task_assignment_id:' || p_task_assignment_id
1598: || ' and parent_incident_id: ' || p_parent_incident_id || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1599: CSM_UTIL_PKG.LOG(p_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_HIST_DEL_INIT',FND_LOG.LEVEL_EXCEPTION);
1600: RAISE;
1601: END TASK_ASSIGNMENT_HIST_DEL_INIT;
1602:
1603: END CSM_TASK_ASSIGNMENT_EVENT_PKG;

Line 1603: END CSM_TASK_ASSIGNMENT_EVENT_PKG;

1599: CSM_UTIL_PKG.LOG(p_error_msg, 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_HIST_DEL_INIT',FND_LOG.LEVEL_EXCEPTION);
1600: RAISE;
1601: END TASK_ASSIGNMENT_HIST_DEL_INIT;
1602:
1603: END CSM_TASK_ASSIGNMENT_EVENT_PKG;