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