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_USER_EVENT_PKG dependencies on FND_LOG

Line 36: || p_responsibility_id , 'CSM_USER_EVENT_PKG.IS_OMFS_PALM_RESPONSIBILITY',FND_LOG.LEVEL_PROCEDURE);

32: l_responsibilities_rec l_responsibilities_csr%ROWTYPE;
33:
34: BEGIN
35: CSM_UTIL_PKG.LOG('Entering IS_OMFS_PALM_RESPONSIBILITY for user_id: ' || p_user_id || ' and responsibility_id: '
36: || p_responsibility_id , 'CSM_USER_EVENT_PKG.IS_OMFS_PALM_RESPONSIBILITY',FND_LOG.LEVEL_PROCEDURE);
37:
38: OPEN l_responsibilities_csr (p_responsibility_id,p_user_id);
39: FETCH l_responsibilities_csr INTO l_responsibilities_rec;
40:

Line 48: || p_responsibility_id , 'CSM_USER_EVENT_PKG.IS_OMFS_PALM_RESPONSIBILITY',FND_LOG.LEVEL_PROCEDURE);

44: END IF;
45: CLOSE l_responsibilities_csr;
46:
47: CSM_UTIL_PKG.LOG('Leaving IS_OMFS_PALM_RESPONSIBILITY for user_id: ' || p_user_id || ' and responsibility_id: '
48: || p_responsibility_id , 'CSM_USER_EVENT_PKG.IS_OMFS_PALM_RESPONSIBILITY',FND_LOG.LEVEL_PROCEDURE);
49:
50: RETURN TRUE;
51: EXCEPTION
52: WHEN OTHERS THEN

Line 57: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_USER_EVENT_PKG.IS_OMFS_PALM_RESPONSIBILITY',FND_LOG.LEVEL_EXCEPTION);

53: l_sqlerrno := to_char(SQLCODE);
54: l_sqlerrmsg := substr(SQLERRM, 1,2000);
55: l_error_msg := ' Exception in IS_OMFS_PALM_RESPONSIBILITY for for user_id: ' || p_user_id || ' and responsibility_id: '
56: || p_responsibility_id || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
57: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_USER_EVENT_PKG.IS_OMFS_PALM_RESPONSIBILITY',FND_LOG.LEVEL_EXCEPTION);
58: RETURN FALSE;
59: END IS_OMFS_PALM_RESPONSIBILITY;
60:
61: PROCEDURE disable_user_pub_synch(p_user_id IN NUMBER)

Line 70: 'CSM_USER_EVENT_PKG.disable_user_pub_synch',FND_LOG.LEVEL_PROCEDURE);

66: l_return_status VARCHAR2(2000);
67:
68: BEGIN
69: CSM_UTIL_PKG.LOG('Entering disable_user_pub_synch for user_id:' || p_user_id,
70: 'CSM_USER_EVENT_PKG.disable_user_pub_synch',FND_LOG.LEVEL_PROCEDURE);
71:
72: asg_helper.disable_user_pub_synch(p_user_id, 'SERVICEP');
73:
74: CSM_UTIL_PKG.LOG('Leaving disable_user_pub_synch for user_id:' || p_user_id,

Line 75: 'CSM_USER_EVENT_PKG.disable_user_pub_synch',FND_LOG.LEVEL_PROCEDURE);

71:
72: asg_helper.disable_user_pub_synch(p_user_id, 'SERVICEP');
73:
74: CSM_UTIL_PKG.LOG('Leaving disable_user_pub_synch for user_id:' || p_user_id,
75: 'CSM_USER_EVENT_PKG.disable_user_pub_synch',FND_LOG.LEVEL_PROCEDURE);
76: EXCEPTION
77: WHEN OTHERS THEN
78: l_sqlerrno := to_char(SQLCODE);
79: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 82: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_USER_EVENT_PKG.disable_user_pub_synch',FND_LOG.LEVEL_EXCEPTION);

78: l_sqlerrno := to_char(SQLCODE);
79: l_sqlerrmsg := substr(SQLERRM, 1,2000);
80: l_error_msg := ' Exception in disable_user_pub_synch for for user_id: ' || p_user_id
81: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
82: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_USER_EVENT_PKG.disable_user_pub_synch',FND_LOG.LEVEL_EXCEPTION);
83: RAISE;
84: END disable_user_pub_synch;
85:
86: FUNCTION is_first_omfs_palm_user(p_user_id IN NUMBER) RETURN BOOLEAN

Line 107: 'CSM_USER_EVENT_PKG.IS_FIRST_OMFS_PALM_USER',FND_LOG.LEVEL_PROCEDURE);

103: l_user_rec l_user_csr%ROWTYPE;
104:
105: BEGIN
106: CSM_UTIL_PKG.LOG('Entering IS_FIRST_OMFS_PALM_USER for user_id:' || p_user_id,
107: 'CSM_USER_EVENT_PKG.IS_FIRST_OMFS_PALM_USER',FND_LOG.LEVEL_PROCEDURE);
108:
109: OPEN l_user_csr(p_user_id);
110: FETCH l_user_csr INTO l_user_rec;
111: IF (l_user_csr%FOUND) THEN

Line 118: 'CSM_USER_EVENT_PKG.IS_FIRST_OMFS_PALM_USER',FND_LOG.LEVEL_PROCEDURE);

114: END IF;
115: CLOSE l_user_csr;
116:
117: CSM_UTIL_PKG.LOG('Leaving IS_FIRST_OMFS_PALM_USER for user_id:' || p_user_id,
118: 'CSM_USER_EVENT_PKG.IS_FIRST_OMFS_PALM_USER',FND_LOG.LEVEL_PROCEDURE);
119: RETURN TRUE;
120:
121: EXCEPTION
122: WHEN OTHERS THEN

Line 127: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_USER_EVENT_PKG.IS_FIRST_OMFS_PALM_USER',FND_LOG.LEVEL_EXCEPTION);

123: l_sqlerrno := to_char(SQLCODE);
124: l_sqlerrmsg := substr(SQLERRM, 1,2000);
125: l_error_msg := ' Exception in IS_FIRST_OMFS_PALM_USER for for user_id: ' || p_user_id
126: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
127: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_USER_EVENT_PKG.IS_FIRST_OMFS_PALM_USER',FND_LOG.LEVEL_EXCEPTION);
128: RETURN TRUE;
129: END IS_FIRST_OMFS_PALM_USER;
130:
131: PROCEDURE spawn_dashboard_srch_cols_ins(p_user_id IN NUMBER)

Line 139: 'CSM_USER_EVENT_PKG.spawn_dashboard_srch_cols_ins',FND_LOG.LEVEL_PROCEDURE);

135: l_msg VARCHAR2(4000);
136: l_status VARCHAR2(40);
137: BEGIN
138: CSM_UTIL_PKG.LOG('Entering spawn_dashboard_srch_cols_ins for user_id: ' || p_user_id,
139: 'CSM_USER_EVENT_PKG.spawn_dashboard_srch_cols_ins',FND_LOG.LEVEL_PROCEDURE);
140:
141: CSM_DBOARD_SRCH_COLS_EVENT_PKG.Refresh_Acc(l_status,l_msg);
142:
143: CSM_UTIL_PKG.LOG('Leaving spawn_dashboard_srch_cols_ins for user_id: ' || p_user_id,

Line 144: 'CSM_USER_EVENT_PKG.spawn_dashboard_srch_cols_ins',FND_LOG.LEVEL_PROCEDURE);

140:
141: CSM_DBOARD_SRCH_COLS_EVENT_PKG.Refresh_Acc(l_status,l_msg);
142:
143: CSM_UTIL_PKG.LOG('Leaving spawn_dashboard_srch_cols_ins for user_id: ' || p_user_id,
144: 'CSM_USER_EVENT_PKG.spawn_dashboard_srch_cols_ins',FND_LOG.LEVEL_PROCEDURE);
145: EXCEPTION
146: WHEN OTHERS THEN
147: l_sqlerrno := to_char(SQLCODE);
148: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 151: CSM_UTIL_PKG.LOG(l_msg, 'csm_user_event_pkg.spawn_dashboard_srch_cols_ins',FND_LOG.LEVEL_EXCEPTION);

147: l_sqlerrno := to_char(SQLCODE);
148: l_sqlerrmsg := substr(SQLERRM, 1,2000);
149: l_msg := ' Exception in spawn_dashboard_srch_cols_ins for for user_id: ' || p_user_id
150: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
151: CSM_UTIL_PKG.LOG(l_msg, 'csm_user_event_pkg.spawn_dashboard_srch_cols_ins',FND_LOG.LEVEL_EXCEPTION);
152: RAISE;
153: END spawn_dashboard_srch_cols_ins;
154:
155: --Bug 7239431

Line 164: 'CSM_USER_EVENT_PKG.spawn_perz_ins',FND_LOG.LEVEL_PROCEDURE);

160: l_msg VARCHAR2(4000);
161: l_return_status VARCHAR2(40);
162: BEGIN
163: CSM_UTIL_PKG.LOG('Entering spawn_perz_ins for user_id: ' || p_user_id,
164: 'CSM_USER_EVENT_PKG.spawn_perz_ins',FND_LOG.LEVEL_PROCEDURE);
165:
166: CSM_UTIL_PKG.LOG('Populating PERSONALIZED CUSTOMIZATION VIEWS Access table',
167: 'CSM_USER_EVENT_PKG.spawn_perz_ins',FND_LOG.LEVEL_PROCEDURE);
168:

Line 167: 'CSM_USER_EVENT_PKG.spawn_perz_ins',FND_LOG.LEVEL_PROCEDURE);

163: CSM_UTIL_PKG.LOG('Entering spawn_perz_ins for user_id: ' || p_user_id,
164: 'CSM_USER_EVENT_PKG.spawn_perz_ins',FND_LOG.LEVEL_PROCEDURE);
165:
166: CSM_UTIL_PKG.LOG('Populating PERSONALIZED CUSTOMIZATION VIEWS Access table',
167: 'CSM_USER_EVENT_PKG.spawn_perz_ins',FND_LOG.LEVEL_PROCEDURE);
168:
169: CSM_CUSTMZ_VIEWS_EVENT_PKG.REFRESH_USER(p_user_id);
170:
171: CSM_UTIL_PKG.LOG('Populating PERSONALIZED DELTA PAGE VIEWS Access table',

Line 172: 'CSM_USER_EVENT_PKG.spawn_perz_ins',FND_LOG.LEVEL_PROCEDURE);

168:
169: CSM_CUSTMZ_VIEWS_EVENT_PKG.REFRESH_USER(p_user_id);
170:
171: CSM_UTIL_PKG.LOG('Populating PERSONALIZED DELTA PAGE VIEWS Access table',
172: 'CSM_USER_EVENT_PKG.spawn_perz_ins',FND_LOG.LEVEL_PROCEDURE);
173:
174: CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_USER(p_user_id);
175:
176:

Line 178: 'CSM_USER_EVENT_PKG.spawn_perz_ins',FND_LOG.LEVEL_PROCEDURE);

174: CSM_PAGE_PERZ_DELTA_EVENT_PKG.REFRESH_USER(p_user_id);
175:
176:
177: CSM_UTIL_PKG.LOG('Populating PERSONALIZED NEW MESSAGES Access table',
178: 'CSM_USER_EVENT_PKG.spawn_perz_ins',FND_LOG.LEVEL_PROCEDURE);
179:
180: CSM_NEW_MESSAGES_EVENT_PKG.REFRESH_USER(p_user_id);
181:
182: CSM_UTIL_PKG.LOG('Leaving spawn_perz_ins for user_id: ' || p_user_id,

Line 183: 'CSM_USER_EVENT_PKG.spawn_perz_ins',FND_LOG.LEVEL_PROCEDURE);

179:
180: CSM_NEW_MESSAGES_EVENT_PKG.REFRESH_USER(p_user_id);
181:
182: CSM_UTIL_PKG.LOG('Leaving spawn_perz_ins for user_id: ' || p_user_id,
183: 'CSM_USER_EVENT_PKG.spawn_perz_ins',FND_LOG.LEVEL_PROCEDURE);
184: EXCEPTION
185: WHEN OTHERS THEN
186: l_sqlerrno := to_char(SQLCODE);
187: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 190: CSM_UTIL_PKG.LOG(l_msg, 'csm_user_event_pkg.spawn_perz_ins',FND_LOG.LEVEL_EXCEPTION);

186: l_sqlerrno := to_char(SQLCODE);
187: l_sqlerrmsg := substr(SQLERRM, 1,2000);
188: l_msg := ' Exception in spawn_perz_ins for for user_id: ' || p_user_id
189: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
190: CSM_UTIL_PKG.LOG(l_msg, 'csm_user_event_pkg.spawn_perz_ins',FND_LOG.LEVEL_EXCEPTION);
191: RAISE;
192: END spawn_perz_ins;
193:
194: PROCEDURE spawn_task_ins(p_user_id IN NUMBER)

Line 240: 'CSM_USER_EVENT_PKG.spawn_task_ins',FND_LOG.LEVEL_PROCEDURE);

236:
237:
238: BEGIN
239: CSM_UTIL_PKG.LOG('Entering spawn_task_ins for user_id: ' || p_user_id,
240: 'CSM_USER_EVENT_PKG.spawn_task_ins',FND_LOG.LEVEL_PROCEDURE);
241:
242: -- loop to spawn process
243: FOR l_task_rec IN l_task_csr(p_user_id) LOOP
244: csm_task_event_pkg.task_ins_init(p_task_id=>l_task_rec.task_id);

Line 248: 'CSM_USER_EVENT_PKG.spawn_task_ins',FND_LOG.LEVEL_PROCEDURE);

244: csm_task_event_pkg.task_ins_init(p_task_id=>l_task_rec.task_id);
245: END LOOP;
246:
247: CSM_UTIL_PKG.LOG('Leaving spawn_task_ins for user_id: ' || p_user_id,
248: 'CSM_USER_EVENT_PKG.spawn_task_ins',FND_LOG.LEVEL_PROCEDURE);
249: EXCEPTION
250: WHEN OTHERS THEN
251: l_sqlerrno := to_char(SQLCODE);
252: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 255: CSM_UTIL_PKG.LOG(l_error_msg, 'csm_user_event_pkg.spawn_task_ins',FND_LOG.LEVEL_EXCEPTION);

251: l_sqlerrno := to_char(SQLCODE);
252: l_sqlerrmsg := substr(SQLERRM, 1,2000);
253: l_error_msg := ' Exception in spawn_task_ins for for user_id: ' || p_user_id
254: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
255: CSM_UTIL_PKG.LOG(l_error_msg, 'csm_user_event_pkg.spawn_task_ins',FND_LOG.LEVEL_EXCEPTION);
256: RAISE;
257: END spawn_task_ins;
258:
259: --12.1XB6

Line 294: 'CSM_USER_EVENT_PKG.spawn_incident_ins',FND_LOG.LEVEL_PROCEDURE);

290: l_group_id NUMBER;
291: l_user_id NUMBER;
292: BEGIN
293: CSM_UTIL_PKG.LOG('Entering spawn_incident_ins for user_id: ' || p_user_id,
294: 'CSM_USER_EVENT_PKG.spawn_incident_ins',FND_LOG.LEVEL_PROCEDURE);
295:
296: OPEN c_get_group(p_user_id);
297: FETCH c_get_group INTO l_group_id,l_user_id;
298: CLOSE c_get_group;

Line 308: 'CSM_USER_EVENT_PKG.spawn_incident_ins',FND_LOG.LEVEL_PROCEDURE);

304: END LOOP;
305: END IF;
306:
307: CSM_UTIL_PKG.LOG('Leaving spawn_incident_ins for user_id: ' || p_user_id,
308: 'CSM_USER_EVENT_PKG.spawn_incident_ins',FND_LOG.LEVEL_PROCEDURE);
309: EXCEPTION
310: WHEN OTHERS THEN
311: l_sqlerrno := to_char(SQLCODE);
312: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 315: CSM_UTIL_PKG.LOG(l_error_msg, 'csm_user_event_pkg.spawn_incident_ins',FND_LOG.LEVEL_EXCEPTION);

311: l_sqlerrno := to_char(SQLCODE);
312: l_sqlerrmsg := substr(SQLERRM, 1,2000);
313: l_error_msg := ' Exception in spawn_incident_ins for for user_id: ' || p_user_id
314: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
315: CSM_UTIL_PKG.LOG(l_error_msg, 'csm_user_event_pkg.spawn_incident_ins',FND_LOG.LEVEL_EXCEPTION);
316: RAISE;
317: END spawn_incident_ins;
318:
319: PROCEDURE spawn_task_assignment_ins(p_user_id IN NUMBER)

Line 373: 'CSM_USER_EVENT_PKG.spawn_task_assignment_ins',FND_LOG.LEVEL_PROCEDURE);

369: l_task_assign_rec l_task_assign_csr% ROWTYPE;
370:
371: BEGIN
372: CSM_UTIL_PKG.LOG('Entering spawn_task_assignment_ins for user_id: ' || p_user_id,
373: 'CSM_USER_EVENT_PKG.spawn_task_assignment_ins',FND_LOG.LEVEL_PROCEDURE);
374:
375: -- loop to spawn process
376: FOR l_task_assign_rec IN l_task_assign_csr(p_user_id) LOOP
377: csm_task_assignment_event_pkg.task_assignment_initializer(p_task_assignment_id=>l_task_assign_rec.task_assignment_id,

Line 383: 'CSM_USER_EVENT_PKG.spawn_task_assignment_ins',FND_LOG.LEVEL_PROCEDURE);

379: x_return_status=>l_return_status);
380: END LOOP;
381:
382: CSM_UTIL_PKG.LOG('Leaving spawn_task_assignment_ins for user_id: ' || p_user_id,
383: 'CSM_USER_EVENT_PKG.spawn_task_assignment_ins',FND_LOG.LEVEL_PROCEDURE);
384: EXCEPTION
385: WHEN OTHERS THEN
386: l_sqlerrno := to_char(SQLCODE);
387: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 390: CSM_UTIL_PKG.LOG(l_error_msg, 'csm_user_event_pkg.spawn_task_assignment_ins',FND_LOG.LEVEL_EXCEPTION);

386: l_sqlerrno := to_char(SQLCODE);
387: l_sqlerrmsg := substr(SQLERRM, 1,2000);
388: l_error_msg := ' Exception in spawn_task_assignment_ins for for user_id: ' || p_user_id
389: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
390: CSM_UTIL_PKG.LOG(l_error_msg, 'csm_user_event_pkg.spawn_task_assignment_ins',FND_LOG.LEVEL_EXCEPTION);
391: RAISE;
392: END spawn_task_assignment_ins;
393:
394: PROCEDURE items_acc_processor(p_user_id IN NUMBER)

Line 406: 'csm_user_event_pkg.items_acc_processor',FND_LOG.LEVEL_PROCEDURE);

402: l_category_set_id NUMBER;
403:
404: BEGIN
405: CSM_UTIL_PKG.LOG('Entering items_acc_processor for user_id: ' || p_user_id,
406: 'csm_user_event_pkg.items_acc_processor',FND_LOG.LEVEL_PROCEDURE);
407:
408: l_organization_id := csm_profile_pkg.get_organization_id(p_user_id);
409: l_category_set_id := csm_profile_pkg.get_category_set_id(p_user_id);
410: l_category_id := csm_profile_pkg.get_category_id(p_user_id);

Line 429: 'csm_user_event_pkg.items_acc_processor',FND_LOG.LEVEL_PROCEDURE);

425: csm_mtl_system_items_event_pkg.get_new_user_mtl_system_items(p_user_id=>p_user_id, p_organization_id=>l_organization_id,
426: p_category_set_id=>l_category_set_id, p_category_id=>l_category_id);
427:
428: CSM_UTIL_PKG.LOG('Leaving items_acc_processor for user_id: ' || p_user_id,
429: 'csm_user_event_pkg.items_acc_processor',FND_LOG.LEVEL_PROCEDURE);
430: EXCEPTION
431: WHEN OTHERS THEN
432: l_sqlerrno := TO_CHAR(SQLCODE);
433: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);

