DBA Data[Home] [Help]

APPS.MSC_E1APS_UTIL dependencies on MSC_E1APS_UTIL

Line 1: PACKAGE BODY MSC_E1APS_UTIL AS -- body

1: PACKAGE BODY MSC_E1APS_UTIL AS -- body
2: --# $Header: MSCE1ULB.pls 120.12.12020000.4 2013/03/21 07:20:59 sravinoo ship $
3: -- Global variables
4: ws_prf VARCHAR2(1000);
5: sql_cnd VARCHAR2(2000);

Line 357: msd_dem_common_utilities.log_debug ('Entering: MSC_E1APS_UTIL.DEM_WORKFLOW - '

353: -- Bug#7199587 syenamar
354: l_schema_name VARCHAR2(255);
355: l_schema_id NUMBER;
356: BEGIN
357: msd_dem_common_utilities.log_debug ('Entering: MSC_E1APS_UTIL.DEM_WORKFLOW - '
358: || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
359: DEM_SCHEMA := fnd_profile.value('MSD_DEM_SCHEMA');
360: IF fnd_profile.value('MSD_DEM_SCHEMA') IS NOT NULL THEN
361: l_user_id := p_user_id;

Line 416: msd_dem_common_utilities.log_debug ('Exiting: MSC_E1APS_UTIL.DEM_WORKFLOW - '

412: /* ELSE
413: msd_dem_common_utilities.log_message ('Auto Run Download - No ');
414: msd_dem_common_utilities.log_message ('Exiting without launching the download workflow.');
415: END IF; */
416: msd_dem_common_utilities.log_debug ('Exiting: MSC_E1APS_UTIL.DEM_WORKFLOW - '
417: || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
418: EXCEPTION
419: WHEN OTHERS THEN
420: errbuf := SUBSTR(SQLERRM,1,150);

Line 426: msd_dem_common_utilities.log_message ('Exception: MSC_E1APS_UTIL.DEM_WORKFLOW - '

422: -- l_stmt := 'begin ' || DEM_SCHEMA || '.DATA_LOAD.LOG_EP_LOAD_FAILURE; end;';
423: -- execute immediate l_stmt;
424: -- l_stmt := 'alter session set current_schema=APPS';
425: -- execute immediate l_stmt;
426: msd_dem_common_utilities.log_message ('Exception: MSC_E1APS_UTIL.DEM_WORKFLOW - '
427: || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
428: msd_dem_common_utilities.log_message (errbuf);
429: RETURN;
430: END DEM_WORKFLOW;

Line 1016: END MSC_E1APS_UTIL;

1012: END;
1013:
1014: RETURN finalreturnStr;
1015: END MSC_E1APS_ODIInitialize10g;
1016: END MSC_E1APS_UTIL;