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_CTO dependencies on MSD_DEM_QUERY_UTILITIES

Line 143: msd_dem_query_utilities.execute_query (

139: || 'Running populate staging tables for EQ_SALES_TMPL_ITEM_OPTIONS first.' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
140:
141: msd_dem_common_utilities.log_debug ('Start EQ_SALES_TMPL_ITEM_OPTIONS - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
142:
143: msd_dem_query_utilities.execute_query (
144: errbuf,
145: retcode,
146: 'EQ_SALES_TMPL_ITEM_OPTIONS',
147: p_sr_instance_id,

Line 155: || 'Error in call to msd_dem_query_utilities.execute_query');

151:
152: IF (retcode = -1)
153: THEN
154: msd_dem_common_utilities.log_message ('Error(4) in msd_dem_cto.populate_staging_table - '
155: || 'Error in call to msd_dem_query_utilities.execute_query');
156: msd_dem_common_utilities.log_message(errbuf);
157: RETURN;
158: ELSE
159: msd_dem_common_utilities.log_message ('Query EQ_SALES_TMPL_ITEM_OPTIONS executed successfully.');

Line 171: msd_dem_common_utilities.log_debug('Calling msd_dem_query_utilities.execute_query');

167: msd_dem_common_utilities.log_message ('In msd_dem_cto.populate_staging_table - '
168: || ' Pre-Process - End ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
169:
170:
171: msd_dem_common_utilities.log_debug('Calling msd_dem_query_utilities.execute_query');
172: msd_dem_query_utilities.execute_query (
173: errbuf,
174: retcode,
175: p_entity_name,

Line 172: msd_dem_query_utilities.execute_query (

168: || ' Pre-Process - End ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
169:
170:
171: msd_dem_common_utilities.log_debug('Calling msd_dem_query_utilities.execute_query');
172: msd_dem_query_utilities.execute_query (
173: errbuf,
174: retcode,
175: p_entity_name,
176: p_sr_instance_id,

Line 181: || 'Error in call to msd_dem_query_utilities.execute_query');

177: NULL );
178: IF (retcode = -1)
179: THEN
180: msd_dem_common_utilities.log_message ('Error(3) in msd_dem_cto.populate_staging_table - '
181: || 'Error in call to msd_dem_query_utilities.execute_query');
182: msd_dem_common_utilities.log_message(errbuf);
183: RETURN;
184: ELSE
185: msd_dem_common_utilities.log_message ('Query ' || p_entity_name || ' executed successfully.');

Line 205: msd_dem_query_utilities.execute_query (

201: COMMIT;
202:
203: msd_dem_common_utilities.log_message ('In msd_dem_cto.populate_staging_table - '
204: || 'Updating item code and site code in T_SRC_SALES_TMPL ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
205: msd_dem_query_utilities.execute_query (
206: errbuf,
207: retcode,
208: 'EQ_SALES_TMPL_ITEM',
209: p_sr_instance_id,

Line 287: msd_dem_common_utilities.log_debug('Calling msd_dem_query_utilities.execute_query');

283: msd_dem_common_utilities.log_message ('In msd_dem_cto.populate_staging_table - '
284: || ' Pre-Process - End ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
285:
286:
287: msd_dem_common_utilities.log_debug('Calling msd_dem_query_utilities.execute_query');
288: msd_dem_query_utilities.execute_query (
289: errbuf,
290: retcode,
291: p_entity_name,

Line 288: msd_dem_query_utilities.execute_query (

284: || ' Pre-Process - End ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
285:
286:
287: msd_dem_common_utilities.log_debug('Calling msd_dem_query_utilities.execute_query');
288: msd_dem_query_utilities.execute_query (
289: errbuf,
290: retcode,
291: p_entity_name,
292: p_sr_instance_id,

Line 297: || 'Error in call to msd_dem_query_utilities.execute_query');

293: NULL );
294: IF (retcode = -1)
295: THEN
296: msd_dem_common_utilities.log_message ('Error(5) in msd_dem_cto.populate_staging_table - '
297: || 'Error in call to msd_dem_query_utilities.execute_query');
298: msd_dem_common_utilities.log_message(errbuf);
299: RETURN;
300: ELSE
301: msd_dem_common_utilities.log_message ('Query ' || p_entity_name || ' executed successfully.');

Line 401: msd_dem_query_utilities.truncate_table (

397: SELECT USER INTO x_curr_user FROM DUAL;
398: msd_dem_common_utilities.log_message ('Current User - ' || x_curr_user);
399:
400: msd_dem_common_utilities.log_debug ('Truncate table MSD_DEM_MODEL_BOM_COMPONENTS');
401: msd_dem_query_utilities.truncate_table (
402: errbuf,
403: retcode,
404: 'MSD_DEM_MODEL_BOM_COMPONENTS',
405: 2,

Line 410: || 'Error in call to msd_dem_query_utilities.truncate_table');

406: 1);
407: IF (retcode = -1)
408: THEN
409: msd_dem_common_utilities.log_message ('Error(1) in msd_dem_cto.collect_model_bom_components - '
410: || 'Error in call to msd_dem_query_utilities.truncate_table');
411: msd_dem_common_utilities.log_message(errbuf);
412: RETURN;
413: END IF;
414:

Line 892: msd_dem_query_utilities.truncate_table (errbuf, retcode, 'MSD_DEM_CTO_BOM', 2);

888: /* CTO Performance Fix - Store the Model Bom Components Information in a table */
889:
890: /* Truncate the table MSD_DEM_CTO_BOM */
891: msd_dem_common_utilities.log_debug ('Truncate table MSD_DEM_CTO_BOM...' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
892: msd_dem_query_utilities.truncate_table (errbuf, retcode, 'MSD_DEM_CTO_BOM', 2);
893: IF (retcode = -1)
894: THEN
895:
896: retcode := -1;

Line 899: msd_dem_common_utilities.log_message ('Error in call to msd_dem_query_utilities.truncate_table for truncating MSD_DEM_CTO_BOM');

895:
896: retcode := -1;
897: errbuf := substr(SQLERRM,1,150);
898: msd_dem_common_utilities.log_message ('Error(3): msd_dem_cto.collect_model_bom_components - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
899: msd_dem_common_utilities.log_message ('Error in call to msd_dem_query_utilities.truncate_table for truncating MSD_DEM_CTO_BOM');
900: RETURN;
901:
902: END IF;
903:

Line 1008: msd_dem_common_utilities.log_debug ('Entering: msd_dem_query_utilities.purge_cto_gl_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

1004: x_sql VARCHAR2(500) := NULL;
1005:
1006: BEGIN
1007:
1008: msd_dem_common_utilities.log_debug ('Entering: msd_dem_query_utilities.purge_cto_gl_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
1009:
1010: /* Log the parameters */
1011: msd_dem_common_utilities.log_message ('Table to be deleted - T_EP_CTO');
1012: msd_dem_common_utilities.log_message ('Table to be deleted - T_EP_CTO_BASE_MODEL');