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 340: CSM_UTIL_PKG.log('Entered CSM_AUTO_SYNC_NFN .Will apply_client_changes' );

336:
337: IF ITEM_EXISTS( p_pubitems_tbl, 'CSM_AUTO_SYNC_NFN') THEN
338:
339:
340: CSM_UTIL_PKG.log('Entered CSM_AUTO_SYNC_NFN .Will apply_client_changes' );
341: CSM_AUTO_SYNC_NFN_PKG.APPLY_CLIENT_CHANGES
342: (
343: p_user_name,
344: p_tranid,

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

412: --TODO: call other wrappers for other updatable PIs
413:
414:
415: EXCEPTION WHEN OTHERS THEN
416: CSM_UTIL_PKG.log('Exception occurred in CSM_SERVICEP_WRAPPER_PKG.APPLY_DIRTY_PUBITEMS:' || fnd_global.local_chr(10) || SQLERRM,
417: 'CSM_SERVICEP_WRAPPER_PKG.APPLY_DIRTY_PUBITEMS',FND_LOG.LEVEL_EXCEPTION );
418:
419: END APPLY_DIRTY_PUBITEMS;
420:

Line 446: 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);

442: l_return_status);
443:
444: FOR i IN 1..l_pubitems_tbl.count LOOP
445:
446: 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);
447: -- logm('Dirty Pub items for tranid: ' || p_tranid || ' : ' || l_pubitems_tbl(i));
448: END LOOP;
449:
450: /*** successfully retrieved item names? ***/

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

486: */
487:
488: EXCEPTION WHEN OTHERS THEN
489: /*** catch and log exceptions ***/
490: CSM_UTIL_PKG.log('Exception occurred in CSM_SERVICEP_WRAPPER_PKG.Apply_Client_Changes: ' || sqlerrm
491: || ' for User: ' || p_user_name ,'CSM_SERVICEP_WRAPPER_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);
492:
493:
494: END APPLY_CLIENT_CHANGES;

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

514:
515: l_resp_rec l_resp_csr%ROWTYPE;
516:
517: BEGIN
518: csm_util_pkg.log('insert called','CSM_SERVICEP_WRAPPER_PKG.POPULATE_ACCESS_RECORDS',FND_LOG.LEVEL_PROCEDURE);
519:
520: csm_util_pkg.pvt_log('insert called' || 'CSM_SERVICEP_WRAPPER_PKG.POPULATE_ACCESS_RECORDS');
521: FOR l_resp_rec IN l_resp_csr(p_userid) LOOP
522: csm_util_pkg.pvt_log('POPULATE_ACCESS_RECORDS: USER_ID = ' || p_userid || ' RESP_ID = ' || l_resp_rec.RESPONSIBILITY_ID);

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

516:
517: BEGIN
518: csm_util_pkg.log('insert called','CSM_SERVICEP_WRAPPER_PKG.POPULATE_ACCESS_RECORDS',FND_LOG.LEVEL_PROCEDURE);
519:
520: csm_util_pkg.pvt_log('insert called' || 'CSM_SERVICEP_WRAPPER_PKG.POPULATE_ACCESS_RECORDS');
521: FOR l_resp_rec IN l_resp_csr(p_userid) LOOP
522: csm_util_pkg.pvt_log('POPULATE_ACCESS_RECORDS: USER_ID = ' || p_userid || ' RESP_ID = ' || l_resp_rec.RESPONSIBILITY_ID);
523: csm_util_pkg.log('POPULATE_ACCESS_RECORDS: USER_ID = ' || p_userid || ' RESP_ID = ' || l_resp_rec.RESPONSIBILITY_ID
524: ,FND_LOG.LEVEL_STATEMENT );

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

518: csm_util_pkg.log('insert called','CSM_SERVICEP_WRAPPER_PKG.POPULATE_ACCESS_RECORDS',FND_LOG.LEVEL_PROCEDURE);
519:
520: csm_util_pkg.pvt_log('insert called' || 'CSM_SERVICEP_WRAPPER_PKG.POPULATE_ACCESS_RECORDS');
521: FOR l_resp_rec IN l_resp_csr(p_userid) LOOP
522: csm_util_pkg.pvt_log('POPULATE_ACCESS_RECORDS: USER_ID = ' || p_userid || ' RESP_ID = ' || l_resp_rec.RESPONSIBILITY_ID);
523: csm_util_pkg.log('POPULATE_ACCESS_RECORDS: USER_ID = ' || p_userid || ' RESP_ID = ' || l_resp_rec.RESPONSIBILITY_ID
524: ,FND_LOG.LEVEL_STATEMENT );
525: CSM_WF_PKG.User_Resp_Post_Ins(p_user_id => p_userid,
526: p_responsibility_id => l_resp_rec.RESPONSIBILITY_ID );

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

519:
520: csm_util_pkg.pvt_log('insert called' || 'CSM_SERVICEP_WRAPPER_PKG.POPULATE_ACCESS_RECORDS');
521: FOR l_resp_rec IN l_resp_csr(p_userid) LOOP
522: csm_util_pkg.pvt_log('POPULATE_ACCESS_RECORDS: USER_ID = ' || p_userid || ' RESP_ID = ' || l_resp_rec.RESPONSIBILITY_ID);
523: csm_util_pkg.log('POPULATE_ACCESS_RECORDS: USER_ID = ' || p_userid || ' RESP_ID = ' || l_resp_rec.RESPONSIBILITY_ID
524: ,FND_LOG.LEVEL_STATEMENT );
525: CSM_WF_PKG.User_Resp_Post_Ins(p_user_id => p_userid,
526: p_responsibility_id => l_resp_rec.RESPONSIBILITY_ID );
527: END LOOP;

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

535: */
536: PROCEDURE DELETE_ACCESS_RECORDS ( p_userid in number)
537: IS
538: BEGIN
539: csm_util_pkg.log('delete called','CSM_SERVICEP_WRAPPER_PKG.DELETE_ACCESS_RECORDS',FND_LOG.LEVEL_PROCEDURE);
540: CSM_WF_PKG.User_Del(p_user_id => p_userid);
541: END DELETE_ACCESS_RECORDS; -- end DELETE_ACCESS_RECORDS
542:
543: /*

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

550: SELECT count(1) INTO l_count
551: FROM all_synonyms
552: WHERE owner = g_olite_schema AND SYNONYM_NAME = 'FND_GLOBAL';
553: IF l_count = 0 THEN
554: -- csm_util_pkg.log(' synonym mobileadmin.FND_GLOBAL does not exist');
555: --EXECUTE IMMEDIATE 'create synonym mobileadmin.FND_GLOBAL for FND_GLOBAL';
556: EXECUTE IMMEDIATE 'create synonym '
557: ||g_olite_schema||'.FND_GLOBAL for FND_GLOBAL';
558: END IF;

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

559: SELECT count(1) INTO l_count
560: FROM all_synonyms
561: WHERE owner = g_olite_schema AND SYNONYM_NAME = 'CSM_PROFILE_PKG';
562: IF l_count = 0 THEN
563: -- csm_util_pkg.log(' synonym mobileadmin.csm_profile_pkg does not exist');
564: --EXECUTE IMMEDIATE 'create synonym mobileadmin.csm_profile_pkg for csm_profile_pkg';
565:
566: EXECUTE IMMEDIATE 'create synonym '
567: ||g_olite_schema||'.csm_profile_pkg for csm_profile_pkg';

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

567: ||g_olite_schema||'.csm_profile_pkg for csm_profile_pkg';
568: END IF;
569: SELECT count(1) INTO l_count
570: FROM all_synonyms
571: WHERE owner = g_olite_schema AND SYNONYM_NAME = 'CSM_UTIL_PKG';
572: IF l_count = 0 THEN
573: -- csm_util_pkg.log(' synonym mobileadmin.csm_profile_pkg does not exist');
574: --EXECUTE IMMEDIATE 'create synonym mobileadmin.csm_util_pkg for csm_util_pkg';
575:

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

569: SELECT count(1) INTO l_count
570: FROM all_synonyms
571: WHERE owner = g_olite_schema AND SYNONYM_NAME = 'CSM_UTIL_PKG';
572: IF l_count = 0 THEN
573: -- csm_util_pkg.log(' synonym mobileadmin.csm_profile_pkg does not exist');
574: --EXECUTE IMMEDIATE 'create synonym mobileadmin.csm_util_pkg for csm_util_pkg';
575:
576: EXECUTE IMMEDIATE 'create synonym '
577: ||g_olite_schema||'.csm_util_pkg for csm_util_pkg';

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

570: FROM all_synonyms
571: WHERE owner = g_olite_schema AND SYNONYM_NAME = 'CSM_UTIL_PKG';
572: IF l_count = 0 THEN
573: -- csm_util_pkg.log(' synonym mobileadmin.csm_profile_pkg does not exist');
574: --EXECUTE IMMEDIATE 'create synonym mobileadmin.csm_util_pkg for csm_util_pkg';
575:
576: EXECUTE IMMEDIATE 'create synonym '
577: ||g_olite_schema||'.csm_util_pkg for csm_util_pkg';
578: END IF;

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

573: -- csm_util_pkg.log(' synonym mobileadmin.csm_profile_pkg does not exist');
574: --EXECUTE IMMEDIATE 'create synonym mobileadmin.csm_util_pkg for csm_util_pkg';
575:
576: EXECUTE IMMEDIATE 'create synonym '
577: ||g_olite_schema||'.csm_util_pkg for csm_util_pkg';
578: END IF;
579:
580: RETURN 'Y';
581:

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

585: END CHECK_OLITE_SCHEMA;
586:
587: FUNCTION detect_conflict(p_user_name IN VARCHAR2) RETURN VARCHAR2 IS
588: BEGIN
589: CSM_UTIL_PKG.LOG('Entering CSM_SERVICEP_WRAPPER_PKG.DETECT_CONFLICT for user ' || p_user_name ,
590: 'CSM_SERVICEP_WRAPPER_PKG.DETECT_CONFLICT',FND_LOG.LEVEL_PROCEDURE);
591:
592: RETURN 'Y' ;
593: EXCEPTION

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

600: p_sequence IN NUMBER)
601: RETURN VARCHAR2 IS
602: l_profile_value VARCHAR2(30) ;
603: BEGIN
604: CSM_UTIL_PKG.LOG('Entering CSM_SERVICEP_WRAPPER_PKG.CONFLICT_RESOLUTION_METHOD for user ' || p_user_name ,
605: 'CSM_SERVICEP_WRAPPER_PKG.CONFLICT_RESOLUTION_METHOD',FND_LOG.LEVEL_PROCEDURE);
606: l_profile_value := fnd_profile.value(csm_profile_pkg.g_JTM_APPL_CONFLICT_RULE);
607:
608: if l_profile_value = 'SERVER_WINS' then

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

626: /*** get_all_dirty and get_all_defered_pub_items is replaced by get_all_pub_items ***/
627: csm_html5_pkg.get_all_pub_items(p_user_name,p_tranid,l_pubitems_tbl,l_return_status);
628:
629: FOR i IN 1..l_pubitems_tbl.count LOOP
630: csm_util_pkg.log('Dirty Pub items for tranid: ' || p_tranid || ' : ' || l_pubitems_tbl(i),'CSM_SERVICEP_WRAPPER_PKG.APPLY_HTML5_CHANGES',FND_LOG.LEVEL_PROCEDURE);
631: END LOOP;
632:
633: /*** successfully retrieved item names? ***/
634: IF l_pubitems_tbl.COUNT > 0 THEN

Line 644: CSM_UTIL_PKG.log('No data found for User: ' || p_user_name || ' in txn-id:'|| p_tranid,'CSM_SERVICEP_WRAPPER_PKG.APPLY_HTML5_CHANGES',FND_LOG.LEVEL_EXCEPTION);

640: , l_pubitems_tbl
641: , l_return_status
642: );
643: ELSE
644: CSM_UTIL_PKG.log('No data found for User: ' || p_user_name || ' in txn-id:'|| p_tranid,'CSM_SERVICEP_WRAPPER_PKG.APPLY_HTML5_CHANGES',FND_LOG.LEVEL_EXCEPTION);
645: END IF;
646:
647: EXCEPTION WHEN OTHERS THEN
648: /*** catch and log exceptions ***/

Line 649: CSM_UTIL_PKG.log('Exception occurred in CSM_SERVICEP_WRAPPER_PKG.APPLY_HTML5_CHANGES: ' || sqlerrm || ' for User: ' || p_user_name ,'CSM_SERVICEP_WRAPPER_PKG.APPLY_HTML5_CHANGES',FND_LOG.LEVEL_EXCEPTION);

645: END IF;
646:
647: EXCEPTION WHEN OTHERS THEN
648: /*** catch and log exceptions ***/
649: CSM_UTIL_PKG.log('Exception occurred in CSM_SERVICEP_WRAPPER_PKG.APPLY_HTML5_CHANGES: ' || sqlerrm || ' for User: ' || p_user_name ,'CSM_SERVICEP_WRAPPER_PKG.APPLY_HTML5_CHANGES',FND_LOG.LEVEL_EXCEPTION);
650:
651: END APPLY_HTML5_CHANGES;
652:
653: