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

Line 24: CSM_UTIL_PKG.LOG('Entering RESOURCE_EXTNS_ACC_I for resource_id: ' || p_resource_id,

20: l_error_msg VARCHAR2(4000);
21: l_return_status VARCHAR2(2000);
22:
23: BEGIN
24: CSM_UTIL_PKG.LOG('Entering RESOURCE_EXTNS_ACC_I for resource_id: ' || p_resource_id,
25: 'CSM_RESOURCE_EXTNS_EVENT_PKG.RESOURCE_EXTNS_ACC_I',FND_LOG.LEVEL_PROCEDURE);
26:
27: CSM_ACC_PKG.Insert_Acc
28: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1

Line 36: CSM_UTIL_PKG.LOG('Leaving RESOURCE_EXTNS_ACC_I for resource_id: ' || p_resource_id,

32: , P_PK1_NUM_VALUE => p_resource_id
33: , P_USER_ID => p_user_id
34: );
35:
36: CSM_UTIL_PKG.LOG('Leaving RESOURCE_EXTNS_ACC_I for resource_id: ' || p_resource_id,
37: 'CSM_RESOURCE_EXTNS_EVENT_PKG.RESOURCE_EXTNS_ACC_I',FND_LOG.LEVEL_PROCEDURE);
38: EXCEPTION
39: WHEN OTHERS THEN
40: l_sqlerrno := to_char(SQLCODE);

Line 44: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_RESOURCE_EXTNS_EVENT_PKG.RESOURCE_EXTNS_ACC_I',FND_LOG.LEVEL_EXCEPTION);

40: l_sqlerrno := to_char(SQLCODE);
41: l_sqlerrmsg := substr(SQLERRM, 1,2000);
42: l_error_msg := ' Exception in RESOURCE_EXTNS_ACC_I for resource_id:' || to_char(p_resource_id)
43: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
44: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_RESOURCE_EXTNS_EVENT_PKG.RESOURCE_EXTNS_ACC_I',FND_LOG.LEVEL_EXCEPTION);
45: RAISE;
46: END RESOURCE_EXTNS_ACC_I;
47:
48: PROCEDURE RESOURCE_EXTNS_ACC_D (p_resource_id IN NUMBER, p_user_id IN NUMBER )

Line 56: CSM_UTIL_PKG.LOG('Entering RESOURCE_EXTNS_ACC_D for resource_id: ' || p_resource_id,

52: l_error_msg VARCHAR2(4000);
53: l_return_status VARCHAR2(2000);
54:
55: BEGIN
56: CSM_UTIL_PKG.LOG('Entering RESOURCE_EXTNS_ACC_D for resource_id: ' || p_resource_id,
57: 'CSM_RESOURCE_EXTNS_EVENT_PKG.RESOURCE_EXTNS_ACC_D',FND_LOG.LEVEL_PROCEDURE);
58:
59: CSM_ACC_PKG.Delete_Acc
60: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1

Line 67: CSM_UTIL_PKG.LOG('Leaving RESOURCE_EXTNS_ACC_D for resource_id: ' || p_resource_id,

63: , P_PK1_NUM_VALUE => p_resource_id
64: , P_USER_ID => p_user_id
65: );
66:
67: CSM_UTIL_PKG.LOG('Leaving RESOURCE_EXTNS_ACC_D for resource_id: ' || p_resource_id,
68: 'CSM_RESOURCE_EXTNS_EVENT_PKG.RESOURCE_EXTNS_ACC_D',FND_LOG.LEVEL_PROCEDURE);
69: EXCEPTION
70: WHEN OTHERS THEN
71: l_sqlerrno := to_char(SQLCODE);

Line 75: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_RESOURCE_EXTNS_EVENT_PKG.RESOURCE_EXTNS_ACC_D',FND_LOG.LEVEL_EXCEPTION);

71: l_sqlerrno := to_char(SQLCODE);
72: l_sqlerrmsg := substr(SQLERRM, 1,2000);
73: l_error_msg := ' Exception in RESOURCE_EXTNS_ACC_D for resource_id:' || to_char(p_resource_id)
74: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
75: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_RESOURCE_EXTNS_EVENT_PKG.RESOURCE_EXTNS_ACC_D',FND_LOG.LEVEL_EXCEPTION);
76: RAISE;
77: END RESOURCE_EXTNS_ACC_D;
78:
79: --Bug 5236469

Line 100: CSM_UTIL_PKG.LOG('Entering RESOURCE_EXTNS_ACC_CLEANUP for resource_id: ' || p_user_id,

96: l_resource_id NUMBER;
97:
98:
99: BEGIN
100: CSM_UTIL_PKG.LOG('Entering RESOURCE_EXTNS_ACC_CLEANUP for resource_id: ' || p_user_id,
101: 'CSM_RESOURCE_EXTNS_EVENT_PKG.RESOURCE_EXTNS_ACC_CLEANUP',FND_LOG.LEVEL_PROCEDURE);
102:
103: OPEN c_res(p_user_id);
104: FETCH c_res INTO l_resource_id;

Line 115: CSM_UTIL_PKG.LOG('Leaving RESOURCE_EXTNS_ACC_CLEANUP for resource_id: ' || p_user_id,

111:
112: --to remove old bad data from access table
113: DELETE FROM CSM_RS_RESOURCE_EXTNS_ACC WHERE resource_id=l_resource_id;
114:
115: CSM_UTIL_PKG.LOG('Leaving RESOURCE_EXTNS_ACC_CLEANUP for resource_id: ' || p_user_id,
116: 'CSM_RESOURCE_EXTNS_EVENT_PKG.RESOURCE_EXTNS_ACC_CLEANUP',FND_LOG.LEVEL_PROCEDURE);
117: EXCEPTION
118: WHEN OTHERS THEN
119: l_sqlerrno := to_char(SQLCODE);

Line 123: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_RESOURCE_EXTNS_EVENT_PKG.RESOURCE_EXTNS_ACC_CLEANUP',FND_LOG.LEVEL_EXCEPTION);

119: l_sqlerrno := to_char(SQLCODE);
120: l_sqlerrmsg := substr(SQLERRM, 1,2000);
121: l_error_msg := ' Exception in RESOURCE_EXTNS_ACC_CLEANUP for user_id:' || to_char(p_user_id)
122: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
123: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_RESOURCE_EXTNS_EVENT_PKG.RESOURCE_EXTNS_ACC_CLEANUP',FND_LOG.LEVEL_EXCEPTION);
124: RAISE;
125: END RESOURCE_EXTNS_ACC_CLEANUP;
126:
127: --Bug 5236469

Line 221: CSM_UTIL_PKG.LOG('Entering PROCESS_USER for resource_id: ' || p_resource_id,

217: l_error_msg VARCHAR2(4000);
218: l_return_status VARCHAR2(2000);
219:
220: BEGIN
221: CSM_UTIL_PKG.LOG('Entering PROCESS_USER for resource_id: ' || p_resource_id,
222: 'CSM_RESOURCE_EXTNS_EVENT_PKG.PROCESS_USER',FND_LOG.LEVEL_PROCEDURE);
223:
224: IF PROFILE_VALUE(p_user_id)=0 THEN --ALL MFS USERS
225:

Line 226: CSM_UTIL_PKG.LOG('DELETING FOR PROFILE-0 for user id : ' || p_user_id,

222: 'CSM_RESOURCE_EXTNS_EVENT_PKG.PROCESS_USER',FND_LOG.LEVEL_PROCEDURE);
223:
224: IF PROFILE_VALUE(p_user_id)=0 THEN --ALL MFS USERS
225:
226: CSM_UTIL_PKG.LOG('DELETING FOR PROFILE-0 for user id : ' || p_user_id,
227: 'CSM_RESOURCE_EXTNS_EVENT_PKG.PROCESS_USER',FND_LOG.LEVEL_PROCEDURE);
228: FOR user_rec IN c_delete_prof0(p_resource_id,p_user_id)
229: LOOP
230: RESOURCE_EXTNS_ACC_D(user_rec.resource_id,p_user_id);

Line 233: CSM_UTIL_PKG.LOG('INSERTING FOR PROFILE-0 for user id : ' || p_user_id,

229: LOOP
230: RESOURCE_EXTNS_ACC_D(user_rec.resource_id,p_user_id);
231: END LOOP;
232:
233: CSM_UTIL_PKG.LOG('INSERTING FOR PROFILE-0 for user id : ' || p_user_id,
234: 'CSM_RESOURCE_EXTNS_EVENT_PKG.PROCESS_USER',FND_LOG.LEVEL_PROCEDURE);
235: FOR user_rec IN c_insert_prof0(p_user_id)
236: LOOP
237: RESOURCE_EXTNS_ACC_I(user_rec.resource_id,p_user_id);

Line 242: CSM_UTIL_PKG.LOG('DELETING FOR PROFILE "1" for user id : ' || p_user_id,

238: END LOOP;
239:
240: ELSE
241:
242: CSM_UTIL_PKG.LOG('DELETING FOR PROFILE "1" for user id : ' || p_user_id,
243: 'CSM_RESOURCE_EXTNS_EVENT_PKG.PROCESS_USER',FND_LOG.LEVEL_PROCEDURE);
244:
245: FOR user_rec IN c_delete_prof2(p_resource_id,p_user_id)
246: LOOP

Line 250: CSM_UTIL_PKG.LOG('INSERTING FOR PROFILE "1" for user id : ' || p_user_id,

246: LOOP
247: RESOURCE_EXTNS_ACC_D(user_rec.resource_id,p_user_id);
248: END LOOP;
249:
250: CSM_UTIL_PKG.LOG('INSERTING FOR PROFILE "1" for user id : ' || p_user_id,
251: 'CSM_RESOURCE_EXTNS_EVENT_PKG.PROCESS_USER',FND_LOG.LEVEL_PROCEDURE);
252:
253: FOR user_rec IN c_grp_members(p_resource_id,p_user_id)
254: LOOP

Line 260: CSM_UTIL_PKG.LOG('Leaving PROCESS_USER for resource_id: ' || p_resource_id,

256: END LOOP;
257:
258: END IF;
259:
260: CSM_UTIL_PKG.LOG('Leaving PROCESS_USER for resource_id: ' || p_resource_id,
261: 'CSM_RESOURCE_EXTNS_EVENT_PKG.PROCESS_USER',FND_LOG.LEVEL_PROCEDURE);
262: EXCEPTION
263: WHEN OTHERS THEN
264: l_sqlerrno := to_char(SQLCODE);

Line 268: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_RESOURCE_EXTNS_EVENT_PKG.PROCESS_USER',FND_LOG.LEVEL_EXCEPTION);

264: l_sqlerrno := to_char(SQLCODE);
265: l_sqlerrmsg := substr(SQLERRM, 1,2000);
266: l_error_msg := ' Exception in PROCESS_USER for resource_id:' || to_char(p_resource_id)
267: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
268: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_RESOURCE_EXTNS_EVENT_PKG.PROCESS_USER',FND_LOG.LEVEL_EXCEPTION);
269: RAISE;
270: END PROCESS_USER;
271:
272: --Bug 5236469 : CONCURRENT PROGRAM TO CAPTURE PROFILE UPDATES

Line 292: CSM_UTIL_PKG.LOG('Entering RESOURCE_EXTNS_ACC_CLEANUP',

288: l_error_msg VARCHAR2(4000);
289: l_return_status VARCHAR2(2000);
290: l_scope NUMBER;
291: BEGIN
292: CSM_UTIL_PKG.LOG('Entering RESOURCE_EXTNS_ACC_CLEANUP',
293: 'CSM_RESOURCE_EXTNS_EVENT_PKG.RESOURCE_EXTNS_ACC_CLEANUP',FND_LOG.LEVEL_PROCEDURE);
294:
295: FOR r_users IN C_PALM_USERS
296: LOOP

Line 304: CSM_UTIL_PKG.LOG('Leaving PROCESS_NOTIFICATION_SCOPE',

300:
301: p_status := 'FINE';
302: p_message := 'CSM_RESOURCE_EXTNS_EVENT_PKG.PROCESS_NOTIFICATION_SCOPE executed successfully';
303:
304: CSM_UTIL_PKG.LOG('Leaving PROCESS_NOTIFICATION_SCOPE',
305: 'CSM_RESOURCE_EXTNS_EVENT_PKG.PROCESS_NOTIFICATION_SCOPE',FND_LOG.LEVEL_PROCEDURE);
306: EXCEPTION
307: WHEN OTHERS THEN
308: l_sqlerrno := to_char(SQLCODE);

Line 314: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_RESOURCE_EXTNS_EVENT_PKG.PROCESS_NOTIFICATION_SCOPE',FND_LOG.LEVEL_EXCEPTION);

310: l_error_msg := ' Exception in PROCESS_NOTIFICATION_SCOPE :' || l_sqlerrno || ':' || l_sqlerrmsg;
311: p_status := 'ERROR';
312: p_message := 'Error in CSM_RESOURCE_EXTNS_EVENT_PKG.PROCESS_NOTIFICATION_SCOPE: ' || l_sqlerrno || ':' || l_sqlerrmsg;
313: ROLLBACK;
314: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_RESOURCE_EXTNS_EVENT_PKG.PROCESS_NOTIFICATION_SCOPE',FND_LOG.LEVEL_EXCEPTION);
315: END PROCESS_NOTIFICATION_SCOPE;
316:
317: /* RESOURCE_EXTNS_ACC_PROCESSOR
318: * ----------------------------

Line 362: CSM_UTIL_PKG.LOG('Entering RESOURCE_EXTNS_ACC_PROCESSOR for resource_id: ' || p_resource_id,

358: l_error_msg VARCHAR2(4000);
359: l_return_status VARCHAR2(2000);
360:
361: BEGIN
362: CSM_UTIL_PKG.LOG('Entering RESOURCE_EXTNS_ACC_PROCESSOR for resource_id: ' || p_resource_id,
363: 'CSM_RESOURCE_EXTNS_EVENT_PKG.RESOURCE_EXTNS_ACC_PROCESSOR',FND_LOG.LEVEL_PROCEDURE);
364:
365: IF csm_util_pkg.is_palm_resource(p_resource_id) THEN
366: -- when the parameter RESOURCE_ID is a mobile user..also for him enabled='N' at the time of creation

Line 365: IF csm_util_pkg.is_palm_resource(p_resource_id) THEN

361: BEGIN
362: CSM_UTIL_PKG.LOG('Entering RESOURCE_EXTNS_ACC_PROCESSOR for resource_id: ' || p_resource_id,
363: 'CSM_RESOURCE_EXTNS_EVENT_PKG.RESOURCE_EXTNS_ACC_PROCESSOR',FND_LOG.LEVEL_PROCEDURE);
364:
365: IF csm_util_pkg.is_palm_resource(p_resource_id) THEN
366: -- when the parameter RESOURCE_ID is a mobile user..also for him enabled='N' at the time of creation
367: ---the above api takes care of this.
368: --Insert his record to himself
369: RESOURCE_EXTNS_ACC_I(p_resource_id,p_user_id);

Line 393: CSM_UTIL_PKG.LOG('Leaving RESOURCE_EXTNS_ACC_PROCESSOR for resource_id: ' || p_resource_id,

389: END LOOP;
390:
391: END IF;
392:
393: CSM_UTIL_PKG.LOG('Leaving RESOURCE_EXTNS_ACC_PROCESSOR for resource_id: ' || p_resource_id,
394: 'CSM_RESOURCE_EXTNS_EVENT_PKG.RESOURCE_EXTNS_ACC_PROCESSOR',FND_LOG.LEVEL_PROCEDURE);
395: EXCEPTION
396: WHEN OTHERS THEN
397: l_sqlerrno := to_char(SQLCODE);

Line 401: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_RESOURCE_EXTNS_EVENT_PKG.RESOURCE_EXTNS_ACC_PROCESSOR',FND_LOG.LEVEL_EXCEPTION);

397: l_sqlerrno := to_char(SQLCODE);
398: l_sqlerrmsg := substr(SQLERRM, 1,2000);
399: l_error_msg := ' Exception in RESOURCE_EXTNS_ACC_PROCESSOR for resource_id:' || to_char(p_resource_id)
400: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
401: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_RESOURCE_EXTNS_EVENT_PKG.RESOURCE_EXTNS_ACC_PROCESSOR',FND_LOG.LEVEL_EXCEPTION);
402: RAISE;
403: END RESOURCE_EXTNS_ACC_PROCESSOR;
404:
405: --Bug 5236469

Line 446: CSM_UTIL_PKG.LOG('Entering RS_GROUP_MEMBERS_INS_INIT for resource_id: ' || to_char(p_resource_id) || ' and group_id: '

442: l_return_status VARCHAR2(2000);
443:
444: l_user_id fnd_user.user_id%TYPE := NULL;
445: BEGIN
446: CSM_UTIL_PKG.LOG('Entering RS_GROUP_MEMBERS_INS_INIT for resource_id: ' || to_char(p_resource_id) || ' and group_id: '
447: || TO_CHAR(p_group_id), 'CSM_RESOURCE_EXTNS_EVENT_PKG.RS_GROUP_MEMBERS_INS_INIT',FND_LOG.LEVEL_PROCEDURE);
448:
449: -- get user_id
450: OPEN l_resource_csr(p_resource_id);

Line 473: CSM_UTIL_PKG.LOG('Leaving RS_GROUP_MEMBERS_INS_INIT for resource_id: ' || to_char(p_resource_id) || ' and group_id: '

469: END IF;
470: END LOOP;
471:
472:
473: CSM_UTIL_PKG.LOG('Leaving RS_GROUP_MEMBERS_INS_INIT for resource_id: ' || to_char(p_resource_id) || ' and group_id: '
474: || TO_CHAR(p_group_id), 'CSM_RESOURCE_EXTNS_EVENT_PKG.RS_GROUP_MEMBERS_INS_INIT',FND_LOG.LEVEL_PROCEDURE);
475: EXCEPTION
476: WHEN OTHERS THEN
477: l_sqlerrno := to_char(SQLCODE);

Line 481: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_RESOURCE_EXTNS_EVENT_PKG.RS_GROUP_MEMBERS_INS_INIT',FND_LOG.LEVEL_EXCEPTION);

477: l_sqlerrno := to_char(SQLCODE);
478: l_sqlerrmsg := substr(SQLERRM, 1,2000);
479: l_error_msg := ' Exception in RS_GROUP_MEMBERS_INS_INIT for resource_id:' || to_char(p_resource_id) || ' and group_id: '
480: || TO_CHAR(p_group_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
481: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_RESOURCE_EXTNS_EVENT_PKG.RS_GROUP_MEMBERS_INS_INIT',FND_LOG.LEVEL_EXCEPTION);
482: RAISE;
483: END RS_GROUP_MEMBERS_INS_INIT;
484:
485: --Bug 5236469

Line 527: CSM_UTIL_PKG.LOG('Entering RS_GROUP_MEMBERS_DEL_INIT for resource_id: ' || to_char(p_resource_id) || ' and group_id: '

523:
524: l_user_id fnd_user.user_id%TYPE := NULL;
525:
526: BEGIN
527: CSM_UTIL_PKG.LOG('Entering RS_GROUP_MEMBERS_DEL_INIT for resource_id: ' || to_char(p_resource_id) || ' and group_id: '
528: || TO_CHAR(p_group_id), 'CSM_RESOURCE_EXTNS_EVENT_PKG.RS_GROUP_MEMBERS_DEL_INIT',FND_LOG.LEVEL_PROCEDURE);
529:
530: -- get the user_id
531: OPEN l_resource_csr(p_resource_id);

Line 552: CSM_UTIL_PKG.LOG('Leaving RS_GROUP_MEMBERS_DEL_INIT for resource_id: ' || to_char(p_resource_id) || ' and group_id: '

548: END IF;
549: END IF;
550: END LOOP;
551:
552: CSM_UTIL_PKG.LOG('Leaving RS_GROUP_MEMBERS_DEL_INIT for resource_id: ' || to_char(p_resource_id) || ' and group_id: '
553: || TO_CHAR(p_group_id), 'CSM_RESOURCE_EXTNS_EVENT_PKG.RS_GROUP_MEMBERS_DEL_INIT',FND_LOG.LEVEL_PROCEDURE);
554: EXCEPTION
555: WHEN OTHERS THEN
556: l_sqlerrno := to_char(SQLCODE);

Line 560: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_RESOURCE_EXTNS_EVENT_PKG.RS_GROUP_MEMBERS_DEL_INIT',FND_LOG.LEVEL_EXCEPTION);

556: l_sqlerrno := to_char(SQLCODE);
557: l_sqlerrmsg := substr(SQLERRM, 1,2000);
558: l_error_msg := ' Exception in RS_GROUP_MEMBERS_DEL_INIT for resource_id:' || to_char(p_resource_id) || ' and group_id: '
559: || TO_CHAR(p_group_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
560: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_RESOURCE_EXTNS_EVENT_PKG.RS_GROUP_MEMBERS_DEL_INIT',FND_LOG.LEVEL_EXCEPTION);
561: RAISE;
562: END RS_GROUP_MEMBERS_DEL_INIT;
563:
564: END CSM_RESOURCE_EXTNS_EVENT_PKG;