[Home] [Help]
4015: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
4016:
4017: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_TRIPS', MSC_CL_COLLECTION.v_instance_id, -1);
4018:
4019: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_TRIP_STOPS', MSC_CL_COLLECTION.v_instance_id, -1);
4020:
4021: END IF; -- MSC_CL_COLLECTION.v_is_complete_refresh
4022:
4023: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
4032: END LOOP;
4033:
4034: FOR c_rec IN c2_d LOOP
4035:
4036: DELETE MSC_TRIP_STOPS
4037: WHERE PLAN_ID= -1
4038: AND STOP_ID= c_rec.STOP_ID
4039: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID;
4040:
4159: BEGIN
4160:
4161: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
4162:
4163: UPDATE MSC_TRIP_STOPS
4164: SET
4165: STOP_LOCATION_ID = c_rec.STOP_LOCATION_ID,
4166: STATUS_CODE = c_rec.STATUS_CODE,
4167: STOP_SEQUENCE_NUMBER = c_rec.STOP_SEQUENCE_NUMBER,
4179: END IF;
4180:
4181: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) OR SQL%NOTFOUND THEN
4182:
4183: INSERT INTO MSC_TRIP_STOPS
4184: ( PLAN_ID,
4185: STOP_ID,
4186: STOP_LOCATION_ID,
4187: STATUS_CODE,
4226:
4227: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4228: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4229: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');
4230: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIP_STOPS');
4231: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4232:
4233: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4234: RAISE;
4238:
4239: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4240: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4241: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');
4242: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIP_STOPS');
4243: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4244:
4245:
4246: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');