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_COLLECT_RETURN_HISTORY

Line 1: PACKAGE BODY MSD_DEM_COLLECT_RETURN_HISTORY AS

1: PACKAGE BODY MSD_DEM_COLLECT_RETURN_HISTORY AS
2: /* $Header: msddemcrhb.pls 120.15.12020000.2 2013/02/28 14:11:31 nallkuma ship $ */
3:
4: /*** PRIVATE PROCEDURES ***/
5:

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

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

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

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

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

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

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

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

297: ELSE
298: NULL;
299: END IF; --jarora
300:
301: msd_dem_common_utilities.log_debug ('Exiting: msd_dem_collect_return_history.collect_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
302:
303: EXCEPTION
304: WHEN OTHERS THEN
305: retcode := -1 ;

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

303: EXCEPTION
304: WHEN OTHERS THEN
305: retcode := -1 ;
306: errbuf := substr(SQLERRM,1,150);
307: msd_dem_common_utilities.log_message ('Exception(3): msd_dem_collect_return_history.collect_data - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
308: msd_dem_common_utilities.log_message (errbuf);
309: RETURN;
310:
311: END COLLECT_DATA;

Line 389: 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'));

385: x_table_present NUMBER := 0;
386:
387: BEGIN
388:
389: 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'));
390:
391: /* Get the db link to the source instance */
392: msd_dem_common_utilities.get_dblink (
393: x_errbuf,

Line 402: 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'));

398: IF (x_retcode = '-1')
399: THEN
400: retcode := -1;
401: errbuf := x_errbuf;
402: 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'));
403: RETURN;
404: END IF;
405:
406: /* Calling procedure to push the profile values, collection enabled orgs and

Line 428: 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'));

424: OR p_collection_window IS NOT NULL))
425: THEN
426: x_retcode := 1;
427: x_errbuf := 'Date Range filters are ignored in ''Refresh'' collections';
428: 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'));
429: msd_dem_common_utilities.log_message (x_errbuf);
430: END IF;
431:
432:

Line 441: 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'));

437: OR p_to_date IS NOT NULL))
438: THEN
439: x_retcode := 1;
440: x_errbuf := 'The ''Date From'' and ''Date To'' fields are ignored if ''Rolling'' date range type is selected.';
441: 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'));
442: msd_dem_common_utilities.log_message (x_errbuf);
443: END IF;
444:
445:

Line 453: 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'));

449: AND p_collection_window IS NOT NULL)
450: THEN
451: x_retcode := 1;
452: x_errbuf := 'The ''History Collection Window'' field is ignored if ''Absolute'' date range type is selected.';
453: 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'));
454: msd_dem_common_utilities.log_message (x_errbuf);
455: END IF;
456:
457:

Line 465: 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'));

461: AND p_collection_window IS NULL)
462: THEN
463: retcode := -1;
464: errbuf := 'The ''History Collection Window'' field cannot be NULL, if ''Rolling'' date range type is selected.';
465: 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'));
466: msd_dem_common_utilities.log_message (errbuf);
467: RETURN;
468: END IF;
469:

Line 479: 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'));

475: OR p_to_date IS NULL))
476: THEN
477: retcode := -1;
478: errbuf := 'The ''Date From'' and ''Date To'' fields cannot be NULL, if ''Absolute'' date range type is selected.';
479: 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'));
480: msd_dem_common_utilities.log_message (errbuf);
481: RETURN;
482: END IF;
483:

Line 521: 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'));

517: IF (x_from_date > x_to_date)
518: THEN
519: retcode := -1;
520: errbuf := 'From Date should not be greater than To Date.';
521: 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'));
522: msd_dem_common_utilities.log_message (errbuf);
523: RETURN;
524: END IF;
525:

Line 532: 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'));

528: IF (p_collection_window < 0)
529: THEN
530: retcode := -1;
531: errbuf := 'History Collection Window must be a positive number.';
532: 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'));
533: msd_dem_common_utilities.log_message (errbuf);
534: RETURN;
535: ELSE
536: x_to_date := trunc(sysdate);

Line 559: 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'));

555: IF (x_retcode1 = '-1')
556: THEN
557: retcode := -1;
558: errbuf := x_errbuf1;
559: 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'));
560: msd_dem_common_utilities.log_message ('Unable to get instance info.');
561: RETURN;
562: END IF;
563:

Line 598: 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'));

594: IF (x_dest_table is NULL)
595: THEN
596: retcode := -1;
597: errbuf := 'Unable to find the return history staging tables.';
598: 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'));
599: msd_dem_common_utilities.log_message (errbuf);
600: RETURN;
601: END IF;
602:

Line 676: 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'));

672: IF (x_dm_time_bucket IS NULL)
673: THEN
674: retcode := -1;
675: errbuf := 'Unable to get lowest time bucket';
676: 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'));
677: msd_dem_common_utilities.log_message (errbuf);
678: RETURN;
679: ELSIF (upper(x_dm_time_bucket) = 'DAY')
680: THEN

Line 729: 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'));

725: x_series_id := MSD_DEM_COMMON_UTILITIES.C_ACTUAL_PRODUCTION;
726:
727: ELSE
728: retcode := -1;
729: 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'));
730: msd_dem_common_utilities.log_message ('Error - invalid history series');
731: RETURN;
732:
733: END IF; --jarora

Line 753: 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'));

749: IF (x_retcode1 = -1)
750: THEN
751: retcode := -1;
752: errbuf := x_errbuf1;
753: 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'));
754: msd_dem_common_utilities.log_message ('Error while collecting History'); --jarora
755: RETURN;
756: END IF;
757:

Line 775: 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'));

771: IF (x_retcode1 = -1)
772: THEN
773: retcode := -1;
774: errbuf := x_errbuf1;
775: 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'));
776: msd_dem_common_utilities.log_message ('Error while analyzing history staging table. '); --jarora
777: RETURN;
778: END IF;
779:

Line 782: 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'));

778: END IF;
779:
780: retcode := x_retcode;
781: errbuf := x_errbuf;
782: 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'));
783:
784: EXCEPTION
785: WHEN OTHERS THEN
786: retcode := -1 ;

Line 788: 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'));

784: EXCEPTION
785: WHEN OTHERS THEN
786: retcode := -1 ;
787: errbuf := substr(SQLERRM,1,150);
788: 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'));
789: msd_dem_common_utilities.log_message (errbuf);
790: RETURN;
791:
792: END COLLECT_RETURN_HISTORY_DATA;

Line 794: END MSD_DEM_COLLECT_RETURN_HISTORY;

790: RETURN;
791:
792: END COLLECT_RETURN_HISTORY_DATA;
793:
794: END MSD_DEM_COLLECT_RETURN_HISTORY;