Line 436: CSM_UTIL_PKG.LOG(l_error_msg, 'csm_user_event_pkg.items_acc_processor',FND_LOG.LEVEL_EXCEPTION);

432: l_sqlerrno := TO_CHAR(SQLCODE);
433: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
434: l_error_msg := ' Exception in items_acc_processor for user_id :'
435: || to_char(p_user_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
436: CSM_UTIL_PKG.LOG(l_error_msg, 'csm_user_event_pkg.items_acc_processor',FND_LOG.LEVEL_EXCEPTION);
437: RAISE;
438: END items_acc_processor;
439:
440: PROCEDURE spawn_inv_loc_assignment_ins(p_resource_id IN NUMBER, p_user_id IN NUMBER)

Line 456: 'csm_user_event_pkg.spawn_inv_loc_assignment_ins',FND_LOG.LEVEL_PROCEDURE);

452: AND SYSDATE BETWEEN nvl(effective_date_start, SYSDATE) AND nvl(effective_date_end, SYSDATE);
453:
454: BEGIN
455: CSM_UTIL_PKG.LOG('Entering spawn_inv_loc_assignment_ins for user_id: ' || p_user_id,
456: 'csm_user_event_pkg.spawn_inv_loc_assignment_ins',FND_LOG.LEVEL_PROCEDURE);
457:
458: IF csm_util_pkg.is_palm_resource(p_resource_id) THEN
459: FOR r_csp_inv_loc_assignment_rec IN l_csp_inv_loc_assignment_csr(p_resource_id) LOOP
460: CSM_INV_LOC_ASS_EVENT_PKG.INV_LOC_ASSIGNMENT_INS_INIT

Line 466: 'csm_user_event_pkg.spawn_inv_loc_assignment_ins',FND_LOG.LEVEL_PROCEDURE);

462: END LOOP;
463: END IF;
464:
465: CSM_UTIL_PKG.LOG('Leaving spawn_inv_loc_assignment_ins for user_id: ' || p_user_id,
466: 'csm_user_event_pkg.spawn_inv_loc_assignment_ins',FND_LOG.LEVEL_PROCEDURE);
467: EXCEPTION
468: WHEN OTHERS THEN
469: l_sqlerrno := TO_CHAR(SQLCODE);
470: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);

Line 473: CSM_UTIL_PKG.LOG(l_error_msg, 'csm_user_event_pkg.spawn_inv_loc_assignment_ins',FND_LOG.LEVEL_EXCEPTION);

469: l_sqlerrno := TO_CHAR(SQLCODE);
470: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
471: l_error_msg := ' Exception in spawn_inv_loc_assignment_ins for user_id :'
472: || to_char(p_user_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
473: CSM_UTIL_PKG.LOG(l_error_msg, 'csm_user_event_pkg.spawn_inv_loc_assignment_ins',FND_LOG.LEVEL_EXCEPTION);
474: RAISE;
475: END spawn_inv_loc_assignment_ins;
476:
477: PROCEDURE spawn_po_loc_ass_all_ins(p_resource_id IN NUMBER, p_user_id IN NUMBER)

Line 511: 'csm_user_event_pkg.spawn_po_loc_ass_all_ins',FND_LOG.LEVEL_PROCEDURE);

507: AND jtrs.resource_id = p_resource_id;
508:
509: BEGIN
510: CSM_UTIL_PKG.LOG('Entering spawn_po_loc_ass_all_ins for user_id: ' || p_user_id,
511: 'csm_user_event_pkg.spawn_po_loc_ass_all_ins',FND_LOG.LEVEL_PROCEDURE);
512:
513: IF csm_util_pkg.is_palm_resource(p_resource_id) THEN
514:
515: FOR r_po_loc_ass_all_rec IN l_po_loc_ass_all_csr(p_resource_id) LOOP

Line 532: 'csm_user_event_pkg.spawn_po_loc_ass_all_ins',FND_LOG.LEVEL_PROCEDURE);

528:
529: END IF;
530:
531: CSM_UTIL_PKG.LOG('Leaving spawn_po_loc_ass_all_ins for user_id: ' || p_user_id,
532: 'csm_user_event_pkg.spawn_po_loc_ass_all_ins',FND_LOG.LEVEL_PROCEDURE);
533: EXCEPTION
534: WHEN OTHERS THEN
535: l_sqlerrno := TO_CHAR(SQLCODE);
536: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);

Line 539: CSM_UTIL_PKG.LOG(l_error_msg, 'csm_user_event_pkg.spawn_po_loc_ass_all_ins',FND_LOG.LEVEL_EXCEPTION);

535: l_sqlerrno := TO_CHAR(SQLCODE);
536: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
537: l_error_msg := ' Exception in spawn_po_loc_ass_all_ins for user_id :'
538: || to_char(p_user_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
539: CSM_UTIL_PKG.LOG(l_error_msg, 'csm_user_event_pkg.spawn_po_loc_ass_all_ins',FND_LOG.LEVEL_EXCEPTION);
540: RAISE;
541: END spawn_po_loc_ass_all_ins;
542:
543: PROCEDURE spawn_csp_req_headers_ins(p_resource_id IN NUMBER, p_user_id IN NUMBER)

Line 568: 'csm_user_event_pkg.spawn_csp_req_headers_ins',FND_LOG.LEVEL_PROCEDURE);

564: );
565:
566: BEGIN
567: CSM_UTIL_PKG.LOG('Entering spawn_csp_req_headers_ins for user_id: ' || p_user_id,
568: 'csm_user_event_pkg.spawn_csp_req_headers_ins',FND_LOG.LEVEL_PROCEDURE);
569:
570: IF csm_util_pkg.is_palm_resource(p_resource_id) THEN
571:
572: FOR r_req_headers_rec IN l_req_headers_csr(p_resource_id) LOOP

Line 581: 'csm_user_event_pkg.spawn_csp_req_headers_ins',FND_LOG.LEVEL_PROCEDURE);

577:
578: END IF;
579:
580: CSM_UTIL_PKG.LOG('Leaving spawn_csp_req_headers_ins for user_id: ' || p_user_id,
581: 'csm_user_event_pkg.spawn_csp_req_headers_ins',FND_LOG.LEVEL_PROCEDURE);
582: EXCEPTION
583: WHEN OTHERS THEN
584: l_sqlerrno := TO_CHAR(SQLCODE);
585: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);

Line 588: CSM_UTIL_PKG.LOG(l_error_msg, 'csm_user_event_pkg.spawn_csp_req_headers_ins',FND_LOG.LEVEL_EXCEPTION);

584: l_sqlerrno := TO_CHAR(SQLCODE);
585: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
586: l_error_msg := ' Exception in spawn_csp_req_headers_ins for user_id :'
587: || to_char(p_user_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
588: CSM_UTIL_PKG.LOG(l_error_msg, 'csm_user_event_pkg.spawn_csp_req_headers_ins',FND_LOG.LEVEL_EXCEPTION);
589: RAISE;
590: END spawn_csp_req_headers_ins;
591:
592: PROCEDURE spawn_csp_req_lines_ins(p_resource_id IN NUMBER, p_user_id IN NUMBER)

Line 620: 'csm_user_event_pkg.spawn_csp_req_lines_ins',FND_LOG.LEVEL_PROCEDURE);

616: );
617:
618: BEGIN
619: CSM_UTIL_PKG.LOG('Entering spawn_csp_req_lines_ins for user_id: ' || p_user_id,
620: 'csm_user_event_pkg.spawn_csp_req_lines_ins',FND_LOG.LEVEL_PROCEDURE);
621:
622: IF csm_util_pkg.is_palm_resource(p_resource_id) THEN
623:
624: FOR r_req_lines_rec IN l_req_lines_csr(p_resource_id) LOOP

Line 633: 'csm_user_event_pkg.spawn_csp_req_lines_ins',FND_LOG.LEVEL_PROCEDURE);

629:
630: END IF;
631:
632: CSM_UTIL_PKG.LOG('Leaving spawn_csp_req_lines_ins for user_id: ' || p_user_id,
633: 'csm_user_event_pkg.spawn_csp_req_lines_ins',FND_LOG.LEVEL_PROCEDURE);
634: EXCEPTION
635: WHEN OTHERS THEN
636: l_sqlerrno := TO_CHAR(SQLCODE);
637: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);

Line 640: CSM_UTIL_PKG.LOG(l_error_msg, 'csm_user_event_pkg.spawn_csp_req_lines_ins',FND_LOG.LEVEL_EXCEPTION);

636: l_sqlerrno := TO_CHAR(SQLCODE);
637: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
638: l_error_msg := ' Exception in spawn_csp_req_lines_ins for user_id :'
639: || to_char(p_user_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
640: CSM_UTIL_PKG.LOG(l_error_msg, 'csm_user_event_pkg.spawn_csp_req_lines_ins',FND_LOG.LEVEL_EXCEPTION);
641: RAISE;
642: END spawn_csp_req_lines_ins;
643:
644: PROCEDURE enable_user_pub_synch(p_user_id IN NUMBER)

Line 653: 'csm_user_event_pkg.enable_user_pub_synch',FND_LOG.LEVEL_PROCEDURE);

649: l_return_status VARCHAR2(2000);
650:
651: BEGIN
652: CSM_UTIL_PKG.LOG('Entering enable_user_pub_synch for user_id:' || p_user_id,
653: 'csm_user_event_pkg.enable_user_pub_synch',FND_LOG.LEVEL_PROCEDURE);
654:
655: asg_helper.enable_user_pub_synch(p_user_id, 'SERVICEP');
656:
657: CSM_UTIL_PKG.LOG('Leaving enable_user_pub_synch for user_id:' || p_user_id,

Line 658: 'csm_user_event_pkg.enable_user_pub_synch',FND_LOG.LEVEL_PROCEDURE);

654:
655: asg_helper.enable_user_pub_synch(p_user_id, 'SERVICEP');
656:
657: CSM_UTIL_PKG.LOG('Leaving enable_user_pub_synch for user_id:' || p_user_id,
658: 'csm_user_event_pkg.enable_user_pub_synch',FND_LOG.LEVEL_PROCEDURE);
659: EXCEPTION
660: WHEN OTHERS THEN
661: l_sqlerrno := to_char(SQLCODE);
662: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 665: CSM_UTIL_PKG.LOG(l_error_msg, 'csm_user_event_pkg.enable_user_pub_synch',FND_LOG.LEVEL_EXCEPTION);

661: l_sqlerrno := to_char(SQLCODE);
662: l_sqlerrmsg := substr(SQLERRM, 1,2000);
663: l_error_msg := ' Exception in enable_user_pub_synch for for user_id: ' || p_user_id
664: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
665: CSM_UTIL_PKG.LOG(l_error_msg, 'csm_user_event_pkg.enable_user_pub_synch',FND_LOG.LEVEL_EXCEPTION);
666: RAISE;
667: END enable_user_pub_synch;
668:
669: PROCEDURE user_resp_ins_initializer (p_responsibility_id IN NUMBER, p_user_id IN NUMBER)

Line 686: 'CSM_USER_EVENT_PKG.USER_RESP_INS_INITIALIZER',FND_LOG.LEVEL_PROCEDURE);

682: WHERE user_id = p_user_id;
683:
684: BEGIN
685: CSM_UTIL_PKG.LOG('Entering USER_RESP_INS_INITIALIZER for user_id:' || p_user_id,
686: 'CSM_USER_EVENT_PKG.USER_RESP_INS_INITIALIZER',FND_LOG.LEVEL_PROCEDURE);
687:
688: -- check if responsibility is a MFS responsibility
689: IF NOT is_omfs_palm_responsibility(p_responsibility_id=>p_responsibility_id,
690: p_user_id=>p_user_id) THEN

Line 692: 'CSM_USER_EVENT_PKG.USER_RESP_INS_INITIALIZER',FND_LOG.LEVEL_EXCEPTION);

688: -- check if responsibility is a MFS responsibility
689: IF NOT is_omfs_palm_responsibility(p_responsibility_id=>p_responsibility_id,
690: p_user_id=>p_user_id) THEN
691: CSM_UTIL_PKG.LOG('Responsibility id: ' || p_responsibility_id || ' not a valid MFS responsibility for user_id:' || p_user_id,
692: 'CSM_USER_EVENT_PKG.USER_RESP_INS_INITIALIZER',FND_LOG.LEVEL_EXCEPTION);
693: RETURN;
694: END IF;
695:
696: -- get resource_id of the user

Line 783: 'CSM_USER_EVENT_PKG.USER_RESP_INS_INITIALIZER',FND_LOG.LEVEL_PROCEDURE);

779: -- enable user sync
780: csm_user_event_pkg.enable_user_pub_synch(p_user_id=>p_user_id);
781:
782: CSM_UTIL_PKG.LOG('Leaving USER_RESP_INS_INITIALIZER for user_id:' || p_user_id,
783: 'CSM_USER_EVENT_PKG.USER_RESP_INS_INITIALIZER',FND_LOG.LEVEL_PROCEDURE);
784: EXCEPTION
785: WHEN OTHERS THEN
786: l_sqlerrno := to_char(SQLCODE);
787: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 790: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_USER_EVENT_PKG.USER_RESP_INS_INITIALIZER',FND_LOG.LEVEL_EXCEPTION);

