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_SR_EVENT_PKG dependencies on CSM_UTIL_PKG

Line 53: AND decode(CSM_UTIL_PKG.get_group_owner(inc.owner_group_id),

49: FROM csm_incidents_all_acc acc,
50: cs_incidents_all_b inc,
51: cs_incident_statuses_b ists
52: WHERE inc.incident_id = acc.incident_id
53: AND decode(CSM_UTIL_PKG.get_group_owner(inc.owner_group_id),
54: -1,
55: CSM_UTIL_PKG.get_owner(inc.created_by),
56: CSM_UTIL_PKG.get_group_owner(inc.owner_group_id)) = acc.user_id
57: AND (inc.creation_date < (SYSDATE - csm_profile_pkg.get_task_history_days(acc.user_id)))

Line 55: CSM_UTIL_PKG.get_owner(inc.created_by),

51: cs_incident_statuses_b ists
52: WHERE inc.incident_id = acc.incident_id
53: AND decode(CSM_UTIL_PKG.get_group_owner(inc.owner_group_id),
54: -1,
55: CSM_UTIL_PKG.get_owner(inc.created_by),
56: CSM_UTIL_PKG.get_group_owner(inc.owner_group_id)) = acc.user_id
57: AND (inc.creation_date < (SYSDATE - csm_profile_pkg.get_task_history_days(acc.user_id)))
58: AND inc.INCIDENT_STATUS_ID = ists.INCIDENT_STATUS_ID
59: AND ists.CLOSE_FLAG = 'Y';

Line 56: CSM_UTIL_PKG.get_group_owner(inc.owner_group_id)) = acc.user_id

52: WHERE inc.incident_id = acc.incident_id
53: AND decode(CSM_UTIL_PKG.get_group_owner(inc.owner_group_id),
54: -1,
55: CSM_UTIL_PKG.get_owner(inc.created_by),
56: CSM_UTIL_PKG.get_group_owner(inc.owner_group_id)) = acc.user_id
57: AND (inc.creation_date < (SYSDATE - csm_profile_pkg.get_task_history_days(acc.user_id)))
58: AND inc.INCIDENT_STATUS_ID = ists.INCIDENT_STATUS_ID
59: AND ists.CLOSE_FLAG = 'Y';
60:

Line 94: CSM_UTIL_PKG.LOG(TO_CHAR(l_incident_tbl.COUNT) || ' records sent for purge', 'CSM_SR_EVENT_PKG.PURGE_INCIDENTS_CONC',FND_LOG.LEVEL_EVENT);

90:
91: FETCH l_purge_incidents_csr BULK COLLECT INTO l_incident_tbl,l_userid_tbl,l_cnt_tbl LIMIT 50;
92: EXIT WHEN l_incident_tbl.COUNT = 0;
93:
94: CSM_UTIL_PKG.LOG(TO_CHAR(l_incident_tbl.COUNT) || ' records sent for purge', 'CSM_SR_EVENT_PKG.PURGE_INCIDENTS_CONC',FND_LOG.LEVEL_EVENT);
95:
96: FOR I IN 1..l_incident_tbl.count
97: LOOP
98: l_incident_id:=l_incident_tbl(I);

Line 135: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SR_EVENT_PKG.PURGE_INCIDENTS_CONC',FND_LOG.LEVEL_EVENT);

