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.6 2006/06/08 09:54:09 utekumal noship $ */
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 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 310: 'CSM_SERVICEP_WRAPPER_PKG.APPLY_DIRTY_PUBITEMS',FND_LOG.LEVEL_EXCEPTION );

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

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

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

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

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

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

Line 498: 'CSM_SERVICEP_WRAPPER_PKG.CONFLICT_RESOLUTION_METHOD',FND_LOG.LEVEL_PROCEDURE);

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

Line 513: END CSM_SERVICEP_WRAPPER_PKG;

509: END ;
510:
511:
512:
513: END CSM_SERVICEP_WRAPPER_PKG;