404: msd_dem_common_utilities.log_debug(substr(SQLERRM,1,150));
405: retcode := -1;
406: END;
407:
408: /* Deletes the msd_dem_entities_inuse table if the new demantra schema is intstalled
409: * this will ensure that there will be no mapping between the seeded units in APPS and
410: * the (display uints,exchange rate,indexes) in Demantra */
411: PROCEDURE cleanup_entities_inuse(errbuf out nocopy varchar2, retcode out nocopy varchar2)
412: as
409: * this will ensure that there will be no mapping between the seeded units in APPS and
410: * the (display uints,exchange rate,indexes) in Demantra */
411: PROCEDURE cleanup_entities_inuse(errbuf out nocopy varchar2, retcode out nocopy varchar2)
412: as
413: /*Deletes the msd_dem_entities_inuse table */
414: BEGIN
415:
416: delete msd_dem_entities_inuse;
417: commit;
412: as
413: /*Deletes the msd_dem_entities_inuse table */
414: BEGIN
415:
416: delete msd_dem_entities_inuse;
417: commit;
418: EXCEPTION
419: when others then
420: msd_dem_common_utilities.log_message(substr(SQLERRM,1,150));