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

Line 214: CSM_UTIL_PKG.LOG('Entering Profile refresh Acc' , 'CSM_PROFILE_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);

210: l_tab_prf_name char_tab_type;
211:
212: BEGIN
213:
214: CSM_UTIL_PKG.LOG('Entering Profile refresh Acc' , 'CSM_PROFILE_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);
215:
216: /*****DELETES*****************/
217:
218: CSM_UTIL_PKG.LOG('Processing Deletes' , 'CSM_PROFILE_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);

Line 218: CSM_UTIL_PKG.LOG('Processing Deletes' , 'CSM_PROFILE_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);

214: CSM_UTIL_PKG.LOG('Entering Profile refresh Acc' , 'CSM_PROFILE_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);
215:
216: /*****DELETES*****************/
217:
218: CSM_UTIL_PKG.LOG('Processing Deletes' , 'CSM_PROFILE_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);
219:
220: OPEN l_profiles_del_csr;
221: LOOP
222: l_tab_access_id.DELETE;

Line 228: 'CSM_PROFILE_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);

224: FETCH l_profiles_del_csr BULK COLLECT INTO l_tab_access_id,l_tab_user_id LIMIT 1000;
225: EXIT WHEN l_tab_access_id.COUNT = 0;
226:
227: CSM_UTIL_PKG.LOG('Bulk deleted ' || l_tab_access_id.count || ' records from csm_profile_option_values_acc' ,
228: 'CSM_PROFILE_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);
229:
230: l_markdirty := asg_download.mark_dirty(
231: P_PUB_ITEM => g_pub_item
232: , p_accessList => l_tab_access_id

Line 248: CSM_UTIL_PKG.LOG('Processing Updates' , 'CSM_PROFILE_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);

244:
245: COMMIT;
246: /*****************UPDATES*****************/
247:
248: CSM_UTIL_PKG.LOG('Processing Updates' , 'CSM_PROFILE_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);
249:
250: OPEN l_profiles_upd_csr;
251: LOOP
252: l_tab_access_id.DELETE;

Line 263: 'CSM_PROFILE_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);

259: FETCH l_profiles_upd_csr BULK COLLECT INTO l_tab_access_id,l_tab_user_id,l_tab_l_id,l_tab_l_val,l_tab_lva_id,l_tab_pf_val LIMIT 1000;
260: EXIT WHEN l_tab_access_id.COUNT = 0;
261:
262: CSM_UTIL_PKG.LOG('Bulk updated ' || l_tab_access_id.count || ' records in csm_profile_option_values_acc' ,
263: 'CSM_PROFILE_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);
264:
265: l_markdirty := asg_download.mark_dirty(
266: P_PUB_ITEM => g_pub_item
267: , p_accessList => l_tab_access_id

Line 289: CSM_UTIL_PKG.LOG('Processing Inserts' , 'CSM_PROFILE_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);

285:
286: COMMIT;
287: /********************* INSERTS *****************************/
288:
289: CSM_UTIL_PKG.LOG('Processing Inserts' , 'CSM_PROFILE_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);
290:
291: OPEN l_profiles_ins_csr;
292: LOOP
293: l_tab_access_id.DELETE;

Line 308: 'CSM_PROFILE_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);

304: l_tab_l_id,l_tab_l_val,l_tab_lva_id,l_tab_pf_val,l_tab_prf_name LIMIT 1000;
305: EXIT WHEN l_tab_access_id.COUNT = 0;
306:
307: CSM_UTIL_PKG.LOG('Bulk inserted ' || l_tab_access_id.count || ' records into csm_profile_option_values_acc' ,
308: 'CSM_PROFILE_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);
309:
310:
311: FORALL i IN 1..l_tab_access_id.COUNT
312: INSERT INTO csm_profile_option_values_acc(access_id, user_id, application_id, profile_option_id,

Line 344: CSM_UTIL_PKG.LOG('Leaving Profile refresh Acc' , 'CSM_PROFILE_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);

340: p_message := 'CSM_PROFILE_EVENT_PKG.Refresh_Acc Executed successfully';
341:
342: COMMIT;
343:
344: CSM_UTIL_PKG.LOG('Leaving Profile refresh Acc' , 'CSM_PROFILE_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);
345: EXCEPTION
346: WHEN others THEN
347: l_sqlerrno := to_char(SQLCODE);
348: l_sqlerrmsg := substr(SQLERRM, 1,200);

Line 352: csm_util_pkg.log('CSM_PROFILE_EVENT_PKG ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg, 'CSM_PROFILE_EVENT_PKG.REFRESH_ACC', FND_LOG.LEVEL_EXCEPTION);

348: l_sqlerrmsg := substr(SQLERRM, 1,200);
349: ROLLBACK;
350: p_status := 'ERROR';
351: p_message := 'Error in CSM_PROFILE_EVENT_PKG.Refresh_Acc: ' || l_sqlerrno || ':' || l_sqlerrmsg;
352: csm_util_pkg.log('CSM_PROFILE_EVENT_PKG ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg, 'CSM_PROFILE_EVENT_PKG.REFRESH_ACC', FND_LOG.LEVEL_EXCEPTION);
353: fnd_file.put_line(fnd_file.log, 'CSM_PROFILE_EVENT_PKG ERROR : ' || l_sqlerrno || ':' || l_sqlerrmsg);
354: END Refresh_Acc;
355:
356:

Line 438: CSM_UTIL_PKG.LOG('Entering Profile Inserts Acc for new user: '||p_user_id , 'CSM_PROFILE_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);

434:
435:
436: BEGIN
437:
438: CSM_UTIL_PKG.LOG('Entering Profile Inserts Acc for new user: '||p_user_id , 'CSM_PROFILE_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);
439:
440: OPEN l_profiles_ins_csr;
441: LOOP
442: l_tab_access_id.DELETE;

Line 457: 'CSM_PROFILE_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);

453: l_tab_l_id,l_tab_l_val,l_tab_lva_id,l_tab_pf_val,l_tab_prf_name LIMIT 1000;
454: EXIT WHEN l_tab_access_id.COUNT = 0;
455:
456: CSM_UTIL_PKG.LOG('Bulk inserted ' || l_tab_access_id.count || ' records into csm_profile_option_values_acc' ,
457: 'CSM_PROFILE_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);
458:
459:
460: FORALL i IN 1..l_tab_access_id.COUNT
461: INSERT INTO csm_profile_option_values_acc(access_id, user_id, application_id, profile_option_id,

Line 478: CSM_UTIL_PKG.LOG('Leaving Profile Insert Acc for user'||p_user_id , 'CSM_PROFILE_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);

474: );
475:
476: END LOOP;
477: CLOSE l_profiles_ins_csr;
478: CSM_UTIL_PKG.LOG('Leaving Profile Insert Acc for user'||p_user_id , 'CSM_PROFILE_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);
479: EXCEPTION
480: WHEN OTHERS THEN
481: l_sqlerrno := to_char(SQLCODE);
482: l_sqlerrmsg := substr(SQLERRM, 1,2000);

Line 484: CSM_UTIL_PKG.LOG(l_sqlerrmsg, 'csm_profile_event_pkg.refresh_user_acc',FND_LOG.LEVEL_EXCEPTION);

480: WHEN OTHERS THEN
481: l_sqlerrno := to_char(SQLCODE);
482: l_sqlerrmsg := substr(SQLERRM, 1,2000);
483: l_sqlerrmsg := ' Exception in refresh_user_acc for user_id:'|| to_char(p_user_id) || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
484: CSM_UTIL_PKG.LOG(l_sqlerrmsg, 'csm_profile_event_pkg.refresh_user_acc',FND_LOG.LEVEL_EXCEPTION);
485: RAISE;
486: END refresh_user_acc;
487:
488: /* SAJESH : Check if required later