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 CSM_UTIL_PKG

Line 35: CSM_UTIL_PKG.LOG('Entering IS_OMFS_PALM_RESPONSIBILITY for user_id: ' || p_user_id || ' and responsibility_id: '

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

Line 47: CSM_UTIL_PKG.LOG('Leaving IS_OMFS_PALM_RESPONSIBILITY for user_id: ' || p_user_id || ' and responsibility_id: '

43: RETURN FALSE;
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

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 69: CSM_UTIL_PKG.LOG('Entering disable_user_pub_synch for user_id:' || p_user_id,

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

Line 74: CSM_UTIL_PKG.LOG('Leaving 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,
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);

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 106: CSM_UTIL_PKG.LOG('Entering IS_FIRST_OMFS_PALM_USER for user_id:' || p_user_id,

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

Line 117: CSM_UTIL_PKG.LOG('Leaving IS_FIRST_OMFS_PALM_USER for user_id:' || p_user_id,

113: RETURN FALSE;
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

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 138: CSM_UTIL_PKG.LOG('Entering spawn_dashboard_srch_cols_ins for user_id: ' || p_user_id,

134: l_sqlerrmsg VARCHAR2(4000);
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:

Line 143: CSM_UTIL_PKG.LOG('Leaving 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,
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);

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 163: CSM_UTIL_PKG.LOG('Entering spawn_perz_ins for user_id: ' || p_user_id,

159: l_sqlerrmsg VARCHAR2(4000);
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);

Line 166: CSM_UTIL_PKG.LOG('Populating PERSONALIZED CUSTOMIZATION VIEWS Access table',

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:
169: CSM_CUSTMZ_VIEWS_EVENT_PKG.REFRESH_USER(p_user_id);
170:

Line 171: CSM_UTIL_PKG.LOG('Populating PERSONALIZED DELTA PAGE 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',
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:

Line 177: CSM_UTIL_PKG.LOG('Populating PERSONALIZED NEW MESSAGES Access table',

173:
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:

Line 182: CSM_UTIL_PKG.LOG('Leaving spawn_perz_ins for user_id: ' || p_user_id,

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,
183: 'CSM_USER_EVENT_PKG.spawn_perz_ins',FND_LOG.LEVEL_PROCEDURE);
184: EXCEPTION
185: WHEN OTHERS THEN
186: l_sqlerrno := to_char(SQLCODE);

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 239: CSM_UTIL_PKG.LOG('Entering spawn_task_ins for user_id: ' || p_user_id,

235: );
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

Line 247: CSM_UTIL_PKG.LOG('Leaving spawn_task_ins for user_id: ' || p_user_id,

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

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 276: csm_util_pkg.get_owner(inc.created_by)=b_user_id

272: cs_incident_statuses_b ists
273: WHERE (
274: inc.owner_group_id = b_grp_id
275: OR
276: csm_util_pkg.get_owner(inc.created_by)=b_user_id
277: )
278: AND inc.INCIDENT_STATUS_ID = ists.INCIDENT_STATUS_ID
279: AND inc.install_site_id IS NOT NULL
280: AND NVL(ists.CLOSE_FLAG, 'N') <> 'Y';

Line 293: CSM_UTIL_PKG.LOG('Entering spawn_incident_ins for user_id: ' || p_user_id,

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

Line 307: CSM_UTIL_PKG.LOG('Leaving spawn_incident_ins for user_id: ' || p_user_id,

303: csm_sr_event_pkg.sr_ins_init(p_incident_id=>l_incident_rec.incident_id);
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);

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 372: CSM_UTIL_PKG.LOG('Entering spawn_task_assignment_ins for user_id: ' || p_user_id,

368:
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

Line 382: CSM_UTIL_PKG.LOG('Leaving spawn_task_assignment_ins for user_id: ' || p_user_id,

378: p_error_msg=>l_error_msg,
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);

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 405: CSM_UTIL_PKG.LOG('Entering items_acc_processor for user_id: ' || p_user_id,

401: l_category_id NUMBER;
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);

Line 428: CSM_UTIL_PKG.LOG('Leaving items_acc_processor for user_id: ' || p_user_id,

424: -- get all mtl_system_items for the user
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);

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 455: CSM_UTIL_PKG.LOG('Entering spawn_inv_loc_assignment_ins for user_id: ' || p_user_id,

451: AND resource_type = 'RS_EMPLOYEE'
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

Line 458: IF csm_util_pkg.is_palm_resource(p_resource_id) THEN

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
461: (p_csp_inv_loc_assignment_id=>r_csp_inv_loc_assignment_rec.csp_inv_loc_assignment_id);
462: END LOOP;

Line 465: CSM_UTIL_PKG.LOG('Leaving spawn_inv_loc_assignment_ins for user_id: ' || p_user_id,

461: (p_csp_inv_loc_assignment_id=>r_csp_inv_loc_assignment_rec.csp_inv_loc_assignment_id);
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);

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 510: CSM_UTIL_PKG.LOG('Entering spawn_po_loc_ass_all_ins for user_id: ' || p_user_id,

506: AND jtrs.resource_id = rcr.resource_id
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:

Line 513: IF csm_util_pkg.is_palm_resource(p_resource_id) THEN

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
516: csm_party_site_event_pkg.party_sites_acc_i
517: (p_party_site_id=>r_po_loc_ass_all_rec.party_site_id,

Line 531: CSM_UTIL_PKG.LOG('Leaving spawn_po_loc_ass_all_ins for user_id: ' || p_user_id,

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

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 567: CSM_UTIL_PKG.LOG('Entering spawn_csp_req_headers_ins for user_id: ' || p_user_id,

563: AND acc.user_id = jtrs.user_id
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:

Line 570: IF csm_util_pkg.is_palm_resource(p_resource_id) THEN

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
573: csm_csp_req_headers_event_pkg.csp_req_headers_mdirty_i
574: (p_requirement_header_id=>r_req_headers_rec.requirement_header_id,

Line 580: CSM_UTIL_PKG.LOG('Leaving spawn_csp_req_headers_ins for user_id: ' || p_user_id,

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

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 619: CSM_UTIL_PKG.LOG('Entering spawn_csp_req_lines_ins for user_id: ' || p_user_id,

615: AND acc.user_id = jtrs.user_id
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:

Line 622: IF csm_util_pkg.is_palm_resource(p_resource_id) THEN

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
625: csm_csp_req_lines_event_pkg.csp_req_lines_mdirty_i
626: (p_requirement_line_id=>r_req_lines_rec.requirement_line_id,

Line 632: CSM_UTIL_PKG.LOG('Leaving spawn_csp_req_lines_ins for user_id: ' || p_user_id,

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

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 652: CSM_UTIL_PKG.LOG('Entering enable_user_pub_synch for user_id:' || p_user_id,

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

Line 657: CSM_UTIL_PKG.LOG('Leaving 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,
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);

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 685: CSM_UTIL_PKG.LOG('Entering USER_RESP_INS_INITIALIZER for user_id:' || p_user_id,

681: FROM asg_user
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,

Line 691: CSM_UTIL_PKG.LOG('Responsibility id: ' || p_responsibility_id || ' not a valid MFS responsibility for user_id:' || p_user_id,

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

Line 782: CSM_UTIL_PKG.LOG('Leaving USER_RESP_INS_INITIALIZER for user_id:' || p_user_id,

778:
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);

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 802: CSM_UTIL_PKG.LOG('Entering user_del_init for user_id:' || p_user_id,

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

Line 808: CSM_UTIL_PKG.LOG('Leaving user_del_init for user_id:' || p_user_id,

804:
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);

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 828: CSM_UTIL_PKG.LOG('Entering purge_all_acc_tables for user_id:' || p_user_id,

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

Line 906: CSM_UTIL_PKG.LOG('Leaving purge_all_acc_tables for user_id:' || p_user_id,

902: CSM_USER_EVENT_PKG.DELETE_ACC (p_user_id =>p_user_id
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);

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 926: CSM_UTIL_PKG.LOG('Entering spawn_mat_txn for user_id: ' || p_user_id,

922: l_sqlerrmsg VARCHAR2(4000);
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:

Line 931: CSM_UTIL_PKG.LOG('Leaving 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,
932: 'CSM_USER_EVENT_PKG.spawn_mat_txn',FND_LOG.LEVEL_PROCEDURE);
933: EXCEPTION
934: WHEN OTHERS THEN
935: l_sqlerrno := to_char(SQLCODE);

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 952: CSM_UTIL_PKG.LOG('Entering spawn_mtl_serial_numbers for User_id ' || p_user_id,

948: l_sqlerrmsg VARCHAR(4000);
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:

Line 960: CSM_UTIL_PKG.LOG('Leaving spawn_mtl_serial_numbers for User_id ' || p_user_id,

956:
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

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 1014: CSM_UTIL_PKG.LOG('Entering INSERT_ACC for User_id ' || p_user_id,

1010: WHERE USR.OWNER_ID=l_owner_id
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;

Line 1039: CSM_UTIL_PKG.LOG('User is inserted into the Access table: User_id ' || p_user_id,

1035: , p_userid => l_owner_id
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);

Line 1078: CSM_UTIL_PKG.LOG('Leaving INSERT_ACC for User_id ' || p_user_id,

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

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 1113: CSM_UTIL_PKG.LOG('Entering DELETE_ACC for User_id ' || p_user_id,

1109: WHERE USER_ID=l_user_id;
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;

Line 1132: CSM_UTIL_PKG.LOG('User is Deleted From the Access table for User_id :' || p_user_id,

1128: END IF;
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:

Line 1137: CSM_UTIL_PKG.LOG('Leaving DELETE_ACC 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,
1138: 'CSM_USER_EVENT_PKG.DELETE_ACC',FND_LOG.LEVEL_PROCEDURE);
1139: EXCEPTION
1140: WHEN OTHERS THEN
1141: l_sqlerrno := TO_CHAR(SQLCODE);

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 1175: CSM_UTIL_PKG.LOG('Entering INSERT_ACC for User_id ' || p_user_id ||' and owner_id: '||p_owner_id,

1171: WHERE USER_ID=b_user_id
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;

Line 1181: CSM_UTIL_PKG.LOG('Record already there in the Access table: (User_id,owner_id) : (' || p_user_id||','||p_owner_id||')',

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

Line 1194: CSM_UTIL_PKG.LOG('Record inserted into the Access table: (User_id,owner_id) : (' || p_user_id||','||p_owner_id||') and Marking dirty',

1190:
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

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 1236: CSM_UTIL_PKG.LOG('Entering DELETE_ACC for User_id ' || p_user_id ||' and owner_id: '||p_owner_id,

1232: WHERE USER_ID=b_user_id
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;

Line 1260: CSM_UTIL_PKG.LOG('Leaving DELETE_ACC for User_id ' || p_user_id ||' and owner_id: '||p_owner_id,

1256: AND OWNER_ID=p_owner_id;
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);

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: