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