[Home] [Help]
4153: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
4154:
4155: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_TRIPS', MSC_CL_COLLECTION.v_instance_id, -1);
4156:
4157: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_TRIP_STOPS', MSC_CL_COLLECTION.v_instance_id, -1);
4158:
4159: END IF; -- MSC_CL_COLLECTION.v_is_complete_refresh
4160:
4161: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
4170: END LOOP;
4171:
4172: FOR c_rec IN c2_d LOOP
4173:
4174: DELETE MSC_TRIP_STOPS
4175: WHERE PLAN_ID= -1
4176: AND STOP_ID= c_rec.STOP_ID
4177: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID;
4178:
4297: BEGIN
4298:
4299: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
4300:
4301: UPDATE MSC_TRIP_STOPS
4302: SET
4303: STOP_LOCATION_ID = c_rec.STOP_LOCATION_ID,
4304: STATUS_CODE = c_rec.STATUS_CODE,
4305: STOP_SEQUENCE_NUMBER = c_rec.STOP_SEQUENCE_NUMBER,
4317: END IF;
4318:
4319: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) OR SQL%NOTFOUND THEN
4320:
4321: INSERT INTO MSC_TRIP_STOPS
4322: ( PLAN_ID,
4323: STOP_ID,
4324: STOP_LOCATION_ID,
4325: STATUS_CODE,
4364:
4365: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4366: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4367: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');
4368: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIP_STOPS');
4369: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4370:
4371: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4372: RAISE;
4376:
4377: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4378: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4379: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');
4380: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIP_STOPS');
4381: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4382:
4383:
4384: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');