DBA Data[Home] [Help]

APPS.CSM_SERVICEP_WRAPPER_PKG dependencies on FND_GLOBAL

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 445: WHERE owner = g_olite_schema AND SYNONYM_NAME = 'FND_GLOBAL';

441: l_count NUMBER;
442: BEGIN
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 '

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 448: --EXECUTE IMMEDIATE 'create synonym mobileadmin.FND_GLOBAL for FND_GLOBAL';

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;
452: SELECT count(1) INTO l_count

Line 450: ||g_olite_schema||'.FND_GLOBAL for 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;
452: SELECT count(1) INTO l_count
453: FROM all_synonyms
454: WHERE owner = g_olite_schema AND SYNONYM_NAME = 'CSM_PROFILE_PKG';