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

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 '

Line 554: -- csm_util_pkg.log(' synonym mobileadmin.FND_GLOBAL does not exist');

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;

Line 555: --EXECUTE IMMEDIATE 'create synonym mobileadmin.FND_GLOBAL for FND_GLOBAL';

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

Line 557: ||g_olite_schema||'.FND_GLOBAL for 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
560: FROM all_synonyms
561: WHERE owner = g_olite_schema AND SYNONYM_NAME = 'CSM_PROFILE_PKG';