eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSD_DEM_TIME_DATA dependencies on MSD_DEM_COMMON_UTILITIES

Line 26: MSD_DEM_COMMON_UTILITIES.LOG_DEBUG('In Procedure: MSD_DEM_FIX_MANUFACTURING');

22: and calendar_code = nvl(p_cal_code, calendar_code);
23:
24: begin
25:
26: MSD_DEM_COMMON_UTILITIES.LOG_DEBUG('In Procedure: MSD_DEM_FIX_MANUFACTURING');
27:
28:
29: MSD_DEM_COMMON_UTILITIES.LOG_DEBUG('Start Time: '|| to_char(SYSTIMESTAMP,'DD-MM-YYYY HH24:MI:SS'));
30:

Line 29: MSD_DEM_COMMON_UTILITIES.LOG_DEBUG('Start Time: '|| to_char(SYSTIMESTAMP,'DD-MM-YYYY HH24:MI:SS'));

25:
26: MSD_DEM_COMMON_UTILITIES.LOG_DEBUG('In Procedure: MSD_DEM_FIX_MANUFACTURING');
27:
28:
29: MSD_DEM_COMMON_UTILITIES.LOG_DEBUG('Start Time: '|| to_char(SYSTIMESTAMP,'DD-MM-YYYY HH24:MI:SS'));
30:
31: for week in weeks loop
32:
33: -- insert missing days in this week

Line 64: MSD_DEM_COMMON_UTILITIES.LOG_DEBUG('End Time: '|| to_char(SYSTIMESTAMP,'DD-MM-YYYY HH24:MI:SS'));

60: and week_end_date = week.ed
61: );
62: end loop;
63:
64: MSD_DEM_COMMON_UTILITIES.LOG_DEBUG('End Time: '|| to_char(SYSTIMESTAMP,'DD-MM-YYYY HH24:MI:SS'));
65:
66: end msd_dem_fix_manufacturing;
67:
68:

Line 103: select msd_dem_common_utilities.dm_time_level

99: where sr_instance_id = p_instance_id
100: and calendar_code = p_calendar_code;
101:
102: cursor get_lowest_level is
103: select msd_dem_common_utilities.dm_time_level
104: from dual;
105:
106: v_num_of_days number :=0;
107:

Line 121: MSD_DEM_COMMON_UTILITIES.LOG_DEBUG('In Procedure: COLLECT_TIME_DATA');

117: x_sql VARCHAR2(500) := NULL;
118:
119: BEGIN
120:
121: MSD_DEM_COMMON_UTILITIES.LOG_DEBUG('In Procedure: COLLECT_TIME_DATA');
122:
123:
124: if p_auto_run_download <> 1 then
125:

Line 126: msd_dem_common_utilities.log_message('Calendars Download Not Selected');

122:
123:
124: if p_auto_run_download <> 1 then
125:
126: msd_dem_common_utilities.log_message('Calendars Download Not Selected');
127: msd_dem_common_utilities.log_debug('Calendars Download Not Selected');
128: retcode := 0;
129: return;
130:

Line 127: msd_dem_common_utilities.log_debug('Calendars Download Not Selected');

123:
124: if p_auto_run_download <> 1 then
125:
126: msd_dem_common_utilities.log_message('Calendars Download Not Selected');
127: msd_dem_common_utilities.log_debug('Calendars Download Not Selected');
128: retcode := 0;
129: return;
130:
131: end if;

Line 143: msd_dem_common_utilities.log_debug ('MSD Schema: ' || g_msd_schema_name);

139: /* Get the msd schema name */
140: x_sql := 'DECLARE x_retval BOOLEAN; x_dummy1 VARCHAR2(50); x_dummy2 VARCHAR2(50); BEGIN x_retval := fnd_installation.get_app_info' || ' ( ''MSD'', x_dummy1, x_dummy2, :x_out1); END;';
141: EXECUTE IMMEDIATE x_sql USING OUT g_msd_schema_name;
142:
143: msd_dem_common_utilities.log_debug ('MSD Schema: ' || g_msd_schema_name);
144:
145: l_stmt := 'truncate table '|| g_msd_schema_name||'.msd_dem_time';
146:
147: msd_dem_common_utilities.log_debug(l_stmt);

Line 147: msd_dem_common_utilities.log_debug(l_stmt);

143: msd_dem_common_utilities.log_debug ('MSD Schema: ' || g_msd_schema_name);
144:
145: l_stmt := 'truncate table '|| g_msd_schema_name||'.msd_dem_time';
146:
147: msd_dem_common_utilities.log_debug(l_stmt);
148: execute immediate l_stmt ;
149:
150: for l_cals in c_cals
151: loop

Line 157: msd_dem_common_utilities.log_message('Collecting Calendar: '|| l_cals.Calendar_code);

153: l_stmt := null;
154:
155:
156:
157: msd_dem_common_utilities.log_message('Collecting Calendar: '|| l_cals.Calendar_code);
158:
159: if(l_cals.calendar_type = 'Fiscal') then
160:
161: for l_fiscal_cal_data in c_fiscal_cal_data(l_cals.instance , /*substr(l_cals.calendar_code, instr(l_cals.calendar_code, ':')+1)*/ l_cals.calendar_code)

