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

Line 105: CSM_UTIL_PKG.log( 'Exception occurred in CSM_SERVICEP_WRAPPER_PKG.ITEM_EXISTS:' || fnd_global.local_chr(10) || SQLERRM,

101: /*** item name not found ***/
102:
103: RETURN FALSE;
104: EXCEPTION WHEN OTHERS THEN
105: CSM_UTIL_PKG.log( 'Exception occurred in CSM_SERVICEP_WRAPPER_PKG.ITEM_EXISTS:' || fnd_global.local_chr(10) || SQLERRM,
106: 'CSM_SERVICEP_WRAPPER_PKG.ITEM_EXISTS',FND_LOG.LEVEL_EXCEPTION);
107:
108: RETURN FALSE;
109: END ITEM_EXISTS;

Line 309: CSM_UTIL_PKG.log('Exception occurred in CSM_SERVICEP_WRAPPER_PKG.APPLY_DIRTY_PUBITEMS:' || fnd_global.local_chr(10) || SQLERRM,

305: --TODO: call other wrappers for other updatable PIs
306:
307:
308: EXCEPTION WHEN OTHERS THEN
309: CSM_UTIL_PKG.log('Exception occurred in CSM_SERVICEP_WRAPPER_PKG.APPLY_DIRTY_PUBITEMS:' || fnd_global.local_chr(10) || SQLERRM,
310: 'CSM_SERVICEP_WRAPPER_PKG.APPLY_DIRTY_PUBITEMS',FND_LOG.LEVEL_EXCEPTION );
311:
312: END APPLY_DIRTY_PUBITEMS;
313:

Line 339: csm_util_pkg.log('Dirty Pub items for tranid: ' || p_tranid || ' : ' || l_pubitems_tbl(i),'CSM_SERVICEP_WRAPPER_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);

335: l_return_status);
336:
337: FOR i IN 1..l_pubitems_tbl.count LOOP
338:
339: csm_util_pkg.log('Dirty Pub items for tranid: ' || p_tranid || ' : ' || l_pubitems_tbl(i),'CSM_SERVICEP_WRAPPER_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_PROCEDURE);
340: -- logm('Dirty Pub items for tranid: ' || p_tranid || ' : ' || l_pubitems_tbl(i));
341: END LOOP;
342:
343: /*** successfully retrieved item names? ***/

Line 383: CSM_UTIL_PKG.log('Exception occurred in CSM_SERVICEP_WRAPPER_PKG.Apply_Client_Changes: ' || sqlerrm

379: */
380:
381: EXCEPTION WHEN OTHERS THEN
382: /*** catch and log exceptions ***/
383: CSM_UTIL_PKG.log('Exception occurred in CSM_SERVICEP_WRAPPER_PKG.Apply_Client_Changes: ' || sqlerrm
384: || ' for User: ' || p_user_name ,'CSM_SERVICEP_WRAPPER_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);
385:
386:
387: END APPLY_CLIENT_CHANGES;

Line 411: csm_util_pkg.log('insert called','CSM_SERVICEP_WRAPPER_PKG.POPULATE_ACCESS_RECORDS',FND_LOG.LEVEL_PROCEDURE);

407:
408: l_resp_rec l_resp_csr%ROWTYPE;
409:
410: BEGIN
411: csm_util_pkg.log('insert called','CSM_SERVICEP_WRAPPER_PKG.POPULATE_ACCESS_RECORDS',FND_LOG.LEVEL_PROCEDURE);
412:
413: csm_util_pkg.pvt_log('insert called' || 'CSM_SERVICEP_WRAPPER_PKG.POPULATE_ACCESS_RECORDS');
414: FOR l_resp_rec IN l_resp_csr(p_userid) LOOP
415: csm_util_pkg.pvt_log('POPULATE_ACCESS_RECORDS: USER_ID = ' || p_userid || ' RESP_ID = ' || l_resp_rec.RESPONSIBILITY_ID);

Line 413: csm_util_pkg.pvt_log('insert called' || 'CSM_SERVICEP_WRAPPER_PKG.POPULATE_ACCESS_RECORDS');

409:
410: BEGIN
411: csm_util_pkg.log('insert called','CSM_SERVICEP_WRAPPER_PKG.POPULATE_ACCESS_RECORDS',FND_LOG.LEVEL_PROCEDURE);
412:
413: csm_util_pkg.pvt_log('insert called' || 'CSM_SERVICEP_WRAPPER_PKG.POPULATE_ACCESS_RECORDS');
414: FOR l_resp_rec IN l_resp_csr(p_userid) LOOP
415: csm_util_pkg.pvt_log('POPULATE_ACCESS_RECORDS: USER_ID = ' || p_userid || ' RESP_ID = ' || l_resp_rec.RESPONSIBILITY_ID);
416: csm_util_pkg.log('POPULATE_ACCESS_RECORDS: USER_ID = ' || p_userid || ' RESP_ID = ' || l_resp_rec.RESPONSIBILITY_ID
417: ,FND_LOG.LEVEL_STATEMENT );

Line 415: csm_util_pkg.pvt_log('POPULATE_ACCESS_RECORDS: USER_ID = ' || p_userid || ' RESP_ID = ' || l_resp_rec.RESPONSIBILITY_ID);

411: csm_util_pkg.log('insert called','CSM_SERVICEP_WRAPPER_PKG.POPULATE_ACCESS_RECORDS',FND_LOG.LEVEL_PROCEDURE);
412:
413: csm_util_pkg.pvt_log('insert called' || 'CSM_SERVICEP_WRAPPER_PKG.POPULATE_ACCESS_RECORDS');
414: FOR l_resp_rec IN l_resp_csr(p_userid) LOOP
415: csm_util_pkg.pvt_log('POPULATE_ACCESS_RECORDS: USER_ID = ' || p_userid || ' RESP_ID = ' || l_resp_rec.RESPONSIBILITY_ID);
416: csm_util_pkg.log('POPULATE_ACCESS_RECORDS: USER_ID = ' || p_userid || ' RESP_ID = ' || l_resp_rec.RESPONSIBILITY_ID
417: ,FND_LOG.LEVEL_STATEMENT );
418: CSM_WF_PKG.User_Resp_Post_Ins(p_user_id => p_userid,
419: p_responsibility_id => l_resp_rec.RESPONSIBILITY_ID );

Line 416: csm_util_pkg.log('POPULATE_ACCESS_RECORDS: USER_ID = ' || p_userid || ' RESP_ID = ' || l_resp_rec.RESPONSIBILITY_ID

412:
413: csm_util_pkg.pvt_log('insert called' || 'CSM_SERVICEP_WRAPPER_PKG.POPULATE_ACCESS_RECORDS');
414: FOR l_resp_rec IN l_resp_csr(p_userid) LOOP
415: csm_util_pkg.pvt_log('POPULATE_ACCESS_RECORDS: USER_ID = ' || p_userid || ' RESP_ID = ' || l_resp_rec.RESPONSIBILITY_ID);
416: csm_util_pkg.log('POPULATE_ACCESS_RECORDS: USER_ID = ' || p_userid || ' RESP_ID = ' || l_resp_rec.RESPONSIBILITY_ID
417: ,FND_LOG.LEVEL_STATEMENT );
418: CSM_WF_PKG.User_Resp_Post_Ins(p_user_id => p_userid,
419: p_responsibility_id => l_resp_rec.RESPONSIBILITY_ID );
420: END LOOP;

Line 432: csm_util_pkg.log('delete called','CSM_SERVICEP_WRAPPER_PKG.DELETE_ACCESS_RECORDS',FND_LOG.LEVEL_PROCEDURE);

428: */
429: PROCEDURE DELETE_ACCESS_RECORDS ( p_userid in number)
430: IS
431: BEGIN
432: csm_util_pkg.log('delete called','CSM_SERVICEP_WRAPPER_PKG.DELETE_ACCESS_RECORDS',FND_LOG.LEVEL_PROCEDURE);
433: CSM_WF_PKG.User_Del(p_user_id => p_userid);
434: END DELETE_ACCESS_RECORDS; -- end DELETE_ACCESS_RECORDS
435:
436: /*

Line 447: -- csm_util_pkg.log(' synonym mobileadmin.FND_GLOBAL does not exist');

443: SELECT count(1) INTO l_count
444: FROM all_synonyms
445: WHERE owner = g_olite_schema AND SYNONYM_NAME = 'FND_GLOBAL';
446: IF l_count = 0 THEN
447: -- csm_util_pkg.log(' synonym mobileadmin.FND_GLOBAL does not exist');
448: --EXECUTE IMMEDIATE 'create synonym mobileadmin.FND_GLOBAL for FND_GLOBAL';
449: EXECUTE IMMEDIATE 'create synonym '
450: ||g_olite_schema||'.FND_GLOBAL for FND_GLOBAL';
451: END IF;

Line 456: -- csm_util_pkg.log(' synonym mobileadmin.csm_profile_pkg does not exist');

452: SELECT count(1) INTO l_count
453: FROM all_synonyms
454: WHERE owner = g_olite_schema AND SYNONYM_NAME = 'CSM_PROFILE_PKG';
455: IF l_count = 0 THEN
456: -- csm_util_pkg.log(' synonym mobileadmin.csm_profile_pkg does not exist');
457: --EXECUTE IMMEDIATE 'create synonym mobileadmin.csm_profile_pkg for csm_profile_pkg';
458:
459: EXECUTE IMMEDIATE 'create synonym '
460: ||g_olite_schema||'.csm_profile_pkg for csm_profile_pkg';

Line 464: WHERE owner = g_olite_schema AND SYNONYM_NAME = 'CSM_UTIL_PKG';

460: ||g_olite_schema||'.csm_profile_pkg for csm_profile_pkg';
461: END IF;
462: SELECT count(1) INTO l_count
463: FROM all_synonyms
464: WHERE owner = g_olite_schema AND SYNONYM_NAME = 'CSM_UTIL_PKG';
465: IF l_count = 0 THEN
466: -- csm_util_pkg.log(' synonym mobileadmin.csm_profile_pkg does not exist');
467: --EXECUTE IMMEDIATE 'create synonym mobileadmin.csm_util_pkg for csm_util_pkg';
468:

Line 466: -- csm_util_pkg.log(' synonym mobileadmin.csm_profile_pkg does not exist');

462: SELECT count(1) INTO l_count
463: FROM all_synonyms
464: WHERE owner = g_olite_schema AND SYNONYM_NAME = 'CSM_UTIL_PKG';
465: IF l_count = 0 THEN
466: -- csm_util_pkg.log(' synonym mobileadmin.csm_profile_pkg does not exist');
467: --EXECUTE IMMEDIATE 'create synonym mobileadmin.csm_util_pkg for csm_util_pkg';
468:
469: EXECUTE IMMEDIATE 'create synonym '
470: ||g_olite_schema||'.csm_util_pkg for csm_util_pkg';

Line 467: --EXECUTE IMMEDIATE 'create synonym mobileadmin.csm_util_pkg for csm_util_pkg';

463: FROM all_synonyms
464: WHERE owner = g_olite_schema AND SYNONYM_NAME = 'CSM_UTIL_PKG';
465: IF l_count = 0 THEN
466: -- csm_util_pkg.log(' synonym mobileadmin.csm_profile_pkg does not exist');
467: --EXECUTE IMMEDIATE 'create synonym mobileadmin.csm_util_pkg for csm_util_pkg';
468:
469: EXECUTE IMMEDIATE 'create synonym '
470: ||g_olite_schema||'.csm_util_pkg for csm_util_pkg';
471: END IF;

Line 470: ||g_olite_schema||'.csm_util_pkg for csm_util_pkg';

466: -- csm_util_pkg.log(' synonym mobileadmin.csm_profile_pkg does not exist');
467: --EXECUTE IMMEDIATE 'create synonym mobileadmin.csm_util_pkg for csm_util_pkg';
468:
469: EXECUTE IMMEDIATE 'create synonym '
470: ||g_olite_schema||'.csm_util_pkg for csm_util_pkg';
471: END IF;
472:
473: RETURN 'Y';
474:

Line 482: CSM_UTIL_PKG.LOG('Entering CSM_SERVICEP_WRAPPER_PKG.DETECT_CONFLICT for user ' || p_user_name ,

478: END CHECK_OLITE_SCHEMA;
479:
480: FUNCTION detect_conflict(p_user_name IN VARCHAR2) RETURN VARCHAR2 IS
481: BEGIN
482: CSM_UTIL_PKG.LOG('Entering CSM_SERVICEP_WRAPPER_PKG.DETECT_CONFLICT for user ' || p_user_name ,
483: 'CSM_SERVICEP_WRAPPER_PKG.DETECT_CONFLICT',FND_LOG.LEVEL_PROCEDURE);
484:
485: RETURN 'Y' ;
486: EXCEPTION

Line 497: CSM_UTIL_PKG.LOG('Entering CSM_SERVICEP_WRAPPER_PKG.CONFLICT_RESOLUTION_METHOD for user ' || p_user_name ,

493: p_sequence IN NUMBER)
494: RETURN VARCHAR2 IS
495: l_profile_value VARCHAR2(30) ;
496: BEGIN
497: CSM_UTIL_PKG.LOG('Entering CSM_SERVICEP_WRAPPER_PKG.CONFLICT_RESOLUTION_METHOD for user ' || p_user_name ,
498: 'CSM_SERVICEP_WRAPPER_PKG.CONFLICT_RESOLUTION_METHOD',FND_LOG.LEVEL_PROCEDURE);
499: l_profile_value := fnd_profile.value(csm_profile_pkg.g_JTM_APPL_CONFLICT_RULE);
500:
501: if l_profile_value = 'SERVER_WINS' then