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_SERVICEP_WRAPPER_PKG

Line 1: PACKAGE BODY CSM_SERVICEP_WRAPPER_PKG AS

1: PACKAGE BODY CSM_SERVICEP_WRAPPER_PKG AS
2: /* $Header: csmuspwb.pls 120.15.12020000.2 2013/04/09 11:05:54 saradhak ship $ */
3:
4: -- MODIFICATION HISTORY
5: -- Anurag 06/09/02 Created

Line 11: g_object_name CONSTANT VARCHAR2(30) := 'CSM_SERVICEP_WRAPPER_PKG';

7: -- Enter procedure, function bodies as shown below
8:
9: /*** Globals ***/
10: g_debug_level NUMBER; -- debug level
11: g_object_name CONSTANT VARCHAR2(30) := 'CSM_SERVICEP_WRAPPER_PKG';
12: --bug4233613
13: g_olite_schema CONSTANT VARCHAR2(15) := 'MOBILEADMIN';
14:
15:

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 106: 'CSM_SERVICEP_WRAPPER_PKG.ITEM_EXISTS',FND_LOG.LEVEL_EXCEPTION);

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

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 417: 'CSM_SERVICEP_WRAPPER_PKG.APPLY_DIRTY_PUBITEMS',FND_LOG.LEVEL_EXCEPTION );

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:
421: /***

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 491: || ' for User: ' || p_user_name ,'CSM_SERVICEP_WRAPPER_PKG.APPLY_CLIENT_CHANGES',FND_LOG.LEVEL_EXCEPTION);

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

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 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 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 590: 'CSM_SERVICEP_WRAPPER_PKG.DETECT_CONFLICT',FND_LOG.LEVEL_PROCEDURE);

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
594: WHEN OTHERS THEN

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 605: 'CSM_SERVICEP_WRAPPER_PKG.CONFLICT_RESOLUTION_METHOD',FND_LOG.LEVEL_PROCEDURE);

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
609: RETURN 'S' ;

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:

Line 654: END CSM_SERVICEP_WRAPPER_PKG;

650:
651: END APPLY_HTML5_CHANGES;
652:
653:
654: END CSM_SERVICEP_WRAPPER_PKG;