[Home] [Help]
459: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_PERIOD_START_DATES', MSC_CL_COLLECTION.v_instance_id, NULL);
460:
461: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_CAL_YEAR_START_DATES', MSC_CL_COLLECTION.v_instance_id, NULL);
462:
463: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_CAL_WEEK_START_DATES', MSC_CL_COLLECTION.v_instance_id, NULL);
464:
465: END IF;
466:
467: -- Calendar Dates --
1093: BEGIN
1094:
1095: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
1096:
1097: UPDATE MSC_CAL_WEEK_START_DATES
1098: SET
1099: NEXT_DATE= c_rec.NEXT_DATE,
1100: PRIOR_DATE= c_rec.PRIOR_DATE,
1101: SEQ_NUM= c_rec.SEQ_NUM,
1110: END IF;
1111:
1112: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) OR SQL%NOTFOUND THEN
1113:
1114: INSERT INTO MSC_CAL_WEEK_START_DATES
1115: ( CALENDAR_CODE,
1116: EXCEPTION_SET_ID,
1117: WEEK_START_DATE,
1118: NEXT_DATE,
1153: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
1154: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1155: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1156: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CALENDAR_SET_UP');
1157: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CAL_WEEK_START_DATES');
1158: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1159:
1160: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1161: RAISE;
1165:
1166: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1167: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1168: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_CALENDAR_SET_UP');
1169: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_CAL_WEEK_START_DATES');
1170: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1171:
1172: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1173: FND_MESSAGE.SET_TOKEN('COLUMN', 'EXCEPTION_SET_ID');