608: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'ODI Initializion is successful');
609:
610: END IF;
611:
612: /* Deleting all rows from MSC_ST_PRICE_LIST Before Loading the Data */
613: IF parPriceLists = MSC_UTIL.SYS_YES THEN
614: BEGIN
615: DELETE FROM MSC_ST_PRICE_LIST;
616: COMMIT;
611:
612: /* Deleting all rows from MSC_ST_PRICE_LIST Before Loading the Data */
613: IF parPriceLists = MSC_UTIL.SYS_YES THEN
614: BEGIN
615: DELETE FROM MSC_ST_PRICE_LIST;
616: COMMIT;
617:
618: EXCEPTION
619: WHEN OTHERS THEN
616: COMMIT;
617:
618: EXCEPTION
619: WHEN OTHERS THEN
620: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows Deleted from MSC_ST_PRICE_LIST');
621: RETCODE := MSC_UTIL.G_ERROR;
622: RETURN;
623: END;
624: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Rows Deleted from MSC_ST_PRICE_LIST');
620: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows Deleted from MSC_ST_PRICE_LIST');
621: RETCODE := MSC_UTIL.G_ERROR;
622: RETURN;
623: END;
624: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Rows Deleted from MSC_ST_PRICE_LIST');
625: END IF;
626:
627: FlagODILaunch := MSC_E1_APS_ODIEXECUTE (arrScr, WSURL);
628: