[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,
673:
674:
675: END IF;
676:
677: --If it is complete or partial or continuous refresh, delete existing calendars in the current instance from MSC_CALENDARS
678:
679:
680: 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
681: MSC_CL_COLLECTION.DELETE_MSC_TABLE('MSC_CALENDARS', MSC_CL_COLLECTION.v_instance_id, NULL);
677: --If it is complete or partial or continuous refresh, delete existing calendars in the current instance from MSC_CALENDARS
678:
679:
680: 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
681: MSC_CL_COLLECTION.DELETE_MSC_TABLE('MSC_CALENDARS', MSC_CL_COLLECTION.v_instance_id, NULL);
682: END IF;
683:
684: FOR c_rec IN c5 LOOP
685:
690: IF MSC_CL_COLLECTION.v_instance_type <> MSC_UTIL.G_INS_OTHER THEN
691:
692: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'cal code='|| c_rec.CALENDAR_CODE);
693:
694: INSERT INTO MSC_CALENDARS
695: ( CALENDAR_CODE,
696: DESCRIPTION,
697: CALENDAR_START_DATE,
698: CALENDAR_END_DATE,
724:
725: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
726: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
727: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CALENDAR_SET_UP');
728: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CALENDARS');
729: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
730: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
731: RAISE;
732:
735:
736: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
737: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
738: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CALENDAR_SET_UP');
739: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CALENDARS');
740: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
741:
742: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
743: FND_MESSAGE.SET_TOKEN('COLUMN', 'CALENDAR_CODE');
752: FOR c_rec IN c6 LOOP
753:
754: BEGIN
755:
756: UPDATE MSC_CALENDARS
757: SET
758: FIRST_WORKING_DATE = c_rec.FIRST_WORKING_DATE,
759: LAST_WORKING_DATE = c_rec.LAST_WORKING_DATE
760: WHERE CALENDAR_CODE = c_rec.CALENDAR_CODE
767:
768: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
769: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
770: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CALENDAR_SET_UP');
771: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CALENDARS');
772: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
773: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
774: RAISE;
775:
778:
779: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
780: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
781: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CALENDAR_SET_UP');
782: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CALENDARS');
783: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
784: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
785: FND_MESSAGE.SET_TOKEN('COLUMN', 'CALENDAR_CODE');
786: FND_MESSAGE.SET_TOKEN('VALUE', c_rec.CALENDAR_CODE);