741: RETURN;
742: msd_dem_common_utilities.log_message ('Error in Updating Demantra Item Staging Table for item_type level');
743: END IF;
744:
745: msd_dem_common_utilities.log_debug ('Begin Call Custom Hook msd_dem_custom_hooks.item_hook - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
746:
747: msd_dem_custom_hooks.item_hook (
748: errbuf,
749: retcode);
743: END IF;
744:
745: msd_dem_common_utilities.log_debug ('Begin Call Custom Hook msd_dem_custom_hooks.item_hook - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
746:
747: msd_dem_custom_hooks.item_hook (
748: errbuf,
749: retcode);
750:
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'));
747: msd_dem_custom_hooks.item_hook (
748: errbuf,
749: retcode);
750:
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'));
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:
760: /* Analyze Item Staging Table */
775:
776: ELSIF (p_collect_level_type = 1) /* LOCATION */
777: THEN
778:
779: msd_dem_common_utilities.log_debug ('Begin Call Custom Hook msd_dem_custom_hooks.location_hook - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
780:
781: msd_dem_custom_hooks.location_hook (
782: errbuf,
783: retcode);
777: THEN
778:
779: msd_dem_common_utilities.log_debug ('Begin Call Custom Hook msd_dem_custom_hooks.location_hook - ' || TO_CHAR(systimestamp, 'DD-MON-YYYY HH24:MI:SS'));
780:
781: msd_dem_custom_hooks.location_hook (
782: errbuf,
783: retcode);
784:
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'));
781: msd_dem_custom_hooks.location_hook (
782: errbuf,
783: retcode);
784:
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'));
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:
794: /* Analyze Location Staging Table */