[Home] [Help]
347: AND mtil.SR_TP_ID(+)= msca.CARRIER_PARTNER_ID
348: AND mtil.PARTNER_TYPE(+)=4;
349:
350:
351: --If instance type is not 'others', then insert into msc_calendars those calendars present in msc_calendar_dates
352: CURSOR c5 IS
353: SELECT distinct
354: mscd.CALENDAR_CODE,
355: mscd.CALENDAR_START_DATE,
360: WHERE mscd.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
361:
362:
363:
364: --Calculate the first and last working days for each of the calendars in MSC_CALENDARS
365: CURSOR c6 IS
366: SELECT
367: Min(CALENDAR_DATE) FIRST_WORKING_DATE,
368: Max(CALENDAR_DATE) LAST_WORKING_DATE,
670:
671:
672: END IF;
673:
674: --If it is complete or partial or continuous refresh, delete existing calendars in the current instance from MSC_CALENDARS
675:
676:
677: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh OR MSC_CL_COLLECTION.v_is_cont_refresh) THEN
678: MSC_CL_COLLECTION.DELETE_MSC_TABLE('MSC_CALENDARS', MSC_CL_COLLECTION.v_instance_id, NULL);
674: --If it is complete or partial or continuous refresh, delete existing calendars in the current instance from MSC_CALENDARS
675:
676:
677: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh OR MSC_CL_COLLECTION.v_is_cont_refresh) THEN
678: MSC_CL_COLLECTION.DELETE_MSC_TABLE('MSC_CALENDARS', MSC_CL_COLLECTION.v_instance_id, NULL);
679: END IF;
680:
681: FOR c_rec IN c5 LOOP
682:
687: IF MSC_CL_COLLECTION.v_instance_type <> MSC_UTIL.G_INS_OTHER THEN
688:
689: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'cal code='|| c_rec.CALENDAR_CODE);
690:
691: INSERT INTO MSC_CALENDARS
692: ( CALENDAR_CODE,
693: DESCRIPTION,
694: CALENDAR_START_DATE,
695: CALENDAR_END_DATE,
721:
722: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
723: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
724: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CALENDAR_SET_UP');
725: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CALENDARS');
726: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
727: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
728: RAISE;
729:
732:
733: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
734: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
735: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CALENDAR_SET_UP');
736: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CALENDARS');
737: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
738:
739: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
740: FND_MESSAGE.SET_TOKEN('COLUMN', 'CALENDAR_CODE');
749: FOR c_rec IN c6 LOOP
750:
751: BEGIN
752:
753: UPDATE MSC_CALENDARS
754: SET
755: FIRST_WORKING_DATE = c_rec.FIRST_WORKING_DATE,
756: LAST_WORKING_DATE = c_rec.LAST_WORKING_DATE
757: WHERE CALENDAR_CODE = c_rec.CALENDAR_CODE
764:
765: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
766: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
767: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CALENDAR_SET_UP');
768: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CALENDARS');
769: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
770: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
771: RAISE;
772:
775:
776: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
777: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
778: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CALENDAR_SET_UP');
779: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CALENDARS');
780: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
781: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
782: FND_MESSAGE.SET_TOKEN('COLUMN', 'CALENDAR_CODE');
783: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.CALENDAR_CODE);