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 FND_LOG

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 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 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 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 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 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 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 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 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 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 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;