DBA Data[Home] [Help]

APPS.MSC_E1_APS_PDP dependencies on MSC_ST_PRICE_LIST

Line 612: /* Deleting all rows from MSC_ST_PRICE_LIST Before Loading the Data */

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;

Line 615: DELETE FROM MSC_ST_PRICE_LIST;

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

Line 620: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows Deleted from MSC_ST_PRICE_LIST');

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');

Line 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: