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_COLLECT_RETURN_HISTORY dependencies on MSD_DEM_COMMON_UTILITIES

Line 73: msd_dem_common_utilities.log_debug ('Entering: msd_dem_collect_return_history.collect_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

69: l_custom_view_name VARCHAR2(100) := NULL;
70:
71: BEGIN
72:
73: msd_dem_common_utilities.log_debug ('Entering: msd_dem_collect_return_history.collect_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
74:
75:
76:
77: IF (p_series_id = MSD_DEM_COMMON_UTILITIES.C_SRP_RETURN_HISTORY) --jarora

Line 77: IF (p_series_id = MSD_DEM_COMMON_UTILITIES.C_SRP_RETURN_HISTORY) --jarora

73: msd_dem_common_utilities.log_debug ('Entering: msd_dem_collect_return_history.collect_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
74:
75:
76:
77: IF (p_series_id = MSD_DEM_COMMON_UTILITIES.C_SRP_RETURN_HISTORY) --jarora
78: THEN
79:
80: /* RMA types specified by the user */
81: open c_rma_type;

Line 85: ELSIF ( p_series_id = MSD_DEM_COMMON_UTILITIES.C_SRP_USG_HISTORY_DR)

81: open c_rma_type;
82: fetch c_rma_type into x_rma_type;
83: close c_rma_type;
84:
85: ELSIF ( p_series_id = MSD_DEM_COMMON_UTILITIES.C_SRP_USG_HISTORY_DR)
86: THEN
87:
88: /* WIP Accounting classes specified by the user */
89: open c_accnt_class;

Line 107: msd_dem_common_utilities.log_message ('Error(1): msd_dem_collect_return_history.collect_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

103: IF (l_identifier IS NULL)
104: THEN
105: retcode := -1;
106: errbuf := 'Unable to get the query identifier.';
107: msd_dem_common_utilities.log_message ('Error(1): msd_dem_collect_return_history.collect_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
108: msd_dem_common_utilities.log_message (errbuf);
109: RETURN;
110: END IF;
111:

Line 108: msd_dem_common_utilities.log_message (errbuf);

104: THEN
105: retcode := -1;
106: errbuf := 'Unable to get the query identifier.';
107: msd_dem_common_utilities.log_message ('Error(1): msd_dem_collect_return_history.collect_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
108: msd_dem_common_utilities.log_message (errbuf);
109: RETURN;
110: END IF;
111:
112: /* Check if custom view for Discrete */

Line 126: msd_dem_common_utilities.log_debug ('Begin collect discrete history - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS')); --jarora

122: IF ( p_instance_type <> 2
123: OR p_apps_ver = 4)
124: THEN
125:
126: msd_dem_common_utilities.log_debug ('Begin collect discrete history - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS')); --jarora
127:
128: IF (p_series_id = MSD_DEM_COMMON_UTILITIES.C_SRP_RETURN_HISTORY) --jarora
129: THEN
130:

Line 128: IF (p_series_id = MSD_DEM_COMMON_UTILITIES.C_SRP_RETURN_HISTORY) --jarora

124: THEN
125:
126: msd_dem_common_utilities.log_debug ('Begin collect discrete history - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS')); --jarora
127:
128: IF (p_series_id = MSD_DEM_COMMON_UTILITIES.C_SRP_RETURN_HISTORY) --jarora
129: THEN
130:
131: If(X_RMA_TYPE <> '''''') then
132: x_add_where_clause := 'OTTL.NAME IN ('|| X_RMA_TYPE ||')';

Line 137: ELSIF (p_series_id = MSD_DEM_COMMON_UTILITIES.C_SRP_USG_HISTORY_DR)

133: else
134: x_add_where_clause := '1=1';
135: end if;
136:
137: ELSIF (p_series_id = MSD_DEM_COMMON_UTILITIES.C_SRP_USG_HISTORY_DR)
138: THEN
139:
140: If(X_ACCNT_CLASS <> '''''') then
141: x_add_where_clause := 'WAC.CLASS_CODE IN ('|| X_ACCNT_CLASS ||')';

Line 159: || '$C_MASTER_ORG#' || msd_dem_common_utilities.get_parameter_value (p_sr_instance_id, 'MSD_DEM_MASTER_ORG');

155: || '$C_DEST_DATE#' || 'MDBR.SDATE'
156: || '$C_SOURCE_DATE#' || ' nvl( ' || substr(l_msd_source_date_col, 0, instr(upper(l_msd_source_date_col), 'SDATE')-1) || ', to_date(''01/01/1000'', ''DD/MM/YYYY'')) ' || ' SDATE'
157: || '$C_ADD_WHERE_CLAUSE#' || x_add_where_clause
158: || '$C_SR_INSTANCE_ID#' || to_char(p_sr_instance_id)
159: || '$C_MASTER_ORG#' || msd_dem_common_utilities.get_parameter_value (p_sr_instance_id, 'MSD_DEM_MASTER_ORG');
160:
161: IF (p_collection_method <> 1) THEN
162: x_key_values := x_key_values || '$C_TIME_CLAUSE#' || ' WHERE SDATE BETWEEN '
163: || 'to_date(''' || to_char(p_from_date, 'DD/MM/RRRR') || ''', ''DD/MM/RRRR'') '

Line 173: IF (p_series_id IN (MSD_DEM_COMMON_UTILITIES.C_ON_HAND_INVENTORY,

169:
170: x_key_values := x_key_values || '$';
171:
172: /* Bug# 6491059 */
173: IF (p_series_id IN (MSD_DEM_COMMON_UTILITIES.C_ON_HAND_INVENTORY,
174: MSD_DEM_COMMON_UTILITIES.C_TOTAL_BACKLOG,
175: MSD_DEM_COMMON_UTILITIES.C_PAST_DUE_BACKLOG,
176: MSD_DEM_COMMON_UTILITIES.C_ACTUAL_PRODUCTION,
177: MSD_DEM_COMMON_UTILITIES.C_INSTALL_BASE_HISTORY))

Line 174: MSD_DEM_COMMON_UTILITIES.C_TOTAL_BACKLOG,

170: x_key_values := x_key_values || '$';
171:
172: /* Bug# 6491059 */
173: IF (p_series_id IN (MSD_DEM_COMMON_UTILITIES.C_ON_HAND_INVENTORY,
174: MSD_DEM_COMMON_UTILITIES.C_TOTAL_BACKLOG,
175: MSD_DEM_COMMON_UTILITIES.C_PAST_DUE_BACKLOG,
176: MSD_DEM_COMMON_UTILITIES.C_ACTUAL_PRODUCTION,
177: MSD_DEM_COMMON_UTILITIES.C_INSTALL_BASE_HISTORY))
178: THEN

Line 175: MSD_DEM_COMMON_UTILITIES.C_PAST_DUE_BACKLOG,

171:
172: /* Bug# 6491059 */
173: IF (p_series_id IN (MSD_DEM_COMMON_UTILITIES.C_ON_HAND_INVENTORY,
174: MSD_DEM_COMMON_UTILITIES.C_TOTAL_BACKLOG,
175: MSD_DEM_COMMON_UTILITIES.C_PAST_DUE_BACKLOG,
176: MSD_DEM_COMMON_UTILITIES.C_ACTUAL_PRODUCTION,
177: MSD_DEM_COMMON_UTILITIES.C_INSTALL_BASE_HISTORY))
178: THEN
179: x_key_values := replace (x_key_values, 'SDATE', 'PDATE');

Line 176: MSD_DEM_COMMON_UTILITIES.C_ACTUAL_PRODUCTION,

172: /* Bug# 6491059 */
173: IF (p_series_id IN (MSD_DEM_COMMON_UTILITIES.C_ON_HAND_INVENTORY,
174: MSD_DEM_COMMON_UTILITIES.C_TOTAL_BACKLOG,
175: MSD_DEM_COMMON_UTILITIES.C_PAST_DUE_BACKLOG,
176: MSD_DEM_COMMON_UTILITIES.C_ACTUAL_PRODUCTION,
177: MSD_DEM_COMMON_UTILITIES.C_INSTALL_BASE_HISTORY))
178: THEN
179: x_key_values := replace (x_key_values, 'SDATE', 'PDATE');
180: END IF;

Line 177: MSD_DEM_COMMON_UTILITIES.C_INSTALL_BASE_HISTORY))

173: IF (p_series_id IN (MSD_DEM_COMMON_UTILITIES.C_ON_HAND_INVENTORY,
174: MSD_DEM_COMMON_UTILITIES.C_TOTAL_BACKLOG,
175: MSD_DEM_COMMON_UTILITIES.C_PAST_DUE_BACKLOG,
176: MSD_DEM_COMMON_UTILITIES.C_ACTUAL_PRODUCTION,
177: MSD_DEM_COMMON_UTILITIES.C_INSTALL_BASE_HISTORY))
178: THEN
179: x_key_values := replace (x_key_values, 'SDATE', 'PDATE');
180: END IF;
181:

Line 190: || '$C_MASTER_ORG#' || msd_dem_common_utilities.get_parameter_value (p_sr_instance_id, 'MSD_DEM_MASTER_ORG');

186: || '$C_DEST_DATE#' || 'INP.DATET SDATE'
187: || '$C_SOURCE_DATE#' || SUBSTR(L_MSD_SOURCE_DATE_COL, 1, instr(L_MSD_SOURCE_DATE_COL, 'SDATE')-1)||' PDATE'
188: || '$C_ADD_WHERE_CLAUSE#' || x_add_where_clause
189: || '$C_SR_INSTANCE_ID#' || to_char(p_sr_instance_id)
190: || '$C_MASTER_ORG#' || msd_dem_common_utilities.get_parameter_value (p_sr_instance_id, 'MSD_DEM_MASTER_ORG');
191:
192: IF (p_collection_method <> 1) THEN
193: x_key_values := x_key_values || '$C_TIME_CLAUSE#' || ', msd_dem_dates inp WHERE mdbr.pdate BETWEEN '
194: || 'to_date(''' || to_char(p_from_date, 'DD/MM/RRRR') || ''', ''DD/MM/RRRR'') '

Line 205: IF (p_series_id IN (MSD_DEM_COMMON_UTILITIES.C_ON_HAND_INVENTORY,

201:
202: x_key_values := x_key_values || '$';
203:
204: /* Change for streams with LAST aggregation along time */
205: IF (p_series_id IN (MSD_DEM_COMMON_UTILITIES.C_ON_HAND_INVENTORY,
206: MSD_DEM_COMMON_UTILITIES.C_TOTAL_BACKLOG,
207: MSD_DEM_COMMON_UTILITIES.C_PAST_DUE_BACKLOG))
208: THEN
209: l_identifier := l_identifier || '_L';

Line 206: MSD_DEM_COMMON_UTILITIES.C_TOTAL_BACKLOG,

202: x_key_values := x_key_values || '$';
203:
204: /* Change for streams with LAST aggregation along time */
205: IF (p_series_id IN (MSD_DEM_COMMON_UTILITIES.C_ON_HAND_INVENTORY,
206: MSD_DEM_COMMON_UTILITIES.C_TOTAL_BACKLOG,
207: MSD_DEM_COMMON_UTILITIES.C_PAST_DUE_BACKLOG))
208: THEN
209: l_identifier := l_identifier || '_L';
210: END IF;

Line 207: MSD_DEM_COMMON_UTILITIES.C_PAST_DUE_BACKLOG))

203:
204: /* Change for streams with LAST aggregation along time */
205: IF (p_series_id IN (MSD_DEM_COMMON_UTILITIES.C_ON_HAND_INVENTORY,
206: MSD_DEM_COMMON_UTILITIES.C_TOTAL_BACKLOG,
207: MSD_DEM_COMMON_UTILITIES.C_PAST_DUE_BACKLOG))
208: THEN
209: l_identifier := l_identifier || '_L';
210: END IF;
211:

Line 229: msd_dem_common_utilities.log_message ('Error(2): msd_dem_collect_return_history.collect_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

225: OR x_large_sql IS NULL)
226: THEN
227: retcode := -1;
228: errbuf := 'Unable to get the query.';
229: msd_dem_common_utilities.log_message ('Error(2): msd_dem_collect_return_history.collect_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
230: msd_dem_common_utilities.log_message (errbuf);
231: RETURN;
232: END IF;
233:

Line 230: msd_dem_common_utilities.log_message (errbuf);

226: THEN
227: retcode := -1;
228: errbuf := 'Unable to get the query.';
229: msd_dem_common_utilities.log_message ('Error(2): msd_dem_collect_return_history.collect_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
230: msd_dem_common_utilities.log_message (errbuf);
231: RETURN;
232: END IF;
233:
234:

Line 235: msd_dem_common_utilities.log_debug ('Query - ');

231: RETURN;
232: END IF;
233:
234:
235: msd_dem_common_utilities.log_debug ('Query - ');
236: msd_dem_common_utilities.log_debug (x_large_sql);
237:
238: msd_dem_common_utilities.log_debug ('Query Start Time - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
239:

Line 236: msd_dem_common_utilities.log_debug (x_large_sql);

232: END IF;
233:
234:
235: msd_dem_common_utilities.log_debug ('Query - ');
236: msd_dem_common_utilities.log_debug (x_large_sql);
237:
238: msd_dem_common_utilities.log_debug ('Query Start Time - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
239:
240: BEGIN

Line 238: msd_dem_common_utilities.log_debug ('Query Start Time - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

234:
235: msd_dem_common_utilities.log_debug ('Query - ');
236: msd_dem_common_utilities.log_debug (x_large_sql);
237:
238: msd_dem_common_utilities.log_debug ('Query Start Time - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
239:
240: BEGIN
241: /* insert return history data into return history staging table */
242: EXECUTE IMMEDIATE x_large_sql;

Line 247: msd_dem_common_utilities.log_message ('Exception(1): msd_dem_collect_return_history.collect_data- ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

243: EXCEPTION
244: WHEN OTHERS THEN
245: retcode := -1 ;
246: errbuf := substr(SQLERRM,1,150);
247: msd_dem_common_utilities.log_message ('Exception(1): msd_dem_collect_return_history.collect_data- ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
248: msd_dem_common_utilities.log_message (errbuf);
249: msd_dem_common_utilities.log_debug ('Query End Time - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
250: RETURN;
251: END;

Line 248: msd_dem_common_utilities.log_message (errbuf);

244: WHEN OTHERS THEN
245: retcode := -1 ;
246: errbuf := substr(SQLERRM,1,150);
247: msd_dem_common_utilities.log_message ('Exception(1): msd_dem_collect_return_history.collect_data- ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
248: msd_dem_common_utilities.log_message (errbuf);
249: msd_dem_common_utilities.log_debug ('Query End Time - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
250: RETURN;
251: END;
252:

Line 249: msd_dem_common_utilities.log_debug ('Query End Time - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

245: retcode := -1 ;
246: errbuf := substr(SQLERRM,1,150);
247: msd_dem_common_utilities.log_message ('Exception(1): msd_dem_collect_return_history.collect_data- ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
248: msd_dem_common_utilities.log_message (errbuf);
249: msd_dem_common_utilities.log_debug ('Query End Time - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
250: RETURN;
251: END;
252:
253: msd_dem_common_utilities.log_debug ('Query End Time - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

Line 253: msd_dem_common_utilities.log_debug ('Query End Time - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

249: msd_dem_common_utilities.log_debug ('Query End Time - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
250: RETURN;
251: END;
252:
253: msd_dem_common_utilities.log_debug ('Query End Time - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
254:
255: COMMIT;
256:
257: IF (p_series_id = MSD_DEM_COMMON_UTILITIES.C_RETURN_HISTORY)

Line 257: IF (p_series_id = MSD_DEM_COMMON_UTILITIES.C_RETURN_HISTORY)

253: msd_dem_common_utilities.log_debug ('Query End Time - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
254:
255: COMMIT;
256:
257: IF (p_series_id = MSD_DEM_COMMON_UTILITIES.C_RETURN_HISTORY)
258: THEN
259:
260: msd_dem_common_utilities.log_debug ('Start Updating Site codes - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
261:

Line 260: msd_dem_common_utilities.log_debug ('Start Updating Site codes - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

256:
257: IF (p_series_id = MSD_DEM_COMMON_UTILITIES.C_RETURN_HISTORY)
258: THEN
259:
260: msd_dem_common_utilities.log_debug ('Start Updating Site codes - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
261:
262: MSD_DEM_UPDATE_LEVEL_CODES.update_code(x_errbuf ,
263: x_retcode,
264: p_SR_instance_id,

Line 270: msd_dem_common_utilities.log_debug ('End Updating Site codes - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

266: p_dest_table,
267: 'LEVEL4',
268: 'LEVEL4_SR_PK');
269:
270: msd_dem_common_utilities.log_debug ('End Updating Site codes - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
271:
272: END IF; --jarora
273:
274: msd_dem_common_utilities.log_debug ('End collect discrete history - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS')); --jarora

Line 274: msd_dem_common_utilities.log_debug ('End collect discrete history - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS')); --jarora

270: msd_dem_common_utilities.log_debug ('End Updating Site codes - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
271:
272: END IF; --jarora
273:
274: msd_dem_common_utilities.log_debug ('End collect discrete history - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS')); --jarora
275:
276: END IF;
277:
278: IF (p_series_id = MSD_DEM_COMMON_UTILITIES.C_RETURN_HISTORY)

Line 278: IF (p_series_id = MSD_DEM_COMMON_UTILITIES.C_RETURN_HISTORY)

274: msd_dem_common_utilities.log_debug ('End collect discrete history - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS')); --jarora
275:
276: END IF;
277:
278: IF (p_series_id = MSD_DEM_COMMON_UTILITIES.C_RETURN_HISTORY)
279: THEN
280: /* Delete the RMA types stored in the DB table */
281: delete from msd_dem_rma_type;
282: ELSIF (p_series_id = MSD_DEM_COMMON_UTILITIES.C_SRP_USG_HISTORY_DR)

Line 282: ELSIF (p_series_id = MSD_DEM_COMMON_UTILITIES.C_SRP_USG_HISTORY_DR)

278: IF (p_series_id = MSD_DEM_COMMON_UTILITIES.C_RETURN_HISTORY)
279: THEN
280: /* Delete the RMA types stored in the DB table */
281: delete from msd_dem_rma_type;
282: ELSIF (p_series_id = MSD_DEM_COMMON_UTILITIES.C_SRP_USG_HISTORY_DR)
283: THEN
284: /* Delete the WIP Accounting classes stored in the DB table */
285: delete from msd_dem_accnt_classes;
286: ELSE

Line 290: msd_dem_common_utilities.log_debug ('Exiting: msd_dem_collect_return_history.collect_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

286: ELSE
287: NULL;
288: END IF; --jarora
289:
290: msd_dem_common_utilities.log_debug ('Exiting: msd_dem_collect_return_history.collect_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
291:
292: EXCEPTION
293: WHEN OTHERS THEN
294: retcode := -1 ;

Line 296: msd_dem_common_utilities.log_message ('Exception(3): msd_dem_collect_return_history.collect_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

292: EXCEPTION
293: WHEN OTHERS THEN
294: retcode := -1 ;
295: errbuf := substr(SQLERRM,1,150);
296: msd_dem_common_utilities.log_message ('Exception(3): msd_dem_collect_return_history.collect_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
297: msd_dem_common_utilities.log_message (errbuf);
298: RETURN;
299:
300: END COLLECT_DATA;

Line 297: msd_dem_common_utilities.log_message (errbuf);

293: WHEN OTHERS THEN
294: retcode := -1 ;
295: errbuf := substr(SQLERRM,1,150);
296: msd_dem_common_utilities.log_message ('Exception(3): msd_dem_collect_return_history.collect_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
297: msd_dem_common_utilities.log_message (errbuf);
298: RETURN;
299:
300: END COLLECT_DATA;
301:

Line 377: msd_dem_common_utilities.log_debug ('Entering: msd_dem_collect_return_history.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

373: l_series_name VARCHAR2(100) := NULL; --sopjarora
374:
375: BEGIN
376:
377: msd_dem_common_utilities.log_debug ('Entering: msd_dem_collect_return_history.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
378:
379: /* Get the db link to the source instance */
380: msd_dem_common_utilities.get_dblink (
381: x_errbuf,

Line 380: msd_dem_common_utilities.get_dblink (

376:
377: msd_dem_common_utilities.log_debug ('Entering: msd_dem_collect_return_history.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
378:
379: /* Get the db link to the source instance */
380: msd_dem_common_utilities.get_dblink (
381: x_errbuf,
382: x_retcode,
383: p_sr_instance_id,
384: g_dblink);

Line 390: msd_dem_common_utilities.log_message ('Error(1): msd_dem_collect_return_history.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

386: IF (x_retcode = '-1')
387: THEN
388: retcode := -1;
389: errbuf := x_errbuf;
390: msd_dem_common_utilities.log_message ('Error(1): msd_dem_collect_return_history.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
391: RETURN;
392: END IF;
393:
394: /* Calling procedure to push the profile values, collection enabled orgs and

Line 405: msd_dem_common_utilities.log_debug ('Begin validation of inputs parameters - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

401:
402:
403: /* VALIDATION OF INPUT PARAMETERS - BEGIN */
404:
405: msd_dem_common_utilities.log_debug ('Begin validation of inputs parameters - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
406:
407:
408: /* Show Warning if collection method is Refresh and a date range filter is specified */
409: IF ( p_collection_method = 1

Line 416: msd_dem_common_utilities.log_message ('Warning(1): msd_dem_collect_return_history.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

412: OR p_collection_window IS NOT NULL))
413: THEN
414: x_retcode := 1;
415: x_errbuf := 'Date Range filters are ignored in ''Refresh'' collections';
416: msd_dem_common_utilities.log_message ('Warning(1): msd_dem_collect_return_history.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
417: msd_dem_common_utilities.log_message (x_errbuf);
418: END IF;
419:
420:

Line 417: msd_dem_common_utilities.log_message (x_errbuf);

413: THEN
414: x_retcode := 1;
415: x_errbuf := 'Date Range filters are ignored in ''Refresh'' collections';
416: msd_dem_common_utilities.log_message ('Warning(1): msd_dem_collect_return_history.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
417: msd_dem_common_utilities.log_message (x_errbuf);
418: END IF;
419:
420:
421: /* Show Warning if collection method is net change, date range type is Rolling and from date and to date are specified */

Line 429: msd_dem_common_utilities.log_message ('Warning(2): msd_dem_collect_return_history.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

425: OR p_to_date IS NOT NULL))
426: THEN
427: x_retcode := 1;
428: x_errbuf := 'The ''Date From'' and ''Date To'' fields are ignored if ''Rolling'' date range type is selected.';
429: msd_dem_common_utilities.log_message ('Warning(2): msd_dem_collect_return_history.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
430: msd_dem_common_utilities.log_message (x_errbuf);
431: END IF;
432:
433:

Line 430: msd_dem_common_utilities.log_message (x_errbuf);

426: THEN
427: x_retcode := 1;
428: x_errbuf := 'The ''Date From'' and ''Date To'' fields are ignored if ''Rolling'' date range type is selected.';
429: msd_dem_common_utilities.log_message ('Warning(2): msd_dem_collect_return_history.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
430: msd_dem_common_utilities.log_message (x_errbuf);
431: END IF;
432:
433:
434: /* Show Warning if collection method is net change, date range type is Absolute and history collection window is specified */

Line 441: msd_dem_common_utilities.log_message ('Warning(3): msd_dem_collect_return_history.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

437: AND p_collection_window IS NOT NULL)
438: THEN
439: x_retcode := 1;
440: x_errbuf := 'The ''History Collection Window'' field is ignored if ''Absolute'' date range type is selected.';
441: msd_dem_common_utilities.log_message ('Warning(3): msd_dem_collect_return_history.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
442: msd_dem_common_utilities.log_message (x_errbuf);
443: END IF;
444:
445:

Line 442: msd_dem_common_utilities.log_message (x_errbuf);

438: THEN
439: x_retcode := 1;
440: x_errbuf := 'The ''History Collection Window'' field is ignored if ''Absolute'' date range type is selected.';
441: msd_dem_common_utilities.log_message ('Warning(3): msd_dem_collect_return_history.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
442: msd_dem_common_utilities.log_message (x_errbuf);
443: END IF;
444:
445:
446: /* Error if collection method is net change, date range type is Rolling and history collection window is not specified */

Line 453: msd_dem_common_utilities.log_message ('Error(3): msd_dem_collect_return_history.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

449: AND p_collection_window IS NULL)
450: THEN
451: retcode := -1;
452: errbuf := 'The ''History Collection Window'' field cannot be NULL, if ''Rolling'' date range type is selected.';
453: msd_dem_common_utilities.log_message ('Error(3): msd_dem_collect_return_history.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
454: msd_dem_common_utilities.log_message (errbuf);
455: RETURN;
456: END IF;
457:

Line 454: msd_dem_common_utilities.log_message (errbuf);

450: THEN
451: retcode := -1;
452: errbuf := 'The ''History Collection Window'' field cannot be NULL, if ''Rolling'' date range type is selected.';
453: msd_dem_common_utilities.log_message ('Error(3): msd_dem_collect_return_history.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
454: msd_dem_common_utilities.log_message (errbuf);
455: RETURN;
456: END IF;
457:
458:

Line 467: msd_dem_common_utilities.log_message ('Error(4): msd_dem_collect_return_history.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

463: OR p_to_date IS NULL))
464: THEN
465: retcode := -1;
466: errbuf := 'The ''Date From'' and ''Date To'' fields cannot be NULL, if ''Absolute'' date range type is selected.';
467: msd_dem_common_utilities.log_message ('Error(4): msd_dem_collect_return_history.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
468: msd_dem_common_utilities.log_message (errbuf);
469: RETURN;
470: END IF;
471:

Line 468: msd_dem_common_utilities.log_message (errbuf);

464: THEN
465: retcode := -1;
466: errbuf := 'The ''Date From'' and ''Date To'' fields cannot be NULL, if ''Absolute'' date range type is selected.';
467: msd_dem_common_utilities.log_message ('Error(4): msd_dem_collect_return_history.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
468: msd_dem_common_utilities.log_message (errbuf);
469: RETURN;
470: END IF;
471:
472:

Line 473: msd_dem_common_utilities.log_debug ('End validation of inputs parameters - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

469: RETURN;
470: END IF;
471:
472:
473: msd_dem_common_utilities.log_debug ('End validation of inputs parameters - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
474:
475: /* VALIDATION OF INPUT PARAMETERS - END */
476:
477:

Line 480: msd_dem_common_utilities.log_debug ('Begin get dates - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

476:
477:
478: /* Get the start date and end dates for collection */
479:
480: msd_dem_common_utilities.log_debug ('Begin get dates - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
481:
482: IF (p_collection_method = 1) /* Refresh*/
483: THEN
484: x_from_date := to_date('01/01/1000', 'DD/MM/YYYY');

Line 509: msd_dem_common_utilities.log_message ('Error(6): msd_dem_collect_return_history.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

505: IF (x_from_date > x_to_date)
506: THEN
507: retcode := -1;
508: errbuf := 'From Date should not be greater than To Date.';
509: msd_dem_common_utilities.log_message ('Error(6): msd_dem_collect_return_history.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
510: msd_dem_common_utilities.log_message (errbuf);
511: RETURN;
512: END IF;
513:

Line 510: msd_dem_common_utilities.log_message (errbuf);

506: THEN
507: retcode := -1;
508: errbuf := 'From Date should not be greater than To Date.';
509: msd_dem_common_utilities.log_message ('Error(6): msd_dem_collect_return_history.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
510: msd_dem_common_utilities.log_message (errbuf);
511: RETURN;
512: END IF;
513:
514: ELSE /* Rolling */

Line 520: msd_dem_common_utilities.log_message ('Error(7): msd_dem_collect_return_history.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

516: IF (p_collection_window < 0)
517: THEN
518: retcode := -1;
519: errbuf := 'History Collection Window must be a positive number.';
520: msd_dem_common_utilities.log_message ('Error(7): msd_dem_collect_return_history.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
521: msd_dem_common_utilities.log_message (errbuf);
522: RETURN;
523: ELSE
524: x_to_date := trunc(sysdate);

Line 521: msd_dem_common_utilities.log_message (errbuf);

517: THEN
518: retcode := -1;
519: errbuf := 'History Collection Window must be a positive number.';
520: msd_dem_common_utilities.log_message ('Error(7): msd_dem_collect_return_history.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
521: msd_dem_common_utilities.log_message (errbuf);
522: RETURN;
523: ELSE
524: x_to_date := trunc(sysdate);
525: x_from_date := x_to_date - p_collection_window + 1;

Line 530: msd_dem_common_utilities.log_debug ('End get dates - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

526: END IF;
527: END IF;
528: END IF;
529:
530: msd_dem_common_utilities.log_debug ('End get dates - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
531: msd_dem_common_utilities.log_debug ('Begin get instance info - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
532:
533: /* Get the instance info */
534: msd_dem_common_utilities.get_instance_info (

Line 531: msd_dem_common_utilities.log_debug ('Begin get instance info - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

527: END IF;
528: END IF;
529:
530: msd_dem_common_utilities.log_debug ('End get dates - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
531: msd_dem_common_utilities.log_debug ('Begin get instance info - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
532:
533: /* Get the instance info */
534: msd_dem_common_utilities.get_instance_info (
535: x_errbuf1,

Line 534: msd_dem_common_utilities.get_instance_info (

530: msd_dem_common_utilities.log_debug ('End get dates - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
531: msd_dem_common_utilities.log_debug ('Begin get instance info - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
532:
533: /* Get the instance info */
534: msd_dem_common_utilities.get_instance_info (
535: x_errbuf1,
536: x_retcode1,
537: x_instance_code,
538: x_apps_ver,

Line 547: msd_dem_common_utilities.log_message ('Error(8): msd_dem_collect_return_history.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

543: IF (x_retcode1 = '-1')
544: THEN
545: retcode := -1;
546: errbuf := x_errbuf1;
547: msd_dem_common_utilities.log_message ('Error(8): msd_dem_collect_return_history.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
548: msd_dem_common_utilities.log_message ('Unable to get instance info.');
549: RETURN;
550: END IF;
551:

Line 548: msd_dem_common_utilities.log_message ('Unable to get instance info.');

544: THEN
545: retcode := -1;
546: errbuf := x_errbuf1;
547: msd_dem_common_utilities.log_message ('Error(8): msd_dem_collect_return_history.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
548: msd_dem_common_utilities.log_message ('Unable to get instance info.');
549: RETURN;
550: END IF;
551:
552: msd_dem_common_utilities.log_debug ('End get instance info - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

Line 552: msd_dem_common_utilities.log_debug ('End get instance info - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

548: msd_dem_common_utilities.log_message ('Unable to get instance info.');
549: RETURN;
550: END IF;
551:
552: msd_dem_common_utilities.log_debug ('End get instance info - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
553:
554: select instr(p_entity_name,':'),length(p_entity_name) --sopjarora
555: INTO l_position,l_length
556: FROM DUAL;

Line 582: msd_dem_common_utilities.log_message ('Error(9): msd_dem_collect_return_history.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

578: IF (x_dest_table is NULL)
579: THEN
580: retcode := -1;
581: errbuf := 'Unable to find the return history staging tables.';
582: msd_dem_common_utilities.log_message ('Error(9): msd_dem_collect_return_history.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
583: msd_dem_common_utilities.log_message (errbuf);
584: RETURN;
585: END IF;
586:

Line 583: msd_dem_common_utilities.log_message (errbuf);

579: THEN
580: retcode := -1;
581: errbuf := 'Unable to find the return history staging tables.';
582: msd_dem_common_utilities.log_message ('Error(9): msd_dem_collect_return_history.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
583: msd_dem_common_utilities.log_message (errbuf);
584: RETURN;
585: END IF;
586:
587: /* Demantra is Installed */

Line 608: msd_dem_common_utilities.log_message (' Collect History Data - Actions');

604: x_dest_table := v_applsys_schema || '.' || x_dest_table;
605:
606: END IF; --jarora
607:
608: msd_dem_common_utilities.log_message (' Collect History Data - Actions');
609: msd_dem_common_utilities.log_message ('--------------------------------');
610: msd_dem_common_utilities.log_message (' ');
611:
612: msd_dem_common_utilities.log_message ('Date From (DD/MM/RRRR) - ' || to_char(x_from_date, 'DD/MM/RRRR'));

Line 609: msd_dem_common_utilities.log_message ('--------------------------------');

605:
606: END IF; --jarora
607:
608: msd_dem_common_utilities.log_message (' Collect History Data - Actions');
609: msd_dem_common_utilities.log_message ('--------------------------------');
610: msd_dem_common_utilities.log_message (' ');
611:
612: msd_dem_common_utilities.log_message ('Date From (DD/MM/RRRR) - ' || to_char(x_from_date, 'DD/MM/RRRR'));
613: msd_dem_common_utilities.log_message ('Date To (DD/MM/RRRR) - ' || to_char(x_to_date, 'DD/MM/RRRR'));

Line 610: msd_dem_common_utilities.log_message (' ');

606: END IF; --jarora
607:
608: msd_dem_common_utilities.log_message (' Collect History Data - Actions');
609: msd_dem_common_utilities.log_message ('--------------------------------');
610: msd_dem_common_utilities.log_message (' ');
611:
612: msd_dem_common_utilities.log_message ('Date From (DD/MM/RRRR) - ' || to_char(x_from_date, 'DD/MM/RRRR'));
613: msd_dem_common_utilities.log_message ('Date To (DD/MM/RRRR) - ' || to_char(x_to_date, 'DD/MM/RRRR'));
614:

Line 612: msd_dem_common_utilities.log_message ('Date From (DD/MM/RRRR) - ' || to_char(x_from_date, 'DD/MM/RRRR'));

608: msd_dem_common_utilities.log_message (' Collect History Data - Actions');
609: msd_dem_common_utilities.log_message ('--------------------------------');
610: msd_dem_common_utilities.log_message (' ');
611:
612: msd_dem_common_utilities.log_message ('Date From (DD/MM/RRRR) - ' || to_char(x_from_date, 'DD/MM/RRRR'));
613: msd_dem_common_utilities.log_message ('Date To (DD/MM/RRRR) - ' || to_char(x_to_date, 'DD/MM/RRRR'));
614:
615: msd_dem_common_utilities.log_debug ('Begin delete from history staging table - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS')); --jarora
616:

Line 613: msd_dem_common_utilities.log_message ('Date To (DD/MM/RRRR) - ' || to_char(x_to_date, 'DD/MM/RRRR'));

609: msd_dem_common_utilities.log_message ('--------------------------------');
610: msd_dem_common_utilities.log_message (' ');
611:
612: msd_dem_common_utilities.log_message ('Date From (DD/MM/RRRR) - ' || to_char(x_from_date, 'DD/MM/RRRR'));
613: msd_dem_common_utilities.log_message ('Date To (DD/MM/RRRR) - ' || to_char(x_to_date, 'DD/MM/RRRR'));
614:
615: msd_dem_common_utilities.log_debug ('Begin delete from history staging table - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS')); --jarora
616:
617: IF p_truncate = 1 --sopjarora

Line 615: msd_dem_common_utilities.log_debug ('Begin delete from history staging table - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS')); --jarora

611:
612: msd_dem_common_utilities.log_message ('Date From (DD/MM/RRRR) - ' || to_char(x_from_date, 'DD/MM/RRRR'));
613: msd_dem_common_utilities.log_message ('Date To (DD/MM/RRRR) - ' || to_char(x_to_date, 'DD/MM/RRRR'));
614:
615: msd_dem_common_utilities.log_debug ('Begin delete from history staging table - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS')); --jarora
616:
617: IF p_truncate = 1 --sopjarora
618: THEN
619: /* Truncate the history staging table */ --jarora

Line 620: msd_dem_common_utilities.log_message ('Deleting data from history staging table - ' || x_dest_table); --jarora

616:
617: IF p_truncate = 1 --sopjarora
618: THEN
619: /* Truncate the history staging table */ --jarora
620: msd_dem_common_utilities.log_message ('Deleting data from history staging table - ' || x_dest_table); --jarora
621: x_sql := 'DELETE FROM ' || x_dest_table; --amitku
622: EXECUTE IMMEDIATE x_sql;
623: msd_dem_common_utilities.log_debug ('End delete from history staging table - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS')); --jarora
624: END IF;

Line 623: msd_dem_common_utilities.log_debug ('End delete from history staging table - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS')); --jarora

619: /* Truncate the history staging table */ --jarora
620: msd_dem_common_utilities.log_message ('Deleting data from history staging table - ' || x_dest_table); --jarora
621: x_sql := 'DELETE FROM ' || x_dest_table; --amitku
622: EXECUTE IMMEDIATE x_sql;
623: msd_dem_common_utilities.log_debug ('End delete from history staging table - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS')); --jarora
624: END IF;
625:
626:
627: msd_dem_common_utilities.log_debug ('Begin get dm time level - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

Line 627: msd_dem_common_utilities.log_debug ('Begin get dm time level - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

623: msd_dem_common_utilities.log_debug ('End delete from history staging table - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS')); --jarora
624: END IF;
625:
626:
627: msd_dem_common_utilities.log_debug ('Begin get dm time level - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
628:
629: /* Get the lowest time bucket */
630: IF (x_dem_schema IS NOT NULL) /* Demantra is Installed */ --jarora
631: THEN

Line 632: x_dm_time_bucket := msd_dem_common_utilities.dm_time_level;

628:
629: /* Get the lowest time bucket */
630: IF (x_dem_schema IS NOT NULL) /* Demantra is Installed */ --jarora
631: THEN
632: x_dm_time_bucket := msd_dem_common_utilities.dm_time_level;
633: ELSE
634: x_dm_time_bucket := 'DAY';
635: END IF; --jarora
636:

Line 641: msd_dem_common_utilities.log_message ('Error(10): msd_dem_collect_return_history.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

637: IF (x_dm_time_bucket IS NULL)
638: THEN
639: retcode := -1;
640: errbuf := 'Unable to get lowest time bucket';
641: msd_dem_common_utilities.log_message ('Error(10): msd_dem_collect_return_history.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
642: msd_dem_common_utilities.log_message (errbuf);
643: RETURN;
644: ELSIF (upper(x_dm_time_bucket) = 'DAY')
645: THEN

Line 642: msd_dem_common_utilities.log_message (errbuf);

638: THEN
639: retcode := -1;
640: errbuf := 'Unable to get lowest time bucket';
641: msd_dem_common_utilities.log_message ('Error(10): msd_dem_collect_return_history.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
642: msd_dem_common_utilities.log_message (errbuf);
643: RETURN;
644: ELSIF (upper(x_dm_time_bucket) = 'DAY')
645: THEN
646: x_dm_time_level := 1;

Line 651: msd_dem_common_utilities.log_debug ('End get dm time level - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

647: ELSE
648: x_dm_time_level := 2;
649: END IF;
650:
651: msd_dem_common_utilities.log_debug ('End get dm time level - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
652:
653: /* Collect history series */ --jarora
654: msd_dem_common_utilities.log_debug ('Begin collect History - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS')); --jarora
655:

Line 654: msd_dem_common_utilities.log_debug ('Begin collect History - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS')); --jarora

650:
651: msd_dem_common_utilities.log_debug ('End get dm time level - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
652:
653: /* Collect history series */ --jarora
654: msd_dem_common_utilities.log_debug ('Begin collect History - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS')); --jarora
655:
656: IF p_entity_name = 'MSD_DEM_RETURN_HISTORY'
657: THEN
658: x_series_id := MSD_DEM_COMMON_UTILITIES.C_RETURN_HISTORY;

Line 658: x_series_id := MSD_DEM_COMMON_UTILITIES.C_RETURN_HISTORY;

654: msd_dem_common_utilities.log_debug ('Begin collect History - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS')); --jarora
655:
656: IF p_entity_name = 'MSD_DEM_RETURN_HISTORY'
657: THEN
658: x_series_id := MSD_DEM_COMMON_UTILITIES.C_RETURN_HISTORY;
659:
660: ELSIF p_entity_name = 'MSD_DEM_SRP_RETURN_HISTORY'
661: THEN
662: x_series_id := MSD_DEM_COMMON_UTILITIES.C_SRP_RETURN_HISTORY;

Line 662: x_series_id := MSD_DEM_COMMON_UTILITIES.C_SRP_RETURN_HISTORY;

658: x_series_id := MSD_DEM_COMMON_UTILITIES.C_RETURN_HISTORY;
659:
660: ELSIF p_entity_name = 'MSD_DEM_SRP_RETURN_HISTORY'
661: THEN
662: x_series_id := MSD_DEM_COMMON_UTILITIES.C_SRP_RETURN_HISTORY;
663:
664: ELSIF p_entity_name = 'MSD_DEM_DPT_REP_USG_HISTORY'
665: THEN
666: x_series_id := MSD_DEM_COMMON_UTILITIES.C_SRP_USG_HISTORY_DR;

Line 666: x_series_id := MSD_DEM_COMMON_UTILITIES.C_SRP_USG_HISTORY_DR;

662: x_series_id := MSD_DEM_COMMON_UTILITIES.C_SRP_RETURN_HISTORY;
663:
664: ELSIF p_entity_name = 'MSD_DEM_DPT_REP_USG_HISTORY'
665: THEN
666: x_series_id := MSD_DEM_COMMON_UTILITIES.C_SRP_USG_HISTORY_DR;
667:
668: ELSIF p_entity_name = 'MSD_DEM_FLD_SER_USG_HISTORY'
669: THEN
670: x_series_id := MSD_DEM_COMMON_UTILITIES.C_SRP_USG_HISTORY_FS;

Line 670: x_series_id := MSD_DEM_COMMON_UTILITIES.C_SRP_USG_HISTORY_FS;

666: x_series_id := MSD_DEM_COMMON_UTILITIES.C_SRP_USG_HISTORY_DR;
667:
668: ELSIF p_entity_name = 'MSD_DEM_FLD_SER_USG_HISTORY'
669: THEN
670: x_series_id := MSD_DEM_COMMON_UTILITIES.C_SRP_USG_HISTORY_FS;
671:
672: ELSIF p_entity_name = 'MSD_DEM_INS_BASE_HISTORY'
673: THEN
674: x_series_id := MSD_DEM_COMMON_UTILITIES.C_INSTALL_BASE_HISTORY;

Line 674: x_series_id := MSD_DEM_COMMON_UTILITIES.C_INSTALL_BASE_HISTORY;

670: x_series_id := MSD_DEM_COMMON_UTILITIES.C_SRP_USG_HISTORY_FS;
671:
672: ELSIF p_entity_name = 'MSD_DEM_INS_BASE_HISTORY'
673: THEN
674: x_series_id := MSD_DEM_COMMON_UTILITIES.C_INSTALL_BASE_HISTORY;
675:
676: ELSIF p_entity_name = 'BIIO_SCI_BACKLOG:MSD_TOTAL_BACKLOG' --sopjarora
677: THEN
678: x_series_id := MSD_DEM_COMMON_UTILITIES.C_TOTAL_BACKLOG;

Line 678: x_series_id := MSD_DEM_COMMON_UTILITIES.C_TOTAL_BACKLOG;

674: x_series_id := MSD_DEM_COMMON_UTILITIES.C_INSTALL_BASE_HISTORY;
675:
676: ELSIF p_entity_name = 'BIIO_SCI_BACKLOG:MSD_TOTAL_BACKLOG' --sopjarora
677: THEN
678: x_series_id := MSD_DEM_COMMON_UTILITIES.C_TOTAL_BACKLOG;
679:
680: ELSIF p_entity_name = 'BIIO_SCI_BACKLOG:MSD_PAST_DUE_BACKLOG'
681: THEN
682: x_series_id := MSD_DEM_COMMON_UTILITIES.C_PAST_DUE_BACKLOG;

Line 682: x_series_id := MSD_DEM_COMMON_UTILITIES.C_PAST_DUE_BACKLOG;

678: x_series_id := MSD_DEM_COMMON_UTILITIES.C_TOTAL_BACKLOG;
679:
680: ELSIF p_entity_name = 'BIIO_SCI_BACKLOG:MSD_PAST_DUE_BACKLOG'
681: THEN
682: x_series_id := MSD_DEM_COMMON_UTILITIES.C_PAST_DUE_BACKLOG;
683:
684: ELSIF p_entity_name = 'BIIO_SCI:MSD_ON_HAND_INVENTORY'
685: THEN
686: x_series_id := MSD_DEM_COMMON_UTILITIES.C_ON_HAND_INVENTORY;

Line 686: x_series_id := MSD_DEM_COMMON_UTILITIES.C_ON_HAND_INVENTORY;

682: x_series_id := MSD_DEM_COMMON_UTILITIES.C_PAST_DUE_BACKLOG;
683:
684: ELSIF p_entity_name = 'BIIO_SCI:MSD_ON_HAND_INVENTORY'
685: THEN
686: x_series_id := MSD_DEM_COMMON_UTILITIES.C_ON_HAND_INVENTORY;
687:
688: ELSIF p_entity_name = 'BIIO_SCI:MSD_ACTUAL_PRODUCTION'
689: THEN
690: x_series_id := MSD_DEM_COMMON_UTILITIES.C_ACTUAL_PRODUCTION;

Line 690: x_series_id := MSD_DEM_COMMON_UTILITIES.C_ACTUAL_PRODUCTION;

686: x_series_id := MSD_DEM_COMMON_UTILITIES.C_ON_HAND_INVENTORY;
687:
688: ELSIF p_entity_name = 'BIIO_SCI:MSD_ACTUAL_PRODUCTION'
689: THEN
690: x_series_id := MSD_DEM_COMMON_UTILITIES.C_ACTUAL_PRODUCTION;
691:
692: ELSE
693: retcode := -1;
694: msd_dem_common_utilities.log_message ('Error(10.1): MSD_DEM_COLLECT_RETURN_HISTORY.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

Line 694: msd_dem_common_utilities.log_message ('Error(10.1): MSD_DEM_COLLECT_RETURN_HISTORY.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

690: x_series_id := MSD_DEM_COMMON_UTILITIES.C_ACTUAL_PRODUCTION;
691:
692: ELSE
693: retcode := -1;
694: msd_dem_common_utilities.log_message ('Error(10.1): MSD_DEM_COLLECT_RETURN_HISTORY.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
695: msd_dem_common_utilities.log_message ('Error - invalid history series');
696: RETURN;
697:
698: END IF; --jarora

Line 695: msd_dem_common_utilities.log_message ('Error - invalid history series');

691:
692: ELSE
693: retcode := -1;
694: msd_dem_common_utilities.log_message ('Error(10.1): MSD_DEM_COLLECT_RETURN_HISTORY.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
695: msd_dem_common_utilities.log_message ('Error - invalid history series');
696: RETURN;
697:
698: END IF; --jarora
699:

Line 718: msd_dem_common_utilities.log_message ('Error(11): MSD_DEM_COLLECT_RETURN_HISTORY.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

714: IF (x_retcode1 = -1)
715: THEN
716: retcode := -1;
717: errbuf := x_errbuf1;
718: msd_dem_common_utilities.log_message ('Error(11): MSD_DEM_COLLECT_RETURN_HISTORY.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
719: msd_dem_common_utilities.log_message ('Error while collecting History'); --jarora
720: RETURN;
721: END IF;
722:

Line 719: msd_dem_common_utilities.log_message ('Error while collecting History'); --jarora

715: THEN
716: retcode := -1;
717: errbuf := x_errbuf1;
718: msd_dem_common_utilities.log_message ('Error(11): MSD_DEM_COLLECT_RETURN_HISTORY.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
719: msd_dem_common_utilities.log_message ('Error while collecting History'); --jarora
720: RETURN;
721: END IF;
722:
723: msd_dem_common_utilities.log_debug ('End collect History - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS')); --jarora

Line 723: msd_dem_common_utilities.log_debug ('End collect History - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS')); --jarora

719: msd_dem_common_utilities.log_message ('Error while collecting History'); --jarora
720: RETURN;
721: END IF;
722:
723: msd_dem_common_utilities.log_debug ('End collect History - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS')); --jarora
724:
725: COMMIT;
726:
727: msd_dem_common_utilities.log_debug ('Begin Analyze history staging table - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS')); --jarora

Line 727: msd_dem_common_utilities.log_debug ('Begin Analyze history staging table - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS')); --jarora

723: msd_dem_common_utilities.log_debug ('End collect History - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS')); --jarora
724:
725: COMMIT;
726:
727: msd_dem_common_utilities.log_debug ('Begin Analyze history staging table - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS')); --jarora
728:
729: msd_dem_collect_history_data.analyze_table (
730: x_errbuf1,
731: x_retcode1,

Line 734: msd_dem_common_utilities.log_debug ('End Analyze history staging table - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS')); --jarora

730: x_errbuf1,
731: x_retcode1,
732: x_dest_table);
733:
734: msd_dem_common_utilities.log_debug ('End Analyze history staging table - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS')); --jarora
735:
736: IF (x_retcode1 = -1)
737: THEN
738: retcode := -1;

Line 740: msd_dem_common_utilities.log_message ('Error(19): msd_dem_collect_return_history.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

736: IF (x_retcode1 = -1)
737: THEN
738: retcode := -1;
739: errbuf := x_errbuf1;
740: msd_dem_common_utilities.log_message ('Error(19): msd_dem_collect_return_history.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
741: msd_dem_common_utilities.log_message ('Error while analyzing history staging table. '); --jarora
742: RETURN;
743: END IF;
744:

Line 741: msd_dem_common_utilities.log_message ('Error while analyzing history staging table. '); --jarora

737: THEN
738: retcode := -1;
739: errbuf := x_errbuf1;
740: msd_dem_common_utilities.log_message ('Error(19): msd_dem_collect_return_history.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
741: msd_dem_common_utilities.log_message ('Error while analyzing history staging table. '); --jarora
742: RETURN;
743: END IF;
744:
745: retcode := x_retcode;

Line 747: msd_dem_common_utilities.log_debug ('Exiting: msd_dem_collect_return_history.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

743: END IF;
744:
745: retcode := x_retcode;
746: errbuf := x_errbuf;
747: msd_dem_common_utilities.log_debug ('Exiting: msd_dem_collect_return_history.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
748:
749: EXCEPTION
750: WHEN OTHERS THEN
751: retcode := -1 ;

Line 753: msd_dem_common_utilities.log_message ('Exception: msd_dem_collect_return_history.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

749: EXCEPTION
750: WHEN OTHERS THEN
751: retcode := -1 ;
752: errbuf := substr(SQLERRM,1,150);
753: msd_dem_common_utilities.log_message ('Exception: msd_dem_collect_return_history.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
754: msd_dem_common_utilities.log_message (errbuf);
755: RETURN;
756:
757: END COLLECT_RETURN_HISTORY_DATA;

Line 754: msd_dem_common_utilities.log_message (errbuf);

750: WHEN OTHERS THEN
751: retcode := -1 ;
752: errbuf := substr(SQLERRM,1,150);
753: msd_dem_common_utilities.log_message ('Exception: msd_dem_collect_return_history.collect_return_history_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
754: msd_dem_common_utilities.log_message (errbuf);
755: RETURN;
756:
757: END COLLECT_RETURN_HISTORY_DATA;
758: