DBA Data[Home] [Help]

APPS.MSC_E1APS_DEMCL dependencies on MSD_DEM_CALENDARS

Line 405: FROM MSD_DEM_CALENDARS;

401:
402: BEGIN
403: /* Step 1: Deleting all rows and extracting data from MSC_CALENDARS */
404: DELETE
405: FROM MSD_DEM_CALENDARS;
406:
407: COMMIT;
408: EXCEPTION
409: WHEN OTHERS THEN

Line 410: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows Deleted from MSD_DEM_CALENDARS');

406:
407: COMMIT;
408: EXCEPTION
409: WHEN OTHERS THEN
410: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows Deleted from MSD_DEM_CALENDARS');
411: RETCODE := MSC_UTIL.G_ERROR;
412: RETURN;
413: END;
414: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Rows Deleted from MSD_DEM_CALENDARS');

Line 414: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Rows Deleted from MSD_DEM_CALENDARS');

410: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows Deleted from MSD_DEM_CALENDARS');
411: RETCODE := MSC_UTIL.G_ERROR;
412: RETURN;
413: END;
414: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Rows Deleted from MSD_DEM_CALENDARS');
415: BEGIN
416: INSERT
417: INTO MSD_DEM_CALENDARS
418: (

Line 417: INTO MSD_DEM_CALENDARS

413: END;
414: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Rows Deleted from MSD_DEM_CALENDARS');
415: BEGIN
416: INSERT
417: INTO MSD_DEM_CALENDARS
418: (
419: INSTANCE ,
420: CALENDAR_TYPE ,
421: CALENDAR_CODE ,

Line 444: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows Inserted into MSD_DEM_CALENDARS from MSC_CALENDARS');

440:
441: COMMIT;
442: EXCEPTION
443: WHEN OTHERS THEN
444: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows Inserted into MSD_DEM_CALENDARS from MSC_CALENDARS');
445: RETCODE := MSC_UTIL.G_ERROR;
446: RETURN;
447: END;
448: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Rows Inserted into MSD_DEM_CALENDARS from MSC_CALENDARS');

Line 448: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Rows Inserted into MSD_DEM_CALENDARS from MSC_CALENDARS');

444: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'No Rows Inserted into MSD_DEM_CALENDARS from MSC_CALENDARS');
445: RETCODE := MSC_UTIL.G_ERROR;
446: RETURN;
447: END;
448: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR,'Rows Inserted into MSD_DEM_CALENDARS from MSC_CALENDARS');
449: /*ODI Initialize*/
450: odi_url := fnd_profile.value('MSC_E1APS_ODIURL');
451: IF odi_url IS NOT NULL THEN
452: BEGIN