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.

[Home] [Help]

APPS.CSM_TASK_ASSIGNMENT_EVENT_PKG dependencies on CSM_UTIL_PKG

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 170: CSM_UTIL_PKG.LOG('Entering SPAWN_DEBRIEF_HEADER_INS for task_assignment_id: ' || p_task_assignment_id,

166: WHERE acc.debrief_header_id = dh.debrief_header_id
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

Line 180: CSM_UTIL_PKG.LOG('Leaving SPAWN_DEBRIEF_HEADER_INS for task_assignment_id: ' || p_task_assignment_id,

176: p_h_user_id=>p_user_id,
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);

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 217: CSM_UTIL_PKG.LOG('Entering SPAWN_DEBRIEF_LINE_INS for task_assignment_id: ' || p_task_assignment_id,

213: WHERE acc.debrief_line_id = dl.debrief_line_id
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

Line 227: CSM_UTIL_PKG.LOG('Leaving SPAWN_DEBRIEF_LINE_INS for task_assignment_id: ' || p_task_assignment_id,

223: p_h_user_id=>p_user_id,
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);

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 266: CSM_UTIL_PKG.LOG('Entering SPAWN_REQUIREMENT_HEADER_INS for task_assignment_id: ' || p_task_assignment_id,

262: AND acc.user_id = p_user_id
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

Line 277: CSM_UTIL_PKG.LOG('Leaving SPAWN_REQUIREMENT_HEADER_INS for task_assignment_id: ' || p_task_assignment_id,

273: p_user_id=>p_user_id);
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);

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_UTIL_PKG.LOG('Entering SPAWN_REQUIREMENTS_INS for task_assignment_id: ' || p_task_assignment_id,

316: AND acc.user_id = au.user_id
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

Line 335: CSM_UTIL_PKG.LOG('Leaving SPAWN_REQUIREMENTS_INS for task_assignment_id: ' || p_task_assignment_id,

331: END LOOP;
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);

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 368: CSM_UTIL_PKG.LOG('Entering TASK_ASSIGNMENTS_ACC_PROCESSOR for task_assignment_id: ' || p_task_assignment_id,

364: WHERE user_id = p_user_id
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);

Line 374: IF (NOT CSM_UTIL_PKG.IS_HTML5_USER(p_user_id) AND (p_flow_type IS NULL OR p_flow_type <> 'HISTORY')) THEN

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:
374: IF (NOT CSM_UTIL_PKG.IS_HTML5_USER(p_user_id) AND (p_flow_type IS NULL OR p_flow_type <> 'HISTORY')) THEN
375: csm_contract_event_pkg.sr_contract_acc_i(p_incident_id=>p_incident_id,p_user_id=>p_user_id);
376: END IF ;
377: END IF;
378:

Line 401: CSM_UTIL_PKG.LOG('Leaving TASK_ASSIGNMENTS_ACC_PROCESSOR for task_assignment_id: ' || p_task_assignment_id,

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

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 421: CSM_UTIL_PKG.LOG('Entering ACC_INSERT for task_assignment_id: ' || p_task_assignment_id,

417: l_error_msg VARCHAR2(4000);
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

Line 433: CSM_UTIL_PKG.LOG('Leaving ACC_INSERT for task_assignment_id: ' || p_task_assignment_id,

429: ,P_PK1_NUM_VALUE => p_task_assignment_id
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);

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

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

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

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

Line 574: CSM_UTIL_PKG.LOG('Not a mobile task_assignment_id: ' || p_task_assignment_id,

570: OPEN l_TaskAssgDetails_csr(p_task_assignment_id);
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;

Line 580: l_htm5_user :=CSM_UTIL_PKG.IS_HTML5_USER(l_taskassgdetails_rec.user_id);

576: RETURN;
577: END IF;
578: CLOSE l_taskassgdetails_csr;
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;

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 753: CSM_UTIL_PKG.LOG('Leaving CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENT_INITIALIZER for task_assignment_id: ' || p_task_assignment_id,

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

Line 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 836: CSM_UTIL_PKG.LOG('Entering TASK_ASSIGNMENT_HIST_INIT for task_assignment_id: ' || p_task_assignment_id

832: l_TaskAssgDetails_null_rec l_TaskAssgDetails_csr%ROWTYPE;
833:
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;

Line 847: CSM_UTIL_PKG.LOG('No date found for history task_assignment_id: ' || p_task_assignment_id,

843: OPEN l_TaskAssgDetails_csr(p_task_assignment_id);
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;

Line 924: CSM_UTIL_PKG.LOG('Leaving TASK_ASSIGNMENT_HIST_INIT for task_assignment_id: ' || p_task_assignment_id

920: -- resource extns acc
921: csm_resource_extns_event_pkg.resource_extns_acc_i(p_resource_id=>l_taskassgdetails_rec.resource_id,
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

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 1053: CSM_UTIL_PKG.LOG('Entering TASK_ASSIGNMENT_PURGE_INIT for task_assignment_id: ' || p_task_assignment_id,

1049: l_task_assg_purge_null_rec l_task_assg_purge_csr%ROWTYPE;
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);

Line 1061: CSM_UTIL_PKG.LOG('Not a mobile task_assignment_id: ' || p_task_assignment_id,

1057: OPEN l_task_assg_purge_csr(p_task_assignment_id);
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;

Line 1069: l_htm5_user:=csm_util_pkg.is_html5_user(l_task_assg_purge_rec.user_id);

1065: CLOSE l_task_assg_purge_csr;
1066: -- get Service Inv Validation org
1067: l_organization_id := csm_profile_pkg.get_organization_id(l_task_assg_purge_rec.user_id);
1068:
1069: l_htm5_user:=csm_util_pkg.is_html5_user(l_task_assg_purge_rec.user_id);
1070:
1071: --html5 functionality
1072: IF l_task_assg_purge_rec.ADDRESS_ID IS NOT NULL AND l_htm5_user THEN
1073: csm_party_site_event_pkg.party_sites_acc_d(p_party_site_id => l_task_assg_purge_rec.ADDRESS_ID,

Line 1215: CSM_UTIL_PKG.LOG('Leaving TASK_ASSIGNMENT_PURGE_INIT for task_assignment_id: ' || p_task_assignment_id,

1211: p_source_object_type_code=>l_task_assg_purge_rec.source_object_type_code,
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);

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 1256: CSM_UTIL_PKG.LOG('Entering SPAWN_DEBRIEF_HEADER_DEL for task_assignment_id: ' || p_task_assignment_id,

1252: AND acc.user_id = p_user_id
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

Line 1266: CSM_UTIL_PKG.LOG('Leaving SPAWN_DEBRIEF_HEADER_DEL for task_assignment_id: ' || p_task_assignment_id,

1262: p_user_id=>p_user_id,
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);

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 1303: CSM_UTIL_PKG.LOG('Entering SPAWN_DEBRIEF_LINE_DEL for task_assignment_id: ' || p_task_assignment_id,

1299: AND acc.user_id = p_user_id
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

Line 1314: CSM_UTIL_PKG.LOG('Leaving SPAWN_DEBRIEF_LINE_DEL for task_assignment_id: ' || p_task_assignment_id,

1310: p_flow_type=>p_flow_type);
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);

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 1353: CSM_UTIL_PKG.LOG('Entering SPAWN_REQUIREMENT_HEADER_DEL for task_assignment_id: ' || p_task_assignment_id,

1349: AND acc.user_id = p_user_id
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

Line 1364: CSM_UTIL_PKG.LOG('Leaving SPAWN_REQUIREMENT_HEADER_DEL for task_assignment_id: ' || p_task_assignment_id,

1360: p_user_id=>p_user_id);
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);

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 1404: CSM_UTIL_PKG.LOG('Entering SPAWN_REQUIREMENT_LINES_DEL for task_assignment_id: ' || p_task_assignment_id,

1400: AND acc.requirement_line_id = line.requirement_line_id
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

Line 1420: CSM_UTIL_PKG.LOG('Leaving SPAWN_REQUIREMENT_LINES_DEL for task_assignment_id: ' || p_task_assignment_id,

1416: END LOOP;
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);

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 1445: CSM_UTIL_PKG.LOG('Entering TASK_ASSIGNMENTS_ACC_D for task_assignment_id: ' || p_task_assignment_id,

1441: l_error_msg VARCHAR2(4000);
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);

Line 1451: IF (NOT CSM_UTIL_PKG.IS_HTML5_USER(p_user_id) AND (p_flow_type IS NULL OR p_flow_type <> 'HISTORY')) THEN

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:
1451: IF (NOT CSM_UTIL_PKG.IS_HTML5_USER(p_user_id) AND (p_flow_type IS NULL OR p_flow_type <> 'HISTORY')) THEN
1452: csm_contract_event_pkg.sr_contract_acc_d(p_incident_id=>p_incident_id,p_user_id=>p_user_id);
1453: END IF ;
1454: END IF;
1455:

Line 1463: CSM_UTIL_PKG.LOG('Leaving TASK_ASSIGNMENTS_ACC_D for task_assignment_id: ' || p_task_assignment_id,

1459: -- delete task assignments
1460: csm_task_assignment_event_pkg.acc_delete(p_task_assignment_id=>p_task_assignment_id,
1461: p_user_id=>p_user_id);
1462:
1463: CSM_UTIL_PKG.LOG('Leaving TASK_ASSIGNMENTS_ACC_D for task_assignment_id: ' || p_task_assignment_id,
1464: 'CSM_TASK_ASSIGNMENT_EVENT_PKG.TASK_ASSIGNMENTS_ACC_D',FND_LOG.LEVEL_PROCEDURE);
1465: EXCEPTION
1466: WHEN OTHERS THEN
1467: l_sqlerrno := to_char(SQLCODE);

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 1483: CSM_UTIL_PKG.LOG('Entering ACC_DELETE for task_assignment_id: ' || p_task_assignment_id,

1479: l_error_msg VARCHAR2(4000);
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

Line 1494: CSM_UTIL_PKG.LOG('Leaving ACC_DELETE for task_assignment_id: ' || p_task_assignment_id,

1490: ,P_PK1_NUM_VALUE => p_task_assignment_id
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);

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 1578: CSM_UTIL_PKG.LOG('Entering TASK_ASSIGNMENT_HIST_DEL_INIT for task_assignment_id: ' || p_task_assignment_id

1574: l_TaskAssgHistPurge_null_rec l_TaskAssgHistPurge_csr%ROWTYPE;
1575:
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;

Line 1589: CSM_UTIL_PKG.LOG('No date found for history task_assignment_id: ' || p_task_assignment_id,

1585: OPEN l_TaskAssgHistPurge_csr(p_task_assignment_id);
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;

Line 1661: CSM_UTIL_PKG.LOG('Leaving TASK_ASSIGNMENT_HIST_DEL_INIT for task_assignment_id: ' || p_task_assignment_id

1657: p_source_object_type_code=>l_TaskAssgHistPurge_rec.source_object_type_code,
1658: p_flow_type=>l_flowtype,
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

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;