Line 284: MSD_DEM_COMMON_UTILITIES.LOG_DEBUG(L_STMT);

280: elsif (l_cals.calendar_type = 'Manufacturing') then
281:
282: msd_dem_query_utilities.get_query(retcode, l_stmt, 'CAL', null);
283:
284: MSD_DEM_COMMON_UTILITIES.LOG_DEBUG(L_STMT);
285:
286: MSD_DEM_COMMON_UTILITIES.LOG_DEBUG('Instance: '|| l_cals.instance);
287: MSD_DEM_COMMON_UTILITIES.LOG_DEBUG('Calendar Code: '|| l_cals.calendar_CODE);
288:

Line 286: MSD_DEM_COMMON_UTILITIES.LOG_DEBUG('Instance: '|| l_cals.instance);

282: msd_dem_query_utilities.get_query(retcode, l_stmt, 'CAL', null);
283:
284: MSD_DEM_COMMON_UTILITIES.LOG_DEBUG(L_STMT);
285:
286: MSD_DEM_COMMON_UTILITIES.LOG_DEBUG('Instance: '|| l_cals.instance);
287: MSD_DEM_COMMON_UTILITIES.LOG_DEBUG('Calendar Code: '|| l_cals.calendar_CODE);
288:
289: MSD_DEM_COMMON_UTILITIES.LOG_DEBUG('Start Time: '|| to_char(SYSTIMESTAMP,'DD-MM-YYYY HH24:MI:SS'));
290:

Line 287: MSD_DEM_COMMON_UTILITIES.LOG_DEBUG('Calendar Code: '|| l_cals.calendar_CODE);

283:
284: MSD_DEM_COMMON_UTILITIES.LOG_DEBUG(L_STMT);
285:
286: MSD_DEM_COMMON_UTILITIES.LOG_DEBUG('Instance: '|| l_cals.instance);
287: MSD_DEM_COMMON_UTILITIES.LOG_DEBUG('Calendar Code: '|| l_cals.calendar_CODE);
288:
289: MSD_DEM_COMMON_UTILITIES.LOG_DEBUG('Start Time: '|| to_char(SYSTIMESTAMP,'DD-MM-YYYY HH24:MI:SS'));
290:
291: execute immediate l_stmt using l_cals.instance, l_cals.calendar_CODE;

Line 289: MSD_DEM_COMMON_UTILITIES.LOG_DEBUG('Start Time: '|| to_char(SYSTIMESTAMP,'DD-MM-YYYY HH24:MI:SS'));

285:
286: MSD_DEM_COMMON_UTILITIES.LOG_DEBUG('Instance: '|| l_cals.instance);
287: MSD_DEM_COMMON_UTILITIES.LOG_DEBUG('Calendar Code: '|| l_cals.calendar_CODE);
288:
289: MSD_DEM_COMMON_UTILITIES.LOG_DEBUG('Start Time: '|| to_char(SYSTIMESTAMP,'DD-MM-YYYY HH24:MI:SS'));
290:
291: execute immediate l_stmt using l_cals.instance, l_cals.calendar_CODE;
292:
293: MSD_DEM_COMMON_UTILITIES.LOG_DEBUG('End Time: '|| to_char(SYSTIMESTAMP,'DD-MM-YYYY HH24:MI:SS'));

Line 293: MSD_DEM_COMMON_UTILITIES.LOG_DEBUG('End Time: '|| to_char(SYSTIMESTAMP,'DD-MM-YYYY HH24:MI:SS'));

289: MSD_DEM_COMMON_UTILITIES.LOG_DEBUG('Start Time: '|| to_char(SYSTIMESTAMP,'DD-MM-YYYY HH24:MI:SS'));
290:
291: execute immediate l_stmt using l_cals.instance, l_cals.calendar_CODE;
292:
293: MSD_DEM_COMMON_UTILITIES.LOG_DEBUG('End Time: '|| to_char(SYSTIMESTAMP,'DD-MM-YYYY HH24:MI:SS'));
294:
295:
296: if l_lowest_level = 'Day' then
297: msd_dem_fix_manufacturing(l_cals.calendar_CODE);

Line 308: msd_dem_common_utilities.log_debug(l_stmt);

304:
305: l_stmt := 'begin ' || fnd_profile.value('MSD_DEM_SCHEMA') || '.Integration_1_Load_Calendars' ||
306: '(''' || fnd_profile.value('MSD_DEM_FISCAL_CALENDAR') || ''')' ||'; end;';
307:
308: msd_dem_common_utilities.log_debug(l_stmt);
309:
310: execute immediate 'alter session set current_schema=' || fnd_profile.value('MSD_DEM_SCHEMA');
311:
312: execute immediate l_stmt;

Line 324: MSD_DEM_COMMON_UTILITIES.LOG_MESSAGE( substr(SQLERRM,1,150));

320:
321: when others then
322: l_stmt := 'alter session set current_schema=APPS';
323: execute immediate l_stmt;
324: MSD_DEM_COMMON_UTILITIES.LOG_MESSAGE( substr(SQLERRM,1,150));
325: errbuf := substr(SQLERRM,1,150);
326: retcode := -1 ;
327:
328: end collect_time_data;