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_LEVEL_TYPES dependencies on MSD_DEM_COLLECT_LEVEL_TYPES

Line 1: PACKAGE BODY MSD_DEM_COLLECT_LEVEL_TYPES AS

1: PACKAGE BODY MSD_DEM_COLLECT_LEVEL_TYPES AS
2: /* $Header: msddemcltb.pls 120.11.12020000.2 2012/09/25 10:22:06 kkhatri ship $ */
3:
4: LOC_TEMPORARY_TABLE VARCHAR2(240) := 'MSD_DEM_LOCATIONS_GTT ';
5: LOC_POPULATE_TEMP_TABLE_VIEW VARCHAR2(240) := 'MSD_DEM_LOCATIONS_GTT_V';

Line 35: msd_dem_common_utilities.log_debug ('Entering: msd_dem_collect_level_types.check_data_model');

31: flag_dm_active NUMBER;
32:
33: BEGIN
34:
35: msd_dem_common_utilities.log_debug ('Entering: msd_dem_collect_level_types.check_data_model');
36:
37: x_sql := ' SELECT NVL(COUNT(1),0) FROM ' || x_dem_schema || '.DM_WIZ_DM_DEF '
38: || ' WHERE DATA_MODEL_TREE_ID = 15'
39: || ' AND IS_ACTIVE = 1' ;

Line 83: msd_dem_common_utilities.log_message ('Exception: msd_dem_collect_level_types.check_data_model');

79: EXCEPTION
80: WHEN OTHERS THEN
81: retcode := 1;
82: errbuf := substr(SQLERRM,1,150);
83: msd_dem_common_utilities.log_message ('Exception: msd_dem_collect_level_types.check_data_model');
84: msd_dem_common_utilities.log_message (errbuf);
85: RETURN 'NEW' ;
86:
87: END check_data_model;

Line 384: msd_dem_common_utilities.log_debug ('Entering: msd_dem_collect_level_types.populate_new_items');

380: x_inv_item_id_tab INV_ITEM_ID_TAB;
381:
382: BEGIN
383:
384: msd_dem_common_utilities.log_debug ('Entering: msd_dem_collect_level_types.populate_new_items');
385:
386:
387: msd_dem_common_utilities.log_message (' Populate New Items ');
388: msd_dem_common_utilities.log_message (' --------------------');

Line 411: msd_dem_common_utilities.log_message ('Warning(1): msd_dem_collect_level_types.populate_new_items');

407: IF ( x_master_org IS NULL)
408: THEN
409: retcode := 1;
410: errbuf := 'Master organization not set.';
411: msd_dem_common_utilities.log_message ('Warning(1): msd_dem_collect_level_types.populate_new_items');
412: msd_dem_common_utilities.log_message (errbuf);
413: RETURN;
414: END IF;
415:

Line 422: msd_dem_common_utilities.log_message ('Warning(2): msd_dem_collect_level_types.populate_new_items');

418: IF (x_retcode = -1)
419: THEN
420: retcode := 1;
421: errbuf := 'Unable to get the query for populating new items into item staging table';
422: msd_dem_common_utilities.log_message ('Warning(2): msd_dem_collect_level_types.populate_new_items');
423: msd_dem_common_utilities.log_message (errbuf);
424: RETURN;
425: END IF;
426:

Line 449: msd_dem_common_utilities.log_debug ('Exiting: msd_dem_collect_level_types.populate_new_items');

445: ELSE
446: msd_dem_common_utilities.log_message ('No new items found for processing');
447: END IF;
448:
449: msd_dem_common_utilities.log_debug ('Exiting: msd_dem_collect_level_types.populate_new_items');
450:
451: retcode := 0;
452:
453: EXCEPTION

Line 457: msd_dem_common_utilities.log_message ('Exception: msd_dem_collect_level_types.populate_new_items');

453: EXCEPTION
454: WHEN OTHERS THEN
455: retcode := 1;
456: errbuf := substr(SQLERRM,1,150);
457: msd_dem_common_utilities.log_message ('Exception: msd_dem_collect_level_types.populate_new_items');
458: msd_dem_common_utilities.log_message (errbuf);
459: RETURN;
460:
461: END POPULATE_NEW_ITEMS;

Line 532: msd_dem_common_utilities.log_debug ('Entering msd_dem_collect_level_types.populate_organization_type...' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

528: var_org_type_desc VARCHAR2(255) DEFAULT NULL;
529:
530: BEGIN
531:
532: msd_dem_common_utilities.log_debug ('Entering msd_dem_collect_level_types.populate_organization_type...' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
533:
534: /* Check if the new columns for Org Type are available in T_SRC_LOC_TMPL */
535: SELECT count(*)
536: INTO var_count

Line 597: msd_dem_common_utilities.log_debug ('Exiting msd_dem_collect_level_types.populate_organization_type...' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

593: || ' org_type_desc = ''' || var_org_type_desc || ''' ';
594:
595: COMMIT;
596:
597: msd_dem_common_utilities.log_debug ('Exiting msd_dem_collect_level_types.populate_organization_type...' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
598:
599: EXCEPTION
600: WHEN OTHERS THEN
601: retcode := -1;

Line 603: msd_dem_common_utilities.log_message ('msd_dem_collect_level_types.populate_organization_type - ERROR ...' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

599: EXCEPTION
600: WHEN OTHERS THEN
601: retcode := -1;
602: errbuf := substr(SQLERRM,1,150);
603: msd_dem_common_utilities.log_message ('msd_dem_collect_level_types.populate_organization_type - ERROR ...' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
604: msd_dem_common_utilities.log_message (errbuf);
605: RETURN;
606:
607: END POPULATE_ORGANIZATION_TYPE;

Line 630: msd_dem_common_utilities.log_debug ('Entering msd_dem_collect_level_types.populate_item_type...' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

626:
627:
628: BEGIN
629:
630: msd_dem_common_utilities.log_debug ('Entering msd_dem_collect_level_types.populate_item_type...' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
631:
632: x_sql := ' select count(nvl(1,0)) from all_tables where table_name = ''T_EP_I_ATT_10'' and owner = ''' || x_dem_schema || '''' ;
633: EXECUTE IMMEDIATE x_sql INTO x_count ;
634:

Line 637: msd_dem_common_utilities.log_debug ('Exiting msd_dem_collect_level_types.populate_item_type...No Action Perfomed...' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

633: EXECUTE IMMEDIATE x_sql INTO x_count ;
634:
635: IF (x_count = 0) THEN
636: msd_dem_common_utilities.log_debug('Warning: T_EP_I_ATT_10 table doesnot exist in demantra schema.' );
637: msd_dem_common_utilities.log_debug ('Exiting msd_dem_collect_level_types.populate_item_type...No Action Perfomed...' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
638: retcode := 1;
639: errbuf := 'T_EP_I_ATT_10 table doesnot exist in demantra schema.';
640: return;
641: END IF ;

Line 656: msd_dem_common_utilities.log_debug ('Exiting msd_dem_collect_level_types.populate_item_type...' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

652: EXECUTE IMMEDIATE x_sql ;
653: COMMIT;
654:
655: msd_dem_common_utilities.log_debug('Update sql for item_type level - ' || x_sql);
656: msd_dem_common_utilities.log_debug ('Exiting msd_dem_collect_level_types.populate_item_type...' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
657:
658: EXCEPTION
659: WHEN OTHERS THEN
660: errbuf := substr(SQLERRM,1,150);

Line 755: msd_dem_common_utilities.log_message ('Error: msd_dem_collect_level_types.collect_levels - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

751: msd_dem_common_utilities.log_debug ('End Call Custom Hook msd_dem_custom_hooks.item_hook - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
752:
753: IF (retcode = -1)
754: THEN
755: msd_dem_common_utilities.log_message ('Error: msd_dem_collect_level_types.collect_levels - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
756: msd_dem_common_utilities.log_message ('Error in call to custom hook msd_dem_custom_hooks.item_hook ');
757: RETURN;
758: END IF;
759:

Line 772: msd_dem_common_utilities.log_message ('Warning: msd_dem_collect_level_types.collect_levels - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

768: msd_dem_common_utilities.log_debug ('End Analyze item staging table - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
769:
770: IF (retcode = 1)
771: THEN
772: msd_dem_common_utilities.log_message ('Warning: msd_dem_collect_level_types.collect_levels - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
773: msd_dem_common_utilities.log_message ('Error while analyzing item staging table. ');
774: END IF;
775:
776: ELSIF (p_collect_level_type = 1) /* LOCATION */

Line 789: msd_dem_common_utilities.log_message ('Error: msd_dem_collect_level_types.collect_levels - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

785: msd_dem_common_utilities.log_debug ('End Call Custom Hook msd_dem_custom_hooks.location_hook - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
786:
787: IF (retcode = -1)
788: THEN
789: msd_dem_common_utilities.log_message ('Error: msd_dem_collect_level_types.collect_levels - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
790: msd_dem_common_utilities.log_message ('Error in call to custom hook msd_dem_custom_hooks.location_hook ');
791: RETURN;
792: END IF;
793:

Line 806: msd_dem_common_utilities.log_message ('Warning: msd_dem_collect_level_types.collect_levels - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));

802: msd_dem_common_utilities.log_debug ('End Analyze location staging table - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
803:
804: IF (retcode = 1)
805: THEN
806: msd_dem_common_utilities.log_message ('Warning: msd_dem_collect_level_types.collect_levels - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
807: msd_dem_common_utilities.log_message ('Error while analyzing location staging table. ');
808: END IF;
809:
810: END IF;

Line 821: END MSD_DEM_COLLECT_LEVEL_TYPES;

817: retcode := -1;
818:
819: end collect_levels;
820:
821: END MSD_DEM_COLLECT_LEVEL_TYPES;