131: l_error_msg := ' Exception in Purge_incidents_conc for incident_id:'
132: || to_char(l_incident_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
133: p_status := 'ERROR';
134: p_message := 'Error in CSM_SR_EVENT_PKG.PURGE_INCIDENTS_CONC: ' || l_error_msg;
135: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SR_EVENT_PKG.PURGE_INCIDENTS_CONC',FND_LOG.LEVEL_EVENT);
136: -- x_return_status := FND_API.G_RET_STS_ERROR ;
137: -- RAISE;
138: END PURGE_INCIDENTS_CONC;
139:

Line 160: CSM_UTIL_PKG.LOG('Entering CSM_SR_EVENT_PKG.IS_SR_TASK for task_id: ' || p_task_id,

156: AND tsk.SCHEDULED_END_DATE IS NOT NULL
157: ;
158:
159: BEGIN
160: CSM_UTIL_PKG.LOG('Entering CSM_SR_EVENT_PKG.IS_SR_TASK for task_id: ' || p_task_id,
161: 'CSM_SR_EVENT_PKG.IS_SR_TASK',FND_LOG.LEVEL_PROCEDURE);
162:
163: l_source_object_type_code := NULL;
164:

Line 169: CSM_UTIL_PKG.LOG('Not a mobile Task Type for task_id: ' || p_task_id,

165: OPEN l_jtf_tasks_csr(p_task_id);
166: FETCH l_jtf_tasks_csr INTO l_source_object_type_code;
167: IF l_jtf_tasks_csr%NOTFOUND THEN
168: CLOSE l_jtf_tasks_csr;
169: CSM_UTIL_PKG.LOG('Not a mobile Task Type for task_id: ' || p_task_id,
170: 'CSM_SR_EVENT_PKG.IS_SR_TASK',FND_LOG.LEVEL_EXCEPTION);
171: RETURN FALSE;
172: END IF;
173: CLOSE l_jtf_tasks_csr;

Line 176: CSM_UTIL_PKG.LOG('Leaving CSM_SR_EVENT_PKG.IS_SR_TASK for task_id: ' || p_task_id,

172: END IF;
173: CLOSE l_jtf_tasks_csr;
174:
175: IF (l_source_object_type_code IN ('SR', 'TASK') OR l_source_object_type_code IS NULL) THEN
176: CSM_UTIL_PKG.LOG('Leaving CSM_SR_EVENT_PKG.IS_SR_TASK for task_id: ' || p_task_id,
177: 'CSM_SR_EVENT_PKG.IS_SR_TASK', FND_LOG.LEVEL_PROCEDURE);
178: RETURN TRUE;
179: ELSE
180: CSM_UTIL_PKG.LOG('Not a mobile Task Type for task_id: ' || p_task_id,

Line 180: CSM_UTIL_PKG.LOG('Not a mobile Task Type for task_id: ' || p_task_id,

176: CSM_UTIL_PKG.LOG('Leaving CSM_SR_EVENT_PKG.IS_SR_TASK for task_id: ' || p_task_id,
177: 'CSM_SR_EVENT_PKG.IS_SR_TASK', FND_LOG.LEVEL_PROCEDURE);
178: RETURN TRUE;
179: ELSE
180: CSM_UTIL_PKG.LOG('Not a mobile Task Type for task_id: ' || p_task_id,
181: 'CSM_SR_EVENT_PKG.IS_SR_TASK',FND_LOG.LEVEL_EXCEPTION);
182: RETURN FALSE;
183: END IF;
184:

Line 191: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SR_EVENT_PKG.IS_SR_TASK',FND_LOG.LEVEL_EXCEPTION);

187: l_sqlerrno := to_char(SQLCODE);
188: l_sqlerrmsg := substr(SQLERRM, 1,2000);
189: l_error_msg := ' Exception in IS_SR_TASK for task_id:' || to_char(p_task_id)
190: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
191: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SR_EVENT_PKG.IS_SR_TASK',FND_LOG.LEVEL_EXCEPTION);
192: RETURN FALSE;
193: END IS_SR_TASK;
194:
195: FUNCTION IS_TASK_STATUS_DOWNLOADABLE(p_task_id IN NUMBER)

Line 217: CSM_UTIL_PKG.LOG('Entering CSM_SR_EVENT_PKG.IS_TASK_STATUS_DOWNLOADABLE for task_id: ' || p_task_id,

213: OR jts.completed_flag = 'Y'
214: ));
215:
216: BEGIN
217: CSM_UTIL_PKG.LOG('Entering CSM_SR_EVENT_PKG.IS_TASK_STATUS_DOWNLOADABLE for task_id: ' || p_task_id,
218: 'CSM_SR_EVENT_PKG.IS_TASK_STATUS_DOWNLOADABLE',FND_LOG.LEVEL_PROCEDURE);
219:
220: OPEN l_jtf_task_status_csr(p_task_id);
221: FETCH l_jtf_task_status_csr INTO l_dummy;

Line 224: CSM_UTIL_PKG.LOG('Task Status not downloadable for task_id: ' || p_task_id,

220: OPEN l_jtf_task_status_csr(p_task_id);
221: FETCH l_jtf_task_status_csr INTO l_dummy;
222: IF l_jtf_task_status_csr%NOTFOUND THEN
223: CLOSE l_jtf_task_status_csr;
224: CSM_UTIL_PKG.LOG('Task Status not downloadable for task_id: ' || p_task_id,
225: 'CSM_SR_EVENT_PKG.IS_TASK_STATUS_DOWNLOADABLE',FND_LOG.LEVEL_EXCEPTION);
226: RETURN FALSE;
227: END IF;
228: CLOSE l_jtf_task_status_csr;

Line 230: CSM_UTIL_PKG.LOG('Leaving CSM_SR_EVENT_PKG.IS_TASK_STATUS_DOWNLOADABLE for task_id: ' || p_task_id,

226: RETURN FALSE;
227: END IF;
228: CLOSE l_jtf_task_status_csr;
229:
230: CSM_UTIL_PKG.LOG('Leaving CSM_SR_EVENT_PKG.IS_TASK_STATUS_DOWNLOADABLE for task_id: ' || p_task_id,
231: 'CSM_SR_EVENT_PKG.IS_TASK_STATUS_DOWNLOADABLE',FND_LOG.LEVEL_PROCEDURE);
232:
233: RETURN TRUE;
234: EXCEPTION

Line 240: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SR_EVENT_PKG.IS_TASK_STATUS_DOWNLOADABLE',FND_LOG.LEVEL_EXCEPTION);

236: l_sqlerrno := to_char(SQLCODE);
237: l_sqlerrmsg := substr(SQLERRM, 1,2000);
238: l_error_msg := ' Exception in IS_TASK_STATUS_DOWNLOADABLE for task_id:' || to_char(p_task_id)
239: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
240: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SR_EVENT_PKG.IS_TASK_STATUS_DOWNLOADABLE',FND_LOG.LEVEL_EXCEPTION);
241: RETURN FALSE;
242: END IS_TASK_STATUS_DOWNLOADABLE;
243:
244: FUNCTION IS_ASSGN_STATUS_DOWNLOADABLE(p_task_assignment_id IN NUMBER)

Line 268: CSM_UTIL_PKG.LOG('Entering CSM_SR_EVENT_PKG.IS_ASSGN_STATUS_DOWNLOADABLE for task_assignment_id: ' || p_task_assignment_id,

264: OR jts.completed_flag = 'Y'
265: ));
266:
267: BEGIN
268: CSM_UTIL_PKG.LOG('Entering CSM_SR_EVENT_PKG.IS_ASSGN_STATUS_DOWNLOADABLE for task_assignment_id: ' || p_task_assignment_id,
269: 'CSM_SR_EVENT_PKG.IS_ASSGN_STATUS_DOWNLOADABLE',FND_LOG.LEVEL_PROCEDURE);
270:
271: OPEN l_jtf_task_assg_status_csr(p_task_assignment_id);
272: FETCH l_jtf_task_assg_status_csr INTO l_dummy;

Line 275: CSM_UTIL_PKG.LOG('Task Assignment Status not downloadable for task_assignment_id: ' || p_task_assignment_id,

271: OPEN l_jtf_task_assg_status_csr(p_task_assignment_id);
272: FETCH l_jtf_task_assg_status_csr INTO l_dummy;
273: IF l_jtf_task_assg_status_csr%NOTFOUND THEN
274: CLOSE l_jtf_task_assg_status_csr;
275: CSM_UTIL_PKG.LOG('Task Assignment Status not downloadable for task_assignment_id: ' || p_task_assignment_id,
276: 'CSM_SR_EVENT_PKG.IS_ASSGN_STATUS_DOWNLOADABLE',FND_LOG.LEVEL_EXCEPTION);
277: RETURN FALSE;
278: END IF;
279: CLOSE l_jtf_task_assg_status_csr;

Line 281: CSM_UTIL_PKG.LOG('Leaving CSM_SR_EVENT_PKG.IS_ASSGN_STATUS_DOWNLOADABLE for task_assignment_id: ' || p_task_assignment_id,

277: RETURN FALSE;
278: END IF;
279: CLOSE l_jtf_task_assg_status_csr;
280:
281: CSM_UTIL_PKG.LOG('Leaving CSM_SR_EVENT_PKG.IS_ASSGN_STATUS_DOWNLOADABLE for task_assignment_id: ' || p_task_assignment_id,
282: 'CSM_SR_EVENT_PKG.IS_ASSGN_STATUS_DOWNLOADABLE',FND_LOG.LEVEL_PROCEDURE);
283:
284: RETURN TRUE;
285: EXCEPTION

Line 291: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SR_EVENT_PKG.IS_ASSGN_STATUS_DOWNLOADABLE',FND_LOG.LEVEL_EXCEPTION);

287: l_sqlerrno := to_char(SQLCODE);
288: l_sqlerrmsg := substr(SQLERRM, 1,2000);
289: l_error_msg := ' Exception in IS_ASSGN_STATUS_DOWNLOADABLE for task_assignment_id:' || to_char(p_task_assignment_id)
290: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
291: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SR_EVENT_PKG.IS_ASSGN_STATUS_DOWNLOADABLE',FND_LOG.LEVEL_EXCEPTION);
292: RETURN FALSE;
293: END IS_ASSGN_STATUS_DOWNLOADABLE;
294:
295: PROCEDURE SPAWN_SR_CONTACTS_INS(p_incident_id IN NUMBER, p_sr_contact_point_id IN NUMBER,

Line 326: CSM_UTIL_PKG.LOG('Entering CSM_SR_EVENT_PKG.SPAWN_SR_CONTACTS_INS for incident_id: ' || p_incident_id,

322: AND SYSDATE BETWEEN jtrs.start_date_active AND nvl(jtrs.end_date_active, SYSDATE)
323: ;
324:
325: BEGIN
326: CSM_UTIL_PKG.LOG('Entering CSM_SR_EVENT_PKG.SPAWN_SR_CONTACTS_INS for incident_id: ' || p_incident_id,
327: 'CSM_SR_EVENT_PKG.SPAWN_SR_CONTACTS_INS',FND_LOG.LEVEL_PROCEDURE);
328:
329: FOR r_srcontpts_rec IN l_srcontpts_csr(p_incident_id, p_sr_contact_point_id) LOOP
330: IF r_srcontpts_rec.contact_type = 'EMPLOYEE' THEN

Line 353: CSM_UTIL_PKG.LOG('Leaving CSM_SR_EVENT_PKG.SPAWN_SR_CONTACTS_INS for task_assignment_id: ' || p_incident_id,

349: csm_sr_contact_event_pkg.sr_cntact_mdirty_i(p_sr_contact_point_id=>r_srcontpts_rec.sr_contact_point_id,
350: p_user_id=>p_user_id);
351: END LOOP;
352:
353: CSM_UTIL_PKG.LOG('Leaving CSM_SR_EVENT_PKG.SPAWN_SR_CONTACTS_INS for task_assignment_id: ' || p_incident_id,
354: 'CSM_SR_EVENT_PKG.SPAWN_SR_CONTACTS_INS',FND_LOG.LEVEL_PROCEDURE);
355: EXCEPTION
356: WHEN OTHERS THEN
357: l_sqlerrno := to_char(SQLCODE);

Line 361: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SR_EVENT_PKG.SPAWN_SR_CONTACTS_INS',FND_LOG.LEVEL_EXCEPTION);

357: l_sqlerrno := to_char(SQLCODE);
358: l_sqlerrmsg := substr(SQLERRM, 1,2000);
359: l_error_msg := ' Exception in SPAWN_SR_CONTACTS_INS for incident_id:' || to_char(p_incident_id)
360: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
361: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SR_EVENT_PKG.SPAWN_SR_CONTACTS_INS',FND_LOG.LEVEL_EXCEPTION);
362: RAISE;
363: END SPAWN_SR_CONTACTS_INS;
364:
365: PROCEDURE SR_ITEM_INS_INIT(p_incident_id IN NUMBER, p_instance_id IN NUMBER, p_party_site_id IN NUMBER,

Line 375: CSM_UTIL_PKG.LOG('Entering SR_ITEM_INS_INIT for incident_id: ' || p_incident_id ||

371: l_error_msg VARCHAR2(4000);
372: l_return_status VARCHAR2(2000);
373:
374: BEGIN
375: CSM_UTIL_PKG.LOG('Entering SR_ITEM_INS_INIT for incident_id: ' || p_incident_id ||
376: ' and instance_id: ' || p_instance_id,'CSM_SR_EVENT_PKG.SR_ITEM_INS_INIT',FND_LOG.LEVEL_PROCEDURE);
377:
378: -- initialize count of IB items at location to 0;
379: csm_sr_event_pkg.g_ib_count := 0;

Line 400: CSM_UTIL_PKG.LOG('Leaving SR_ITEM_INS_INIT for incident_id: ' || p_incident_id ||

396: p_userid=>p_user_id,
397: p_error_msg=>l_error_msg,
398: x_return_status=>l_return_status);
399:
400: CSM_UTIL_PKG.LOG('Leaving SR_ITEM_INS_INIT for incident_id: ' || p_incident_id ||
401: ' and instance_id: ' || p_instance_id,'CSM_SR_EVENT_PKG.SR_ITEM_INS_INIT',FND_LOG.LEVEL_PROCEDURE);
402: EXCEPTION
403: WHEN OTHERS THEN
404: l_sqlerrno := to_char(SQLCODE);

Line 408: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SR_EVENT_PKG.SR_ITEM_INS_INIT',FND_LOG.LEVEL_EXCEPTION);

404: l_sqlerrno := to_char(SQLCODE);
405: l_sqlerrmsg := substr(SQLERRM, 1,2000);
406: l_error_msg := ' Exception in SR_ITEM_INS_INIT for incident_id: ' || p_incident_id || ' and instance_id:'
407: || to_char(p_instance_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
408: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SR_EVENT_PKG.SR_ITEM_INS_INIT',FND_LOG.LEVEL_EXCEPTION);
409: RAISE;
410: END SR_ITEM_INS_INIT;
411:
412: PROCEDURE SPAWN_ITEM_INSTANCES_INS (p_instance_id IN NUMBER, p_organization_id IN NUMBER, p_user_id IN NUMBER)

Line 478: CSM_UTIL_PKG.LOG('Entering SPAWN_ITEM_INSTANCES_INS for instance_id: ' || p_instance_id,

474: AND SYSDATE BETWEEN NVL(attr.active_start_date, SYSDATE) AND NVL(attr.active_end_date, SYSDATE)
475: ;
476:
477: BEGIN
478: CSM_UTIL_PKG.LOG('Entering SPAWN_ITEM_INSTANCES_INS for instance_id: ' || p_instance_id,
479: 'CSM_SR_EVENT_PKG.SPAWN_ITEM_INSTANCES_INS',FND_LOG.LEVEL_PROCEDURE);
480:
481: l_transaction_date := SYSDATE;
482: l_null_relationship_id := TO_NUMBER(NULL);

Line 518: CSM_UTIL_PKG.LOG('Leaving SPAWN_ITEM_INSTANCES_INS for instance_id: ' || p_instance_id,

514: ,P_USER_ID => p_user_id
515: );
516: END LOOP;
517:
518: CSM_UTIL_PKG.LOG('Leaving SPAWN_ITEM_INSTANCES_INS for instance_id: ' || p_instance_id,
519: 'CSM_SR_EVENT_PKG.SPAWN_ITEM_INSTANCES_INS',FND_LOG.LEVEL_PROCEDURE);
520: EXCEPTION
521: WHEN OTHERS THEN
522: l_sqlerrno := to_char(SQLCODE);

Line 526: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SR_EVENT_PKG.SPAWN_ITEM_INSTANCES_INS',FND_LOG.LEVEL_EXCEPTION);

522: l_sqlerrno := to_char(SQLCODE);
523: l_sqlerrmsg := substr(SQLERRM, 1,2000);
524: l_error_msg := l_error_msg || '- Exception in SPAWN_ITEM_INSTANCES_INS for instance_id:'
525: || to_char(p_instance_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
526: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SR_EVENT_PKG.SPAWN_ITEM_INSTANCES_INS',FND_LOG.LEVEL_EXCEPTION);
527: RAISE;
528: END SPAWN_ITEM_INSTANCES_INS;
529:
530: PROCEDURE INCIDENTS_ACC_I(p_incident_id IN NUMBER, p_user_id IN NUMBER)

Line 538: CSM_UTIL_PKG.LOG('Entering INCIDENTS_ACC_I for incident_id: ' || p_incident_id,

534: l_error_msg VARCHAR2(4000);
535: l_return_status VARCHAR2(2000);
536:
537: BEGIN
538: CSM_UTIL_PKG.LOG('Entering INCIDENTS_ACC_I for incident_id: ' || p_incident_id,
539: 'CSM_SR_EVENT_PKG.INCIDENTS_ACC_I',FND_LOG.LEVEL_PROCEDURE);
540:
541: CSM_ACC_PKG.Insert_Acc
542: ( P_PUBLICATION_ITEM_NAMES => g_incidents_pubi_name

Line 550: CSM_UTIL_PKG.LOG('Leaving INCIDENTS_ACC_I for incident_id: ' || p_incident_id,

546: ,P_PK1_NUM_VALUE => p_incident_id
547: ,P_USER_ID => p_user_id
548: );
549:
550: CSM_UTIL_PKG.LOG('Leaving INCIDENTS_ACC_I for incident_id: ' || p_incident_id,
551: 'CSM_SR_EVENT_PKG.INCIDENTS_ACC_I',FND_LOG.LEVEL_PROCEDURE);
552: EXCEPTION
553: WHEN OTHERS THEN
554: l_sqlerrno := to_char(SQLCODE);

Line 558: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SR_EVENT_PKG.INCIDENTS_ACC_I',FND_LOG.LEVEL_EXCEPTION);

554: l_sqlerrno := to_char(SQLCODE);
555: l_sqlerrmsg := substr(SQLERRM, 1,2000);
556: l_error_msg := ' Exception in INCIDENTS_ACC_I for incident_id:'
557: || to_char(p_incident_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
558: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SR_EVENT_PKG.INCIDENTS_ACC_I',FND_LOG.LEVEL_EXCEPTION);
559: RAISE;
560: END INCIDENTS_ACC_I;
561:
562: PROCEDURE SPAWN_SR_CONTACT_DEL(p_incident_id IN NUMBER, p_sr_contact_point_id IN NUMBER,

Line 593: CSM_UTIL_PKG.LOG('Entering CSM_SR_EVENT_PKG.SPAWN_SR_CONTACT_DEL for incident_id: ' || p_incident_id,

589: AND SYSDATE BETWEEN jtrs.start_date_active AND nvl(jtrs.end_date_active, SYSDATE)
590: ;
591:
592: BEGIN
593: CSM_UTIL_PKG.LOG('Entering CSM_SR_EVENT_PKG.SPAWN_SR_CONTACT_DEL for incident_id: ' || p_incident_id,
594: 'CSM_SR_EVENT_PKG.SPAWN_SR_CONTACT_DEL',FND_LOG.LEVEL_PROCEDURE);
595:
596: FOR r_srcontpts_rec IN l_srcontpts_csr(p_incident_id, p_sr_contact_point_id) LOOP
597: IF r_srcontpts_rec.contact_type = 'EMPLOYEE' THEN

Line 621: CSM_UTIL_PKG.LOG('Leaving CSM_SR_EVENT_PKG.SPAWN_SR_CONTACT_DEL for incident_id: ' || p_incident_id,

617: csm_sr_contact_event_pkg.sr_cntact_mdirty_d(p_sr_contact_point_id=>r_srcontpts_rec.sr_contact_point_id,
618: p_user_id=>p_user_id);
619: END LOOP;
620:
621: CSM_UTIL_PKG.LOG('Leaving CSM_SR_EVENT_PKG.SPAWN_SR_CONTACT_DEL for incident_id: ' || p_incident_id,
622: 'CSM_SR_EVENT_PKG.SPAWN_SR_CONTACT_DEL',FND_LOG.LEVEL_PROCEDURE);
623: EXCEPTION
624: WHEN OTHERS THEN
625: l_sqlerrno := to_char(SQLCODE);

Line 629: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SR_EVENT_PKG.SPAWN_SR_CONTACT_DEL',FND_LOG.LEVEL_EXCEPTION);

625: l_sqlerrno := to_char(SQLCODE);
626: l_sqlerrmsg := substr(SQLERRM, 1,2000);
627: l_error_msg := ' Exception in SPAWN_SR_CONTACT_DEL for incident_id:' || to_char(p_incident_id)
628: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
629: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SR_EVENT_PKG.SPAWN_SR_CONTACT_DEL',FND_LOG.LEVEL_EXCEPTION);
630: RAISE;
631: END SPAWN_SR_CONTACT_DEL;
632:
633: PROCEDURE SR_ITEM_DEL_INIT(p_incident_id IN NUMBER, p_instance_id IN NUMBER, p_party_site_id IN NUMBER,

Line 643: CSM_UTIL_PKG.LOG('Entering SR_ITEM_DEL_INIT for incident_id: ' || p_incident_id ||

639: l_error_msg VARCHAR2(4000);
640: l_return_status VARCHAR2(2000);
641:
642: BEGIN
643: CSM_UTIL_PKG.LOG('Entering SR_ITEM_DEL_INIT for incident_id: ' || p_incident_id ||
644: ' and instance_id: ' || p_instance_id,'CSM_SR_EVENT_PKG.SR_ITEM_DEL_INIT',FND_LOG.LEVEL_PROCEDURE);
645:
646: -- spawn item instances del
647: csm_sr_event_pkg.spawn_item_instances_del(p_instance_id=>p_instance_id,p_organization_id=>p_organization_id,

Line 665: CSM_UTIL_PKG.LOG('Leaving SR_ITEM_DEL_INIT for incident_id: ' || p_incident_id ||

661: p_userid=>p_user_id,
662: p_error_msg=>l_error_msg,
663: x_return_status=>l_return_status);
664:
665: CSM_UTIL_PKG.LOG('Leaving SR_ITEM_DEL_INIT for incident_id: ' || p_incident_id ||
666: ' and instance_id: ' || p_instance_id,'CSM_SR_EVENT_PKG.SR_ITEM_DEL_INIT',FND_LOG.LEVEL_PROCEDURE);
667: EXCEPTION
668: WHEN OTHERS THEN
669: l_sqlerrno := to_char(SQLCODE);

Line 673: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SR_EVENT_PKG.SR_ITEM_DEL_INIT',FND_LOG.LEVEL_EXCEPTION);

669: l_sqlerrno := to_char(SQLCODE);
670: l_sqlerrmsg := substr(SQLERRM, 1,2000);
671: l_error_msg := ' Exception in SR_ITEM_DEL_INIT for incident_id: ' || p_incident_id || ' and instance_id:'
672: || to_char(p_instance_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
673: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SR_EVENT_PKG.SR_ITEM_DEL_INIT',FND_LOG.LEVEL_EXCEPTION);
674: RAISE;
675: END SR_ITEM_DEL_INIT;
676:
677: PROCEDURE SPAWN_ITEM_INSTANCES_DEL (p_instance_id IN NUMBER, p_organization_id IN NUMBER,

Line 743: CSM_UTIL_PKG.LOG('Entering SPAWN_ITEM_INSTANCES_DEL for instance_id: ' || p_instance_id,

739: AND SYSDATE BETWEEN NVL(attr.active_start_date, SYSDATE) AND NVL(attr.active_end_date, SYSDATE)
740: ;
741:
742: BEGIN
743: CSM_UTIL_PKG.LOG('Entering SPAWN_ITEM_INSTANCES_DEL for instance_id: ' || p_instance_id,
744: 'CSM_SR_EVENT_PKG.SPAWN_ITEM_INSTANCES_DEL',FND_LOG.LEVEL_PROCEDURE);
745:
746: l_transaction_date := SYSDATE;
747: l_null_relationship_id := TO_NUMBER(NULL);

Line 781: CSM_UTIL_PKG.LOG('Leaving SPAWN_ITEM_INSTANCES_DEL for instance_id: ' || p_instance_id,

777: ,P_USER_ID => p_user_id
778: );
779: END LOOP;
780:
781: CSM_UTIL_PKG.LOG('Leaving SPAWN_ITEM_INSTANCES_DEL for instance_id: ' || p_instance_id,
782: 'CSM_SR_EVENT_PKG.SPAWN_ITEM_INSTANCES_DEL',FND_LOG.LEVEL_PROCEDURE);
783: EXCEPTION
784: WHEN OTHERS THEN
785: l_sqlerrno := to_char(SQLCODE);

Line 789: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SR_EVENT_PKG.SPAWN_ITEM_INSTANCES_DEL',FND_LOG.LEVEL_EXCEPTION);

785: l_sqlerrno := to_char(SQLCODE);
786: l_sqlerrmsg := substr(SQLERRM, 1,2000);
787: l_error_msg := l_error_msg || '- Exception in SPAWN_ITEM_INSTANCES_DEL for instance_id:'
788: || to_char(p_instance_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
789: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SR_EVENT_PKG.SPAWN_ITEM_INSTANCES_DEL',FND_LOG.LEVEL_EXCEPTION);
790: RAISE;
791: END SPAWN_ITEM_INSTANCES_DEL;
792:
793: PROCEDURE INCIDENTS_ACC_D(p_incident_id IN NUMBER, p_user_id IN NUMBER)

Line 801: CSM_UTIL_PKG.LOG('Entering INCIDENTS_ACC_D for incident_id: ' || p_incident_id,

797: l_error_msg VARCHAR2(4000);
798: l_return_status VARCHAR2(2000);
799:
800: BEGIN
801: CSM_UTIL_PKG.LOG('Entering INCIDENTS_ACC_D for incident_id: ' || p_incident_id,
802: 'CSM_SR_EVENT_PKG.INCIDENTS_ACC_D',FND_LOG.LEVEL_PROCEDURE);
803:
804: CSM_ACC_PKG.Delete_Acc
805: ( P_PUBLICATION_ITEM_NAMES => g_incidents_pubi_name

Line 812: CSM_UTIL_PKG.LOG('Leaving INCIDENTS_ACC_D for incident_id: ' || p_incident_id,

808: ,P_PK1_NUM_VALUE => p_incident_id
809: ,P_USER_ID => p_user_id
810: );
811:
812: CSM_UTIL_PKG.LOG('Leaving INCIDENTS_ACC_D for incident_id: ' || p_incident_id,
813: 'CSM_SR_EVENT_PKG.INCIDENTS_ACC_D',FND_LOG.LEVEL_PROCEDURE);
814: EXCEPTION
815: WHEN OTHERS THEN
816: l_sqlerrno := to_char(SQLCODE);

Line 820: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SR_EVENT_PKG.INCIDENTS_ACC_D',FND_LOG.LEVEL_EXCEPTION);

816: l_sqlerrno := to_char(SQLCODE);
817: l_sqlerrmsg := substr(SQLERRM, 1,2000);
818: l_error_msg := ' Exception in INCIDENTS_ACC_D for incident_id:'
819: || to_char(p_incident_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
820: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SR_EVENT_PKG.INCIDENTS_ACC_D',FND_LOG.LEVEL_EXCEPTION);
821: RAISE;
822: END INCIDENTS_ACC_D;
823:
824: --12.1XB6

Line 846: RETURN CSM_UTIL_PKG.is_mfs_group(l_owner_group_id) OR CSM_UTIL_PKG.is_palm_user(l_created_by);

842: OPEN c_sr_owner_group(p_task_id);
843: FETCH c_sr_owner_group INTO l_owner_group_id,l_created_by;
844: CLOSE c_sr_owner_group;
845:
846: RETURN CSM_UTIL_PKG.is_mfs_group(l_owner_group_id) OR CSM_UTIL_PKG.is_palm_user(l_created_by);
847:
848: END;
849:
850: --12.1

Line 890: AND acc.user_id = CSM_UTIL_PKG.get_group_owner(csi.owner_group_id));*/

886: /*AND NOT EXISTS
887: (SELECT 1
888: FROM csm_incidents_all_acc acc
889: WHERE acc.incident_id = csi.incident_id
890: AND acc.user_id = CSM_UTIL_PKG.get_group_owner(csi.owner_group_id));*/
891:
892:
893: CURSOR l_addr_id_csr (p_incident_id IN NUMBER)
894: IS

Line 932: CSM_UTIL_PKG.LOG('Entering SR_INS_INIT for incident_id: ' || p_incident_id ,'CSM_SR_EVENT_PKG.SR_INS_INIT',FND_LOG.LEVEL_PROCEDURE);

928:
929: l_assignee_user_id NUMBER;
930:
931: BEGIN
932: CSM_UTIL_PKG.LOG('Entering SR_INS_INIT for incident_id: ' || p_incident_id ,'CSM_SR_EVENT_PKG.SR_INS_INIT',FND_LOG.LEVEL_PROCEDURE);
933:
934: OPEN l_sr_csr(p_incident_id);
935: FETCH l_sr_csr INTO l_sr_rec;
936: IF l_sr_csr%NOTFOUND THEN

Line 942: IF ( NOT CSM_UTIL_PKG.is_mfs_group(l_sr_rec.owner_group_id)) THEN

938: RETURN;
939: END IF;
940: CLOSE l_sr_csr;
941: --12.1XB6
942: IF ( NOT CSM_UTIL_PKG.is_mfs_group(l_sr_rec.owner_group_id)) THEN
943: IF ( NOT CSM_UTIL_PKG.is_palm_user(l_sr_rec.created_by)) THEN
944: CSM_UTIL_PKG.LOG('Leaving SR_INS_INIT because the Owner group of SR is not a mobile resource group
945: and also this SR , incident_id: ' || p_incident_id ||' is not created by a mobile user'
946: ,'CSM_SR_EVENT_PKG.SR_INS_INIT',FND_LOG.LEVEL_PROCEDURE);

Line 943: IF ( NOT CSM_UTIL_PKG.is_palm_user(l_sr_rec.created_by)) THEN

939: END IF;
940: CLOSE l_sr_csr;
941: --12.1XB6
942: IF ( NOT CSM_UTIL_PKG.is_mfs_group(l_sr_rec.owner_group_id)) THEN
943: IF ( NOT CSM_UTIL_PKG.is_palm_user(l_sr_rec.created_by)) THEN
944: CSM_UTIL_PKG.LOG('Leaving SR_INS_INIT because the Owner group of SR is not a mobile resource group
945: and also this SR , incident_id: ' || p_incident_id ||' is not created by a mobile user'
946: ,'CSM_SR_EVENT_PKG.SR_INS_INIT',FND_LOG.LEVEL_PROCEDURE);
947: RETURN;

Line 944: CSM_UTIL_PKG.LOG('Leaving SR_INS_INIT because the Owner group of SR is not a mobile resource group

940: CLOSE l_sr_csr;
941: --12.1XB6
942: IF ( NOT CSM_UTIL_PKG.is_mfs_group(l_sr_rec.owner_group_id)) THEN
943: IF ( NOT CSM_UTIL_PKG.is_palm_user(l_sr_rec.created_by)) THEN
944: CSM_UTIL_PKG.LOG('Leaving SR_INS_INIT because the Owner group of SR is not a mobile resource group
945: and also this SR , incident_id: ' || p_incident_id ||' is not created by a mobile user'
946: ,'CSM_SR_EVENT_PKG.SR_INS_INIT',FND_LOG.LEVEL_PROCEDURE);
947: RETURN;
948: ELSE

Line 949: l_owner_id := CSM_UTIL_PKG.get_owner(l_sr_rec.created_by);

945: and also this SR , incident_id: ' || p_incident_id ||' is not created by a mobile user'
946: ,'CSM_SR_EVENT_PKG.SR_INS_INIT',FND_LOG.LEVEL_PROCEDURE);
947: RETURN;
948: ELSE
949: l_owner_id := CSM_UTIL_PKG.get_owner(l_sr_rec.created_by);
950: END IF;
951: ELSE
952: l_owner_id := CSM_UTIL_PKG.get_group_owner(l_sr_rec.owner_group_id);
953: END IF;

Line 952: l_owner_id := CSM_UTIL_PKG.get_group_owner(l_sr_rec.owner_group_id);

948: ELSE
949: l_owner_id := CSM_UTIL_PKG.get_owner(l_sr_rec.created_by);
950: END IF;
951: ELSE
952: l_owner_id := CSM_UTIL_PKG.get_group_owner(l_sr_rec.owner_group_id);
953: END IF;
954:
955:
956:

Line 1066: IF NOT CSM_UTIL_PKG.from_same_group(l_owner_resource_id,assign_rec.resource_id) THEN

1062: -- to download other grp's resource if required
1063: OPEN c_resource_id(l_owner_id);
1064: FETCH c_resource_id INTO l_owner_resource_id;
1065: CLOSE c_resource_id;
1066: IF NOT CSM_UTIL_PKG.from_same_group(l_owner_resource_id,assign_rec.resource_id) THEN
1067: --assignee bug
1068: OPEN c_user_id(assign_rec.resource_id);
1069: FETCH c_user_id INTO l_assignee_user_id;
1070: CLOSE c_user_id;

Line 1080: CSM_UTIL_PKG.LOG('Leaving SR_INS_INIT for incident_id: ' || p_incident_id ,'CSM_SR_EVENT_PKG.SR_INS_INIT',FND_LOG.LEVEL_PROCEDURE);

1076: end loop;
1077:
1078: END LOOP;
1079:
1080: CSM_UTIL_PKG.LOG('Leaving SR_INS_INIT for incident_id: ' || p_incident_id ,'CSM_SR_EVENT_PKG.SR_INS_INIT',FND_LOG.LEVEL_PROCEDURE);
1081: EXCEPTION
1082: WHEN OTHERS THEN
1083: l_sqlerrno := to_char(SQLCODE);
1084: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 1087: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SR_EVENT_PKG.SR_INS_INIT',FND_LOG.LEVEL_EXCEPTION);

1083: l_sqlerrno := to_char(SQLCODE);
1084: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1085: l_error_msg := ' Exception in SR_INS_INIT for incident_id:'
1086: || to_char(p_incident_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1087: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SR_EVENT_PKG.SR_INS_INIT',FND_LOG.LEVEL_EXCEPTION);
1088: RAISE;
1089: END SR_INS_INIT;
1090:
1091: --12.1

Line 1130: AND acc.user_id = NVL(b_user_id,decode(CSM_UTIL_PKG.get_group_owner(csi.owner_group_id),-1,csi.created_by,CSM_UTIL_PKG.get_group_owner(csi.owner_group_id)) ));

1126: AND EXISTS
1127: (SELECT 1
1128: FROM csm_incidents_all_acc acc
1129: WHERE acc.incident_id = csi.incident_id
1130: AND acc.user_id = NVL(b_user_id,decode(CSM_UTIL_PKG.get_group_owner(csi.owner_group_id),-1,csi.created_by,CSM_UTIL_PKG.get_group_owner(csi.owner_group_id)) ));
1131:
1132: l_sr_rec l_sr_csr%ROWTYPE;
1133:
1134: CURSOR c_tasks(b_incident_id NUMBER)

Line 1165: CSM_UTIL_PKG.LOG('Entering SR_DEL_INIT for incident_id: ' || p_incident_id ,'CSM_SR_EVENT_PKG.SR_DEL_INIT',FND_LOG.LEVEL_PROCEDURE);

1161: l_assignee_user_id NUMBER;
1162:
1163:
1164: BEGIN
1165: CSM_UTIL_PKG.LOG('Entering SR_DEL_INIT for incident_id: ' || p_incident_id ,'CSM_SR_EVENT_PKG.SR_DEL_INIT',FND_LOG.LEVEL_PROCEDURE);
1166:
1167: OPEN l_sr_csr(p_incident_id,p_user_id);
1168: FETCH l_sr_csr INTO l_sr_rec;
1169: IF l_sr_csr%NOTFOUND THEN

Line 1177: IF ( NOT CSM_UTIL_PKG.is_mfs_group(l_sr_rec.owner_group_id)) THEN

1173: CLOSE l_sr_csr;
1174:
1175: --12.1XB6
1176: IF p_user_id IS NULL THEN
1177: IF ( NOT CSM_UTIL_PKG.is_mfs_group(l_sr_rec.owner_group_id)) THEN
1178: IF ( NOT CSM_UTIL_PKG.is_palm_user(l_sr_rec.created_by)) THEN
1179: CSM_UTIL_PKG.LOG('Leaving SR_DEL_INIT since the Owner group of SR is not a mobile resource group
1180: and also this SR , incident_id: ' || p_incident_id ||' is not created by a mobile user'
1181: ,'CSM_SR_EVENT_PKG.SR_DEL_INIT',FND_LOG.LEVEL_PROCEDURE);

Line 1178: IF ( NOT CSM_UTIL_PKG.is_palm_user(l_sr_rec.created_by)) THEN

1174:
1175: --12.1XB6
1176: IF p_user_id IS NULL THEN
1177: IF ( NOT CSM_UTIL_PKG.is_mfs_group(l_sr_rec.owner_group_id)) THEN
1178: IF ( NOT CSM_UTIL_PKG.is_palm_user(l_sr_rec.created_by)) THEN
1179: CSM_UTIL_PKG.LOG('Leaving SR_DEL_INIT since the Owner group of SR is not a mobile resource group
1180: and also this SR , incident_id: ' || p_incident_id ||' is not created by a mobile user'
1181: ,'CSM_SR_EVENT_PKG.SR_DEL_INIT',FND_LOG.LEVEL_PROCEDURE);
1182: RETURN;

Line 1179: CSM_UTIL_PKG.LOG('Leaving SR_DEL_INIT since the Owner group of SR is not a mobile resource group

1175: --12.1XB6
1176: IF p_user_id IS NULL THEN
1177: IF ( NOT CSM_UTIL_PKG.is_mfs_group(l_sr_rec.owner_group_id)) THEN
1178: IF ( NOT CSM_UTIL_PKG.is_palm_user(l_sr_rec.created_by)) THEN
1179: CSM_UTIL_PKG.LOG('Leaving SR_DEL_INIT since the Owner group of SR is not a mobile resource group
1180: and also this SR , incident_id: ' || p_incident_id ||' is not created by a mobile user'
1181: ,'CSM_SR_EVENT_PKG.SR_DEL_INIT',FND_LOG.LEVEL_PROCEDURE);
1182: RETURN;
1183: ELSE

Line 1184: l_owner_id := CSM_UTIL_PKG.get_owner(l_sr_rec.created_by);

1180: and also this SR , incident_id: ' || p_incident_id ||' is not created by a mobile user'
1181: ,'CSM_SR_EVENT_PKG.SR_DEL_INIT',FND_LOG.LEVEL_PROCEDURE);
1182: RETURN;
1183: ELSE
1184: l_owner_id := CSM_UTIL_PKG.get_owner(l_sr_rec.created_by);
1185: END IF;
1186: ELSE
1187: l_owner_id := CSM_UTIL_PKG.get_group_owner(l_sr_rec.owner_group_id);
1188: END IF;

Line 1187: l_owner_id := CSM_UTIL_PKG.get_group_owner(l_sr_rec.owner_group_id);

1183: ELSE
1184: l_owner_id := CSM_UTIL_PKG.get_owner(l_sr_rec.created_by);
1185: END IF;
1186: ELSE
1187: l_owner_id := CSM_UTIL_PKG.get_group_owner(l_sr_rec.owner_group_id);
1188: END IF;
1189: ELSE
1190: l_owner_id:=p_user_id;
1191: END IF;

Line 1296: IF NOT CSM_UTIL_PKG.from_same_group(l_owner_resource_id,assign_rec.resource_id) THEN

1292: /*Other grp's member Resource to be deleted from acc if assigned to him*/
1293: OPEN c_resource_id(l_owner_id);
1294: FETCH c_resource_id INTO l_owner_resource_id;
1295: CLOSE c_resource_id;
1296: IF NOT CSM_UTIL_PKG.from_same_group(l_owner_resource_id,assign_rec.resource_id) THEN
1297: --assignee bug
1298: OPEN c_user_id(assign_rec.resource_id);
1299: FETCH c_user_id INTO l_assignee_user_id;
1300: CLOSE c_user_id;

Line 1309: CSM_UTIL_PKG.LOG('Leaving SR_DEL_INIT for incident_id: ' || p_incident_id ,'CSM_SR_EVENT_PKG.SR_DEL_INIT',FND_LOG.LEVEL_PROCEDURE);

1305: end loop;
1306:
1307: END LOOP;
1308:
1309: CSM_UTIL_PKG.LOG('Leaving SR_DEL_INIT for incident_id: ' || p_incident_id ,'CSM_SR_EVENT_PKG.SR_DEL_INIT',FND_LOG.LEVEL_PROCEDURE);
1310: EXCEPTION
1311: WHEN OTHERS THEN
1312: l_sqlerrno := to_char(SQLCODE);
1313: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 1316: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SR_EVENT_PKG.SR_DEL_INIT',FND_LOG.LEVEL_EXCEPTION);

1312: l_sqlerrno := to_char(SQLCODE);
1313: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1314: l_error_msg := ' Exception in SR_DEL_INIT for incident_id:'
1315: || to_char(p_incident_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1316: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SR_EVENT_PKG.SR_DEL_INIT',FND_LOG.LEVEL_EXCEPTION);
1317: RAISE;
1318: END SR_DEL_INIT;
1319:
1320: --12.1

Line 1379: CSM_UTIL_PKG.LOG('Entering SR_UPD_INIT for incident_id: ' || p_incident_id ,'CSM_SR_EVENT_PKG.SR_UPD_INIT',FND_LOG.LEVEL_PROCEDURE);

1375: WHERE acc.incident_id = p_incident_id;
1376:
1377:
1378: BEGIN
1379: CSM_UTIL_PKG.LOG('Entering SR_UPD_INIT for incident_id: ' || p_incident_id ,'CSM_SR_EVENT_PKG.SR_UPD_INIT',FND_LOG.LEVEL_PROCEDURE);
1380:
1381: OPEN l_sr_csr(p_incident_id);
1382: FETCH l_sr_csr INTO l_sr_rec;
1383: IF l_sr_csr%NOTFOUND THEN

Line 1520: CSM_UTIL_PKG.LOG('Leaving SR_UPD_INIT for incident_id: ' || p_incident_id ,'CSM_SR_EVENT_PKG.SR_UPD_INIT',FND_LOG.LEVEL_PROCEDURE);

1516: );
1517:
1518: END LOOP;
1519:
1520: CSM_UTIL_PKG.LOG('Leaving SR_UPD_INIT for incident_id: ' || p_incident_id ,'CSM_SR_EVENT_PKG.SR_UPD_INIT',FND_LOG.LEVEL_PROCEDURE);
1521: EXCEPTION
1522: WHEN OTHERS THEN
1523: l_sqlerrno := to_char(SQLCODE);
1524: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 1527: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SR_EVENT_PKG.SR_UPD_INIT',FND_LOG.LEVEL_EXCEPTION);

1523: l_sqlerrno := to_char(SQLCODE);
1524: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1525: l_error_msg := ' Exception in SR_UPD_INIT for incident_id:'
1526: || to_char(p_incident_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1527: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SR_EVENT_PKG.SR_UPD_INIT',FND_LOG.LEVEL_EXCEPTION);
1528: RAISE;
1529: END SR_UPD_INIT;
1530:
1531: --Function to find whether the SR associated with Task assignment id is open before purging.

Line 1552: CSM_UTIL_PKG.LOG('Entering CSM_SR_EVENT_PKG.IS_SR_OPEN for task_id: ' || p_task_id,

1548: AND tsk.task_id = c_task_id
1549: AND tsk.source_object_id = inc.incident_id;
1550:
1551: BEGIN
1552: CSM_UTIL_PKG.LOG('Entering CSM_SR_EVENT_PKG.IS_SR_OPEN for task_id: ' || p_task_id,
1553: 'CSM_SR_EVENT_PKG.IS_SR_OPEN',FND_LOG.LEVEL_PROCEDURE);
1554:
1555: l_incident_id := NULL;
1556:

Line 1562: CSM_UTIL_PKG.LOG('The SR is open for task_id : ' || p_task_id,

1558: FETCH l_is_sr_open_csr INTO l_incident_id;
1559: IF l_is_sr_open_csr%NOTFOUND THEN
1560:
1561: CLOSE l_is_sr_open_csr;
1562: CSM_UTIL_PKG.LOG('The SR is open for task_id : ' || p_task_id,
1563: 'CSM_SR_EVENT_PKG.IS_SR_OPEN',FND_LOG.LEVEL_EXCEPTION);
1564: RETURN TRUE;
1565: END IF;
1566: CLOSE l_is_sr_open_csr;

Line 1568: CSM_UTIL_PKG.LOG('The SR is Closed for task_id : ' || p_task_id,

1564: RETURN TRUE;
1565: END IF;
1566: CLOSE l_is_sr_open_csr;
1567:
1568: CSM_UTIL_PKG.LOG('The SR is Closed for task_id : ' || p_task_id,
1569: 'CSM_SR_EVENT_PKG.IS_SR_OPEN',FND_LOG.LEVEL_EXCEPTION);
1570:
1571: RETURN FALSE;
1572:

Line 1579: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SR_EVENT_PKG.IS_SR_OPEN',FND_LOG.LEVEL_EXCEPTION);

1575: l_sqlerrno := to_char(SQLCODE);
1576: l_sqlerrmsg := substr(SQLERRM, 1,2000);
1577: l_error_msg := ' Exception in IS_SR_OPEN for task_id:' || to_char(p_task_id)
1578: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1579: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_SR_EVENT_PKG.IS_SR_OPEN',FND_LOG.LEVEL_EXCEPTION);
1580: RAISE;
1581: END IS_SR_OPEN;
1582:
1583: