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;
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:
548: l_count NUMBER;
549: BEGIN
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 '
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;
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;
559: SELECT count(1) INTO l_count
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;
559: SELECT count(1) INTO l_count
560: FROM all_synonyms
561: WHERE owner = g_olite_schema AND SYNONYM_NAME = 'CSM_PROFILE_PKG';