786: l_sqlerrno := to_char(SQLCODE);
787: l_sqlerrmsg := substr(SQLERRM, 1,2000);
788: l_error_msg := ' Exception in USER_RESP_INS_INITIALIZER for for user_id: ' || p_user_id
789: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
790: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_USER_EVENT_PKG.USER_RESP_INS_INITIALIZER',FND_LOG.LEVEL_EXCEPTION);
791: RAISE;
792: END USER_RESP_INS_INITIALIZER;
793:
794: PROCEDURE user_del_init(p_user_id IN NUMBER)

Line 803: 'csm_user_event_pkg.user_del_init',FND_LOG.LEVEL_PROCEDURE);

799: l_return_status VARCHAR2(2000);
800:
801: BEGIN
802: CSM_UTIL_PKG.LOG('Entering user_del_init for user_id:' || p_user_id,
803: 'csm_user_event_pkg.user_del_init',FND_LOG.LEVEL_PROCEDURE);
804:
805: -- purge all ACC tables
806: csm_user_event_pkg.purge_all_acc_tables(p_user_id=>p_user_id);
807:

Line 809: 'csm_user_event_pkg.user_del_init',FND_LOG.LEVEL_PROCEDURE);

805: -- purge all ACC tables
806: csm_user_event_pkg.purge_all_acc_tables(p_user_id=>p_user_id);
807:
808: CSM_UTIL_PKG.LOG('Leaving user_del_init for user_id:' || p_user_id,
809: 'csm_user_event_pkg.user_del_init',FND_LOG.LEVEL_PROCEDURE);
810: EXCEPTION
811: WHEN OTHERS THEN
812: l_sqlerrno := to_char(SQLCODE);
813: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 816: CSM_UTIL_PKG.LOG(l_error_msg, 'csm_user_event_pkg.user_del_init',FND_LOG.LEVEL_EXCEPTION);

812: l_sqlerrno := to_char(SQLCODE);
813: l_sqlerrmsg := substr(SQLERRM, 1,2000);
814: l_error_msg := ' Exception in user_del_init for for user_id: ' || p_user_id
815: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
816: CSM_UTIL_PKG.LOG(l_error_msg, 'csm_user_event_pkg.user_del_init',FND_LOG.LEVEL_EXCEPTION);
817: RAISE;
818: END user_del_init;
819:
820: PROCEDURE purge_all_acc_tables(p_user_id IN NUMBER)

Line 829: 'csm_user_event_pkg.purge_all_acc_tables',FND_LOG.LEVEL_PROCEDURE);

825: l_return_status VARCHAR2(2000);
826:
827: BEGIN
828: CSM_UTIL_PKG.LOG('Entering purge_all_acc_tables for user_id:' || p_user_id,
829: 'csm_user_event_pkg.purge_all_acc_tables',FND_LOG.LEVEL_PROCEDURE);
830:
831: DELETE FROM CSM_DEBRIEF_LINES_ACC WHERE user_id = p_user_id;
832: DELETE FROM CSM_DEBRIEF_HEADERS_ACC WHERE user_id = p_user_id;
833: DELETE FROM CSM_ITEM_INSTANCES_ACC WHERE user_id = p_user_id;

Line 907: 'csm_user_event_pkg.purge_all_acc_tables',FND_LOG.LEVEL_PROCEDURE);

903: ,x_return_status =>l_return_status
904: ,x_error_message =>l_error_msg);
905:
906: CSM_UTIL_PKG.LOG('Leaving purge_all_acc_tables for user_id:' || p_user_id,
907: 'csm_user_event_pkg.purge_all_acc_tables',FND_LOG.LEVEL_PROCEDURE);
908: EXCEPTION
909: WHEN OTHERS THEN
910: l_sqlerrno := to_char(SQLCODE);
911: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 914: CSM_UTIL_PKG.LOG(l_error_msg, 'csm_user_event_pkg.purge_all_acc_tables',FND_LOG.LEVEL_EXCEPTION);

910: l_sqlerrno := to_char(SQLCODE);
911: l_sqlerrmsg := substr(SQLERRM, 1,2000);
912: l_error_msg := ' Exception in purge_all_acc_tables for for user_id: ' || p_user_id
913: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
914: CSM_UTIL_PKG.LOG(l_error_msg, 'csm_user_event_pkg.purge_all_acc_tables',FND_LOG.LEVEL_EXCEPTION);
915: RAISE;
916: END purge_all_acc_tables;
917:
918: --Populate PIs related to parts transfer

Line 927: 'CSM_USER_EVENT_PKG.spawn_mat_txn',FND_LOG.LEVEL_PROCEDURE);

923: l_msg VARCHAR2(4000);
924: l_status VARCHAR2(40);
925: BEGIN
926: CSM_UTIL_PKG.LOG('Entering spawn_mat_txn for user_id: ' || p_user_id,
927: 'CSM_USER_EVENT_PKG.spawn_mat_txn',FND_LOG.LEVEL_PROCEDURE);
928:
929: CSM_MTL_MATERIAL_TXN_ACC_PKG.get_new_user_mat_txn(p_user_id);
930:
931: CSM_UTIL_PKG.LOG('Leaving spawn_mat_txn for user_id: ' || p_user_id,

Line 932: 'CSM_USER_EVENT_PKG.spawn_mat_txn',FND_LOG.LEVEL_PROCEDURE);

928:
929: CSM_MTL_MATERIAL_TXN_ACC_PKG.get_new_user_mat_txn(p_user_id);
930:
931: CSM_UTIL_PKG.LOG('Leaving spawn_mat_txn for user_id: ' || p_user_id,
932: 'CSM_USER_EVENT_PKG.spawn_mat_txn',FND_LOG.LEVEL_PROCEDURE);
933: EXCEPTION
934: WHEN OTHERS THEN
935: l_sqlerrno := to_char(SQLCODE);
936: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 939: CSM_UTIL_PKG.LOG(l_msg, 'csm_user_event_pkg.spawn_perz_ins',FND_LOG.LEVEL_EXCEPTION);

935: l_sqlerrno := to_char(SQLCODE);
936: l_sqlerrmsg := substr(SQLERRM, 1,2000);
937: l_msg := ' Exception in spawn_perz_ins for for user_id: ' || p_user_id
938: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
939: CSM_UTIL_PKG.LOG(l_msg, 'csm_user_event_pkg.spawn_perz_ins',FND_LOG.LEVEL_EXCEPTION);
940: RAISE;
941: END spawn_mat_txn;
942:
943: --PROCEDURE TO DOWNLOAD SERIAL NUMBERS DURING USER CREATION.

Line 953: 'CSM_USER_EVENT_PKG.spawn_mtl_serial_numbers',FND_LOG.LEVEL_PROCEDURE);

949: l_error_msg VARCHAR(4000);
950:
951: BEGIN
952: CSM_UTIL_PKG.LOG('Entering spawn_mtl_serial_numbers for User_id ' || p_user_id,
953: 'CSM_USER_EVENT_PKG.spawn_mtl_serial_numbers',FND_LOG.LEVEL_PROCEDURE);
954:
955: l_organization_id := csm_profile_pkg.get_organization_id(p_user_id);
956:
957: --get all the serial numbers for the User

Line 961: 'CSM_USER_EVENT_PKG.spawn_mtl_serial_numbers',FND_LOG.LEVEL_PROCEDURE);

957: --get all the serial numbers for the User
958: CSM_SERIAL_NUMBERS_EVENT_PKG.insert_mtl_serial_numbers(l_organization_id,TO_DATE('1','J'),p_resource_id,p_user_id);
959:
960: CSM_UTIL_PKG.LOG('Leaving spawn_mtl_serial_numbers for User_id ' || p_user_id,
961: 'CSM_USER_EVENT_PKG.spawn_mtl_serial_numbers',FND_LOG.LEVEL_PROCEDURE);
962:
963: EXCEPTION
964: WHEN OTHERS THEN
965: l_sqlerrno := TO_CHAR(SQLCODE);

Line 970: CSM_UTIL_PKG.LOG(l_error_msg,'CSM_USER_EVENT_PKG.spawn_mtl_serial_numbers',FND_LOG.LEVEL_EXCEPTION);

966: l_sqlerrmsg := TO_CHAR(SQLERRM);
967: l_error_msg := 'Exception in spawn_mtl_serial_numbers for User_id '
968: || TO_CHAR(p_user_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
969:
970: CSM_UTIL_PKG.LOG(l_error_msg,'CSM_USER_EVENT_PKG.spawn_mtl_serial_numbers',FND_LOG.LEVEL_EXCEPTION);
971: RAISE;
972: END spawn_mtl_serial_numbers;
973:
974: PROCEDURE INSERT_ACC (p_user_id IN NUMBER

Line 1015: 'CSM_USER_EVENT_PKG.INSERT_ACC',FND_LOG.LEVEL_PROCEDURE);

1011: AND USR.USER_ID = ACC.USER_ID;
1012:
1013: BEGIN
1014: CSM_UTIL_PKG.LOG('Entering INSERT_ACC for User_id ' || p_user_id,
1015: 'CSM_USER_EVENT_PKG.INSERT_ACC',FND_LOG.LEVEL_PROCEDURE);
1016: OPEN c_asg_user(p_user_id);
1017: FETCH c_asg_user INTO l_user_id,l_owner_id,l_group_id;
1018: CLOSE c_asg_user;
1019:

Line 1040: 'CSM_USER_EVENT_PKG.INSERT_ACC',FND_LOG.LEVEL_PROCEDURE);

1036: , p_dml => 'I'
1037: , P_TIMESTAMP => sysdate
1038: );
1039: CSM_UTIL_PKG.LOG('User is inserted into the Access table: User_id ' || p_user_id,
1040: 'CSM_USER_EVENT_PKG.INSERT_ACC',FND_LOG.LEVEL_PROCEDURE);
1041: --If the user is a owner
1042: IF l_user_id = l_owner_id AND l_group_id IS NOT NULL THEN
1043: OPEN c_group_users(l_owner_id);
1044: LOOP

Line 1079: 'CSM_USER_EVENT_PKG.INSERT_ACC',FND_LOG.LEVEL_PROCEDURE);

1075: CLOSE c_group_users;
1076:
1077: END IF;
1078: CSM_UTIL_PKG.LOG('Leaving INSERT_ACC for User_id ' || p_user_id,
1079: 'CSM_USER_EVENT_PKG.INSERT_ACC',FND_LOG.LEVEL_PROCEDURE);
1080: EXCEPTION
1081: WHEN OTHERS THEN
1082: l_sqlerrno := TO_CHAR(SQLCODE);
1083: l_sqlerrmsg := TO_CHAR(SQLERRM);

Line 1087: CSM_UTIL_PKG.LOG(l_error_msg,'CSM_USER_EVENT_PKG.INSERT_ACC',FND_LOG.LEVEL_EXCEPTION);

1083: l_sqlerrmsg := TO_CHAR(SQLERRM);
1084: l_error_msg := 'Exception in INSERT_ACC for User_id '
1085: || TO_CHAR(p_user_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1086:
1087: CSM_UTIL_PKG.LOG(l_error_msg,'CSM_USER_EVENT_PKG.INSERT_ACC',FND_LOG.LEVEL_EXCEPTION);
1088: RAISE;
1089: END INSERT_ACC;
1090:
1091: PROCEDURE DELETE_ACC (p_user_id IN NUMBER

Line 1114: 'CSM_USER_EVENT_PKG.DELETE_ACC',FND_LOG.LEVEL_PROCEDURE);

1110:
1111:
1112: BEGIN
1113: CSM_UTIL_PKG.LOG('Entering DELETE_ACC for User_id ' || p_user_id,
1114: 'CSM_USER_EVENT_PKG.DELETE_ACC',FND_LOG.LEVEL_PROCEDURE);
1115:
1116: OPEN c_user_acc(p_user_id);
1117: FETCH c_user_acc INTO l_access_id,l_user_id,l_owner_id;
1118: --Do mark dirty only for the User

Line 1133: 'CSM_USER_EVENT_PKG.DELETE_ACC',FND_LOG.LEVEL_PROCEDURE);

1129: --delete for owner,member or individual user
1130: DELETE FROM CSM_USER_ACC WHERE USER_ID =l_user_id;
1131:
1132: CSM_UTIL_PKG.LOG('User is Deleted From the Access table for User_id :' || p_user_id,
1133: 'CSM_USER_EVENT_PKG.DELETE_ACC',FND_LOG.LEVEL_PROCEDURE);
1134:
1135: END IF;
1136:
1137: CSM_UTIL_PKG.LOG('Leaving DELETE_ACC for User_id ' || p_user_id,

Line 1138: 'CSM_USER_EVENT_PKG.DELETE_ACC',FND_LOG.LEVEL_PROCEDURE);

1134:
1135: END IF;
1136:
1137: CSM_UTIL_PKG.LOG('Leaving DELETE_ACC for User_id ' || p_user_id,
1138: 'CSM_USER_EVENT_PKG.DELETE_ACC',FND_LOG.LEVEL_PROCEDURE);
1139: EXCEPTION
1140: WHEN OTHERS THEN
1141: l_sqlerrno := TO_CHAR(SQLCODE);
1142: l_sqlerrmsg := TO_CHAR(SQLERRM);

Line 1146: CSM_UTIL_PKG.LOG(l_error_msg,'CSM_USER_EVENT_PKG.DELETE_ACC',FND_LOG.LEVEL_EXCEPTION);

1142: l_sqlerrmsg := TO_CHAR(SQLERRM);
1143: l_error_msg := 'Exception in DELETE_ACC for User_id '
1144: || TO_CHAR(p_user_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1145:
1146: CSM_UTIL_PKG.LOG(l_error_msg,'CSM_USER_EVENT_PKG.DELETE_ACC',FND_LOG.LEVEL_EXCEPTION);
1147: RAISE;
1148: END DELETE_ACC;
1149:
1150: /*

Line 1176: 'CSM_USER_EVENT_PKG.INSERT_ACC',FND_LOG.LEVEL_PROCEDURE);

1172: AND OWNER_ID = b_owner_id;
1173:
1174: BEGIN
1175: CSM_UTIL_PKG.LOG('Entering INSERT_ACC for User_id ' || p_user_id ||' and owner_id: '||p_owner_id,
1176: 'CSM_USER_EVENT_PKG.INSERT_ACC',FND_LOG.LEVEL_PROCEDURE);
1177:
1178: OPEN c_user_acc(p_user_id,p_owner_id);
1179: FETCH c_user_acc INTO l_access_id;
1180: IF c_user_acc%FOUND THEN

Line 1182: 'CSM_USER_EVENT_PKG.INSERT_ACC',FND_LOG.LEVEL_PROCEDURE);

1178: OPEN c_user_acc(p_user_id,p_owner_id);
1179: FETCH c_user_acc INTO l_access_id;
1180: IF c_user_acc%FOUND THEN
1181: CSM_UTIL_PKG.LOG('Record already there in the Access table: (User_id,owner_id) : (' || p_user_id||','||p_owner_id||')',
1182: 'CSM_USER_EVENT_PKG.INSERT_ACC',FND_LOG.LEVEL_PROCEDURE);
1183: UPDATE CSM_USER_ACC SET COUNTER=COUNTER+1 ,LAST_UPDATE_DATE=sysdate WHERE ACCESS_ID=l_access_id;
1184: CLOSE c_user_acc;
1185: ELSE
1186:

Line 1195: 'CSM_USER_EVENT_PKG.INSERT_ACC',FND_LOG.LEVEL_PROCEDURE);

1191: INSERT INTO CSM_USER_ACC(ACCESS_ID,USER_ID,OWNER_ID,COUNTER,LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN)
1192: VALUES (l_access_id,p_user_id,p_owner_id,1,sysdate,1,sysdate,1,1);
1193:
1194: CSM_UTIL_PKG.LOG('Record inserted into the Access table: (User_id,owner_id) : (' || p_user_id||','||p_owner_id||') and Marking dirty',
1195: 'CSM_USER_EVENT_PKG.INSERT_ACC',FND_LOG.LEVEL_PROCEDURE);
1196:
1197: l_markdirty := asg_download.mark_dirty(
1198: p_pub_item => g_pub_item
1199: , p_accessid => l_access_id

Line 1206: CSM_UTIL_PKG.LOG('Leaving INSERT_ACC for User_id ' || p_user_id ||' and owner_id: '||p_owner_id,'CSM_USER_EVENT_PKG.INSERT_ACC',FND_LOG.LEVEL_PROCEDURE);

1202: , P_TIMESTAMP => sysdate
1203: );
1204: END IF;
1205:
1206: CSM_UTIL_PKG.LOG('Leaving INSERT_ACC for User_id ' || p_user_id ||' and owner_id: '||p_owner_id,'CSM_USER_EVENT_PKG.INSERT_ACC',FND_LOG.LEVEL_PROCEDURE);
1207: EXCEPTION
1208: WHEN OTHERS THEN
1209: l_sqlerrno := TO_CHAR(SQLCODE);
1210: l_sqlerrmsg := TO_CHAR(SQLERRM);

Line 1214: CSM_UTIL_PKG.LOG(l_error_msg,'CSM_USER_EVENT_PKG.INSERT_ACC',FND_LOG.LEVEL_EXCEPTION);

1210: l_sqlerrmsg := TO_CHAR(SQLERRM);
1211: l_error_msg := 'Exception in INSERT_ACC for User_id '
1212: || TO_CHAR(p_user_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1213:
1214: CSM_UTIL_PKG.LOG(l_error_msg,'CSM_USER_EVENT_PKG.INSERT_ACC',FND_LOG.LEVEL_EXCEPTION);
1215: RAISE;
1216: END INSERT_ACC;
1217:
1218: PROCEDURE DELETE_ACC (p_user_id IN NUMBER,p_owner_id IN NUMBER)

Line 1237: 'CSM_USER_EVENT_PKG.DELETE_ACC',FND_LOG.LEVEL_PROCEDURE);

1233: AND OWNER_ID = b_owner_id;
1234:
1235: BEGIN
1236: CSM_UTIL_PKG.LOG('Entering DELETE_ACC for User_id ' || p_user_id ||' and owner_id: '||p_owner_id,
1237: 'CSM_USER_EVENT_PKG.DELETE_ACC',FND_LOG.LEVEL_PROCEDURE);
1238:
1239: OPEN c_user_acc(p_user_id,p_owner_id);
1240: FETCH c_user_acc INTO l_access_id,l_counter;
1241:

Line 1261: 'CSM_USER_EVENT_PKG.DELETE_ACC',FND_LOG.LEVEL_PROCEDURE);

1257: END IF;
1258: END IF;
1259:
1260: CSM_UTIL_PKG.LOG('Leaving DELETE_ACC for User_id ' || p_user_id ||' and owner_id: '||p_owner_id,
1261: 'CSM_USER_EVENT_PKG.DELETE_ACC',FND_LOG.LEVEL_PROCEDURE);
1262: EXCEPTION
1263: WHEN OTHERS THEN
1264: l_sqlerrno := TO_CHAR(SQLCODE);
1265: l_sqlerrmsg := TO_CHAR(SQLERRM);

Line 1269: CSM_UTIL_PKG.LOG(l_error_msg,'CSM_USER_EVENT_PKG.DELETE_ACC',FND_LOG.LEVEL_EXCEPTION);

1265: l_sqlerrmsg := TO_CHAR(SQLERRM);
1266: l_error_msg := 'Exception in DELETE_ACC for User_id '
1267: || TO_CHAR(p_user_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
1268:
1269: CSM_UTIL_PKG.LOG(l_error_msg,'CSM_USER_EVENT_PKG.DELETE_ACC',FND_LOG.LEVEL_EXCEPTION);
1270: RAISE;
1271: END DELETE_ACC;
1272:
1273: